public ActionResult Details(int applicationId) { // get application Application application = _applicationsRepository.GetApplicationById(applicationId); // get current user logged in int userIdCurrentlyLoggedIn = Int32.Parse(User.Claims.FirstOrDefault(uc => uc.Type == ClaimTypes.NameIdentifier).Value); // check if application does not exists if (application == null) { return(NotFound()); } // check if application is not made by the applicant if (User.IsInRole("candidate")) { ViewBag.SelectedNav = "Profile"; if (application.JobFinderUser.UserId != userIdCurrentlyLoggedIn) { return(NotFound()); } } // check if company user is not assigned to see the job listing if (User.IsInRole("hr")) { ViewBag.SelectedNav = "Dashboard"; int companyId = application.JobListing.Company.CompanyId; if (!_companyUsersRepository.CompanyUserExists(userIdCurrentlyLoggedIn, companyId)) { return(NotFound()); } } // retrieve data for application ApplicationEducation applicationEducation = _applicationEducationsRepository.GetApplicationEducationForApplication(applicationId); ApplicationWorkExperience applicationWorkExperience = _applicationWorkExperience.GetApplicationWorkExperienceForApplication(applicationId); ApplicationSkill applicationSkill = _applicationSkillsRepository.GetApplicationSkillForApplication(applicationId); // build a list for potential application statuses List <string> ApplicationStatuses = new List <string> { "Pending", "Contacted", "Accepted", "Rejected" }; // build up a view model with all the data required to see an application ViewApplicationViewModel viewApplicationViewModel = new ViewApplicationViewModel { Application = application, ApplicationEducation = applicationEducation, ApplicationSkill = applicationSkill, ApplicationWorkExperience = applicationWorkExperience, OtherNotes = application.OtherNotes, Status = application.Status, ApplicationWrittenAt = application.ApplicationWrittenAt }; ViewBag.ApplicationStatuses = new SelectList(ApplicationStatuses, ApplicationStatuses); return(View(viewApplicationViewModel)); }
public void LoadApplicant(int appid) { try { using (var db = new LetranIntegratedSystemEntities()) { var findapp = db.HRISOnlineJobApplications.Find(appid); if (findapp != null) { //Personal Information txtFirstName.Text = findapp.FirstName; txtMiddleName.Text = findapp.MiddleName; txtLastName.Text = findapp.LastName; txtAddress.Text = findapp.CityAddress; txtTelNo.Text = findapp.TelephoneNo; txtMobileNo.Text = findapp.MobileNo; txtAge.Text = findapp.Age; if (findapp.Gender == "Male") { rbMale.IsChecked = true; } else { rbFemale.IsChecked = false; } dpBirthday.SelectedDate = findapp.Birthday; txtPlaceBirth.Text = findapp.Birthplace; cbCivilStatus.Text = findapp.CivilStatus; txtCitizenship.Text = findapp.Citizenship; txtReligion.Text = findapp.Religion; txtTIN.Text = findapp.TIN; txtSSS.Text = findapp.SSS; txtPagibig.Text = findapp.PAGIBIG; txtPhilhealth.Text = findapp.PHILHEALTH; //Educational Information AEList = new List <ApplicationEducation>(); cbEduc.ItemsSource = db.EducationalLevels.ToList(); cbEduc.DisplayMemberPath = "EducLevelName"; cbEduc.SelectedValuePath = "EducLevelID"; var appeduc = db.HRISOnlineJobApplicationEducations.Where(m => m.ApplicationID == findapp.ApplicationID).ToList(); foreach (var x in appeduc) { ApplicationEducation ae = new ApplicationEducation(); ae.EducLevelID = x.EducationType.Value; ae.Course = x.Course; ae.Honor = x.Honors; ae.InclusiveDate = x.InclusiveDates; ae.SchoolName = x.SchoolAddress; AEList.Add(ae); } dgEduc.ItemsSource = AEList; //Professional Licenses APList = new List <ApplicationProfessionalLicense>(); var applicense = db.HRISOnlineJobApplicationLicenses.Where(m => m.ApplicationID == findapp.ApplicationID).ToList(); foreach (var x in applicense) { ApplicationProfessionalLicense apl = new ApplicationProfessionalLicense(); apl.ExamDate = x.ExamDate.Value; apl.ExamPassed = x.ExamPassed; apl.ExamPlace = x.ExamPlace; apl.Rating = x.Rating; APList.Add(apl); } dgProf.ItemsSource = APList; //Work Experience AWEList = new List <ApplicationWorkExperience>(); var appwork = db.HRISOnlineJobApplicationWorkExperiences.Where(m => m.ApplicationID == findapp.ApplicationID).ToList(); foreach (var x in appwork) { ApplicationWorkExperience awe = new ApplicationWorkExperience(); awe.Company = x.CompanyName; awe.InclusiveDate = x.InclusiveDate; awe.LastSalary = x.LastSalary; awe.Position = x.Position; awe.ReasonforLeaving = x.ReasonLeaving; AWEList.Add(awe); } dgWorkExp.ItemsSource = AWEList; //Seminars / Training Attended ASList = new List <ApplicationSeminar>(); var appsem = db.HRISOnlineJobApplicationSeminars.Where(m => m.ApplicationID == findapp.ApplicationID).ToList(); foreach (var x in appsem) { ApplicationSeminar asem = new ApplicationSeminar(); asem.InclusiveDate = x.InclusiveDate; asem.Seminar = x.Title; asem.Venue = x.Venue; ASList.Add(asem); } dgSem.ItemsSource = ASList; //Additional Qualifications txtSpecialskill.Text = findapp.SpecialSkills; txtLanguage.Text = findapp.LanguagesSpeak; txtMachine.Text = findapp.MachinesOperate; txtKnowledge.Text = findapp.AdditionalKnowledge; txtImpairment.Text = findapp.PhyschologicalImpairments; cbStatus.SelectedValue = Convert.ToInt32(findapp.ApplicationStatusID); } else { MessageBox.Show("Applicant not found.", "System Warning!", MessageBoxButton.OK, MessageBoxImage.Warning); } } } catch (Exception) { MessageBox.Show("Something went wrong.", "System Error!", MessageBoxButton.OK, MessageBoxImage.Error); } }
public ActionResult Create(int jobId, IFormCollection collection) { Template jobTemplate = _templatesRepository.GetTemplateByJobId(jobId); int userIdCurrentlyLoggedIn = Int32.Parse(User.Claims.FirstOrDefault(uc => uc.Type == ClaimTypes.NameIdentifier).Value); Application application = new Application { Status = "Pending", UserId = userIdCurrentlyLoggedIn, ApplicationWrittenAt = DateTime.Now, JobListingId = jobId }; if (jobTemplate.OtherNotes == 1) { application.OtherNotes = collection["otherNotes"]; } int ApplicationId = _applicationsRepository.AddApplication(application); if (jobTemplate.WorkExperience == 1) { ApplicationWorkExperience newApplicationWorkExperience = new ApplicationWorkExperience { CompanyName = collection["workExpCompanyName"], StartDate = DateTime.Parse(collection["workExpStartDate"]), EndDate = DateTime.Parse(collection["workExpEndDate"]), Position = collection["workExpPosition"], Responsibilities = collection["workExpResponsibilities"], Duties = collection["workExpDuties"], ApplicationId = ApplicationId }; _dbContext.ApplicationWorkExperiences.Add(newApplicationWorkExperience); _dbContext.SaveChanges(); } if (jobTemplate.Skills == 1) { ApplicationSkill newApplicationSkill = new ApplicationSkill { Name = collection["skillName"], Rating = Int16.Parse(collection["skillRating"]), Description = collection["skillDescription"], ApplicationId = ApplicationId }; _dbContext.ApplicationSkills.Add(newApplicationSkill); _dbContext.SaveChanges(); } if (jobTemplate.Education == 1) { ApplicationEducation newApplicationEducation = new ApplicationEducation { SchoolName = collection["schoolName"], StartDate = DateTime.Parse(collection["educationStartDate"]), EndDate = DateTime.Parse(collection["educationEndDate"]), Degree = collection["educationDegree"], ApplicationId = ApplicationId }; _dbContext.ApplicationEducations.Add(newApplicationEducation); _dbContext.SaveChanges(); } ViewBag.SelectedNav = "Jobs"; return(RedirectToAction("Index", "Jobs")); }