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