public async Task <ActionResult> Restock(int productid, int qty, string addedby)
{
var user = await _context.Users.SingleOrDefaultAsync(u => u.Email == addedby);
if (user == null)
{
return(BadRequest("Unknown user"));
}
if (user.Status.ToLower() != "active")
{
return(BadRequest("User account is not active"));
}
var target = await _context.Product.SingleOrDefaultAsync(obj => obj.Productid == productid);
if (target == null)
{
return(BadRequest("Invalid product"));
}
var sh = new Stockhistory()
{
Addedby = addedby,
Dateadded = DateTime.Now,
Productid = productid,
Qtyadded = qty,
Qtyavailable = target.Qtyavailable
};
target.Qtyavailable += qty;
_context.Stockhistory.Add(sh);
await _context.SaveChangesAsync();
return(Ok());
}
public async Task <ActionResult> Put(int logid, [FromBody] Stockhistory obj)
{
var target = await _context.Stockhistory.SingleOrDefaultAsync(nobj => nobj.Logid == logid);
if (target != null && ModelState.IsValid)
{
_context.Entry(target).CurrentValues.SetValues(obj);
await _context.SaveChangesAsync();
return(Ok());
}
return(BadRequest());
}
public async Task <ActionResult <Stockhistory> > Post([FromBody] Stockhistory obj)
{
if (!ModelState.IsValid)
{
return(BadRequest());
}
else
{
_context.Stockhistory.Add(obj);
await _context.SaveChangesAsync();
return(Created("api/Stockhistory", obj));
}
}
