public category GetById(int id) { using (var db = new MVCDemoEntities()) { return(db.categories.Where(s => s.id == id).FirstOrDefault()); } }
public product GetById(int id) { using (var db = new MVCDemoEntities()) { return(db.products.Where(s => s.id == id).FirstOrDefault()); } }
public List <category> GetAll() { using (var db = new MVCDemoEntities()) { return(db.categories.ToList()); } }
public List <product> GetAll() { using (var db = new MVCDemoEntities()) { return(db.products.OrderByDescending(s => s.id).ToList()); } }
public void Update(product product) { using (var db = new MVCDemoEntities()) { db.Entry(product).State = EntityState.Modified; db.SaveChanges(); } }
private List <vDeptEmp> GetDepEmp() { List <vDeptEmp> deptEmps = new List <vDeptEmp>(); using (MVCDemoEntities db = new MVCDemoEntities()) { deptEmps = db.vDeptEmp.ToList(); } return(deptEmps); }
public void Add(product product) { product.created_date = DateTime.Now; product.created_by = "web"; using (var db = new MVCDemoEntities()) { db.products.Add(product); db.SaveChanges(); } }
public void Delete(int id) { using (var db = new MVCDemoEntities()) { var product = db.products.Where(s => s.id == id).FirstOrDefault(); if (product != null) { db.products.Remove(product); db.SaveChanges(); } } //using (var db = new MVCDemoEntities()) //{ // db.USP_PRODUCTS_DELETE(id); //} }