public void TestCommunityOnboardingSuccess() { using (var dbContext = GetConnection()) { string path = GetDataPath("community bulk sheet.xlsx"); Guid communityId = Guid.Parse("6B8CC193-1F72-4B50-AD49-65C470405186"); Guid contactId = Guid.Parse("862c17f4-6522-4806-9c63-b345bd4e4c07"); var serviceFactory = new ServiceFactory(dbContext, contactId); CommunityImport communityOnboarding = new CommunityImport(serviceFactory, communityId, ""); communityOnboarding.Import(path); } }
public ActionResult Import(Guid communityId, [FromForm] AttachViewModel attachViewModel) { try { Guid id = Guid.Parse(attachViewModel.Id); FileUploadManager fileUploadManager = new FileUploadManager(attachViewModel.Attachment); string fileName = fileUploadManager.FileName; var outputFilePath = FileUploadManager.GetTempFolderPath(Guid.NewGuid().ToString() + ".xlsx"); var byteArray = fileUploadManager.GetByteArray(); ServiceFactory serviceFactory = new ServiceFactory(this._faciTechDbContext, this._contactId); CommunityImport communityOnboarding = new CommunityImport(serviceFactory, id, outputFilePath); var isValid = communityOnboarding.Import(byteArray); FileManager fileManager = new FileManager(outputFilePath); var outputFile = new Attachment() { FileName = fileName, FileContent = fileManager.GetByteArray(), TableName = "Community", TableId = _communityId, MimeType = attachViewModel.Attachment.ContentType }; _attachmentService.Create(outputFile, true); _communityService.UpdateLastUpload(communityId, fileName); fileUploadManager.DeleteFile(); return(Ok(new ApiResponse(new { IsAllValid = isValid, FileName = fileName }, ApiStatus.Success))); } catch (Exception ex) { return(new UnknownErrorResult(ex, base._errorEnabled)); } }