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