public void UpdateMethodOk() { // create instance of class to test clsOrderLineCollection AllOrderLines = new clsOrderLineCollection(); // create test data clsOrderLine TestItem = new clsOrderLine(); // primary key var Int32 PrimaryKey = 0; // set properties for test data TestItem.orderID = 1; TestItem.staffID = 1; TestItem.orderComplete = true; // set ThisAddress to the test data AllOrderLines.ThisOrderLine = TestItem; // add the record PrimaryKey = AllOrderLines.Add(); // set primary key of test data TestItem.orderLineID = PrimaryKey; // modify test data TestItem.orderID = 3; TestItem.staffID = 1; TestItem.orderComplete = true; // set record based on new test data AllOrderLines.ThisOrderLine = TestItem; // update the record AllOrderLines.Update(); // find record AllOrderLines.ThisOrderLine.Find(PrimaryKey); // test that ThisOrderLine matches the test data Assert.AreEqual(AllOrderLines.ThisOrderLine, TestItem); }
public void DeleteMethodOK() { clsOrderLineCollection orderLines = new clsOrderLineCollection(); clsOrderLine orderLine = new clsOrderLine { OrderId = 3, OrderLineId = 1, ProductId = 1, Quantity = 5 }; Int32 primaryKey = 0; orderLines.ThisOrderLine = orderLine; primaryKey = orderLines.Add(); orderLine.OrderLineId = primaryKey; orderLines.ThisOrderLine.find(primaryKey); orderLines.Delete(); Assert.IsFalse(orderLines.ThisOrderLine.find(primaryKey)); }
public void DeleteMethodOK() { //instance of class clsOrderLineCollection AllOrderLines = new clsOrderLineCollection(); //create item for test data clsOrderLine TestItem = new clsOrderLine(); //var to store the primary key Int32 PrimaryKey = 0; //set properties TestItem.OrderId = 1; TestItem.ProductId = "123abc"; TestItem.Price = 24.99; TestItem.Quantity = 3; TestItem.Available = true; //set ThisOrder to the test data AllOrderLines.ThisOrderLine = TestItem; //add the record PrimaryKey = AllOrderLines.Add(); //set the primary key of the test data TestItem.OrderId = PrimaryKey; //find the record AllOrderLines.ThisOrderLine.Find(PrimaryKey); //delete the record AllOrderLines.Delete(); //now find the record Boolean Found = AllOrderLines.ThisOrderLine.Find(PrimaryKey); //test to see that the record was not found Assert.IsFalse(Found); }
public void AddMethodOK() { //instance of class clsOrderLineCollection AllOrderLines = new clsOrderLineCollection(); //create item for test data clsOrderLine TestItem = new clsOrderLine(); //var to store the primary key Int32 PrimaryKey = 0; //set properties TestItem.OrderId = 1; TestItem.ProductId = "123abc"; TestItem.Price = 24.99; TestItem.Quantity = 3; TestItem.Available = true; //set ThisOrder to the test data AllOrderLines.ThisOrderLine = TestItem; //add the record PrimaryKey = AllOrderLines.Add(); //set the primary key of the test data TestItem.OrderId = PrimaryKey; //find the record AllOrderLines.ThisOrderLine.Find(PrimaryKey); //test if values are the same Assert.AreEqual(AllOrderLines.ThisOrderLine, TestItem); }
public void AddMethodOK() { //create an instance of the class we want to create clsOrderLineCollection AllOrders = new clsOrderLineCollection(); //create the item of test data clsOrderLine TestItem = new clsOrderLine(); //var to store the primary key Int32 PrimaryKey = 0; //set its properties TestItem.OrderLineID = 2; TestItem.OrderNo = 2; TestItem.TrainerID = 2; TestItem.OrderLineID = 2; TestItem.OrderQty = 1; TestItem.Price = 2; //set ThisOrder to the test data AllOrders.ThisOrderLine = TestItem; //add the record PrimaryKey = AllOrders.Add(); //set the primary key to the test data TestItem.OrderNo = PrimaryKey; //find the record AllOrders.ThisOrderLine.Find(PrimaryKey); //test to see that two values are the same Assert.AreEqual(AllOrders.ThisOrderLine, TestItem); }
public void AddMethodOK() { //create class instance clsOrderLineCollection AllOrderLines = new clsOrderLineCollection(); // create test data clsOrderLine TestItem = new clsOrderLine(); // primary key variable Int32 PrimaryKey = 0; // set properties TestItem.orderLineID = 1; TestItem.orderID = 1; TestItem.staffID = 1; TestItem.orderComplete = true; //set this order to the test data AllOrderLines.ThisOrderLine = TestItem; // add record PrimaryKey = AllOrderLines.Add(); // set primary key of test data TestItem.orderLineID = PrimaryKey; // find record AllOrderLines.ThisOrderLine.Find(PrimaryKey); // test values are the same Assert.AreEqual(AllOrderLines.ThisOrderLine, TestItem); }
public void UpdateMethodOk() { clsOrderLineCollection AllLines = new clsOrderLineCollection(); clsOrderLine TestItem = new clsOrderLine(); Int32 PrimaryKey = 0; TestItem.OrderLineId = 1; TestItem.OrderId = 1; TestItem.ItemNo = 1; TestItem.ItemDescription = "Test Item"; TestItem.Quantity = 1; TestItem.UnitCost = 15; AllLines.ThisOrderLine = TestItem; PrimaryKey = AllLines.Add(); TestItem.OrderLineId = PrimaryKey; TestItem.OrderId = 2; TestItem.ItemNo = 8; TestItem.ItemDescription = "Test Item 2"; TestItem.Quantity = 2; TestItem.UnitCost = 25; AllLines.ThisOrderLine = TestItem; AllLines.Update(); AllLines.ThisOrderLine.Find(PrimaryKey); Assert.AreEqual(AllLines.ThisOrderLine, TestItem); }
void Add() { //create instance of the class clsOrderLineCollection NewOrder = new clsOrderLineCollection(); //validate the data on the web form String Error = NewOrder.ThisOrderLine.Valid(txtTrainerID.Text, txtOrderNo.Text, txtQuantity.Text, ddlTrainerID.Text); if (Error == "") //string trainerID, string orderNo, string quantity, string price { //capture trainer ID NewOrder.ThisOrderLine.TrainerID = Convert.ToInt32(txtTrainerID.Text); //capture order no NewOrder.ThisOrderLine.OrderNo = Convert.ToInt32(txtOrderNo.Text); //capture quantity NewOrder.ThisOrderLine.OrderQty = Convert.ToInt32(txtQuantity.Text); //capture price NewOrder.ThisOrderLine.Price = Convert.ToInt32(ddlTrainerID.Text); NewOrder.Add(); lblError.Text = "New trainer was successfully added into your order!"; } else { //report error lblError.Text = "There were problems with the data entered: " + Error; } }
public void DeleteMethodOK() { //create an instance of the class we want to create clsOrderLineCollection AllOrderLines = new clsOrderLineCollection(); //create the item of test data clsOrderLine TestItem = new clsOrderLine(); //var to store the primary key Int32 PrimaryKey = 0; //set its properties TestItem.OrderLineID = 5; TestItem.OrderID = "5"; TestItem.ProductID = "5"; //set ThisOrder to the test data AllOrderLines.ThisOrderLine = TestItem; //add the record PrimaryKey = AllOrderLines.Add(); //set the primary key of the test data TestItem.OrderLineID = PrimaryKey; //Find the record AllOrderLines.ThisOrderLine.Find(PrimaryKey); //delete the record AllOrderLines.Delete(); //now find the record Boolean Found = AllOrderLines.ThisOrderLine.Find(PrimaryKey); //test to see that the record was not found Assert.IsFalse(Found); }
public void UpdateMethodOK() { //create an instance of the class we want to create clsOrderLineCollection AllOrderLines = new clsOrderLineCollection(); //create the item of test data clsOrderLine TestItem = new clsOrderLine(); //var to store the primary key Int32 PrimaryKey = 0; //set its properties TestItem.OrderID = "5"; TestItem.ProductID = "5"; //set ThisOrder to the test data AllOrderLines.ThisOrderLine = TestItem; //add the record PrimaryKey = AllOrderLines.Add(); //set the primary key of the test data TestItem.OrderLineID = PrimaryKey; //modify the test data TestItem.OrderID = "6"; TestItem.ProductID = "6"; //set the record based on the new test data AllOrderLines.ThisOrderLine = TestItem; //update the record AllOrderLines.Update(); //fnd the record AllOrderLines.ThisOrderLine.Find(PrimaryKey); //test to see thisorderline matches the test data Assert.AreEqual(AllOrderLines.ThisOrderLine, TestItem); }
public void DeleteMethodOK() { //create class instance clsOrderLineCollection AllOrderLines = new clsOrderLineCollection(); // create test data clsOrderLine TestItem = new clsOrderLine(); // primary key variable Int32 PrimaryKey = 0; // set properties TestItem.orderID = 1; TestItem.orderLineID = 1; TestItem.staffID = 1; TestItem.orderComplete = true; //set this order to the test data AllOrderLines.ThisOrderLine = TestItem; // add record PrimaryKey = AllOrderLines.Add(); // set primary key of test data TestItem.orderLineID = PrimaryKey; // find record AllOrderLines.ThisOrderLine.Find(PrimaryKey); // delete record AllOrderLines.Delete(); // find the record again Boolean Found = AllOrderLines.ThisOrderLine.Find(PrimaryKey); // test that record was not found Assert.IsFalse(Found); }
protected void btnOKOrderLine_Click(object sender, EventArgs e) { clsOrderLine AnOrderLine = new clsOrderLine(); string orderID = OrderIDFind.Text; string productID = ProductIDFind.Text; string selectionDescription = SelectionDescriptionFind.Text; string quantity = QuantityList.Text; string Error = ""; Error = AnOrderLine.Valid(orderID, productID, quantity, selectionDescription); if (Error == "") { AnOrderLine.orderID = Convert.ToInt32(OrderIDFind.Text); AnOrderLine.productID = Convert.ToInt32(ProductIDFind.Text); AnOrderLine.selectionDescription = SelectionDescriptionFind.Text; AnOrderLine.quantity = Convert.ToInt32(QuantityList.Text); clsOrderLineCollection OrderLineList = new clsOrderLineCollection(); if (OrderLineID == -1) { OrderLineList.ThisOrderLine = AnOrderLine; OrderLineList.Add(); } else { OrderLineList.ThisOrderLine.Find(OrderLineID); OrderLineList.ThisOrderLine = AnOrderLine; OrderLineList.Update(); } Response.Redirect("OrderLineList.aspx"); } else { Label2.Text = Error; } }
protected void btnOK_Click(object sender, EventArgs e) { //create new instance of the class clsOrderLine AnOrderLine = new clsOrderLine(); string OrderId = txtOrderId.Text; string ProductId = txtProductId.Text; string Price = txtPrice.Text; string Quantity = txtQuantity.Text; //var for error messages string Error = ""; //validate the data Error = AnOrderLine.Valid(ProductId, Price, Quantity); if (Error == "") { //capture the order id AnOrderLine.OrderId = this.OrderID; //capture the product id AnOrderLine.ProductId = ProductId; //capture the price AnOrderLine.Price = Convert.ToDouble(Price); //capture the quantity AnOrderLine.Quantity = Convert.ToInt32(Quantity); //capture available AnOrderLine.Available = chkAvailable.Checked; //store the order in the session object Session["AnOrder"] = AnOrderLine; //navigate to the viewer page Response.Write("OrderLineViewer.aspx"); //create new instance of the order collection clsOrderLineCollection OrderLineList = new clsOrderLineCollection(); if (this.OrderID == -1) { //set the ThisOrder property OrderLineList.ThisOrderLine = AnOrderLine; //add the new record OrderLineList.Add(); }//otherwise it must be an update else { //find the record to update OrderLineList.ThisOrderLine.Find(OrderID); //set the ThisOrder property OrderLineList.ThisOrderLine = AnOrderLine; //update the record OrderLineList.Update(); } //redirect back to the listpage Response.Redirect("OrderLineList.aspx"); } else { //display error message lblError.Text = Error; } }
protected void btnOK_Click(object sender, EventArgs e) { // create new instance clsOrderLine AnOrderLine = new clsOrderLine(); // capture staff id string StaffID = txtStaffID.Text; // capture order id string OrderID = txtOrderID.Text; // Error string string Error = ""; // validate data Error = AnOrderLine.Valid(OrderID, StaffID); if (Error == "") { // capture orderline ID AnOrderLine.orderLineID = OrderLineID; // capture order ID AnOrderLine.orderID = Convert.ToInt32(OrderID); // capture staff ID AnOrderLine.staffID = Convert.ToInt32(StaffID); // capture order Complete AnOrderLine.orderComplete = chkOrderComplete.Checked; // new istance of order line collection clsOrderLineCollection OrderLineList = new clsOrderLineCollection(); // if this is a new record if (OrderLineID == -1) { // set thisOrderLine OrderLineList.ThisOrderLine = AnOrderLine; // add new record OrderLineList.Add(); } // otherwise must be update else { // find record to update OrderLineList.ThisOrderLine.Find(OrderLineID); // set thisOrderLine OrderLineList.ThisOrderLine = AnOrderLine; // update record OrderLineList.Update(); } // redirect to list page Response.Redirect("OrderLineList.aspx"); } else { // display error message lblError.Text = Error; } }
protected void btnOK_Click(object sender, EventArgs e) { clsOrderLine orderLine = new clsOrderLine(); string orderLineId = txtBxOrderLineId.Text; string orderId = txtBxOrderId.Text; string productId = txtBxProductId.Text; string quantity = txtBxQuantity.Text; string error = orderLine.Validate(orderLineId, orderId, productId, quantity); clsOrderLineCollection OrderLineList = new clsOrderLineCollection(); if (error == "") { orderLine.OrderLineId = Convert.ToInt32(orderLineId); orderLine.OrderId = Convert.ToInt32(orderId); orderLine.ProductId = Convert.ToInt32(productId); orderLine.Quantity = Convert.ToInt32(quantity); Session["orderLine"] = orderLine; clsOrderLineCollection orders = new clsOrderLineCollection(); clsOrderLine orderLineTemp = new clsOrderLine { OrderId = Convert.ToInt32(txtBxOrderId.Text), OrderLineId = Convert.ToInt32(txtBxOrderLineId.Text), ProductId = Convert.ToInt32(txtBxProductId.Text), Quantity = Convert.ToInt32(txtBxQuantity.Text), }; if (!orderLineTemp.exists(orderLineTemp.OrderLineId)) { orders.ThisOrderLine = orderLine; orders.Add(); } else { OrderLineList.ThisOrderLine = orderLine; OrderLineList.Update(); } } else { lblError.Text = error; } Response.Redirect("OrderLineViewer.aspx"); }
public void AddMethodOK() { clsOrderLineCollection AllOrderLines = new clsOrderLineCollection(); clsOrderLine TestItem = new clsOrderLine(); Int32 PrimaryKey = 0; TestItem.selectionDescription = "Nike Air"; TestItem.orderID = 1; TestItem.productID = 1; TestItem.quantity = 2; AllOrderLines.ThisOrderLine = TestItem; PrimaryKey = AllOrderLines.Add(); TestItem.orderLineID = PrimaryKey; AllOrderLines.ThisOrderLine.Find(PrimaryKey); Assert.AreEqual(AllOrderLines.ThisOrderLine, TestItem); }
public void AddMethodOK() { clsOrderLineCollection AllOrderLines = new clsOrderLineCollection(); clsOrderLine TestItem = new clsOrderLine(); Int32 PrimaryKey = 0; TestItem.CustomerName = "Emma Wang"; TestItem.DateProcessed = DateTime.Now.Date; TestItem.EquipmentOrdered = "Weights"; TestItem.TotalCost = 5; TestItem.OrderProcessed = true; AllOrderLines.ThisOrderLine = TestItem; PrimaryKey = AllOrderLines.Add(); TestItem.OrderNo = PrimaryKey; AllOrderLines.ThisOrderLine.Find(PrimaryKey); Assert.AreEqual(AllOrderLines.ThisOrderLine, TestItem); }
protected void btnOK_Click(object sender, EventArgs e) { //create a new instance of clsOrderline clsOrderLine anOrderLine = new clsOrderLine(); //capture the equipment ordered string EquipmentOrdered = txtEquipmentOrdered.Text; //capture customer name string CustomerName = txtCustomerName.Text; //capture date ordered string DateProcessed = txtDateProcessed.Text; //store the address in the session object string Error = ""; Error = anOrderLine.Valid(CustomerName, DateProcessed, EquipmentOrdered); if (Error == "") { anOrderLine.OrderNo = OrderNo; anOrderLine.CustomerName = CustomerName; anOrderLine.DateProcessed = Convert.ToDateTime(DateProcessed); anOrderLine.EquipmentOrdered = EquipmentOrdered; anOrderLine.OrderProcessed = chkProcessed.Checked; clsOrderLineCollection OrderLineList = new clsOrderLineCollection(); if (OrderNo == -1) { OrderLineList.ThisOrderLine = anOrderLine; OrderLineList.Add(); } else { OrderLineList.ThisOrderLine.Find(OrderNo); OrderLineList.ThisOrderLine = anOrderLine; OrderLineList.Update(); } Response.Redirect("OrderLineList.aspx"); } else { //display the error message lblError.Text = Error; } }
public void DeleteMethodOK() { clsOrderLineCollection AllOrderLines = new clsOrderLineCollection(); clsOrderLine TestItem = new clsOrderLine(); Int32 PrimaryKey = 0; TestItem.orderLineID = 1; TestItem.selectionDescription = "Nike Air"; TestItem.orderID = 1; TestItem.productID = 1; TestItem.quantity = 2; AllOrderLines.ThisOrderLine = TestItem; PrimaryKey = AllOrderLines.Add(); TestItem.orderLineID = PrimaryKey; AllOrderLines.ThisOrderLine.Find(PrimaryKey); AllOrderLines.Delete(); Boolean Found = AllOrderLines.ThisOrderLine.Find(PrimaryKey); Assert.IsFalse(Found); }
public void DeleteMethodOk() { clsOrderLineCollection AllLines = new clsOrderLineCollection(); clsOrderLine TestItem = new clsOrderLine(); Int32 PrimaryKey = 0; TestItem.OrderLineId = 1; TestItem.OrderId = 1; TestItem.ItemNo = 1; TestItem.ItemDescription = "Test Item"; TestItem.Quantity = 1; TestItem.UnitCost = 15; AllLines.ThisOrderLine = TestItem; PrimaryKey = AllLines.Add(); TestItem.OrderId = PrimaryKey; AllLines.ThisOrderLine.Find(PrimaryKey); AllLines.Delete(); bool Found = AllLines.ThisOrderLine.Find(PrimaryKey); Assert.IsFalse(Found); }
public void UpdateMethodOK() { clsOrderLineCollection AllOrderLines = new clsOrderLineCollection(); clsOrderLine TestItem = new clsOrderLine(); Int32 PrimaryKey = 1; TestItem.orderID = 1; TestItem.selectionDescription = "Jordan Air"; TestItem.productID = 1; TestItem.quantity = 4; AllOrderLines.ThisOrderLine = TestItem; PrimaryKey = AllOrderLines.Add(); TestItem.orderID = 2; TestItem.selectionDescription = "Jordan Air but different"; TestItem.productID = 2; TestItem.quantity = 3; AllOrderLines.ThisOrderLine = TestItem; AllOrderLines.Update(); AllOrderLines.ThisOrderLine.Find(PrimaryKey); Assert.AreEqual(AllOrderLines.ThisOrderLine, TestItem); }
//function for adding new record void Add() { //create an instance of the OrderLine Collection clsOrderLineCollection OrderLineCollection = new clsOrderLineCollection(); //validate the data on the web form Boolean OK = OrderLineCollection.ThisOrderLine.Valid(txtOLOrderID.Text, txtOLProductID.Text); //if the data is ok then add it to the object# if (OK == true) { //get the data entered by the user OrderLineCollection.ThisOrderLine.OrderID = txtOLOrderID.Text; OrderLineCollection.ThisOrderLine.ProductID = txtOLProductID.Text; //add the record OrderLineCollection.Add(); } else { //report an error lblOLError.Text = "There were problems with the data entered"; } }
protected void btnOk_Click(object sender, EventArgs e) { string Error = ""; clsOrderLine AnOrderLine = new clsOrderLine(); string OrderId = txtOrderId.Text; string ItemNo = txtItemNo.Text; string ItemDescription = txtItemDescription.Text; string Quantity = txtQuantity.Text; string UnitCost = txtUnitCost.Text; Error = AnOrderLine.Valid(OrderId, ItemNo, ItemDescription, Quantity, UnitCost); if (Error == "") { AnOrderLine.OrderLineId = OrderLineId; AnOrderLine.OrderId = Convert.ToInt32(OrderId); AnOrderLine.ItemNo = Convert.ToInt32(ItemNo); AnOrderLine.ItemDescription = ItemDescription; AnOrderLine.Quantity = Convert.ToInt32(Quantity); AnOrderLine.UnitCost = Convert.ToDecimal(UnitCost); clsOrderLineCollection OrderLineList = new clsOrderLineCollection(); if (OrderLineId == -1) { OrderLineList.ThisOrderLine = AnOrderLine; OrderLineList.Add(); } else { OrderLineList.ThisOrderLine.Find(OrderLineId); OrderLineList.ThisOrderLine = AnOrderLine; OrderLineList.Update(); } Response.Redirect("OrderLineList.aspx"); } else { lblError.Text = Error; } }
public void AddMethodOK() { clsOrderLineCollection orderLines = new clsOrderLineCollection(); clsOrderLine orderLine = new clsOrderLine { OrderId = 3, OrderLineId = 1, ProductId = 1, Quantity = 5 }; Int32 primaryKey = 0; orderLines.ThisOrderLine = orderLine; primaryKey = orderLines.Add(); orderLine.OrderLineId = primaryKey; orderLines.ThisOrderLine.find(primaryKey); Assert.AreEqual(orderLines.ThisOrderLine, orderLine); }