public void setHuySL(int id)
{
using (QLNTEntities1 db = new QLNTEntities1())
{
ThuocBaoVeTV p = db.ThuocBaoVeTV.Where(c => c.MaThuoc == id).SingleOrDefault();
p.SoLuong = 0;
db.SaveChanges();
}
}
public void Delete(string id)
{
using (QLNTEntities1 db = new QLNTEntities1())
{
int ma = Convert.ToInt32(id);
ThuocBaoVeTV temp = db.ThuocBaoVeTV.Where(p => p.MaThuoc == ma).SingleOrDefault();
db.ThuocBaoVeTV.Remove(temp);
db.SaveChanges();
}
}
public void Add(ThuocBaoVeTV o)
{
/*using (QLNTEntities1 db = new QLNTEntities1())
* {
*
* db.PhanBons.Add(new PhanBon() { TenPB ="Nis", Loai="Vô cơ", NgaySX= new DateTime(2019,7,1),HanSD = new DateTime(2020, 7, 1),SoLuong=12,DonGia=100000,KhoiLuong=500 });
* db.SaveChanges();
* }*/
using (QLNTEntities1 db = new QLNTEntities1())
{
db.ThuocBaoVeTV.Add(o);
db.SaveChanges();
}
}
public void Edit(ThuocBaoVeTV o)
{
using (QLNTEntities1 db = new QLNTEntities1())
{
int ma = o.MaThuoc;
ThuocBaoVeTV temp = db.ThuocBaoVeTV.Find(ma);
temp.TenThuoc = o.TenThuoc;
temp.ThoiGianCachLy = o.ThoiGianCachLy;
temp.NoiSX = o.NoiSX;
temp.Dang = o.Dang;
temp.SoLuong = o.SoLuong;
temp.CongDung = o.CongDung;
temp.NgaySX = o.NgaySX;
temp.HanSD = o.HanSD;
temp.MaDoc = o.MaDoc;
db.SaveChanges();
}
}
