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 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"));
}
