public async void Get_Success_Excel()
        {
            var dbContext       = DbContext(GetCurrentMethod());
            var serviceProvider = GetServiceProviderMock(dbContext).Object;

            CostCalculationGarmentFacade costCalculationGarmentFacade = new CostCalculationGarmentFacade(serviceProvider, dbContext);

            var data = await DataUtil(costCalculationGarmentFacade, serviceProvider, dbContext).GetTestData();

            var acceptedBy = "acceptedBy";
            await costCalculationGarmentFacade.AcceptanceCC(new List <long> {
                data.Id
            }, acceptedBy);

            var filter = new
            {
                section           = data.Section,
                roNo              = data.RO_Number,
                buyer             = data.BuyerBrandCode,
                acceptedDateStart = data.ROAcceptedDate.AddDays(-30),
                acceptedDateEnd   = data.ROAcceptedDate.AddDays(30),
            };

            var facade   = new AcceptedROReportFacade(serviceProvider);
            var Response = facade.GenerateExcel(filter: JsonConvert.SerializeObject(filter));

            Assert.NotNull(Response.Item2);
        }
        public void Get_Success_Empty_Excel()
        {
            var dbContext       = DbContext(GetCurrentMethod());
            var serviceProvider = GetServiceProviderMock(dbContext).Object;

            var facade = new AcceptedROReportFacade(serviceProvider);

            var Response = facade.GenerateExcel();

            Assert.NotNull(Response.Item2);
        }