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