public ActionResult Index() { try { using (var context = new VhDbContext()) { var listOfJobs = context.JobModel.Include("company").ToList(); var newJobList = new List <JobDTO>(); foreach (var job in listOfJobs) { var princialSkill = context.Skill.Find(job.PrincipalSkill).SkillName; newJobList.Add(new JobDTO { CityCountry = job.City + ", " + job.Country, CompanyName = job.Company.Name, Id = job.Id, Position = job.Position, PrincipalSkill = princialSkill, Published = job.PostDate }); } ViewBag.ListOfJobs = newJobList.ToList(); } return(View()); } catch (Exception) { throw; } }
public ActionResult UserView(int userId) { using (var context = new VhDbContext()) { var listJob = new List <JobDTO>(); var user = context.User.Find(userId); var jobForUserPosition = context.JobModel.Where(c => c.Position == user.Position).ToList(); var jobForPrinciipalSkill = context.JobModel.Where(c => c.PrincipalSkill == user.PrincipalSkill).ToList(); foreach (var job in jobForUserPosition) { var princialSkill = context.Skill.Find(job.PrincipalSkill).SkillName; var companyName = context.Company.Find(job.CompanyId).Name; listJob.Add(new JobDTO { CityCountry = job.City + ", " + job.Country, CompanyName = companyName, Id = job.Id, Position = job.Position, PrincipalSkill = princialSkill, Published = job.PostDate }); } foreach (var job in jobForPrinciipalSkill) { var princialSkill = context.Skill.Find(job.PrincipalSkill).SkillName; listJob.Add(new JobDTO { CityCountry = job.City + ", " + job.Country, CompanyName = job.Company.Name, Id = job.Id, Position = job.Position, PrincipalSkill = princialSkill, Published = job.PostDate }); } ViewBag.ListOfJobs = listJob.ToList(); ViewBag.User = user; } return(View()); }
public ActionResult UserList() { try { using (var context = new VhDbContext()) { var listOfUsers = context.User.ToList(); var newUserList = new List <UserDTO>(); foreach (var user in listOfUsers) { //var princialSkill = context.Skill.Find(user.PrincipalSkill); newUserList.Add(new UserDTO { Email = user.Email, EnglishLevel = user.EnglishLevel, FirstName = user.FirstName, LastName = user.LastName, Id = user.Id, Linkedin = user.Linkedin, Position = user.Position, Skills = user.Skills, YearsOfExperience = user.YearsOfExperience }); } ViewBag.ListOfUser = newUserList.ToList(); } return(View()); } catch (Exception) { throw; } }
public ActionResult JobView(int jobId) { try { using (var context = new VhDbContext()) { var princialSkill = ""; var job = context.JobModel.Find(jobId); var listOfUsersWithPricinpalSkill = new List <ListUserPrincipalSkillDTO>(); var peopleWhithPrincipalSkills = context.UserSkill.Where(c => c.SkillId == job.PrincipalSkill && c.YeatsOfExperience == job.YearOfExperience ).ToList(); var findPosition = context.User.Where(c => c.Position == job.Position).ToList(); var companyName = context.Company.Find(job.CompanyId).Name; foreach (var user in peopleWhithPrincipalSkills) { var _user = context.User.Find(user.UserId); princialSkill = context.Skill.Find(job.PrincipalSkill).SkillName; listOfUsersWithPricinpalSkill.Add(new ListUserPrincipalSkillDTO { EnglishLevel = _user.EnglishLevel, FirstName = _user.FirstName, LastName = _user.LastName, Position = _user.Position, UserId = _user.Id, YearsOfExprience = _user.YearsOfExperience, Email = _user.Email, PricinpalSkill = princialSkill, }); } foreach (var _user in findPosition) { listOfUsersWithPricinpalSkill.Add(new ListUserPrincipalSkillDTO { EnglishLevel = _user.EnglishLevel, FirstName = _user.FirstName, LastName = _user.LastName, Position = _user.Position, UserId = _user.Id, YearsOfExprience = _user.YearsOfExperience, Email = _user.Email, PricinpalSkill = princialSkill, }); } ViewBag.ListOfUsers = listOfUsersWithPricinpalSkill.ToList(); ViewBag.Job = job; ViewBag.CompanyName = companyName; ViewBag.PrincipalSkill = princialSkill; } return(View()); } catch (Exception) { throw; } }