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