public List <PhieuHdChiTiet> GetAll()
{
using (var db = new QLBH_WinDBContext())
{
return(db.PhieuHdChiTiets.ToList());
}
}
public SpLoai GetById(int id)
{
using (var db = new QLBH_WinDBContext())
{
return(db.SpLoais.Find(id));
}
}
public GioHang GetById(int id)
{
using (var db = new QLBH_WinDBContext())
{
return(db.GioHangs.Find(id));
}
}
public PhieuHdChiTiet GetById(int id)
{
using (var db = new QLBH_WinDBContext())
{
return(db.PhieuHdChiTiets.Find(id));
}
}
public List <GioHang> GetAll()
{
using (var db = new QLBH_WinDBContext())
{
return(db.GioHangs.ToList());
}
}
public List <SpNhom> GetAll()
{
using (var db = new QLBH_WinDBContext())
{
return(db.SpNhoms.ToList());
}
}
public List <SpLoai> GetAll()
{
using (var db = new QLBH_WinDBContext())
{
return(db.SpLoais.Include("Sps").ToList());
}
}
public Ncc GetById(int id)
{
using (var db = new QLBH_WinDBContext())
{
return(db.Nccs.Find(id));
}
}
public List <Kh> GetAll()
{
using (var db = new QLBH_WinDBContext())
{
return(db.Khs.ToList());
}
}
public void Delete(SpLoai obj)
{
using (var db = new QLBH_WinDBContext())
{
db.SpLoais.Attach(obj);
db.SpLoais.Remove(obj);
db.SaveChanges();
}
}
public Ncc Insert(Ncc obj)
{
using (var db = new QLBH_WinDBContext())
{
db.Nccs.Add(obj);
db.SaveChanges();
return(obj);
}
}
public GioHang Insert(GioHang obj)
{
using (var db = new QLBH_WinDBContext())
{
db.GioHangs.Add(obj);
db.SaveChanges();
return(obj);
}
}
public Kh Insert(Kh obj)
{
using (var db = new QLBH_WinDBContext())
{
db.Khs.Add(obj);
db.SaveChanges();
return(obj);
}
}
public void Delete(PhieuHdChiTiet obj)
{
using (var db = new QLBH_WinDBContext())
{
db.PhieuHdChiTiets.Attach(obj);
db.PhieuHdChiTiets.Remove(obj);
db.SaveChanges();
}
}
public PhieuHdChiTiet Insert(PhieuHdChiTiet obj)
{
using (var db = new QLBH_WinDBContext())
{
db.PhieuHdChiTiets.Add(obj);
db.SaveChanges();
return(obj);
}
}
public void Update(PhieuHdChiTiet obj)
{
using (var db = new QLBH_WinDBContext())
{
db.PhieuHdChiTiets.Attach(obj);
db.Entry(obj).State = EntityState.Modified;
db.SaveChanges();
}
}
public void Update(SpLoai obj)
{
using (var db = new QLBH_WinDBContext())
{
db.SpLoais.Attach(obj);
db.Entry(obj).State = EntityState.Modified;
db.SaveChanges();
}
}
public SpLoai Insert(SpLoai obj)
{
using (var db = new QLBH_WinDBContext())
{
db.SpLoais.Add(obj);
db.SaveChanges();
return(obj);
}
}
public bool Edit(int mancc, string tenncc)
{
var edit = new Ncc();
using (var db = new QLBH_WinDBContext())
{
edit = db.Nccs.Where(p => p.MaNcc.Equals(mancc)).SingleOrDefault();
edit.TenNcc = tenncc;
db.Nccs.Attach(edit);
db.Entry(edit).State = EntityState.Modified;
db.SaveChanges();
}
return(false);
}
public bool Them(string tenncc)
{
var them = new Ncc();
using (var db = new QLBH_WinDBContext())
{
try
{
them.TenNcc = tenncc;
db.Nccs.Add(them);
db.SaveChanges();
}
catch
{
return(true);
}
}
return(false);
}
public bool Delete(int mancc)
{
var del = new Ncc();
var data = new DataGridView();
using (var db = new QLBH_WinDBContext())
{
try
{
del = db.Nccs.Where(p => p.MaNcc.Equals(mancc)).SingleOrDefault();
db.Nccs.Attach(del);
db.Nccs.Remove(del);
db.SaveChanges();
}
catch
{
return(true);
}
}
return(false);
}
public static bool NhanVien_KiemTraDangNhap(Nv obj)
{
var db = new QLBH_WinDBContext();
return(db.Nvs.Any(m => m.MaNv == obj.MaNv && m.Mk == obj.Mk));
}
