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