/// <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; } }
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); }