protected void GridView_Sorting(object sender, GridViewSortEventArgs e) { // dont allow sorting if in edit mode if (GrdLetterPrintHistory.EditIndex >= 0) { return; } DataTable dataTable = Session["letterbestprinthistory_data"] as DataTable; if (dataTable != null) { if (Session["letterbestprinthistory_sortexpression"] == null) { Session["letterbestprinthistory_sortexpression"] = ""; } DataView dataView = new DataView(dataTable); string[] sortData = Session["letterbestprinthistory_sortexpression"].ToString().Trim().Split(' '); string newSortExpr = (e.SortExpression == sortData[0] && sortData[1] == "ASC") ? "DESC" : "ASC"; dataView.Sort = e.SortExpression + " " + newSortExpr; Session["letterbestprinthistory_sortexpression"] = e.SortExpression + " " + newSortExpr; GrdLetterPrintHistory.DataSource = dataView; GrdLetterPrintHistory.DataBind(); } }
protected void FillGrid() { int patient_id = IsValidFormPatient() ? GetFormPatient(false) : -1; if (patient_id != -1) { Patient patient = PatientDB.GetByID(patient_id); Page.Title = lblHeading.Text = "B.E.S.T. Letter Print History For "; lnkToEntity.Text = patient.Person.FullnameWithoutMiddlename; lnkToEntity.NavigateUrl = "PatientDetailV2.aspx?type=view&id=" + patient.PatientID; } DataTable dt = LetterBestPrintHistoryDB.GetDataTable(patient_id); Session["letterbestprinthistory_data"] = dt; if (dt.Rows.Count > 0) { if (IsPostBack && Session["letterbestprinthistory_sortexpression"] != null && Session["letterbestprinthistory_sortexpression"].ToString().Length > 0) { DataView dataView = new DataView(dt); dataView.Sort = Session["letterbestprinthistory_sortexpression"].ToString(); GrdLetterPrintHistory.DataSource = dataView; } else { GrdLetterPrintHistory.DataSource = dt; } try { GrdLetterPrintHistory.DataBind(); } catch (Exception ex) { HideTableAndSetErrorMessage("", ex.ToString()); } } else { dt.Rows.Add(dt.NewRow()); GrdLetterPrintHistory.DataSource = dt; GrdLetterPrintHistory.DataBind(); int TotalColumns = GrdLetterPrintHistory.Rows[0].Cells.Count; GrdLetterPrintHistory.Rows[0].Cells.Clear(); GrdLetterPrintHistory.Rows[0].Cells.Add(new TableCell()); GrdLetterPrintHistory.Rows[0].Cells[0].ColumnSpan = TotalColumns; GrdLetterPrintHistory.Rows[0].Cells[0].Text = "No Record Found"; } }
protected void FillGrid() { int org_id = IsValidFormOrganisation() ? GetFormOrganisation(false) : 0; int patient_id = IsValidFormPatient() ? GetFormPatient(false) : -1; int register_referrer_id = IsValidFormRegReferrer() ? GetFormRegReferrer(false) : -1; if (patient_id != -1) { Patient patient = PatientDB.GetByID(patient_id); lblHeading.Text = "Letter Print History For "; lnkToEntity.Text = patient.Person.FullnameWithoutMiddlename; lnkToEntity.NavigateUrl = "PatientDetailV2.aspx?type=view&id=" + patient.PatientID; } else if (org_id != 0) { Organisation org = OrganisationDB.GetByID(org_id); lblHeading.Text = "Letter Print History For "; lnkToEntity.Text = org.Name; lnkToEntity.NavigateUrl = "OrganisationDetailV2.aspx?type=view&id=" + org.OrganisationID; } DataTable dt = LetterPrintHistoryDB.GetDataTable(DateTime.MinValue, DateTime.MinValue, org_id, patient_id, register_referrer_id, Convert.ToInt32(Session["SiteID"])); Session["letterprinthistory_data"] = dt; if (dt.Rows.Count > 0) { if (IsPostBack && Session["letterprinthistory_sortexpression"] != null && Session["letterprinthistory_sortexpression"].ToString().Length > 0) { DataView dataView = new DataView(dt); dataView.Sort = Session["letterprinthistory_sortexpression"].ToString(); GrdLetterPrintHistory.DataSource = dataView; } else { GrdLetterPrintHistory.DataSource = dt; } try { GrdLetterPrintHistory.DataBind(); GrdLetterPrintHistory.PagerSettings.FirstPageText = "1"; GrdLetterPrintHistory.PagerSettings.LastPageText = GrdLetterPrintHistory.PageCount.ToString(); GrdLetterPrintHistory.DataBind(); } catch (Exception ex) { SetErrorMessage("", ex.ToString()); } } else { dt.Rows.Add(dt.NewRow()); GrdLetterPrintHistory.DataSource = dt; GrdLetterPrintHistory.DataBind(); int TotalColumns = GrdLetterPrintHistory.Rows[0].Cells.Count; GrdLetterPrintHistory.Rows[0].Cells.Clear(); GrdLetterPrintHistory.Rows[0].Cells.Add(new TableCell()); GrdLetterPrintHistory.Rows[0].Cells[0].ColumnSpan = TotalColumns; GrdLetterPrintHistory.Rows[0].Cells[0].Text = "No Record Found"; } }