public bool InsertChiTietHoaDonNhaCungCap(string mahd, string masp, int soluong, decimal giamua, string ghichu, string tensp) { var c = from i in db.ChiTietHoaDonNhaCungCaps where i.MaHoaDonNhaCungCap == mahd && i.MaSPNCC == masp select i; if (c.Any()) { throw new Exception("There Already Have"); } else { ChiTietHoaDonNhaCungCap ct = new ChiTietHoaDonNhaCungCap(); ct.MaHoaDonNhaCungCap = mahd; ct.SoLuong = soluong; ct.MaSPNCC = masp; ct.TenSPNCC = tensp; ct.GiaMuaBenNhaCungCap = giamua; ct.GhiChu = ghichu; decimal money = Convert.ToDecimal(soluong * giamua); UpdateTongTienHoaDonNhaCungCapI(mahd, money); db.ChiTietHoaDonNhaCungCaps.InsertOnSubmit(ct); db.SubmitChanges(); InsertSanPhamNhaCungCap(masp); decimal n = giamua * (decimal)1.05; InsertOfUpdateBangGiaSi(masp, giamua.ToString()); return(true); } }
private void DeleteChiTietHoaDonNhaCungCap(string MaHoaDonNhaCungCap, string MaSp) { ChiTietHoaDonNhaCungCap Chitiet = db.ChiTietHoaDonNhaCungCaps.Where(x => x.MaHoaDonNhaCungCap == MaHoaDonNhaCungCap && x.MaSPNCC == MaSp).FirstOrDefault(); decimal Money = Convert.ToDecimal(Chitiet.GiaMuaBenNhaCungCap * Chitiet.SoLuong); db.ChiTietHoaDonNhaCungCaps.DeleteOnSubmit(Chitiet); db.SubmitChanges(); UpdateTongTienHoaDonNhaCungCapD(MaHoaDonNhaCungCap, Money); }
public int GetSoLuongbyOneSanPham(string mahd, string masp) { ChiTietHoaDonNhaCungCap chitiet = db.ChiTietHoaDonNhaCungCaps.Where(x => x.MaSPNCC == masp && x.MaHoaDonNhaCungCap == mahd).FirstOrDefault(); if (chitiet != null) { return(chitiet.SoLuong); } else { throw new Exception("Invalid ID or Null ID"); } }
public bool DeleteChiTietHDNCC(string mahd, string masp) { ChiTietHoaDonNhaCungCap ct = db.ChiTietHoaDonNhaCungCaps.Where(x => x.MaSPNCC == masp && x.MaHoaDonNhaCungCap == mahd).FirstOrDefault(); if (ct != null) { decimal money = ct.SoLuong * ct.GiaMuaBenNhaCungCap; UpdateTongTienHoaDonNhaCungCapD(mahd, money); db.ChiTietHoaDonNhaCungCaps.DeleteOnSubmit(ct); db.SubmitChanges(); return(true); } else { throw new Exception("Invalid ID of Null ID"); } }