protected void GridView_Sorting(object sender, GridViewSortEventArgs e)
    {
        // dont allow sorting if in edit mode
        if (GrdStaff.EditIndex >= 0)
        {
            return;
        }

        DataTable dataTable = Session["externalstaffinfo_data"] as DataTable;

        if (dataTable != null)
        {
            if (Session["externalstaffinfo_sortexpression"] == null)
            {
                Session["externalstaffinfo_sortexpression"] = "";
            }

            DataView dataView    = new DataView(dataTable);
            string[] sortData    = Session["externalstaffinfo_sortexpression"].ToString().Trim().Split(' ');
            string   newSortExpr = (e.SortExpression == sortData[0] && sortData[1] == "ASC") ? "DESC" : "ASC";
            dataView.Sort = e.SortExpression + " " + newSortExpr;
            Session["externalstaffinfo_sortexpression"] = e.SortExpression + " " + newSortExpr;

            GrdStaff.DataSource = dataView;
            GrdStaff.DataBind();
        }
    }
Ejemplo n.º 2
0
        //Bind Staff Grid Data
        #region [Bind Staff Grid Data]

        private void BindStaffGridData()
        {
            try
            {
                EWA_Common objEWA = new EWA_Common();
                BL_Common  objBL  = new BL_Common();

                objEWA.OrgId    = Convert.ToString(Session["OrgId"]);
                objEWA.CourseId = ddlCourse.SelectedValue;
                //objEWA.DesignationId = ddlDesignation.SelectedItem.ToString();
                // objEWA.DepartmentId = ddlDepartment.SelectedItem.ToString();
                DataSet ds = objBL.BindStaffList_BL(objEWA);

                if (ds.Tables[0].Rows.Count > 0)
                {
                    GrdStaff.DataSource = ds;
                    GrdStaff.DataBind();
                    btnDownload.Visible = true;
                }
                else
                {
                    GrdStaff.DataSource = null;
                    GrdStaff.DataBind();
                    btnDownload.Visible = false;
                }
            }
            catch (Exception exp)
            {
                GeneralErr(exp.Message.ToString());
            }
        }
    protected void FillGrid()
    {
        string searchSurname = "";

        if (Request.QueryString["surname_search"] != null && Request.QueryString["surname_search"].Length > 0)
        {
            searchSurname         = Request.QueryString["surname_search"];
            txtSearchSurname.Text = Request.QueryString["surname_search"];
        }
        bool searchSurnameOnlyStartsWith = true;

        if (Request.QueryString["surname_starts_with"] != null && Request.QueryString["surname_starts_with"].Length > 0)
        {
            searchSurnameOnlyStartsWith           = Request.QueryString["surname_starts_with"] == "0" ? false : true;
            chkSurnameSearchOnlyStartWith.Checked = searchSurnameOnlyStartsWith;
        }
        else
        {
            chkSurnameSearchOnlyStartWith.Checked = searchSurnameOnlyStartsWith;
        }



        DataTable dt = StaffDB.GetDataTable_StaffInfo(Convert.ToBoolean(Session["IsStakeholder"]), chkShowFired.Checked, true, true, searchSurname, searchSurnameOnlyStartsWith);

        // remove "Call Center" staff member
        for (int i = dt.Rows.Count - 1; i >= 0; i--)
        {
            if (((int)dt.Rows[i]["staff_id"]) == -5)
            {
                dt.Rows.RemoveAt(i);
            }
        }

        dt.DefaultView.Sort = "firstname, surname, middlename";
        dt = dt.DefaultView.ToTable();
        Session["externalstaffinfo_data"] = dt;


        this.GrdStaff.AllowPaging = false;

        /*
         * if (!IsPostBack)
         *  chkUsePaging.Checked = dt.Rows.Count > 50;
         * this.GrdStaff.AllowPaging = chkUsePaging.Checked;
         */

        if (dt.Rows.Count > 0)
        {
            if (IsPostBack && Session["externalstaffinfo_sortexpression"] != null && Session["externalstaffinfo_sortexpression"].ToString().Length > 0)
            {
                DataView dataView = new DataView(dt);
                dataView.Sort       = Session["externalstaffinfo_sortexpression"].ToString();
                GrdStaff.DataSource = dataView;
            }
            else
            {
                GrdStaff.DataSource = dt;
            }

            try
            {
                GrdStaff.DataBind();
                GrdStaff.PagerSettings.FirstPageText = "1";
                GrdStaff.PagerSettings.LastPageText  = GrdStaff.PageCount.ToString();
                GrdStaff.DataBind();
            }
            catch (Exception ex)
            {
                HideTableAndSetErrorMessage("", ex.ToString());
            }
        }
        else
        {
            dt.Rows.Add(dt.NewRow());
            GrdStaff.DataSource = dt;
            GrdStaff.DataBind();

            int TotalColumns = GrdStaff.Rows[0].Cells.Count;
            GrdStaff.Rows[0].Cells.Clear();
            GrdStaff.Rows[0].Cells.Add(new TableCell());
            GrdStaff.Rows[0].Cells[0].ColumnSpan = TotalColumns;
            GrdStaff.Rows[0].Cells[0].Text       = "No Record Found";
        }
    }
