public ActionResult Index() { using (var db = new Models.RecruitDBContext()) { ViewBag.specializations = db.Specialization.ToList(); ViewBag.careerLevels = db.CareerLevel.ToList(); } return(View()); }
public JsonResult Search() { var search_term = Request.QueryString["search"]; var specialization = Request.QueryString["specialization"]; var level = Request.QueryString["level"]; var jobs = new List <Models.Job>(); using (var db = new Models.RecruitDBContext()) { jobs = db.Job.Where(job => (job.title.Contains(search_term) || job.description.Contains(search_term) || job.requirements.Contains(search_term) || job.category.Contains(specialization) || job.level.Contains(level))).ToList(); } return(Json(new { status = "success", data = jobs }, JsonRequestBehavior.AllowGet)); }
protected override void Seed(Models.RecruitDBContext context) { context.Country.Add( new Country { name = "Nigeria", code = "NG" } ); context.Country.Add( new Country { name = "South Africa", code = "ZA" } ); context.State.Add( new State { name = "Lagos", country_code = "NG" } ); context.State.Add( new State { name = "Abuja", country_code = "NG" } ); context.Specialization.Add( new Specialization { name = "Accounting / Audit / Tax", code = "ACC" } ); context.Specialization.Add( new Specialization { name = "Programming", code = "PRG" } ); context.CareerLevel.Add( new CareerLevel { name = "Vocational/Semi-Skilled/Unskilled Labour", code = "SKILLED_LABOUR" } ); context.CareerLevel.Add( new CareerLevel { name = "Undergraduate Internship/Vacation Job", code = "UNDER_GRAD" } ); context.CareerLevel.Add( new CareerLevel { name = "Fresh Graduate/Entry Level/Graduate Internship", code = "ENTRY_LEVEL" } ); context.CareerLevel.Add( new CareerLevel { name = "Experienced (Non-Manager)", code = "EXPERIENCED" } ); context.CareerLevel.Add( new CareerLevel { name = "Manager (Staff Supervisor/Head of Department)", code = "MANAGER" } ); context.CareerLevel.Add( new CareerLevel { name = "Executive (Director/CEO/CFO/COO)", code = "EXEC" } ); base.Seed(context); }