public ActionResult Edit(int id)
{
try
{
var position = new OfficePosition();
using (var db = new TalentContext())
{
position = db.OfficePositions.Include("JobRequirements").Where(x => x.OfficePositionID == id).FirstOrDefault();
ViewBag.Departments = db.Departments.ToList();
ViewBag.Industries = db.Industries.ToList();
ViewBag.Branches = db.Branches.ToList();
ViewBag.Positions = db.OfficePositions.ToList();
ViewBag.JobRequirements = position.JobRequirements.Select(x => new { x.ID, x.Mandatory, x.ScoreID,
x.NeedCode, x.DesiredScore, x.OfficePositionID, x.QualificationCode,
x.QualificationDescription, x.QualificationType, x.StageCode, x.Priority }).ToList();
ViewBag.ApplicantEvalMetrics = db.ApplicantEvaluationMetrics
.Where(x => x.OfficePositionID == id)
.Select(y => new { y.ID, y.OfficePositionID, y.EvaluationCode, y.EvaluationDescription, y.MaximumScore }).ToList();
var list = db.JobQualifications.ToList();
ViewBag.Codes = list.GroupBy(o => o.QualificationCode).Select(x => x.FirstOrDefault());
ViewBag.Types = list;
return(View(position));
}
}
catch
{
return(View("Error"));
}
}
public ActionResult expensemanager()
{
using (var db = new TalentContext())
{
}
return(View());
}
public ActionResult CreateGuide(int?applicantid, WelcomeGuide guide)
{
ViewBag.Templates = db.OnboardingTemplates.ToList();
ViewBag.Branches = db.Branches.ToList();
if (!ModelState.IsValid)
{
guide.DateCreated = DateTime.UtcNow;
guide.StartDate = DateTime.UtcNow.AddDays(7);
return(View(guide));
}
using (var db = new TalentContext())
{
guide.Status = Status.Review;
db.WelcomeGuides.Add(guide);
db.SaveChanges();
if (guide.TemplateID != null)
{
guide.WelcomeMessage = db.OnboardingTemplates.Find(guide.TemplateID).WelcomeMessage;
var activities = db.CompletedActivities.Where(x => x.OnboardingTemplateID == guide.ID).ToList();
var guideactivities = OnboardingUtilityHelper.ConvertToGuideActivities(activities, guide.ID);
//guide.CompletedActivities = OnboardingUtilityHelper.ConvertToGuideActivities(db.OnboardingTemplates.Find(guide.TemplateID).CompletedActivities.ToList(), guide.ID);
guide.previewurl = Guid.NewGuid().ToString();
db.CompletedActivities.AddRange(guideactivities);
db.SaveChanges();
}
}
return(RedirectToAction("Guide/Customize/" + guide.Name + "/" + guide.ID, "Onboarding"));
}
private void createOfficePositions()
{
TalentContext context = new TalentContext();
for (int i = 1; i <= 5; i++)
{
var job = context.OfficePositions.Find(i);
var requisition = new JobRequisition()
{
JobRequisitionID = i,
HeadOfDepartmentID = 1,
HumanResourcePersonnelID = 2,
JobTitle = job.Title,
JobDescription = job.RoleSummary,
PublishedDate = DateTime.Now,
StartDate = DateTime.Now.AddDays(i),
ClosingDate = DateTime.Now.AddDays(14),
Location = "Lagos",
Status = JobRequisition.JobRequisitionStatus.Posted,
NoOfPositionsAvailable = 1,
OfficePositionID = job.OfficePositionID
};
context.JobRequisitions.Add(requisition);
}
// context.SaveChanges();
}
public ActionResult complaintmanager()
{
using (var db = new TalentContext())
{
}
return(View());
}
public ActionResult ManageApplication(int?id)
{
var db = new TalentContext();
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
JobApplication application = db.JobApplications.Find(id);
// JobApplication application = db.JobApplications.Include("JobRequisition").Include("JobSeeker").WhereFind(id);
if (application == null)
{
return(HttpNotFound());
}
try
{
ViewBag.requisitionid = application.JobRequisitionID;
ViewBag.applicationid = application.JobApplicationID;
return(View(application));
}
catch (Exception ex)
{
ViewBag.Message = "Sorry , Unable to retrieve Details for Job Application";
return(View("Error"));
}
}
public ActionResult _GetEvaluations(int id, int stageid, int officeid, Dictionary <string, int> maxscores)
{
ViewBag.stageid = stageid;
ViewBag.maxscores = maxscores;
var applicantmetrics = db.ApplicantEvaluationMetrics.Where(x => x.OfficePositionID == officeid);
// ViewBag.ApplicantMetrics = applicantmetrics;
var evaluations = new List <Evaluation>();
using (var db = new TalentContext())
{
var evaluationss = db.Evaluations.Where(x => x.InterviewEvaluationID == id).ToList();
if (evaluationss.Count() != applicantmetrics.Count())
{
foreach (var metric in applicantmetrics)
{
evaluations.Add(new Evaluation
{
EvaluationCode = metric.EvaluationCode,
EvaluationDescription = metric.EvaluationDescription,
InterviewEvaluationID = id
});
}
db.Evaluations.AddRange(evaluations);
db.SaveChanges();
}
else
{
evaluations = evaluationss;
}
}
return(PartialView(evaluations));
}
public ActionResult _GetCandidateEvaluationForm(int interviewid, int employeeid)
{
var interviewevaluation = new InterviewEvaluation();
using (var db = new TalentContext())
{
var categories = db.EvaluationCategories.Where(x => x.InterviewID == interviewid).ToList();
var dictionary = new Dictionary <string, string>();
foreach (var item in categories)
{
dictionary[item.EvaluationCode] = item.EvaluationDescription;
}
ViewBag.Dictionary = dictionary;
var existinginterviewevaluation = db.InterviewEvaluations.Where(x => x.InterviewID == interviewid && x.EmployeeID == employeeid);
if (existinginterviewevaluation.Any())
{
interviewevaluation = existinginterviewevaluation.FirstOrDefault();
}
else
{
int count = db.InterviewEvaluations.Where(x => x.InterviewID == interviewevaluation.InterviewID).Count();
interviewevaluation.EvaluationNo = "TR" + String.Format("{0:D6}", interviewid + count + 6);
interviewevaluation.EmployeeID = employeeid;
interviewevaluation.InterviewID = interviewid;
interviewevaluation.StageID = 1;
}
}
return(PartialView(interviewevaluation));
}
public JsonResult _SubmitCandidateAvailabilityForm(Interview interview)
{
bool action = false;
if (ModelState.IsValid)
{
using (var db = new TalentContext())
{
//var InterviewExistingCheck = db.Interviews.Where(o => o.JobRequisitionID == interview.JobRequisitionID && o.JobApplicationID == interview.JobApplicationID);
if (interview.InterviewID != 0)
{
db.Interviews.Add(interview);
db.Entry(interview).State = System.Data.Entity.EntityState.Modified;
db.SaveChanges();
}
else
{
db.Interviews.Add(interview);
db.SaveChanges();
}
var applicant = db.JobApplications.Include("JobSeeker").Where(x => x.JobApplicationID == interview.JobApplicationID).First().JobSeeker;
ApplicationDbContext context = new ApplicationDbContext();
var UserManager = new UserManager <ApplicationUser>(new UserStore <ApplicationUser>(context));
var applicantemail = UserManager.FindById(applicant.UserId).Email;
SendEmailToApplicant();
action = true;
}
}
var response = new Dictionary <string, dynamic>();
response.Add("action", (bool)action);
response.Add("interviewid", (int)interview.InterviewID);
return(Json(response, JsonRequestBehavior.AllowGet));
}
public ActionResult onboarding()
{
using (var db = new TalentContext())
{
}
return(View());
}
public PermissionsController()
{
ApplicationDbContext context = new ApplicationDbContext();
Context = context;
db = new TalentContext();
}
public ActionResult Trainings()
{
using (var db = new TalentContext())
{
}
return(View());
}
public ActionResult Performance()
{
using (var db = new TalentContext())
{
}
return(View());
}
public JsonResult CreateUpdate(Sales sales)
{
using (TalentContext db = new TalentContext())
{
if (sales.Id == 0)
{
db.Sales.Add(sales);
db.SaveChanges();
}
else
{
var salesData = db.Sales.Where(x => x.Id == sales.Id).FirstOrDefault();
salesData.DateSold = sales.DateSold;
salesData.ProductId = sales.ProductId;
salesData.CustomerId = sales.CustomerId;
salesData.StoreId = sales.StoreId;
db.SaveChanges();
}
return(Json(new
{
redirectUrl = Url.Action("Index", "Sales"),
isRedirect = true
}));
}
//return null;
}
public ActionResult ExitManagement()
{
using (var db = new TalentContext())
{
}
return(View());
}
public ActionResult _GetInterviewEvaluations(int interviewid)
{
var interviewevaluations = new List <InterviewEvaluation>();
using (var db = new TalentContext())
{
var allevaluations = db.InterviewEvaluations.Include("Employee").Where(x => x.InterviewID == interviewid).ToList();
var evalscores = db.Evaluations.Include("InterviewEvaluation").Where(x => x.InterviewEvaluation.InterviewID == interviewid);
if (allevaluations.Any())
{
foreach (var score in allevaluations)
{
var ev = evalscores.Where(x => x.InterviewEvaluationID == score.ID);
if (ev.Count() > 0)
{
score.Score1 = (decimal)ev.Average(x => x.Score1);
}
}
interviewevaluations.AddRange(allevaluations);
}
//interviewevaluations.Add(new InterviewEvaluation()
//{
// ID = 1,
// EmployeeID = 10,
// InterviewID = interviewid,
// EvaluationNo = "TR" + String.Format("{0:D6}", interviewid + allevaluations.Count),
// RecommendForHire = false
//});
}
return(PartialView(interviewevaluations));
}
internal async Task <ActionResult> SaveBioDetails(JobSeeker applicant)
{
try
{
if (ModelState.IsValid)
{
using (var db = new TalentContext())
{
var id = applicant.ID;
var originaluserdata = GetUserProfile(id);
originaluserdata.FirstName = applicant.FirstName;
originaluserdata.LastName = applicant.LastName;
originaluserdata.PhoneNumber = applicant.PhoneNumber;
originaluserdata.Address = applicant.Address;
originaluserdata.DateOfBirth = applicant.DateOfBirth;
db.Entry(originaluserdata).State = EntityState.Modified;
await db.SaveChangesAsync();
//db.SaveChanges();
}
return(RedirectToAction("Education", "Applicant"));
}
return(View("ManageProfile", "Applicant", applicant));
}
catch (Exception ex)
{
ModelState.AddModelError("", ex);
return(View("Error"));
//return new HttpStatusCodeResult(HttpStatusCode.BadRequest);
}
}
public ActionResult Skills(List <CheckModel> checks, ICollection <string> ret, ICollection <Product> products)
{
SetUserSessionID();
var user = getUserAndSkill();
using (var db = new TalentContext())
{
ViewBag.Industries = db.Industries.ToList();
ViewBag.Skills = db.Skills.ToList();
var list = new List <CheckModel>();
foreach (var item in (List <Skill>)ViewBag.Skills)
{
if (user.Skills.Contains(item))
{
list.Add(new CheckModel {
Id = item.ID, Name = item.Name, Checked = true
});
}
else
{
list.Add(new CheckModel {
Id = item.ID, Name = item.Name, Checked = false
});
}
}
ViewBag.SelectedSkills = list;
}
return(PartialView(user));
}
public ActionResult _GetSkills(int id)
{
var user = new JobSeeker();
var sk = new List <CheckModel>();
using (var db = new TalentContext())
{
user = db.Applicants.Include("Skills").Where(s => s.ID == id).FirstOrDefault();
ViewBag.Skills = db.Skills.ToList();
var list = new List <CheckModel>();
foreach (var item in (List <Skill>)ViewBag.Skills)
{
if (user.Skills.Contains(item))
{
list.Add(new CheckModel {
Id = item.ID, Name = item.Name, Checked = true
});
}
else
{
list.Add(new CheckModel {
Id = item.ID, Name = item.Name, Checked = false
});
}
}
ViewBag.SelectedSkills = list;
sk = list;
}
return(PartialView(sk));
}
public ActionResult ManageProfile()
{
SetUserSessionID();
if (TempData["userid"] == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.Unauthorized));
}
var user = getUserAndSkill();
using (var db = new TalentContext())
{
ViewBag.Industries = db.Industries.ToList();
ViewBag.Skills = db.Skills.ToList();
//var list = new List<CheckModel>();
//foreach (var item in (List<Skill>)ViewBag.Skills)
//{
// if (user.Skills.Contains(item))
// {
// list.Add(new CheckModel { Id = item.ID, Name = item.Name, Checked = true});
// }
// else
// {
// list.Add(new CheckModel { Id = item.ID, Name = item.Name, Checked = false });
// }
//}
//ViewBag.SelectedSkills = list;
ViewBag.userid = user.ID;
}
return(View(user));
}
public JsonResult GetData()
{
using (TalentContext db = new TalentContext())
{
var data = db.Product.ToList();
return(Json(data));
}
}
public ActionResult _GetApplication(int?id)
{
var application = new JobApplication();
var db = new TalentContext();
application = db.JobApplications.Find(id);
return(PartialView(application));
}
public int _getUserId()
{
var db = new TalentContext();
var userguid = User.Identity.GetUserId();
var userid = db.Employees.Where(x => x.UserId == userguid).FirstOrDefault().ID;
return(userid);
}
private void SetUserSessionID()
{
if (TempData["userid"] == null)
{
var userid = User.Identity.GetUserId();
var applicantid = new TalentContext().Applicants.Where(s => s.UserId == userid).FirstOrDefault().ID;
TempData["userid"] = applicantid;
}
}
public ActionResult _GetRequirementsForEditing(List <BusinessLogic.UpdatedDomain.JobRequirement> requirements)
{
using (var db = new TalentContext())
{
ViewBag.Requirements = db.JobQualifications.ToList();
ViewBag.RequirementCode = db.JobQualifications.Select(o => o.QualificationType).Distinct().ToList();
}
return(PartialView("_GetRequirements", requirements));
}
public JsonResult GetInformationForRole(int officeroleid)
{
var db = new TalentContext();
OfficePosition details = db.OfficePositions.Find(officeroleid);
var employeecount = db.Employees.Where(x => x.OfficePositionID == officeroleid).Count();
var vaccantposts = details.Posts - employeecount;
return(Json(new { Title = details.Title, Responsibilities = details.Reqirements, Posts = details.Posts, AvailablePosts = vaccantposts }, "application/json", Encoding.UTF8, JsonRequestBehavior.AllowGet));
}
public ActionResult Apply(int id,JobSeeker jobseeker)
{
if (id == 0)
{
return new HttpStatusCodeResult(HttpStatusCode.BadRequest);
}
JobRequisition job = db.JobRequisitions.Find(id);
ViewBag.Industries = db.Industries.ToList();
ViewBag.jobRequisition = job;
if (job == null)
{
return HttpNotFound();
}
try
{
//get the details of the applicant
var IsProfileCompleted = checkalluserfields();
var IsApplicationExisting = checkIfApplicationExists(User.Identity.GetUserId(),id);
if (IsApplicationExisting)
{
ViewBag.Message = "FoundApplication";
return View(jobseeker);
}
if (IsProfileCompleted)
{
//run check to see if there is an existing application with the clientid and job requisitionid
//Display Message to indicate Success
//Create new Job Application
var application = new JobApplication();
application.ApplicationStatus = ApplicationStatus.Applied;
application.JobSeekerID = getuserid();
application.RegistrationDate = DateTime.Now;
application.JobRequisitionID = id;
using(var db=new TalentContext())
{
db.JobApplications.Add(application);
db.SaveChanges();
}
ViewBag.Message = "True";
}
else
{
ViewBag.Message = "False";
}
//Obtain List of Fields to be Updated
//Display Message to indicate Success
return View(jobseeker);
}
catch
{
ViewBag.Message = "Please Re-Apply";
return View(jobseeker);
}
}
public ActionResult _GetClosedApplications(int id)
{
var activeapplications = new List <JobApplication>();
var db = new TalentContext();
activeapplications = db.JobApplications.Where(job => job.JobRequisitionID == id).
Where(job => job.ApplicationStatus == ApplicationStatus.Canceled).ToList();
return(PartialView("_GetNewApplications", activeapplications));
}
public ActionResult Create(JobRequisition requisition, List <CheckModel> checks)
{
var req = new TalentContext().JobRequisitions.Count();
requisition.RequisitionNo = "TR" + String.Format("{0:D6}", req + 1);
if (DateTime.Now.Year > requisition.StartDate.Year)
{
ViewBag.Message = "Invalid Start Date for Requisition";
//ViewBag.Message = requisition.StartDate + " " + requisition.ClosingDate+ " " + requisition.PublishedDate;
return(View(requisition));
}
if (DateTime.Now.Year > requisition.ClosingDate.Year)
{
ViewBag.Message = "Invalid Closing Date for Requisition";
//ViewBag.Message = requisition.StartDate + " " + requisition.ClosingDate+ " " + requisition.PublishedDate;
return(View(requisition));
}
if (!ModelState.IsValid)
{
ViewBag.Message = "Couldn't Create Requisition; Form was not Completed Properly";
return(View(requisition));
}
try
{
List <Skill> selectedskills = checks.Where(x => x.Checked == true)
.Select(o => new Skill {
ID = o.Id, Name = o.Name
}).ToList();
var selectedint = selectedskills.Select(o => o.ID).ToList();
requisition.Status = JobRequisition.JobRequisitionStatus.Created;
//requisition.StartDate = DateTime.UtcNow;
//requisition.ClosingDate = DateTime.UtcNow;
requisition.PublishedDate = DateTime.UtcNow;
using (var db = new TalentContext())
{
var skills = db.Skills
.Where(x => selectedint.Contains(x.ID))
.ToList();
db.JobRequisitions.Add(requisition);
db.SaveChanges();
requisition.Skills.Union(skills);
requisition.Skills.Intersect(skills);
requisition.Skills = skills;
db.SaveChanges();
}
ViewBag.Message = "Successfully Created Requisition";
return(View());
}
catch
{
return(View("Error"));
}
}
public ActionResult Edit(int?id, JobRequisition requisition, List <CheckModel> checks)
{
ViewBag.Message = "Changes Were Not Saved. Pls Try Again";
if (!ModelState.IsValid)
{
return(View(requisition));
}
try
{
//List<Skill> selectedskills = checks.Where(x => x.Checked == true)
// .Select(o => new Skill { ID = o.Id, Name = o.Name }).ToList();
//var selectedint = selectedskills.Select(o => o.ID).ToList();
using (var db = new TalentContext())
{
JobRequisition jobRequisition = db.JobRequisitions.Find(id);
if (string.IsNullOrEmpty(jobRequisition.RequisitionNo))
{
var req = new TalentContext().JobRequisitions.Count();
jobRequisition.RequisitionNo = "TR" + String.Format("{0:D6}", req + 1);
}
jobRequisition.JobResponsibilities = requisition.JobResponsibilities;
jobRequisition.EducationalRequirements = requisition.EducationalRequirements;
jobRequisition.AgeLimit = requisition.AgeLimit;
jobRequisition.JobDescription = jobRequisition.JobDescription;
jobRequisition.Location = requisition.Location;
jobRequisition.ClosingDate = requisition.ClosingDate;
jobRequisition.StartDate = requisition.StartDate;
jobRequisition.YearsOfExperience = requisition.YearsOfExperience;
jobRequisition.NoOfPositionsAvailable = requisition.NoOfPositionsAvailable;
jobRequisition.Status = JobRequisition.JobRequisitionStatus.Created;
jobRequisition.PublishedDate = DateTime.Now;
db.Entry(jobRequisition).State = System.Data.Entity.EntityState.Modified;
//var skills = db.Skills
// .Where(x => selectedint.Contains(x.ID))
// .ToList();
// db.JobRequisitions.Add(requisition);
//jobRequisition.Skills.Clear();
//jobRequisition.Skills = selectedskills;
db.SaveChanges();
//requisition.Skills.Union(skills);
//requisition.Skills.Intersect(skills);
//requisition.Skills = skills;
// db.SaveChanges();
ViewBag.Message = "Changes Were succesfully Saved";
return(RedirectToAction("Requisitions", "Admin"));
//return View(requisition);
}
}
catch
{
//return;
return(View("Error"));
}
}