Ejemplo n.º 4
0
    protected void FillGrid()
    {
        lblNbrProviders.Text = StaffDB.GetCountOfProviders().ToString();

        string searchSurname = "";

        if (Request.QueryString["surname_search"] != null && Request.QueryString["surname_search"].Length > 0)
        {
            searchSurname         = Request.QueryString["surname_search"];
            txtSearchSurname.Text = Request.QueryString["surname_search"];
        }
        bool searchSurnameOnlyStartsWith = true;

        if (Request.QueryString["surname_starts_with"] != null && Request.QueryString["surname_starts_with"].Length > 0)
        {
            searchSurnameOnlyStartsWith           = Request.QueryString["surname_starts_with"] == "0" ? false : true;
            chkSurnameSearchOnlyStartWith.Checked = searchSurnameOnlyStartsWith;
        }
        else
        {
            chkSurnameSearchOnlyStartWith.Checked = searchSurnameOnlyStartsWith;
        }



        DataTable dt = StaffDB.GetDataTable_StaffInfo(Convert.ToBoolean(Session["IsStakeholder"]), chkShowFired.Checked, false, false, searchSurname, searchSurnameOnlyStartsWith);

        // remove "Patient Login" staff member and Call Centre staff memebers
        for (int i = dt.Rows.Count - 1; i >= 0; i--)
        {
            if (((int)dt.Rows[i]["staff_id"]) == -6 || ((int)dt.Rows[i]["staff_id"]) == -7 || ((int)dt.Rows[i]["staff_id"]) == -8)
            {
                dt.Rows.RemoveAt(i);
            }
        }

        // hide higher privleiged users from lower priveliged users
        UserView userView = UserView.GetInstance();

        for (int i = dt.Rows.Count - 1; i >= 0; i--)
        {
            if (!userView.IsStakeholder && Convert.ToBoolean(dt.Rows[i]["is_stakeholder"]))
            {
                dt.Rows.RemoveAt(i);
                continue;
            }
            if (!userView.IsStakeholder && !userView.IsMasterAdmin && Convert.ToBoolean(dt.Rows[i]["is_master_admin"]))
            {
                dt.Rows.RemoveAt(i);
                continue;
            }
        }

        dt.DefaultView.Sort = "firstname, surname, middlename";
        dt = dt.DefaultView.ToTable();
        Session["staffinfo_data"] = dt;


        this.GrdStaff.AllowPaging = false;

        /*
         * if (!IsPostBack)
         *  chkUsePaging.Checked = dt.Rows.Count > 50;
         * this.GrdStaff.AllowPaging = chkUsePaging.Checked;
         */

        if (dt.Rows.Count > 0)
        {
            if (IsPostBack && Session["staffinfo_sortexpression"] != null && Session["staffinfo_sortexpression"].ToString().Length > 0)
            {
                DataView dataView = new DataView(dt);
                dataView.Sort       = Session["staffinfo_sortexpression"].ToString();
                GrdStaff.DataSource = dataView;
            }
            else
            {
                GrdStaff.DataSource = dt;
            }

            try
            {
                GrdStaff.DataBind();
                GrdStaff.PagerSettings.FirstPageText = "1";
                GrdStaff.PagerSettings.LastPageText  = GrdStaff.PageCount.ToString();
                GrdStaff.DataBind();
            }
            catch (Exception ex)
            {
                HideTableAndSetErrorMessage("", ex.ToString());
            }
        }
        else
        {
            dt.Rows.Add(dt.NewRow());
            GrdStaff.DataSource = dt;
            GrdStaff.DataBind();

            int TotalColumns = GrdStaff.Rows[0].Cells.Count;
            GrdStaff.Rows[0].Cells.Clear();
            GrdStaff.Rows[0].Cells.Add(new TableCell());
            GrdStaff.Rows[0].Cells[0].ColumnSpan = TotalColumns;
            GrdStaff.Rows[0].Cells[0].Text       = "No Record Found";
        }
    }
