public async Task <int> CreateDocument(string fileName, string fileSize, byte[] bytes, string ext, int workflowId, string webUrl) { var newDoc = new Document { FileName = fileName.ToUpper(), FileSize = fileSize, Content = bytes, Type = ext.ToUpper(), CreatedDate = DateTime.Now, IsProcessed = false, WebUrl = webUrl, WorkflowId = workflowId }; using (var da = new DocumentDataAccess(conStr)) { try { return(await da.CreateAsync(newDoc)); } catch (Exception ex) { throw ex; } } }
public async Task <IEnumerable <Dictionary <string, object> > > ExecuteSourceOperation(ActiveOperation ops) { // TODO // 1) Read file content from blob storage // 2> Return List from excel data var intermediateJson = JsonConvert.DeserializeObject <string>(ops.Content); var content = JsonConvert.DeserializeObject <ExcelDocument>(intermediateJson); using (var da = new DocumentDataAccess(_conStr)) { var doc = await da.Get(Convert.ToInt32(content.DocumentId)); if (doc != null) { var bs = new BlobStorageService(blobContainer); var blobContent = await bs.GetBlob(doc.WebUrl); var excelData = new ExcelManager().ExtractData(blobContent); return(excelData); } } return(null); }
public void CreateDocumentBL_WithParameters_Ok() { IDocumentDataAccess documentDataAccess = new DocumentDataAccess(); IUserDataAccess userDataAccess = new UserDataAccess(); IDocumentBusinessLogic documentBL = new DocumentBusinessLogic(documentDataAccess, userDataAccess); Assert.IsNotNull(documentBL); }
public static async Task <IActionResult> ConnectorGet( [HttpTrigger(AuthorizationLevel.Anonymous, "get", Route = "documents")] HttpRequest req, ILogger log) { using (var da = new DocumentDataAccess(conStr)) { var result = await da.Get(); return(new OkObjectResult(result.ToList().OrderByDescending(p => p.CreatedDate))); } }
public StandardRelationsInfo GetStandardRelations(Guid id) { using (var uow = Read()) { var dataAccess = new StandardDataAccess(uow); var relations = dataAccess.GetStandardRelations(id); var authorities = new DataAccessBase <Data.AcademicBenchmark.Model.Authority>(uow).GetAll(); var document = new DocumentDataAccess(uow).GetAll(); return(StandardRelationsInfo.Create(relations, authorities, document)); } }
public IList <StandardRelationsInfo> GetStandardsRelations(IList <Guid> ids) { using (var uow = Read()) { var result = new List <StandardRelationsInfo>(); var standardDA = new StandardDataAccess(uow); var authorities = new DataAccessBase <Data.AcademicBenchmark.Model.Authority>(uow).GetAll(); var docs = new DocumentDataAccess(uow).GetAll(); foreach (var id in ids) { var relation = standardDA.GetStandardRelations(id); result.Add(StandardRelationsInfo.Create(relation, authorities, docs)); } return(result); } }
public void IntegrationTest_ExpectedParameters_Ok() { DocumentDataAccess documentDA = new DocumentDataAccess(); UserDataAccess userDA = new UserDataAccess(); DocumentBusinessLogic documentBL = new DocumentBusinessLogic(documentDA, userDA); Document document1 = Utils.CreateDocumentForTest(); Document document2 = Utils.CreateDocumentForTest(); documentBL.AddDocument(document1); documentBL.AddDocument(document2); document2.AddDocumentParagraphAtLast(paragraph); documentBL.ModifyDocument(document2); documentBL.DeleteDocument(document1.Id); Document document2Obtained = documentBL.GetDocument(document2.Id); IList <Document> documentsObtained = documentBL.GetDocuments(); Assert.IsTrue(!documentsObtained.Contains(document1) && documentsObtained.Contains(document2Obtained)); }