public bool Delete(int idhaodon, int idhang)
{
decimal thanhtiencu = 0;
try
{
using (var db = new QLPhongKaraokeEntities())
{
var x = from s in db.CT_HOADONDV
where s.ID_HoaDonDV == idhaodon && s.ID_Hang == idhang && s.Deleted == 0
select s;
var sv = x.FirstOrDefault();
var hang = (from s in db.HANGs where s.ID == idhang select s).FirstOrDefault();
if (sv != null)
{
thanhtiencu = sv.ThanhTien;
sv.Deleted = 1;
db.SaveChanges();
// cap nhat so luong ton
hang.SLTon += sv.SoLuong;
db.SaveChanges();
//cap nhat tong tien hoa don
var hd = new MMHOADONDV();
hd.UpdateTongTien(sv.ID_HoaDonDV, hd.GetOne(sv.ID_HoaDonDV).TongTien - thanhtiencu);
}
}
return(true);
}
catch (Exception)
{
return(false);
}
}
public bool Update(CT_HOADONDV item)
{
decimal thanhtiencu = 0;
try
{
using (var db = new QLPhongKaraokeEntities())
{
var x = from s in db.CT_HOADONDV
where s.ID_HoaDonDV == item.ID_HoaDonDV && s.ID_Hang == item.ID_Hang && s.Deleted == 0
select s;
var sv = x.FirstOrDefault();
var hang = (from s in db.HANGs where s.ID == sv.ID_Hang select s).FirstOrDefault();
if (sv != null)
{
thanhtiencu = sv.ThanhTien;
var soluongcu = sv.SoLuong;
sv.SoLuong = item.SoLuong;
sv.DonGia = item.DonGia;
sv.ThanhTien = item.ThanhTien;
db.SaveChanges();
//cap nhat soluong
hang.SLTon = hang.SLTon + soluongcu - sv.SoLuong;
db.SaveChanges();
var hd = new MMHOADONDV(); //khi cap nhat thi cap nhat lai tong tien
var tongtien = hd.GetOne(sv.ID_HoaDonDV).TongTien - thanhtiencu + item.ThanhTien;
hd.UpdateTongTien(sv.ID_HoaDonDV, tongtien);
}
}
return(true);
}
catch (Exception)
{
return(false);
}
}
public bool Insert(CT_HOADONDV item)
{
try
{
using (var db = new QLPhongKaraokeEntities())
{
var x = from s in db.CT_HOADONDV
where s.ID_HoaDonDV == item.ID_HoaDonDV && s.ID_Hang == item.ID_Hang
select s;
var sv = x.FirstOrDefault();
var hang = (from s in db.HANGs where s.ID == item.ID_Hang select s).FirstOrDefault();
if (sv != null) //da co thi cap nhat sl chu khong co them
{
sv.SoLuong += item.SoLuong;
sv.ThanhTien += item.ThanhTien;
db.SaveChanges();
}
else
{
db.CT_HOADONDV.Add(item);
db.SaveChanges();
}
//cap nhat so luong ton
hang.SLTon -= item.SoLuong;
db.SaveChanges();
//cap nhat tong tien hoadon
var hd = new MMHOADONDV();
hd.UpdateTongTien(item.ID_HoaDonDV, hd.GetOne(item.ID_HoaDonDV).TongTien + item.ThanhTien);
}
return(true);
}
catch (Exception)
{
return(false);
}
}