public string Insert(StaffsDto dto) { var conn = _baseInterface.GetConnection(); var transaction = conn.BeginTransaction(); string message = ""; try { var photoStorage = new PhotoStorages(); photoStorage.Photo = null; photoStorage.PhotoLocation = null; int photoStorageId = _photoStorageRepository.Insert(photoStorage, transaction, conn); var user = dto.ToUserEntity(); user.PhotoStorageId = photoStorageId; user.Password = Web.Repositories.Utitlities.Security.GetMd5Sum(dto.Password); user.CreatedDate = DateTime.Now; user.CreatedBy = Convert.ToInt32(HttpContext.Current.Session["UserId"]); int userId = _usersRepository.Insert(user, transaction, conn); var staff = dto.ToEntity(); staff.UserId = userId; int staffId = _staffsRepository.Insert(staff, transaction, conn); message = _messageClass.ShowSuccessMessage(staffId); transaction.Commit(); } catch (SqlException ex) { message = _messageClass.ShowErrorMessage(string.Format("{0} ~ {1}", ex.Number.ToString(), ex.Message)); transaction.Rollback(); } return(message); }
public async Task <string> Update(StaffsDto dto) { if (!menu.ModifyAccess) { return(null); } return(await _staffsService.Update(dto)); }
public string Insert(StaffsDto dto) { if (!menu.WriteAccess) { return(null); } return(_staffsService.Insert(dto)); }
public async Task <ActionResult> AddStaff() { if (!menu.WriteAccess) { return(RedirectToAction("Logout", "Account")); } var obj = new StaffsDto(); obj = await _staffsService.DropDownMethods(obj); return(View("AddModifyStaff", obj)); }
public async Task <StaffsDto> DropDownMethods(StaffsDto dto) { if (dto is null) { dto = new StaffsDto(); } dto.Roles = await _administrationService.GetActiveRoleAsync(); dto.Designations = await _administrationService.GetActiveDesignationAsync(); dto.Departments = await _administrationService.GetActiveDepartmentAsync(); dto.Genders = await _administrationService.GetActiveGenderAsync(); dto.UserStatus = await _administrationService.GetActiveUserStatusAsync(); return(dto); }
public async Task <string> Update(StaffsDto dto) { SqlTransaction transaction; var conn = _baseInterface.GetConnection(); transaction = conn.BeginTransaction(); string message = ""; try { var staff = await _staffsRepository.GetStaffByIdAsync(dto.StaffId); if (staff == null) { return(null); } var user = await _usersRepository.GetUserByIdAsync(staff.UserId); user.UserName = dto.UserName; user.EmailAddress = dto.EmailAddress; user.ContactNumber = dto.ContactNumber; user.UserStatusId = dto.UserStatusId; user.UpdatedBy = Convert.ToInt32(HttpContext.Current.Session["UserId"]); user.UpdatedDate = DateTime.Now; _usersRepository.Update(user, transaction, conn); var staffEntity = dto.ToEntity(); staffEntity.UserId = user.UserId; int staffId = _staffsRepository.Update(staffEntity, transaction, conn); message = _messageClass.ShowSuccessMessage(staffId); transaction.Commit(); } catch (SqlException ex) { message = _messageClass.ShowErrorMessage(string.Format("{0} ~ {1}", ex.Number.ToString(), ex.Message)); transaction.Rollback(); } return(message); }
public static Users ToUserEntity(this StaffsDto dto) { if (dto == null) { return(null); } return(new Users { UserId = dto.UserId, UserTypeId = 2, PhotoStorageId = dto.PhotoStorageId, UserName = dto.UserName, Password = dto.Password, EmailAddress = dto.EmailAddress, ContactNumber = dto.ContactNumber, CreatedBy = dto.CreatedBy, CreatedDate = dto.CreatedDate, UpdatedBy = dto.UpdatedBy, UpdatedDate = dto.UpdatedDate, UserStatusId = dto.UserStatusId, }); }
public static Staffs ToEntity(this StaffsDto dto) { if (dto == null) { return(null); } return(new Staffs { StaffId = dto.StaffId, UserId = dto.UserId, RoleId = dto.RoleId, DesignationId = dto.DesignationId, DepartmentId = dto.DepartmentId, StaffName = dto.StaffName, GenderId = dto.GenderId, TemporaryAddress = dto.TemporaryAddress, PermanentAddress = dto.PermanentAddress, CitizenshipNumber = dto.CitizenshipNumber, PanNumber = dto.PanNumber, BasicSalary = dto.BasicSalary, }); }