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