예제 #1
0
        /// <summary>
        /// To Bind Grid
        /// </summary>
        private void BindGrid()
        {
            UserRightsDAL objUserRightsDAL = new UserRightsDAL();

            if (ddlType.SelectedItem.Text == "Form")
            {
                var lstGridData = objUserRightsDAL.SelectForGridTypeForm(Convert.ToInt32(ddlUser.SelectedValue));
                objUserRightsDAL   = null;
                grdMain.DataSource = lstGridData;
                grdMain.DataBind();
            }
            else if (ddlType.SelectedItem.Text == "Menu")
            {
                var lstGridData = objUserRightsDAL.SelectForGridTypeMenu(Convert.ToInt32(ddlUser.SelectedValue));
                objUserRightsDAL   = null;
                grdMain.DataSource = lstGridData;
                grdMain.DataBind();
            }
            else if (ddlType.SelectedItem.Text == "Report")
            {
                var lstGridData = objUserRightsDAL.SelectForGridTypeRep(Convert.ToInt32(ddlUser.SelectedValue));
                objUserRightsDAL   = null;
                grdMain.DataSource = lstGridData;
                grdMain.DataBind();
            }

            int count    = grdMain.Rows.Count;
            int RowCount = 0;

            foreach (GridViewRow row in grdMain.Rows)
            {
                CheckBox chkSelect = (CheckBox)row.FindControl("chkSelect");
                if (chkSelect.Checked)
                {
                    RowCount++;
                }
            }
            if (RowCount == count)
            {
                chkSelectAllRows.Checked     = true;
                imgBtnSelectAllRows.ImageUrl = "~/Images/SelectAll_Active.png";
            }
            else
            {
                chkSelectAllRows.Checked     = false;
                imgBtnSelectAllRows.ImageUrl = "~/Images/SelectAll_Inactive.png";
            }
            if (count > 0)
            {
                selectall.Visible = true;
            }
            else
            {
                selectall.Visible = false;
            }
        }
예제 #2
0
        protected void imgBtnSelectAllRows_Click(object sender, ImageClickEventArgs e)
        {
            Int32         empIdno          = Convert.ToInt32((Session["UserIdno"] == null) ? "0" : Session["UserIdno"].ToString());
            int           value            = 0;
            string        strMsg           = string.Empty;
            int           intUserRghtsIdno = 0;
            UserRightsDAL objUserRightsDAL = new UserRightsDAL();

            if (ddlType.SelectedItem.Text == "Form")
            {
                var lstGridData = objUserRightsDAL.SelectForGridTypeForm(Convert.ToInt32(ddlUser.SelectedValue));
                int i           = 0;
                foreach (GridViewRow row in grdMain.Rows)
                {
                    bool bAdd    = false;
                    bool bEdit   = false;
                    bool bView   = false;
                    bool bDelete = false;
                    bool bPrint  = false;
                    if (lstGridData.Count > 0)
                    {
                        intUserRghtsIdno = Convert.ToInt32(DataBinder.Eval(lstGridData[i], "UserRgt_Idno"));
                        CheckBox chkSelect = (CheckBox)row.FindControl("chkSelect");
                        if (chkSelect.Checked == true)
                        {
                            bAdd = true; bEdit = true; bView = true; bDelete = true; bPrint = true;
                        }
                        else if (chkSelect.Checked == false)
                        {
                            bAdd = false; bEdit = false; bView = false; bDelete = false; bPrint = false;
                        }
                        value = objUserRightsDAL.UpdateAll(intUserRghtsIdno, bAdd, bEdit, bView, bDelete, bPrint, empIdno);
                    }
                    i++;
                }
            }
            else if (ddlType.SelectedItem.Text == "Menu")
            {
                var lstGridData = objUserRightsDAL.SelectForGridTypeMenu(Convert.ToInt32(ddlUser.SelectedValue));
                int i           = 0;
                foreach (GridViewRow row in grdMain.Rows)
                {
                    bool bAdd    = false;
                    bool bEdit   = false;
                    bool bView   = false;
                    bool bDelete = false;
                    bool bPrint  = false;
                    if (lstGridData.Count > 0)
                    {
                        intUserRghtsIdno = Convert.ToInt32(DataBinder.Eval(lstGridData[i], "UserRgt_Idno"));
                        CheckBox chkSelect = (CheckBox)row.FindControl("chkSelect");
                        if (chkSelect.Checked == true)
                        {
                            bAdd = true; bEdit = true; bView = true; bDelete = true; bPrint = true;
                        }
                        else if (chkSelect.Checked == false)
                        {
                            bAdd = false; bEdit = false; bView = false; bDelete = false; bPrint = false;
                        }
                        value = objUserRightsDAL.UpdateAll(intUserRghtsIdno, bAdd, bEdit, bView, bDelete, bPrint, empIdno);
                    }
                    i++;
                }
            }
            else if (ddlType.SelectedItem.Text == "Report")
            {
                var lstGridData = objUserRightsDAL.SelectForGridTypeRep(Convert.ToInt32(ddlUser.SelectedValue));
                int i           = 0;
                foreach (GridViewRow row in grdMain.Rows)
                {
                    bool bAdd    = false;
                    bool bEdit   = false;
                    bool bView   = false;
                    bool bDelete = false;
                    bool bPrint  = false;
                    if (lstGridData.Count > 0)
                    {
                        intUserRghtsIdno = Convert.ToInt32(DataBinder.Eval(lstGridData[i], "UserRgt_Idno"));
                        CheckBox chkSelect = (CheckBox)row.FindControl("chkSelect");
                        if (chkSelect.Checked == true)
                        {
                            bAdd = true; bEdit = true; bView = true; bDelete = true; bPrint = true;
                        }
                        else if (chkSelect.Checked == false)
                        {
                            bAdd = false; bEdit = false; bView = false; bDelete = false; bPrint = false;
                        }
                        value = objUserRightsDAL.UpdateAll(intUserRghtsIdno, bAdd, bEdit, bView, bDelete, bPrint, empIdno);
                    }
                    i++;
                }
            }
            objUserRightsDAL = null;
            if (value > 0)
            {
                this.BindGrid();
                strMsg = "Record updated successfully.";
            }
            if (value <= 0)
            {
                strMsg = "Record not updated.";
            }
            ScriptManager.RegisterStartupScript(this, this.GetType(), "alertstrMsg", "PassMessage('" + strMsg + "')", true);
        }