public ActionResult Create([Bind(Include = "CTBH_ID,CTSP_ID,BH_ID,TTBH_ID,CTBH_NGAYBH,CTBH_NGAYTRA,CTBH_GHICHU")] CHITIETBH cHITIETBH)
{
string CTSP_ID = Request["CTSP_ID"];
DateTime CTBH_NGAYBH = Convert.ToDateTime(Request["CTBH_NGAYBH"]);
DateTime CTBH_NGAYTRA = Convert.ToDateTime(Request["CTBH_NGAYTRA"]);
string result = db.Database.SqlQuery <string>("select CTSP_ID from ChiTietSanPham where CTSP_ID ='" + CTSP_ID + "' and CTSP_TRANGTHAI = 0").FirstOrDefault();
string resultKH = db.Database.SqlQuery <string>("select KH_ID from DonHang dn inner join ChiTietDonHang ctdh on dn.DN_ID = ctdh.DN_ID where ctdh.CTSP_ID ='" + CTSP_ID + "'").FirstOrDefault();
if (result == null)
{
ModelState.AddModelError("", "Sản phẩm " + CTSP_ID + " chưa được bán hoặc không tồn tại.");
}
else if (CTBH_NGAYBH >= CTBH_NGAYTRA)
{
ModelState.AddModelError("", "Ngày bảo hành phải trước ngày trả");
}
else
{
cHITIETBH.NV_ID = Session["NV_ID"].ToString();
cHITIETBH.KH_ID = resultKH;
cHITIETBH.CTBH_ID = db.autottang("ChiTietBH", "CTBH_ID", db.CHITIETBHs.Count()).ToString();
db.CHITIETBHs.Add(cHITIETBH);
db.SaveChanges();
ModelState.AddModelError("", "Đã thêm " + result);
}
ViewBag.BH_ID = new SelectList(db.BAOHANHs, "BH_ID", "BH_TEN", cHITIETBH.BH_ID);
ViewBag.CTSP_ID = new SelectList(db.CHITIETSANPHAMs, "CTSP_ID", "CTSP_TEN", cHITIETBH.CTSP_ID);
ViewBag.TTBH_ID = new SelectList(db.TRANGTHAIBHs, "TTBH_ID", "TTBH_TEN", cHITIETBH.TTBH_ID);
return(View(cHITIETBH));
}
public ActionResult DeleteConfirmed(string id)
{
CHITIETBH cHITIETBH = db.CHITIETBHs.Find(id);
db.CHITIETBHs.Remove(cHITIETBH);
db.SaveChanges();
return(RedirectToAction("Index"));
}
public ActionResult Edit([Bind(Include = "CTBH_ID,CTSP_ID,BH_ID,TTBH_ID,CTBH_NGAYBH,CTBH_NGAYTRA,CTBH_GHICHU")] CHITIETBH cHITIETBH)
{
if (ModelState.IsValid)
{
db.Entry(cHITIETBH).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.BH_ID = new SelectList(db.BAOHANHs, "BH_ID", "BH_TEN", cHITIETBH.BH_ID);
ViewBag.CTSP_ID = new SelectList(db.CHITIETSANPHAMs, "CTSP_ID", "CTSP_TEN", cHITIETBH.CTSP_ID);
ViewBag.TTBH_ID = new SelectList(db.TRANGTHAIBHs, "TTBH_ID", "TTBH_TEN", cHITIETBH.TTBH_ID);
return(View(cHITIETBH));
}
// GET: CHITIETBHs/Details/5
public ActionResult Details(string id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
CHITIETBH cHITIETBH = db.CHITIETBHs.Find(id);
if (cHITIETBH == null)
{
return(HttpNotFound());
}
return(View(cHITIETBH));
}
// GET: CHITIETBHs/Edit/5
public ActionResult Edit(string id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
CHITIETBH cHITIETBH = db.CHITIETBHs.Find(id);
if (cHITIETBH == null)
{
return(HttpNotFound());
}
ViewBag.BH_ID = new SelectList(db.BAOHANHs, "BH_ID", "BH_TEN", cHITIETBH.BH_ID);
ViewBag.CTSP_ID = new SelectList(db.CHITIETSANPHAMs, "CTSP_ID", "CTSP_TEN", cHITIETBH.CTSP_ID);
ViewBag.TTBH_ID = new SelectList(db.TRANGTHAIBHs, "TTBH_ID", "TTBH_TEN", cHITIETBH.TTBH_ID);
return(View(cHITIETBH));
}
