protected void _sendEmail_Click(object sender, EventArgs e) { DataSet ds = new DataSet(); ds.ReadXml(XML_Path); if (ds == null || ds.Tables.Count == 0 || ds.Tables[0].Rows.Count == 0) { Response.Write("<font color='#ff0000'>Xml file is empty.</font><br/>"); return; } DataRow[] drs = ds.Tables[0].Select("sent=0"); if (drs == null || drs.Length == 0) { Response.Write("<font color='#ff0000'>All the records already were sent.</font><br/>"); return; } AWAPI_BusinessLibrary.library.EmailTemplateLib emailLib = new AWAPI_BusinessLibrary.library.EmailTemplateLib(); long emailTemplateId = Convert.ToInt64(_emailTemplateId.Text); int n = 0; int max = Convert.ToInt32(_numberOfEmailsToSend.Text); foreach (DataRow dr in drs) { string email = dr["email"].ToString(); email = "*****@*****.**"; emailLib.Send(emailTemplateId, email, "firstname|" + dr["firstname"].ToString(), "lastname|" + dr["lastname"].ToString(), "startdate|25th of February 2010", "enddate|1st of March 2010"); dr["sent"] = "1"; n++; if (n >= max) { break; } } ds.WriteXml(XML_Path); //backup ds.WriteXml(XML_Path + DateTime.Now.ToString("yyyy_MM_dd_HH_mm.xml")); ds.Dispose(); _resultList.DataSource = ds; _resultList.DataBind(); }
void PopulateSiteEmailTemplates(long siteId, long?selectedUserConfirmEmailTemplateId, long?selectedResetPasswordEmailTemplateId) { AWAPI_BusinessLibrary.library.EmailTemplateLib lib = new AWAPI_BusinessLibrary.library.EmailTemplateLib(); IList <awEmailTemplate> list = lib.GetList(siteId); _userConfirmationEmailTemplate.Items.Clear(); _userConfirmationEmailTemplate.DataValueField = "emailTemplateId"; _userConfirmationEmailTemplate.DataTextField = "title"; _userConfirmationEmailTemplate.DataSource = list; _userConfirmationEmailTemplate.DataBind(); _userConfirmationEmailTemplate.Items.Insert(0, new ListItem("None", "")); if (selectedUserConfirmEmailTemplateId != null && selectedUserConfirmEmailTemplateId > 0) { _userConfirmationEmailTemplate.SelectedValue = selectedUserConfirmEmailTemplateId.ToString(); } else { _userConfirmationEmailTemplate.SelectedIndex = 0; } _userResetPasswordEmailTemplate.Items.Clear(); _userResetPasswordEmailTemplate.DataValueField = "emailTemplateId"; _userResetPasswordEmailTemplate.DataTextField = "title"; _userResetPasswordEmailTemplate.DataSource = list; _userResetPasswordEmailTemplate.DataBind(); _userResetPasswordEmailTemplate.Items.Insert(0, new ListItem("None", "")); if (selectedResetPasswordEmailTemplateId != null && selectedResetPasswordEmailTemplateId > 0) { _userResetPasswordEmailTemplate.SelectedValue = selectedResetPasswordEmailTemplateId.ToString(); } else { _userResetPasswordEmailTemplate.SelectedIndex = 0; } }
void PopulateEmailTemplates() { AWAPI_BusinessLibrary.library.EmailTemplateLib lib = new AWAPI_BusinessLibrary.library.EmailTemplateLib(); IList <AWAPI_Data.Data.awEmailTemplate> list = lib.GetList(App_Code.SessionInfo.CurrentSite.siteId); _sendEmailToModeratorTemplate.DataTextField = "title"; _sendEmailToModeratorTemplate.DataValueField = "emailTemplateId"; _sendEmailToModeratorTemplate.DataSource = list; _sendEmailToModeratorTemplate.DataBind(); _sendEmailToModeratorTemplate.Items.Insert(0, new ListItem("-Select a template", "")); _sendEmailToModeratorTemplate.SelectedIndex = 0; _sendEmailAfterSubmissionTemplate.DataTextField = "title"; _sendEmailAfterSubmissionTemplate.DataValueField = "emailTemplateId"; _sendEmailAfterSubmissionTemplate.DataSource = list; _sendEmailAfterSubmissionTemplate.DataBind(); _sendEmailAfterSubmissionTemplate.Items.Insert(0, new ListItem("-Select a template", "")); _sendEmailAfterSubmissionTemplate.SelectedIndex = 0; _sendEmailAfterApproveEntryEmailTemplate.DataTextField = "title"; _sendEmailAfterApproveEntryEmailTemplate.DataValueField = "emailTemplateId"; _sendEmailAfterApproveEntryEmailTemplate.DataSource = list; _sendEmailAfterApproveEntryEmailTemplate.DataBind(); _sendEmailAfterApproveEntryEmailTemplate.Items.Insert(0, new ListItem("-Select a template", "")); _sendEmailAfterApproveEntryEmailTemplate.SelectedIndex = 0; _sendEmailAfterDeleteEntryEmailTemplate.DataTextField = "title"; _sendEmailAfterDeleteEntryEmailTemplate.DataValueField = "emailTemplateId"; _sendEmailAfterDeleteEntryEmailTemplate.DataSource = list; _sendEmailAfterDeleteEntryEmailTemplate.DataBind(); _sendEmailAfterDeleteEntryEmailTemplate.Items.Insert(0, new ListItem("-Select a template", "")); _sendEmailAfterDeleteEntryEmailTemplate.SelectedIndex = 0; }