public static IEnumerable <SelectListItem> GetList(string name) { List <SelectListItem> skillsets = new List <SelectListItem>(); try { SelectListItem skillset = null; using (RPEntities db = new RPEntities()) { var skillsetsFromDB = db.SkillSets.Where(u => u.Name.Contains(name)).ToList(); { foreach (SkillSet thisSkillSet in skillsetsFromDB) { skillset = new SelectListItem(); skillset.Value = thisSkillSet.SkillSetId.ToString(); skillset.Text = thisSkillSet.Name; skillset.Selected = false; skillsets.Add(skillset); } } } } catch (Exception exp) { Logger.LogException(exp); } return(skillsets); }
public static Resource Initialize(int resourceId) { Resource resource = null; using (RPEntities db = new RPEntities()) { resource = db.Resources.Include(r => r.ResourceDocuments.Select(d => d.DocumentType)).Include(t => t.ResourceType).Include(v => v.Vendor).Include(v => v.Vendor1) .Include(c => c.Client).Include(u => u.AspNetUser).Include(s => s.ResourceSkillSets.Select(n => n.SkillSet)).Where(r => r.ResourceId == resourceId).FirstOrDefault(); } return(resource); }
public static IEnumerable <InterviewViewModel> GetInterviews(int resourceId) { using (RPEntities db = new RPEntities()) { var interviews = db.Interviews.Include(i => i.InterviewDetails).Where(i => i.ResourceId == resourceId).Select(x => new InterviewViewModel { InterviewId = x.InterviewId, InterviewDate = x.StartTime, InterviewType = x.InterviewType, InterviewStatus = x.Status, InterviewerName = x.Interviewer.AspNetUser.FirstName + " " + x.Interviewer.AspNetUser.LastName, InterviewerId = x.InterviewerId.Value, AverageRating = x.InterviewDetails.Where(d => d.InterviewId == x.InterviewId).Select(r => r.Rating).Average() }); return(interviews.ToList()); } }
public static IEnumerable <SuggestedResourceModel> GetResources(int requirementId) { using (RPEntities db = new RPEntities()) { var requirementSkillSetIds = db.RequirementSkillSets.Where(r => r.RequirementId == requirementId).Select(s => s.SkillSetId).ToList(); var resources = db.Resources.Include(r => r.AspNetUser).Where(r => r.ResourceSkillSets.Any(s => requirementSkillSetIds.Contains(s.SkillSetId))) .GroupBy(x => new { x.ResourceId, x.AspNetUser.FirstName, x.AspNetUser.LastName, x.Availability, x.ProjectEndDate }) .Select(g => new SuggestedResourceModel { ResourceId = g.Key.ResourceId, Name = g.Key.FirstName + " " + g.Key.LastName, Availability = g.Key.Availability, ProjectEndDate = g.Key.ProjectEndDate }); return(resources.ToList()); } }
public static IEnumerable <RequirementDisplayModel> GetRequirements(int resourceId) { using (RPEntities db = new RPEntities()) { var resourceSkillSetIds = db.ResourceSkillSets.Where(r => r.ResourceId == resourceId).Select(s => s.SkillSetId).ToList(); var requirements = db.Requirements.Include(r => r.Client).Where(r => r.RequirementSkillSets.Any(s => resourceSkillSetIds.Contains(s.SkillSetId)) && r.Status == 1) .GroupBy(x => new { x.JobNumber, x.JobTitle, x.Client.Name, x.Description }) .Select(g => new RequirementDisplayModel { Client = g.Key.Name, JobNumber = g.Key.JobNumber, JobTitle = g.Key.JobTitle, Description = g.Key.Description, RequirementId = g.Min(r => r.RequirementId) }); return(requirements.ToList()); } }
public static IEnumerable <SuggestedResourceModel> GetList(string name) { List <SuggestedResourceModel> resources = null; try { using (RPEntities db = new RPEntities()) { resources = db.Resources.Where(u => u.AspNetUser.FirstName.Contains(name) || u.AspNetUser.LastName.Contains(name)) .Select(g => new SuggestedResourceModel { ResourceId = g.ResourceId, Name = g.AspNetUser.FirstName + " " + g.AspNetUser.LastName, Availability = g.Availability, ProjectEndDate = g.ProjectEndDate }).ToList(); } } catch (Exception exp) { Logger.LogException(exp); } return(resources); }