public void SetUp() { testDataHelper = new TestDataHelper(); uploadFileRepository = new UploadFileRepository(); constituent = testDataHelper.CreateConstituent(ConstituentMother.ConstituentWithName(ConstituentNameMother.JamesFranklin())); savedUpload = testDataHelper.CreateUpload(UploadMother.Test(constituent)); }
public void ImportMapping(int fileID) { var file = UploadFileRepository.Get().Where(m => m.ID == fileID && m.IsActive == true && m.IsImported == false).FirstOrDefault(); if (file != null) { using (MemoryStream ms = new MemoryStream(file.UploadFileData)) { using (ExcelPackage excel = new ExcelPackage(ms)) { if (excel.Workbook.Worksheets.Count == 0) { throw new Exception("File Is Empty"); } else { try { List <FileMappingViewModel> fileMapping = new List <FileMappingViewModel>(); var worksheet = excel.Workbook.Worksheets.FirstOrDefault(); var start = worksheet.Dimension.Start; var end = worksheet.Dimension.End; for (int row = start.Row + 1; row <= end.Row; row++) { fileMapping.Add(new FileMappingViewModel() { SheetName = worksheet.Cells[row, 1].Text, VariableName = worksheet.Cells[row, 2].Text, Cell = worksheet.Cells[row, 3].Text, FileTypeID = file.UploadFileTypeID, VariableTypeID = (int)VariableTypes.Nvarchar }); } if (fileMapping.Count == 0) { throw new Exception("File Is not Correct"); } FileMappingRepository.ImportNewMappingData(fileMapping.Select(m => Transformer.AsDatabaseModel(m)).ToList(), file.UploadFileTypeID); UploadFileRepository.CheckAsImported(file.ID); } catch (Exception ex) { throw new Exception(ex.Message); } } } } } else { throw new Exception("File Not Found! It's already deactivated or imported!"); } }
public bool SaveExcelFileToDatabase(UploadFileViewModel model) { try { using (var ms = new MemoryStream()) { model.UploadFile.CopyTo(ms); model.FileBytes = ms.ToArray(); } model.UploadDate = DateTime.Now; model.IsActive = true; model.IsImported = false; if (UploadFileRepository.DisableActiveFileStatuses(model.FileTypeID) && UploadFileRepository.SaveExcelFileToDatabase(Transformer.AsDatabaseModel(model))) { return(true); } return(false); } catch (Exception ex) { throw new Exception(ex.Message); } }
public IEnumerable <UploadFileViewModel> GetFileList() { var data = UploadFileRepository.GetUploadFileList().Where(m => m.IsActive == true).ToList(); return(data.Select(m => Transformer.AsDatabaseModel(m))); }
public UploadServiceImpl(UploadFileRepository repository) { this.repository = repository; }