public bool addSach(Phieunhap phieunhap,CTPN[] ctpn)
{
try
{//phieunhap.NgayNhap = DateTime.Today;
NoNXB no = new NoNXB();
Kho kho = new Kho();
//tao dl ao
no.NgayNhap = phieunhap.NgayNhap;
no.IdNXB = phieunhap.IdNXB;
kho.NgayGhi = phieunhap.NgayNhap;
foreach (var i in ctpn) //code ctpn in here
{
Sach sach = db.Saches.Find(i.IdSach);
kho.IdSach = sach.IdSach;
kho.SL = i.SoLuong;
no.TienNo = i.SoLuong * sach.GiaNhap;
UpdateNo(no);
UpdateKho(kho);
phieunhap.CTPNs.Add(i);
db.SaveChanges();
}
db.Phieunhaps.Add(phieunhap);
db.SaveChanges();
return true;
}
catch (Exception ex)
{
return false;
}
}
private void UpdateNo(NoNXB no)
{
if (db.NoNXBs.Any(o => o.IdNXB == no.IdNXB))
{
NoNXB olditem = db.NoNXBs.Where(c => c.IdNXB == no.IdNXB).FirstOrDefault();
olditem.TienNo = olditem.TienNo + no.TienNo;
db.Entry(olditem).State = System.Data.Entity.EntityState.Modified;
}
else
{
db.NoNXBs.Add(no);
}
}
