public ActionResult DevEmployees()
{ //vraca development zaposlenike
Company11Context db = new Company11Context();
var list1 = db.Employees.Where(a => a.Department.departmentName == "Development");
return(View(list1.ToList()));
}
//prikazuje koliko ima zaposlenika u svakoj lokaciji
//prikaze kao badge
public ActionResult ShowSecondHighestSalary()
{ //da mi prikaze drugu najvecu placu
Company11Context db = new Company11Context();
//var list = db.Employees.OrderByDescending(e => e.salary).Skip(1).First();
var list = db.Employees.GroupBy(e => e.salary).OrderByDescending(g => g.Key).Skip(1).First();
///ovaj kod koristim jer vise zaposlenika ima istu placu
return(View(list.ToList()));
}
public ActionResult Average()
{
//vraca prosjecnu placu dev zaposlenika bez londona
Company11Context db = new Company11Context();
var average = db.Employees.Where(i => i.Department.departmentName == "Development").
Where(a => a.Department.departmentLocation != "London").Average(x => x.salary);
ViewBag.average = average;
return(View());
}
