internal int UpdatePagePermission(tbl_PagePermission pagePermissionobj, int pagePermissionId) { try { tbl_PagePermission pagePerObj = _context.tbl_PagePermission.First(x => x.PermissionID == pagePermissionId); pagePerObj.RoleID = pagePermissionobj.RoleID; pagePerObj.PageID = pagePermissionobj.PageID; pagePerObj.ModuleId = pagePermissionobj.ModuleId; pagePerObj.CategoryId = pagePermissionobj.CategoryId; pagePerObj.CanVisit = pagePermissionobj.CanVisit; pagePerObj.CanEdit = pagePermissionobj.CanEdit; pagePerObj.CanDelete = pagePermissionobj.CanDelete; pagePerObj.CanExecute = pagePermissionobj.CanExecute; _context.SaveChanges(); return(1); } catch (Exception) { throw; } }
internal int SavePagePermission(List <tbl_PagePermission> pagePermissiones) { try { foreach (tbl_PagePermission aitem in pagePermissiones) { tbl_PagePermission tblpermission = _context.tbl_PagePermission.FirstOrDefault(x => x.RoleID == aitem.RoleID && x.PageID == aitem.PageID && x.CategoryId == aitem.CategoryId && x.ModuleId == aitem.ModuleId); if (tblpermission != null) { _context.tbl_PagePermission.DeleteObject(tblpermission); _context.SaveChanges(); } _context.tbl_PagePermission.AddObject(aitem); } _context.SaveChanges(); return(1); } catch (Exception) { throw; } }
internal int UpdatePagePermission(tbl_PagePermission pagePermissionobj, int pagePermissionId) { return(pageDal.UpdatePagePermission(pagePermissionobj, pagePermissionId)); }
protected void BtnSave_Clcik(object sender, EventArgs e) { try { List <tbl_PagePermission> pagesPermissiones = new List <tbl_PagePermission>(); CheckBox headerChkBox = ((CheckBox)gridviewPagePermissiones.HeaderRow.FindControl("headerLevelCheckBox")); if (headerChkBox.Checked == true) { foreach (GridViewRow gvRow in gridviewPagePermissiones.Rows) { tbl_PagePermission pagePermissionobj = new tbl_PagePermission(); pagePermissionobj.RoleID = Convert.ToInt32(drpRole.SelectedValue); //pagePermissionobj.PageID = Convert.ToInt32(drpPageName.SelectedValue); pagePermissionobj.CategoryId = Convert.ToInt32(drpCategory.SelectedValue); pagePermissionobj.ModuleId = Convert.ToInt32(drpModulName.SelectedValue); pagePermissionobj.OCODE = Convert.ToString(((SessionUser)Session["SessionUser"]).OCode); pagePermissionobj.EDIT_USER = ((SessionUser)Session["SessionUser"]).UserId; pagePermissionobj.EDIT_DATE = DateTime.Now; CheckBox rowChkBox = ((CheckBox)gvRow.FindControl("rowLevelCheckBox")); Label lblPagePermissionId = ((Label)gvRow.FindControl("lblPagePermissionId")); CheckBox rowCanVisit = ((CheckBox)gvRow.FindControl("chCanVisit")); CheckBox rowCanEdit = ((CheckBox)gvRow.FindControl("ChCanEdit")); CheckBox rowCanDelete = ((CheckBox)gvRow.FindControl("ChCanDelete")); CheckBox rowcanExecute = ((CheckBox)gvRow.FindControl("ChCanExecute")); pagePermissionobj.PageID = Convert.ToInt32(lblPagePermissionId.Text); pagePermissionobj.CanVisit = Convert.ToBoolean(rowCanVisit.Checked); pagePermissionobj.CanExecute = Convert.ToBoolean(rowcanExecute.Checked); pagePermissionobj.CanEdit = Convert.ToBoolean(rowCanEdit.Checked); pagePermissionobj.CanDelete = Convert.ToBoolean(rowCanDelete.Checked); pagesPermissiones.Add(pagePermissionobj); rowChkBox.Checked = true;//((CheckBox)sender).Checked; } } else { foreach (GridViewRow gvRow in gridviewPagePermissiones.Rows) { CheckBox rowChkBox = ((CheckBox)gvRow.FindControl("rowLevelCheckBox")); if (rowChkBox.Checked == true) { tbl_PagePermission pagePermissionobj = new tbl_PagePermission(); pagePermissionobj.RoleID = Convert.ToInt32(drpRole.SelectedValue); //pagePermissionobj.PageID = Convert.ToInt32(drpPageName.SelectedValue); pagePermissionobj.CategoryId = Convert.ToInt32(drpCategory.SelectedValue); pagePermissionobj.ModuleId = Convert.ToInt32(drpModulName.SelectedValue); pagePermissionobj.OCODE = Convert.ToString(((SessionUser)Session["SessionUser"]).OCode); pagePermissionobj.EDIT_USER = ((SessionUser)Session["SessionUser"]).UserId; pagePermissionobj.EDIT_DATE = DateTime.Now; Label lblPagePermissionId = ((Label)gvRow.FindControl("lblPagePermissionId")); CheckBox rowCanVisit = ((CheckBox)gvRow.FindControl("chCanVisit")); CheckBox rowCanEdit = ((CheckBox)gvRow.FindControl("ChCanEdit")); CheckBox rowCanDelete = ((CheckBox)gvRow.FindControl("ChCanDelete")); CheckBox rowcanExecute = ((CheckBox)gvRow.FindControl("ChCanExecute")); pagePermissionobj.PageID = Convert.ToInt32(lblPagePermissionId.Text); pagePermissionobj.CanVisit = Convert.ToBoolean(rowCanVisit.Checked); pagePermissionobj.CanExecute = Convert.ToBoolean(rowcanExecute.Checked); pagePermissionobj.CanEdit = Convert.ToBoolean(rowCanEdit.Checked); pagePermissionobj.CanDelete = Convert.ToBoolean(rowCanDelete.Checked); pagesPermissiones.Add(pagePermissionobj); } } } int result = pageBll.SavePagePermission(pagesPermissiones); if (result == 1) { //lblStatus.Text = "Data Save Successfully."; ScriptManager.RegisterStartupScript(this.Page, Page.GetType(), "text", "func('Data Saved Successfully')", true); } } catch (Exception) { throw; } }