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