protected void Page_Load(object sender, EventArgs e) { _log = new ClsChangeLog("MasterSchedule"); // FIX for hiding calendar when a date is selected Page.ClientScript.RegisterClientScriptBlock(this.GetType(), "hideCalendar", "function hideCalendar(cb) { cb.hide(); }", true); // FIX for css not loading when a calendar is inside of an updatepanel+multiview (+tabcontrol?) string url = Page.ClientScript.GetWebResourceUrl(typeof(ClientCssResourceAttribute), "AjaxControlToolkit.Calendar.Calendar.css"); HtmlLink myHtmlLink = new HtmlLink(); myHtmlLink.Href = url; myHtmlLink.Attributes.Add("rel", "stylesheet"); myHtmlLink.Attributes.Add("type", "text/css"); Page.Header.Controls.Add(myHtmlLink); rowFilter = "Select * From ChangeLog_Report ORDER BY DateSubmitted"; if (!Page.IsPostBack) { DataSet ds = _log.FillDs(); //gvNeedsApproval.DataSource = ds.Tables[0].DefaultView; //lblRecordCount.Text = ds.Tables[0].Rows.Count.ToString(); //gvNeedsApproval.DataBind(); BindLists(ds); CreateFilteredReport(); currentPageNumber = 1; } }
protected void Page_Load(object sender, EventArgs e) { ClsChangeLog log = new ClsChangeLog("MasterSchedule"); log.LogId = int.Parse(Request.QueryString["changelogid"]); DataView view = log.FillDs().Tables[0].DefaultView; view.RowFilter = "LogID = " + Request.QueryString["changelogid"]; this.gvNeedsApproval.DataSource = view; this.gvNeedsApproval.DataBind(); }
private void CreateFilteredReport() { try { ClsDivisionProcessing dp = new ClsDivisionProcessing(); List <string> rowFilters = new List <string>(); if (ddlTermFilter.SelectedValue != "All") { rowFilters.Add("Term = '" + ddlTermFilter.SelectedValue + "' "); } if (ddlCourse.SelectedValue != "All") { rowFilters.Add("CourseNumber LIKE '" + ddlCourse.SelectedValue.Trim() + "%' "); } if (ddlSubmittedByFilter.SelectedValue != "All") { rowFilters.Add("SubmittedBy = '" + ddlSubmittedByFilter.SelectedValue.Trim() + "' "); } if (!string.IsNullOrEmpty(txtFrom.Text)) { DateTime from = DateTime.Parse(txtFrom.Text); rowFilters.Add("DateSubmitted >=#" + from.ToShortDateString() + "#"); } if (!string.IsNullOrEmpty(txtTo.Text)) { DateTime to = DateTime.Parse(txtTo.Text); to = to.AddDays(1); rowFilters.Add("DateSubmitted <= #" + to.ToShortDateString() + "#"); } if (ddlDivision.SelectedValue != "All") { rowFilters.Add(dp.GetDepartments(ddlDivision.SelectedValue)); } StringBuilder sb = new StringBuilder(); string a = ""; foreach (string filter in rowFilters) { sb.Append(a); sb.Append(filter); a = " AND "; } rowFilter = sb.ToString(); DataSet ds = _log.FillDs(); DataTable dt = new DataTable(); dt = ds.Tables[0].Clone(); DataView view = ds.Tables[0].DefaultView; view.RowFilter = rowFilter; DataTable cacheTable = view.ToTable(); int counter = ((currentPageNumber - 1) * PAGE_SIZE); for (int i = counter; i < (PAGE_SIZE + counter); i++) { dt.ImportRow(cacheTable.Rows[i]); if (i == (view.Count - 1)) { break; } } double totalRows = view.Count; lblTotalPages.Text = CalculateTotalPages(totalRows).ToString(); lblCurrentPage.Text = currentPageNumber.ToString(); if (currentPageNumber == 1) { Btn_Previous.Enabled = false; if (Int32.Parse(lblTotalPages.Text) > 1) { Btn_Next.Enabled = true; } else { Btn_Next.Enabled = false; } } else { Btn_Previous.Enabled = true; if (currentPageNumber == Int32.Parse(lblTotalPages.Text)) { Btn_Next.Enabled = false; } else { Btn_Next.Enabled = true; } } lblRecordCount.Text = view.Count.ToString(); gvNeedsApproval.DataSource = dt; gvNeedsApproval.DataBind(); } catch (Exception ex) { gvNeedsApproval.DataSource = null; gvNeedsApproval.DataBind(); } }