public Result UiPageSave(SEC_UIPage page) { Result _result = new Result(); _uiPageFactory = new UiPageFactory(); _userActionMappingFactory = new UserActionMappingFactory(); Dictionary <int, CheckSessionData> dictionary = CheckSessionData.GetSessionValues(); int userId = Convert.ToInt32(dictionary[6].Id == "" ? 0 : Convert.ToInt32(dictionary[6].Id)); int empId = Convert.ToInt32(dictionary[1].Id == "" ? 0 : Convert.ToInt32(dictionary[1].Id)); try { if (page.ID > 0) { _uiPageFactory.Edit(page); _result = _uiPageFactory.Save(); if (_result.isSucess) { SEC_UserActionMapping userActionMapping = new SEC_UserActionMapping(); _userGroupFactory = new UserGroupFactory(); var groupID = _userGroupFactory.GetAll().ToList(); foreach (var details in groupID) { var uiMapping = _userActionMappingFactory.FindBy(x => x.UserGroupID == details.ID && x.UIPageID == page.ID).Count(); if (uiMapping == 0) { userActionMapping.UserGroupID = details.ID; userActionMapping.UIPageID = page.ID; userActionMapping.UIModuleID = Convert.ToInt32(page.ModuleID); userActionMapping.IsCreate = false; userActionMapping.IsDelete = false; userActionMapping.IsEdit = false; userActionMapping.IsSelect = false; userActionMapping.CreatedBy = empId; userActionMapping.CreatedDate = DateTime.Now; _userActionMappingFactory.Add(userActionMapping); _result = _userActionMappingFactory.Save(); } } if (_result.isSucess) { _result.message = _result.UpdateSuccessfull(tablePageName); return(_result); } _result.message = _result.UpdateSuccessfull(tablePageName); } } else { int pageID = 1; var prvPage = _uiPageFactory.GetLastRecord().OrderByDescending(x => x.ID).FirstOrDefault(); if (prvPage != null) { pageID = prvPage.ID + 1; } page.UrlID = 1; page.ID = pageID; _uiPageFactory.Add(page); _result = _uiPageFactory.Save(); if (_result.isSucess) { var uiMapping = _userActionMappingFactory.FindBy(x => x.UserGroupID == userId && x.UIPageID == page.ID).Count(); if (uiMapping == 0) { SEC_UserActionMapping userActionMapping = new SEC_UserActionMapping(); _userGroupFactory = new UserGroupFactory(); var groupID = _userGroupFactory.GetAll().ToList(); foreach (var details in groupID) { userActionMapping.UserGroupID = details.ID; userActionMapping.UIPageID = page.ID; userActionMapping.UIModuleID = Convert.ToInt32(page.ModuleID); userActionMapping.IsCreate = false; userActionMapping.IsDelete = false; userActionMapping.IsEdit = false; userActionMapping.IsSelect = false; userActionMapping.CreatedBy = empId; userActionMapping.CreatedDate = DateTime.Now; _userActionMappingFactory.Add(userActionMapping); _result = _userActionMappingFactory.Save(); } if (_result.isSucess) { _result.message = _result.SaveSuccessfull(tablePageName); _result.lastInsertedID = userActionMapping.ID; return(_result); } } _result.message = _result.SaveSuccessfull(tablePageName); } } } catch (Exception e) { _result.isSucess = false; _result.message = e.Message; } return(_result); }
public Result SaveUserGroupWithPageMapping(SEC_UserGroup userGroup) { Result result = new Result(); using (var dbContextTransaction = context.Database.BeginTransaction()) { try { _userGroupFactory = new UserGroupFactory(); _userGroupFactory.Add(userGroup); bool isDuplicate = _userGroupFactory.FindBy(x => x.Name.ToLower().Trim() == userGroup.Name.ToLower().Trim()).Any(x => x.Name.ToLower() == userGroup.Name.ToLower()); if (!isDuplicate) { result = _userGroupFactory.Save(); _uiPageFactory = new UiPageFactory(); _userActionMappingFactory = new UserActionMappingFactory(); if (result.isSucess) { List <SEC_UIPage> uiPageList = _uiPageFactory.GetAll().ToList(); foreach (var item in uiPageList) { SEC_UserActionMapping userMappings = new SEC_UserActionMapping(); userMappings.UserGroupID = Convert.ToInt32(userGroup.ID); userMappings.UIModuleID = Convert.ToInt32(item.ModuleID); userMappings.UIPageID = item.ID; userMappings.IsSelect = false; userMappings.IsCreate = false; userMappings.IsEdit = false; userMappings.IsDelete = false; userMappings.CreatedDate = DateTime.Now; userMappings.CreatedBy = Convert.ToInt32(userGroup.CreatedBy); _userActionMappingFactory.Add(userMappings); } result = _userActionMappingFactory.Save(); } if (result.isSucess) { result.message = result.SaveSuccessfull(tableName); dbContextTransaction.Commit(); return(result); } else { result.isSucess = false; dbContextTransaction.Rollback(); return(result); } } result.message = "Your entared code is duplicate"; result.isSucess = false; dbContextTransaction.Commit(); return(result); } catch (Exception ex) { result.message = "Error occured"; result.isSucess = false; dbContextTransaction.Rollback(); } } return(result); }
public Result EditUserGroupPagePermission(SEC_UserGroup userGroup, List <MenuItemVM> userMappingVm = null) { Result _result = new Result(); using (var dbContextTransaction = context.Database.BeginTransaction()) { try { Dictionary <int, CheckSessionData> dictionary = CheckSessionData.GetSessionValues(); int userId = Convert.ToInt32(dictionary[3].Id); _userGroupFactory = new UserGroupFactory(); if (userGroup != null) { userGroup.UpdatedBy = userId; userGroup.UpdatedDate = DateTime.Now; _userGroupFactory.Edit(userGroup); _result = _userGroupFactory.Save(); } if (_result.isSucess) { if (userMappingVm != null) { _userActionMappingFactory = new UserActionMappingFactory(); int userGroupId = Convert.ToInt32(userGroup.ID); List <SEC_UserActionMapping> userMappingList = _userActionMappingFactory.FindBy(x => x.UserGroupID == userGroupId).ToList(); foreach (var item in userMappingVm) { SEC_UserActionMapping userMapping = userMappingList.FirstOrDefault(x => x.UIPageID == item.PageId); if (userMapping != null) { userMapping.IsSelect = item.Select != null ? (bool)item.Select : userMapping.IsSelect; userMapping.IsCreate = item.Create != null ? (bool)item.Create : userMapping.IsCreate; userMapping.IsEdit = item.Edit != null ? (bool)item.Edit : userMapping.IsEdit; userMapping.IsDelete = item.Delete != null ? (bool)item.Delete : userMapping.IsDelete; userMapping.UpdatedDate = DateTime.Now; userMapping.UpdatedBy = userId; _userActionMappingFactory.Edit(userMapping); } _result = _userActionMappingFactory.Save(); } if (_result.isSucess) { _result.message = _result.UpdateSuccessfull(tableName); dbContextTransaction.Commit(); } else { _result.isSucess = false; dbContextTransaction.Rollback(); } } } return(_result); } catch (Exception ex) { _result.isSucess = false; dbContextTransaction.Rollback(); return(_result); } } }
public Result SaveUserGroupWithPagePermission(SEC_UserGroup userGroup, List <MenuItemVM> menuVm) { Result result = new Result(); using (var dbContextTransaction = context.Database.BeginTransaction()) { try { _userGroupFactory = new UserGroupFactory(); _userGroupFactory.Add(userGroup); bool isDuplicate = _userGroupFactory.FindBy(x => x.Name.ToLower().Trim() == userGroup.Name.ToLower().Trim()).Any(x => x.Name.ToLower() == userGroup.Name.ToLower()); if (!isDuplicate) { _userGroupFactory.Save(); _uiPageFactory = new UiPageFactory(); _userActionMappingFactory = new UserActionMappingFactory(); List <SEC_UIPage> uiPageList = _uiPageFactory.GetAll().ToList(); foreach (var item in uiPageList) { SEC_UserActionMapping userMappings = new SEC_UserActionMapping(); userMappings.UserGroupID = Convert.ToInt32(userGroup.ID); userMappings.UIModuleID = Convert.ToInt32(item.ModuleID); userMappings.UIPageID = item.ID; userMappings.IsSelect = false; userMappings.IsCreate = false; userMappings.IsEdit = false; userMappings.IsDelete = false; userMappings.CreatedDate = DateTime.Now; userMappings.CreatedBy = Convert.ToInt32(userGroup.CreatedBy); _userActionMappingFactory.Add(userMappings); } _userActionMappingFactory.Save(); if (menuVm != null) { int userGroupId = Convert.ToInt32(userGroup.ID); List <SEC_UserActionMapping> userMappingList = _userActionMappingFactory.FindBy(x => x.UserGroupID == userGroupId).ToList(); List <MenuItemVM> userMappingVmList = menuVm.Distinct().ToList(); foreach (var item in userMappingVmList) { SEC_UserActionMapping userMapping = new SEC_UserActionMapping(); userMapping = userMappingList.FirstOrDefault(x => x.UIPageID == item.PageId); if (userMapping != null) { userMapping.IsSelect = item.Select != null ? (bool)item.Select : userMapping.IsSelect; userMapping.IsCreate = item.Create != null ? (bool)item.Create : userMapping.IsCreate; userMapping.IsEdit = item.Edit != null ? (bool)item.Edit : userMapping.IsEdit; userMapping.IsDelete = item.Delete != null ? (bool)item.Delete : userMapping.IsDelete; _userActionMappingFactory.Edit(userMapping); } } _userActionMappingFactory.Save(); } result.message = "Saved Successfuly"; result.isSucess = true; dbContextTransaction.Commit(); return(result); } result.message = "Your entared code is duplicate"; result.isSucess = false; dbContextTransaction.Commit(); return(result); } catch (Exception ex) { result.message = "Error occured"; result.isSucess = false; dbContextTransaction.Rollback(); } } return(result); }