public void AddMethodOK()
{
//creates an instance of class we want to create
ClsOrderCollection AllOrder = new ClsOrderCollection();
//creates item of test data
ClsOrder TestItem = new ClsOrder();
//Var to store primary key
Int32 PrimaryKey = 0;
//Sets its properties
TestItem.OrderID = 1;
TestItem.CustomerID = 45879632;
TestItem.ShippingAddress = "64 potter Lane";
TestItem.OrderStatus = "Pending";
TestItem.OrderDate = DateTime.Now.Date;
TestItem.OrderShipped = false;
//set ThisOrder to the test data
AllOrder.ThisOrder = TestItem;
//add the record
PrimaryKey = AllOrder.Add();
//set primary key of the test data
TestItem.OrderID = PrimaryKey;
//find the record
AllOrder.ThisOrder.Find(PrimaryKey);
//Test to see if the two are the same
Assert.AreEqual(AllOrder.ThisOrder, TestItem);
}
public void DeleteMethodOK()
{
//creates instance of class we want to create
ClsOrderCollection AllOrder = new ClsOrderCollection();
//creates the item of test data
ClsOrder TestItem = new ClsOrder();
//Var to store primary key
Int32 PrimaryKey = 0;
//Sets its properties
TestItem.OrderID = 1;
TestItem.CustomerID = 45879632;
TestItem.ShippingAddress = "64 potter Lane";
TestItem.OrderStatus = "pending";
TestItem.OrderDate = DateTime.Now.Date;
TestItem.OrderShipped = false;
//set ThisOrder to the test data
AllOrder.ThisOrder = TestItem;
//add the record
PrimaryKey = AllOrder.Add();
//set primary key of the test data
TestItem.OrderID = PrimaryKey;
//find the record
AllOrder.ThisOrder.Find(PrimaryKey);
//delete the record
AllOrder.Delete();
//now find the record
Boolean Found = AllOrder.ThisOrder.Find(PrimaryKey);
//Test to see if the record was not found
Assert.IsTrue(Found);
}
public void ListAndCountOK()
{
//creates an instance of class we want to create
ClsOrderCollection AllOrder = new ClsOrderCollection();
//Test data to assign to property
List <ClsOrder> TestList = new List <ClsOrder>();
//creates item of test data
ClsOrder TestItem = new ClsOrder();
//Set properties
TestItem.OrderID = 1;
TestItem.CustomerID = 45879632;
TestItem.ShippingAddress = "64 potter Lane";
TestItem.OrderStatus = "Pending";
TestItem.OrderDate = DateTime.Now.Date;
TestItem.OrderShipped = false;
//Add item to test list
TestList.Add(TestItem);
//reinitialise the object for some new data
TestItem = new ClsOrder();
//sets its properties
TestItem.OrderID = 2;
TestItem.CustomerID = 58974136;
TestItem.ShippingAddress = "54 Queensville";
TestItem.OrderStatus = "Dispatched";
TestItem.OrderDate = DateTime.Now.Date;
TestItem.OrderShipped = true;
//Add item to test list
TestList.Add(TestItem);
//Assign data to the property
AllOrder.OrderList = TestList;
//Test to see if the two are the same
Assert.AreEqual(AllOrder.Count, TestList.Count);
}
protected void BtnApply_Click(object sender, EventArgs e)
{
if (txtOrderStatus.Text == "")
{
lblError.Text = "Please enter an Order status before trying to filter";
}
else
{
//lblError.Text = "";
ClsOrderCollection Orders = new ClsOrderCollection();
Orders.ReportByOrderStatus(txtOrderStatus.Text);
lstOrderList.DataSource = Orders.OrderList;
lstOrderList.DataValueField = "OrderID";
lstOrderList.DataTextField = "allProperties";
lstOrderList.DataBind();
if (lstOrderList.Items.Count > 0)
{
lblError.Text = "";
}
else if (lstOrderList.Items.Count == 0)
{
lblError.Text = "There are no records with the status " + txtOrderStatus.Text + " please try again";
Orders.ReportByOrderStatus("");
txtOrderStatus.Text = "";
DisplayOrders();
}
}
}
protected void BtnApply2_Click(object sender, EventArgs e)
{
lblError.Text = "";
ClsOrderCollection Orders = new ClsOrderCollection();
string orderID = txtOrderID.Text;
int OID = 0;
bool canC = int.TryParse(orderID, out OID);
if (canC == false)
{
lblError.Text = "Please enter a valid OrderID";
}
else
{
Orders.ReportByOrderID(Convert.ToInt32(txtOrderID.Text));
}
lstOrderList.DataSource = Orders.OrderList;
lstOrderList.DataValueField = "OrderID";
lstOrderList.DataTextField = "allProperties";
lstOrderList.DataBind();
if (lstOrderList.Items.Count <= 0)
{
lblError.Text = "There are no records with the OrderID: " + txtOrderID.Text;
}
}
public void UpdateMethodOK()
{
ClsOrderCollection AllOrders = new ClsOrderCollection();
ClsOrder AnOrder = new ClsOrder();
int PrimaryKey = 0;
AnOrder.CustomerID = 2;
AnOrder.CarID = 2;
AnOrder.DateOfOrder = DateTime.Now.Date;
AnOrder.ServiceID = 66;
AnOrder.OrderPrice = 50000;
AnOrder.OrderStatus = "pending";
AnOrder.PaymentID = 3;
AnOrder.Completed = false;
AllOrders.ThisOrder = AnOrder;
PrimaryKey = AllOrders.Add();
AnOrder.OrderID = PrimaryKey;
AnOrder.CustomerID = 2;
AnOrder.CarID = 2;
AnOrder.DateOfOrder = DateTime.Now.Date;
AnOrder.ServiceID = 66;
AnOrder.OrderPrice = 50000;
AnOrder.OrderStatus = "completed";
AnOrder.PaymentID = 3;
AnOrder.Completed = true;
AllOrders.ThisOrder = AnOrder;
AllOrders.Update();
AllOrders.ThisOrder.Find(PrimaryKey);
Assert.AreEqual(AllOrders.ThisOrder, AnOrder);
AllOrders.Delete();
}
public void ReportByOrderStatusNoneFound()
{
ClsOrderCollection FilteredOrders = new ClsOrderCollection();
FilteredOrders.ReportByOrderStatus("XXX");
Assert.AreEqual(0, FilteredOrders.Count);
}
public void ReportByShippingAddressTestDataFound()
{
//creates an instance of the filtered data
ClsOrderCollection FilteredOrder = new ClsOrderCollection();
//var to store outcome
Boolean OK = true;
//apply a Shipping Address which does not exist
FilteredOrder.ReportByShippingAddress("xx xxxx xxxxxx");
//check if that is the correct number of records that are found
if (FilteredOrder.Count == 2)
{
//checks the first record is OrderID 4
if (FilteredOrder.OrderList[0].OrderID != 4)
{
OK = false;
}
//checks the first record is OrderID 5
if (FilteredOrder.OrderList[0].OrderID != 4)
{
OK = false;
}
}
else
{
OK = false;
}
//tests to see that there are no records
Assert.IsFalse(OK);
}
protected void BtnClear2_Click(object sender, EventArgs e)
{
ClsOrderCollection Orders = new ClsOrderCollection();
txtOrderID.Text = "";
DisplayOrders();
lblError.Text = "";
}
public void CountPropertyOK()
{
ClsOrderCollection AllOrder = new ClsOrderCollection();
Int32 SomeCount = 15;
AllOrder.Count = SomeCount;
Assert.AreEqual(AllOrder.Count, SomeCount);
}
protected void btnYes_Click(object sender, EventArgs e)
{
ClsOrderCollection Orders = new ClsOrderCollection();
Orders.ThisOrder.Find(OrderID);
Orders.Delete();
Response.Redirect("OrderList.aspx");
}
protected void BtnClear_Click(object sender, EventArgs e)
{
ClsOrderCollection Orders = new ClsOrderCollection();
Orders.ReportByOrderStatus("");
txtOrderStatus.Text = "";
DisplayOrders();
lblError.Text = "";
}
public void ReportByOrderStatusMethodOK()
{
ClsOrderCollection AllOrders = new ClsOrderCollection();
//ClsOrder AnOrder = new ClsOrder();
ClsOrderCollection FilteredOrders = new ClsOrderCollection();
FilteredOrders.ReportByOrderStatus("");
Assert.AreEqual(AllOrders.Count, FilteredOrders.Count);
}
public void ReportByShippingAddressNoneFound()
{
//creates an instance of the filtered data
ClsOrderCollection FilteredOrder = new ClsOrderCollection();
//applies the Shipping Address that does not exist
FilteredOrder.ReportByShippingAddress("xx xxxx xxxxxx");
//tests to see that there are no records
Assert.AreEqual(0, FilteredOrder.Count);
}
protected void BtnYes_Click(object sender, EventArgs e)
{
//create an instance of the Order Collection
ClsOrderCollection OrderList = new ClsOrderCollection();
//finds the record to delete
OrderList.ThisOrder.Find(OrderID);
//deletes the record
OrderList.Delete();
//Redirects back to the main page
Response.Redirect("OrderList.aspx");
}
public void ReportByShippingAddressMethodOK()
{
//creates an instance of class we want to create
ClsOrderCollection AllOrder = new ClsOrderCollection();
//creates an instance of the filtered data
ClsOrderCollection FilteredOrder = new ClsOrderCollection();
//applies a blank string (should return all the redords);
FilteredOrder.ReportByShippingAddress("");
//tests to see of the two values are the same
Assert.AreEqual(AllOrder.Count, FilteredOrder.Count);
}
void DisplayOrder()
{
//create an instance of the Order collection
ClsOrderCollection OrderCollection = new ClsOrderCollection();
//find the record to update
OrderCollection.ThisOrder.Find(OrderID);
//display the data for this record
txtOrderID.Text = OrderCollection.ThisOrder.OrderID.ToString();
txtOrderDate.Text = OrderCollection.ThisOrder.OrderDate.ToString();
txtCustomerID.Text = OrderCollection.ThisOrder.CustomerID.ToString();
txtShippingAddress.Text = OrderCollection.ThisOrder.ShippingAddress;
}
void DisplayOrder()
{
//create an instance of the Order Collection
ClsOrderCollection Orders = new ClsOrderCollection();
//set the data source to the list of Orders in the collection
lstOrderList.DataSource = Orders.OrderList;
//set the name of the primary key
lstOrderList.DataValueField = "OrderID";
//set the data field to display
lstOrderList.DataTextField = "OrderStatus";
//bind the data to the list
lstOrderList.DataBind();
}
public void ThisOrderPropertyOK()
{
ClsOrderCollection AllOrders = new ClsOrderCollection();
ClsOrder TestItem = new ClsOrder();
TestItem.CustomerID = 2;
TestItem.CarID = 2;
TestItem.DateOfOrder = DateTime.Now.Date;
TestItem.ServiceID = 1;
TestItem.OrderPrice = 5000;
TestItem.OrderStatus = "Done";
TestItem.PaymentID = 1;
TestItem.Completed = true;
AllOrders.ThisOrder = TestItem;
Assert.AreEqual(AllOrders.ThisOrder, TestItem);
}
void DisplayOrders()
{
ClsOrderCollection Orders = new ClsOrderCollection();
Orders.ThisOrder.Find(OrderID);
TxtOrderID.Text = Orders.ThisOrder.OrderID.ToString();
txtCustomerID.Text = Orders.ThisOrder.CustomerID.ToString();
DropDownCars.SelectedValue = Orders.ThisOrder.CarID.ToString();
TxtPaymentID.Text = Orders.ThisOrder.PaymentID.ToString();
DropDownServices.SelectedValue = Orders.ThisOrder.ServiceID.ToString();
TxtDateOfOrder.Text = Orders.ThisOrder.DateOfOrder.ToString();
txtPrice.Text = Orders.ThisOrder.OrderPrice.ToString();
txtOrderStatus.Text = Orders.ThisOrder.OrderStatus;
CheckBoxCompleted.Checked = Orders.ThisOrder.Completed;
}
protected void BtnApply_Click(object sender, EventArgs e)
{
//create an instance of the customer collection
ClsOrderCollection OrderCollection = new ClsOrderCollection();
OrderCollection.ReportByShippingAddress(txtFilter.Text);
//clear any existing filter to tidy up the interface
txtFilter.Text = "";
lstOrderList.DataSource = OrderCollection.OrderList;
//set the name of the primary key
lstOrderList.DataValueField = "OrderID";
//set the name of the field to display
lstOrderList.DataTextField = "ShippingAddress";
//bind the data to the list
lstOrderList.DataBind();
}
public void OrderListOK()
{
ClsOrderCollection AllOrder = new ClsOrderCollection();
List <ClsOrder> TestList = new List <ClsOrder>();
ClsOrder TestItem = new ClsOrder();
TestItem.OrderID = 1;
TestItem.CustomerID = 45879632;
TestItem.ShippingAddress = "64 potter Lane";
TestItem.OrderStatus = "Pending";
TestItem.OrderDate = DateTime.Now.Date;
TestItem.OrderShipped = false;
TestList.Add(TestItem);
AllOrder.OrderList = TestList;
Assert.AreEqual(AllOrder.OrderList, TestList);
}
public void ListAndCountOK()
{
ClsOrderCollection AllOrders = new ClsOrderCollection();
List <ClsOrder> TestList = new List <ClsOrder>();
ClsOrder TestItem = new ClsOrder();
TestItem.CustomerID = 2;
TestItem.CarID = 2;
TestItem.DateOfOrder = DateTime.Now.Date;
TestItem.ServiceID = 66;
TestItem.OrderPrice = 5000;
TestItem.OrderStatus = "test";
TestItem.PaymentID = 1;
TestItem.Completed = true;
TestList.Add(TestItem);
AllOrders.OrderList = TestList;
Assert.AreEqual(AllOrders.Count, TestList.Count);
}
public void ThisOrderPropertyOK()
{
ClsOrderCollection AllOrder = new ClsOrderCollection();
//Test data to assign to property
ClsOrder TestOrder = new ClsOrder();
//Set properties of the test item
TestOrder.OrderID = 1;
TestOrder.CustomerID = 45879632;
TestOrder.ShippingAddress = "64 potter Lane";
TestOrder.OrderStatus = "Pending";
TestOrder.OrderDate = DateTime.Now.Date;
TestOrder.OrderShipped = false;
//Assign data to the property
AllOrder.ThisOrder = TestOrder;
//Test to see that the two are the same
Assert.AreEqual(AllOrder.ThisOrder, TestOrder);
}
public void AddMethodOK()
{
ClsOrderCollection AllOrders = new ClsOrderCollection();
ClsOrder AnOrder = new ClsOrder();
int PrimaryKey = 0;
AnOrder.CustomerID = 2;
AnOrder.CarID = 2;
AnOrder.DateOfOrder = DateTime.Now.Date;
AnOrder.ServiceID = 66;
AnOrder.OrderPrice = 5000;
AnOrder.OrderStatus = "test";
AnOrder.PaymentID = 3;
AnOrder.Completed = true;
AllOrders.ThisOrder = AnOrder;
PrimaryKey = AllOrders.Add();
AnOrder.OrderID = PrimaryKey;
AllOrders.ThisOrder.Find(PrimaryKey);
Assert.AreEqual(AllOrders.ThisOrder, AnOrder);
AllOrders.Delete(); // This to delete the new record we have just made for consistancey with the rest of the test.
}
public void UpdateMethodOK()
{
//creates an instance of class we want to create
ClsOrderCollection AllOrder = new ClsOrderCollection();
//creates item of test data
ClsOrder TestItem = new ClsOrder();
//Var to store primary key
Int32 PrimaryKey = 0;
//Sets its properties
TestItem.OrderID = 1;
TestItem.CustomerID = 45879632;
TestItem.ShippingAddress = "64 potter Lane";
TestItem.OrderStatus = "Pending";
TestItem.OrderDate = DateTime.Now.Date;
TestItem.OrderShipped = false;
//set ThisOrder to the test data
AllOrder.ThisOrder = TestItem;
//add the record
PrimaryKey = AllOrder.Add();
//set primary key of the test data
TestItem.OrderID = PrimaryKey;
//modify test data
TestItem.OrderID = 2;
TestItem.CustomerID = 58974136;
TestItem.ShippingAddress = "54 Queensville";
TestItem.OrderStatus = "Dispatched";
TestItem.OrderDate = DateTime.Now.Date;
TestItem.OrderShipped = true;
//sets the record based on new data
AllOrder.ThisOrder = TestItem;
//updates record
AllOrder.Update();
//find record
AllOrder.ThisOrder.Find(PrimaryKey);
//tests to see if ThisOrder matches test data
Assert.AreEqual(AllOrder.ThisOrder, TestItem);
}
public void DeleteMethodOK()
{
ClsOrderCollection AllOrders = new ClsOrderCollection();
ClsOrder AnOrder = new ClsOrder();
int PrimaryKey = 0;
AnOrder.CustomerID = 2;
AnOrder.CarID = 2;
AnOrder.DateOfOrder = DateTime.Now.Date;
AnOrder.ServiceID = 66;
AnOrder.OrderPrice = 50000;
AnOrder.OrderStatus = "Done";
AnOrder.PaymentID = 3;
AnOrder.Completed = true;
AllOrders.ThisOrder = AnOrder;
PrimaryKey = AllOrders.Add();
AnOrder.OrderID = PrimaryKey;
AllOrders.ThisOrder.Find(PrimaryKey);
AllOrders.Delete();
bool Found = AllOrders.ThisOrder.Find(PrimaryKey);
Assert.IsFalse(Found);
}
public void ReportByOrderStatusTestDataFound()
{
ClsOrderCollection FilteredOrders = new ClsOrderCollection();
Boolean OK = true;
FilteredOrders.ReportByOrderStatus("completed");
if (FilteredOrders.Count == 8)
{
if (FilteredOrders.OrderList[0].OrderID != 51)
{
OK = false;
}
if (FilteredOrders.OrderList[1].OrderID != 52)
{
OK = false;
}
}
else
{
OK = false;
}
Console.Write(FilteredOrders.Count);
Assert.IsTrue(OK);
}
protected void btnSubmit_Click(object sender, EventArgs e)
{
// Old
//ClsOrder AnOrder = new ClsOrder();
//AnOrder.OrderID = Convert.ToInt32(TxtOrderID.Text);
//AnOrder.CustomerID = Convert.ToInt32(txtCustomerID.Text);
//AnOrder.CarID = txtCar.Text;
//AnOrder.DateOfOrder = Convert.ToDateTime(TxtDateOfOrder.Text);
////AnOrder.ServiceID = DropDownServices.SelectedValue;
//Session["AnOrder"] = AnOrder;
//Response.Redirect("OrderViewer.aspx");
// New
ClsOrder AnOrder = new ClsOrder();
string orderID = TxtOrderID.Text;
string DateOfOrder = TxtDateOfOrder.Text;
string customerID = txtCustomerID.Text;
string OrderPrice = txtPrice.Text;
string OrderStatus = txtOrderStatus.Text;
string Error = "";
Error = AnOrder.Valid(DateOfOrder, OrderPrice, OrderStatus);
if (Error == "")
{
int OID = 0;
bool canC = int.TryParse(orderID, out OID);
if (canC == false)
{
AnOrder.OrderID = OrderID;
}
else
{
AnOrder.OrderID = Convert.ToInt32(TxtOrderID.Text);
}
int OIDC = 0;
bool canCC = int.TryParse(customerID, out OIDC);
if (canCC == false)
{
AnOrder.CustomerID = CustomerID;
}
else
{
AnOrder.CustomerID = Convert.ToInt32(txtCustomerID.Text);
}
AnOrder.CarID = Convert.ToInt32(DropDownCars.SelectedValue);
AnOrder.DateOfOrder = Convert.ToDateTime(DateOfOrder);
AnOrder.ServiceID = Convert.ToInt32(DropDownServices.SelectedValue);
double price;
price = Convert.ToDouble(OrderPrice);
AnOrder.OrderPrice = price;
AnOrder.OrderStatus = OrderStatus;
AnOrder.PaymentID = Convert.ToInt32(TxtPaymentID.Text);
AnOrder.Completed = CheckBoxCompleted.Checked;
ClsOrderCollection OrderList = new ClsOrderCollection();
if (OrderID == -1)
{
OrderList.ThisOrder = AnOrder;
OrderList.Add();
}
else
{
OrderList.ThisOrder.Find(OrderID);
OrderList.ThisOrder = AnOrder;
OrderList.Update();
}
Response.Redirect("OrderList.aspx");
}
else
{
lblError.Text = Error;
}
}
public void InstanceOK()
{
ClsOrderCollection AllOrders = new ClsOrderCollection();
Assert.IsNotNull(AllOrders);
}