public ActionResult deleteTrash(int id)
{
order morder = db.orders.Find(id);
var orderDetail = db.ordersdetails.Where(m => m.orderid == morder.ID).ToList();
foreach (var item in orderDetail)
{
var idd = int.Parse(item.ticketId.ToString());
ticket ticket = db.tickets.Find(idd);
ticket.sold = ticket.sold - item.quantity;
db.Entry(ticket).State = EntityState.Modified;
db.SaveChanges();
}
foreach (var orItem in orderDetail)
{
ordersdetail or = db.ordersdetails.Find(orItem.ID);
db.ordersdetails.Remove(or);
db.SaveChanges();
}
db.orders.Remove(morder);
db.SaveChanges();
Message.set_flash("Đã xóa vĩnh viễn 1 Đơn hàng", "success");
return(RedirectToAction("trash"));
}
public ActionResult canelOrder(int OrderId)
{
order morder = db.orders.Find(OrderId);
var orderDetail = db.ordersdetails.Where(m => m.orderid == morder.ID).ToList();
foreach (var item in orderDetail)
{
var id = int.Parse(item.ticketId.ToString());
ticket ticket = db.tickets.Find(id);
ticket.sold = ticket.sold - item.quantity;
db.Entry(ticket).State = EntityState.Modified;
db.SaveChanges();
}
var orderdetail = db.ordersdetails.Where(m => m.orderid == morder.ID);
foreach (var orItem in orderDetail)
{
ordersdetail or = db.ordersdetails.Find(orItem.ID);
db.ordersdetails.Remove(or);
db.SaveChanges();
}
db.orders.Remove(morder);
db.SaveChanges();
Message.set_flash("Đã hủy 1 đơn hàng", "success");
return(Redirect("~/tai-khoan"));
}
public ActionResult AddSDet(ordersdetail ordersdetailmodel, int id)
{
ordersdetailmodel.OrderId = id;
using (QWDBEntities db = new QWDBEntities())
{
var GetServicePrice = db.services.Find(ordersdetailmodel.ServiceId).Price;
ordersdetailmodel.Price = GetServicePrice;
}
DetailsLists.ordsd.Add(ordersdetailmodel);
return(PartialView("_AddedDet", detailsLists()));
}
public ActionResult checkOut(order order, FormCollection fc)
{
var iddd = 0;
user sessionUser = (user)Session[Common.CommonConstants.CUSTOMER_SESSION];
if (sessionUser != null)
{
iddd = sessionUser.ID;
}
float total = float.Parse(fc["total"]);
order.created_ate = DateTime.Now;
order.status = 1;
order.total = total;
order.CusId = iddd;
db.orders.Add(order);
db.SaveChanges();
int lastOrderID = order.ID;
ordersdetail orderDetail = new ordersdetail();
int id1 = int.Parse(fc["veOnvay"]);
orderDetail.ticketId = id1;
orderDetail.quantity = order.guestTotal;
orderDetail.orderid = lastOrderID;
db.ordersdetails.Add(orderDetail);
// tru so luong nghe
var ticket = db.tickets.Find(id1);
ticket.sold = ticket.sold + order.guestTotal;
db.Entry(ticket).State = EntityState.Modified;
//neu ton tai ve 2 chieu
if (!string.IsNullOrEmpty(fc["veReturn"]))
{
int id2 = int.Parse(fc["veReturn"]);
ordersdetail orderDetail2 = new ordersdetail();
orderDetail2.ticketId = id2;
orderDetail2.orderid = lastOrderID;
orderDetail2.quantity = order.guestTotal;
db.ordersdetails.Add(orderDetail2);
// tru so luong nghe
var ticket2 = db.tickets.Find(id2);
ticket2.sold = ticket2.sold + order.guestTotal;
db.Entry(ticket2).State = EntityState.Modified;
}
db.SaveChanges();
return(View("checkOutComfin", order));
}
