public async Task <ActionResult <Location9144> > PostLocation9144(Location9144 l)
{
// _context.Location9144.Add(location9144);
try
{
_context.Database.ExecuteSqlRaw("EXEC ADD_LOCATION @PLOCID = " + l.LocationID +
", @PLOCNAME = " + l.LocationName +
", @PLOCADDRESS = " + l.Address +
", @PMANAGER = " + l.Manager);
await _context.SaveChangesAsync();
}
catch (DbUpdateException)
{
if (Location9144Exists(l.LocationID))
{
return(Conflict());
}
else
{
throw;
}
}
return(CreatedAtAction("GetLocation9144", new { id = l.LocationID }, l));
}
public async Task <IActionResult> PutLocation9144(string id, Location9144 l)
{
if (id != l.LocationID)
{
return(BadRequest());
}
// _context.Entry(location9144).State = EntityState.Modified;
try
{
await _context.SaveChangesAsync();
}
catch (DbUpdateConcurrencyException)
{
if (!Location9144Exists(id))
{
return(NotFound());
}
else
{
throw;
}
}
return(NoContent());
}
