XGIS
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.
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.
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?
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
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
wonderfull
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.