public void Update(PhieuHdChiTiet obj)
{
using (var db = new QLBH_WinDBContext())
{
db.PhieuHdChiTiets.Attach(obj);
db.Entry(obj).State = EntityState.Modified;
db.SaveChanges();
}
}
public void Delete(PhieuHdChiTiet obj)
{
using (var db = new QLBH_WinDBContext())
{
db.PhieuHdChiTiets.Attach(obj);
db.PhieuHdChiTiets.Remove(obj);
db.SaveChanges();
}
}
public PhieuHdChiTiet Insert(PhieuHdChiTiet obj)
{
using (var db = new QLBH_WinDBContext())
{
db.PhieuHdChiTiets.Add(obj);
db.SaveChanges();
return(obj);
}
}
public static string LapHoaDon(string data, int phanTram, string tienGiam)
{
JavaScriptSerializer json = new JavaScriptSerializer();
List <string[]> mystring = json.Deserialize <List <string[]> >(data);
PhieuHd phd = new PhieuHd()
{
NgayLap = DateTime.Now,
PhanTramGiam = phanTram,
TienGiam = tienGiam
};
PhieuHd_BUS.Insert(phd);
int maPhieuHd = PhieuHd_BUS.GetAll().ToList().Last().MaPhieuHd;
for (int i = 0; i < mystring.Count; i++)
{
int maSp = int.Parse(mystring[i][0]);
int sL = int.Parse(mystring[i][1]);
PhieuHdChiTiet phd_ct = new PhieuHdChiTiet();
phd_ct.MaPhieuHd = maPhieuHd;
phd_ct.MaSp = maSp;
phd_ct.SoLuong = sL;
phd_ct.ThanhTien = maSp * sL;
Sp sp = Sp_BUS.GetById(maSp);
sp.SoLuongTonKho -= sL;
if (sp.SoLuongTonKho < 0)
{
sp.SoLuongTonKho = 0;
}
Sp_BUS.Update(sp);
PhieuHdChiTiet_BUS.Insert(phd_ct);
}
return("");
}
static PhieuHdChiTiet_DAO()
{
Kh = new PhieuHdChiTiet();
}
public static void Update(PhieuHdChiTiet obj)
{
_instance.Update(obj);
}
public static PhieuHdChiTiet Insert(PhieuHdChiTiet obj)
{
return(_instance.Insert(obj));
}
