public void setHuySL(int id) { using (QLNTEntities1 db = new QLNTEntities1()) { PhanBon p = db.PhanBon.Where(c => c.MaPB == id).SingleOrDefault(); p.SoLuong = 0; db.SaveChanges(); } }
public void Delete(string id) { using (QLNTEntities1 db = new QLNTEntities1()) { int ma = Convert.ToInt32(id); PhanBon temp = db.PhanBons.Where(p => p.MaPB == ma).SingleOrDefault(); db.PhanBons.Remove(temp); db.SaveChanges(); } }
public void Add(PhanBon 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.PhanBons.Add(o); db.SaveChanges(); } }
public void Edit(PhanBon o) { using (QLNTEntities1 db = new QLNTEntities1()) { int ma = o.MaPB; PhanBon temp = db.PhanBons.Find(ma); temp.TenPB = o.TenPB; temp.Loai = o.Loai; temp.SoLuong = o.SoLuong; temp.KhoiLuong = o.KhoiLuong; temp.NgaySX = o.NgaySX; temp.HanSD = o.HanSD; temp.DonGia = o.DonGia; db.SaveChanges(); } }