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));
}
