void EnAzPersoneliOlanDepartman()
{
labelControl19.Text = (from x in db.TBLDEPARTMAN
join y in db.TBLPERSONEL
on x.ID equals y.DEPARTMAN
group x by x.AD into Dep
select new
{
Dep.Key,
Toplam = Dep.Count()
}).OrderBy(c => c.Toplam).Select(b => b.Key).First(); //EN C*K PERSONELI OLAN DEPARTMANIN ADI
}
void EnAzPersoneliOlanDepartmaninPersonelSayisi()
{
labelControl19.Text = (from x in db.TBLDEPARTMAN
join y in db.TBLPERSONEL
on x.ID equals y.DEPARTMAN
group x by x.AD into Dep
select new
{
Dep.Key,
Toplam = Dep.Count()
}).OrderBy(a => a.Toplam).Select(b => b.Toplam).First().ToString(); //EN C*K PERSONELI OLAN DEPARTMANIN PERSONEL SAYISI
}
void EnCokPersoneliOlanDepartman()
{
labelControl17.Text = (from x in db.TBLDEPARTMAN
join y in db.TBLPERSONEL
on x.ID equals y.DEPARTMAN
group x by x.AD into Dep
select new
{
Dep.Key,
Toplam = Dep.Count()
}).OrderByDescending(c => c.Toplam).Select(b => b.Key).First(); //EN C*K PERSONELI OLAN DEPARTMANIN ADI
// BURASI DOĞRU EN C*K PERSONELI OLAN DEPARTMNI GETIRIYOR AMA ISMINI DEIL IDSINI GETIRIYOR
/*
* labelControl17.Text = db.TBLPERSONEL.OrderBy(x => x.DEPARTMAN).GroupBy(y => y.DEPARTMAN).Select(z => new
* {
* z.Key,
* toplam = z.Count()
* }).OrderByDescending(a=>a.toplam).Select(b=>b.Key).First().ToString();
*
*/
}