public int AddMachineDetail(MachineDetailWithDowntimeCode obj)
{
using var db = new SqlConnection(_connectionString);
var sql = @"INSERT INTO [dbo].[MachineDetails]
([notes]
,[runtime]
,[downtime])
output inserted.id
VALUES
(@notes
,@runtime
,@downtime)";
var newMachineDetailId = db.ExecuteScalar <int>(sql, obj);
var sqlToUpdateAssignment = @"UPDATE [dbo].[MachineAssignments]
SET [downtimeCodeId] = @downtimeCodeId
,[machineDetailId] = @machineDetailId
,[isCompleted] = @isCompleted
WHERE Id = @machineAssignmentId";
var parameters = new
{
machineAssignmentId = obj.MachineAssignmentId,
downtimeCodeId = obj.DowntimeCode,
machineDetailId = newMachineDetailId,
isCompleted = obj.IsCompleted,
};
var updateMachineAssignment = db.QueryFirstOrDefault <MachineAssignment>(sqlToUpdateAssignment, parameters);
return(newMachineDetailId);
}
public IActionResult AddMachineDetail(MachineDetailWithDowntimeCode newObj)
{
var newMachineDetailId = _repo.AddMachineDetail(newObj);
return(Created($"/api/machineDetails/{newMachineDetailId}", newMachineDetailId));
}
