public async Task <FileUploadRespObj> Handle(UploadStateCommand request, CancellationToken cancellationToken) { try { var apiResponse = new FileUploadRespObj { Status = new APIResponseStatus { IsSuccessful = false, Message = new APIResponseMessage() } }; var files = _accessor.HttpContext.Request.Form.Files; var byteList = new List <byte[]>(); foreach (var fileBit in files) { if (fileBit.Length > 0) { using (var ms = new MemoryStream()) { await fileBit.CopyToAsync(ms); byteList.Add(ms.ToArray()); } } } var _Country = await _repo.GetAllCountry(); var uploadedRecord = new List <CommonLookupsObj>(); ExcelPackage.LicenseContext = LicenseContext.NonCommercial; if (byteList.Count() > 0) { foreach (var byteItem in byteList) { using (MemoryStream stream = new MemoryStream(byteItem)) using (ExcelPackage excelPackage = new ExcelPackage(stream)) { //Use first sheet by default ExcelWorksheet workSheet = excelPackage.Workbook.Worksheets[0]; int totalRows = workSheet.Dimension.Rows; int totalColumns = workSheet.Dimension.Columns; if (totalColumns != 3) { apiResponse.Status.Message.FriendlyMessage = $"Three (3) Columns Expected"; return(apiResponse); } //First row is considered as the header for (int i = 2; i <= totalRows; i++) { var lkp = new CommonLookupsObj { ExcelLineNumber = i, LookupName = workSheet.Cells[i, 1]?.Value != null ? workSheet.Cells[i, 1]?.Value.ToString() : string.Empty, Code = workSheet.Cells[i, 2]?.Value != null ? workSheet.Cells[i, 2]?.Value.ToString() : string.Empty, ParentName = workSheet.Cells[i, 3]?.Value != null ? workSheet.Cells[i, 3]?.Value.ToString() : string.Empty, }; uploadedRecord.Add(lkp); } } } } var _StateList = await _repo.GetAllStateAsync(); if (uploadedRecord.Count > 0) { foreach (var item in uploadedRecord) { if (string.IsNullOrEmpty(item.Code)) { apiResponse.Status.Message.FriendlyMessage = $"State Code can not be empty on line {item.ExcelLineNumber}"; return(apiResponse); } if (string.IsNullOrEmpty(item.LookupName)) { apiResponse.Status.Message.FriendlyMessage = $"State Name can not be empty on line {item.ExcelLineNumber}"; return(apiResponse); } if (string.IsNullOrEmpty(item.ParentName)) { apiResponse.Status.Message.FriendlyMessage = $"Country Name can not be empty on line {item.ExcelLineNumber}"; return(apiResponse); } else { var country = _Country.FirstOrDefault(d => d.CountryCode.Trim().ToLower() == item.ParentName.Trim().ToLower()); if (country == null) { apiResponse.Status.Message.FriendlyMessage = $"Country name unidentified on line {item.ExcelLineNumber}"; return(apiResponse); } item.ParentId = country.CountryId; } var currentState = _StateList.FirstOrDefault(c => c.StateCode.ToLower() == item.Code.ToLower() && c.Deleted == false); if (currentState == null) { var State = new cor_state(); State.StateName = item.LookupName; State.CountryId = item.ParentId; State.StateCode = item.Code; await _repo.AddUpdateStateAsync(State); } else { currentState.StateName = item.LookupName; currentState.CountryId = item.ParentId; currentState.StateCode = item.Code; await _repo.AddUpdateStateAsync(currentState); } } } apiResponse.Status.IsSuccessful = true; apiResponse.Status.Message.FriendlyMessage = "Successful"; return(apiResponse); } catch (Exception ex) { throw new Exception(ex.Message); } }
public async Task <LookUpRegRespObj> Handle(AddUpdateStateCommand request, CancellationToken cancellationToken) { try { var item = new cor_state { Active = true, StateCode = request.Code, StateId = request.StateId, CountryId = request.CountryId, StateName = request.Name, CreatedOn = DateTime.Now, Deleted = false, CreatedBy = "" }; var addedOrUpdated = await _repo.AddUpdateStateAsync(item); if (!addedOrUpdated) { return new LookUpRegRespObj { Status = new APIResponseStatus { IsSuccessful = false, Message = new APIResponseMessage { FriendlyMessage = "Unable to add item" } } } } ; return(new LookUpRegRespObj { LookUpId = item.StateId, Status = new APIResponseStatus { IsSuccessful = true, Message = new APIResponseMessage { FriendlyMessage = "Item added successfully" } } }); } catch (Exception ex) { #region Log error to file return(new LookUpRegRespObj { Status = new APIResponseStatus { IsSuccessful = false, Message = new APIResponseMessage { FriendlyMessage = "Error occured!! Unable to process request", TechnicalMessage = $"{ex?.Message ?? ex?.InnerException?.Message} ErrorStack : {ex?.StackTrace}" } } }); #endregion } }