public IActionResult SicCodeUploadPost(AdminFileUploadViewModel viewModel) { if (!ReferenceDataHelper.TryParseCsvFileWithHeadings( viewModel.File, new[] { "SicCodeId", "SicSectionId", "Description", "Synonyms" }, out List <SicCode> sicCodesFromUploadFile, out string errorMessage)) { viewModel.AddErrorFor(m => m.File, errorMessage); return(View("SicCodeUpload", viewModel)); } List <SicCode> sicCodesFromDatabase = dataRepository.GetAll <SicCode>().ToList(); var sicCodeUploadCheckViewModel = new AdminSicCodeUploadCheckViewModel { SerializedNewRecords = JsonConvert.SerializeObject(sicCodesFromUploadFile), AddsEditsDeletesSet = new AddsEditsDeletesSet <SicCode>( sicCodesFromDatabase, sicCodesFromUploadFile, s => s.SicCodeId, (s1, s2) => s1.SicSectionId == s2.SicSectionId && s1.Description == s2.Description && s1.Synonyms == s2.Synonyms, s => s.OrganisationSicCodes.Count > 0) }; return(View("SicCodeUploadCheck", sicCodeUploadCheckViewModel)); }
public IActionResult DataMigrationFromFile() { if (!IsUserAllowedToImportData()) { return(Unauthorized()); } var viewModel = new AdminFileUploadViewModel(); return(View("DataMigrationFromFile", viewModel)); }
public IActionResult ImportAllDataFromFile(AdminFileUploadViewModel viewModel) { if (!IsUserAllowedToImportData()) { return(Unauthorized()); } byte[] fileAsBytes; using (var memoryStream = new MemoryStream()) { viewModel.File.OpenReadStream().CopyTo(memoryStream); fileAsBytes = memoryStream.ToArray(); } string fileAsString = BackupHelper.Unzip(fileAsBytes); ImportDataFromJsonString(fileAsString); return(Json("Succeeded!")); }
public IActionResult SicCodeUploadGet() { var viewModel = new AdminFileUploadViewModel(); return(View("SicCodeUpload", viewModel)); }