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