Hello frdz,

I want to create the autorefill reminder service page which reminds me to do the things of that month on the first day of month.
It should be continued every month.

I have searched on net but not able to find only able to get the information of the reminder software download.

If anyone can help me to code to set time for reminder alert on every month then it will be grateful.

Atleast suggest me some points on how to perform how the timer can be set in ASP.NET 2005 with C#.
It is the web-application not a window application.

My application is based on the intranet.
I have already created the table with the to-do services and datetime in sqlserver 2005.

What i want is to remind me for the customer service who are regular to give a call n then deliver them service as of medicines or it gives reminder if the stock gets empty in the store.

I don't know how to do with the C#.
In VB it was done thru timer and that to in windows application.So,pls suggest me.

Pls help me....
Pls provide me some sample source code or example regardin my question to know how it can be done.
Any answer or help which can guide me is appreciated..

Hi sheenaa,

I suggest you do not try to implement it by ASP.NET. It’s not a good solution. Please use Windows application or Windows Service instead.

Well, ASP.NET can implement your requirement becase:

• ASP.NET can read the data from SQL Server by using ADO.NET.
• ASP.NET can reminder user by an alert.
• ASP.NET can automatically postback every some time by using client script or AJAX timer control.

However, the problem is we must remain the web browser process visiting the website all the time. In addition, the web browser automatically postback every some time. This is wasting resources on both Client and Web Server side.

first sorry i dont have ready code, however what i could think of is whenever a user logs into application in that login validation process itself if credentials are proper perform next step which is, you check current date may be i would write something like following in sp

//do login checking, if correct credentials do following

if datepart(dd,getdate()) = 1

begin

      //fetch all the to do list and return in dataset or any source of your choice

end

then in login page itself in login event you check if there's data returned in the dataset accordingly redirect to To Do list page.

hope its not too complicate.

thanks,

satish.

Benson Yu - MSFT....

thanxs for ur reply with suggestion.

But,i have to create it with ASP.NET C# only.

What about the web-service in ASP.NET webapplication.Can i use that ??

Ur suggestion is almost correct but then to i have to ask u this pls reply soon 

 satish_nagdev

thanxs for ur reply.

I don't get much idea how could it be done with the suggestion as u said.

Could u be more somewhat specific in ur explanation again...I don't get about the stored procedure in login page..

If possible then pls reply again 

Hi Sheena,

first i would like to know what authentication are you using in your application?

what i meant was on assumption that you've some log in page, so in loggin page you probably would check for user's credentials.

i would place my logic just after checking if the user is valid or not. and what i meant by stored procedure is i will write my entire credentials checking and fetching of to-do list for particular user at one go.

i'll be able to tell more proper way once i know what exactly you are doing? i mean authentication method etc.

thanks,

satish.

 Hi,

       I have two types of the users:

administrator = 1 and normal user = 2.

       The reminder alert is to be given to all the normal users of the store.It is based on intranet and in ASP.NET with C#.

        The reminder can be given to user for the completion of the stock and to give the purchase order.

        The reminder can also be set for the expiring items in the stock and so on...

Thanxss..... 

hi,

I understand your problem, as i also have same work in a web project. where i need to send reminder emails for some purpose.
The solution posted by satish_nagdev is not applicable. what if nobody hit your application for a month due to some reason. as a result no execution of code.

The One solution is use SQL Jobs.

sql server provides such a nice way to schedule jobs.

First create a new job in sql server. set the timing that after how many time to execute that job. no matter if some one hit's your application or not. this job will execute.Second and the important thing is where to place code.
there are lot of options provided by sql jobs. you can write a window service (in Dotnet or vb6 etc) means executable file place it any where on server. and give the path of this file to the sql job you created. this exe file will contain the code to check the database and do the required functionality if some specific criteria matches. the sql job will execute on each duration (you have set for it) and will execute that exe file. you can also write script directly while creating sql job rather to create and executable file.

The other solution to your problem is Caching. Dotnet provide lot of facilities with caching to do these kind of tasks

hope this will help you. if this is still confusing for you. feel free to contact me. rizwan.javed@yahoo.com

All the best

Regards

Muhammad Rizwan Javed

Software Engineer,Lahore Pakistan 

Hi Sheena 

sheenaa:

How to set time for reminder alert on every month in ASP.NET with C#

i was bit confused over the subject you mentioned as your question i.e. i thought once every month.

ok now i've one more thought in mind which sounds easy to me but dont know if you get it or not. it goes as follows

1. Create Views in database like one for products where stock is completing infact you can set a range of stock like

create view stkView as Select ProductID, ProductName, QtyInHand from ProductMaster where QtyHand = 0 //just for example

similarly a view for expiring items.

step 2> in your webpage place a usercontrol containing a grid for 0 qty items and/or expiring items or just a list containing simple text like

Reminders

1.>There are items for which you need to order or have 0 qty left

2.>There are items in stock whose expiry date is crossed etc.

so in this user control you can check data in the view in database.

the problem here which i could think is refreshing of this user control i.e. timely reading of data from views for which what i could think of using is Caching and Cache invalidation feature.

hope i'm not going too complicated way.

regards,

satish.

hi seema,

i m also getting same problem with my application.if u got solvation pls send sample code.

thanks in advance.

hi seena, i m also getting same problem with my application.if u have solution pls send the sample code. 

hi

you use database triggers or stired procedures to do the job.

first create a section on your page and invoke the procedure only when you first time log in the day not always when the page is loaded and also when the administrator is logged in.

make a list of all the tasks and display all of them.and also you can perform any other tasks . you can also use the services that are present in the asp.net.

m also facing same problem, if u get solution do mail me

It's me Faisal talked with you on messenger. This thread i got your email address plz send me the suggested solution. I shall be very thankful to you.

Faisal

 Hey Faisal.

you have multiple solutions for that. here is details about these  http://forums.asp.net/t/1257150.aspx.

now let me know which solution you want. i will guide you accordingly.