Beispiel #1
0
        public void CanInsertSalesInformation()
        {
            SalesInformation sale = new SalesInformation();

            var repo = new SalesInformationRepositoryDapper();

            sale.CustomerName    = "Susan Wright";
            sale.CustomerPhone   = "502-555-0117";
            sale.CustomerEmail   = "*****@*****.**";
            sale.CustomerStreet1 = "200 Merriweather Rd";
            sale.CustomerStreet2 = "Apt B";
            sale.CustomerCity    = "Louisville";
            sale.CustomerState   = "KY";
            sale.CustomerZip     = "40223";
            sale.PurchasePrice   = 18200;
            sale.PurchaseTypeID  = 2;
            sale.VehicleID       = 4;

            var dateTime = DateTime.Parse("04/20/2020");

            sale.PurchaseDate = dateTime;

            sale.Id = "00000000-0000-0000-0000-000000000000";

            repo.Insert(sale);

            Assert.AreEqual(3, sale.SalesID);
        }
Beispiel #2
0
        public void CanLoadSalesReport()
        {
            var repo = new SalesInformationRepositoryDapper();

            var sales = repo.GetSales();

            Assert.IsNotNull(sales);
        }