public ActionResult Companies(string sortOrder, string searchString) { RecruitDB db = new RecruitDB(); ViewBag.NameSortParm = String.IsNullOrEmpty(sortOrder) ? "name_desc" : ""; var Company = from s in db.CompanyProfiles select s; if (!String.IsNullOrEmpty(searchString)) { Company = Company.Where(s => s.GroupOfCompany.ToString().Contains(searchString)); } switch (sortOrder) { case "name_desc": Company = Company.OrderByDescending(s => s.GroupOfCompany); break; default: Company = Company.OrderBy(s => s.GroupOfCompany); break; } return(View(Company.ToList())); }
public ActionResult Jobs(string sortOrder, string searchString) { RecruitDB db = new RecruitDB(); ViewBag.NameSortParm = String.IsNullOrEmpty(sortOrder) ? "name_desc" : ""; ViewBag.DateSortParm = sortOrder == "Date" ? "date_desc" : "Date"; var jobsVar = from s in db.CompanyJobPosts select s; if (!String.IsNullOrEmpty(searchString)) { jobsVar = jobsVar.Where(s => s.DegreeTitle.ToString().Contains(searchString)); } switch (sortOrder) { case "name_desc": jobsVar = jobsVar.OrderByDescending(s => s.CompanyProfile.GroupOfCompany); break; case "Date": jobsVar = jobsVar.OrderBy(s => s.JobPostingDate); break; case "date_desc": jobsVar = jobsVar.OrderByDescending(s => s.JobPostingDate); break; default: jobsVar = jobsVar.OrderBy(s => s.CompanyProfile.GroupOfCompany); break; } return(View(jobsVar.ToList())); }
public ActionResult Student() { RecruitDB db = new RecruitDB(); List <EmpProfile> employeeprofile = db.EmpProfiles.ToList(); return(View(employeeprofile)); }
public ActionResult Index() { RecruitDB db = new RecruitDB(); string CurrentUser = User.Identity.GetUserId(); int CurrentUserProfileID; if (db.CompanyProfiles.Where(r => r.UserID == CurrentUser).Any() == true) { CurrentUserProfileID = db.CompanyProfiles.Where(r => r.UserID == CurrentUser).First().CompanyProfileID; } else { return(RedirectToAction("Create", "CompanyProfile")); } ViewBag.A = db.CompanyProfiles.Where(r => r.UserID == CurrentUser).ToList(); ViewBag.B = db.CompanyLogos.Where(r => r.CompanyProfileID == CurrentUserProfileID).ToList(); ViewBag.C = db.CompanyJobPosts.Where(r => r.CompanyProfileID == CurrentUserProfileID).ToList(); ViewBag.CurrentUserBag = CurrentUserProfileID; return(View()); }
public ActionResult Index() { RecruitDB db = new RecruitDB(); string CurrentUser = User.Identity.GetUserId(); int CurrentUserProfileID; if (db.EmpProfiles.Where(r => r.UserID == CurrentUser).Any() == true) { CurrentUserProfileID = db.EmpProfiles.Where(r => r.UserID == CurrentUser).First().EmpProfileID; } else { return(RedirectToAction("Create", "Profile")); } ViewBag.A = db.EmpProfiles.Where(r => r.UserID == CurrentUser).ToList(); ViewBag.B = db.ProfilePhotos.Where(r => r.EmpProfileID == CurrentUserProfileID).ToList(); string Description = db.Qualifications.Where(r => r.EmpProfileID == CurrentUserProfileID).First().Description; ViewBag.StudentDescription = Description; string Nationality = db.EmpProfiles.Where(r => r.EmpProfileID == CurrentUserProfileID).First().Nationality; ViewBag.Nationality = Nationality; string DOB = db.EmpProfiles.Where(r => r.EmpProfileID == CurrentUserProfileID).First().DOB.ToShortDateString(); ViewBag.DOB = DOB; string CNIC = db.EmpProfiles.Where(r => r.EmpProfileID == CurrentUserProfileID).First().CNIC; ViewBag.CNIC = CNIC; ViewBag.Qualification = db.Qualifications.Where(r => r.EmpProfileID == CurrentUserProfileID).ToList(); ViewBag.Skill = db.EmpSkills.Where(r => r.EmpProfileID == CurrentUserProfileID).ToList(); ViewBag.Experience = db.EmpWorkExperiences.Where(r => r.EmpProfileID == CurrentUserProfileID).ToList(); ViewBag.F = db.EmpCVs.Where(r => r.EmpProfileID == CurrentUserProfileID).ToList(); ViewBag.CurrentUserBag = CurrentUserProfileID; return(new Rotativa.ViewAsPdf("Index")); }
public ActionResult Index() { RecruitDB db = new RecruitDB(); string CurrentUser = User.Identity.GetUserId(); int CurrentUserProfileID; if (db.EmpProfiles.Where(r => r.UserID == CurrentUser).Any() == true) { CurrentUserProfileID = db.EmpProfiles.Where(r => r.UserID == CurrentUser).First().EmpProfileID; } else { return(RedirectToAction("Create", "Profile")); } ViewBag.A = db.EmpProfiles.Where(r => r.UserID == CurrentUser).ToList(); ViewBag.B = db.ProfilePhotos.Where(r => r.EmpProfileID == CurrentUserProfileID).ToList(); ViewBag.C = db.Qualifications.Where(r => r.EmpProfileID == CurrentUserProfileID).ToList(); ViewBag.D = db.EmpSkills.Where(r => r.EmpProfileID == CurrentUserProfileID).ToList(); ViewBag.E = db.EmpWorkExperiences.Where(r => r.EmpProfileID == CurrentUserProfileID).ToList(); ViewBag.F = db.EmpCVs.Where(r => r.EmpProfileID == CurrentUserProfileID).ToList(); ViewBag.CurrentUserBag = CurrentUserProfileID; return(View()); }