// 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); }
//Xóa chi tiết đơn đặt hàng public bool DeleteDetail(int maCTDH) { CT_PHIEUDATNCC CTDHExit = context.CT_PHIEUDATNCCs.FirstOrDefault(t => t.TRANGTHAI != 0 && t.MACTPD == maCTDH); if (CTDHExit == null) { return(false); } CTDHExit.TRANGTHAI = 0; // update tong tien //lay dat hang var datHang = context.PHIEUDATHANG_NCCs .Include(t => t.CT_PHIEUDATNCCs) .FirstOrDefault(t => t.MAPHIEUDAT == CTDHExit.MAPHIEUDAT && t.TRANGTHAI != 0); if (datHang == null) { return(false); } ////////tinh tong tien var newTongTien = datHang.CT_PHIEUDATNCCs.Where(t => t.TRANGTHAI == 1). Sum(t => t.SOLUONG * t.GIANHAP); //update tong tien datHang.TONGTIEN = newTongTien; //save context.SaveChanges(); return(true); }
public bool AddPhieuDatHangNCC(PhieuDatHang_NCCViewModel model) { var tongTien = model.ChiTietPhieuDats.Sum(t => t.SL * t.GiaNhap); var phieuDat = new PHIEUDATHANG_NCC() { MANCC = model.MaNCC, NGAYDAT = DateTime.Now, NGUOIDAT = HttpContext.Current.User.Identity.Name, TONGTIEN = tongTien, TRANGTHAI = 1, }; context.PHIEUDATHANG_NCCs.Add(phieuDat); context.SaveChanges(); foreach (var detail in model.ChiTietPhieuDats) { var chiTiet = new CT_PHIEUDATNCC() { MAPHIEUDAT = phieuDat.MAPHIEUDAT, MASANPHAM = detail.MaSP, SOLUONG = detail.SL, GIANHAP = detail.GiaNhap, THANHTIEN = detail.SL * detail.GiaNhap, TRANGTHAI = 1, }; context.CT_PHIEUDATNCCs.Add(chiTiet); } 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 bool AddCTPhieuDatHangNCC(int id, PhieuDatHang_NCCViewModel model) { var tongTien = model.ChiTietPhieuDats.Sum(t => t.SL * t.GiaNhap); foreach (var detail in model.ChiTietPhieuDats) { var chiTiet = new CT_PHIEUDATNCC() { MAPHIEUDAT = id, MASANPHAM = detail.MaSP, SOLUONG = detail.SL, GIANHAP = detail.GiaNhap, THANHTIEN = detail.SL * detail.GiaNhap, TRANGTHAI = 1, }; context.CT_PHIEUDATNCCs.Add(chiTiet); } context.SaveChanges(); return(true); }
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); } }