public ActionResult Overview(int radioIds) { //Fetching UserManager var userManager = new UserManager <ApplicationUser>(new UserStore <ApplicationUser>(db)); //Get User from Database based on userId var currentUser = userManager.FindById(User.Identity.GetUserId()); //get the current company from db Company company = db.Companies.Where(x => x.ApplicationUserId == currentUser.Id).Single(); //get the total employee nr for company var totalEmployees = db.Employees.Where(e => e.CompanyId == company.CompanyId).Count(); // get the employees nr with level and count var countEmployee = db.EmployeesSkills.Include(e => e.Employee).Where(l => l.Level == radioIds && l.Employee.CompanyId == company.CompanyId).Count(); // calculate the percentage represented by countEmployee ratio int percentComplete = (int)Math.Round((double)(100 * countEmployee) / totalEmployees); if (ModelState.IsValid && countEmployee != 0) { var model = new EmployeeSkillViewModel { Level = percentComplete }; return(PartialView("_PartialOverview", model)); //using the _PartialOverview.cshtml } return(View(ViewBag.Message = "No level experience found within your company.")); }
// GET: EmployeeSkills/Create public ActionResult Create() { var userManager = new UserManager <ApplicationUser>(new UserStore <ApplicationUser>(db)); var currentUser = userManager.FindById(User.Identity.GetUserId()); Employee e = db.Employees.Where(i => i.ApplicationUserId == currentUser.Id).FirstOrDefault(); var list = new List <Skill>(); list = db.Skills.Where(x => x.CompanyId == e.CompanyId).ToList(); var list2 = new List <EmployeeSkill>(); foreach (var item in e.IEmployeeSkill) { list2.Add(item); } for (int i = 0; i < list.Count(); i++) { for (int j = 0; j < list2.Count(); j++) { if (list[i].SkillId == list2[j].SkillId) { list.RemoveAt(i); } } } var model = new EmployeeSkillViewModel { SkillList = list.Select(a => new SelectListItem { Text = a.Skillname, Value = a.SkillId.ToString() }) }; return(View(model)); }
public ActionResult ExperienceOverview() { var model = new EmployeeSkillViewModel { LevelList = new List <SelectListItem>() { new SelectListItem { Text = "1", Value = "1" }, new SelectListItem { Text = "2", Value = "2" }, new SelectListItem { Text = "3", Value = "3" }, new SelectListItem { Text = "4", Value = "4" }, new SelectListItem { Text = "5", Value = "5" } } }; return(View(model)); }
public ActionResult Edit(EmployeeSkillViewModel employee) { if (ModelState.IsValid) { var MyEmployee = db.Employees.Find(employee.MyEmployee.ID); MyEmployee.Name = employee.MyEmployee.Name; MyEmployee.Salary = employee.MyEmployee.Salary; MyEmployee.Birthdate = employee.MyEmployee.Birthdate; foreach (var item in db.EmployeetoSkill) { if (item.EmployeeId == employee.MyEmployee.ID) { db.Entry(item).State = System.Data.Entity.EntityState.Deleted; } } foreach (var item in employee.MySkills) { if (item.Checked) { db.EmployeetoSkill.Add(new EmployeetoSkill() { EmployeeId = employee.MyEmployee.ID, SkillId = item.SkillID }); } } db.SaveChanges(); return(RedirectToAction("Index")); } return(View(employee)); }
public ActionResult GetSkills() { //Fetching UserManager var userManager = new UserManager <ApplicationUser>(new UserStore <ApplicationUser>(db)); //Get User from Database based on userId var currentUser = userManager.FindById(User.Identity.GetUserId()); Employee e = db.Employees.Where(x => x.ApplicationUserId == currentUser.Id).Single(); Company company = db.Companies.Find(e.CompanyId); var list = new List <Skill>(); list = db.Skills.Where(x => x.CompanyId == company.CompanyId).ToList(); var model = new EmployeeSkillViewModel { SkillList = list.Select(a => new SelectListItem { Text = a.Skillname, Value = a.SkillId.ToString(), }) }; return(View(model)); }
public ActionResult Create(int?id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } EmployeeSkillViewModel skillViewModel = new EmployeeSkillViewModel(); skillViewModel.EmployeeId = (int)id; return(View(skillViewModel)); }
public async Task <IActionResult> Index(string employeeId) { var viewModel = new EmployeeSkillViewModel(); if (!string.IsNullOrEmpty(employeeId)) { viewModel.Employee = await _employeeService.GetByEmployeeIdWithDetailAsync(employeeId); viewModel.EmployeeSkills = await _employeeSkillService.GetByEmployeeId(employeeId); } return(View(viewModel)); }
public ActionResult Create([Bind(Include = "EmployeeSkillId,Level,SkillId,EmployeeId")] EmployeeSkillViewModel model) { if (ModelState.IsValid) { var userManager = new UserManager <ApplicationUser>(new UserStore <ApplicationUser>(db)); var currentUser = userManager.FindById(User.Identity.GetUserId()); Employee employee = db.Employees.Where(i => i.ApplicationUserId == currentUser.Id).FirstOrDefault(); EmployeeSkill e = new EmployeeSkill(); e.EmployeeId = employee.EmployeeId; e.Level = model.Level; e.SkillId = model.SkillId; employee.IEmployeeSkill.Add(e); db.EmployeesSkills.Add(e); db.SaveChanges(); return(RedirectToAction("Index")); } return(View(model)); }
public ActionResult Create(EmployeeSkillViewModel employeeSkillViewModel) { try { if (ModelState.IsValid) { var request = new RestRequest(Method.POST); request.AddJsonBody(employeeSkillViewModel); client.Execute(request); return(RedirectToAction("Get", new { id = employeeSkillViewModel.EmployeeId })); } return(View(employeeSkillViewModel)); } catch { return(View()); } }
// GET: Employees/Edit/5 public ActionResult Edit(int?id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } Employee employee = db.Employees.Find(id); var skillscheksQuery = (from skill in db.Skills select new Skillcheck() { SkillName = skill.Name, SkillID = skill.ID, Checked = ((from employeeskill in db.EmployeetoSkill where employeeskill.SkillId == skill.ID & employeeskill.EmployeeId == employee.ID select employeeskill).Count() > 0) } ); List <Skillcheck> skillschecked = skillscheksQuery.ToList(); for (int i = 0; i < skillschecked.Count; i++) { } EmployeeSkillViewModel Employeesandskills = new EmployeeSkillViewModel() { MyEmployee = employee, MySkills = skillschecked }; if (employee == null) { return(HttpNotFound()); } return(View(Employeesandskills)); }