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;
}
