Beispiel #1
0
        protected void GetApprovedUsers()
        {
            DataTable dt = null;

            dt = DataProxy.GetApprovedUsers();

            DataView dv = dt.DefaultView;

            //if (dv != null)
            //    dv.Sort = "Approved ASC";

            grdApproveUser.DataSource = dt;
            grdApproveUser.DataBind();
            grdApproveUser.Visible    = true;
            Session["dvUserRequests"] = dt.DefaultView;
            btnPrint.Visible          = true;
            btnExport.Visible         = true;
            lblReportTitle.Visible    = true;
        }
Beispiel #2
0
        protected void GetSearchResults()
        {
            DataTable dt = null;
            //bool bCountrySearch = false;

            //if (ddlCountries.SelectedIndex > 0)
            //    bCountrySearch = true;

            int    intCountryID = 0;
            string strCountry   = "";

            if (ddlCountries.SelectedValue != "")
            {
                intCountryID = Convert.ToInt32(ddlCountries.SelectedValue);
                strCountry   = ddlCountries.SelectedItem.Text;
            }

            dt = DataProxy.GetApprovedUsers();
            DataView dv = dt.DefaultView;

            dv.RowFilter = "1=1 ";

            if (intCountryID > 0)
            {
                dv.RowFilter += "AND CountryExpertise LIKE '%" + strCountry + "%'";
            }

            if (ddlRoles.SelectedIndex > 0)
            {
                dv.RowFilter += "AND UserType = '" + ddlRoles.SelectedValue + "'";
            }

            grdApproveUser.DataSource = dv;
            grdApproveUser.DataBind();
            grdApproveUser.Visible    = true;
            Session["dvUserRequests"] = dt.DefaultView;
            btnPrint.Visible          = true;
            btnExport.Visible         = true;
            lblReportTitle.Visible    = true;
        }