public ActionResult DeleteConfirmed(int id) { Food_Order food_Order = db.Food_Order.Find(id); db.Food_Order.Remove(food_Order); db.SaveChanges(); return(RedirectToAction("Index")); }
public ActionResult <ReceiptViewModel> bookTableWithOrder(BookingOrderViewModel model) { Booking booking = new Booking() { ReservationDate = DateTime.Now, ReservedDate = model.booking.ReservedDate, customer_Id = model.booking.customer_Id, table_Id = model.booking.table_Id, CheckInTime = model.booking.CheckInTime, CheckOutTime = model.booking.CheckInTime + 1, TotalPrice = 0 }; _context.Add(booking); _context.SaveChanges(); foreach (var item in model.food_Orders) { Order order = new Order() { Date = DateTime.Now, }; _context.Add(order); _context.SaveChanges(); Food_Order food_Order = new Food_Order() { Quantity = item.Quantity, OrderPrice = _context.Foods.Where(m => m.Id == item.food_Id).Select(m => m.Price).FirstOrDefault(), food_Id = item.food_Id, foodName = _context.Foods.Where(m => m.Id == item.food_Id).Select(m => m.Name).FirstOrDefault(), order_Id = order.Id, booking_Id = booking.Id, TotalOrderPrice = item.Quantity * _context.Foods.Where(m => m.Id == item.food_Id).Select(m => m.Price).FirstOrDefault(), }; _context.Add(food_Order); _context.SaveChanges(); Food ExistedFood = _context.Foods.Where(f => f.Id == item.food_Id).FirstOrDefault(); ExistedFood.Stock = ExistedFood.Stock - item.Quantity.Value; _context.SaveChanges(); booking.TotalPrice += food_Order.TotalOrderPrice.Value; _context.SaveChanges(); } ReceiptViewModel receipt = new ReceiptViewModel(); receipt.customerName = _context.Customers.Where(c => c.UserId == booking.customer_Id).Select(c => c.Name).FirstOrDefault(); receipt.tableNO = _context.Tables.Where(c => c.Id == booking.table_Id).Select(c => c.NO).FirstOrDefault(); receipt.NOofPersons = _context.Tables.Where(c => c.Id == booking.table_Id).Select(c => c.NOofPersons).FirstOrDefault(); receipt.ReservedDate = booking.ReservedDate.Value.ToString("dd/MM/yyyy"); receipt.CheckInTime = booking.CheckInTime; receipt.CheckOutTime = booking.CheckOutTime; List <Food_Order> customerFoodOrders = _context.Food_Orders.Where(f => f.booking == booking).ToList(); receipt.foodOrders = customerFoodOrders; receipt.TotalBookingPrice = booking.TotalPrice; return(Ok(receipt)); }
public ActionResult Edit([Bind(Include = "ID,Cus_Id,Item_Id,OrderDate,Quantity,Total_Price")] Food_Order food_Order) { if (ModelState.IsValid) { db.Entry(food_Order).State = EntityState.Modified; db.SaveChanges(); return(RedirectToAction("Index")); } ViewBag.Cus_Id = new SelectList(db.Customers, "ID", "Cus_Name", food_Order.Cus_Id); ViewBag.Item_Id = new SelectList(db.Items, "ID", "Item_Name", food_Order.Item_Id); return(View(food_Order)); }
public ActionResult Details(int?id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } Food_Order food_Order = db.Food_Order.Find(id); if (food_Order == null) { return(HttpNotFound()); } return(View(food_Order)); }
public ActionResult Edit(int?id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } Food_Order food_Order = db.Food_Order.Find(id); if (food_Order == null) { return(HttpNotFound()); } ViewBag.Cus_Id = new SelectList(db.Customers, "ID", "Cus_Name", food_Order.Cus_Id); ViewBag.Item_Id = new SelectList(db.Items, "ID", "Item_Name", food_Order.Item_Id); return(View(food_Order)); }
protected void btnPay_Click(object sender, EventArgs e) { // Customer Id string userId = ""; // Reservation Detail string type = ""; // Food Order string food_id = ""; string food_name = ""; string qty = ""; // Payment decimal totalPrice = 0; if (!string.IsNullOrEmpty(Session["Id"] as string)) { userId = Session["id"].ToString(); if (Page.IsValid) { int randomId; Random random = new Random(); bool repeatId = false; string cust_id; // Booking string bookingId = ""; int person = 0; string seatArea = ""; DateTime dt; // Booking person = int.Parse(Session["person"].ToString()); seatArea = Session["seatArea"].ToString(); dt = DateTime.Parse(Session["datetime"].ToString()); // Generate Booking Id do { randomId = random.Next(10000, 999999); bookingId = "RES" + randomId; var p = OneDB.ReservationBKs.SingleOrDefault(b => b.resID == bookingId); if (p == null) { repeatId = true; } } while (repeatId == false); //For random code generate var chars = "ABCDEFGHIJKLMNOPQRSTUVWXYZabcdefghijklmnopqrstuvwxyz0123456789"; var stringChars = new char[8]; for (int i = 0; i < stringChars.Length; i++) { stringChars[i] = chars[random.Next(chars.Length)]; } var finalString = new String(stringChars); cust_id = userId; ReservationBK book = new ReservationBK { resID = bookingId, resHeadCount = person, resArea = seatArea, resDate = dt, customer_ID = cust_id }; OneDB.ReservationBKs.InsertOnSubmit(book); OneDB.SubmitChanges(); // Reservation Detail string rd_id; type = Session["reserveType"].ToString(); string res_id; res_id = bookingId; // Generate Reservation Detail Id do { randomId = random.Next(10000, 999999); rd_id = "RD" + randomId; var p = OneDB.Reservation_Details.SingleOrDefault(b => b.resDetail_iD == rd_id); if (p == null) { repeatId = true; } } while (repeatId == false); //For random code generate var RDchars = "ABCDEFGHIJKLMNOPQRSTUVWXYZabcdefghijklmnopqrstuvwxyz0123456789"; var RDstringChars = new char[8]; for (int i = 0; i < RDstringChars.Length; i++) { RDstringChars[i] = chars[random.Next(RDchars.Length)]; } var RDfinalString = new String(RDstringChars); // Insert in Reservation Detail Table Reservation_Detail resDetail = new Reservation_Detail { resDetail_iD = rd_id, resDetail_type = type, reservation_ID = res_id }; OneDB.Reservation_Details.InsertOnSubmit(resDetail); OneDB.SubmitChanges(); // Food Order food_name = Session["foodname"].ToString(); qty = Session["foodquantity"].ToString(); // Generate Reservation Id do { randomId = random.Next(10000, 999999); food_id = "FO" + randomId; var p = OneDB.Food_Orders.SingleOrDefault(b => b.foodID == food_id); if (p == null) { repeatId = true; } } while (repeatId == false); //For random code generate var FOchars = "ABCDEFGHIJKLMNOPQRSTUVWXYZabcdefghijklmnopqrstuvwxyz0123456789"; var FOstringChars = new char[8]; for (int i = 0; i < FOstringChars.Length; i++) { FOstringChars[i] = chars[random.Next(FOchars.Length)]; } var FOfinalString = new String(FOstringChars); // Insert in Food Order Food_Order order = new Food_Order { foodID = food_id, }; OneDB.Food_Orders.InsertOnSubmit(order); OneDB.SubmitChanges(); // Food Order Detail string orderid = ""; food_name = Session["foodname"].ToString(); qty = Session["foodquantity"].ToString(); var id = food_id; // Generate Reservation Id do { randomId = random.Next(10000, 999999); orderid = "FD" + randomId; var p = OneDB.FoodOrderDetails.SingleOrDefault(b => b.OrderId == orderid); if (p == null) { repeatId = true; } } while (repeatId == false); //For random code generate var FDchars = "ABCDEFGHIJKLMNOPQRSTUVWXYZabcdefghijklmnopqrstuvwxyz0123456789"; var FDstringChars = new char[8]; for (int i = 0; i < FDstringChars.Length; i++) { FDstringChars[i] = chars[random.Next(FDchars.Length)]; } var FDfinalString = new String(FDstringChars); // Insert in Food Order Detail FoodOrderDetail od = new FoodOrderDetail { OrderId = food_id, Id = orderid, foodName = food_name, quantity = qty }; OneDB.FoodOrderDetails.InsertOnSubmit(od); OneDB.SubmitChanges(); // Address string address_id; string firstName = txtFirst.Text; string lastName = txtLast.Text; string address = txtAddress.Text; string postcode = txtPostcode.Text; string state = txtState.Text; cust_id = userId; // Generate Reservation Id do { randomId = random.Next(10000, 999999); address_id = "ADD" + randomId; var p = OneDB.Addresses.SingleOrDefault(b => b.Id == address_id); if (p == null) { repeatId = true; } } while (repeatId == false); //For random code generate var ADchars = "ABCDEFGHIJKLMNOPQRSTUVWXYZabcdefghijklmnopqrstuvwxyz0123456789"; var ADstringChars = new char[8]; for (int i = 0; i < ADstringChars.Length; i++) { ADstringChars[i] = chars[random.Next(ADchars.Length)]; } var ADfinalString = new String(ADstringChars); // Insert in Address Address a = new Address() { Id = address_id, FirstName = firstName, LastName = lastName, AddressLine = address, Postcode = postcode, State = state, Customer_ID = cust_id }; OneDB.Addresses.InsertOnSubmit(a); OneDB.SubmitChanges(); // Payment string pay_id; totalPrice = decimal.Parse(Session["total"].ToString()); DateTime payDate = DateTime.Now; cust_id = userId; string payFoodid = food_id; // Generate Reservation Id do { randomId = random.Next(10000, 999999); pay_id = "P" + randomId; var p = OneDB.Checkouts.SingleOrDefault(b => b.paymentID == pay_id); if (p == null) { repeatId = true; } } while (repeatId == false); //For random code generate var Pchars = "ABCDEFGHIJKLMNOPQRSTUVWXYZabcdefghijklmnopqrstuvwxyz0123456789"; var PstringChars = new char[8]; for (int i = 0; i < PstringChars.Length; i++) { PstringChars[i] = chars[random.Next(Pchars.Length)]; } var PfinalString = new String(PstringChars); // Insert in Checkout Checkout c = new Checkout() { paymentID = pay_id, totalPrice = totalPrice, paymentDate = payDate, Customer_ID = cust_id, foodID = food_id }; OneDB.Checkouts.InsertOnSubmit(c); OneDB.SubmitChanges(); // Check In string chk_code = ""; // Generate Reservation Id randomId = random.Next(10000, 999999); chk_code = randomId.ToString(); //For random code generate var CHKchars = "ABCDEFGHIJKLMNOPQRSTUVWXYZabcdefghijklmnopqrstuvwxyz0123456789"; var CHKstringChars = new char[6]; for (int i = 0; i < CHKstringChars.Length; i++) { CHKstringChars[i] = chars[random.Next(CHKchars.Length)]; } var CHKfinalString = new String(CHKstringChars); string booking = "Booking"; string status = "Pending"; // Insert in Check in Check_In chk = new Check_In { check_code = CHKfinalString, check_type = booking, check_status = status }; OneDB.Check_Ins.InsertOnSubmit(chk); OneDB.SubmitChanges(); var email = Session["email"]; // Send Email try { MailMessage mailMessage = new MailMessage(); mailMessage.To.Add(email.ToString()); mailMessage.From = new MailAddress("*****@*****.**"); mailMessage.Subject = "Verification Mail"; mailMessage.Body = "<h3>hi</h3> " + "<h2>your booking verification code are</h2> <p>" + "<h1>" + CHKfinalString + "</h1>"; mailMessage.IsBodyHtml = true; SmtpClient smtpClient = new SmtpClient(); smtpClient.Host = "smtp.gmail.com"; smtpClient.Port = 587; smtpClient.Credentials = new System.Net.NetworkCredential ("*****@*****.**", "cornhub666lol"); smtpClient.EnableSsl = true; smtpClient.Send(mailMessage); } catch (Exception ex) { Response.Write("Unable to send the e-mail <br/>" + ex.Message); } displayStatus.Text = "Payment Successful!"; Server.Transfer("~/Reservation/PaymentSuccessful.aspx"); } } }