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