public int InsertChiTietHoaDonBanSi(eChiTietHoaDonBanSi Ct)
{
var SanPham = from i in db.SanPhams
where i.MaSP == Ct.MaSP
select i;
if (SanPham.Any())
{
var ChiTiet = from i in db.ChiTietHoaDonBanSis
where i.MaHoaDonBanSi == Ct.MaHoaDonoBanSi && i.MaSP == Ct.MaSP
select i;
if (ChiTiet.Any())
{
return(0);
}
else
{
ChiTietHoaDonBanSi ChitietHDBS = new ChiTietHoaDonBanSi();
ChitietHDBS.MaHoaDonBanSi = Ct.MaHoaDonoBanSi;
ChitietHDBS.MaSP = Ct.MaSP;
ChitietHDBS.SoLuong = Ct.soluong;
ChitietHDBS.GhiChu = Ct.GhiChu;
ChitietHDBS.GiaBanSi = Ct.GiaBanSi;
decimal Money = Ct.soluong * Ct.GiaBanSi;
UpdateTongTienHoaDonBanSiI(Ct.MaHoaDonoBanSi, Money);
db.ChiTietHoaDonBanSis.InsertOnSubmit(ChitietHDBS);
db.SubmitChanges();
return(1);
}
}
else
{
return(2);
}
}
public void DeleteChiTietHoaDonBanSi(string MaHoaDonBanSi, string MaSp, string MaChiTietHoaDonBanSi)
{
ChiTietHoaDonBanSi Chitiet = db.ChiTietHoaDonBanSis.Where(x => x.MaHoaDonBanSi == MaHoaDonBanSi && x.MaSP == MaSp).FirstOrDefault();
decimal Money = Convert.ToDecimal(Chitiet.GiaBanSi * Chitiet.SoLuong);
db.ChiTietHoaDonBanSis.DeleteOnSubmit(Chitiet);
db.SubmitChanges();
UpdateTongTienHoaDonBanSiD(MaHoaDonBanSi, Money);
}
