public async Task <CheckingStatus> Get(long Id) { CheckingStatus CheckingStatus = await UOW.CheckingStatusRepository.Get(Id); if (CheckingStatus == null) { return(null); } return(CheckingStatus); }
private CheckingStatus ConvertDTOToEntity(CheckingStatus_CheckingStatusDTO CheckingStatus_CheckingStatusDTO) { CheckingStatus CheckingStatus = new CheckingStatus(); CheckingStatus.Id = CheckingStatus_CheckingStatusDTO.Id; CheckingStatus.Code = CheckingStatus_CheckingStatusDTO.Code; CheckingStatus.Name = CheckingStatus_CheckingStatusDTO.Name; CheckingStatus.BaseLanguage = CurrentContext.Language; return(CheckingStatus); }
public PlaceChecking_CheckingStatusDTO(CheckingStatus CheckingStatus) { this.Id = CheckingStatus.Id; this.Code = CheckingStatus.Code; this.Name = CheckingStatus.Name; this.Errors = CheckingStatus.Errors; }
public async Task <bool> Create(CheckingStatus CheckingStatus) { CheckingStatusDAO CheckingStatusDAO = new CheckingStatusDAO(); CheckingStatusDAO.Id = CheckingStatus.Id; CheckingStatusDAO.Code = CheckingStatus.Code; CheckingStatusDAO.Name = CheckingStatus.Name; DataContext.CheckingStatus.Add(CheckingStatusDAO); await DataContext.SaveChangesAsync(); CheckingStatus.Id = CheckingStatusDAO.Id; await SaveReference(CheckingStatus); return(true); }
public async Task <ActionResult <CheckingStatus_CheckingStatusDTO> > Get([FromBody] CheckingStatus_CheckingStatusDTO CheckingStatus_CheckingStatusDTO) { if (!ModelState.IsValid) { throw new BindException(ModelState); } if (!await HasPermission(CheckingStatus_CheckingStatusDTO.Id)) { return(Forbid()); } CheckingStatus CheckingStatus = await CheckingStatusService.Get(CheckingStatus_CheckingStatusDTO.Id); return(new CheckingStatus_CheckingStatusDTO(CheckingStatus)); }
public async Task <bool> Update(CheckingStatus CheckingStatus) { CheckingStatusDAO CheckingStatusDAO = DataContext.CheckingStatus.Where(x => x.Id == CheckingStatus.Id).FirstOrDefault(); if (CheckingStatusDAO == null) { return(false); } CheckingStatusDAO.Id = CheckingStatus.Id; CheckingStatusDAO.Code = CheckingStatus.Code; CheckingStatusDAO.Name = CheckingStatus.Name; await DataContext.SaveChangesAsync(); await SaveReference(CheckingStatus); return(true); }
public async Task <CheckingStatus> Get(long Id) { CheckingStatus CheckingStatus = await DataContext.CheckingStatus.AsNoTracking() .Where(x => x.Id == Id) .Select(x => new CheckingStatus() { Id = x.Id, Code = x.Code, Name = x.Name, }).FirstOrDefaultAsync(); if (CheckingStatus == null) { return(null); } return(CheckingStatus); }
public async Task <bool> ValidateId(CheckingStatus CheckingStatus) { CheckingStatusFilter CheckingStatusFilter = new CheckingStatusFilter { Skip = 0, Take = 10, Id = new IdFilter { Equal = CheckingStatus.Id }, Selects = CheckingStatusSelect.Id }; int count = await UOW.CheckingStatusRepository.Count(CheckingStatusFilter); if (count == 0) { CheckingStatus.AddError(nameof(CheckingStatusValidator), nameof(CheckingStatus.Id), ErrorCode.IdNotExisted); } return(count == 1); }
public async Task <CheckingStatus> Delete(CheckingStatus CheckingStatus) { if (!await CheckingStatusValidator.Delete(CheckingStatus)) { return(CheckingStatus); } try { await UOW.CheckingStatusRepository.Delete(CheckingStatus); await Logging.CreateAuditLog(new { }, CheckingStatus, nameof(CheckingStatusService)); return(CheckingStatus); } catch (Exception ex) { await Logging.CreateSystemLog(ex, nameof(CheckingStatusService)); } return(null); }
public async Task <CheckingStatus> Update(CheckingStatus CheckingStatus) { if (!await CheckingStatusValidator.Update(CheckingStatus)) { return(CheckingStatus); } try { var oldData = await UOW.CheckingStatusRepository.Get(CheckingStatus.Id); await UOW.CheckingStatusRepository.Update(CheckingStatus); CheckingStatus = await UOW.CheckingStatusRepository.Get(CheckingStatus.Id); await Logging.CreateAuditLog(CheckingStatus, oldData, nameof(CheckingStatusService)); return(CheckingStatus); } catch (Exception ex) { await Logging.CreateSystemLog(ex, nameof(CheckingStatusService)); } return(null); }
private async Task SaveReference(CheckingStatus CheckingStatus) { }
public async Task <bool> Delete(CheckingStatus CheckingStatus) { await DataContext.CheckingStatus.Where(x => x.Id == CheckingStatus.Id).DeleteFromQueryAsync(); return(true); }
public async Task <ActionResult> Import(IFormFile file) { if (!ModelState.IsValid) { throw new BindException(ModelState); } List <CheckingStatus> CheckingStatuses = new List <CheckingStatus>(); using (ExcelPackage excelPackage = new ExcelPackage(file.OpenReadStream())) { ExcelWorksheet worksheet = excelPackage.Workbook.Worksheets.FirstOrDefault(); if (worksheet == null) { return(Ok(CheckingStatuses)); } int StartColumn = 1; int StartRow = 1; int IdColumn = 0 + StartColumn; int CodeColumn = 1 + StartColumn; int NameColumn = 2 + StartColumn; for (int i = StartRow; i <= worksheet.Dimension.End.Row; i++) { if (string.IsNullOrEmpty(worksheet.Cells[i + StartRow, StartColumn].Value?.ToString())) { break; } string IdValue = worksheet.Cells[i + StartRow, IdColumn].Value?.ToString(); string CodeValue = worksheet.Cells[i + StartRow, CodeColumn].Value?.ToString(); string NameValue = worksheet.Cells[i + StartRow, NameColumn].Value?.ToString(); CheckingStatus CheckingStatus = new CheckingStatus(); CheckingStatus.Code = CodeValue; CheckingStatus.Name = NameValue; CheckingStatuses.Add(CheckingStatus); } } CheckingStatuses = await CheckingStatusService.Import(CheckingStatuses); if (CheckingStatuses.All(x => x.IsValidated)) { return(Ok(true)); } else { List <string> Errors = new List <string>(); for (int i = 0; i < CheckingStatuses.Count; i++) { CheckingStatus CheckingStatus = CheckingStatuses[i]; if (!CheckingStatus.IsValidated) { string Error = $"Dòng {i + 2} có lỗi:"; if (CheckingStatus.Errors.ContainsKey(nameof(CheckingStatus.Id))) { Error += CheckingStatus.Errors[nameof(CheckingStatus.Id)]; } if (CheckingStatus.Errors.ContainsKey(nameof(CheckingStatus.Code))) { Error += CheckingStatus.Errors[nameof(CheckingStatus.Code)]; } if (CheckingStatus.Errors.ContainsKey(nameof(CheckingStatus.Name))) { Error += CheckingStatus.Errors[nameof(CheckingStatus.Name)]; } Errors.Add(Error); } } return(BadRequest(Errors)); } }
public async Task <bool> Create(CheckingStatus CheckingStatus) { return(CheckingStatus.IsValidated); }
public async Task <ActionResult> Import(IFormFile file) { if (!ModelState.IsValid) { throw new BindException(ModelState); } AppUserFilter AppUserFilter = new AppUserFilter { Skip = 0, Take = int.MaxValue, Selects = AppUserSelect.ALL }; List <AppUser> AppUsers = await AppUserService.List(AppUserFilter); PlaceFilter PlaceFilter = new PlaceFilter { Skip = 0, Take = int.MaxValue, Selects = PlaceSelect.ALL }; List <Place> Places = await PlaceService.List(PlaceFilter); CheckingStatusFilter PlaceCheckingStatusFilter = new CheckingStatusFilter { Skip = 0, Take = int.MaxValue, Selects = CheckingStatusSelect.ALL }; List <CheckingStatus> PlaceCheckingStatuses = await CheckingStatusService.List(PlaceCheckingStatusFilter); List <PlaceChecking> PlaceCheckings = new List <PlaceChecking>(); using (ExcelPackage excelPackage = new ExcelPackage(file.OpenReadStream())) { ExcelWorksheet worksheet = excelPackage.Workbook.Worksheets.FirstOrDefault(); if (worksheet == null) { return(Ok(PlaceCheckings)); } int StartColumn = 1; int StartRow = 1; int IdColumn = 0 + StartColumn; int AppUserIdColumn = 1 + StartColumn; int PlaceIdColumn = 2 + StartColumn; int PlaceCheckingStatusIdColumn = 3 + StartColumn; int CheckInAtColumn = 4 + StartColumn; int CheckOutAtColumn = 5 + StartColumn; for (int i = StartRow; i <= worksheet.Dimension.End.Row; i++) { if (string.IsNullOrEmpty(worksheet.Cells[i + StartRow, StartColumn].Value?.ToString())) { break; } string IdValue = worksheet.Cells[i + StartRow, IdColumn].Value?.ToString(); string AppUserIdValue = worksheet.Cells[i + StartRow, AppUserIdColumn].Value?.ToString(); string PlaceIdValue = worksheet.Cells[i + StartRow, PlaceIdColumn].Value?.ToString(); string PlaceCheckingStatusIdValue = worksheet.Cells[i + StartRow, PlaceCheckingStatusIdColumn].Value?.ToString(); string CheckInAtValue = worksheet.Cells[i + StartRow, CheckInAtColumn].Value?.ToString(); string CheckOutAtValue = worksheet.Cells[i + StartRow, CheckOutAtColumn].Value?.ToString(); PlaceChecking PlaceChecking = new PlaceChecking(); PlaceChecking.CheckInAt = DateTime.TryParse(CheckInAtValue, out DateTime CheckInAt) ? CheckInAt : DateTime.Now; PlaceChecking.CheckOutAt = DateTime.TryParse(CheckOutAtValue, out DateTime CheckOutAt) ? CheckOutAt : DateTime.Now; AppUser AppUser = AppUsers.Where(x => x.Id.ToString() == AppUserIdValue).FirstOrDefault(); PlaceChecking.AppUserId = AppUser == null ? 0 : AppUser.Id; PlaceChecking.AppUser = AppUser; Place Place = Places.Where(x => x.Id.ToString() == PlaceIdValue).FirstOrDefault(); PlaceChecking.PlaceId = Place == null ? 0 : Place.Id; PlaceChecking.Place = Place; CheckingStatus PlaceCheckingStatus = PlaceCheckingStatuses.Where(x => x.Id.ToString() == PlaceCheckingStatusIdValue).FirstOrDefault(); PlaceChecking.PlaceCheckingStatusId = PlaceCheckingStatus == null ? 0 : PlaceCheckingStatus.Id; PlaceChecking.PlaceCheckingStatus = PlaceCheckingStatus; PlaceCheckings.Add(PlaceChecking); } } PlaceCheckings = await PlaceCheckingService.Import(PlaceCheckings); if (PlaceCheckings.All(x => x.IsValidated)) { return(Ok(true)); } else { List <string> Errors = new List <string>(); for (int i = 0; i < PlaceCheckings.Count; i++) { PlaceChecking PlaceChecking = PlaceCheckings[i]; if (!PlaceChecking.IsValidated) { string Error = $"Dòng {i + 2} có lỗi:"; if (PlaceChecking.Errors.ContainsKey(nameof(PlaceChecking.Id))) { Error += PlaceChecking.Errors[nameof(PlaceChecking.Id)]; } if (PlaceChecking.Errors.ContainsKey(nameof(PlaceChecking.AppUserId))) { Error += PlaceChecking.Errors[nameof(PlaceChecking.AppUserId)]; } if (PlaceChecking.Errors.ContainsKey(nameof(PlaceChecking.PlaceId))) { Error += PlaceChecking.Errors[nameof(PlaceChecking.PlaceId)]; } if (PlaceChecking.Errors.ContainsKey(nameof(PlaceChecking.PlaceCheckingStatusId))) { Error += PlaceChecking.Errors[nameof(PlaceChecking.PlaceCheckingStatusId)]; } if (PlaceChecking.Errors.ContainsKey(nameof(PlaceChecking.CheckInAt))) { Error += PlaceChecking.Errors[nameof(PlaceChecking.CheckInAt)]; } if (PlaceChecking.Errors.ContainsKey(nameof(PlaceChecking.CheckOutAt))) { Error += PlaceChecking.Errors[nameof(PlaceChecking.CheckOutAt)]; } Errors.Add(Error); } } return(BadRequest(Errors)); } }