protected void SortReferrerAdditionalEmails(string sortExpression, params string[] sortExpr) { DataTable dataTable = ViewState["referreradditionalemail_data"] as DataTable; if (dataTable != null) { if (ViewState["referreradditionalemail_sortexpression"] == null) { ViewState["referreradditionalemail_sortexpression"] = ""; } DataView dataView = new DataView(dataTable); string[] sortData = ViewState["referreradditionalemail_sortexpression"].ToString().Trim().Split(' '); string newSortExpr = (sortExpr.Length == 0) ? (sortExpression == sortData[0] && sortData[1] == "ASC") ? "DESC" : "ASC" : sortExpr[0]; dataView.Sort = sortExpression + " " + newSortExpr; ViewState["referreradditionalemail_sortexpression"] = sortExpression + " " + newSortExpr; GrdReferrerAdditionalEmails.DataSource = dataView; GrdReferrerAdditionalEmails.DataBind(); } }
protected void FillGrdReferrerAdditionalEmails() { try { GrdReferrerAdditionalEmails.Visible = true; Patient patient = PatientDB.GetByID(GetFormPTID()); lblHeading.Text = "Referrer Additional Emails For " + patient.Person.FullnameWithoutMiddlename; DataTable dt = ReferrerAdditionalEmailDB.GetDataTable_ByPatient(patient.PatientID, false); dt.DefaultView.Sort = "rae_name ASC"; dt = dt.DefaultView.ToTable(); ViewState["referreradditionalemail_data"] = dt; if (dt.Rows.Count > 0) { if (IsPostBack && ViewState["referreradditionalemail_sortexpression"] != null && ViewState["referreradditionalemail_sortexpression"].ToString().Length > 0) { DataView dataView = new DataView(dt); dataView.Sort = ViewState["referreradditionalemail_sortexpression"].ToString(); GrdReferrerAdditionalEmails.DataSource = dataView; } else { GrdReferrerAdditionalEmails.DataSource = dt; } GrdReferrerAdditionalEmails.DataBind(); } else { dt.Rows.Add(dt.NewRow()); GrdReferrerAdditionalEmails.DataSource = dt; GrdReferrerAdditionalEmails.DataBind(); int TotalColumns = GrdReferrerAdditionalEmails.Rows[0].Cells.Count; GrdReferrerAdditionalEmails.Rows[0].Cells.Clear(); GrdReferrerAdditionalEmails.Rows[0].Cells.Add(new TableCell()); GrdReferrerAdditionalEmails.Rows[0].Cells[0].ColumnSpan = TotalColumns; GrdReferrerAdditionalEmails.Rows[0].Cells[0].Text = "No Additional Emails Added Yet"; } } catch (CustomMessageException ex) { SetErrorMessage(ex.ToString()); } catch (Exception ex) { SetErrorMessage("", Utilities.IsDev() ? ex.ToString() : ex.Message); } }