Esempio n. 1
0
        public void CanReturnZeroResultsOutOfDateRange()
        {
            ReportsRepositoryADO repo = new ReportsRepositoryADO();

            SalesSearchParameters testParametersOne = new SalesSearchParameters
            {
                MaxDate  = new DateTime(2015, 4, 2),
                MinDate  = new DateTime(2014, 1, 2),
                UserName = null
            };

            SalesSearchParameters testParametersTwo = new SalesSearchParameters
            {
                MaxDate  = new DateTime(2018, 4, 2),
                MinDate  = new DateTime(2017, 4, 2),
                UserName = null
            };

            List <SalesReportListingItem> searchedSalesReportOne = repo.SearchSalesReports(testParametersOne).ToList();

            List <SalesReportListingItem> searchedSalesReportTwo = repo.SearchSalesReports(testParametersOne).ToList();

            Assert.AreEqual(0, searchedSalesReportOne.Count);
            Assert.AreEqual(0, searchedSalesReportTwo.Count);
        }
Esempio n. 2
0
        public void CanGetSalesReport()
        {
            ReportsRepositoryADO repo = new ReportsRepositoryADO();

            List <SalesReportListingItem> salesReport = repo.GetSalesReport().ToList();

            Assert.AreEqual(2, salesReport.Count);

            Assert.AreEqual("11111111-1111-1111-1111-111111111111", salesReport[1].UserId);
            Assert.AreEqual("*****@*****.**", salesReport[1].UserName);
            Assert.AreEqual(2, salesReport[1].CarsSold);
            Assert.AreEqual(18000m, salesReport[1].Sales);
        }
Esempio n. 3
0
        public void CanGetInventoryReport()
        {
            ReportsRepositoryADO repo = new ReportsRepositoryADO();

            List <InventoryReportListingItem> inventoryReportsList = repo.GetInventory().ToList();

            Assert.AreEqual(10, inventoryReportsList.Count);

            Assert.IsTrue(inventoryReportsList[8].IsNew);
            Assert.AreEqual("Acura", inventoryReportsList[8].Make);
            Assert.AreEqual("TLX", inventoryReportsList[8].Model);
            Assert.AreEqual(0, inventoryReportsList[8].UnitsInStock);
            Assert.AreEqual(34150m, inventoryReportsList[8].StockValue);
            Assert.AreEqual(new DateTime(2020, 1, 1), inventoryReportsList[8].Year);
        }
Esempio n. 4
0
        public void CanReturnZeroResultsWrongUserName()
        {
            ReportsRepositoryADO repo = new ReportsRepositoryADO();

            SalesSearchParameters parameters = new SalesSearchParameters
            {
                MaxDate  = new DateTime(2017, 4, 2),
                MinDate  = new DateTime(2017, 1, 2),
                UserName = "******"
            };

            List <SalesReportListingItem> searchedSalesReport = repo.SearchSalesReports(parameters).ToList();

            Assert.AreEqual(0, searchedSalesReport.Count);
        }
Esempio n. 5
0
        public void CanSearchOnMinDateChange()
        {
            ReportsRepositoryADO repo = new ReportsRepositoryADO();

            SalesSearchParameters parameters = new SalesSearchParameters
            {
                MaxDate  = null,
                MinDate  = new DateTime(2017, 1, 1),
                UserName = null
            };

            List <SalesReportListingItem> searchedSalesReport = repo.SearchSalesReports(parameters).ToList();

            Assert.AreEqual(1, searchedSalesReport.Count);

            Assert.AreEqual(27000, searchedSalesReport[0].Sales);
            Assert.AreEqual("00000000-0000-0000-0000-000000000000", searchedSalesReport[0].UserId);
            Assert.AreEqual("*****@*****.**", searchedSalesReport[0].UserName);
        }
Esempio n. 6
0
        public void CanSearchOnMaxDateChange()
        {
            ReportsRepositoryADO repo = new ReportsRepositoryADO();

            SalesSearchParameters parameters = new SalesSearchParameters
            {
                MaxDate  = new DateTime(2020, 1, 1),
                MinDate  = null,
                UserName = null
            };

            List <SalesReportListingItem> searchedSalesReport = repo.SearchSalesReports(parameters).ToList();

            Assert.AreEqual(2, searchedSalesReport.Count);

            Assert.AreEqual(18000m, searchedSalesReport[1].Sales);
            Assert.AreEqual("11111111-1111-1111-1111-111111111111", searchedSalesReport[1].UserId);
            Assert.AreEqual("*****@*****.**", searchedSalesReport[1].UserName);
        }