Exemple #1
0
        public void EmptyTablegOrderDetailsTest()
        {
            DALDB db = new DALDB();
            int   n  = 10;

            Assert.AreEqual(true, db.OrderDetails(n));
        }
Exemple #2
0
        public void EmptyTableCustOrdersDetailTest()
        {
            DALDB db = new DALDB();
            int   s  = -9;

            Assert.AreEqual(true, db.CustOrdersDetail(s));
        }
Exemple #3
0
        public void OrderDetailsTest()
        {
            DALDB db = new DALDB();
            int   n  = 10248;

            Assert.AreEqual(true, db.OrderDetails(n));
        }
Exemple #4
0
        public void EmptyTableCustOrderHistTest()
        {
            DALDB  db = new DALDB();
            string s  = "test";

            Assert.AreEqual(true, db.CustOrderHist(s));
        }
Exemple #5
0
        public void CustOrdersDetailTest()
        {
            DALDB db = new DALDB();
            int   s  = 10250;

            Assert.AreEqual(true, db.CustOrdersDetail(s));
        }
Exemple #6
0
        public void CustOrderHistTest()
        {
            DALDB  db = new DALDB();
            string s  = "RATTC";

            Assert.AreEqual(true, db.CustOrderHist(s));
        }
Exemple #7
0
        public void GetWrongOrderTest()
        {
            DALDB db = new DALDB();
            int   id = -15;

            Assert.AreEqual(false, db.GetOrder(id));
        }
Exemple #8
0
        public void GetOrderTest()
        {
            DALDB db = new DALDB();
            int   id = 12083;

            Assert.AreEqual(true, db.GetOrder(id));
        }
Exemple #9
0
        public void SendWrongOrderTest()
        {
            DALDB db = new DALDB();
            int   id = 0;

            Assert.AreEqual(false, db.SendOrder(id));
        }
Exemple #10
0
        public void CreateWrongOrderTest()
        {
            DALDB db = new DALDB();

            string   CustomerID     = "";
            int      EmployeeID     = 0;
            DateTime OrderDate      = DateTime.MinValue;
            DateTime RequiredDate   = DateTime.MinValue;
            DateTime ShippedDate    = DateTime.MinValue;
            int      ShipVia        = -1;
            float    Freight        = -1;
            string   ShipName       = "Rattlesnake Canyon Grocery";
            string   ShipAddress    = "2817 Milton Dr.";
            string   ShipCity       = "Albuquerque";
            string   ShipRegion     = "NM";
            string   ShipPostalCode = "87110";
            string   ShipCountry    = "USA";

            Orders note = new Orders(CustomerID, EmployeeID, OrderDate,
                                     RequiredDate, ShippedDate, ShipVia, Freight, ShipName, ShipAddress,
                                     ShipCity, ShipRegion, ShipPostalCode, ShipCountry);

            Assert.AreEqual(false, db.CreateOrder(note));
        }
Exemple #11
0
        public void ShowOrdersTest()
        {
            DALDB db = new DALDB();

            Assert.AreEqual(true, db.ShowOrders());
        }