public static void StartStep(int id, int employee_id) { bool isWorkingOn = false; var data = LoadStepById(id); var incidentEmployeeData = IncidentEmployeeProcessor.LoadEmployeesByIncidentId(data.incident_id); foreach (var employee in incidentEmployeeData) { if (employee_id == employee.Employee_Id) { isWorkingOn = true; } } if (isWorkingOn == false) { IncidentEmployeeProcessor.AddEmployeeToIncident(data.incident_id, employee_id); } data.datetimeStart = DateTime.Now; var datetimestring = data.datetimeStart.ToString("yyyy/MM/dd HH:mm:ss"); data.status = "busy"; IncidentStepEmployeeprocessor.AddEmployeeToStep(employee_id, id); string sql = $"Update incident_timeline Set datetimeStart = '{datetimestring}', status = '{data.status}'"; SQLDataAccess.SaveData(sql, data); }
public static void DeleteStep(int id) { var employees = IncidentStepEmployeeprocessor.LoadEmployeesFromStepId(id); foreach (var employee in employees) { IncidentStepEmployeeprocessor.RemoveEmployeeFromStep(id, employee.employee_id); } string sql = $"DELETE FROM incident_timeline WHERE id = '{id}';"; SQLDataAccess.DeleteData(sql); }