public virtual IEnumerable <TrainingAndRelatedEmployees> GetTrainingAndRelatedEmployees(int trainingId)
{
IEnumerable <Training> trainingList = new RepositoryFactory().Create <Training>().GetAll();
IEnumerable <Employee> employeeList = new RepositoryFactory().Create <Employee>().GetAll();
IEnumerable <TrainingEmployee> trainingEmployeeList = new TrainingEmployeeRepository().GetAll();
try
{
var result = from training in trainingList
join combo in trainingEmployeeList on training.TrainingId equals combo.TrainingId
join employee in employeeList on combo.EmployeeId equals employee.EmployeeId
select new TrainingAndRelatedEmployees
{
TrainingId = training.TrainingId,
TrainingName = training.TrainingName,
EmployeeName = employee.EmployeeName
};
return(result.Where(item =>
item.TrainingId == trainingId));
}
catch (Exception e)
{
Console.WriteLine("Error in combining training and employee : " + e);
return(new List <TrainingAndRelatedEmployees>());
}
}
public virtual dynamic GetEmployeeAndRelatedTraining(int employeeId)
{
IEnumerable <Training> trainingList = new TrainingRepository().GetAll().Result;
IEnumerable <Employee> employeeList = new EmployeeRepository().GetAll().Result;
IEnumerable <TrainingEmployee> trainingEmployeeList = new TrainingEmployeeRepository().GetAll().Result;
try
{
var result = from emp in employeeList
join combo in trainingEmployeeList on emp.EmployeeId equals combo.EmployeeId
join train in trainingList on combo.TrainingId equals train.TrainingId
select new
{
EmployeeId = emp.EmployeeId,
EmployeeName = emp.EmployeeName,
TrainingName = train.TrainingName
};
return(result.Where(item =>
item.EmployeeId == employeeId));
}
catch (Exception e)
{
Console.WriteLine("Error in combining training and employee : " + e);
return(new List <dynamic>());
}
}
public virtual async Task <bool> AddEmployeesToTrainingProgram(int trainingId, List <int> employeeIdList)
{
try
{
TrainingEmployeeRepository comboRepo = new TrainingEmployeeRepository();
foreach (int id in employeeIdList)
{
TrainingEmployee item = new TrainingEmployee();
item.TrainingId = trainingId;
item.EmployeeId = id;
await comboRepo.Insert(item);
}
return(true);
}
catch (Exception e)
{
Console.WriteLine("Encountered error while adding employees to training: " + e);
return(false);
}
}
