private void buttonOrdDelete_Click(object sender, EventArgs e)
{
DialogResult answer = MessageBox.Show("Do you want to delete this Order?", "Confirmation", MessageBoxButtons.YesNo, MessageBoxIcon.Information);
if (answer == DialogResult.Yes)
{
OrderDA.Delete(Convert.ToInt32((textBoxOrdNumber.Text)));
//int BookQuantity = OrderDA.SearchByNumber(Convert.ToInt32(textBoxOrdNumber.Text)).OrdQuantity;
//decimal orderCost = OrderDA.SearchByNumber(Convert.ToInt32(textBoxOrdNumber.Text)).OrdTotal;
//Books abook = new Books();
//Clients aclient = new Clients();
//abook = BooksDA.SearchByTitle(comboBoxOrdProduct.Text);
//aclient = ClientsDA.Search(comboBoxOrdClient.Text);
//abook.QOH = abook.QOH + BookQuantity;
//aclient.creditLimit = aclient.creditLimit + orderCost;
OrderDA.ListOrder(listViewOrd);
buttonOrdList.PerformClick();
UpdateComboBoxes();
}
}
private void buttonDeleteOrder_Click(object sender, EventArgs e)
{
if (IsValidOrderData())
{
DialogResult ans = MessageBox.Show("Do you really want to delete this Employee?", "Confirmation", MessageBoxButtons.YesNo, MessageBoxIcon.Information);
if (ans == DialogResult.Yes)
{
OrderDA.Delete(textBoxOnumber.Text);
MessageBox.Show("Order record has been deleted successfully", "Confirmation");
ClearAll();
textBoxOnumber.Focus();
}
}
}
//Delete
private void buttonOrdDel_Click(object sender, EventArgs e)
{
DialogResult ans = MessageBox.Show("Are you sure you want to delete this Order?", "Delete Confirmation", MessageBoxButtons.YesNo, MessageBoxIcon.Information);
if (ans == DialogResult.Yes)
{
OrderDA.Delete(Convert.ToInt32(textBoxOrId.Text));
int bkQuantity = OrderDA.SearchID(Convert.ToInt32(textBoxOrId.Text)).OrdBkQuantity;
decimal ordCost = OrderDA.SearchID(Convert.ToInt32(textBoxOrId.Text)).OrdCost;
Book abook = new Book();
Client aclient = new Client();
abook = BookDA.SearchISBN(Convert.ToInt64(comboBoxOrdISBN.Text));
aclient = ClientDA.SearchName(comboBoxOrdClient.Text);
abook.BkQOH = abook.BkQOH + bkQuantity;
aclient.ClientCredit = aclient.ClientCredit + ordCost;
OrderDA.ListOrder(listViewOrder);
UpdateComboBoxes();
}
}
private void btn_Delete_Click(object sender, EventArgs e)
{
OrderDA.Delete(Convert.ToInt32(txt_input.Text));
MessageBox.Show("Order Record data has beeen deleted", "DONE");
}
private void buttonCancelOrder_Click(object sender, EventArgs e)
{
OrderDA.Delete(Convert.ToInt32(textBoxOrderId.Text));
MessageBox.Show("Order has been Cancelled Successfully", "Confirmation");
}
// on logged in
protected void LoggedIn(object sender, EventArgs e)
{
// seeing if there is an order just in case I missed something
if (Session["AnonymousUserName"] != null)
{
// if the user has an order on going delete it and replace it
// with the items that the anonymous user just made(which is really a customer)
//Instantiate our Category specific DataAccess Class
CustomerDA customerDA = new CustomerDA();
// check to see if user has items in their cart
//Create an Object that specifies what we want to Get
Customer customer = new Customer();
//gets customer info based on customer username
customer.Username = UserLogin.UserName;
//We will be returned a collection so lets Declare that and fill it using Get()
Collection<Customer> getCustomer = customerDA.Get(customer);
// count orders with customerid = @customerid and txtnid = @txnid
// instantiate class
Order orders = new Order();
orders.CustomerId = getCustomer[0].Id;
orders.TxnId = "";
OrderDA orderDA = new OrderDA();
Collection<Order> getOrders = orderDA.Get(orders);
// returns number of orders
object getOrder = getOrders.Count;
//clear
orders = null;
orderDA = null;
getOrders = null;
// if the user who is logged has items in his cart as an anonymous user
// delete the items he had previously on his cart and add the new items and order
// that they just put into his cart
if (int.Parse(getOrder.ToString()) > 0)
{
// get the orderID of the customer that he had on going order
// instantiate class
Order oID = new Order();
oID.CustomerId = getCustomer[0].Id;
oID.TxnId = "";
OrderDA ordersDA = new OrderDA();
Collection<Order> getOID = ordersDA.Get(oID);
// returns one item
object getOrderID = getOID[0].Id;
//clear
oID = null;
ordersDA = null;
getOID = null;
// delete the order and items that involve the order above
// delete items from the orderItem table associated with that order if any
//Create an Object that specifies what we want to Get
// OrderItem deleteOrderItem = new OrderItem();
//OrderItemDA deleteOrderItemDA = new OrderItemDA();
////gets orderItem info based on customerID
//deleteOrderItem.OrderId = int.Parse(getOrderID.ToString());
//// deletes the orderItems with that customerID
//deleteOrderItemDA.Delete(deleteOrderItem);
//// clear
//deleteOrderItemDA = null;
//deleteOrderItem = null;
DAL.DataAccess da5 =
new DAL.DataAccess(
ConfigurationManager.ConnectionStrings["MyPetStoreDB"].ConnectionString,
"System.Data.SqlClient");
string comm5 =
"Delete FROM OrderItem WHERE OrderID = @orderID";
// array with orderID
string[] p5 = { "@orderID" };
string[] v5 = { getOrderID.ToString() };
da5.ExecuteNonQuery(comm5, p5, v5);
// clear
p5 = null;
v5 = null;
// delete order
//Instantiate our Order specific DataAccess Class
OrderDA deleteOrderDA = new OrderDA();
//Create an Object that specifies what we want to Get
Order deleteOrder = new Order();
//gets order info based on customerID
deleteOrder.Id = int.Parse(getOrderID.ToString());
// deletes the order with that customerID
deleteOrderDA.Delete(deleteOrder);
// clear
deleteOrderDA = null;
deleteOrder = null;
// get cusotmerID of anonymous user
//Instantiate our Category specific DataAccess Class
CustomerDA customerDA2 = new CustomerDA();
// check to see if user has items in their cart
//Create an Object that specifies what we want to Get
Customer customer2 = new Customer();
//gets customer info based on customer username
customer2.Username = Session["AnonymousUserName"].ToString();
//We will be returned a collection so lets Declare that and fill it using Get()
Collection<Customer> getCustomer2 = customerDA2.Get(customer2);
//for (int i = 0; i < getCustomer2.Count; i++)
//{
// getCustomer2[i].Id;
//}
// get orderID of anonymous user
//Create an Object that specifies what we want to Get
Order ordersID = new Order();
//gets order info based on customerID
ordersID.CustomerId = getCustomer2[0].Id;
OrderDA ordersIDDA = new OrderDA();
// deletes the order with that customerID
Collection<Order> getOrder2 = ordersIDDA.Get(ordersID);
// update the customerid of the anonymous order to the customer, of the user who just logged on
DAL.DataAccess da4 =
new DAL.DataAccess(ConfigurationManager.ConnectionStrings["MyPetStoreDB"].ConnectionString,
"System.Data.SqlClient");
string comm4 =
"UPDATE Orders SET CustomerID = @customerID WHERE OrderID = @orderID AND TXNID = @txnID";
// empty array
string[] p4 = { "@customerID", "@orderID", "@txnID" };
string[] v4 = { getCustomer[0].Id.ToString(), getOrder2[0].Id.ToString(), "" };
// new cus old get order
da4.ExecuteNonQuery(comm4, p4, v4);
// clear
p4 = null;
v4 = null;
// delete anonymous customer from customer table
Customer customers = new Customer();
customers.Id = getCustomer2[0].Id;
CustomerDA customersDA = new CustomerDA();
customersDA.Delete(customers);
// clear
customers = null;
customersDA = null;
//abandon session
Session.Abandon();
Session.Clear();
}
// if user doesn't have an on going order just
// change the customer ID on the order
else
{
// get cusotmerID of anonymous user
//Instantiate our Category specific DataAccess Class
CustomerDA customerDA2 = new CustomerDA();
// check to see if user has items in their cart
//Create an Object that specifies what we want to Get
Customer customer2 = new Customer();
//gets customer info based on customer username
customer2.Username = Session["AnonymousUserName"].ToString();
//We will be returned a collection so lets Declare that and fill it using Get()
Collection<Customer> getCustomer2 = customerDA2.Get(customer2);
//for (int i = 0; i < getCustomer2.Count; i++)
//{
// getCustomer2[i].Id;
//}
// get orderID of anonymous user based on customerID
OrderDA ordersIDDA = new OrderDA();
//Create an Object that specifies what we want to Get
Order ordersID = new Order();
//gets order info based on customerID
ordersID.CustomerId = getCustomer2[0].Id;
// deletes the order with that customerID
Collection<Order> getOrder2 = ordersIDDA.Get(ordersID);
// update the customerid of the anonymous order to the customer, of the user who just logged on
DAL.DataAccess da4 =
new DAL.DataAccess(ConfigurationManager.ConnectionStrings["MyPetStoreDB"].ConnectionString,
"System.Data.SqlClient");
string comm4 =
"UPDATE Orders SET CustomerID = @customerID WHERE OrderID = @orderID AND TXNID = @txnID";
// empty array
string[] p4 = { "@customerID", "@orderID", "@txnID" };
string[] v4 = { getCustomer[0].Id.ToString(), getOrder2[0].Id.ToString(), "" };
// new cus old get order
da4.ExecuteNonQuery(comm4, p4, v4);
// clear
p4 = null;
v4 = null;
// delete anonymous customer from customer table
Customer customers = new Customer();
customers.Id = getCustomer2[0].Id;
CustomerDA customersDA = new CustomerDA();
customersDA.Delete(customers);
// clear
customers = null;
customersDA = null;
//DAL.DataAccess da8 =
// new DAL.DataAccess(
// ConfigurationManager.ConnectionStrings["MyPetStoreDB"].ConnectionString,
// "System.Data.SqlClient");
//string comm8 =
// "Delete FROM Customer WHERE CustomerID = @customerID";
//// array with customerID
//string[] p8 = { "@customerID" };
//string[] v8 = { getCustomer2[0].Id.ToString() };
//da8.ExecuteNonQuery(comm8, p8, v8);
//// clear
//p8 = null;
//v8 = null;
//abandon session
Session.Abandon();
Session.Clear();
}
}
}
