public ActionResult AddDepartmentAllocation() { UserAllocation userDepartment = new UserAllocation(); userDepartment.Departments = departmentManagement.GetAllDepartments(); return(PartialView("_UserAllocatedDepartment", userDepartment)); }
public ActionResult View(string userId, long groupNumber) { ViewBag.Title = "Add/Update User Allocation"; ViewBag.IsAddEdit = false; if (!PermissionControl.CheckPermission(UserAppPermissions.UserAllocation_Add) && !PermissionControl.CheckPermission(UserAppPermissions.UserAllocation_Edit)) { logger.Info("Don't have rights to add new Requisition"); return(Json(new { Message = Resources.Messages.MSG_RESTRICTED_ACCESS, MessageClass = MessageClass.Error, Response = false })); } var AdminUser = RoleManager.Roles.Where(x => x.Name.Equals(UserRoles.Admin)).SingleOrDefault(); var userList = UserManager.Users.Where(x => !x.IsDeleted && !(x.Roles.Select(y => y.RoleId).Contains(AdminUser.Id))).ToList(); UserReAllocationVM allocationVM = new UserReAllocationVM(); allocationVM.UserList = userList; allocationVM.UserId = userId; var userAllocatedDepartments = userAllocationManagement.GetUserAllocationByGroupNumber(groupNumber); if (userAllocatedDepartments != null && userAllocatedDepartments.Count() > 0) { var departments = departmentManagement.GetAllDepartments(); foreach (var userDept in userAllocatedDepartments) { userDept.Departments = departments; } allocationVM.UserAllocatedDepartments = userAllocatedDepartments; } return(PartialView("_AddUpdateAllocation", allocationVM)); }
public ActionResult AddEdit(string id) { ViewBag.Title = "Add/Update Users"; var roleManager = new RoleManager <IdentityRole>(new RoleStore <IdentityRole>()); var departments = departmentManagement.GetAllDepartments(); var requisition = requisitionManagement.GetAllApprovedRequisition(); var roles = RoleManager.Roles.Where(x => !x.Name.Equals("Admin")).ToList().Select(x => new Core.ViewModel.SelectListItem() { Text = x.Name, Value = x.Id }); var user = new UserVM(); user.RequisitionList = requisition; if (id != "0") { var appUser = UserManager.FindById(id); var userRoles = UserManager.GetRoles(id); IEnumerable <UserDepartment> userDepartments = userdepartmentManagement.GetAllUserDepartmentById(appUser.Id); user.Id = appUser.Id; user.FirstName = appUser.FirstName; user.LastName = appUser.LastName; user.Email = appUser.Email; user.EmployeeNumber = appUser.EmployeeNumber; user.Mobile = appUser.Mobile; user.Designation = appUser.Designation; user.UserPermissions = GetUserPermission(id); user.RequisitionID = appUser.RequisitionID; if (userDepartments != null) { foreach (var userDept in userDepartments) { userDept.Departments = departments; userDept.RolesList = roles; } user.UserDepartments = userDepartments; } } return(PartialView("_AddEditUser", user)); }
private ExcelFileProcess ProcessExpenseSheet(string path, string fileName, DateTime expenseDate) { logger.DebugFormat("Processing User Expense Sheet Name [{0}]", fileName); DataSet ds = ExcelFileReader.Read(path); DataTable table = ds.Tables[0]; table = table.Rows.Cast <DataRow>().Where(row => !row.ItemArray.All(field => field is System.DBNull || string.Compare((Convert.ToString(field)).Trim(), string.Empty) == 0)).CopyToDataTable(); if (table.Rows.Count == 0) { logger.DebugFormat("No rows found in file [{0}]", fileName); return(new ExcelFileProcess { Message = "No rows to insert.", Response = false, MessageType = MessageClass.Error }); } string missingcolumn = ExcelFileReader.CheckAllColumnExist(table, ColumnList); if (!string.IsNullOrWhiteSpace(missingcolumn)) { logger.Debug(string.Format(Resources.Messages.MSG_GENERIC_COLUMN_MISSING, missingcolumn)); return(new ExcelFileProcess { Message = string.Format(Resources.Messages.MSG_GENERIC_COLUMN_MISSING, missingcolumn), Response = false, MessageType = MessageClass.Error }); } string info = ExcelFileReader.ValidateData(table, MandatoryColumnList); if (!string.IsNullOrWhiteSpace(info)) { logger.Debug(info); return(new ExcelFileProcess { Message = info, Response = false, MessageType = MessageClass.Error }); } string errors = ExcelFileReader.ValidateAmount(table, ValidateColumnList); if (!string.IsNullOrWhiteSpace(errors)) { logger.Debug(errors); return(new ExcelFileProcess { Message = errors, Response = false, MessageType = MessageClass.Error }); } var department = departmentManagement.GetAllDepartments(); var allocation = userAllocationManagement.GetAllUsersActiveAllocations(); var users = UserManager.Users.Where(x => !x.IsDeleted).ToList(); errors = ExcelFileReader.ValidateDepartmentAndUsersAndAllocation(table, department, users, allocation); if (!string.IsNullOrWhiteSpace(errors)) { logger.Debug(errors); return(new ExcelFileProcess { Message = errors, Response = false, MessageType = MessageClass.Error }); } ExcelFileProcess process = InsertData(table, fileName, users, expenseDate, allocation); return(process); }