public IEnumerable <Product> GetAll() { using (OkanDbEntities db = new OkanDbEntities()) { return(db.Products.ToList()); } }
public Product Get(int id) { using (OkanDbEntities db = new OkanDbEntities()) { return(db.Products.FirstOrDefault(p => p.ProductId == id)); } }
public void Remove(Product entity) { using (OkanDbEntities db = new OkanDbEntities()) { db.Products.Attach(entity); db.Entry(entity).State = System.Data.Entity.EntityState.Deleted; db.SaveChanges(); } }
public void Save(Product entity) { using (OkanDbEntities db = new OkanDbEntities()) { var prod = Get(entity.ProductId); if (prod == null) { db.Products.Attach(entity); db.Entry(entity).State = System.Data.Entity.EntityState.Added; db.SaveChanges(); } else { db.Products.Attach(entity); db.Entry(entity).State = System.Data.Entity.EntityState.Modified; db.SaveChanges(); } } }