public IActionResult Index() { UserInfoViewModel vm = new UserInfoViewModel(); var userInfo = _userInfoService.GetUserInfo(User.Identity.Name); vm.StartUserInfo = userInfo; if (User.IsInRole(ProfilerRoles.Student)) { var currentStudent = _studentService.GetCurrentStudentByUserInfo(userInfo.Id); var currentResume = _resumeService.GetResumeByStudentId(currentStudent.Id); vm.Stream = _streamService.GetStreamByStudentId(currentStudent.Id); vm.IsResumeExists = currentResume != null ? true : false; return(View(vm)); } else if (User.IsInRole(ProfilerRoles.HR)) { return(RedirectToAction(nameof(HrManagerController.Index), "HrManager")); } else if (User.IsInRole(ProfilerRoles.Trainer)) { return(RedirectToAction(nameof(TrainerController.Index), "Trainer")); } return(View(vm)); }
public IActionResult Index() { var vm = new ResumeViewModel(); #region Fill data to viewmodel (if it's exist) // Get info about current user vm.UserInfo = _userInfo; var currentStudent = _studentService.GetCurrentStudentByUserInfo(vm.UserInfo.Id); //Get current Resume Id Resume resume = _resumeService.GetResumeByStudentId(currentStudent.Id); //create new resume if it doesn't exist if (resume == null) { _resumeService.CreateResumeForStudent(currentStudent.Id); } //Fill data to viewmodel int resumeId = _resumeService.GetResumeByStudentId(currentStudent.Id).Id; vm.ResumeId = resumeId; vm.CurrentResumeStep = _resumeService.GetResumeByStudentId(currentStudent.Id).CurrentStep; var stream = _streamService.GetStreamByStudentId(currentStudent.Id); if (stream != null) { vm.StreamFullName = stream.StreamFullName; } var summary = _summaryService.GetSummaryByResumeId(resumeId); if (summary != null) { vm.Summary = summary.Text; } string [] existingStudentsSkill = _skillService.GetAllSkillsForStudent(currentStudent.Id).ToArray(); if (existingStudentsSkill.Length != 0) { vm.Skills = _skillService.GetAllSkillsForStudent(currentStudent.Id).ToArray(); } else { //If Student hasn't skills in DB, get the default skills by stream vm.Skills = _skillService.GetDefaultSkillsByStream(stream.Id).ToArray(); } vm.ForeignLanguages = _languageService.GetAllForeignLanguagesForResume(resumeId).ToDictionary(x => x.LanguageId, x => x.LanguageLevelId); vm.Educations = _educationService.GetAllEducationsForResume(resumeId).ToArray(); vm.Courses = _courseService.GetAllCoursesForResume(resumeId).ToArray(); vm.Certificates = _certificateService.GetAllCertificatesForResume(resumeId).ToArray(); vm.Exams = _examService.GetAllExamsForResume(resumeId).ToArray(); WorkExperience[] workExperiences = _workExperienceService.GetWorkExperienceForResume(resumeId).ToArray(); vm.WorkExperiences = new WorkExperienceViewModel[workExperiences.Length]; if (workExperiences.Count() != 0) { for (int i = 0; i < workExperiences.Count(); i++) { vm.WorkExperiences[i] = new WorkExperienceViewModel(workExperiences[i]); } } vm.Portfolios = _portfolioService.GetPortfolioForResume(resumeId).ToArray(); vm.MilitaryStatus = _militaryStatusService.GetMilitaryStatusForResume(resumeId); vm.Recommendations = _recommendationService.GetAllRecommendationsForResume(resumeId).ToArray(); vm.AdditionalInfo = _additionalInfoService.GetAdditionalInfo(resumeId); #endregion #region Fill data to dropdown lists //Get all languages from table Languages List <Language> languages = _languageService.GetAllLanguages().ToList(); languages.Insert(0, languages.First(l => l.Name == "English")); var index = languages.FindLastIndex(l => l.Name == "English"); languages.RemoveAt(index); //Fill data to dropdownlist Languages vm.Languages = languages; //Get all language levels from table LanguageLevels List <LanguageLevel> languageLevels = _languageService.GetAllLanguageLevels().ToList(); languageLevels.Insert(0, new LanguageLevel { LevelName = "---", Id = 0 }); //Fill data to dropdownlist language levels vm.LanguageLevels = languageLevels; //Get all skills from table Skills vm.SkillList = _skillService.GetAllSkills().ToList(); //Get all Months, Years from DateService vm.Months = _dateService.GetAllMonths(); vm.Years = _dateService.GetAllYears().ToList(); //Fill data to dropdownlist Education Levels vm.EducationLevels = _educationService.GetEducationLevels().ToList(); #endregion //TODO: add more other statuses, when they will be implemented if (resume != null && resume.Status == ResumeStatuses.Submitted) { return(RedirectToAction(nameof(ResumeReviewController.Index), "ResumeReview", new { resumeId = resume.Id })); } else { return(View("Index", vm)); } }
public HRStudentDataViewModel GetAllStudentViewData() { IList <Student> students = _studentService.GetAllStudents(); if (students.Count == 0) { return(null); } HRStudentDataViewModel viewModel = new HRStudentDataViewModel { LanguageLevels = _languageService.GetAllLanguageLevels(), Streams = _streamService.GetAllStreams(), TableData = new List <HRStudentDataViewModel.TableRow>() }; foreach (Student st in students) { UserInfo studentInfo = _studentService.GetUserInfo(st); Resume resume = _resumeService.GetResumeByStudentId(st.Id); HRStudentDataViewModel.TableRow row = new HRStudentDataViewModel.TableRow() { StudentId = st.Id, Choose = false, Stream = _streamService.GetStreamByStudentId(st.Id), RuName = studentInfo?.RuName, RuSurname = studentInfo.RuSurname, DateOfBirth = studentInfo.DateOfBirth, Email = studentInfo.Email, Phone = studentInfo.Phone, TrainerEmail = "*****@*****.**", DateOfGraduation = st.DateOfGraduation, GraduationMark = st.GraduationMark, ParticipationOnPracticalLab = false, Comments = null }; if (resume == null) { row.Languages = null; row.Status = "new"; row.Specializations = null; } else { row.Languages = _languageService.GetAllForeignLanguagesForResume(resume.Id); row.Status = resume.Status; row.Specializations = resume.Educations?.Select(s => s.Specialization); } var skills = _skillService.GetAllSkillsForStudent(st.Id); if (skills.Count() == 0) { row.StudentSkills = _skillService.GetDefaultSkillsByStream(_streamService.GetStreamByStudentId(st.Id).Id); } else { row.StudentSkills = skills; } viewModel.TableData.Add(row); } return(viewModel); }
public async Task <IActionResult> CreateTestAccounts() { //Define the web request params string apiUrl = "https://sheets.googleapis.com/v4/spreadsheets/"; string spreadsheetId = "1BK50eogFUI8z1Vmy6gzXRsjTbcywNo8YRgpRKya3qWo"; string sheetRange = "A2:Z"; string apiKey = "AIzaSyD6MYQCVZdN93XIL--ekM0SPOyQeY6fkPU"; string requestUrl = apiUrl + spreadsheetId + "/values/" + sheetRange + "?key=" + apiKey; //create request HttpWebRequest webRequest = (HttpWebRequest)WebRequest.Create(requestUrl); using (HttpWebResponse webResponse = (HttpWebResponse)webRequest.GetResponse()) { //read the response stream StreamReader reader = new StreamReader(webResponse.GetResponseStream()); var jsonString = reader.ReadToEnd(); //parse the response stream JObject deserealizedJson = JsonConvert.DeserializeObject(jsonString) as JObject; IEnumerable <JToken> tableRows = deserealizedJson.GetSheetRow(2); //verify that the trainer does not exist string trainerEmail = tableRows.FirstOrDefault().GetElementValue(0); ApplicationUser trainer = await _userManager.FindByEmailAsync(trainerEmail); if (trainer == null) { //create default trainer trainer = new ApplicationUser() { UserName = trainerEmail, Email = trainerEmail }; IdentityResult trainerCreationResult = await _userManager.CreateAsync(trainer, PasswordGenerator.Generate(6, 0)); if (trainerCreationResult.Succeeded) { foreach (JToken row in tableRows) { string sheetRowEmail = row.GetElementValue(7); //check if the email is already present in the system ApplicationUser dbUser = await _userManager.FindByEmailAsync(sheetRowEmail); if (dbUser == null) { //pick values from the spreadsheet for the new user ApplicationUser user = new ApplicationUser() { UserName = sheetRowEmail, Email = sheetRowEmail }; var result = await _userManager.CreateAsync(user, row.GetElementValue(12)); if (result.Succeeded) { //add to the role Students var currentUser = await _userManager.FindByNameAsync(user.UserName); await _userManager.AddToRoleAsync(currentUser, ProfilerRoles.Student); //add user info //TODO: parse the number UserInfo userInfo = new UserInfo { UserId = currentUser.Id, EnName = row.GetElementValue(1), EnSurname = row.GetElementValue(2), RuSurname = row.GetElementValue(3), RuName = row.GetElementValue(4), DateOfBirth = ParseDateTimeToBLRStandard(row.GetElementValue(6)), Email = row.GetElementValue(7), Phone = row.GetElementValue(8) }; await _userInfoService.AddUserInfoAsync(userInfo); //bind userInfo to applicationUser currentUser.UserInfo = userInfo; //save changes to the database to assign id to userinfo await _db.SaveChangesAsync(); //pick the created userInfo UserInfo userInfoCreated = _userInfoService.GetUserInfo(currentUser.Email); //TODO: verify datetime Student student = new Student { TrainerId = trainer.Id, UserInfoId = userInfoCreated.Id, DateOfGraduation = ParseDateTimeToBLRStandard(row.GetElementValue(9)), GraduationMark = Convert.ToInt32(row.GetElementValue(11)) }; await _studentService.AddOrUpdateStudentAsync(student); //save changes to assign id to the student await _db.SaveChangesAsync(); //pick the stream Model.Models.Stream stream = _streamService.GetStreamByShortName(row.GetElementValue(10)); if (stream != null) { //bind stream to the student await _studentService.AddStream(student, stream); } //create resume _resumeService.CreateResumeForStudent(student.Id); await _db.SaveChangesAsync(); //change resume Resume resume = _resumeService.GetResumeByStudentId(student.Id); resume.CurrentStep = Convert.ToInt32(row.GetElementValue(13)); _resumeService.UpdateResume(resume); //save changes await _db.SaveChangesAsync(); } } } } } else { ErrorViewModel evm = new ErrorViewModel { RequestId = "Something went wrong" }; return(View("Error", evm)); } } return(RedirectToAction("Index", "Home")); }