public void UpdateMethodOK() { clsOrderCollection AllOrders = new clsOrderCollection(); clsOrder TestItem = new clsOrder(); Int32 PrimaryKey = 0; TestItem.customerID = 3; TestItem.dateOrdered = DateTime.Now.Date; TestItem.deliveryAddress = "Ellistown, Amazon BHX2, LE16 1GQ"; TestItem.paid = true; TestItem.staffID = 4; TestItem.totalPrice = 15.00; AllOrders.ThisOrder = TestItem; PrimaryKey = AllOrders.Add(); TestItem.orderID = PrimaryKey; TestItem.customerID = 4; TestItem.dateOrdered = DateTime.Now.Date; TestItem.deliveryAddress = "Another Address, not Amazon"; TestItem.paid = false; TestItem.staffID = 6; TestItem.totalPrice = 18.15; AllOrders.ThisOrder = TestItem; AllOrders.Update(); AllOrders.ThisOrder.Find(PrimaryKey); Assert.AreEqual(AllOrders.ThisOrder, TestItem); }
void Add() { //create instance of the class clsOrderCollection NewOrder = new clsOrderCollection(); //validate the data on the web form String Error = NewOrder.ThisOrder.Valid(txtCustomerID.Text, txtDeliveryTown.Text, txtOrderDate.Text, txtOrderStatus.Text, txtOrderValue.Text, txtCustomerID.Text); if (Error == "") { NewOrder.ThisOrder.CustomerID = Convert.ToInt32(txtCustomerID.Text); //capture emailaddress NewOrder.ThisOrder.EmailAddress = txtCustomerID.Text; //capture delivery town NewOrder.ThisOrder.DeliveryTown = txtDeliveryTown.Text; //capture date added NewOrder.ThisOrder.DateAdded = Convert.ToDateTime(txtOrderDate.Text); //capture order value NewOrder.ThisOrder.OrderValue = Convert.ToInt32(txtOrderValue.Text); //capture order status NewOrder.ThisOrder.OrderStatus = txtOrderStatus.Text; //add the record NewOrder.Add(); lblError.Text = "New order was added succesfully. "; } else { //report error lblError1.Text = Error; } }
public void AddMethodOK() { clsOrderCollection orders = new clsOrderCollection(); clsOrder order = new clsOrder { OrderId = 1, CustomerId = 1, Date = DateTime.Now.Date, Details = "Text", StaffId = 1 }; Int32 primaryKey = 0; orders.ThisOrder = order; primaryKey = orders.Add(); order.OrderId = primaryKey; orders.ThisOrder.find(primaryKey); Assert.AreEqual(orders.ThisOrder, order); }
public void UpdateOK() { clsOrderCollection col = new clsOrderCollection(); clsDataConnection db = new clsDataConnection(); clsOrder order = new clsOrder(); order.Product_Id = 1; order.Customer_Id = 1; order.Date_Ordered = DateTime.Today; order.Dispatch = true; order.Order_Quantity = 4; order.Product_Name = "Gym gloves"; col.mthisorder = order; col.Add(); int key = order.Product_Id; clsOrder test = new clsOrder(); test.Product_Id = key; test.Customer_Id = 2; test.Date_Ordered = DateTime.Today; test.Dispatch = false; test.Product_Name = "boxes"; test.Order_Quantity = 5; col.mthisorder = test; col.Update(); Assert.AreEqual(test.find(key), true); }
public void DeleteMethodOK() { //instance of class clsOrderCollection AllOrders = new clsOrderCollection(); //create item for test data clsOrder TestItem = new clsOrder(); //var to store the primary key Int32 PrimaryKey = 0; //set properties TestItem.OrderId = 1; TestItem.ShippingMethod = "sameday"; TestItem.DateOrdered = DateTime.Now.Date; TestItem.Dispatched = true; //set ThisOrder to the test data AllOrders.ThisOrder = TestItem; //add the record PrimaryKey = AllOrders.Add(); //set the primary key of the test data TestItem.OrderId = PrimaryKey; //find the record AllOrders.ThisOrder.Find(PrimaryKey); //delete the record AllOrders.Delete(); //now find the record Boolean Found = AllOrders.ThisOrder.Find(PrimaryKey); //test to see that the record was not found Assert.IsFalse(Found); }
public void AddMethodOK() { //create an instance of the class we want to create clsOrderCollection AllOrders = new clsOrderCollection(); //create the item of test data clsOrder TestItem = new clsOrder(); //var to store the primary key Int32 PrimaryKey = 0; //set its properties TestItem.OrderNo = 33; TestItem.Active = true; TestItem.CollectionPostcode = "LE2 7EE"; TestItem.DestinationCountry = "United Kingdom"; TestItem.DestinationPostcode = "LE2 7FZ"; TestItem.DateCreated = "2018/02/01"; TestItem.ParcelSize = "M"; TestItem.Status = "Dispatching"; TestItem.CustomerNo = 1; //set ThisAddress to the test data AllOrders.ThisOrder = TestItem; //add the record PrimaryKey = AllOrders.Add(); //set the primary key of the test data TestItem.OrderNo = PrimaryKey; //find the record AllOrders.ThisOrder.Find(PrimaryKey); //test to see that the two values are the same Assert.AreEqual(AllOrders.ThisOrder, TestItem); }
public void AddMethodOK() { //create an instance of the class we want to create clsOrderCollection AllOrders = new clsOrderCollection(); //create the item of test data clsOrder TestItem = new clsOrder(); //var to store the primary key Int32 PrimaryKey = 0; //set its properties TestItem.CustomerID = 2; TestItem.OrderNo = 2; TestItem.DeliveryTown = "Test Town"; TestItem.OrderStatus = "Test Status"; TestItem.OrderValue = 1; TestItem.EmailAddress = "*****@*****.**"; TestItem.DateAdded = DateTime.Now.Date; //set ThisOrder to the test data AllOrders.ThisOrder = TestItem; //add the record PrimaryKey = AllOrders.Add(); //set the primary key to the test data TestItem.OrderNo = PrimaryKey; //find the record AllOrders.ThisOrder.Find(PrimaryKey); //test to see that two values are the same Assert.AreEqual(AllOrders.ThisOrder, TestItem); }
public void AddMethodOK() { //create an instance of the class we want to create clsOrderCollection AllOrders = new clsOrderCollection(); //create the item of test Customer clsOrder TestItem = new clsOrder(); //var to store the primary key Int32 PrimaryKey = 0; //set the properties of the test Customer object TestItem.OrderId = 2; TestItem.ShippingAddress = "99 Granby Street, Leicester, UK"; TestItem.Phonenum = "1111111111111111"; TestItem.Email = "*****@*****.**"; TestItem.DateOrdered = DateTime.Now.Date; //assign the data to the property AllOrders.ThisOrder = TestItem; //add the record PrimaryKey = AllOrders.Add(); //set the primary key of the test data TestItem.OrderId = PrimaryKey; //find the record AllOrders.ThisOrder.Find(PrimaryKey); //test to see that the two values are the same Assert.AreEqual(AllOrders.ThisOrder, TestItem); }
public void UpdateMethodOK() { //create an instance of the class we want to create clsOrderCollection AllOrders = new clsOrderCollection(); //create the item of test Customer clsOrder TestItem = new clsOrder(); //var to store the primary key Int32 PrimaryKey = 0; //set the properties of the test Customer object TestItem.OrderId = 2; TestItem.ShippingAddress = "99 Granby Street, Leicester, UK"; TestItem.Phonenum = "1111111111111111"; TestItem.Email = "*****@*****.**"; TestItem.DateOrdered = DateTime.Now.Date; //assign the data to the property AllOrders.ThisOrder = TestItem; //add the record PrimaryKey = AllOrders.Add(); //set the primary key of the test data TestItem.OrderId = PrimaryKey; //modify the test data TestItem.ShippingAddress = "102 Jaguar Lane, London"; TestItem.Phonenum = "1111111111111111"; TestItem.Email = "*****@*****.**"; TestItem.DateOrdered = DateTime.Now.Date; //set the record based on the new test data AllOrders.ThisOrder = TestItem; //update the record AllOrders.Update(); //find the record AllOrders.ThisOrder.Find(PrimaryKey); //test to see that the two values are the same Assert.AreEqual(AllOrders.ThisOrder, TestItem); }
public void UpdateMethodOK() { clsOrderCollection AllOrders = new clsOrderCollection(); clsOrder TestItem = new clsOrder(); Int32 PrimaryKey = 0; TestItem.CustomerID = 1; TestItem.ShippingAddress = "AddressTest"; TestItem.OrderDate = DateTime.Now.Date; TestItem.OrderShipped = true; AllOrders.ThisOrder = TestItem; PrimaryKey = AllOrders.Add(); TestItem.OrderID = PrimaryKey; TestItem.CustomerID = 2; TestItem.ShippingAddress = "AddressTest2Edited"; TestItem.OrderDate = DateTime.Now.Date; TestItem.OrderShipped = false; AllOrders.ThisOrder = TestItem; AllOrders.Update(); AllOrders.ThisOrder.Find(PrimaryKey); Assert.AreEqual(AllOrders.ThisOrder, TestItem); }
public void DeleteMethodOK() { //create an instance of the class we want to create clsOrderCollection AllOrders = new clsOrderCollection(); //create the item of test data clsOrder TestItem = new clsOrder(); //var to store the primary key Int32 PrimaryKey = 0; //set it's properties TestItem.OrderId = 2; TestItem.ShippingAddress = "99 Granby Street, Leicester, UK"; TestItem.Phonenum = "1111111111111111"; TestItem.Email = "Junnun Malik"; TestItem.DateOrdered = DateTime.Now.Date; //set ThisAddress to the test data AllOrders.ThisOrder = TestItem; //add the record PrimaryKey = AllOrders.Add(); //set the primary key of the test data TestItem.OrderId = PrimaryKey; //find the record AllOrders.ThisOrder.Find(PrimaryKey); //delete the record AllOrders.Delete(); //now find the record Boolean Found = AllOrders.ThisOrder.Find(PrimaryKey); //test to see that the two values are the same Assert.IsFalse(Found); }
public void UpdateMethodOK() { clsOrderCollection AllOrder = new clsOrderCollection(); clsOrders TestItem = new clsOrders(); Int32 PrimaryKey = 0; TestItem.OrderId = 89; TestItem.DeliveryAddress = "An Address"; TestItem.DispatchedStatus = true; TestItem.UnitPrice = 5.99; TestItem.Quantity = 2; TestItem.OrderDate = DateTime.Now.Date; TestItem.ProductCode = "ABC1234"; TestItem.ItemId = 1; AllOrder.ThisOrder = TestItem; PrimaryKey = AllOrder.Add(); TestItem.OrderId = PrimaryKey; TestItem.DeliveryAddress = "A new Address"; TestItem.DispatchedStatus = false; TestItem.UnitPrice = 6.99; TestItem.Quantity = 5; TestItem.OrderDate = DateTime.Now.Date; TestItem.ProductCode = "ABC1245"; TestItem.ItemId = 1; AllOrder.ThisOrder = TestItem; AllOrder.Update(); AllOrder.ThisOrder.Find(PrimaryKey); Assert.AreEqual(AllOrder.ThisOrder, TestItem); }
public void AddMethodOK() { //create class instance clsOrderCollection AllOrders = new clsOrderCollection(); // create test data clsOrder TestItem = new clsOrder(); // primary key variable Int32 PrimaryKey = 0; // set properties TestItem.orderID = 1; TestItem.numberPlate = "AB09ZXC"; TestItem.customerID = 5; TestItem.price = 5000; TestItem.quantity = 1; TestItem.dateOrdered = DateTime.Now.Date; //set this order to the test data AllOrders.ThisOrder = TestItem; // add record PrimaryKey = AllOrders.Add(); // set primary key of test data TestItem.orderID = PrimaryKey; // find record AllOrders.ThisOrder.Find(PrimaryKey); // test values are the same Assert.AreEqual(AllOrders.ThisOrder, TestItem); }
public void DeleteMethodOK() { //create class instance clsOrderCollection AllOrders = new clsOrderCollection(); // create test data clsOrder TestItem = new clsOrder(); // primary key variable Int32 PrimaryKey = 0; // set properties TestItem.orderID = 1; TestItem.numberPlate = "AB09ZXC"; TestItem.customerID = 5; TestItem.price = 5000; TestItem.quantity = 1; TestItem.dateOrdered = DateTime.Now.Date; //set this order to the test data AllOrders.ThisOrder = TestItem; // add record PrimaryKey = AllOrders.Add(); // set primary key of test data TestItem.orderID = PrimaryKey; // find record AllOrders.ThisOrder.Find(PrimaryKey); // delete record AllOrders.Delete(); // find the record again Boolean Found = AllOrders.ThisOrder.Find(PrimaryKey); // test that record was not found Assert.IsFalse(Found); }
public void AddMethodOk() { //create intance of class to create clsOrderCollection AllOrders = new clsOrderCollection(); //var to store primary key Int32 PrimaryKey = 0; //create test data to assign to the property clsOrder TestItem = new clsOrder(); //set properties TestItem.OrderNo = 4; TestItem.DateOrdered = DateTime.Now.Date; TestItem.ProductName = "Logitech M220 Silent Wireless Mouse "; TestItem.QuantityNo = 3; TestItem.OrderPrice = 50; //set thisorder to test data AllOrders.ThisOrder = TestItem; //add record PrimaryKey = AllOrders.Add(); //set primary key of the test data TestItem.OrderNo = PrimaryKey; //find the record AllOrders.ThisOrder.Find(PrimaryKey); //test to see the values are the same Assert.AreEqual(AllOrders.ThisOrder, TestItem); }
public void DeleteMethodOK() { clsOrderCollection AllOrders = new clsOrderCollection(); clsOrder TestItem = new clsOrder(); Int32 PrimaryKey = 0; //data to delete TestItem.StaffId = 349; TestItem.DeliveryAddress = "SA70 8SQ"; TestItem.ItemColour = "Green"; TestItem.ItemPrice = 17; TestItem.OrderPlaced = DateTime.Now.Date; TestItem.ItemDescription = "Single Player"; TestItem.ItemAvailability = true; AllOrders.ThisOrder = TestItem; TestItem.OrderNo = PrimaryKey; PrimaryKey = AllOrders.Add(); TestItem.OrderNo = PrimaryKey; AllOrders.ThisOrder.Find(PrimaryKey); AllOrders.Delete(); Boolean Found = AllOrders.ThisOrder.Find(PrimaryKey); Assert.IsFalse(Found); }
public void UpdateMethodOK() { clsOrderCollection AllOrders = new clsOrderCollection(); clsOrder TestItem = new clsOrder(); Int32 PrimaryKey = 0; TestItem.Payed = true; TestItem.OrderNumber = 1; TestItem.OrderPrice = 10; TestItem.ItemCount = 2; TestItem.Address = "ankara"; TestItem.Date = DateTime.Now.Date; AllOrders.ThisOrder = TestItem; PrimaryKey = AllOrders.Add(); TestItem.OrderNumber = PrimaryKey; TestItem.Payed = true; TestItem.OrderNumber = 1; TestItem.OrderPrice = 10; TestItem.ItemCount = 2; TestItem.Address = "ankara"; TestItem.Date = DateTime.Now.Date; AllOrders.ThisOrder = TestItem; AllOrders.Update(); AllOrders.ThisOrder.Find(PrimaryKey); Assert.AreEqual(AllOrders.ThisOrder, TestItem); }
public void UpdateMethodOK() { clsOrderCollection AllOrders = new clsOrderCollection(); clsOrder TestItem = new clsOrder(); Int32 PrimaryKey = 0; TestItem.ItemAvailable = true; TestItem.OrderID = 1234; TestItem.TotalItem = 10; TestItem.TotalPrice = 15.55; TestItem.DeliveryAddress = "1, A Street, LE1 5AB, Leicester"; TestItem.DateOrdered = DateTime.Now.Date; AllOrders.ThisOrder = TestItem; PrimaryKey = AllOrders.Add(); TestItem.OrderID = PrimaryKey; TestItem.ItemAvailable = false; TestItem.OrderID = 4567; TestItem.TotalItem = 15; TestItem.TotalPrice = 17.99; TestItem.DeliveryAddress = "2, B Street, LE1 5AB, Leicester"; TestItem.DateOrdered = DateTime.Now.Date; AllOrders.ThisOrder = TestItem; AllOrders.Update(); AllOrders.ThisOrder.Find(PrimaryKey); Assert.AreEqual(AllOrders.ThisOrder, TestItem); }
public void UpdateMethodOK() { clsOrderCollection AllOrders = new clsOrderCollection(); clsOrder TestItem = new clsOrder(); Int32 PrimaryKey = 0; TestItem.Delivered = true; TestItem.CustomerId = 1; TestItem.OrderPrice = 1; TestItem.DateReceived = DateTime.Now.Date; TestItem.Description = "Blue Shirt"; TestItem.Quantity = 1; AllOrders.ThisOrder = TestItem; PrimaryKey = AllOrders.Add(); TestItem.OrderId = PrimaryKey; TestItem.Delivered = false; TestItem.CustomerId = 2; TestItem.OrderPrice = 2; TestItem.DateReceived = DateTime.Now.Date; TestItem.Description = "Pink Shirt"; TestItem.Quantity = 2; AllOrders.ThisOrder = TestItem; AllOrders.Update(); AllOrders.ThisOrder.Find(PrimaryKey); Assert.AreEqual(AllOrders.ThisOrder, TestItem); }
public void DeleteMethodOK() { //create an instance of the class we want to create clsOrderCollection AllOrders = new clsOrderCollection(); //string variable to store clsOrder TestItem = new clsOrder(); Int32 PrimaryKey = 0; TestItem.OrderNo = 1; TestItem.DeliveryDate = DateTime.Now.Date; TestItem.OrderDate = DateTime.Now.Date; TestItem.PartNo = 1234567; AllOrders.ThisOrder = TestItem; PrimaryKey = AllOrders.Add(); TestItem.OrderNo = PrimaryKey; AllOrders.ThisOrder.Find(PrimaryKey); AllOrders.Delete(); Boolean Found = AllOrders.ThisOrder.Find(PrimaryKey); Assert.IsFalse(Found); }
//function for adding new records void Add() { //create an instance of the OrderCollection class clsOrderCollection Orders = new clsOrderCollection(); //validate the data on the web form String Error = Orders.ThisOrder.Valid(txtComputerNo.Text, txtCustomerNo.Text, txtItemName.Text, txtCustomerName.Text, txtInvoice.Text, txtDeliveryDate.Text, txtOrderDate.Text, ddlStatus.Text); //if the data is OK then add it to the object if (Error == "") { //copy the data from the interface to the object Orders.ThisOrder.ComputerNo = Convert.ToInt32(txtComputerNo.Text); Orders.ThisOrder.CustomerNo = Convert.ToInt32(txtCustomerNo.Text); Orders.ThisOrder.ItemName = txtItemName.Text; Orders.ThisOrder.CustomerName = txtCustomerName.Text; Orders.ThisOrder.Invoice = Convert.ToInt32(txtInvoice.Text); Orders.ThisOrder.DeliveryDate = Convert.ToDateTime(txtDeliveryDate.Text); Orders.ThisOrder.OrderDate = Convert.ToDateTime(txtOrderDate.Text); Orders.ThisOrder.Status = ddlStatus.Text; //add the new record Orders.Add(); //all done so redirect back to the main page Response.Redirect("Order.aspx"); } else { //report an error lblError.Text = "There were problems with the data entered " + Error; } }
public void UpdateMethodOK() { //create an instance of the class we want to create clsOrderCollection AllOrders = new clsOrderCollection(); //create the item of test data clsOrder TestItem = new clsOrder(); //var to store the primary key Int32 PrimaryKey = 0; //set its properties TestItem.OrderNo = 1; TestItem.DeliveryDate = DateTime.Now.Date; TestItem.OrderDate = DateTime.Now.Date; //set ThisCustomer to the test data AllOrders.ThisOrder = TestItem; //add the record PrimaryKey = AllOrders.Add(); //set the primary key of the test data TestItem.OrderNo = PrimaryKey; //modify the test data TestItem.DeliveryDate = DateTime.Now.Date; //set the record based on the new test data AllOrders.ThisOrder = TestItem; //update the record AllOrders.Update(); //find the record AllOrders.ThisOrder.Find(PrimaryKey); //test to see ThisCustomer matches the test data Assert.AreEqual(AllOrders.ThisOrder, TestItem); }
//function for adding new records void Add() { // create an instance of the order book clsOrderCollection OrderBook = new clsOrderCollection(); // validate the data on the web form String Error = OrderBook.ThisOrder.Valid(txtFirstPrice.Text, txtSecondPrice.Text, txtThirdPrice.Text, txtOrderTotal.Text); // if the data is OK then add it to the object if (Error == "") { OrderBook.ThisOrder.FirstChoice = Convert.ToInt32(ddlFirstChoice.SelectedValue); OrderBook.ThisOrder.SecondChoice = Convert.ToInt32(ddlSecondChoice.SelectedValue); OrderBook.ThisOrder.ThirdChoice = Convert.ToInt32(ddlThirdChoice.SelectedValue); OrderBook.ThisOrder.FirstPrice = Convert.ToInt32(txtFirstPrice.Text); OrderBook.ThisOrder.SecondPrice = Convert.ToInt32(txtSecondPrice.Text); OrderBook.ThisOrder.ThirdPrice = Convert.ToInt32(txtThirdPrice.Text); OrderBook.ThisOrder.OrderTotal = Convert.ToInt32(txtOrderTotal.Text); // add the record OrderBook.Add(); //Response.Redirect("OrderDefault.aspx"); Response.Redirect("ACardDetails.aspx"); } else { //report an error lblError.Text = "There were problems with the data entered " + Error; } }
public void UpdateMethodOk() { clsOrderCollection AllOrder = new clsOrderCollection(); clsOrder TestItem = new clsOrder(); Int32 PrimaryKey = 0; //TestItem.OrderID = 1; TestItem.CustomerID = 1; TestItem.StaffID = 1; TestItem.CarID = 1; TestItem.Date = DateTime.Now.Date; TestItem.Email = ""; TestItem.Price = 1; AllOrder.ThisOrder = TestItem; PrimaryKey = AllOrder.Add(); TestItem.OrderID = PrimaryKey; // TestItem.OrderID = 2; TestItem.CustomerID = 2; TestItem.StaffID = 2; TestItem.CarID = 2; TestItem.Date = DateTime.Now.Date; TestItem.Email = ""; TestItem.Price = 2; AllOrder.ThisOrder = TestItem; AllOrder.update(); AllOrder.ThisOrder.Find(PrimaryKey); Assert.AreEqual(AllOrder.ThisOrder, TestItem); }
public void AddMethodOK() { //instance of class clsOrderCollection AllOrders = new clsOrderCollection(); //create item for test data clsOrder TestItem = new clsOrder(); //var to store the primary key Int32 PrimaryKey = 0; //set properties TestItem.OrderId = 1; TestItem.ShippingMethod = "sameday"; TestItem.DateOrdered = DateTime.Now.Date; TestItem.Dispatched = true; //set ThisOrder to the test data AllOrders.ThisOrder = TestItem; //add the record PrimaryKey = AllOrders.Add(); //set the primary key of the test data TestItem.OrderId = PrimaryKey; //find the record AllOrders.ThisOrder.Find(PrimaryKey); //test if values are the same Assert.AreEqual(AllOrders.ThisOrder, TestItem); }
public void AddMethodOK() { //create an instance of the class we want to create clsOrderCollection AllOrders = new clsOrderCollection(); //create the test data clsOrders TestItem = new clsOrders(); //varaible to store the primary key Int32 PrimaryKey = 0; //set it's properties TestItem.OrderId = 5; TestItem.CustomerId = 1; TestItem.ProductId = "26g"; TestItem.OrderDate = DateTime.Now.Date; TestItem.Description = "Description 3"; TestItem.Price = 12.99; TestItem.Paid = true; TestItem.Status = "Processing"; TestItem.DateShipped = DateTime.Now.Date; //set ThisOrder to the test data AllOrders.ThisOrder = TestItem; //add the record PrimaryKey = AllOrders.Add(); //set the primary key of the test data TestItem.OrderId = PrimaryKey; //find the record AllOrders.ThisOrder.Find(PrimaryKey); //test to see that the two values are the same Assert.AreEqual(AllOrders.ThisOrder, TestItem); }
public void DeleteMethodOK() { clsOrderCollection orders = new clsOrderCollection(); clsOrder order = new clsOrder { OrderId = 1, CustomerId = 1, Date = DateTime.Now.Date, StaffId = 1, Details = "Text" }; Int32 primaryKey = 0; orders.ThisOrder = order; primaryKey = orders.Add(); order.OrderId = primaryKey; orders.ThisOrder.find(primaryKey); orders.Delete(); Assert.IsFalse(orders.ThisOrder.find(primaryKey)); }
public void DeleteMethodOK() { //create an instance of the class we want to create clsOrderCollection AllOrders = new clsOrderCollection(); //create the test data clsOrders TestItem = new clsOrders(); //var to store the primary key Int32 PrimaryKey = 0; //set it's properties TestItem.OrderId = 20; TestItem.CustomerId = 1; TestItem.ProductId = "32g"; TestItem.OrderDate = DateTime.Now.Date; TestItem.Description = "Another Description"; TestItem.Price = 24.99; TestItem.Paid = true; TestItem.Status = "Shipped"; TestItem.DateShipped = DateTime.Now.Date; //set ThisOrder to the test data AllOrders.ThisOrder = TestItem; //add the record PrimaryKey = AllOrders.Add(); //set the primary key of the test data TestItem.OrderId = PrimaryKey; //find the record AllOrders.ThisOrder.Find(PrimaryKey); //delete the record AllOrders.Delete(); //now find the record Boolean Found = AllOrders.ThisOrder.Find(PrimaryKey); //test to see that the record was not found Assert.IsFalse(Found); }
public void UpdateMethodOk() { clsOrderCollection AllOrders = new clsOrderCollection(); clsOrder TestItem = new clsOrder(); Int32 PrimaryKey = 0; TestItem.Shipment = true; TestItem.GameTitle = "game1"; //first set of attributes TestItem.TotalPrice = 1; TestItem.DeliveryDate = DateTime.Now.Date; AllOrders.ThisOrder = TestItem; PrimaryKey = AllOrders.Add(); TestItem.orderID = PrimaryKey; TestItem.Shipment = false; TestItem.GameTitle = "game2"; //second set of attributes TestItem.TotalPrice = 2; TestItem.DeliveryDate = DateTime.Now.Date; AllOrders.ThisOrder = TestItem; AllOrders.Update(); AllOrders.ThisOrder.Find(PrimaryKey); Assert.AreEqual(AllOrders.ThisOrder, TestItem);//check if they are the same }
public void UpdateMethodOk() { clsOrderCollection AllOrders = new clsOrderCollection(); clsOrder TestItem = new clsOrder(); Int32 PrimaryKey = 0; TestItem.OrderDate = DateTime.Now.Date; TestItem.OrderTotal = 200; TestItem.CustomerId = 5; TestItem.StaffId = 2; TestItem.OrderStatus = true; TestItem.OrderProgress = "test"; AllOrders.ThisOrder = TestItem; PrimaryKey = AllOrders.Add(); TestItem.OrderId = PrimaryKey; TestItem.OrderDate = DateTime.Now.Date; TestItem.OrderTotal = 250; TestItem.CustomerId = 5; TestItem.StaffId = 1; TestItem.OrderStatus = false; TestItem.OrderProgress = "test"; AllOrders.ThisOrder = TestItem; AllOrders.Update(); AllOrders.ThisOrder.Find(PrimaryKey); Assert.AreEqual(AllOrders.ThisOrder, TestItem); }