public async Task <IActionResult> PutDriver(int id, StaffDriver staffDriver) { if (id != staffDriver.DriverId) { return(BadRequest()); } await _context.Database.ExecuteSqlInterpolatedAsync( $"UPDATE \"Drivers\" SET \"DepartmentId\" = {staffDriver.DepartmentId}, \"LastName\" = {staffDriver.LastName}, \"FirstName\" = {staffDriver.FirstName}, \"MiddleName\" = {staffDriver.MiddleName}, \"DateOfBirth\" = {staffDriver.DateOfBirth}, \"Region\" = {staffDriver.Region}, \"City\" = {staffDriver.City}, \"Street\" = {staffDriver.Street}, \"Building\" = {staffDriver.Building}, \"Flat\" = {staffDriver.Flat}, \"Beginning\" = {staffDriver.Beginning}, \"Ending\" = {staffDriver.Ending}, \"Salary\" = {staffDriver.Salary}, \"Available\" = {staffDriver.Available} WHERE \"DriverId\" = {id}"); try { await _context.SaveChangesAsync(); } catch (DbUpdateConcurrencyException) { if (!DriverExists(id)) { return(NotFound()); } else { throw; } } return(NoContent()); }
public async Task <ActionResult <StaffDriver> > PostDriver(StaffDriver staffDriver) { await _context.Database.ExecuteSqlInterpolatedAsync($"INSERT INTO \"Drivers\" (\"CarId\", \"DepartmentId\", \"LastName\", \"FirstName\", \"MiddleName\", \"DateOfBirth\", \"Region\", \"City\", \"Street\", \"Building\", \"Flat\", \"Beginning\", \"Ending\", \"Salary\", \"Available\") VALUES ({staffDriver.CarId}, {staffDriver.DepartmentId}, {staffDriver.LastName}, {staffDriver.FirstName}, {staffDriver.MiddleName}, {staffDriver.DateOfBirth}, {staffDriver.Region}, {staffDriver.City}, {staffDriver.Street}, {staffDriver.Building}, {staffDriver.Flat}, {staffDriver.Beginning}, {staffDriver.Ending}, {staffDriver.Salary}, {staffDriver.Available})"); await _context.SaveChangesAsync(); return(CreatedAtAction("GetOperator", new { id = staffDriver.DriverId }, staffDriver)); }