public ActionResult <String> AddNewProduct([FromForm] ProductWithCategoryIdsTE productData) { ProductTE product = _context.products.SingleOrDefault(x => x.ProductName.ToLower() == productData.ProductName.ToLower()); if (product == null) { string UploadFolder = Path.Combine(_hostEnvironemnt.WebRootPath, "Images"); string UniqueName = Guid.NewGuid().ToString() + "_" + productData.Imagefile.FileName; string FilePath = Path.Combine(UploadFolder, UniqueName); productData.Imagefile.CopyTo(new FileStream(FilePath, FileMode.Create)); ProductTE prod = new ProductTE() { ProductName = productData.ProductName, ImagePath = UniqueName, CategoryId = productData.CategoryId }; _context.Add(prod); _context.SaveChanges(); } else { string UploadFolder = Path.Combine(_hostEnvironemnt.WebRootPath, "Images"); string UniqueName = Guid.NewGuid().ToString() + "_" + productData.Imagefile; string FilePath = Path.Combine(UploadFolder, UniqueName); productData.Imagefile.CopyTo(new FileStream(FilePath, FileMode.Create)); product.ImagePath = UniqueName; _context.Entry(product).State = Microsoft.EntityFrameworkCore.EntityState.Modified; } return(Ok("Saved Successfully!")); }
public ActionResult <StockTE> GetStockPrice([FromForm] ProductWithCategoryIdsTE prod) { int ProdId = _context.products.Single(x => x.ProductName == prod.ProductName && x.CategoryId == prod.CategoryId).Id; StockTE stock = _context.stocks.SingleOrDefault(x => x.ProductId == ProdId && x.Size == prod.ProductSize); return(Ok(stock)); }
public ActionResult <String> SetStockPrice([FromForm] ProductWithCategoryIdsTE prod) { int ProdId = _context.products.Single(x => x.ProductName == prod.ProductName && x.CategoryId == prod.CategoryId).Id; StockTE stock = _context.stocks.SingleOrDefault(x => x.ProductId == ProdId && x.Size == prod.ProductSize); if (stock != null) { stock.Cost = prod.Cost; _context.Entry(stock).State = Microsoft.EntityFrameworkCore.EntityState.Modified; _context.SaveChanges(); } else { return(Ok("Product Not Found.. Please check!")); } return(Ok("Success Fully Done!")); }
public ActionResult <List <ProductTE> > GetProductById([FromForm] ProductWithCategoryIdsTE data) { List <ProductTE> products = _context.products.Where(x => x.CategoryId == data.Id).ToList <ProductTE>(); return(Ok(products)); }