// Cập nhật chi tiết đơn hàng
public bool UpdateCTDH(CT_PhieuDatHangNCCViewModel model)
{
CT_PHIEUDATNCC CTDHExit = context.CT_PHIEUDATNCCs.FirstOrDefault(t => t.TRANGTHAI != 0 && t.MACTPD == model.MaCTPhieuDat);
if (CTDHExit == null)
{
return(false);
}
CTDHExit.SOLUONG = model.SL;
CTDHExit.GIANHAP = model.GiaNhap;
CTDHExit.THANHTIEN = model.SL * CTDHExit.GIANHAP;
var datHang = context.PHIEUDATHANG_NCCs
.Include(t => t.CT_PHIEUDATNCCs)
.FirstOrDefault(t => t.MAPHIEUDAT == CTDHExit.MAPHIEUDAT && t.TRANGTHAI == 1);
if (datHang == null)
{
return(false);
}
//tinh tong tien
var newTongTien = datHang.CT_PHIEUDATNCCs.Where(t => t.TRANGTHAI != 0).
Sum(t => t.SOLUONG * t.GIANHAP);
//update tong tien
datHang.TONGTIEN = newTongTien;
//save
context.SaveChanges();
return(true);
}
public bool Update(CT_PhieuDatHangNCCViewModel model)
{
CT_PHIEUDATNCC pdh = context.CT_PHIEUDATNCCs.FirstOrDefault(t => t.MAPHIEUDAT == model.MaPhieuDat);
if (pdh == null)
{
return(false);
}
pdh.MASANPHAM = model.MaSP;
pdh.SOLUONG = model.SL;
pdh.GIANHAP = model.GiaNhap;
pdh.THANHTIEN = model.ThanhTien;
context.SaveChanges();
return(true);
}
public ActionResult Edit(int id, CT_PhieuDatHangNCCViewModel collection)
{
try
{
// TODO: Add update logic here
var result = ct.Update(collection);
if (!result)
{
return(HttpNotFound());
}
return(RedirectToAction("Index"));
}
catch
{
return(View());
}
}
public bool Add(CT_PhieuDatHangNCCViewModel model)
{
try
{
var dathang = new CT_PHIEUDATNCC
{
MAPHIEUDAT = model.MaPhieuDat,
MASANPHAM = model.MaSP,
SOLUONG = model.SL,
GIANHAP = model.GiaNhap,
THANHTIEN = model.ThanhTien,
};
context.CT_PHIEUDATNCCs.Add(dathang);
context.SaveChanges();
return(true);
}
catch (Exception)
{
return(false);
}
}
public ActionResult UpdateCtDatHang(int id, CT_PhieuDatHangNCCViewModel model)
{
try
{
if (ModelState.IsValid && model.GiaNhap > 0 && model.SL > 0)
{
// TODO: Add update logic here
model.MaCTPhieuDat = id;
var result = PDHService.UpdateCTDH(model);
if (result == false)
{
return(HttpNotFound());
}
return(Json("success"));
}
return(View(model));
}
catch
{
return(View());
}
}
