public void Delete(string id) { using (QLNTEntities1 db = new QLNTEntities1()) { int ma = Convert.ToInt32(id); Cay temp = db.Cay.Where(p => p.MaLoaiCay == ma).SingleOrDefault(); db.Cay.Remove(temp); db.SaveChanges(); } }
public void Edit(Cay o) { using (QLNTEntities1 db = new QLNTEntities1()) { int ma = o.MaLoaiCay; Cay temp = db.Cay.Find(ma); temp.TenCay = o.TenCay; temp.SoLuong = o.SoLuong; temp.MuaThuHoach = o.MuaThuHoach; temp.NamTrongCay = o.NamTrongCay; db.SaveChanges(); } }
public void Add(Cay 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.Cay.Add(o); db.SaveChanges(); } }