public ActionResult Put([FromBody] Models.Request.ProductPutRequest request)
{
using (Models.PRODUCTOSContext db = new Models.PRODUCTOSContext())
{
Models.Product Product = db.Products.Find(request.id);
Product.ProdCondition = request.condition;
Product.ProdStatus = request.status;
db.Entry(Product).State = Microsoft.EntityFrameworkCore.EntityState.Modified;
db.SaveChanges();
}
return(Ok());
}
public async Task <ActionResult <Models.Product> > GetProduct(int id)
{
using (Models.PRODUCTOSContext db = new Models.PRODUCTOSContext())
{
Models.Product Product = db.Products.Find(id);
if (Product == null)
{
return(NotFound());
}
return(Product);
}
}
public ActionResult Post([FromBody] Models.Request.ProductPostRequest request)
{
using (Models.PRODUCTOSContext db = new Models.PRODUCTOSContext())
{
Models.Product Product = new Models.Product();
Product.ProdName = request.name;
Product.ProdCondition = request.condition;
Product.ProdStatus = 0;
db.Add(Product);
db.SaveChanges();
}
return(Ok());
}
public ActionResult Get()
{
using (Models.PRODUCTOSContext db = new Models.PRODUCTOSContext())
{
var lst = (from p in db.Products join s in db.ProductConditions on p.ProdCondition equals s.CondId where p.ProdStatus == 0
select new Models.Request.ProductGetRequest
{
ProdId = p.ProdId,
ProdName = p.ProdName,
ProdCondition = s.CondName,
ProdStatus = p.ProdStatus
}).ToList();
return(Ok(lst));
}
}
