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