示例#1
0
    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();
        }
    }
示例#2
0
    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);
        }
    }