public ActionResult DeleteConfirmed(int id) { if (Session["admin"] == null) { return(RedirectToAction("Login")); } tbl_Bill tbl_Bill = db.tbl_Bill.Find(id); db.tbl_Bill.Remove(tbl_Bill); db.SaveChanges(); return(RedirectToAction("Index")); }
public ActionResult Edit([Bind(Include = "id,level_status,cus_id,created_at,total_price,cus_name")] tbl_Bill tbl_Bill) { if (Session["admin"] == null) { return(RedirectToAction("Login")); } if (ModelState.IsValid) { db.Entry(tbl_Bill).State = System.Data.Entity.EntityState.Modified; db.SaveChanges(); return(RedirectToAction("Index")); } ViewBag.cus_id = new SelectList(db.tbl_Customer, "id", "username", tbl_Bill.cus_id); return(View(tbl_Bill)); }
public ActionResult ThemHD(FormCollection collection, tbl_Bill hd) { var t_tenkh = Request.Form["TenKH"]; var t_tennv = Request.Form["TenNV"]; var t_tinhtrang = Request.Form["TinhTrang"]; hd.CustomerID = Convert.ToInt32(t_tenkh); hd.PersionalID = Convert.ToInt32(t_tennv); hd.DateCreate = DateTime.Now; hd.Status = Convert.ToBoolean(t_tinhtrang); ddd.tbl_Bills.InsertOnSubmit(hd); ddd.SubmitChanges(); Session["cthd1"] = hd.Id; Session["TrangThai1"] = hd.Status; return(this.ThemHD()); }
// GET: Bill/Details/5 public ActionResult Details(int?id) { if (Session["admin"] == null) { return(RedirectToAction("Login")); } if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } tbl_Bill tbl_Bill = db.tbl_Bill.Find(id); if (tbl_Bill == null) { return(HttpNotFound()); } return(View(tbl_Bill)); }
// GET: Bill/Edit/5 public ActionResult Edit(int?id) { if (Session["admin"] == null) { return(RedirectToAction("Login")); } if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } tbl_Bill tbl_Bill = db.tbl_Bill.Find(id); if (tbl_Bill == null) { return(HttpNotFound()); } ViewBag.cus_id = new SelectList(db.tbl_Customer, "id", "username", tbl_Bill.cus_id); return(View(tbl_Bill)); }
//GET: Cancel Ordering public ActionResult CancelOrdering(int?id) { if (id == null) { return(View("../Err")); } tbl_Bill bill = db.tbl_Bill.Find(id); bill.level_status = 4; List <tbl_BillDetail> billList = db.tbl_BillDetail.Where(bD => bD.bill_id == id).ToList(); for (int i = 0; i < billList.Count; i++) { tbl_Product p = db.tbl_Product.Find(billList[i].pro_id); p.amount += billList[i].amount; db.Entry(p).State = System.Data.Entity.EntityState.Modified; } db.Entry(bill).State = System.Data.Entity.EntityState.Modified; db.SaveChanges(); return(Redirect(Request.UrlReferrer.AbsoluteUri)); }
//GET: Order public ActionResult Ordering() { CartData cart = (CartData)Session["cart"]; if (cart.amounts == 0) { return(Redirect(Request.UrlReferrer.AbsoluteUri)); } String cus_address = Request.Form.Get("address"); String cus_name = Request.Form.Get("name"); tbl_Customer cus = (tbl_Customer)Session["user"]; CartData cartList = (CartData)Session["cart"]; tbl_Bill bill = db.tbl_Bill.Create(); bill.cus_id = cus.id; bill.level_status = 0; bill.total_price = cartList.cost; bill.cus_address = cus_address; bill.cus_name = cus_name; bill.created_at = DateTime.Now; db.tbl_Bill.Add(bill); for (int i = 0; i < cartList.arrCart.Count; i++) { Cart c = (Cart)cartList.arrCart[i]; tbl_BillDetail billDetail = db.tbl_BillDetail.Create(); billDetail.bill_id = bill.id; billDetail.pro_id = c.item.id; billDetail.price = c.cost * c.amounts; billDetail.amount = c.amounts; db.tbl_BillDetail.Add(billDetail); tbl_Product p = db.tbl_Product.Find(c.item.id); p.amount -= c.amounts; db.Entry(p).State = System.Data.Entity.EntityState.Modified; } db.SaveChanges(); Session.Remove("cart"); return(RedirectToAction("Account")); }