private void BindDesignation() { WebTransport.DAL.DesigRightsDAL objclsDesigRightsDAL = new WebTransport.DAL.DesigRightsDAL(); var objDesignRights = objclsDesigRightsDAL.SelectDesignation(); objclsDesigRightsDAL = null; ddlDesignation.DataSource = objDesignRights; ddlDesignation.DataTextField = "Desig_Name"; ddlDesignation.DataValueField = "Desig_Idno"; ddlDesignation.DataBind(); ddlDesignation.Items.Insert(0, new ListItem("--Select--", "0")); }
/// <summary> /// To Bind Desig DropDown /// </summary> private void BindDesignation() { // AutomobileOnline.Model.clsDesigRightsDAL objclsDesigRightsDAL = new AutomobileOnline.Model.clsDesigRightsDAL(); WebTransport.DAL.DesigRightsDAL objclsDesigRightsDAL = new WebTransport.DAL.DesigRightsDAL(); var objDesignRights = objclsDesigRightsDAL.SelectDesignation(); objclsDesigRightsDAL = null; ddlDesign.DataSource = objDesignRights; ddlDesign.DataTextField = "Desig_Name"; ddlDesign.DataValueField = "Desig_Idno"; ddlDesign.DataBind(); ddlDesign.Items.Insert(0, new ListItem("< Choose >", "0")); }
/// <summary> /// To Bind Grid /// </summary> private void BindGrid() { // AutomobileOnline.Model.clsDesigRightsDAL objclsDesigRightsDAL = new AutomobileOnline.Model.clsDesigRightsDAL(); WebTransport.DAL.DesigRightsDAL objclsDesigRightsDAL = new WebTransport.DAL.DesigRightsDAL(); if (ddlType.SelectedItem.Text == "Form") { var lstGridData = objclsDesigRightsDAL.SelectForGridTypeForm(Convert.ToInt32(ddlDesign.SelectedValue)); objclsDesigRightsDAL = null; grdMain.DataSource = lstGridData; grdMain.DataBind(); int startRowOnPage = (grdMain.PageIndex * grdMain.PageSize) + 1; int lastRowOnPage = startRowOnPage + grdMain.Rows.Count - 1; lblcontant.Text = "Showing " + startRowOnPage.ToString() + " - " + lastRowOnPage.ToString() + " of " + lstGridData.Count.ToString(); lblcontant.Visible = true; divpaging.Visible = true; } else if (ddlType.SelectedItem.Text == "Menu") { var lstGridData = objclsDesigRightsDAL.SelectForGridTypeMenu(Convert.ToInt32(ddlDesign.SelectedValue)); objclsDesigRightsDAL = null; grdMain.DataSource = lstGridData; grdMain.DataBind(); int startRowOnPage = (grdMain.PageIndex * grdMain.PageSize) + 1; int lastRowOnPage = startRowOnPage + grdMain.Rows.Count - 1; lblcontant.Text = "Showing " + startRowOnPage.ToString() + " - " + lastRowOnPage.ToString() + " of " + lstGridData.Count.ToString(); lblcontant.Visible = true; divpaging.Visible = true; } else if (ddlType.SelectedItem.Text == "Report") { var lstGridData = objclsDesigRightsDAL.SelectForGridTypeRep(Convert.ToInt32(ddlDesign.SelectedValue)); objclsDesigRightsDAL = null; grdMain.DataSource = lstGridData; grdMain.DataBind(); int startRowOnPage = (grdMain.PageIndex * grdMain.PageSize) + 1; int lastRowOnPage = startRowOnPage + grdMain.Rows.Count - 1; lblcontant.Text = "Showing " + startRowOnPage.ToString() + " - " + lastRowOnPage.ToString() + " of " + lstGridData.Count.ToString(); lblcontant.Visible = true; divpaging.Visible = true; } else { lblcontant.Visible = false; divpaging.Visible = false; } 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 intDesigRghtsIdno = 0; // AutomobileOnline.Model.clsDesigRightsDAL objclsDesigRightsDAL = new AutomobileOnline.Model.clsDesigRightsDAL(); WebTransport.DAL.DesigRightsDAL objclsDesigRightsDAL = new WebTransport.DAL.DesigRightsDAL(); if (ddlType.SelectedItem.Text == "Form") { var lstGridData = objclsDesigRightsDAL.SelectForGridTypeForm(Convert.ToInt32(ddlDesign.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) { intDesigRghtsIdno = Convert.ToInt32(DataBinder.Eval(lstGridData[i], "DesigRghts_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 = objclsDesigRightsDAL.UpdateAll(intDesigRghtsIdno, bAdd, bEdit, bView, bDelete, bPrint, empIdno); bool bDesigRights = true; if (bAdd == true && bEdit == true && bView == true && bDelete == true && bPrint == true) { bDesigRights = true; } if (bAdd == false && bEdit == false && bView == false && bDelete == false && bPrint == false) { bDesigRights = false; } int intDesigRights = 0; intDesigRights = objclsDesigRightsDAL.UpdateDesigRights(Convert.ToInt32(ddlDesign.SelectedValue) /*intDesigRghtsIdno*/, bDesigRights); } i++; } } else if (ddlType.SelectedItem.Text == "Menu") { var lstGridData = objclsDesigRightsDAL.SelectForGridTypeMenu(Convert.ToInt32(ddlDesign.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) { intDesigRghtsIdno = Convert.ToInt32(DataBinder.Eval(lstGridData[i], "DesigRghts_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 = objclsDesigRightsDAL.UpdateAll(intDesigRghtsIdno, bAdd, bEdit, bView, bDelete, bPrint, empIdno); bool bDesigRights = true; if (bAdd == true && bEdit == true && bView == true && bDelete == true && bPrint == true) { bDesigRights = true; } if (bAdd == false && bEdit == false && bView == false && bDelete == false && bPrint == false) { bDesigRights = false; } int intDesigRights = 0; intDesigRights = objclsDesigRightsDAL.UpdateDesigRights(Convert.ToInt32(ddlDesign.SelectedValue) /*intDesigRghtsIdno*/, bDesigRights); } i++; } } else if (ddlType.SelectedItem.Text == "Report") { var lstGridData = objclsDesigRightsDAL.SelectForGridTypeRep(Convert.ToInt32(ddlDesign.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) { intDesigRghtsIdno = Convert.ToInt32(DataBinder.Eval(lstGridData[i], "DesigRghts_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 = objclsDesigRightsDAL.UpdateAll(intDesigRghtsIdno, bAdd, bEdit, bView, bDelete, bPrint, empIdno); bool bDesigRights = true; if (bAdd == true && bEdit == true && bView == true && bDelete == true && bPrint == true) { bDesigRights = true; } if (bAdd == false && bEdit == false && bView == false && bDelete == false && bPrint == false) { bDesigRights = false; } int intDesigRights = 0; intDesigRights = objclsDesigRightsDAL.UpdateDesigRights(Convert.ToInt32(ddlDesign.SelectedValue) /*intDesigRghtsIdno*/, bDesigRights); } i++; } } objclsDesigRightsDAL = null; if (value > 0) { this.BindGrid(); strMsg = "Record updated successfully."; } ScriptManager.RegisterStartupScript(this, this.GetType(), "alertstrMsg", "PassMessage('" + strMsg + "')", true); }
protected void grdMain_RowCommand(object sender, GridViewCommandEventArgs e) { Int32 empIdno = Convert.ToInt32((Session["UserIdno"] == null) ? "0" : Session["UserIdno"].ToString()); string strMsg = string.Empty; int intDesigRghtsIdno = 0; bool bAdd = false; bool bEdit = false; bool bView = false; bool bDelete = false; bool bPrint = false; WebTransport.DAL.DesigRightsDAL objclsDesigRightsDAL = new WebTransport.DAL.DesigRightsDAL(); HiddenField hiddesigId = (HiddenField)grdMain.Rows[0].FindControl("hiddesigId"); int intDesignIdno = Convert.ToInt32(hiddesigId.Value); if (e.CommandName == "cmdAdd") { string[] strAdd = Convert.ToString(e.CommandArgument).Split(new char[] { '_' }); if (strAdd.Length > 1) { intDesigRghtsIdno = Convert.ToInt32(strAdd[0]); if (Convert.ToBoolean(strAdd[1]) == true) { bAdd = false; } else { bAdd = true; } int value = objclsDesigRightsDAL.UpdateAdd(intDesigRghtsIdno, bAdd, empIdno); objclsDesigRightsDAL = null; if (value > 0) { this.BindGrid(); strMsg = "Record updated successfully."; } } } if (e.CommandName == "cmdEdit") { string[] strEdit = Convert.ToString(e.CommandArgument).Split(new char[] { '_' }); if (strEdit.Length > 1) { intDesigRghtsIdno = Convert.ToInt32(strEdit[0]); if (Convert.ToBoolean(strEdit[1]) == true) { bEdit = false; } else { bEdit = true; } int value = objclsDesigRightsDAL.UpdateEdit(intDesigRghtsIdno, bEdit, empIdno); objclsDesigRightsDAL = null; if (value > 0) { this.BindGrid(); strMsg = "Record updated successfully."; } } } if (e.CommandName == "cmdView") { string[] strView = Convert.ToString(e.CommandArgument).Split(new char[] { '_' }); if (strView.Length > 1) { intDesigRghtsIdno = Convert.ToInt32(strView[0]); if (Convert.ToBoolean(strView[1]) == true) { bView = false; } else { bView = true; } int value = objclsDesigRightsDAL.UpdateView(intDesigRghtsIdno, bView, empIdno); objclsDesigRightsDAL = null; if (value > 0) { this.BindGrid(); strMsg = "Record updated successfully."; } } } if (e.CommandName == "cmdDelete") { string[] strDelete = Convert.ToString(e.CommandArgument).Split(new char[] { '_' }); if (strDelete.Length > 1) { intDesigRghtsIdno = Convert.ToInt32(strDelete[0]); if (Convert.ToBoolean(strDelete[1]) == true) { bDelete = false; } else { bDelete = true; } int value = objclsDesigRightsDAL.UpdateDelete(intDesigRghtsIdno, bDelete, empIdno); objclsDesigRightsDAL = null; if (value > 0) { this.BindGrid(); strMsg = "Record updated successfully."; } } } if (e.CommandName == "cmdPrint") { string[] strPrint = Convert.ToString(e.CommandArgument).Split(new char[] { '_' }); if (strPrint.Length > 1) { intDesigRghtsIdno = Convert.ToInt32(strPrint[0]); if (Convert.ToBoolean(strPrint[1]) == true) { bPrint = false; } else { bPrint = true; } int value = objclsDesigRightsDAL.UpdatePrint(intDesigRghtsIdno, bPrint, empIdno); objclsDesigRightsDAL = null; if (value > 0) { this.BindGrid(); strMsg = "Record updated successfully."; } } } if (e.CommandName == "cmdSelectAll") { string[] strAll = Convert.ToString(e.CommandArgument).Split(new char[] { '_' }); if (strAll.Length > 1) { intDesigRghtsIdno = Convert.ToInt32(strAll[0]); int value = 0; GridViewRow row = (GridViewRow)(((Control)e.CommandSource).NamingContainer); 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 = objclsDesigRightsDAL.UpdateAll(intDesigRghtsIdno, bAdd, bEdit, bView, bDelete, bPrint, empIdno); objclsDesigRightsDAL = null; if (value > 0) { this.BindGrid(); strMsg = "Record updated successfully."; } } } bool bDesigRights = true; if (bAdd == true && bEdit == true && bView == true && bDelete == true && bPrint == true) { bDesigRights = true; } if (bAdd == false && bEdit == false && bView == false && bDelete == false && bPrint == false) { bDesigRights = false; } int intDesigRights = 0; // AutomobileOnline.Model.clsDesigRightsDAL objclsDesigRightsDAL1 = new AutomobileOnline.Model.clsDesigRightsDAL(); WebTransport.DAL.DesigRightsDAL objclsDesigRightsDAL1 = new WebTransport.DAL.DesigRightsDAL(); intDesigRights = objclsDesigRightsDAL1.UpdateDesigRights(intDesignIdno, bDesigRights); objclsDesigRightsDAL1 = null; this.BindGrid(); ScriptManager.RegisterStartupScript(this, this.GetType(), "alertstrMsg", "PassMessage('" + strMsg + "')", true); }