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(); } }