Link to home
Start Free TrialLog in
Avatar of XGIS
XGISFlag for Australia

asked on

Auto subscription renewal

Hello Experts,

i am currently commissioned to build a subscription management system and I am not sure how to manage subscription renewals, notification and auto payment any assistance in detail will be appreciated.
Avatar of Todd Gerbert
Todd Gerbert
Flag of United States of America image

That's a fairly broad question on a somewhat involved task, and "assistance in detail" for such a question is probably beyond the scope of a forum such as this. ;)

But, to offer less detail and more of an overview...

Subscriptions will need to be stored in a database.  A simple Windows service, or scheduled task, to query the database daily WHERE Expires < TODAY() AND AutoRenew = True.  Then process the payment, and if successful update the database with the new subscription details; the System.Net.Mail classes can provide you the means to notify the customer.
Avatar of XGIS

ASKER

hello tqerbert:

Thanks for your response, I understand that data is stored in a database I have got the sql 2008 schema in place, I was uncertain as to when the subscription expires how does the payment take place, and how is the email sent?? is the email sent via SQL or does a scheduled task run the classes in the website?? and how does the payment take place automatically until the client unsubscribes?
ASKER CERTIFIED SOLUTION
Avatar of Todd Gerbert
Todd Gerbert
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of XGIS

ASKER

wonderfull