How to keep track or database modifications and inform to user accordingly

Posted by RohiK under ASP.NET on 11/23/2011 | Points: 10 | Views : 1262 | Status : [Member] | Replies : 13
Hi

I want to do the mailing system type task. as the mail received automatically user will show message as mail received .
how to do that?

Happy Programming!!
Rohi



Responses

Posted by: Nitesh.luharuka on: 11/23/2011 [Member] Starter | Points: 25

Up
0
Down
Explain your question more..where will you check if mail has been received or not..or do you want to update your DB after email has been sent ot all users present in DB?

Nitesh Luharuka
http://www.niteshluharuka.com

RohiK, if this helps please login to Mark As Answer. | Alert Moderator

Posted by: RohiK on: 11/24/2011 [Member] Starter | Points: 25

Up
0
Down
Hi,

I have a table mail details. as user send mail to another user , how that user will know immidietly that mail is recived. check mail

Happy Programming!!
Rohi

RohiK, if this helps please login to Mark As Answer. | Alert Moderator

Posted by: Nitesh.luharuka on: 11/24/2011 [Member] Starter | Points: 25

Up
0
Down
You can make a new table that stores userID, total emails & read emails..Everytime a user sends an email, increase the total email count by 1. And when the receiver user logs in, check if total email > read email, show message..You have total-read unread emails. When user reads one of them, increase count of read email by 1.

Nitesh Luharuka
http://www.niteshluharuka.com

RohiK, if this helps please login to Mark As Answer. | Alert Moderator

Posted by: RohiK on: 11/24/2011 [Member] Starter | Points: 25

Up
0
Down
hi,

no no, user is always login.
I just want outlook effect.as the mail receives user will know by small popup showing right bottom side.
just like that.
only i dont understand when to check?

everytime..?

Happy Programming!!
Rohi

RohiK, if this helps please login to Mark As Answer. | Alert Moderator

Posted by: Nitesh.luharuka on: 11/24/2011 [Member] Starter | Points: 25

Up
0
Down
For this, you will need to implement timer that will check say after every 5 mins and return no. of new emails to user.

Nitesh Luharuka
http://www.niteshluharuka.com

RohiK, if this helps please login to Mark As Answer. | Alert Moderator

Posted by: RohiK on: 11/25/2011 [Member] Starter | Points: 25

Up
0
Down
Ya,

but it might increase load to existing one....
is any other solution exists??

Happy Programming!!
Rohi

RohiK, if this helps please login to Mark As Answer. | Alert Moderator

Posted by: Nitesh.luharuka on: 11/25/2011 [Member] Starter | Points: 25

Up
0
Down
Calling an AJAX should not increase load..call ajax with user ID to a different page..check no. of new emails in separate page and return the number..

Nitesh Luharuka
http://www.niteshluharuka.com

RohiK, if this helps please login to Mark As Answer. | Alert Moderator

Posted by: RohiK on: 11/25/2011 [Member] Starter | Points: 25

Up
0
Down


i am thinking about service..?

Happy Programming!!
Rohi

RohiK, if this helps please login to Mark As Answer. | Alert Moderator

Posted by: Nitesh.luharuka on: 11/25/2011 [Member] Starter | Points: 25

Up
0
Down
WCF? You'll need to call a service or you want the service will broadcast to all logged in users?

Nitesh Luharuka
http://www.niteshluharuka.com

RohiK, if this helps please login to Mark As Answer. | Alert Moderator

Posted by: RohiK on: 11/25/2011 [Member] Starter | Points: 25

Up
0
Down
No. service means system service which i write in vb


Happy Programming!!
Rohi

RohiK, if this helps please login to Mark As Answer. | Alert Moderator

Posted by: Nitesh.luharuka on: 11/25/2011 [Member] Starter | Points: 25

Up
0
Down
Is it a Desktop application and if the answer is yes, you will need to run services on everyone's computer. That will be heavy. Instead I will prefer Timer..

Nitesh Luharuka
http://www.niteshluharuka.com

RohiK, if this helps please login to Mark As Answer. | Alert Moderator

Posted by: RohiK on: 11/29/2011 [Member] Starter | Points: 25

Up
0
Down
Hey hi,

If i could insert it on server and from there I handle my job then???

Happy Programming!!
Rohi

RohiK, if this helps please login to Mark As Answer. | Alert Moderator

Posted by: Nitesh.luharuka on: 11/29/2011 [Member] Starter | Points: 25

Up
0
Down
You will need to call service from each Desktop application based on some Timer job else, you will need to broadcast data from server..

Nitesh Luharuka
http://www.niteshluharuka.com

RohiK, if this helps please login to Mark As Answer. | Alert Moderator

Login to post response