public ActionResult LoadAllUserGroup() { try { Dictionary <int, CheckSessionData> dictionary = CheckSessionData.GetSessionValues(); int userGroupId = Convert.ToInt32(dictionary[6].Id == "" ? 0 : Convert.ToInt32(dictionary[6].Id)); if (userGroupId != 0) { _userGroupFactory = new UserGroupFactory(); var userGroup = _userGroupFactory.GetAll().Select(x => new { x.ID, UserGroup = x.Name, IsAdmin = x.IsAdmin, x.CreatedBy, x.CreatedDate }).ToList(); return(Json(userGroup.OrderBy(x => x.UserGroup).ToList())); } return(Json(new { success = false, message = "LogOut" }, JsonRequestBehavior.AllowGet)); } catch (Exception exception) { return(Json(new { success = false, message = exception.Message }, JsonRequestBehavior.AllowGet)); } }
public JsonResult LoadUserGroupForEdit(int id) { try { Dictionary <int, CheckSessionData> dictionary = CheckSessionData.GetSessionValues(); int companyId = Convert.ToInt32(dictionary[1].Id); if (companyId != 0) { _userGroupFactory = new UserGroupFactory(); var userGroup = _userGroupFactory.GetAll() .Select(a => new { a.ID, a.Name }).FirstOrDefault(); return(Json(new { success = true, data = userGroup }, JsonRequestBehavior.AllowGet)); } } catch (Exception exception) { return(Json(new { success = false, message = exception.Message }, JsonRequestBehavior.AllowGet)); } return(Json(new { success = false, message = "Error Ocured" }, JsonRequestBehavior.AllowGet)); }
public Result SelfPasswordChange(ChangePasswordModel changePassword) { try { result = new Result(); result.isSucess = false; Dictionary <int, CheckSessionData> dictionary = CheckSessionData.GetSessionValues(); int userGroupId = Convert.ToInt32(dictionary[6].Id == "" ? 0 : Convert.ToInt32(dictionary[6].Id)); if (userGroupId != 0) { int userId = Convert.ToInt32(dictionary[3].Id); string userName = dictionary[4].Id; _userFactory = new UserFactory(); bool status = _userFactory.GetAll().Any(x => x.UserName == userName && x.UserGroupID == userGroupId); if (status == true) { SEC_UserInformation tblUserInformation; tblUserInformation = _userFactory.FindBy(x => x.ID == userId).FirstOrDefault(); _passwordFactory = new UserPasswordFactory(); Encription encription = new Encription(); SEC_Password tblPassword = _passwordFactory.GetAll().FirstOrDefault(x => x.ID == tblUserInformation.PasswordID); if (tblPassword != null) { tblPassword.OldPassword = tblPassword.NewPassword; tblPassword.NewPassword = encription.Encrypt(changePassword.NewPassword.Trim()); tblPassword.IsSelfChanged = true; tblPassword.UpdatedDate = DateTime.Now; tblPassword.UpdatedBy = userId; _passwordFactory.Edit(tblPassword); } result = _passwordFactory.Save(); if (result.isSucess) { result.message = "Changed Password Sucessfully"; return(result); } } result.message = "Password not Changed try again"; return(result); } result.message = "LogOut"; } catch (Exception exception) { result.isSucess = false; result.message = exception.Message; } return(result); }
public dynamic GetEditPageList(int userGroupId) { try { _userActionMappingFactory = new UserActionMappingFactory(); _uiPageFactory = new UiPageFactory(); _moduleFactory = new ModuleFactory(); _userActionMappingFactory = new UserActionMappingFactory(); var module = _moduleFactory.GetAll().ToList(); var page = from pag in context.SEC_UIPage join map in context.SEC_UserActionMapping on pag.ID equals map.UIPageID where map.UserGroupID == userGroupId select new { PageId = pag.ID, ModuleId = map.UIModuleID, ModuleName = pag.Name, Select = map.IsSelect, Create = map.IsCreate, Edit = map.IsEdit, Delete = map.IsDelete, ShowHide = true }; var menu = (from item in module select new { ID = item.ID, Name = item.Name, Select = true, Edit = true, Create = true, Delete = true, ShowHide = false, children = page.Where(x => x.ModuleId == item.ID).ToList() }).ToList(); return(menu); } catch (Exception ex) { throw ex; } }
public JsonResult GetAllUserGroups() { try { _userGroupFactory = new UserGroupFactory(); var userGroups = _userGroupFactory.GetAll().Select(x => new { x.ID, x.Name }).ToList(); return(Json(userGroups.OrderBy(x => x.Name), JsonRequestBehavior.AllowGet)); } catch (Exception exception) { return(Json(new { success = false, message = exception.Message }, JsonRequestBehavior.AllowGet)); } }
public List <MeetingRoomRequisition> SearchMeetingRoomReq(int?id) { _mrReqFactory = new MeetingRoomReqFactory(); try { var list = new List <MeetingRoomRequisition>(); if (id > 0) { list = _mrReqFactory.FindBy(x => x.MeetingRoomID == id).ToList(); } else { list = _mrReqFactory.GetAll().ToList(); } return(list); } catch (Exception e) { throw e; } }
public List <DAL.db.MeetingRoom> SearchMeetingRoom(int?meetingRoomID) { _mrFactory = new MeetingRoomFactory(); try { var list = new List <DAL.db.MeetingRoom>(); if (meetingRoomID > 0) { list = _mrFactory.FindBy(x => x.MeetingRoomID == meetingRoomID).ToList(); } else { list = _mrFactory.GetAll().ToList(); } return(list); } catch (Exception e) { throw e; } }
public List <Designation> SearchDesignation(int?DesignationID) { try { _esignationFactory = new DesignationFactory(); var list = new List <Designation>(); if (DesignationID > 0) { list = _esignationFactory.FindBy(x => x.DesignationID == DesignationID).ToList(); } else { list = _esignationFactory.GetAll().ToList(); } return(list); } catch (Exception ex) { throw ex; } }
public List <Department> SearchDepartment(int?DepartmentID) { try { _departmentFactory = new DepartmentFactory(); var list = new List <Department>(); if (DepartmentID > 0) { list = _departmentFactory.FindBy(x => x.DepartmentID == DepartmentID).ToList(); } else { list = _departmentFactory.GetAll().ToList(); } return(list); } catch (Exception ex) { throw ex; } }
public List <Employee> SearchEmployee(int?empID) { _scheduleEmpFactory = new ScheduleEmployeeFactory(); try { var list = new List <Employee>(); if (empID > 0) { list = _scheduleEmpFactory.FindBy(x => x.EmployeeID == empID).ToList(); } else { list = _scheduleEmpFactory.GetAll().ToList(); } return(list); } catch (Exception e) { throw e; } }
public List <Employee> SearchEmployee(int?EmployeeID) { try { _employeeFactory = new EmployeeFactory(); var list = new List <Employee>(); if (EmployeeID > 0) { list = _employeeFactory.FindBy(x => x.EmployeeID == EmployeeID).ToList(); } else { list = _employeeFactory.GetAll().ToList(); } return(list); } catch (Exception ex) { throw ex; } }
public List <SET_CompanyBranch> SearchCompanyBranch(int?id) { try { _companyBranchFactory = new CompanyBranchFactory(); var list = new List <SET_CompanyBranch>(); if (id > 0) { list = _companyBranchFactory.FindBy(x => x.BranchID == id).ToList(); } else { list = _companyBranchFactory.GetAll().ToList(); } return(list); } catch (Exception e) { throw e; } }
public List <DAL.db.MeetingParticipant> SearchMeetingRoomParticipant(int?id) { _mrPrFactory = new ParticipantFactory(); try { var list = new List <MeetingParticipant>(); if (id != null) { list = _mrPrFactory.FindBy(x => x.RequisitionID == id).ToList(); } else { list = _mrPrFactory.GetAll().ToList(); } return(list); } catch (Exception e) { throw e; } }
public dynamic GetPageList() { _userActionMappingFactory = new UserActionMappingFactory(); _uiPageFactory = new UiPageFactory(); _moduleFactory = new ModuleFactory(); var module = _moduleFactory.GetAll().ToList(); var page = _uiPageFactory.GetAll(); List <MenuItemVM> pageUrlvmList = new List <MenuItemVM>(); foreach (var item in page) { MenuItemVM pageUrlvm = new MenuItemVM(); pageUrlvm.PageId = item.ID; pageUrlvm.ModuleId = item.ModuleID.GetValueOrDefault(); pageUrlvm.ModuleName = item.Name; pageUrlvm.Select = false; pageUrlvm.Edit = false; pageUrlvm.Create = false; pageUrlvm.Delete = false; pageUrlvm.ShowHide = true; pageUrlvmList.Add(pageUrlvm); } var menu = (from item in module select new { ID = item.ID, Name = item.Name, Select = true, Edit = true, Create = true, Delete = true, ShowHide = false, children = pageUrlvmList.Where(x => x.ModuleId == item.ID).ToList() }).ToList(); return(menu); }
public JsonResult LoadUserGroups() { try { Dictionary <int, CheckSessionData> dictionary = CheckSessionData.GetSessionValues(); int companyId = Convert.ToInt32(dictionary[1].Id == "" ? 0 : Convert.ToInt32(dictionary[1].Id)); if (companyId != 0) { _userGroupFactory = new UserGroupFactory(); var userGroups = _userGroupFactory.GetAll().Select(x => new { id = x.Name, Group = x.Name }).ToList(); return(Json(new { success = true, data = userGroups.OrderBy(x => x.Group) }, JsonRequestBehavior.AllowGet)); } return(Json(new { success = false, message = "LogOut" }, JsonRequestBehavior.AllowGet)); } catch (Exception exception) { return(Json(new { success = false, message = exception.Message }, JsonRequestBehavior.AllowGet)); } }
public ActionResult LoadAllUser() { try { Dictionary <int, CheckSessionData> dictionary = CheckSessionData.GetSessionValues(); int userGroupId = Convert.ToInt32(dictionary[6].Id == "" ? 0 : Convert.ToInt32(dictionary[6].Id)); if (userGroupId != 0) { _userFactory = new UserFactory(); var users = _userFactory.GetAll().Select(x => new { x.ID, x.UserFullName, x.Address, x.PhoneNo, //Group = x.SEC_UserGroup.FirstOrDefault().Name, Group = x.SEC_UserGroup.Name, User = x.UserName, x.IsActive, x.UserGroupID, x.Email, x.UserName, x.EmployeeID, x.CompanyID, x.BranchID, x.Employee.EmpName, x.Employee.DepartmentID }).ToList(); return(Json(users.OrderBy(x => x.UserFullName))); } return(Json(new { success = false, message = "LogOut" }, JsonRequestBehavior.AllowGet)); } catch (Exception exception) { return(Json(new { success = false, message = exception.Message }, JsonRequestBehavior.AllowGet)); } }
public List <SEC_UIModule> SearchUiModule(int?moduleID) { Result _result = new Result(); _moduleFactory = new ModuleFactory(); try { var list = new List <SEC_UIModule>(); if (moduleID > 0) { list = _moduleFactory.FindBy(x => x.ID == moduleID).ToList(); } else { list = _moduleFactory.GetAll().ToList(); } return(list); } catch (Exception e) { throw e; } }
public List <SEC_UIPage> SearchUiPages(int?pageID) { Result _result = new Result(); _uiPageFactory = new UiPageFactory(); try { var list = new List <SEC_UIPage>(); if (pageID > 0) { list = _uiPageFactory.FindBy(x => x.ID == pageID).ToList(); } else { list = _uiPageFactory.GetAll().ToList(); } return(list); } catch (Exception e) { throw e; } }
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 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); }
public dynamic PagePermissedList(int userGroupId) { Dictionary <int, CheckSessionData> dictionary = CheckSessionData.GetSessionValues(); int userId = Convert.ToInt32(dictionary[3].Id); try { var menu = (from map in context.SEC_UserActionMapping.Where(x => (x.IsCreate == true || x.IsDelete == true || x.IsEdit == true || x.IsSelect == true)) join uip in context.SEC_UIPage on map.UIPageID equals uip.ID join mod in context.SEC_UIModule on uip.ModuleID equals mod.ID where map.UserGroupID == userGroupId select new { ID = uip.ID, ModuleID = map.UIModuleID, UIPage = uip.UIPageName, ModuleName = mod.UIName, IsSelect = map.IsSelect, IsCreate = map.IsCreate, IsEdit = map.IsEdit, IsDelete = map.IsDelete }); _moduleFactory = new ModuleFactory(); List <SEC_UIModule> moldule = _moduleFactory.GetAll().ToList(); List <PagePermissionVM> pagePermissionList = new List <PagePermissionVM>(); foreach (var item in menu) { var pagePermission = new PagePermissionVM(); pagePermission.ModuleID = item.ModuleID; pagePermission.UIPageID = item.ID; pagePermission.Module = item.ModuleName; pagePermission.Page = item.UIPage; pagePermissionList.Add(pagePermission); if (moldule.Where(x => x.ID == item.ModuleID && (x.ParentModulIDHierarchy != null)).Count() > 0) { var getParent = moldule.Where(x => x.ID == item.ModuleID).FirstOrDefault(); if (getParent != null) { string hierarchi = getParent.ParentModulIDHierarchy; string[] words = hierarchi.Split(','); foreach (var module in words) { if (pagePermissionList.Where(x => x.Page == getParent.UIName).Count() < 1) { pagePermission = new PagePermissionVM(); pagePermission.ModuleID = item.ModuleID; pagePermission.UIPageID = item.ModuleID; pagePermission.Module = item.ModuleName; pagePermission.Page = item.ModuleName; pagePermissionList.Add(pagePermission); } } } } } return(pagePermissionList.Distinct()); } catch (Exception ex) { throw ex; } }
public Result PasswordChangeByAdminSave(ChangePasswordModel changePassword) { try { result = new Result(); result.isSucess = false; Dictionary <int, CheckSessionData> dictionary = CheckSessionData.GetSessionValues(); int userGroupID = Convert.ToInt32(dictionary[6].Id); int userId = Convert.ToInt32(dictionary[3].Id); string userName = dictionary[4].Id; if (userGroupID != 0) { _userFactory = new UserFactory(); _passwordFactory = new UserPasswordFactory(); _userGroup = new UserGroupFactory(); Encription encription = new Encription(); SEC_Password tblPassword; SEC_UserInformation tblUserInformation = new SEC_UserInformation(); SEC_UserGroup tblUserGroup = new SEC_UserGroup(); if (changePassword.FullName != "" || changePassword.UserName != "") { if (changePassword.UserName != null) { tblUserInformation = _userFactory.FindBy(x => x.UserName == changePassword.UserName).FirstOrDefault(); } tblUserGroup = _userGroup.FindBy(x => x.ID == userGroupID).FirstOrDefault(); if (tblUserGroup != null) { if (tblUserGroup.IsAdmin == false) { result.message = "You are not a Admin"; return(result); } tblPassword = _passwordFactory.GetAll().FirstOrDefault(x => x.ID == tblUserInformation.PasswordID); if (tblPassword != null) { tblPassword.OldPassword = tblPassword.NewPassword; tblPassword.NewPassword = encription.Encrypt(changePassword.NewPassword.Trim()); tblPassword.IsSelfChanged = false; tblPassword.UpdatedDate = DateTime.Now; tblPassword.UpdatedBy = userId; _passwordFactory.Edit(tblPassword); } result = _passwordFactory.Save(); if (result.isSucess) { result.message = "Changed Password Sucessfully"; return(result); } } result.message = "User cant found"; return(result); } result.message = "Password not Changed try again"; return(result); } result.message = "Logout"; } catch (Exception exception) { result.isSucess = false; result.message = exception.Message; return(result); } return(result); }