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