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