//Delete record public static void DeleteRecord(Customer30028452 thisCustomer) { // this method deletes the related records in Order_Products it then deletes the Orders records and finally deletes the customer. // filter orders by customer id Orders30028452 order = BasePage.dbeCineplex.Orders30028452.Find(thisCustomer.CustomerId); // filter orders and products by order id var orderAndMovies = from eachOP in BasePage.dbeCineplex.MovieOrders30028452 select eachOP; // delete each order and products link foreach (var theOrder in orderAndMovies) { if (theOrder.OrderId == order.OrderId) { BasePage.dbeCineplex.MovieOrders30028452.Remove(theOrder); } } // delete the order BasePage.dbeCineplex.Orders30028452.Remove(order); // filter the customers by customer id var result = from eachCustomer in BasePage.dbeCineplex.Customer30028452 where eachCustomer.CustomerId == thisCustomer.CustomerId select eachCustomer; // delete the customer thisCustomer BasePage.dbeCineplex.Customer30028452.Remove(result.FirstOrDefault()); BasePage.dbeCineplex.SaveChanges(); }
protected void btnPurchase_Click(object sender, EventArgs e) { // Add new customer Customer30028452 theCustomer = new Customer30028452(); theCustomer.Name = txtFName.Text + " " + txtLName.Text; theCustomer.Phone = txtPhone.Text; theCustomer.CType = ddlCardType.SelectedValue; theCustomer.CardNo = txtCreditCardNo.Text; //theCustomer.ExpDate = Convert.ToDateTime("01/" + ddlExpiryMonth.SelectedValue + "/" + ddlExpiryYear.SelectedValue + " 00:00:00.00"); theCustomer.ExpDate = DateTime.Today; theCustomer.Email = txtEmail.Text; CPIStudent_dbEntities c = new CPIStudent_dbEntities(); c.Customer30028452.Add(theCustomer); c.SaveChanges(); // add new order Orders30028452 theOrder = new Orders30028452(); theOrder.Date = DateTime.Today; // create delivery date DateTime theDeliveryDate; theDeliveryDate = theOrder.Date.AddDays(5); // store the delivery date in a session variable to show on the next pages Session["DeliveryDate"] = theDeliveryDate.ToShortDateString(); theOrder.Date = theDeliveryDate; theOrder.CustomerId = theCustomer.CustomerId; //CineplexSystem.BasePage.dbeCineplex.Orders30028452.Add(theOrder); c.Orders30028452.Add(theOrder); //CineplexSystem.BasePage.dbeCineplex.SaveChanges(); c.SaveChanges(); // add order transaction information to database MovieOrders30028452 theOrderMovies; float totalSale; // loop through each product in the shopping cart and add to ordered products table foreach (var cartMovie in shoppingCart) { theOrderMovies = new MovieOrders30028452(); theOrderMovies.OrderId = theOrder.OrderId; // save the Order number in a session variable for the purchase order display page Session["OrderID"] = theOrder.OrderId; //theOrderMovies. = cartMovie.Quantity; theOrderMovies.MovieId = cartMovie.MovieId; totalSale = cartMovie.Price * cartMovie.Quantity; // Total Sale Session["TotalSale"] = totalSale; //CineplexSystem.BasePage.dbeCineplex.MovieOrders30028452.Add(theOrderMovies); c.MovieOrders30028452.Add(theOrderMovies); } // save all database changes //CineplexSystem.BasePage.dbeCineplex.SaveChanges(); c.SaveChanges(); // Clear shopping cart without returning products because the cart items have been purchased. ShoppingCart.Reset(); Response.Redirect("~/PurchaseOrder.aspx"); }