private void displaySecondaryEducation(EducationItem item)
{
selectedSecondaryEdu = item;
tbSchoolNameSecondary.Text = item._EDU_SCHOOL_NAME;
tbSchoolAddressSecondary.Text = item._EDU_SCHOOL_ADDRESS;
dpEduSecondaryDate.SelectedDate = DateTime.Parse(item._EDU_DATE_GRADUATED);
}
private void ImportEducations(IEnumerable <XElement> xEductaions, Resume Resume)
{
foreach (var xE in xEductaions)
{
var education = new Education
{
ResumeId = Resume.Id,
Resume = Resume,
Name = GetValue(xE.Element("Name"))
};
_educationService.Insert(education);
UpdateLocales(education, xE);
var eEntries = xE.Descendants("Entry");
foreach (var xEe in eEntries)
{
var eItem = new EducationItem
{
EducationId = education.Id,
Education = education,
Name = GetValue(xEe.Element("Name")),
Period = GetValue(xEe.Element("Period")),
Place = GetValue(xEe.Element("Place")),
Description = GetValue(xEe.Element("Description"))
};
_educationService.InsertEducationItem(eItem);
UpdateLocales(eItem, xEe);
}
}
}
private void BtnAddVocational_Click(object sender, RoutedEventArgs e)
{
if (VocEduValidation())
{
if (hasSelectedEdu)
{
hasSelectedEdu = false;
ChangeVocBtnIcon();
ClearVocationalEduFields();
cbVocationalCollect.SelectedIndex = -1;
selectedEduItem = null;
}
else
{
var eduItem = new EducationItem();
eduItem._EMP_ID = tbEmployeeId.Text;
eduItem._EDU_LEVEL = "Vocational";
eduItem._EDU_SCHOOL_NAME = tbSchoolNameVocational.Text;
eduItem._EDU_SCHOOL_ADDRESS = tbSchoolAddressVocational.Text;
eduItem._EDU_DATE_GRADUATED = dpEduVocationalDate.Text;
eduItem._EDU_DEGREE_EARNED = tbDegreeVocational.Text;
eduItem._EDU_HOLDER = "Education " + (vocationalEduCollection.Count + 1);
vocationalEduCollection.Add(eduItem);
cbVocationalCollect.ItemsSource = vocationalEduCollection;
ClearVocationalEduFields();
MessageBox.Show("New School Record added.");
}
}
}
private void BtnSaveVocational_Click(object sender, RoutedEventArgs e)
{
if (string.IsNullOrEmpty(tbSchoolNameVocational.Text) && string.IsNullOrEmpty(tbSchoolAddressVocational.Text) && string.IsNullOrEmpty(tbDegreeVocational.Text))
{
vocationalEduCollection.Remove(selectedVocationalEdu);
}
else
{
if (VocEduValidation())
{
var item = selectedVocationalEdu;
item._EDU_SCHOOL_NAME = tbSchoolNameVocational.Text;
item._EDU_SCHOOL_ADDRESS = tbSchoolAddressVocational.Text;
item._EDU_DEGREE_EARNED = tbDegreeVocational.Text;
item._EDU_DATE_GRADUATED = dpEduVocationalDate.Text;
}
}
hasSelectedEdu = false;
ChangeVocBtnIcon();
ClearVocationalEduFields();
cbVocationalCollect.SelectedIndex = -1;
selectedVocationalEdu = null;
MessageBox.Show("School record successfully updated.");
}
public async Task <ActionResult <EducationItem> > PostEducationItem(EducationItem educationItem)
{
_context.EducationItems.Add(educationItem);
await _context.SaveChangesAsync();
return(CreatedAtAction("GetEducationItem", new { id = educationItem.Id }, educationItem));
}
public async Task <IActionResult> PutEducationItem(long id, EducationItem educationItem)
{
if (id != educationItem.Id)
{
return(BadRequest());
}
_context.Entry(educationItem).State = EntityState.Modified;
try
{
await _context.SaveChangesAsync();
}
catch (DbUpdateConcurrencyException)
{
if (!EducationItemExists(id))
{
return(NotFound());
}
else
{
throw;
}
}
return(NoContent());
}
private void displayTertiaryEducation(EducationItem item)
{
selectedTertiaryEdu = item;
tbSchoolNameTertiary.Text = item._EDU_SCHOOL_NAME;
tbSchoolAddressTertiary.Text = item._EDU_SCHOOL_ADDRESS;
tbDegreeTertiary.Text = item._EDU_DEGREE_EARNED;
dpEduTertiaryDate.SelectedDate = DateTime.Parse(item._EDU_DATE_GRADUATED);
}
private void displayDoctoralEducation(EducationItem item)
{
selectedDoctoralEdu = item;
tbSchoolNameDoctoral.Text = item._EDU_SCHOOL_NAME;
tbSchoolAddressDoctoral.Text = item._EDU_SCHOOL_ADDRESS;
tbDegreeDoctoral.Text = item._EDU_DEGREE_EARNED;
dpEduDoctoralDate.SelectedDate = DateTime.Parse(item._EDU_DATE_GRADUATED);
}
protected void UpdateLocales(EducationItem entity, XElement xElement)
{
var xName = xElement.Element("Name");
foreach (var locale in xName.Descendants("Locale"))
{
var value = locale.Element("Value").Value;
int languageId = _languageWebApi.GetAll().GetAwaiter().GetResult().FirstOrDefault(x => x.UniqueSeoCode == locale.Attribute("Language").Value).Id;
_localizedEntityHelperService.SaveLocalizedValue(entity,
x => x.Name,
value,
languageId);
}
var xPeriod = xElement.Element("Period");
foreach (var locale in xPeriod.Descendants("Locale"))
{
var value = locale.Element("Value").Value;
int languageId = _languageWebApi.GetAll().GetAwaiter().GetResult().FirstOrDefault(x => x.UniqueSeoCode == locale.Attribute("Language").Value).Id;
_localizedEntityHelperService.SaveLocalizedValue(entity,
x => x.Period,
value,
languageId);
}
var xPlace = xElement.Element("Place");
if (xPlace != null)
{
foreach (var locale in xPlace.Descendants("Locale"))
{
var value = locale.Element("Value").Value;
int languageId = _languageWebApi.GetAll().GetAwaiter().GetResult().FirstOrDefault(x => x.UniqueSeoCode == locale.Attribute("Language").Value).Id;
_localizedEntityHelperService.SaveLocalizedValue(entity,
x => x.Place,
value,
languageId);
}
}
var xDescription = xElement.Element("Description");
if (xDescription != null)
{
foreach (var locale in xDescription.Descendants("Locale"))
{
var value = locale.Element("Value").Value;
int languageId = _languageWebApi.GetAll().GetAwaiter().GetResult().FirstOrDefault(x => x.UniqueSeoCode == locale.Attribute("Language").Value).Id;
_localizedEntityHelperService.SaveLocalizedValue(entity,
x => x.Description,
value,
languageId);
}
}
}
private void CbVocationalCollect_SelectionChanged(object sender, SelectionChangedEventArgs e)
{
if (cbVocationalCollect.SelectedIndex != -1)
{
var item = cbVocationalCollect.SelectedItem as EducationItem;
selectedVocationalEdu = item;
ViewSelectedEdu();
hasSelectedEdu = true;
ChangeVocBtnIcon();
}
}
public EducationItemsResult LoadDefaults()
{
EducationItemsResult returnResult = new EducationItemsResult();
bool ok = false;
EducationItemsResult result = this.GetEducationItems("", "", EducationItemType.Unknown, 0, 0, EducationItemSort.Type);
if (result.Success)
{
if (result.EducationItems == null)
{
ok = true;
}
else if (result.EducationItems.Count == 0)
{
ok = true;
}
}
if (ok)
{
AntepartumEducationValueSet valueSet = new AntepartumEducationValueSet();
foreach (ValueSetItem item in valueSet.Items)
{
// public enum CodingSystem {None, Loinc, SnomedCT}
CodingSystem[] translation = new CodingSystem[] { CodingSystem.None, CodingSystem.Loinc, CodingSystem.SnomedCT };
EducationItem edItem = new EducationItem();
edItem.Description = item.ItemName;
edItem.Category = item.Category;
edItem.Code = item.Code;
edItem.CodingSystem = translation[(int)item.CodeSystem];
edItem.ItemType = EducationItemType.DiscussionTopic;
IenResult saveResult = this.SaveEducationItem(edItem);
returnResult.SetResult(saveResult.Success, saveResult.Message);
if (!saveResult.Success)
{
break;
}
}
}
return(returnResult);
}
private EducationItem ReadEducation(SqlDataReader reader)
{
EducationItem education = new EducationItem();
education.EducationGUID = new Guid(reader["EducationGUID"].ToString());
education.SchoolName = reader["SchoolName"].ToString();
education.DegreeName = reader["DegreeName"].ToString();
education.IsGraduated = (bool)(reader["IsGraduated"]);
education.EducationHours = (int)(reader["EducationHours"]);
education.GraduatedDate = reader["GraduatedDate"].ToString();
education.ConcentrationName = reader["ConcentrationName"].ToString();
return(education);
}
private DsioEducationItem GetDsioItem(EducationItem item)
{
DsioEducationItem returnItem = new DsioEducationItem()
{
Ien = item.Ien,
Description = item.Description,
Category = item.Category,
Url = item.Url,
Code = item.Code
};
returnItem.ItemType = GetDsioItemType(item.ItemType);
returnItem.CodeSystem = GetDsioCodeSystem(item.CodingSystem);
return(returnItem);
}
private EducationItem GetItem(DsioEducationItem dsioItem)
{
EducationItem returnItem = new EducationItem()
{
Ien = dsioItem.Ien,
Description = dsioItem.Description,
Category = dsioItem.Category,
Url = dsioItem.Url,
Code = dsioItem.Code
};
returnItem.ItemType = GetItemType(dsioItem.ItemType);
returnItem.CodingSystem = GetCodingSystem(dsioItem.CodeSystem);
return(returnItem);
}
private void OnDescriptionOpen(EducationItem item)
{
current3Dmodel = item.Model;
itemsScreen.SetActive(false);
descriptionScreen.SetActive(true);
infoContent.text = String.Empty;
foreach (Transform child in content3D.transform)
{
Destroy(child.gameObject);
}
header.text = item.Title;
infoContent.text = item.Description;
var it = Instantiate(item.Model);
it.transform.SetParent(content3D.transform, false);
it.SetActive(true);
}
public PatientEducationItemsResult GetPatientItems(string patientDfn, string ien, DateTime fromDate, DateTime toDate, EducationItemType itemType, int page, int itemsPerPage)
{
PatientEducationItemsResult result = new PatientEducationItemsResult();
if (this.broker != null)
{
DsioGetPatientEducationCommand command = new DsioGetPatientEducationCommand(this.broker);
string dsioItemType = GetDsioItemType(itemType);
string fmFromDate = Util.GetFileManDate(fromDate);
string fmToDate = Util.GetFileManDate(toDate);
command.AddCommandArguments(patientDfn, ien, fmFromDate, fmToDate, dsioItemType, page, itemsPerPage);
RpcResponse response = command.Execute();
result.SetResult(response.Status == RpcResponseStatus.Success, response.InformationalMessage);
if (result.Success)
{
if (command.Items != null)
{
if (command.Items.Count > 0)
{
foreach (DsioPatientEducationItem dsioItem in command.Items)
{
EducationItem item = GetItem(dsioItem);
PatientEducationItem patItem = new PatientEducationItem(item);
patItem.CompletedOn = Util.GetDateTime(dsioItem.CompletedOn);
patItem.CompletedBy = dsioItem.CompletedBy;
result.Items.Add(patItem);
}
result.TotalResults = command.TotalResults;
}
}
}
}
return(result);
}
public ActionResult Detail(Guid id, string resumeGUID)
{
try
{
if (resumeGUID == null || string.IsNullOrWhiteSpace(resumeGUID))
{
resumeGUID = "6257B7B5-C4D0-4D00-ACB4-350A95861B7F";
}
var viewModel = new EducationDetailsViewModel();
Repository _repositoryMain = new Repository(_connectionString);
EducationRepository _repository = new EducationRepository(_connectionString);
Applicant applicant = _repositoryMain.GetApplicant(resumeGUID);
EducationItem education = _repository.GetEducationDetails(resumeGUID, id);
List <MinorItem> minorList = _repository.GetMinorList(id);
if (education.IsGraduated == true)
{
viewModel.Graduated = "Graduated";
}
else
{
viewModel.Graduated = "Did not Graduate";
}
viewModel.Title = "Richard M. Cano Resume";
viewModel.Applicant = applicant;
viewModel.Education = education;
viewModel.MinorList = minorList;
viewModel.Applicant = applicant;
return(View(viewModel));
}
catch (InvalidCastException e)
{
throw (e);
//return View("Error");
}
}
public EducationItem GetEducationDetails(string resumeGUID, Guid educationGUID)
{
EducationItem education = new EducationItem();
SqlConnection con = new SqlConnection(_connectionString);
SqlCommand cmd = new SqlCommand();
SqlDataReader reader;
cmd.CommandText = "Resume_GetEducationDetails";
cmd.CommandType = CommandType.StoredProcedure;
cmd.Connection = con;
cmd.Parameters.AddWithValue("@ResumeGUID", resumeGUID);
cmd.Parameters.AddWithValue("@EducationGUID", educationGUID);
if (con != null && con.State == ConnectionState.Closed)
{
con.Open();
}
else
{
education = null;
return(education);
}
reader = cmd.ExecuteReader();
if (reader.HasRows)
{
while (reader.Read())
{
education = ReadEducation(reader);
}
}
con.Close();
return(education);
}
protected void UpdateLocales(EducationItem entity, EducationItemModel model)
{
foreach (var localized in model.Locales)
{
_localizedEnitityHelperService.SaveLocalizedValue(entity,
x => x.Name,
localized.Name,
localized.LanguageId);
_localizedEnitityHelperService.SaveLocalizedValue(entity,
x => x.Place,
localized.Place,
localized.LanguageId);
_localizedEnitityHelperService.SaveLocalizedValue(entity,
x => x.Period,
localized.Period,
localized.LanguageId);
_localizedEnitityHelperService.SaveLocalizedValue(entity,
x => x.Description,
localized.Description,
localized.LanguageId);
}
}
public EducationItemsResult GetEducationItems(string ien, string category, EducationItemType itemType, int page, int pageSize, EducationItemSort sort)
{
EducationItemsResult result = new EducationItemsResult();
if (this.broker != null)
{
DsioGetEducationItemsCommand command = new DsioGetEducationItemsCommand(this.broker);
string dsioItemType = GetDsioItemType(itemType);
command.AddCommandArguments(ien, category, dsioItemType, page, pageSize, (int)sort);
RpcResponse response = command.Execute();
result.SetResult(response.Status == RpcResponseStatus.Success, response.InformationalMessage);
if (result.Success)
{
if (command.EducationItems != null)
{
if (command.EducationItems.Count > 0)
{
foreach (DsioEducationItem dsioItem in command.EducationItems)
{
EducationItem item = GetItem(dsioItem);
result.EducationItems.Add(item);
}
result.TotalResults = command.TotalResults;
}
}
}
}
return(result);
}
public IenResult SaveEducationItem(EducationItem item)
{
IenResult result = new IenResult();
if (this.broker != null)
{
DsioSaveEducationItemCommand command = new DsioSaveEducationItemCommand(this.broker);
DsioEducationItem dsioItem = GetDsioItem(item);
command.AddCommandArguments(dsioItem);
RpcResponse response = command.Execute();
result.SetResult(response.Status == RpcResponseStatus.Success, response.InformationalMessage);
if (result.Success)
{
result.Ien = command.Ien;
}
}
return(result);
}
private void SetEduBackground(string empId)
{
EducationManager mEduManager = new EducationManager();
List <EducationItem> eduBackgroundList = new List <EducationItem>();
if (!string.IsNullOrEmpty(tbSchoolNamePrimary.Text))
{
selectedPrimaryEdu._EMP_ID = empId;
selectedPrimaryEdu._EDU_LEVEL = "Primary";
selectedPrimaryEdu._EDU_SCHOOL_NAME = tbSchoolNamePrimary.Text;
selectedPrimaryEdu._EDU_SCHOOL_ADDRESS = tbSchoolAddressPrimary.Text;
selectedPrimaryEdu._EDU_DATE_GRADUATED = dpEduPrimaryDate.Text;
eduBackgroundList.Add(selectedPrimaryEdu);
}
if (!string.IsNullOrEmpty(tbSchoolNameSecondary.Text))
{
selectedSecondaryEdu._EMP_ID = empId;
selectedSecondaryEdu._EDU_LEVEL = "Secondary";
selectedSecondaryEdu._EDU_SCHOOL_NAME = tbSchoolNameSecondary.Text;
selectedSecondaryEdu._EDU_SCHOOL_ADDRESS = tbSchoolAddressSecondary.Text;
selectedSecondaryEdu._EDU_DATE_GRADUATED = dpEduSecondaryDate.Text;
eduBackgroundList.Add(selectedSecondaryEdu);
}
if (!string.IsNullOrEmpty(tbSchoolNameTertiary.Text))
{
selectedTertiaryEdu._EMP_ID = empId;
selectedTertiaryEdu._EDU_LEVEL = "Tertiary";
selectedTertiaryEdu._EDU_SCHOOL_NAME = tbSchoolNameTertiary.Text;
selectedTertiaryEdu._EDU_SCHOOL_ADDRESS = tbSchoolAddressTertiary.Text;
selectedTertiaryEdu._EDU_DATE_GRADUATED = dpEduTertiaryDate.Text;
selectedTertiaryEdu._EDU_DEGREE_EARNED = tbDegreeTertiary.Text;
eduBackgroundList.Add(selectedTertiaryEdu);
}
if (!string.IsNullOrEmpty(tbSchoolNameMasteral.Text))
{
selectedMasteralEdu._EMP_ID = empId;
selectedMasteralEdu._EDU_LEVEL = "Masteral";
selectedMasteralEdu._EDU_SCHOOL_NAME = tbSchoolNameMasteral.Text;
selectedMasteralEdu._EDU_SCHOOL_ADDRESS = tbSchoolAddressMasteral.Text;
selectedMasteralEdu._EDU_DATE_GRADUATED = dpEduMasteralDate.Text;
selectedMasteralEdu._EDU_DEGREE_EARNED = tbDegreeMasteral.Text;
eduBackgroundList.Add(selectedMasteralEdu);
}
if (!string.IsNullOrEmpty(tbSchoolNameDoctoral.Text))
{
selectedDoctoralEdu._EMP_ID = empId;
selectedDoctoralEdu._EDU_LEVEL = "Doctoral";
selectedDoctoralEdu._EDU_SCHOOL_NAME = tbSchoolNameDoctoral.Text;
selectedDoctoralEdu._EDU_SCHOOL_ADDRESS = tbSchoolAddressDoctoral.Text;
selectedDoctoralEdu._EDU_DATE_GRADUATED = dpEduDoctoralDate.Text;
selectedDoctoralEdu._EDU_DEGREE_EARNED = tbDegreeDoctoral.Text;
eduBackgroundList.Add(selectedDoctoralEdu);
}
if (vocationalEduCollection.Count != 0)
{
vocationalEduCollection.Remove(selectedVocationalEdu);
foreach (var item in vocationalEduCollection)
{
eduBackgroundList.Add(item);
}
}
if (!string.IsNullOrEmpty(tbSchoolNameVocational.Text))
{
var eduItem = new EducationItem();
eduItem._EMP_ID = empId;
eduItem._EDU_LEVEL = "Vocational";
eduItem._EDU_SCHOOL_NAME = tbSchoolNameVocational.Text;
eduItem._EDU_SCHOOL_ADDRESS = tbSchoolAddressVocational.Text;
eduItem._EDU_DATE_GRADUATED = dpEduVocationalDate.Text;
eduItem._EDU_DEGREE_EARNED = tbDegreeVocational.Text;
eduBackgroundList.Add(eduItem);
}
mEduManager.DeleteEduData(empId);
foreach (var item in eduBackgroundList)
{
mEduManager.SaveEduData(item);
}
}
private void setVocationalEducations(EducationItem item)
{
item._EDU_HOLDER = "Vocational " + (vocationalEduCollection.Count + 1);
vocationalEduCollection.Add(item);
}
public static void Initialize(JustMyResumeContext context)
{
context.Database.EnsureCreated();
// Look for any users.
if (context.Users.Any())
{
return; // DB has been seeded
}
var Users = new User[]
{
new User {
FirstName = "Thomas", LastName = "Woodward", StreetAddress = "809 E. Bellville St.", City = "Marion", State = "KY", Phone = "615.517.5194", Email = "*****@*****.**"
}
};
foreach (User s in Users)
{
context.Users.Add(s);
}
context.SaveChanges();
var userId = context.Users.FirstOrDefault(item => item.LastName == "Woodward").Id;
var jobs = new Job[]
{
new JustMyResumeApi.Models.Job {
UserId = userId, Employer = "Pure Air Internet", Title = "Founder", Role = "Network Designer/Entrepreneur", StartDate = "Jan 2016", EndDate = "May 2018", Description = "<ul><li>Created business plan and pro forma financials based on demographic and statistical data.</li><li>Designed a Fixed Wireless network to service all of western Kentucky.</li><li>Interfaced with vendors and government funding sources.</li></ul>", SortOrder = 1
},
new JustMyResumeApi.Models.Job {
UserId = userId, Employer = "Data Dimensions Corp.", Title = "Systems Analyst III", Role = "Full Stack Developer", StartDate = "Aug 2002", EndDate = "Oct 2015", Description = "<ul><li>Designed, developed, maintained, and migrated internal accounting package responsible for employee incentive-based pay calculation, AR, AP, and Profit/Loss. Used Windows Forms, VB.NET, SQL Server.</li><li>Implemented and maintained intranet end-to-end workflow tracking that enabled piece-incentive pay resulting in 200% productivity increase. Used IIS, C#, ASP.NET, SQL Server.</li><li>Designed, implemented, and maintained package tracking portal for clients as an internet solution with nearly 1,000 registered users. Used IIS, C#, ASP.NET, SQL Server.</li><li>Created a REST service to interface with an Android application I built to provide tablet access to the production rate system.</li></ul>", SortOrder = 2
},
new JustMyResumeApi.Models.Job {
UserId = userId, Employer = "Investment Scorecard", Title = "Programmer Analyst", Role = "Full Stack Microsoft Developer", StartDate = "Apr 2001", EndDate = "Mar 2003", Description = "<ul><li>Maintained a classic ASP web application with thousands of users for investment performance reporting. Used ASP, DCOM, SQL Server, IIS, Active Directory.</li><li>Replaced Active Directory with SQL Server user authentication resulting in greater features and vastly improved scalability.</li><li>Implemented advanced financial analysis and charting feature set which resulted in large new sales.</li></ul>", SortOrder = 3
},
new JustMyResumeApi.Models.Job {
UserId = userId, Employer = "Progressive Design Software (Insync, Inc.)", Title = "Business Partner", Role = "Java Developer", StartDate = "Dec 1999", EndDate = "Apr 2001", Description = "<ul><li>Designed n-tiered platform to support web and internet applications.</li><li>Designed and coded CASE tool to automate the majority of application creation.</li><li>Interfaced with clients and coded a large n-tiered, object-oriented development effort in Visual Basic 6 and SQL Server to replace a legacy system.</li></ul>", SortOrder = 4
},
new JustMyResumeApi.Models.Job {
UserId = userId, Employer = "United Systems and Software", Title = "Programmer Analyst", Role = "Full Stack Microsoft Developer", StartDate = "May 1997", EndDate = "Dec 1999", Description = "<ul><li>Designed, built and maintained multiple object-oriented Visual Basic/SQL Server Line-of-business accounting solutions.</li><li>Designed an n-tiered object-oriented infrastructure and architecture which served as the basis for re-development of the company’s entire product line. Trained and assisted other developers in the use of that architecture.</li></ul>", SortOrder = 5
}
};
foreach (JustMyResumeApi.Models.Job job in jobs)
{
context.Jobs.Add(job);
}
context.SaveChanges();
var skillCategories = new SkillCategory[] {
new SkillCategory {
Name = "Languages", SortOrder = 1
},
new SkillCategory {
Name = "APIs", SortOrder = 2
},
new SkillCategory {
Name = "Databases", SortOrder = 3
}
};
foreach (SkillCategory skillCategory in skillCategories)
{
context.SkillCategories.Add(skillCategory);
}
context.SaveChanges();
long lang = context.SkillCategories.FirstOrDefault(item => item.Name.Equals("Languages")).Id;
long api = context.SkillCategories.FirstOrDefault(item => item.Name.Equals("APIs")).Id;
long db = context.SkillCategories.FirstOrDefault(item => item.Name.Equals("Databases")).Id;
var techSkills = new TechSkill[] {
new TechSkill {
UserId = userId, SkillCategoryId = lang, Name = "C#", SkillLevel = "Expert", SortOrder = 1
},
new TechSkill {
UserId = userId, SkillCategoryId = lang, Name = "Java", SkillLevel = "Proficient", SortOrder = 2
},
new TechSkill {
UserId = userId, SkillCategoryId = lang, Name = "Visual Basic/VB.NET", SkillLevel = "Proficient", SortOrder = 3
},
new TechSkill {
UserId = userId, SkillCategoryId = lang, Name = "Javascript", SkillLevel = "Proficient", SortOrder = 4
},
new TechSkill {
UserId = userId, SkillCategoryId = lang, Name = "SQL", SkillLevel = "Expert", SortOrder = 5
},
new TechSkill {
UserId = userId, SkillCategoryId = lang, Name = "HTML", SkillLevel = "Proficient", SortOrder = 6
},
new TechSkill {
UserId = userId, SkillCategoryId = lang, Name = "CSS", SkillLevel = "Proficient", SortOrder = 7
},
new TechSkill {
UserId = userId, SkillCategoryId = lang, Name = "TypeScript", SkillLevel = "Proficient", SortOrder = 8
},
new TechSkill {
UserId = userId, SkillCategoryId = api, Name = "ASP.NET MVC", SkillLevel = "Proficient", SortOrder = 10
},
new TechSkill {
UserId = userId, SkillCategoryId = api, Name = "ASP.NET Core 2.2", SkillLevel = "Proficient", SortOrder = 10
},
new TechSkill {
UserId = userId, SkillCategoryId = api, Name = "ASP.NET Core Web API", SkillLevel = "Proficient", SortOrder = 10
},
new TechSkill {
UserId = userId, SkillCategoryId = api, Name = "Windows Forms", SkillLevel = "Expert", SortOrder = 12
},
new TechSkill {
UserId = userId, SkillCategoryId = api, Name = "ASP.NET Web Forms", SkillLevel = "Expert", SortOrder = 12
},
new TechSkill {
UserId = userId, SkillCategoryId = api, Name = "Angular 7", SkillLevel = "Proficient", SortOrder = 13
},
new TechSkill {
UserId = userId, SkillCategoryId = api, Name = "Angular Material", SkillLevel = "Proficient", SortOrder = 13
},
new TechSkill {
UserId = userId, SkillCategoryId = api, Name = "AJAX", SkillLevel = "Proficient", SortOrder = 14
},
new TechSkill {
UserId = userId, SkillCategoryId = api, Name = "JQuery", SkillLevel = "Proficient", SortOrder = 15
},
new TechSkill {
UserId = userId, SkillCategoryId = api, Name = "Entity Framework", SkillLevel = "Proficient", SortOrder = 16
},
new TechSkill {
UserId = userId, SkillCategoryId = api, Name = "Entity Framework Core", SkillLevel = "Proficient", SortOrder = 16
},
new TechSkill {
UserId = userId, SkillCategoryId = api, Name = "REST Services", SkillLevel = "Expert", SortOrder = 17
},
new TechSkill {
UserId = userId, SkillCategoryId = api, Name = "Android", SkillLevel = "Entry", SortOrder = 18
},
new TechSkill {
UserId = userId, SkillCategoryId = api, Name = "LINQ", SkillLevel = "Proficient", SortOrder = 19
},
new TechSkill {
UserId = userId, SkillCategoryId = api, Name = "JSON", SkillLevel = "Proficient", SortOrder = 23
},
new TechSkill {
UserId = userId, SkillCategoryId = api, Name = "JSON Web Tokens", SkillLevel = "Proficient", SortOrder = 27
},
new TechSkill {
UserId = userId, SkillCategoryId = api, Name = "Auth0", SkillLevel = "Entry", SortOrder = 28
},
new TechSkill {
UserId = userId, SkillCategoryId = db, Name = "Microsoft SQL Server", SkillLevel = "Expert", SortOrder = 24
},
new TechSkill {
UserId = userId, SkillCategoryId = db, Name = "MySQL", SkillLevel = "Proficient", SortOrder = 25
},
new TechSkill {
UserId = userId, SkillCategoryId = db, Name = "Oracle", SkillLevel = "Entry", SortOrder = 26
}
};
foreach (var item in techSkills)
{
context.TechSkills.Add(item);
}
context.SaveChanges();
var educationItems = new EducationItem[] {
new EducationItem {
UserId = userId, Description = "Harvard University", Degree = "One year, studied economics and some computer science.", SortOrder = 1
},
new EducationItem {
UserId = userId, Description = "Vanderbilt University School of Engineering", Degree = "One and a half years, completed computer science curriculum but not degree requirements.", SortOrder = 2
}
};
foreach (var item in educationItems)
{
context.EducationItems.Add(item);
}
context.SaveChanges();
var projects = new Project[] {
new Project {
UserId = userId, Name = "Dynamic Resume", Description = "A dynamically built resume application capable of hosting multiple resumes. The front end is built using Angular 7 and Angular 7 Material. The business object and data service tier is built using C# for .Net Core 2.2. The business and data tiers employ Wep API and Entity Framework Core. All content is stored in a database hosted in Microsoft SQL Server and accessed asynchronously for scalability.", DemoUrl = "https://www.justmyresume.com", GitHubUrl = "https://github.com/inputoverload/JustMyResumeWeb and https://github.com/inputoverload/JustMyResumeAPI", SortOrder = 1
}
};
foreach (var item in projects)
{
context.Projects.Add(item);
}
context.SaveChanges();
context.LoginModels.Add(new LoginModel
{
UserName = "******",
FirstName = "John",
LastName = "Doe",
Email = "*****@*****.**",
IsAdmin = true,
Password = DBSecurity.hashPassword("def@123")
});
context.SaveChanges();
}
public void InsertEducationItem(EducationItem t)
{
_educationItemRepo.Add(t);
}
public void UpdateEducationItem(EducationItem t)
{
_unitOfWork.Complete();
}
public static EducationItem ToEntity(this EducationItemModel model, EducationItem destination)
{
return(model.MapTo(destination));
}
public void DeleteEducationItem(EducationItem t)
{
_educationItemRepo.Remove(t);
_unitOfWork.Complete();
}
private static TableRow GenerateEducationRow(EducationItem education)
{
TableRow tableRow2 = new TableRow()
{
RsidTableRowAddition = "009B2C1D", ParagraphId = "1EE453E3", TextId = "77777777"
};
TableRowProperties tableRowProperties1 = new TableRowProperties();
GridAfter gridAfter1 = new GridAfter()
{
Val = 1
};
WidthAfterTableRow widthAfterTableRow1 = new WidthAfterTableRow()
{
Width = "360", Type = TableWidthUnitValues.Dxa
};
tableRowProperties1.Append(gridAfter1);
tableRowProperties1.Append(widthAfterTableRow1);
TableCell tableCell2 = new TableCell();
TableCellProperties tableCellProperties2 = new TableCellProperties();
TableCellWidth tableCellWidth2 = new TableCellWidth()
{
Width = "2550", Type = TableWidthUnitValues.Dxa
};
TableCellBorders tableCellBorders2 = new TableCellBorders();
TopBorder topBorder3 = new TopBorder()
{
Val = BorderValues.Single, Color = "FFFFFF", Size = (UInt32Value)0U, Space = (UInt32Value)0U
};
LeftBorder leftBorder3 = new LeftBorder()
{
Val = BorderValues.Single, Color = "FFFFFF", Size = (UInt32Value)0U, Space = (UInt32Value)0U
};
BottomBorder bottomBorder3 = new BottomBorder()
{
Val = BorderValues.Single, Color = "FFFFFF", Size = (UInt32Value)0U, Space = (UInt32Value)0U
};
RightBorder rightBorder3 = new RightBorder()
{
Val = BorderValues.Single, Color = "FFFFFF", Size = (UInt32Value)0U, Space = (UInt32Value)0U
};
tableCellBorders2.Append(topBorder3);
tableCellBorders2.Append(leftBorder3);
tableCellBorders2.Append(bottomBorder3);
tableCellBorders2.Append(rightBorder3);
tableCellProperties2.Append(tableCellWidth2);
tableCellProperties2.Append(tableCellBorders2);
Paragraph paragraph2 = new Paragraph()
{
RsidParagraphAddition = "009B2C1D", RsidRunAdditionDefault = "009E39C2", ParagraphId = "575EC095", TextId = "74BCD266"
};
Run run6 = new Run()
{
RsidRunAddition = "0007641E"
};
RunProperties runProperties6 = new RunProperties();
FontSize fontSize6 = new FontSize()
{
Val = "22"
};
FontSizeComplexScript fontSizeComplexScript6 = new FontSizeComplexScript()
{
Val = "22"
};
runProperties6.Append(fontSize6);
runProperties6.Append(fontSizeComplexScript6);
Text text6 = new Text();
text6.Text = education.StartingYear + " - " + education.EndingYear;
run6.Append(runProperties6);
run6.Append(text6);
paragraph2.Append(run6);
tableCell2.Append(tableCellProperties2);
tableCell2.Append(paragraph2);
TableCell tableCell3 = new TableCell();
TableCellProperties tableCellProperties3 = new TableCellProperties();
TableCellWidth tableCellWidth3 = new TableCellWidth()
{
Width = "5700", Type = TableWidthUnitValues.Dxa
};
TableCellBorders tableCellBorders3 = new TableCellBorders();
TopBorder topBorder4 = new TopBorder()
{
Val = BorderValues.Single, Color = "FFFFFF", Size = (UInt32Value)0U, Space = (UInt32Value)0U
};
LeftBorder leftBorder4 = new LeftBorder()
{
Val = BorderValues.Single, Color = "000000", Size = (UInt32Value)1U, Space = (UInt32Value)0U
};
BottomBorder bottomBorder4 = new BottomBorder()
{
Val = BorderValues.Single, Color = "FFFFFF", Size = (UInt32Value)0U, Space = (UInt32Value)0U
};
RightBorder rightBorder4 = new RightBorder()
{
Val = BorderValues.Single, Color = "FFFFFF", Size = (UInt32Value)0U, Space = (UInt32Value)0U
};
tableCellBorders3.Append(topBorder4);
tableCellBorders3.Append(leftBorder4);
tableCellBorders3.Append(bottomBorder4);
tableCellBorders3.Append(rightBorder4);
tableCellProperties3.Append(tableCellWidth3);
tableCellProperties3.Append(tableCellBorders3);
Paragraph paragraph3 = new Paragraph()
{
RsidParagraphAddition = "009B2C1D", RsidRunAdditionDefault = "009E39C2", ParagraphId = "690EE799", TextId = "77777777"
};
ParagraphProperties paragraphProperties1 = new ParagraphProperties();
SpacingBetweenLines spacingBetweenLines1 = new SpacingBetweenLines()
{
After = "100", Line = "240", LineRule = LineSpacingRuleValues.Auto
};
Indentation indentation1 = new Indentation()
{
Left = "144"
};
paragraphProperties1.Append(spacingBetweenLines1);
paragraphProperties1.Append(indentation1);
Run run7 = new Run();
RunProperties runProperties7 = new RunProperties();
Bold bold2 = new Bold();
FontSize fontSize7 = new FontSize()
{
Val = "22"
};
FontSizeComplexScript fontSizeComplexScript7 = new FontSizeComplexScript()
{
Val = "22"
};
runProperties7.Append(bold2);
runProperties7.Append(fontSize7);
runProperties7.Append(fontSizeComplexScript7);
Text text7 = new Text()
{
Space = SpaceProcessingModeValues.Preserve
};
text7.Text = education.University?.ToUpper();
run7.Append(runProperties7);
run7.Append(text7);
paragraph3.Append(paragraphProperties1);
paragraph3.Append(run7);
Paragraph paragraph4 = new Paragraph()
{
RsidParagraphAddition = "009B2C1D", RsidRunAdditionDefault = "009E39C2", ParagraphId = "7BD7BFC1", TextId = "77777777"
};
ParagraphProperties paragraphProperties2 = new ParagraphProperties();
SpacingBetweenLines spacingBetweenLines2 = new SpacingBetweenLines()
{
After = "100", Line = "240", LineRule = LineSpacingRuleValues.Auto
};
Indentation indentation2 = new Indentation()
{
Left = "144"
};
paragraphProperties2.Append(spacingBetweenLines2);
paragraphProperties2.Append(indentation2);
Run run8 = new Run();
RunProperties runProperties8 = new RunProperties();
FontSize fontSize8 = new FontSize()
{
Val = "22"
};
FontSizeComplexScript fontSizeComplexScript8 = new FontSizeComplexScript()
{
Val = "22"
};
runProperties8.Append(fontSize8);
runProperties8.Append(fontSizeComplexScript8);
Text text8 = new Text();
text8.Text = education.Degree;
run8.Append(runProperties8);
run8.Append(text8);
paragraph4.Append(paragraphProperties2);
paragraph4.Append(run8);
tableCell3.Append(tableCellProperties3);
tableCell3.Append(paragraph3);
tableCell3.Append(paragraph4);
tableRow2.Append(tableRowProperties1);
tableRow2.Append(tableCell2);
tableRow2.Append(tableCell3);
return(tableRow2);
}
public EducationDetailsViewModel()
{
MinorList = new List <MinorItem>();
Applicant = new Applicant();
Education = new EducationItem();
}
