public IActionResult Jobs() { using (var db = new jobsDBContext()) { var jobs = new List <JobDTO>(); var jobposts = db.JobPostings.ToList(); foreach (var jobpost in jobposts) { var companyName = db.Users.Include(a => a.Company).Where(a => a.Id == jobpost.RecruiterId).OrderByDescending(a => a.Id).Select(a => new { a.Company.Name, a.Company.Location }).FirstOrDefault(); jobs.Add(new JobDTO { Id = jobpost.Id, Company = companyName.Name, Date = jobpost.AddedDate.ToShortDateString(), Details = jobpost.Details, LocationLink = companyName.Location, Title = jobpost.Title, isDeaf = jobpost.IsDeaf, isBlind = jobpost.IsBlind, isAll = jobpost.IsAll }); } return(View(jobs)); } }
public IActionResult Login(string email, string password) { using (var db = new jobsDBContext()) { var user = db.Users.FirstOrDefault(a => a.Email.ToLower() == email.ToLower() && a.Password == password); if (user == null) { ViewBag.error = "error"; return(View()); } else { HttpContext.Session.SetString("UserId", user.Id + ""); HttpContext.Session.SetString("Role", user.RoleId + ""); HttpContext.Session.SetString("Name", user.Firstname + " " + user.Lastname); if (user.RoleId == 1) { return(RedirectToAction("managejobs")); } else if (user.RoleId == 2) { return(RedirectToAction("jobs")); } else { return(RedirectToAction("jobs")); } } } }
public IActionResult MyJobs() { int userId = -1; if (int.TryParse(HttpContext.Session.GetString("UserId"), out userId) && int.TryParse(HttpContext.Session.GetString("Role"), out int roleId) && roleId == 2) { using (var db = new jobsDBContext()) { var jobs = new List <JobDTO>(); var jobposts = db.JobApplications.Include(a => a.JobPosting).Where(a => a.ApplicantId == userId).Select(a => a.JobPosting).ToList(); foreach (var jobpost in jobposts) { var companyName = db.Users.Include(a => a.Company).Where(a => a.Id == jobpost.RecruiterId).Select(a => new { a.Company.Name, a.Company.Location }).FirstOrDefault(); jobs.Add(new JobDTO { Id = jobpost.Id, Company = companyName.Name, Date = jobpost.AddedDate.ToShortDateString(), Details = jobpost.Details, LocationLink = companyName.Location, Title = jobpost.Title, isDeaf = jobpost.IsDeaf, isBlind = jobpost.IsBlind, isAll = jobpost.IsAll }); } return(View(jobs)); } } else { return(RedirectToAction("Login")); } }
public IActionResult ManageJobs() { int userId = -1; if (int.TryParse(HttpContext.Session.GetString("UserId"), out userId) && int.TryParse(HttpContext.Session.GetString("Role"), out int roleId) && roleId == 1) { using (var db = new jobsDBContext()) { var jobPosts = new List <ManageJobDTO>(); var jobposts = db.JobPostings.Where(a => a.RecruiterId == userId).ToList(); foreach (var jobPost in jobposts) { int numOfApplicants = db.JobApplications.Where(a => a.JobPostingId == jobPost.Id).Count(); jobPosts.Add(new ManageJobDTO { Id = jobPost.Id, NoApp = numOfApplicants, Status = jobPost.IsActive?"Active":"Inactive", Title = jobPost.Title }); } return(View(jobPosts)); } } else { return(RedirectToAction("Login")); } }
public IActionResult CreateJobs(JobPostings JobPost) { using (var db = new jobsDBContext()) { var userId = int.Parse(HttpContext.Session.GetString("UserId")); JobPost.RecruiterId = userId; JobPost.IsActive = true; JobPost.AddedDate = DateTime.Now; db.JobPostings.Add(JobPost); db.SaveChanges(); return(RedirectToAction("ManageJobs")); } }
public IActionResult Create(Messages message) { using (var db = new jobsDBContext()) { int userId = -1; if (int.TryParse(HttpContext.Session.GetString("UserId"), out userId)) { message.FromId = userId; message.SendDate = DateTime.Now; db.Messages.Add(message); db.SaveChanges(); } return(Ok()); } }
public IActionResult JobDescription(int id) { using (var db = new jobsDBContext()) { var jobpost = db.JobPostings.FirstOrDefault(a => a.Id == id); var companyName = db.Users.Include(a => a.Company).Where(a => a.Id == jobpost.RecruiterId).Select(a => new { a.Company.Name, a.Company.Location }).FirstOrDefault(); var jobDTO = new JobDescriptionDTO { Id = jobpost.Id, Company = companyName.Name, Date = jobpost.AddedDate.ToShortDateString(), Details = jobpost.Details, LocationLink = companyName.Location, Title = jobpost.Title }; return(View(jobDTO)); } }
public IActionResult CreateJobs() { if (int.TryParse(HttpContext.Session.GetString("UserId"), out int userId) && int.TryParse(HttpContext.Session.GetString("Role"), out int roleId) && roleId == 1) { List <SelectListItem> categories = new List <SelectListItem>(); using (var db = new jobsDBContext()) { categories = db.Categories.Select(a => new SelectListItem { Value = a.Id.ToString(), Text = a.Name }).ToList(); ViewBag.categories = categories; return(View()); } } else { return(View("Login")); } }
public IActionResult ManageApplicants(int id) { int userId = -1; if (int.TryParse(HttpContext.Session.GetString("UserId"), out userId) && int.TryParse(HttpContext.Session.GetString("Role"), out int roleId) && roleId == 1) { using (var db = new jobsDBContext()) { ViewBag.jobTitle = db.JobPostings.Where(a => a.Id == id).Select(a => a.Title).FirstOrDefault(); var applicants = db.JobApplications.Include(a => a.Applicant).Include(a => a.Applicant.Disability).Where(a => a.JobPostingId == id).Select(a => new ApplicantDTO { Id = a.Applicant.Id, Name = a.Applicant.Firstname + " " + a.Applicant.Lastname, DisabilityId = (a.Applicant.DisabilityId == null ? 4 : (int)a.Applicant.DisabilityId) }).ToList(); return(View(applicants)); } } else { return(RedirectToAction("login")); } }
public IActionResult Apply(int id) { int userId = -1; if (int.TryParse(HttpContext.Session.GetString("UserId"), out userId) && int.TryParse(HttpContext.Session.GetString("Role"), out int roleId) && roleId == 2) { using (var db = new jobsDBContext()) { var jobapp = new JobApplications { JobPostingId = id, ApplicantId = userId, }; db.JobApplications.Add(jobapp); db.SaveChanges(); return(View()); } } else { return(RedirectToAction("Login")); } }
public IActionResult Index(int?toUserId, int?mode) { using (var db = new jobsDBContext()) { int userId = -1; if (int.TryParse(HttpContext.Session.GetString("UserId"), out userId)) { if (toUserId == null) { toUserId = db.Messages.Where(a => a.ToId == userId || a.FromId == userId).OrderByDescending(a => a.Id).Select(a => a.ToId == userId?a.FromId:a.ToId).FirstOrDefault(); } var messages = db.Messages.Where(a => (a.FromId == userId && a.ToId == toUserId) || (a.FromId == toUserId && a.ToId == userId)).ToList(); ViewBag.thisUserId = userId; ViewBag.toUserId = toUserId; ViewBag.mode = mode ?? 0; ViewBag.toName = db.Users.Where(a => a.Id == toUserId).Select(a => a.Firstname + " " + a.Lastname).FirstOrDefault(); return(View(messages)); } else { return(RedirectToAction("login", "home")); } } }