public void AddSkillTo(Task task, int skillID) { var taskSkill = new TaskSkill { TaskID = task.ID, SkillID = skillID }; task.TaskSkills.Add(taskSkill); }
public static void Initialize(ResumeContext context) { context.Database.EnsureCreated(); if (context.Experiences.Any()) { return; } // make a stronger check here? ///create and save a group of skills (bottom level) Skill csharp = new Skill { Name = "C#", Description = "Web application development in C# (front-end and back-end)" }; Skill dotnet = new Skill { Name = "ASP.NET Core", Description = "Development in ASP.NET Core using Web API and MVC patterns" }; Skill sql = new Skill { Name = "SQL", Description = "Design and implementation of a back-end SQL database in Visual Studio" }; Skill js = new Skill { Name = "JavaScript", Description = "Front-end client development with enhancements, includes AngularJS, JQuery, and AJAX" }; Skill python = new Skill { Name = "Python", Description = "Data mining with Numpy, Scikit-Learn, etc." }; Skill frontend = new Skill { Name = "HTML / CSS", Description = "Front-end client development, includes BootStrap" }; context.Skills.AddRange(new Skill[] { csharp, dotnet, sql, js, python, frontend }); context.SaveChanges(); //create and save experiences / education (top layer) Experience softwareDevIntern = new Experience { Institution = "Hennepin County Government", Title = "Software Development Intern", Start = new DateTime(2017, 5, 1), End = new DateTime(2017, 11, 1), Tasks = new List <Task>() }; // responsibility list must be initialized to add to later Experience dataArchitectureIntern = new Experience { Institution = "Hennepin County Government", Title = "Data Architecture Intern", Start = new DateTime(2017, 11, 1), Tasks = new List <Task>() }; context.Experiences.AddRange(new Experience[] { softwareDevIntern, dataArchitectureIntern }); context.SaveChanges(); Education undergrad = new Education { Institution = "U of MN- Twin Cities", Title = "Computer Science", Degree = "Bachelor of Science", Start = new DateTime(2014, 9, 1), Tasks = new List <Task>() }; context.Education.Add(undergrad); context.SaveChanges(); Activity vhlab = new Activity { Institution = "U of MN- Twin Cities", Title = "Volunteer", Group = "Visible Heart Medical Research Lab", Start = new DateTime(2016, 3, 1), Tasks = new List <Task>() }; context.Activities.Add(vhlab); context.SaveChanges(); //create and save tasks (got by experiences/education) Task t1 = new Task { Description = "Write code to build and customize a REST client; Keep client in sync with API changes", ExperienceID = 1, TSlist = new List <TaskSkill>() }; // initialize skills to be added to later Task t2 = new Task { Description = "Meet with product owners weekly to report progress and refine product designs", ExperienceID = 1, TSlist = new List <TaskSkill>() }; Task t3 = new Task { Description = "Design and implement a SQL database in Visual Studio", ExperienceID = 2, TSlist = new List <TaskSkill>() }; Task t4 = new Task { Description = "Design and implement a Web API to interact with a SQL database", ExperienceID = 2, TSlist = new List <TaskSkill>() }; Task t5 = new Task { Description = "Design and implement a REST client to access a database via an API", ExperienceID = 2, TSlist = new List <TaskSkill>() }; Task t6 = new Task { Description = "Use maching learning to prescribe and evaluate the emergency response to Hurricane Harvey", ExperienceID = 3, TSlist = new List <TaskSkill>() }; Task t7 = new Task { Description = "Use Artificial Intelligence to enhance security cameras with audio emotional sensors", ExperienceID = 3, TSlist = new List <TaskSkill>() }; Task t8 = new Task { Description = "Assist in making image segmentation network; segmented images significantly speed up 3D printing", ExperienceID = 4, TSlist = new List <TaskSkill>() }; Task t9 = new Task { Description = "Create web service to manage experiments and their data", ExperienceID = 4, TSlist = new List <TaskSkill>() }; context.Tasks.AddRange(new Task[] { t1, t2, t3, t4, t5, t6, t7, t8, t9 }); context.SaveChanges(); //create task/skill bridges TaskSkill ts1 = new TaskSkill { TaskID = 1, SkillID = 4 }; TaskSkill ts2 = new TaskSkill { TaskID = 1, SkillID = 6 }; TaskSkill ts3 = new TaskSkill { TaskID = 3, SkillID = 3 }; TaskSkill ts4 = new TaskSkill { TaskID = 4, SkillID = 1 }; TaskSkill ts5 = new TaskSkill { TaskID = 4, SkillID = 2 }; TaskSkill ts6 = new TaskSkill { TaskID = 4, SkillID = 3 }; TaskSkill ts7 = new TaskSkill { TaskID = 5, SkillID = 1 }; TaskSkill ts8 = new TaskSkill { TaskID = 5, SkillID = 2 }; TaskSkill ts9 = new TaskSkill { TaskID = 5, SkillID = 6 }; TaskSkill ts10 = new TaskSkill { TaskID = 6, SkillID = 5 }; TaskSkill ts11 = new TaskSkill { TaskID = 7, SkillID = 5 }; TaskSkill ts12 = new TaskSkill { TaskID = 8, SkillID = 5 }; TaskSkill ts13 = new TaskSkill { TaskID = 9, SkillID = 4 }; TaskSkill ts14 = new TaskSkill { TaskID = 9, SkillID = 6 }; context.TSlist.AddRange(new TaskSkill[] { ts1, ts2, ts3, ts4, ts5, ts6, ts7, ts8, ts9, ts10, ts11, ts12, ts13, ts14 }); context.SaveChanges(); }