public async Task <IActionResult> PutOrder9144(int id, Order9144 o)
{
if (id != o.Orderid)
{
return(BadRequest());
}
_context.Entry(o).State = EntityState.Modified;
try
{
_context.Order9144.FromSqlRaw("EXEC FULLFILL_ORDER " +
"@PORDERID = " + id +
", @PACCOUNTID = " + o.Userid);
await _context.SaveChangesAsync();
}
catch (DbUpdateConcurrencyException)
{
if (!Order9144Exists(id))
{
return(NotFound());
}
else
{
throw;
}
}
return(NoContent());
}
public async Task <ActionResult <Order9144> > PostOrder9144(Order9144 o)
{
// _context.Order9144.Add(o);
var orderID = await Task.FromResult(_context.Order9144.FromSqlRaw("EXEC CREATE_ORDER " +
"@PSHIPPINGADDRESS = " + o.Shippingaddress +
", @PUSERID = " + o.Userid).ToList());
// await _context.SaveChangesAsync();
// return CreatedAtAction("GetOrder9144", new { id = o.Orderid }, o);
return(orderID[0]);
}