internal int DeleteUserAccessById(string UserAccessId, string Ocode) { int aid = Convert.ToInt16(UserAccessId); try { tbl_UserAccess userAccess = _context.tbl_UserAccess.First(i => i.UserAccessId == aid); _context.tbl_UserAccess.DeleteObject(userAccess); _context.SaveChanges(); return(1); } catch (Exception) { throw; } }
internal int SaveUserAccess(List <tbl_UserAccess> UserAccessList) { try { foreach (tbl_UserAccess aitem in UserAccessList) { tbl_UserAccess _userAccess = _context.tbl_UserAccess.FirstOrDefault(x => x.UserID == aitem.UserID && x.PageID == aitem.PageID && x.CategoryId == aitem.CategoryId && x.ModuleId == aitem.ModuleId); if (_userAccess != null) { _context.DeleteObject(_userAccess); _context.SaveChanges(); } _context.tbl_UserAccess.AddObject(aitem); _context.SaveChanges(); } _context.SaveChanges(); return(1); } catch (Exception) { throw; } }
protected void BtnSave_Clcik(object sender, EventArgs e) { try { List <tbl_UserAccess> UserAccessList = new List <tbl_UserAccess>(); CheckBox headerChkBox = ((CheckBox)gridviewPagePermissiones.HeaderRow.FindControl("headerLevelCheckBox")); if (headerChkBox.Checked == true) { foreach (GridViewRow gvRow in gridviewPagePermissiones.Rows) { tbl_UserAccess UAccess = new tbl_UserAccess(); UAccess.UserID = new Guid(drpUserName.SelectedValue.ToString()); UAccess.UserName = drpUserName.SelectedItem.ToString(); UAccess.RoleID = Convert.ToInt32(drpRole.SelectedValue.ToString()); UAccess.OCODE = Convert.ToString(((SessionUser)Session["SessionUser"]).OCode); UAccess.EDIT_USER = ((SessionUser)Session["SessionUser"]).UserId; UAccess.EDIT_DATE = DateTime.Now; CheckBox rowChkBox = ((CheckBox)gvRow.FindControl("rowLevelCheckBox")); Label lblPagePermissionId = ((Label)gvRow.FindControl("lblPageId")); Label lblcatId = ((Label)gvRow.FindControl("lblcategoryhId")); Label lblMulId = ((Label)gvRow.FindControl("lblModuleId")); CheckBox rowCanVisit = ((CheckBox)gvRow.FindControl("chCanVisit")); CheckBox rowCanEdit = ((CheckBox)gvRow.FindControl("ChCanEdit")); CheckBox rowCanDelete = ((CheckBox)gvRow.FindControl("ChCanDelete")); CheckBox rowcanExecute = ((CheckBox)gvRow.FindControl("ChCanExecute")); UAccess.PageID = Convert.ToInt32(lblPagePermissionId.Text); UAccess.CategoryId = Convert.ToInt32(lblcatId.Text); UAccess.ModuleId = Convert.ToInt32(lblMulId.Text); UAccess.CanVisit = Convert.ToBoolean(rowCanVisit.Checked); UAccess.CanExecute = Convert.ToBoolean(rowcanExecute.Checked); UAccess.CanEdit = Convert.ToBoolean(rowCanEdit.Checked); UAccess.CanDelete = Convert.ToBoolean(rowCanDelete.Checked); UserAccessList.Add(UAccess); rowChkBox.Checked = true;//((CheckBox)sender).Checked; } } else { foreach (GridViewRow gvRow in gridviewPagePermissiones.Rows) { CheckBox rowChkBox = ((CheckBox)gvRow.FindControl("rowLevelCheckBox")); if (rowChkBox.Checked == true) { tbl_UserAccess UAccess = new tbl_UserAccess(); UAccess.UserID = Guid.Parse(drpUserName.SelectedValue.ToString()); UAccess.UserName = drpUserName.SelectedItem.ToString(); UAccess.RoleID = Convert.ToInt32(drpRole.SelectedValue.ToString()); UAccess.OCODE = Convert.ToString(((SessionUser)Session["SessionUser"]).OCode); UAccess.EDIT_USER = ((SessionUser)Session["SessionUser"]).UserId; UAccess.EDIT_DATE = DateTime.Now; Label lblPagePermissionId = ((Label)gvRow.FindControl("lblPageId")); Label lblcatId = ((Label)gvRow.FindControl("lblcategoryhId")); Label lblMulId = ((Label)gvRow.FindControl("lblModuleId")); CheckBox rowCanVisit = ((CheckBox)gvRow.FindControl("chCanVisit")); CheckBox rowCanEdit = ((CheckBox)gvRow.FindControl("ChCanEdit")); CheckBox rowCanDelete = ((CheckBox)gvRow.FindControl("ChCanDelete")); CheckBox rowcanExecute = ((CheckBox)gvRow.FindControl("ChCanExecute")); UAccess.PageID = Convert.ToInt32(lblPagePermissionId.Text); UAccess.CategoryId = Convert.ToInt32(lblcatId.Text); UAccess.ModuleId = Convert.ToInt32(lblMulId.Text); UAccess.CanVisit = Convert.ToBoolean(rowCanVisit.Checked); UAccess.CanExecute = Convert.ToBoolean(rowcanExecute.Checked); UAccess.CanEdit = Convert.ToBoolean(rowCanEdit.Checked); UAccess.CanDelete = Convert.ToBoolean(rowCanDelete.Checked); UserAccessList.Add(UAccess); } } } int result = UserAccessBllObj.SaveUserAccess(UserAccessList); if (result == 1) { //lblStatus.Text = "Data Save Successfully."; ScriptManager.RegisterStartupScript(this.Page, Page.GetType(), "text", "func('Data Saved Successfully')", true); } } catch (Exception) { throw; } }