public Entities.Products AddProduct(Entities.Products product) { using (var context = new Models.SalesDBContext(Options)) { context.Products.Add(product); context.SaveChanges(); } return(product); }
public Entities.Products GetProductByID(int ID) { Entities.Products product = null; using (var context = new Models.SalesDBContext(Options)) { product = context.Products.FirstOrDefault(x => x.Id == ID); } return(product); }
public List <Entities.Products> GetProducts() { List <Entities.Products> productsList = null; using (var context = new Models.SalesDBContext(Options)) { productsList = context.Products.OrderBy(x => x.ProductName).ToList(); } return(productsList); }
public Entities.Products RemoveProduct(int ID) { Entities.Products product; using (var context = new Models.SalesDBContext(Options)) { product = context.Products.FirstOrDefault(p => p.Id == ID); context.Products.Remove(product); context.SaveChanges(); } return(product); }