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