ASP.NET

10-Feb-07 4:05

Visual Studio Professional 2005 - C# 2.0, ASP .Net

How do you go about sending reminder notices? I've got an application that the client wants to have a reminder for different tasks go out on various intervals.

Right now it's in an access.mdb file. If a user registers and completes a form we want to remind them that in X more days they need to complete another form. I know how to send the email and all that. What I don't understand is what mechanism you use to track time on a per row basis. Meaning row 136 was entered on February 12th, 7 days later something (what would be a good something) sees that and sends a reminder.

Suggestions? Ideas?

Jon Sagara10-Feb-07 4:17

Jon Sagara

10-Feb-07 4:17

Ideally, you would write a Windows service to sit in the background and regularly check to see if any notifications need to be sent out.

If it were SQL Server, you could set up a Job to run at regular intervals.

However, if you're absolutely stuck, and out of options, and if the Web site receives a fair amount of evenly dispersed (time-wise) traffic, you can rely on the usage patterns to check for pending notifications. Not a great solution, and if traffic ever falls off, your notifications won't get sent out when they need to be.

I suppose you could also expose a public Web service, and then have an external app "ping" that Web service to tell the server to check for and send notifications.

Jon Sagara
Kittens give Morbo gas.
-- Morbo

Blog | Site | Articles

code-frog10-Feb-07 7:09

10-Feb-07 7:09

Yeah, I was just going to write an .exe and run it at scheduled intervals using the Task Scheduling service. But those are all great ideas. If it is SQL Server (which it might be in production) do you have a link to more information?

Jon Sagara10-Feb-07 20:13

Jon Sagara

10-Feb-07 20:13

I don't have a good one off hand, but look up SQL Server Jobs.

Sorry I didn't respond sooner. I was at a "lamaze" class all day (they don't call it that nowadays), then had dinner with the in-laws.

Jon Sagara
Kittens give Morbo gas.
-- Morbo

Blog | Site | Articles

Strange problem in sending file attachment

Bassam Saoud10-Feb-07 7:46

Bassam Saoud

10-Feb-07 7:46

I had a similar requirement once, designed it with a windows service periodically checking a table for new records (SQL Server 2000)and sending Emails. But if you are using SQL Server 2005, you may be interested in looking at Notification Services[^] a built in feature.

NetBot10-Feb-07 2:48

NetBot

10-Feb-07 2:48

Hi all,
I am getting a strange problem when i try to attach a file with a mail message.

Here`s the code..

MailMessage msg=new MailMessage();
msg.To=emailaddr;
msg.From=Fromemp;
msg.Subject="Hello " ;
string attachedFile = UploadCV_File.PostedFile.FileName;
MailAttachment ma=new MailAttachment(attachedFile);
msg.Attachments.Add(ma);
SmtpMail.SmtpServer="localhost";
SmtpMail.Send(msg);

The problem is that it gives an error when i select a file path which is long ie C:\Documents and Settings\Administrator\Desktop\New.txt and doesn`t gives an error if the path is short ie C:\New.txt.

What`s the problem????Help!!! Thanks in advance

code-frog10-Feb-07 7:12

10-Feb-07 7:12

The spaces are what's killing you. Try replacing the spaces with the ascii equivalent.

www.Developerof.NET10-Feb-07 15:45

www.Developerof.NET

10-Feb-07 15:45

Sorry!!!, but replacing spaces with ascii code also doesn`t work .Here is what i did...

MailMessage msg=new MailMessage();
string filename=File1.PostedFile.FileName;
filename.Replace(" "," ");
attachment=new MailAttachment(filename);
msg.To=To_usr.Text;
msg.From=From_usr.Text;
msg.Body=TextBody.Text;
msg.Attachments.Add(attachment);
SmtpMail.SmtpServer = "127.0.0.1";
SmtpMail.SmtpServer.Insert(0,"127.0.0.1");
SmtpMail.Send(msg);

Is this approach right?? What should i do now?

code-frog10-Feb-07 17:10

10-Feb-07 17:10

Well, if it's working then it's right. If not...

Try doing a Response.Write(File1.PostedFile.Filename);

See what it's actually getting. Response.Write should output it to the very top of your web page. You can also use System.Diagnostics and then do a Debug.Write(File1.PostedFile.FileName);

NetBot10-Feb-07 18:37

NetBot

10-Feb-07 18:37

Well i did Response.write but it still shows spaces and hence gives invalid attachment error.I can`t use the alternative of copying the file on server and then attaching it to the mail message.

code-frog10-Feb-07 18:45

10-Feb-07 18:45

Have you given appropriate permissions to ASP to do this? You need to give IIS IUSR and IIS IWPD the correct permissions so they can write files to the server.

Oops, never mind. I was thinking we were uploading to the server...

Have you let someone else test your site from another PC to see if the have the problem?

NetBot10-Feb-07 20:20

NetBot

10-Feb-07 20:20

The app is still under construction and hasn`t been uploaded on a server.It`s still on my PC.