public ActionResult OrderProccess(FormCollection f) { List <CartItem> listcart = Session["CartSession"] as List <CartItem>; Hoa_Don bill = new Hoa_Don() { mahd = f["mahd"], ten_kh = f["customerName"], diachi = f["address"], ngaytao = DateTime.Now, trangthai = "Proccessing", }; db.Hoa_Don.Add(bill); db.SaveChanges(); foreach (CartItem cart in listcart) { SP_HD billDetail = new SP_HD() { mahd = bill.mahd, masp = cart.masp, sl = cart.sl, gia = cart.gia }; db.SP_HD.Add(billDetail); db.SaveChanges(); } Session.Remove(CartSession); return(View("OrderProccess")); }
public ActionResult DeleteConfirmed(int id) { Hoa_Don hoa_Don = db.Hoa_Dons.Find(id); db.Hoa_Dons.Remove(hoa_Don); db.SaveChanges(); return(RedirectToAction("Index")); }
public static bool insert_bill(Hoa_Don hd) { if (QLLK_DAO.add_bill(hd)) { return(true); } else { return(false); } }
public ActionResult Edit([Bind(Include = "HoaDonID,TriGia,KhachID")] Hoa_Don hoa_Don) { if (ModelState.IsValid) { db.Entry(hoa_Don).State = EntityState.Modified; db.SaveChanges(); return(RedirectToAction("Index")); } ViewBag.KhachID = new SelectList(db.CT_Khach_Hangs, "KhachID", "TenKhach", hoa_Don.KhachID); return(View(hoa_Don)); }
public ActionResult Create([Bind(Include = "HoaDonID,TriGia,KhachID")] Hoa_Don hoa_Don) { if (ModelState.IsValid) { db.Hoa_Dons.Add(hoa_Don); db.SaveChanges(); return(RedirectToAction("Index")); } ViewBag.KhachID = new SelectList(db.CT_Khach_Hangs, "KhachID", "TenKhach", hoa_Don.KhachID); return(View(hoa_Don)); }
//tạo Hóa Đơn, CTHD, Phiếu giao public static bool add_bill(Hoa_Don hd) { string query = @"insert into HOA_DON values('" + hd.Id_hd + "','" + hd.Id_nv + "',convert(datetime,'" + hd.Ngaylap + "',103),'" + hd.Trangthai + "','" + hd.Tongtien + "','" + hd.Id_kh + "')"; SqlConnection conn = new SqlConnection(@"Data Source=LAPTOP-A27VSOCJ\SQLEXPRESS;Initial Catalog=QLLK;Integrated Security=True"); SqlCommand cmd = new SqlCommand(query, conn); conn.Open(); cmd.ExecuteNonQuery(); conn.Close(); return(false); }
// GET: Hoa_Don/Details/5 public ActionResult Details(int?id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } Hoa_Don hoa_Don = db.Hoa_Dons.Find(id); if (hoa_Don == null) { return(HttpNotFound()); } return(View(hoa_Don)); }
// GET: Hoa_Don/Edit/5 public ActionResult Edit(int?id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } Hoa_Don hoa_Don = db.Hoa_Dons.Find(id); if (hoa_Don == null) { return(HttpNotFound()); } ViewBag.KhachID = new SelectList(db.CT_Khach_Hangs, "KhachID", "TenKhach", hoa_Don.KhachID); return(View(hoa_Don)); }
public bool UpData(Hoa_Don hdObj) { cmd.CommandText = "update HOA_DON set TRANG_THAI = '" + hdObj.Trangthai + "' where ID_HD='" + hdObj.Id_hd + "'"; cmd.CommandType = CommandType.Text; cmd.Connection = conn.Connection; try { conn.OpenConn(); cmd.ExecuteNonQuery(); conn.CloseConn(); return(true); } catch (Exception ex) { String mex = ex.Message; cmd.Dispose(); conn.CloseConn(); } return(false); }
public IEnumerable <Hoa_Don> getHoaDon(TaiKhoan tk, int madh) { Hoa_Don hd = null; UserLogin user = (UserLogin)Session[Common.CommonConstrants.USER_SESSION]; if (user != null) { hd = new Models.Hoa_Don(); DonHang dh = new DonHang(); Sach book = new Sach(); dh = db.DonHangs.SingleOrDefault(x => x.ma == madh ? true : false); book = dh.Sach; tk = db.TaiKhoans.SingleOrDefault(x => x.ma == user.ID ? true : false); hd.tensach = book.ten; hd.tentk = tk.hoten; hd.ngaygiao = DateTime.Today.AddDays(2); hd.gia = book.gia; hd.diachi = tk.diachi; } yield return(hd); }
public bool UpdData(Hoa_Don hdObj) { return(hdMod.UpData(hdObj)); }