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);
}
