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