public async Task <IActionResult> PutOperator(int id, StaffOperator staffOperator)
{
if (id != staffOperator.OperatorId)
{
return(BadRequest());
}
await _context.Database.ExecuteSqlInterpolatedAsync(
$"UPDATE \"Operators\" SET \"DepartmentId\" = {staffOperator.DepartmentId}, \"LastName\" = {staffOperator.LastName}, \"FirstName\" = {staffOperator.FirstName}, \"MiddleName\" = {staffOperator.MiddleName}, \"DateOfBirth\" = {staffOperator.DateOfBirth}, \"Region\" = {staffOperator.Region}, \"City\" = {staffOperator.City}, \"Street\" = {staffOperator.Street}, \"Building\" = {staffOperator.Building}, \"Flat\" = {staffOperator.Flat}, \"Beginning\" = {staffOperator.Beginning}, \"Ending\" = {staffOperator.Ending}, \"Salary\" = {staffOperator.Salary}, \"WorkingPhone\" = {staffOperator.WorkingPhone} WHERE \"OperatorId\" = {id}");
try
{
await _context.SaveChangesAsync();
}
catch (DbUpdateConcurrencyException)
{
if (!OperatorExists(id))
{
return(NotFound());
}
else
{
throw;
}
}
return(NoContent());
}
public async Task <ActionResult <StaffOperator> > PostOperator(StaffOperator staffOperator)
{
await _context.Database.ExecuteSqlInterpolatedAsync($"INSERT INTO \"Operators\" (\"DepartmentId\", \"LastName\", \"FirstName\", \"MiddleName\", \"DateOfBirth\", \"Region\", \"City\", \"Street\", \"Building\", \"Flat\", \"Beginning\", \"Ending\", \"Salary\", \"WorkingPhone\") VALUES ({staffOperator.DepartmentId}, {staffOperator.LastName}, {staffOperator.FirstName}, {staffOperator.MiddleName}, {staffOperator.DateOfBirth}, {staffOperator.Region}, {staffOperator.City}, {staffOperator.Street}, {staffOperator.Building}, {staffOperator.Flat}, {staffOperator.Beginning}, {staffOperator.Ending}, {staffOperator.Salary}, {staffOperator.WorkingPhone})");
await _context.SaveChangesAsync();
return(CreatedAtAction("GetOperator", new { id = staffOperator.OperatorId }, staffOperator));
}
