public async Task <ActionResult <TechSkill> > PostTechSkill(TechSkill techSkill) { _context.TechSkills.Add(techSkill); await _context.SaveChangesAsync(); return(CreatedAtAction("GetTechSkill", new { id = techSkill.Id }, techSkill)); }
public async Task <IActionResult> PutTechSkill(long id, TechSkill techSkill) { if (id != techSkill.Id) { return(BadRequest()); } _context.Entry(techSkill).State = EntityState.Modified; try { await _context.SaveChangesAsync(); } catch (DbUpdateConcurrencyException) { if (!TechSkillExists(id)) { return(NotFound()); } else { throw; } } return(NoContent()); }
private void MappingSkills(ICollection <CandidateSecondarySkill> candidateSkills) { foreach (var secSkill in candidateSkills) { var techSkill = new TechSkill { Id = secSkill.TechSkill }; unitOfWork.AttachToContext(techSkill); secSkill.TechSkill1 = techSkill; } }
private void MappingPrimarySkill(CandidatePrimarySkill skill) { if (skill == null) { return; } var techSkill = new TechSkill { Id = skill.TechSkill }; unitOfWork.AttachToContext(techSkill); skill.TechSkill1 = techSkill; }
public IActionResult Put(int id, [FromBody] TechSkill techskill) { var entity = _expressoDbContext.TechSkill.Find(id); if (entity == null) { return(NotFound("No Record Found")); } else { entity.Name = techskill.Name; entity.Proficiency = techskill.Proficiency; _expressoDbContext.SaveChanges(); return(Ok("Record Updated Successfully......")); } }
private async Task FillWithData(CancellationToken cancellationToken) { bool Done = false; IReliableDictionary <int, List <TechSkill> > dictionary = await StateManager.GetOrAddAsync <IReliableDictionary <int, List <TechSkill> > >(SkillDictionaryName); //fill with sample data while (!Done) { try { // Create a new Transaction object for this partition using (ITransaction tx = base.StateManager.CreateTransaction()) { IAsyncEnumerable <KeyValuePair <int, List <TechSkill> > > SkillEnum = (await dictionary.CreateEnumerableAsync(tx)); TechSkill tsk = new TechSkill { ResourceId = 1, Name = "C#", Level = Models.Domain.Level.Expert, Notes = string.Empty }; List <TechSkill> skills = new List <TechSkill>(); skills.Add(tsk); await dictionary.AddAsync(tx, tsk.ResourceId, skills); // CommitAsync sends Commit record to log & secondary replicas // After quorum responds, all locks released await tx.CommitAsync(); } // If CommitAsync not called, Dispose sends Abort // record to log & all locks released Done = true; } catch (TimeoutException) { Done = false; await Task.Delay(100, cancellationToken); } } }
private void AttachNewSkills(Vacancy v, TechSkillModel primarySkill, ICollection <TechSkillModel> secondarySkills) { if (primarySkill != null) { var pTechSkill = new TechSkill { Id = primarySkill.Id }; unitOfWork.AttachToContext <TechSkill>(pTechSkill); v.VacancyPrimarySkill = new VacancyPrimarySkill { TechSkill1 = pTechSkill, Level = primarySkill.Level }; } if (secondarySkills != null) { foreach (var skill in secondarySkills) { var sTechSkill = new TechSkill { Id = skill.Id }; unitOfWork.AttachToContext <TechSkill>(sTechSkill); v.VacancySecondarySkills.Add(new VacancySecondarySkill { TechSkill1 = sTechSkill, Level = skill.Level }); } } }
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 IActionResult Post([FromBody] TechSkill techskill) { _expressoDbContext.TechSkill.Add(techskill); _expressoDbContext.SaveChanges(); return(StatusCode(StatusCodes.Status201Created)); }