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