public void AddMethodOK() { // create an instance for the class we want to create clsOrderlineCollection AllOrderline = new clsOrderlineCollection(); // create the item of the test data clsOrderline TestItem = new clsOrderline(); // var to store the primary key Int32 PrimaryKey = 0; // set it properties TestItem.OrderlineId = 2; TestItem.OrderId = 1; TestItem.Quantity = 1; TestItem.InventoryId = 1; // set thisAdress to the test data AllOrderline.ThisOrderline = TestItem; // add the record PrimaryKey = AllOrderline.Add(); // set the primary key TestI data TestItem.OrderlineId = PrimaryKey; // find the record AllOrderline.ThisOrderline.Find(PrimaryKey); // test to see that the two values are the same Assert.AreEqual(AllOrderline.ThisOrderline, TestItem); }
public void DeleteMethodOK() { // create an instance for the class we want to create clsOrderlineCollection AllOrderline = new clsOrderlineCollection(); // create the item of the test data clsOrderline TestItem = new clsOrderline(); // var to store the primary key Int32 PrimaryKey = 0; // set it properties TestItem.OrderlineId = 2; TestItem.OrderId = 4; TestItem.Quantity = 1; TestItem.InventoryId = 1; // set thisAdress to the test data AllOrderline.ThisOrderline = TestItem; // add the record PrimaryKey = AllOrderline.Add(); // set the primary key TestI data TestItem.OrderlineId = PrimaryKey; // find the record AllOrderline.ThisOrderline.Find(PrimaryKey); // delete the record AllOrderline.Delete(); //now find the record Boolean Found = AllOrderline.ThisOrderline.Find(PrimaryKey); // test to see that the record was not found Assert.IsFalse(Found); }
public void UpdateMethod() { //create an instance of a class clsOrderlineCollection AllOrderline = 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.BookingID = 1; TestItem.BookingNo = "CASD4"; TestItem.Quantity = 10; //set ThisOrderline to the test data AllOrderline.ThisOrderline = TestItem; //add the record PrimaryKey = AllOrderline.Add(); //set the primary key of the test data TestItem.OrderlineID = PrimaryKey; //modify the test data TestItem.BookingID = 3; TestItem.BookingNo = "FGSD7"; TestItem.Quantity = 5; //set the record based on the new test data AllOrderline.ThisOrderline = TestItem; //update the record AllOrderline.Update(); //find the record AllOrderline.ThisOrderline.Find(PrimaryKey); //test to see thisOrderline matches the test data Assert.AreEqual(AllOrderline.ThisOrderline, TestItem); }
public void DeleteMethod() { //create an instance of a class clsOrderlineCollection AllOrderline = 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 = 1; TestItem.BookingID = 1; TestItem.BookingNo = "CASD4"; TestItem.Quantity = 10; //set ThisOrderline to the test data AllOrderline.ThisOrderline = TestItem; //add the record PrimaryKey = AllOrderline.Add(); //set the primary key of the test data TestItem.OrderlineID = PrimaryKey; //find the record AllOrderline.ThisOrderline.Find(PrimaryKey); //delete the record AllOrderline.Delete(); //now find the record Boolean Found = AllOrderline.ThisOrderline.Find(PrimaryKey); //test to see that the record was not found Assert.IsFalse(Found); }
protected void Button_OrderLOK_Click(object sender, EventArgs e) { clsOrderline AnOrderL = new clsOrderline(); string ONumber = TextBox_OrderLONumber.Text; string Quantity = TextBox_OrderLQuantity.Text; string ShoeID = TextBox_ShoeID.Text; string Error = ""; Error = AnOrderL.Valid(ONumber, Quantity, ShoeID); if (Error == "") { AnOrderL.OLineNumber = OLineNumber; AnOrderL.ONumber = Convert.ToInt32(ONumber); AnOrderL.Quantity = Convert.ToInt32(Quantity); AnOrderL.ShoeID = Convert.ToInt32(ShoeID); clsOrderlineCollection OrderlineList = new clsOrderlineCollection(); if (OLineNumber == -1) { OrderlineList.ThisOrderline = AnOrderL; OrderlineList.Add(); } else { OrderlineList.ThisOrderline.Find(OLineNumber); OrderlineList.ThisOrderline = AnOrderL; OrderlineList.Update(); } Response.Redirect("OrderlineList.aspx"); } else { Label_OrderLError.Text = Error; } }
public void AddMethodOK() { clsOrderlineCollection AllOrderlines = new clsOrderlineCollection(); clsOrderline TestItem = new clsOrderline(); Int32 PKey = 0; TestItem.OLineNumber = 1; TestItem.ONumber = 1; TestItem.Quantity = 1; TestItem.ShoeID = 1; AllOrderlines.ThisOrderline = TestItem; PKey = AllOrderlines.Add(); TestItem.OLineNumber = PKey; AllOrderlines.ThisOrderline.Find(PKey); Assert.AreEqual(AllOrderlines.ThisOrderline, TestItem); }
public void DeleteMethodOK() { clsOrderlineCollection AllOrderlines = new clsOrderlineCollection(); clsOrderline TestItem = new clsOrderline(); Int32 PKey = 0; TestItem.OLineNumber = 1; TestItem.ONumber = 1; TestItem.Quantity = 1; TestItem.ShoeID = 1; AllOrderlines.ThisOrderline = TestItem; PKey = AllOrderlines.Add(); TestItem.OLineNumber = PKey; AllOrderlines.ThisOrderline.Find(PKey); AllOrderlines.Delete(); Boolean Found = AllOrderlines.ThisOrderline.Find(PKey); Assert.IsFalse(Found); }
public void AddMethod() { //create an instance of a class clsOrderlineCollection AllOrderline = 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 = 1; TestItem.BookingID = 1; TestItem.BookingNo = "CASD4"; TestItem.Quantity = 10; //set ThisOrderline to the test data AllOrderline.ThisOrderline = TestItem; //add the record PrimaryKey = AllOrderline.Add(); //set the primary key of the test data TestItem.OrderlineID = PrimaryKey; //find the record AllOrderline.ThisOrderline.Find(PrimaryKey); }
//function for adding new records void Add() { //create an instance of the Orderline Book clsOrderlineCollection OrderlineBook = new clsOrderlineCollection(); //validate the data on the web form string Error = OrderlineBook.ThisOrderline.Valid(txtBookingNo.Text, txtQuantity.Text); //if the data is ok then add it to the object if (Error == "") { //get the data entered by the user OrderlineBook.ThisOrderline.BookingNo = txtBookingNo.Text; OrderlineBook.ThisOrderline.Quantity = Convert.ToInt32(txtQuantity.Text); //add the record OrderlineBook.Add(); //all done so redirect back to the main page Response.Redirect("OrderlineList.aspx"); } else { //report an error lblError.Text = "There are problems with the data entered " + Error; } }