public void DeleteData()
{
_employeeInfoRepository.ExecuteSqlCommand("SET FOREIGN_KEY_CHECKS = 0");
_employeeInfoRepository.ExecuteSqlCommand("TRUNCATE TABLE employee_info");
_employeeInfoRepository.ExecuteSqlCommand("TRUNCATE TABLE employee_workschedule");
_employeeInfoRepository.ExecuteSqlCommand("TRUNCATE TABLE employee_hours_total");
_employeeInfoRepository.ExecuteSqlCommand("TRUNCATE TABLE work_schedule");
_employeeInfoRepository.ExecuteSqlCommand("TRUNCATE TABLE employee_daily_payroll");
_employeeInfoRepository.ExecuteSqlCommand("TRUNCATE TABLE employee");
_employeeInfoRepository.ExecuteSqlCommand("SET FOREIGN_KEY_CHECKS = 1");
}