public int AddEmployeeToMachine(MachineAssignment machineAssignment)
{
var sql = @"INSERT INTO [dbo].[MachineAssignments]
([machineId]
,[employeeId]
,[isDeleted]
,[isRunning]
,[Date]
,[downtimeCodeId]
,[machineDetailId])
Output inserted.id
VALUES
(@machineId,@employeeId,0,0,getDate(),null,null)";
var parameters = new
{
machineId = machineAssignment.MachineId,
employeeId = machineAssignment.EmployeeId,
};
using var db = new SqlConnection(_connectionString);
var newId = db.ExecuteScalar <int>(sql, parameters);
return(newId);
}
public IActionResult CreateMachineAssignment(MachineAssignment machine)
{
_repo.AddEmployeeToMachine(machine);
return(Created($"/api/machineAssignments/{machine.Id}", machine));
}
