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