public void UpdateProductStore(Productstore productstore) { var prodst = (from ps in _context.Productstore where ps.Id_product == productstore.Id_product && ps.Id_store == productstore.Id_store select ps).SingleOrDefault(); prodst.Availability = productstore.Availability; prodst.Price = productstore.Price; _context.SaveChanges(); }
public IActionResult UpdateProduct([FromBody] ProductStoreModel model) { Productstore productStore = new Productstore(); productStore.Id_product = model.Id_product; productStore.Id_store = model.Id_store; productStore.Price = model.Price; productStore.Availability = model.Availability; try { _storeService.UpdateProductStore(productStore); } catch (AppException ex) { return(BadRequest(new { message = ex.Message })); } return(Ok()); }
public IActionResult FilterProductsByStoreId(int store_id) { var products = _productService.GetProductsByStoreId(store_id); List <ProductPriceAvailModel> result = new List <ProductPriceAvailModel>(); var iter = products.GetEnumerator(); iter.Reset(); iter.MoveNext(); while (iter.Current != null) { Products prod = iter.Current; ProductPriceAvailModel temp = new ProductPriceAvailModel(); temp.Id = prod.Id; temp.Name = prod.Name; temp.Description = prod.Description; temp.Producer = prod.Producer; temp.Weight = prod.Weight; temp.Category = prod.Category; Productstore ps = _productService.GetProductPriceAvail(prod.Id, store_id); temp.Price = ps.Price; temp.Availability = ps.Availability; result.Add(temp); iter.MoveNext(); } return(Ok(result)); }
public IActionResult CreateProduct([FromBody] CreateProductModel model) { Products product = new Products(); product.Name = model.Name; product.Producer = model.Producer; product.Weight = model.Weight; product.Category = model.Category; product.Description = model.Description; product.Bulk_Product = model.Bulk_product; try { var createdProduct = _productService.CreateProduct(product); Productstore productstore = new Productstore(); productstore.Id_product = createdProduct.Id; productstore.Id_store = model.Id_store; productstore.Price = model.Price; productstore.Availability = model.Availability; _storeService.CreateProductStore(productstore); } catch (AppException ex) { return(BadRequest(new { message = ex.Message })); } return(Ok()); }
public void CreateProductStore(Productstore productstore) { _context.Add(productstore); _context.SaveChanges(); }