public IActionResult Get(string name)
{
_logger.Information($"Get product by name {name}.");
using var ctx = new Models.awvmsqldbContext();
var product = ctx.Products.SingleOrDefault(p => p.Name == name);
if (product == null)
{
_logger.Information($"Product with name {name} not found.");
return(NotFound());
}
var mapped = new
{
productId = product.ProductId,
name = product.Name,
productNumber = product.ProductNumber,
sellEndDate = product.SellEndDate,
sellStartDate = product.SellStartDate,
listPrice = product.ListPrice,
weight = product.Weight,
size = product.Size
};
return(Ok(mapped));
}
public void Put(int id, ProductDto product)
{
_logger.Information($"Update product by id {id}.");
using var ctx = new Models.awvmsqldbContext();
var saved = ctx.Products.SingleOrDefault(p => p.ProductId == id);
saved.Name = product.Name;
saved.Size = product.Size;
ctx.SaveChanges();
}
public IActionResult Delete(int id)
{
_logger.Information($"Delete product by id {id}.");
using var ctx = new Models.awvmsqldbContext();
var product = ctx.Products.SingleOrDefault(p => p.ProductId == id);
if (product == null)
{
_logger.Information($"{id} not found.");
return(NotFound());
}
ctx.Products.Remove(product);
ctx.SaveChanges();
return(Ok());
}
public IActionResult Get()
{
_logger.Information("Get all products");
using (var ctx = new Models.awvmsqldbContext())
{
var products = ctx.Products.Select(p => new
{
productId = p.ProductId,
name = p.Name,
productNumber = p.ProductNumber,
sellEndDate = p.SellEndDate,
sellStartDate = p.SellStartDate,
listPrice = p.ListPrice,
weight = p.Weight,
size = p.Size
}).ToArray();
return(Ok(products));
}
}
