private void btnSorgula_Click(object sender, EventArgs e)
{
string fakulte, bolum;
fakulte = cmbFakulteSec.SelectedItem.ToString();
if (cmbBolumSec.SelectedIndex != -1)
{
bolum = cmbBolumSec.SelectedItem.ToString();
}
else
{
bolum = null;
}
BolumAnaBilimSayisalTabloView BABSTV = new BolumAnaBilimSayisalTabloView();
BABSTV.Fakulte = fakulte;
BABSTV.Bolum = bolum;
DataTable dt = BolumAnaBilimSayisalTablosu.TabloGetir(BABSTV);
dataGridSayisalTablo.DataSource = dt;
}
public static DataTable TabloGetir(BolumAnaBilimSayisalTabloView View)
{
try
{
DataTable dt = new DataTable();
dt.Columns.Add("Fakülte");
dt.Columns.Add("Bölüm");
dt.Columns.Add("Prof.");
dt.Columns.Add("Doç.");
dt.Columns.Add("Yar.Doç.");
dt.Columns.Add("Ars.Gör.");
dt.Columns.Add("Okutman");
using (PersonelOtomasyonDBEntities2 db = new PersonelOtomasyonDBEntities2())
{
List <string> Veriler = new List <string>();
List <int?> UnvanID;
DataRow dr = dt.NewRow();
var Fakulteler = (from i in db.tblFakülte
where i.fakutle == View.Fakulte
select i).SingleOrDefault();
dr[0] = Fakulteler.fakutle;
for (int i = 1; i < dt.Columns.Count; i++)
{
dr[i] = "";
}
dt.Rows.Add(dr);
var Bolumler = (from i in db.tblDepartman
where i.fakulte_ID == Fakulteler.fakulte_ID && i.departman == View.Bolum
select i).ToList();
if (View.Bolum == null)
{
Bolumler = (from i in db.tblDepartman
where i.fakulte_ID == Fakulteler.fakulte_ID
select i).ToList();
}
foreach (var item in Bolumler)
{
DataRow dr2 = dt.NewRow();
var Unvanlar = (from i in db.tblPersoneller
join u in db.tblUnvan on i.unvan_ID equals u.unvan_ID
where i.departman_ID == item.departman_ID
group u.unvan by u.unvan_ID into d select new { UnvanID = d.Key, Unvan = d }).ToList();
int x = 0;
dr2[x++] = "";
dr2[x++] = item.departman;
for (int i = 0; i < Unvanlar.Count; i++)
{
int id = Convert.ToInt32(Unvanlar[i].UnvanID);
string temp = db.tblUnvan.FirstOrDefault(z => z.unvan_ID == id).unvan.ToString().Trim();
dr2[temp] = Unvanlar[i].Unvan.Count();
}
dt.Rows.Add(dr2);
}
return(dt);
}
}catch (Exception e)
{
return(null);
}
}
