Databases
StackOverflow2013
Postsdbo
PO
 

Note that there are some explanatory texts on larger screens.

plurals
  1. PO
    primarykey
    data
    text
    <p>i think there a solution:</p> <p>1- you have to add 2 column in the user table in your sql db if you have a user table and in the first column add the date of the last email sent to the user and the second column has the period for sending the email for that user for ex: LastEmailSentDate datetime SendEmailPeriod int</p> <p>2- in your application code write a function that compare the last date of the last sent email with the period of the sending the email.</p> <p>// here the funciton code</p> <pre><code>public void CompareLastSentDate() { // lets assume that you bring the data for the db using Sqdatareader reader //get the field from the LastEmailSentDate field in the database as i mention before DateTime LastEmailSentDate = Convert.ToDate(reader["DatePeriod"]) // get the field from the SendEmailPeriod of the user field from database int sendEmailPeriod = Convert.Toint32(reader["SendEmailPeriod"]) // now you have the date before the period of day ex: before 3 days depend on user DateTime DatePeriod = new DateTime(DateTime.Now.Year, DateTime.Now.Month, (DateTime.Now.Day - sendEmailPeriod )); // if the last email send is before period of day that mean u have to send an email again if(LastEmailSentDate.Day &lt;= DatePeriod.Day) { // sent the email to the user } } </code></pre> <p>note: now u can loop among the users and sent the email</p> <p>you can call this function once in a day by calling it from ur app home page Page_Load event and after the first call of the day add an application["LastFunctionCallDate"] = DateTime.Now flag so in the next you can check this flag if its == today and if not call it again</p>
    singulars
    1. This table or related slice is empty.
    1. POSending Periodic Mail according to user's Setting in ASP.net?
      singulars
      1. PTQuestion
    1. PTAnswer
    1. USHiyasat
    1. USHiyasat
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. VO
      singulars
      1. PO
      1. This table or related slice is empty.
      1. VTUpMod
    2. VO
      singulars
      1. PO
      1. This table or related slice is empty.
      1. VTUpMod
    1. CObut we should call CompareLastSentDate() function periodically. you know this just send mail for users(if I loop your suggested method among users) once and what about the next period?? in fact this function should call every day and check whether send mail or not today. but thank your answer.
      singulars
      1. PO
      1. USmahdiahmadirad
    2. COcheck my answer now i think u will find solution to this too
      singulars
      1. PO
      1. USHiyasat
 

Querying!

 
Guidance
A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload