protected void gvEmailSchedule_PageIndexChanging(object sender, GridViewPageEventArgs e)
{
EmailScheduleSearch scheduleSearch = PopulateSearchEntity();
EmailScheduleDAL newDal = new EmailScheduleDAL();
IList <EmailScheduleResult> schedules = newDal.SearchEmailSchedule(scheduleSearch);
gvEmailSchedule.PageIndex = e.NewPageIndex;
gvEmailSchedule.DataSource = schedules;
gvEmailSchedule.DataBind();
int _pageStart = ((e.NewPageIndex + 1) * PageSize) - PageSize + 1;
int _pageEnd = ((e.NewPageIndex + 1) * PageSize);
if (_pageEnd > schedules.Count)
{
_pageEnd = schedules.Count;
}
if (schedules.Count > PageSize)
{
lblResult.Text = string.Format("Showing result(s) {0}-{1} of {2}", _pageStart.ToString(), _pageEnd.ToString(), schedules.Count.ToString());
}
else if (schedules.Count > 0)
{
lblResult.Text = string.Format("Showing result(s) 1-{0} of {1}", _pageEnd.ToString(), schedules.Count.ToString());
}
else
{
lblResult.Text = string.Empty;
}
}
protected void lbExport_Click(object sender, EventArgs e)
{
EmailScheduleSearch scheduleSearch = PopulateSearchEntity();
EmailScheduleDAL newDal = new EmailScheduleDAL();
DataTable dataTable = newDal.SearchEmailScheduleTable(scheduleSearch);
string FileName = string.Format("EmailSchedule{0}.csv", System.DateTime.Now.ToFileTime().ToString());
Export newExport = new Export("Web");
int[] ColList = { 1, 2, 3, 4, 5, 12, 14, 17, 18, 19, 20, 21, 22 };
newExport.ExportDetails(dataTable, ColList, Export.ExportFormat.CSV, FileName, string.Empty);
}
protected void btnShowReport_Click(object sender, EventArgs e)
{
EmailScheduleSearch scheduleSearch = PopulateSearchEntity();
EmailScheduleDAL newDal = new EmailScheduleDAL();
IList <EmailScheduleResult> schedules = newDal.SearchEmailSchedule(scheduleSearch);
gvEmailSchedule.PageIndex = 0;
gvEmailSchedule.DataSource = schedules;
gvEmailSchedule.DataBind();
if (schedules.Count > PageSize)
{
lblResult.Text = string.Format("Showing result(s) 1-{0} of {1}", PageSize, schedules.Count.ToString());
}
else if (schedules.Count > 0)
{
lblResult.Text = string.Format("Showing result(s) 1-{0} of {0}", schedules.Count.ToString());
}
else
{
lblResult.Text = string.Empty;
}
}
protected void ddlPageSize_SelectedIndexChanged(object sender, EventArgs e)
{
PageSize = Convert.ToInt32(ddlPageSize.SelectedValue);
EmailScheduleSearch scheduleSearch = PopulateSearchEntity();
EmailScheduleDAL newDal = new EmailScheduleDAL();
IList <EmailScheduleResult> schedules = newDal.SearchEmailSchedule(scheduleSearch);
gvEmailSchedule.PageIndex = 0;
gvEmailSchedule.DataSource = schedules;
gvEmailSchedule.DataBind();
if (schedules.Count > PageSize)
{
lblResult.Text = string.Format("Showing result(s) 1-{0} of {1}", PageSize, schedules.Count.ToString());
}
else if (schedules.Count > 0)
{
lblResult.Text = string.Format("Showing result(s) 1-{0} of {0}", schedules.Count.ToString());
}
else
{
lblResult.Text = string.Empty;
}
}
private EmailScheduleSearch PopulateSearchEntity()
{
EmailScheduleSearch newSchedule = new EmailScheduleSearch();
newSchedule.FirstName = txtSearchFName.Text.Trim();
newSchedule.LastName = txtSearchLName.Text.Trim();
newSchedule.Email = txtSearchEmail.Text.Trim();
if (!string.IsNullOrEmpty(txtSearchRegID.Text.Trim()))
{
int regId = -1;
int.TryParse(txtSearchRegID.Text.Trim(), out regId);
newSchedule.RegID = regId;
}
newSchedule.ZipCode = txtSearchZip.Text.Trim();
newSchedule.BdayStartDate = Convert.ToDateTime(ddlSearchBdayStartMonth.SelectedValue + "/" + ddlSearchBdayStartDay.SelectedValue + "/2000");
newSchedule.BdayEndDate = Convert.ToDateTime(ddlSearchBdayEndMonth.SelectedValue + "/" + ddlSearchBdayEndDay.SelectedValue + "/2000");
if (ddlSearchActive.SelectedValue.Equals("1"))
{
newSchedule.Active = true;
}
else if (ddlSearchActive.SelectedValue.Equals("0"))
{
newSchedule.Active = false;
}
else
{
newSchedule.Active = null;
}
if (!string.IsNullOrEmpty(ddlSearchCompany.SelectedValue))
{
int companyId = -1;
int.TryParse(ddlSearchCompany.SelectedValue, out companyId);
newSchedule.CompanyID = companyId;
}
if (!string.IsNullOrEmpty(ddlSearchTemplate.SelectedValue))
{
int templateId = -1;
int.TryParse(ddlSearchTemplate.SelectedValue, out templateId);
newSchedule.TemplateID = templateId;
}
if (!string.IsNullOrEmpty(txtSearchBatchID.Text.Trim()))
{
int emailBatchID = -1;
int.TryParse(txtSearchBatchID.Text.Trim(), out emailBatchID);
newSchedule.EmailContentID = emailBatchID;
}
int status = -1;
int.TryParse(ddlSeachStatus.SelectedValue, out status);
newSchedule.Status = status;
if (string.IsNullOrEmpty(txtSearchRequestStart.Text.Trim()))
{
newSchedule.RequestSearchStart = Convert.ToDateTime("1/1/1900");
}
else
{
newSchedule.RequestSearchStart = Convert.ToDateTime(txtSearchRequestStart.Text.Trim());
}
if (string.IsNullOrEmpty(txtSearchRequestEnd.Text.Trim()))
{
newSchedule.RequestSearchEnd = Convert.ToDateTime("1/1/2099");
}
else
{
newSchedule.RequestSearchEnd = Convert.ToDateTime(txtSearchRequestEnd.Text.Trim());
newSchedule.RequestSearchEnd = newSchedule.RequestSearchEnd.AddDays(1);
}
if (string.IsNullOrEmpty(txtSearchScheduleStart.Text.Trim()))
{
newSchedule.ScheduleSearchStart = Convert.ToDateTime("1/1/1900");
}
else
{
newSchedule.ScheduleSearchStart = Convert.ToDateTime(txtSearchScheduleStart.Text.Trim());
}
if (string.IsNullOrEmpty(txtSearchScheduleEnd.Text.Trim()))
{
newSchedule.ScheduleSearchEnd = Convert.ToDateTime("1/1/2099");
}
else
{
newSchedule.ScheduleSearchEnd = Convert.ToDateTime(txtSearchScheduleEnd.Text.Trim());
newSchedule.ScheduleSearchEnd = newSchedule.ScheduleSearchEnd.AddDays(1);
}
if (string.IsNullOrEmpty(txtSearchSentStart.Text.Trim()))
{
newSchedule.SendSearchStart = Convert.ToDateTime("1/1/1900");
}
else
{
newSchedule.SendSearchStart = Convert.ToDateTime(txtSearchSentStart.Text.Trim());
}
if (string.IsNullOrEmpty(txtSearchSentEnd.Text.Trim()))
{
newSchedule.SendSearchEnd = Convert.ToDateTime("1/1/2099");
}
else
{
newSchedule.SendSearchEnd = Convert.ToDateTime(txtSearchSentEnd.Text.Trim());
newSchedule.SendSearchEnd = newSchedule.SendSearchEnd.AddDays(1);
}
if (string.IsNullOrEmpty(txtSearchOpenedStart.Text.Trim()))
{
newSchedule.OpenSearchStart = Convert.ToDateTime("1/1/1900");
}
else
{
newSchedule.OpenSearchStart = Convert.ToDateTime(txtSearchOpenedStart.Text.Trim());
}
if (string.IsNullOrEmpty(txtSearchOpenedEnd.Text.Trim()))
{
newSchedule.OpenSearchEnd = Convert.ToDateTime("1/1/2099");
}
else
{
newSchedule.OpenSearchEnd = Convert.ToDateTime(txtSearchOpenedEnd.Text.Trim());
newSchedule.OpenSearchEnd = newSchedule.OpenSearchEnd.AddDays(1);
}
return(newSchedule);
}
