public async Task ShouldSuccessGetReportXls()
        {
            var dbContext       = GetDbContext(GetCurrentMethod());
            var serviceProvider = GetServiceProvider(GetCurrentMethod()).Object;

            var unitPaymentCorrectionFacade = new UnitPaymentPriceCorrectionNoteFacade(serviceProvider, dbContext);

            var correctionDataUtil = CorrectionDataUtil(unitPaymentCorrectionFacade, GetCurrentMethod(), serviceProvider);

            var correctionTestData = await correctionDataUtil.GetTestData();

            var service = new PurchaseMonitoringService(dbContext);
            var result  = await service.GenerateExcel(null, null, null, null, 0, null, null, DateTimeOffset.MinValue, DateTimeOffset.Now, 0, null, 1);

            Assert.NotNull(result);
        }
        public async Task ShouldSuccessGetReportWithFilter()
        {
            var dbContext       = GetDbContext(GetCurrentMethod());
            var serviceProvider = GetServiceProvider(GetCurrentMethod()).Object;

            var unitPaymentCorrectionFacade = new UnitPaymentPriceCorrectionNoteFacade(serviceProvider, dbContext);

            var correctionDataUtil = CorrectionDataUtil(unitPaymentCorrectionFacade, GetCurrentMethod(), serviceProvider);

            var correctionTestData = await correctionDataUtil.GetTestData();

            var purchaseRequest = await dbContext.PurchaseRequests.FirstOrDefaultAsync();

            var internalPurchaseOrder = await dbContext.InternalPurchaseOrders.FirstOrDefaultAsync(f => f.PRId == purchaseRequest.Id.ToString());

            var service = new PurchaseMonitoringService(dbContext);
            var result  = await service.GetReport(purchaseRequest.UnitId, purchaseRequest.CategoryId, purchaseRequest.DivisionId, purchaseRequest.BudgetId, purchaseRequest.Id, internalPurchaseOrder.CreatedBy, null, DateTimeOffset.MinValue, DateTimeOffset.Now, 0, null, 1, 25);

            Assert.NotEqual(0, result.Total);
        }
        public async Task ShouldSuccessGetReport_noCorrection()
        {
            var dbContext       = GetDbContext(GetCurrentMethod());
            var serviceProvider = GetServiceProvider(GetCurrentMethod()).Object;

            var unitPaymentCorrectionFacade = new UnitPaymentPriceCorrectionNoteFacade(serviceProvider, dbContext);

            var correctionDataUtil = CorrectionDataUtil(unitPaymentCorrectionFacade, GetCurrentMethod(), serviceProvider);

            var correctionTestData = await correctionDataUtil.GetNewData();

            correctionTestData.CorrectionType = "";

            await unitPaymentCorrectionFacade.Create(correctionTestData, true, "Unit Test", 7);

            var service = new PurchaseMonitoringService(dbContext);
            var result  = await service.GetReport(null, null, null, null, 0, null, null, DateTimeOffset.MinValue, DateTimeOffset.Now, null, null, 0, null, 1, 25);

            Assert.NotEqual(0, result.Total);
            //Assert.NotNull(result.Data);
        }