protected void btnShowReport_Click(object sender, EventArgs e)
{
EmailContentDAL newContentDal = new EmailContentDAL();
UserSelection newSelection = new UserSelection();
EmailContent emailContent = newContentDal.GetEmailContentByID(BatchID, out newSelection);
if (newSelection != null)
{
PopulateSelectionCriterion(newSelection);
}
if (emailContent != null)
{
PopulateEmailContent(emailContent);
}
EmailDeliveryDAL newDal = new EmailDeliveryDAL();
IList <EmailDelivery> emails = newDal.GetSendEmail(BatchID);
gvEmailSend.PageIndex = 0;
gvEmailSend.DataSource = emails;
gvEmailSend.DataBind();
if (emails.Count > 10)
{
lblResult.Text = string.Format("Showing result(s) 1-10 of {0}", emails.Count.ToString());
}
else if (emails.Count > 0)
{
lblResult.Text = string.Format("Showing result(s) 1-{0} of {0}", emails.Count.ToString());
}
else
{
lblResult.Text = string.Empty;
}
}
protected void gvEmailSend_Sorting(object sender, GridViewSortEventArgs e)
{
EmailDeliveryDAL newDal = new EmailDeliveryDAL();
IList <EmailDelivery> emails = newDal.GetSendEmail(BatchID);
DataTable dataTable = Utilities.ConvertToDataTable(emails);
if (dataTable != null)
{
DataView dataView = new DataView(dataTable);
if (ViewState["SortExpression"] != null && ViewState["SortDirection"] != null)
{
if (ViewState["SortExpression"].ToString().Equals(e.SortExpression) && ViewState["SortDirection"].ToString().Equals(e.SortDirection.ToString()))
{
if (e.SortDirection == SortDirection.Ascending)
{
e.SortDirection = SortDirection.Descending;
}
else
{
e.SortDirection = SortDirection.Ascending;
}
}
}
dataView.Sort = e.SortExpression + " " + ConvertSortDirectionToSql(e.SortDirection);
ViewState["SortExpression"] = e.SortExpression;
ViewState["SortDirection"] = e.SortDirection;
ViewState["SortString"] = dataView.Sort;
gvEmailSend.DataSource = dataView;
gvEmailSend.PageIndex = 0;
gvEmailSend.DataBind();
}
int _pageStart = 1;
int _pageEnd = 10;
if (_pageEnd > emails.Count)
{
_pageEnd = emails.Count;
}
if (emails.Count > 10)
{
lblResult.Text = string.Format("Showing result(s) {0}-{1} of {2}", _pageStart.ToString(), _pageEnd.ToString(), emails.Count.ToString());
}
else if (emails.Count > 0)
{
lblResult.Text = string.Format("Showing result(s) 1-{0} of {1}", _pageEnd.ToString(), emails.Count.ToString());
}
else
{
lblResult.Text = string.Empty;
}
}
protected void Page_Load(object sender, EventArgs e)
{
int _emailID = 0;
if (Request.QueryString["emailid"] != null)
{
int.TryParse(Request.QueryString["emailid"].ToString(), out _emailID);
}
EmailDeliveryDAL newDal = new EmailDeliveryDAL();
newDal.UpdateOpenStatus(_emailID, System.DateTime.Now);
Response.Redirect("../Email/images/blank.PNG");
}
protected string SendMail(Entity.User newUser, int emailContentID)
{
EmailDelivery emaildelivery = populateEmailDelivery(newUser, emailContentID);
EmailDeliveryDAL emailDeliveryDAL = new EmailDeliveryDAL();
emailDeliveryDAL.SaveEmailDelivery(emaildelivery);
DateTime originalSchedule = emaildelivery.ScheduleTime;
if (chkReschedule1.Checked == true)
{
emaildelivery.ScheduleTime = RescheduleTime(ddlReschedule1.SelectedValue, originalSchedule);
emailDeliveryDAL.SaveEmailDelivery(emaildelivery);
}
if (chkReschedule2.Checked == true)
{
emaildelivery.ScheduleTime = RescheduleTime(ddlReschedule2.SelectedValue, originalSchedule);
emailDeliveryDAL.SaveEmailDelivery(emaildelivery);
}
if (chkReschedule3.Checked == true)
{
emaildelivery.ScheduleTime = RescheduleTime(ddlReschedule3.SelectedValue, originalSchedule);
emailDeliveryDAL.SaveEmailDelivery(emaildelivery);
}
if (chkReschedule4.Checked == true)
{
emaildelivery.ScheduleTime = RescheduleTime(ddlReschedule4.SelectedValue, originalSchedule);
emailDeliveryDAL.SaveEmailDelivery(emaildelivery);
}
if (chkReschedule5.Checked == true)
{
emaildelivery.ScheduleTime = RescheduleTime(ddlReschedule5.SelectedValue, originalSchedule);
emailDeliveryDAL.SaveEmailDelivery(emaildelivery);
}
if (chkReschedule6.Checked == true)
{
emaildelivery.ScheduleTime = RescheduleTime(ddlReschedule6.SelectedValue, originalSchedule);
emailDeliveryDAL.SaveEmailDelivery(emaildelivery);
}
//string emailBodyText = Utilities.ReplaceTokens(HTMLEditor1.Text, newUser);
//emailBodyText = ReplaceImageSource(emailBodyText);
//string emailSubject = Utilities.ReplaceTokens(txtEmailSubject.Text, newUser);
//string message = MailHelper.SendMailMessage(txtFromEmail.Text, txtReplytoEmail.Text, newUser.Email, string.Empty, string.Empty, emailSubject, emailBodyText, MailPriority.Normal);
//return message;
return(string.Empty);
}
protected void Page_Load(object sender, EventArgs e)
{
lblCancelAll.Text = string.Empty;
if (!IsPostBack)
{
EmailContentDAL newContentDal = new EmailContentDAL();
IList <UserSelection> newSelection = new List <UserSelection>();
IList <EmailContent> emailContents = newContentDal.GetEmailContents(out newSelection);
int limit = 0;
foreach (EmailContent content in emailContents)
{
ListItem item = new ListItem();
item.Text = content.EmailContentID.ToString();
item.Value = content.EmailContentID.ToString();
ddlBatchID.Items.Add(item);
limit++;
//if (limit > 49) break;
}
ddlBatchID.SelectedIndex = 0;
if (newSelection != null && newSelection.Count > 0)
{
PopulateSelectionCriterion(newSelection[0]);
}
if (emailContents != null && emailContents.Count > 0)
{
PopulateEmailContent(emailContents[0]);
}
EmailDeliveryDAL newDal = new EmailDeliveryDAL();
IList <EmailDelivery> emails = newDal.GetSendEmail(BatchID);
gvEmailSend.DataSource = emails;
gvEmailSend.DataBind();
if (emails.Count > 10)
{
lblResult.Text = string.Format("Showing result(s) 1-10 of {0}", emails.Count.ToString());
}
else if (emails.Count > 0)
{
lblResult.Text = string.Format("Showing result(s) 1-{0} of {0}", emails.Count.ToString());
}
else
{
lblResult.Text = string.Empty;
}
}
}
protected void lbCancelAll_Click(object sender, EventArgs e)
{
EmailDeliveryDAL newDal = new EmailDeliveryDAL();
int status = newDal.CancelLatestEmailDeliveryAll(BatchID);
IList <EmailDelivery> emails = newDal.GetSendEmail(BatchID);
DataTable dataTable = Utilities.ConvertToDataTable(emails);
if (dataTable != null)
{
DataView dataView = new DataView(dataTable);
if (ViewState["SortString"] != null)
{
dataView.Sort = ViewState["SortString"].ToString();
}
gvEmailSend.DataSource = dataView;
gvEmailSend.DataBind();
}
lblCancelAll.Text = string.Format("{0} items are in Cancel Status", status.ToString());
}
private void CancelEmail(string ID)
{
int emailID = int.Parse(ID);
EmailDeliveryDAL newDal = new EmailDeliveryDAL();
int status = newDal.CancelEmailDelivery(emailID);
IList <EmailDelivery> emails = newDal.GetSendEmail(BatchID);
DataTable dataTable = Utilities.ConvertToDataTable(emails);
if (dataTable != null)
{
DataView dataView = new DataView(dataTable);
if (ViewState["SortString"] != null)
{
dataView.Sort = ViewState["SortString"].ToString();
}
gvEmailSend.DataSource = dataView;
gvEmailSend.DataBind();
}
}
protected void gvEmailSend_PageIndexChanging(object sender, GridViewPageEventArgs e)
{
EmailDeliveryDAL newDal = new EmailDeliveryDAL();
IList <EmailDelivery> emails = newDal.GetSendEmail(BatchID);
DataTable dataTable = Utilities.ConvertToDataTable(emails);
if (dataTable != null)
{
DataView dataView = new DataView(dataTable);
if (ViewState["SortString"] != null)
{
dataView.Sort = ViewState["SortString"].ToString();
}
gvEmailSend.DataSource = dataView;
gvEmailSend.PageIndex = e.NewPageIndex;
gvEmailSend.DataBind();
}
int _pageStart = ((e.NewPageIndex + 1) * 10) - 9;
int _pageEnd = ((e.NewPageIndex + 1) * 10);
if (_pageEnd > emails.Count)
{
_pageEnd = emails.Count;
}
if (emails.Count > 10)
{
lblResult.Text = string.Format("Showing result(s) {0}-{1} of {2}", _pageStart.ToString(), _pageEnd.ToString(), emails.Count.ToString());
}
else if (emails.Count > 0)
{
lblResult.Text = string.Format("Showing result(s) 1-{0} of {1}", _pageEnd.ToString(), emails.Count.ToString());
}
else
{
lblResult.Text = string.Empty;
}
}
