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