public List <EmployeeService_RoleVM> GetListOfServices(int Id)
{
using (SDIIS_DatabaseEntities dbcontext = new SDIIS_DatabaseEntities()) {
var employeeServices = (from a in dbcontext.EmployeeServices
where a.Employee_Id == Id
select a).ToList();
List <EmployeeService_RoleVM> NewModelListS = new List <EmployeeService_RoleVM>();
foreach (var item in employeeServices)
{
EmployeeService_RoleVM NewModelS = new EmployeeService_RoleVM();
NewModelS.Employee_Id = Id;
NewModelS.EmployeeServiceId = item.Problem_Category_Id;
NewModelS.ServiceDescription = dbcontext.Problem_Categories.Find(item.Problem_Category_Id).Description;
NewModelListS.Add(NewModelS);
}
return(NewModelListS);
}
}
public List <EmployeeService_RoleVM> GetListOfRoles(int Id)
{
using (SDIIS_DatabaseEntities dbcontext = new SDIIS_DatabaseEntities())
{
var employeeRoles = (from a in dbcontext.EmployeeRoles
where a.Employee_Id == Id
select a).ToList();
List <EmployeeService_RoleVM> NewModelList = new List <EmployeeService_RoleVM>();
foreach (var item in employeeRoles)
{
EmployeeService_RoleVM NewModel = new EmployeeService_RoleVM();
NewModel.Employee_Id = Id;
NewModel.EmployeeRoleId = item.JobPosition_Id;
NewModel.RoleDescription = dbcontext.Job_Positions.Find(item.JobPosition_Id).Description;
NewModelList.Add(NewModel);
}
return(NewModelList);
}
}
