public bool SaveRoleAccessRightDetails(RoleAccessRightsBE roleAccessBE) { CommonDAL commondal = new CommonDAL(); SqlConnection con = commondal.Connection(); SqlCommand cmd = new SqlCommand(); cmd.CommandType = CommandType.StoredProcedure; cmd.CommandText = "Sp_UM_RoleAccessRightUpdate"; cmd.Parameters.Add("@PRAId", SqlDbType.Int).Value = roleAccessBE.PRAId; cmd.Parameters.Add("@RoleId", SqlDbType.Int).Value = roleAccessBE.RoleID; cmd.Parameters.Add("@AccessRights", SqlDbType.Int).Value = roleAccessBE.AddRec; cmd.Parameters.Add("@LastModifiedBy", SqlDbType.Int).Value = roleAccessBE.LastModifiedBy; cmd.Connection = con; //con.Open(); int Count = cmd.ExecuteNonQuery(); con.Close(); if (Count == 2) { return true; } else { return false; } }
public bool SaveRoleAccessRightDetails(RoleAccessRightsBE roleAccess) { RoleAccessRightsDAL roleAccessDAL = new RoleAccessRightsDAL(); if (roleAccessDAL.SaveRoleAccessRightDetails(roleAccess)) { return true; } else { return false; } }
protected void ddlRoleId_SelectedIndexChanged(object sender, EventArgs e) { if (ddlRoleId.SelectedItem.Value == "-Select-") { btnSave.Visible = false; lvRoleAccessRight.Visible = false; RoleAccessRightDataPager.Visible = false; ddlPageSize.Visible = false; lblSelect.Visible = false; } else { RoleAccessRightsBE RACCBE = new RoleAccessRightsBE(); RoleAccessRightsBAL roleAccessBAL = new RoleAccessRightsBAL(); DataTable dt = new DataTable(); RACCBE.RoleID = Convert.ToInt32(ddlRoleId.SelectedItem.Value); hdnRoleId.Value = RACCBE.RoleID.ToString(); RoleAccessRightDataPager.SetPageProperties(0, RoleAccessRightDataPager.PageSize, true); bindListView(); recalcNoOfPages(); } }
public void AssignValueRoleAccessRightsBE(int iCell, ref RoleAccessRightsBE roleAccessBE, int Value) { switch (iCell) { case 5: roleAccessBE.AddRec = Value; break; case 7: roleAccessBE.AddRec = Value; break; case 9: roleAccessBE.AddRec = Value; break; case 11: roleAccessBE.ViewRec = Value; break; case 13: roleAccessBE.PrintRec = Value; break; case 15: roleAccessBE.Search = Value; break; case 17: roleAccessBE.Approve = Value; break; } recalcNoOfPages(); }
private void loadRoleAccessRightsBE(RoleAccessRightsBE roleAccessBE) { int a = 0; int count = 0; RoleAccessRightsBAL RACBAL = new RoleAccessRightsBAL(); for (int iRow = 0; iRow < lvRoleAccessRight.Items.Count; iRow++) { for (int iCell = 5; iCell < lvRoleAccessRight.Items[0].Controls.Count - 1; iCell += 2) { roleAccessBE.PRAId = Convert.ToInt32(lvRoleAccessRight.DataKeys[iRow].Value.ToString()); if (((CheckBox)lvRoleAccessRight.Items[iRow].Controls[iCell]).Checked) { a = 1; } else { a = 0; } AssignValueRoleAccessRightsBE(iCell, ref roleAccessBE, a); } if (RACBAL.SaveRoleAccessRightDetails(roleAccessBE)) { count = count + 1; if (count == lvRoleAccessRight.Items.Count) { LoggedIn master = (LoggedIn)this.Master; master.ShowMessage("Role Successfully Updated.", true); } } else { count = count + 1; if (count == lvRoleAccessRight.Items.Count) { LoggedIn master = (LoggedIn)this.Master; master.ShowMessage("Unsuccessful", false); } } } }
protected void btnSave_Click(object sender, EventArgs e) { if (!commonBAL.isUserAuthorisedForPageFunc(LoggedInUser.UserId, thisPageName, "add")) { LoggedIn master = (LoggedIn)this.Master; master.ShowMessage("You are not authorised to perform this function. Please contact system administrator.", false); return; } RoleAccessRightsBAL roleAccessBAL = new RoleAccessRightsBAL(); RoleAccessRightsBE roleAccessBE = new RoleAccessRightsBE(); // roleAccessBE = loadRoleAccessRightsBE(roleAccessBE); roleAccessBE.RoleID = Convert.ToInt32(ddlRoleId.SelectedValue); roleAccessBE.LastModifiedBy = ((UserBE)Session["LoggedInUser"]).UserId; loadRoleAccessRightsBE(roleAccessBE); }