Ejemplo n.º 5
0
    /*
     * protected bool IsValidFormOrg()
     * {
     *  string orgID = Request.QueryString["org"];
     *  return orgID != null && Regex.IsMatch(orgID, @"^\d+$") && OrganisationDB.Exists(Convert.ToInt32(orgID));
     * }
     * protected int GetFormOrg(bool checkIsValid = true)
     * {
     *  if (checkIsValid && !IsValidFormOrg())
     *      throw new Exception("Invalid url org");
     *  return Convert.ToInt32(Request.QueryString["org"]);
     * }
     *
     * protected bool IsValidFormOrgs()
     * {
     *  string orgIDs = Request.QueryString["orgs"];
     *  return orgIDs != null && Regex.IsMatch(orgIDs, @"^[\d,]+$") && OrganisationDB.Exists(orgIDs);
     * }
     * protected string GetFormOrgs(bool checkIsValid = true)
     * {
     *  if (checkIsValid && !IsValidFormOrgs())
     *      throw new Exception("Invalid url orgs");
     *  return Request.QueryString["orgs"];
     * }
     */

    #endregion

    #region GrdStaff

    protected void FillStaffGrid()
    {
        DataTable dt = StaffDB.GetDataTable_StaffInfo(false, false, false, false, txtSearchSurname.Text.Trim(), chkSurnameSearchOnlyStartWith.Checked);

        bool onlyProviders = IsValidFormOnlyProviders() ? GetFormOnlyProviders(false) : false;

        if (onlyProviders)
        {
            lblHeading.Text = "Providers";
            for (int i = dt.Rows.Count - 1; i >= 0; i--)
            {
                if (!StaffDB.Load(dt.Rows[i]).IsProvider)
                {
                    dt.Rows.RemoveAt(i);
                }
            }
        }

        Session["staff_data"] = dt;

        if (dt.Rows.Count > 0)
        {
            if (IsPostBack && Session["staff_sortExpression"] != null && Session["staff_sortExpression"].ToString().Length > 0)
            {
                DataView dataView = new DataView(dt);
                dataView.Sort       = Session["staff_sortExpression"].ToString();
                GrdStaff.DataSource = dataView;
            }
            else
            {
                GrdStaff.DataSource = dt;
            }

            try
            {
                GrdStaff.DataBind();

                // don't need paging -- already have scrolling -- and there won't be too many staff to send in one page
                GrdStaff.PagerSettings.FirstPageText = "1";
                GrdStaff.PagerSettings.LastPageText  = GrdStaff.PageCount.ToString();
                GrdStaff.DataBind();
            }
            catch (Exception ex)
            {
                this.lblErrorMessage.Visible = true;
                this.lblErrorMessage.Text    = ex.ToString();
            }
        }
        else
        {
            dt.Rows.Add(dt.NewRow());
            GrdStaff.DataSource = dt;
            GrdStaff.DataBind();

            int TotalColumns = GrdStaff.Rows[0].Cells.Count;
            GrdStaff.Rows[0].Cells.Clear();
            GrdStaff.Rows[0].Cells.Add(new TableCell());
            GrdStaff.Rows[0].Cells[0].ColumnSpan = TotalColumns;
            GrdStaff.Rows[0].Cells[0].Text       = "No Record Found";
        }
    }