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