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;
                }
            }
        }
示例#2
0
        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);
        }
示例#4
0
        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)));
            }
        }
示例#5
0
        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));
            }
        }
示例#6
0
        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));
        }