public async Task <ActionResult <Location2177> > PostLocation2177(Location2177 l)
{
// _context.Location2177.Add(location2177);
try
{
_context.Database.ExecuteSqlRaw("EXEC ADD_LOCATION @PLOCID = " + l.Locationid +
", @PLOCNAME = " + l.Locname +
", @PLOCADDRESS = " + l.Address +
", @PMANAGER = " + l.Manager);
await _context.SaveChangesAsync();
}
catch (DbUpdateException)
{
if (Location2177Exists(l.Locationid))
{
return(Conflict());
}
else
{
throw;
}
}
return(CreatedAtAction("GetLocation2177", new { id = l.Locationid }, l));
}
public async Task <IActionResult> PutLocation2177(string id, Location2177 l)
{
if (id != l.Locationid)
{
return(BadRequest());
}
// _context.Entry(location2177).State = EntityState.Modified;
try
{
await _context.SaveChangesAsync();
}
catch (DbUpdateConcurrencyException)
{
if (!Location2177Exists(id))
{
return(NotFound());
}
else
{
throw;
}
}
return(NoContent());
}
