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