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