Click here to Skip to main content
Rate this: bad
good
Please Sign up or sign in to vote.
See more: VB.NET
Hi
I am trying to make a web based complaint logging system.
Whenever user makes a complaint, complaint details will be saved in database.
How can i alert the respective person that u have got complaint?
can anyone help me in it.
Posted 26-Jun-13 21:51pm
raj ch2.8K
Rate this: bad
good
Please Sign up or sign in to vote.

Solution 1

One option would be to use a trigger on your database to send an email to the appropriate person when a record is inserted.
 
Another option would be to have a timer job that periodically checks the table for unsent alerts, gathers them up and sends them (flagging them as having been sent).
 
Yet another option is to update your website so that it sends an email to the appropriate person as needed...
  Permalink  
Rate this: bad
good
Please Sign up or sign in to vote.

Solution 2

Check this link to send a Mail. Call this method from where you wnat the message to be sent. For this to work you need have a SMTP configured on server. You can use your outlook settings to do test during development. Keep this information in config file so that it can be modified by admin / web master as per area of deployment.
 
http://social.msdn.microsoft.com/Forums/en-US/a75533eb-131b-4ff3-a3b2-b6df87c25cc8/how-do-i-send-mail-using-c[^]
  Permalink  
v2
Rate this: bad
good
Please Sign up or sign in to vote.

Solution 3

Optionally, Add new column in database (TrueFalse) "HaveToAlert"...
When Any related complaint found Update PArticular cell to "True"
 
Whenever User Log In Check If "HaveToAlert" cell for his row is True or what? If true then You can Alert particular person.
 
After Alert, Again update it to False.
  Permalink  

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

  Print Answers RSS
0 OriginalGriff 7,903
1 Sergey Alexandrovich Kryukov 7,142
2 DamithSL 5,604
3 Manas Bhardwaj 4,986
4 Maciej Los 4,820


Advertise | Privacy | Mobile
Web04 | 2.8.1411023.1 | Last Updated 28 Jun 2013
Copyright © CodeProject, 1999-2014
All Rights Reserved. Terms of Service
Layout: fixed | fluid

CodeProject, 503-250 Ferrand Drive Toronto Ontario, M3C 3G8 Canada +1 416-849-8900 x 100