public async Task <bool> SaveProduct(ProductModel productModel) { using (MarvelDCStoreDBContext db = new MarvelDCStoreDBContext()) { Product product = db.Product.Where(x => x.ProductID == productModel.ProductID).FirstOrDefault(); if (product == null) { product = new Product() { ProductName = productModel.ProductName, ItemQuantity = productModel.ItemQuantity, UnitPrice = productModel.UnitPrice }; db.Product.Add(product); } else { product.ProductName = productModel.ProductName; product.ItemQuantity = productModel.ItemQuantity; product.UnitPrice = productModel.UnitPrice; } return(await db.SaveChangesAsync() >= 1); } }
public async Task <bool> DeleteProduct(int productId) { using (MarvelDCStoreDBContext db = new MarvelDCStoreDBContext()) { Product product = db.Product.Where(x => x.ProductID == productId).FirstOrDefault(); if (product != null) { db.Product.Remove(product); } return(await db.SaveChangesAsync() >= 1); } }
public async Task <List <ProductModel> > GetProducts() { using (MarvelDCStoreDBContext db = new MarvelDCStoreDBContext()) { return(await(from a in db.Product.AsNoTracking() select new ProductModel { ProductID = a.ProductID, ProductName = a.ProductName, ItemQuantity = a.ItemQuantity, UnitPrice = a.UnitPrice }).ToListAsync()); } }
public async Task <ProductModel> GetProductData(int productId) { using (MarvelDCStoreDBContext db = new MarvelDCStoreDBContext()) { return(await(from a in db.Product.AsNoTracking() where a.ProductID.Equals(productId) select new ProductModel { ProductID = a.ProductID, ProductName = a.ProductName, ItemQuantity = a.ItemQuantity, UnitPrice = a.UnitPrice }).FirstOrDefaultAsync()); } }