Click here to Skip to main content
15,919,500 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
See more:
hi all,

i have been developing one website application using ASP.NET with c#.

the thing is i would be need to develop AUTO TOPUP which means the repeat payment.

i have 4 douts in my application ,

step 1. the customer having some amount in to their account .

for example they have 500 rupees on 30/04/2013 in to their account.

step 2. After some certain dates left , the same customer amount has zero balance.

for example on 5/05/2013 customer account have zero balance.

step 3. at this time customer need to subscribe auto top up option which is followed by the website.

step 4. my question is how do i increment customer account balance from zero to some 50,100. or whatever it is.

and this step will do frequently once customer met zero balance in their account,

so this is my problem, so please consider this thoughts as i mentioned above and give me a drop of solution or else give a corresponding link which is related to AUTO TOP UP or else give me an idea how do i create AUTO TOPUP .

please let me know if have any idea or solution.

advices are appreciable....
Posted
Comments
[no name] 30-Apr-13 9:32am    
where are you stuck ?
Thanks7872 1-May-13 0:43am    
what do you mean by this line step 3. at this time customer need to subscribe auto top up option which is followed by the website.

If you are using SQL Server and you want to update balance as soon as balance becomes 0 then create job.
 
Share this answer
 
(With Sql server DB)You can perform this operation with the use of triggers.A trigger is a special kind of a store procedure that executes in response to certain action on the table like insertion, deletion or updation of data.So in your case when customers balance becomes zero you can use trigger to be fired.For more on triggers have a look at Triggers in SQL
 
Share this answer
 
v2

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900