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);
}
public static int DeleteEmployee(int?Id)
{
string sql = $@"delete from dbo.Employee where EmployeeId = {Id}";
return(SQLDataAccess.DeleteData(sql));
}
public static void RemoveEmployeeFromIncident(int id, int employee_Id)
{
string sql = $"DELETE FROM incident_employee WHERE incident_id = '{id}' AND employee_id = '{employee_Id}';";
SQLDataAccess.DeleteData(sql);
}
public static void DeleteIncident(int id)
{
string sql = $"DELETE FROM incident WHERE id = '{id}';";
SQLDataAccess.DeleteData(sql);
}
public static void RemoveEmployeeFromStep(int stepId, int employeeId)
{
string sql = $"DELETE FROM incidenttimeline_employee WHERE incidentTimeline_id = '{stepId}' AND employee_id = '{employeeId}';";
SQLDataAccess.DeleteData(sql);
}
public static void DeleteEmployee(int id)
{
string sql = $"DELETE FROM employee WHERE id = '{id}';";
SQLDataAccess.DeleteData(sql);
}
public static void DeleteHours(int id)
{
string sql = $"DELETE FROM registeredhours WHERE id = '{id}';";
SQLDataAccess.DeleteData(sql);
}
public static void DeleteEvent(int id)
{
string sql = $"DELETE FROM schedule WHERE id = '{id}';";
SQLDataAccess.DeleteData(sql);
}
