public async Task <ActionResult <SeniorityLevel> > PostSeniorityLevel(SeniorityLevel seniorityLevel)
{
_context.SeniorityLevels.Add(seniorityLevel);
await _context.SaveChangesAsync();
return(CreatedAtAction("GetSeniorityLevel", new { id = seniorityLevel.Id }, seniorityLevel));
}
public Agent(string name, SeniorityLevel seniorityLevel)
{
Name = name;
SeniorityLevel = seniorityLevel;
WorkCapacity = (int)(10 * SeniorityMultiplier.GetSeniorityMultiplier(seniorityLevel));
WorkList = new List <string>(WorkCapacity);
}
public async Task <IActionResult> PutSeniorityLevel(long id, SeniorityLevel seniorityLevel)
{
if (id != seniorityLevel.Id)
{
return(BadRequest());
}
_context.Entry(seniorityLevel).State = EntityState.Modified;
try
{
await _context.SaveChangesAsync();
}
catch (DbUpdateConcurrencyException)
{
if (!SeniorityLevelExists(id))
{
return(NotFound());
}
else
{
throw;
}
}
return(NoContent());
}
public JsonResult GetProcessMonthlyMetrics()
{
SeniorityLevel seniority = SeniorityLevel.Entry;
bool seniorityExists = false;
if (Request.Form["seniority"] != string.Empty)
{
seniority = (SeniorityLevel)int.Parse(Request.Form["seniority"]);
seniorityExists = true;
}
string technology = Request.Form["technology"];
int month = int.Parse(Request.Form["month"]);
int year = int.Parse(Request.Form["year"]);
DateTime start = new DateTime(year, month, 1);
DateTime end = new DateTime(year, month, DateTime.DaysInMonth(year, month));
int acceptsNumber = 0, processesNumber = 0;
using (HFContext hfdb = new HFContext())
{
ICollection <Process> processes = (from proc in hfdb.Processes
where ((start <= proc.StartDate && end >= proc.StartDate) ||
(start >= proc.StartDate && start <= proc.EndDate)) &&
((seniorityExists && proc.Seniority == seniority) || proc.Technologies.Contains(technology))
select proc).ToList();
processesNumber = processes.Count;
foreach (Process proc in processes)
{
foreach (ProcessInstance pIns in proc.Instances)
{
if (pIns.CurrentPhase == Phase.Acceptance_Phase)
{
++acceptsNumber;
}
}
}
}
var data = new
{
acceptsNumber = acceptsNumber,
processesNumber = processesNumber
};
return(Json(data));
}
public static double GetSeniorityMultiplier(SeniorityLevel seniorityLevel)
{
return(Multipliers[seniorityLevel]);
}
public static void Initialize(IApplicationContext context)
{
if (!context.EnsureCreated())
{
return; //db was already created or error occurred
}
var confirmed = new UserStatusType
{
Name = "Confirmed",
Description = "The user has confirmed their email is active and is ready for opportunities.",
CanApply = true
};
var userStatusTypes = new List <UserStatusType>
{
new UserStatusType
{
Name = "Submitted",
Description = "The user has signed up and needs to confirm their email is active and receiving messages from the system."
},
confirmed,
new UserStatusType
{
Name = "Banned",
Description = "The user has been banned from any opportunities."
}
};
context.UserStatusTypes.AddRange(userStatusTypes);
context.SaveChanges();
//add user
var robsmitha = new User
{
GitHubLogin = "******",
UserStatusTypeID = confirmed.ID
};
context.Users.Add(robsmitha);
context.SaveChanges();
//add company
var gitCandidates = new Company
{
GitHubLogin = "******"
};
context.Companies.Add(gitCandidates);
context.SaveChanges();
#region Response types
var textResponse = new ResponseType
{
Name = "TextResponse",
Description = "A write in response question that renders a text input field.",
Input = "text"
};
var numberResponse = new ResponseType
{
Name = "NumberResponse",
Description = "A write in response question that renders a number input field.",
Input = "number"
};
var yesNo = new ResponseType
{
Name = "YesNo",
Description = "A yes/no question that renders two yes/mp radio buttons.",
Input = "radio"
};
context.ResponseTypes.Add(yesNo);
context.ResponseTypes.Add(numberResponse);
context.ResponseTypes.Add(textResponse);
context.SaveChanges();
#endregion
#region Validation rules
var isRequired = new ValidationRule
{
Name = "Is Required",
Description = "The field in requierd",
Key = "isRequired"
};
var minLength = new ValidationRule
{
Name = "Minimum Length",
Description = "The field has a minimum length",
Key = "minLength"
};
var maxLength = new ValidationRule
{
Name = "Maximum Length",
Description = "The field has a maximum length",
Key = "maxLength"
};
context.ValidationRules.Add(isRequired);
context.ValidationRules.Add(minLength);
context.ValidationRules.Add(maxLength);
context.SaveChanges();
#endregion
#region Yes/No test question
var yesNoQ = new Question
{
Label = "Are you authorized to work in the U.S.?",
CompanyID = gitCandidates.ID,
ResponseTypeID = yesNo.ID
};
context.Questions.Add(yesNoQ);
context.SaveChanges();
var yesNoQYes = new QuestionResponse
{
Answer = "Yes",
QuestionID = yesNoQ.ID,
DisplayOrder = 1
};
var yesNoQNo = new QuestionResponse
{
Answer = "No",
QuestionID = yesNoQ.ID,
DisplayOrder = 2
};
context.QuestionResponses.Add(yesNoQYes);
context.QuestionResponses.Add(yesNoQNo);
context.SaveChanges();
var yesNoQValidationIsRequired = new QuestionValidation
{
QuestionID = yesNoQ.ID,
ValidationRuleID = isRequired.ID,
};
context.QuestionValidations.Add(yesNoQValidationIsRequired);
context.SaveChanges();
#endregion
#region Write in test question
var numberResponseQ = new Question
{
Label = "How many years have you professionaly developed software?",
CompanyID = gitCandidates.ID,
ResponseTypeID = numberResponse.ID,
Placeholder = "Years of experience",
Minimum = 0,
Maximum = 99
};
context.Questions.Add(numberResponseQ);
context.SaveChanges();
var numberResponseQValidationIsRequired = new QuestionValidation
{
QuestionID = numberResponseQ.ID,
ValidationRuleID = isRequired.ID,
ValidationRuleValue = "true"
};
var numberResponseQValidationMaxLength = new QuestionValidation
{
QuestionID = numberResponseQ.ID,
ValidationRuleID = maxLength.ID,
ValidationRuleValue = "2"
};
context.QuestionValidations.Add(numberResponseQValidationIsRequired);
context.QuestionValidations.Add(numberResponseQValidationMaxLength);
context.SaveChanges();
#endregion
#region Add jobs
var jobApplicationStatusTypes = new List <JobApplicationStatusType>
{
new JobApplicationStatusType
{
Name = "Submitted",
Description = "The application has been submitted.",
IsActiveApplication = true
},
new JobApplicationStatusType
{
Name = "Under Review",
Description = "The application is under review.",
IsActiveApplication = true
},
new JobApplicationStatusType
{
Name = "Under Consideration",
Description = "The application is under review by the company.",
IsActiveApplication = true
},
new JobApplicationStatusType
{
Name = "Scheduling Interview",
Description = "The an interview is being schedules.",
IsActiveApplication = true
},
new JobApplicationStatusType
{
Name = "No Longer Under Consideration",
Description = "The application is no longer being reviewed."
},
new JobApplicationStatusType
{
Name = "Withdrawn",
Description = "The application has been withdrawn by the user."
}
};
context.JobApplicationStatusTypes.AddRange(jobApplicationStatusTypes);
context.SaveChanges();
var intern = new SeniorityLevel
{
Name = "Intern",
Description = "Internship level"
};
var entry = new SeniorityLevel
{
Name = "Entry",
Description = "Entry level"
};
var midLvl = new SeniorityLevel
{
Name = "Mid-level",
Description = "Middle level"
};
var seniorLvl = new SeniorityLevel
{
Name = "Senior",
Description = "Senior level"
};
var lead = new SeniorityLevel
{
Name = "Lead",
Description = "Senior level"
};
var architect = new SeniorityLevel
{
Name = "Architect",
Description = "Architect level"
};
context.SeniorityLevels.AddRange(new [] { intern, entry, midLvl, seniorLvl, lead, architect });
var fullTime = new JobType
{
Name = "Full-time",
Description = "Full-time"
};
var partTime = new JobType
{
Name = "Part-time",
Description = "Part-time"
};
var contract = new JobType
{
Name = "Contract",
Description = "Contract"
};
context.JobTypes.AddRange(new[] { fullTime, partTime, contract });
context.SaveChanges();
var postHTML = "<h4 id="summary">Job Summary</h4> <p>We develop a .NET software application implements a Domain Driven Design (DDD) pattern to help solve enterprise level problems.</p><p>We're looking for talented engineers to join our team.</p><strong>If this job sounds like you apply today!</strong>";
var fullstack = new Job
{
Name = "Full Stack Engineer",
Description = "A .NET MVC frontend and MSSQL backend",
CompanyID = gitCandidates.ID,
UserID = robsmitha.ID,
PostAt = DateTime.Now.AddMinutes(5),
PostHTML = postHTML,
AllowRemote = false,
TeamSize = "10-50 People",
MinSalary = 90000,
MaxSalary = 120000,
Travel = "No",
SeniorityLevelID = midLvl.ID,
JobTypeID = fullTime.ID,
};
var frontend = new Job
{
Name = "Front End Engineer",
Description = "A frontend in ReactJS with Bootstrap4.",
CompanyID = gitCandidates.ID,
PostAt = DateTime.Now.AddDays(-2),
UserID = robsmitha.ID,
PostHTML = postHTML,
AllowRemote = true,
TeamSize = "1-10 People",
MinSalary = 70000,
MaxSalary = 86000,
Travel = "No",
SeniorityLevelID = entry.ID,
JobTypeID = partTime.ID,
};
var senior = new Job
{
Name = "Senior Software Architect",
Description = "Senior Architect Angular frontend and CockroachDB backend",
CompanyID = gitCandidates.ID,
PostAt = DateTime.Now.AddDays(-4),
UserID = robsmitha.ID,
PostHTML = postHTML,
AllowRemote = false,
TeamSize = "50-100 People",
MinSalary = 75000,
MaxSalary = 96000,
Travel = "No",
SeniorityLevelID = seniorLvl.ID,
JobTypeID = fullTime.ID,
};
var cloud = new Job
{
Name = "Cloud Engineer",
Description = "Create and manage CI/CD pipelines and infrastructure.",
CompanyID = gitCandidates.ID,
PostAt = DateTime.Now.AddDays(-8),
UserID = robsmitha.ID,
PostHTML = postHTML,
AllowRemote = false,
TeamSize = "50-100 People",
MinSalary = 65000,
MaxSalary = 86000,
Travel = "No",
SeniorityLevelID = lead.ID,
JobTypeID = fullTime.ID,
};
var jobs = new List <Job>
{
fullstack, frontend, senior, cloud
};
context.Jobs.AddRange(jobs);
context.SaveChanges();
var frontendLocations = new List <JobLocation>
{
new JobLocation
{
City = "Tampa",
StateAbbreviation = "FL",
Latitude = 27.950575,
Longitude = -82.457176,
JobID = frontend.ID
},
new JobLocation
{
City = "Tallahassee",
StateAbbreviation = "FL",
Latitude = 30.455000,
Longitude = -84.253334,
JobID = frontend.ID
},
};
var cloudLocations = new List <JobLocation>
{
new JobLocation
{
City = "Tallahassee",
StateAbbreviation = "FL",
Latitude = 30.455000,
Longitude = -84.253334,
JobID = cloud.ID
},
new JobLocation
{
City = "New York",
StateAbbreviation = "NY",
Latitude = 40.712776,
Longitude = -74.005974,
JobID = cloud.ID
},
};
var jobLocations = new List <JobLocation>
{
new JobLocation
{
City = "Beverly Hills",
StateAbbreviation = "CA",
Latitude = 34.077200,
Longitude = -118.422450,
JobID = fullstack.ID
},
new JobLocation
{
City = "Redmond",
StateAbbreviation = "WA",
Latitude = 47.751076,
Longitude = -120.740135,
JobID = senior.ID
}
};
jobLocations.AddRange(frontendLocations);
jobLocations.AddRange(cloudLocations);
context.JobLocations.AddRange(jobLocations);
foreach (var job in jobs)
{
context.JobApplicationQuestions.AddRange(new[] {
new JobApplicationQuestion
{
JobID = job.ID,
QuestionID = yesNoQ.ID,
DisplayOrder = 1,
},
new JobApplicationQuestion
{
JobID = job.ID,
QuestionID = numberResponseQ.ID,
DisplayOrder = 2
}
});
context.JobBenefits.AddRange(new[] {
new JobBenefit
{
JobID = job.ID,
Name = "Exciting open source projects",
Description = "We don’t work on dull and boring projects. Ever."
},
new JobBenefit
{
JobID = job.ID,
Name = "Flexible working hours",
Description = "Possibility for remote work, home office, and flexible hours during the day."
},
new JobBenefit
{
JobID = job.ID,
Name = "Learning and development",
Description = "Subsidized conferences, classes, and events."
},
new JobBenefit
{
JobID = job.ID,
Name = "Health & vision insurance",
Description = "Health and vision insurance."
}
});
context.JobRequirements.AddRange(new[] {
new JobRequirement
{
JobID = job.ID,
Name = "Programming experience",
Description = "We are looking for people who are familiar with or want to learn .NET quickly'",
},
new JobRequirement
{
JobID = job.ID,
Name = "Flexibility",
Description = "A quick learner who can and wants to switch between programming languages depending on project requirements."
},
new JobRequirement
{
JobID = job.ID,
Name = "Problem solver",
Description = "We appreciate people who work smart – and hard."
}
});
context.JobResponsibilities.AddRange(new[] {
new JobResponsibility
{
JobID = job.ID,
Name = "Design and build",
Description = "Design and implement new features and enhance existing functionalities according to business specifications.",
},
new JobResponsibility
{
JobID = job.ID,
Name = "Ownership",
Description = "Participate in the whole sprint process for product development."
},
new JobResponsibility
{
JobID = job.ID,
Name = "Coding standards",
Description = "Ensure that your code meets software development and quality standards and fits into the continuous release process."
}
});
context.JobMethods.AddRange(new[] {
new JobMethod
{
JobID = job.ID,
Name = "Agile software development",
Description = "We are agile software developers.",
},
new JobMethod
{
JobID = job.ID,
Name = "SCRUM lifecycles",
Description = "We iterate SCRUM lifecycles to develop our software."
},
new JobMethod
{
JobID = job.ID,
Name = "CI/CD",
Description = "Continuous integration and deployment."
}
});
}
var cSharp = new Skill
{
Name = "C#",
Description = "C# progamming language"
};
var javaScript = new Skill
{
Name = "JavaScript",
Description = "JavaScript progamming language"
};
var sfrontend = new Skill
{
Name = "Frontend",
Description = "Frontend development"
};
var sbackend = new Skill
{
Name = "Backend",
Description = "Backend development"
};
var html = new Skill
{
Name = "HTML",
Description = "HTML"
};
var css = new Skill
{
Name = "CSS",
Description = "CSS"
};
context.Skills.AddRange(new List <Skill>
{
cSharp,
javaScript,
sfrontend,
sbackend,
html,
css,
});
context.SaveChanges();
context.JobSkills.AddRange(new []
{
//frontend
new JobSkill
{
JobID = frontend.ID,
SkillID = html.ID
},
new JobSkill
{
JobID = frontend.ID,
SkillID = css.ID
},
new JobSkill
{
JobID = frontend.ID,
SkillID = sfrontend.ID
},
//sr developer
new JobSkill
{
JobID = senior.ID,
SkillID = sbackend.ID
},
new JobSkill
{
JobID = senior.ID,
SkillID = cSharp.ID
},
new JobSkill
{
JobID = senior.ID,
SkillID = javaScript.ID
},
//cloud
new JobSkill
{
JobID = cloud.ID,
SkillID = sbackend.ID
},
new JobSkill
{
JobID = cloud.ID,
SkillID = cSharp.ID
},
//full stack
new JobSkill
{
JobID = fullstack.ID,
SkillID = html.ID
},
new JobSkill
{
JobID = fullstack.ID,
SkillID = css.ID
},
new JobSkill
{
JobID = fullstack.ID,
SkillID = sfrontend.ID
},
new JobSkill
{
JobID = fullstack.ID,
SkillID = sbackend.ID
},
new JobSkill
{
JobID = fullstack.ID,
SkillID = cSharp.ID
},
new JobSkill
{
JobID = fullstack.ID,
SkillID = javaScript.ID
},
});
context.SaveChanges();
#endregion
}
public JsonResult GetMetricsData()
{
SeniorityLevel seniority = (SeniorityLevel)int.Parse(Request.Form["seniority"]);
string technology = Request.Form["technology"];
double avgProcTime = 0.0, maxProcTime = 0.0, minProcTime = 0.0;
Process maxProc = null, minProc = null;
double avgStatTime = 0.0, maxStatTime = 0.0, minStatTime = 0.0;
ProcessInstance maxPIns = null, minPIns = null;
using (HFContext hfdb = new HFContext())
{
List <Process> processes = (from proc in hfdb.Processes
where proc.Seniority == seniority &&
proc.Technologies.Contains(technology)
select proc).ToList();
avgProcTime = processes.Average(proc => (proc.EndDate ?? DateTime.Now).Subtract(proc.StartDate).TotalDays);
maxProcTime = 0.0;
minProcTime = double.MaxValue;
maxProc = processes[0];
minProc = maxProc;
foreach (Process proc in processes)
{
double time = (proc.EndDate ?? DateTime.Now).Subtract(proc.StartDate).TotalDays;
if (time > maxProcTime)
{
maxProcTime = time;
maxProc = proc;
}
if (time < minProcTime)
{
minProcTime = time;
minProc = proc;
}
}
List <ProcessInstance> processInstances = (from pIns in hfdb.ProcessInstances
where pIns.InstanceOf.Seniority == seniority &&
pIns.InstanceOf.Technologies.Contains(technology)
select pIns).ToList();
avgStatTime = processInstances.Average(pIns => AverageTimeWithinInstance(pIns));
maxStatTime = 0.0;
minStatTime = double.MaxValue;
maxPIns = processInstances[0];
minPIns = maxPIns;
foreach (ProcessInstance pIns in processInstances)
{
double time = MaximumTimeWithinInstance(pIns);
if (time > maxStatTime)
{
maxStatTime = time;
maxPIns = pIns;
}
time = MinimumTimeWithinInstance(pIns);
if (time < minStatTime)
{
minStatTime = time;
minPIns = pIns;
}
}
}
var data = new
{
avgProcessTime = avgProcTime.ToString("F"),
maxProcessId = maxProc.Id,
maxProcessName = maxProc.Name,
maxProcessTime = maxProcTime.ToString("F"),
minProcessId = minProc.Id,
minProcessName = minProc.Name,
minProcessTime = minProcTime.ToString("F"),
avgStatusTime = avgStatTime.ToString("F"),
maxStatusId = maxPIns.Id,
maxStatusTime = maxStatTime.ToString("F"),
minStatusId = minPIns.Id,
minStatusTime = minStatTime.ToString("F")
};
return(Json(data));
}
public JsonResult GetProcessMetricsData([ModelBinder(typeof(DataTablesBinder))] IDataTablesRequest requestModel)
{
IQueryable <Process> query = null;
int totalCount = 0;
int filteredCount = 0;
SeniorityLevel seniority = SeniorityLevel.Entry;
bool seniorityExists = false;
if (Request.Form["seniority"] != string.Empty)
{
seniority = (SeniorityLevel)int.Parse(Request.Form["seniority"]);
seniorityExists = true;
}
string technology = Request.Form["technology"];
int month = int.Parse(Request.Form["month"]);
int year = int.Parse(Request.Form["year"]);
DateTime start = new DateTime(year, month, 1);
DateTime end = new DateTime(year, month, DateTime.DaysInMonth(year, month));
using (HFContext hfdb = new HFContext())
{
query = from proc in hfdb.Processes
where ((start <proc.StartDate && end> proc.StartDate) ||
(start > proc.StartDate && start < proc.EndDate)) &&
((seniorityExists && proc.Seniority == seniority) || proc.Technologies.Contains(technology))
select proc;
totalCount = query.Count();
if (requestModel.Search.Value != string.Empty)
{
string value = requestModel.Search.Value.Trim();
query = query.Where(p => p.Name.Contains(value) ||
p.Technologies.Contains(value)
);
}
filteredCount = query.Count();
IOrderedEnumerable <Column> sortedColumns = requestModel.Columns.GetSortedColumns();
string orderByString = string.Empty;
foreach (Column column in sortedColumns)
{
orderByString += orderByString != string.Empty ? "," : "";
orderByString += (column.Data) + (column.SortDirection == Column.OrderDirection.Ascendant ? " asc" : " desc");
}
query = query.OrderBy(orderByString == string.Empty ? "StartDate asc" : orderByString);
query = query.Skip(requestModel.Start).Take(requestModel.Length);
ICollection <Process> processData = query.ToList();
var data = processData.Select(process =>
new {
Id = process.Id,
Name = process.Name,
Technologies = process.Technologies,
Seniority = process.Seniority.ToString(),
Duration = (process.EndDate ?? DateTime.Now).Subtract(process.StartDate).TotalDays.ToString("F")
}).ToList();
return(Json(new DataTablesResponse(requestModel.Draw, data, filteredCount, totalCount)));
}
}
