public static void UniversiteCalSql(bool lisans, Bolum bolum, Sehir sehir) { SqlConnection baglanti = new SqlConnection(@"Data Source=ASUS\SQLEXPRESS;Initial Catalog=UniPuan;Integrated Security=True"); baglanti.Open(); List <Bolum> bolumler = new List <FemClient.Bolum>(); bolumler.Add(bolum); List <Sehir> sehirler = new List <FemClient.Sehir>(); sehirler.Add(sehir); var universiteler = Universite(bolumler, sehirler); foreach (var item in universiteler) { SqlCommand komut = new SqlCommand("UP_SP_UNIVERSITY_SAVE", baglanti); komut.CommandType = System.Data.CommandType.StoredProcedure; komut.Parameters.AddWithValue("@UNIVERSITYID", item.UNIVERSITEID); komut.Parameters.AddWithValue("@UNIVERSITYNAME", item.Universitead); komut.Parameters.AddWithValue("@CITYID", sehir.ilId); komut.Parameters.AddWithValue("@UNITYPEID", "2"); var sonuc = komut.ExecuteNonQuery(); SqlCommand komut1 = new SqlCommand("INSERT into UP_ST_UNIVERSITYDEPARTMENT (UNIVERSITYID,DEPARTMENTID) " + " values(@UNIVERSITYID,@DEPARTMENTID)", baglanti); komut1.Parameters.AddWithValue("@UNIVERSITYID", item.UNIVERSITEID); komut1.Parameters.AddWithValue("@DEPARTMENTID", bolum.BolumId); var sonuc1 = komut1.ExecuteNonQuery(); } baglanti.Close(); PuanCalSql(lisans, bolumler, sehirler, universiteler); }
public static void SehirCalSql(bool lisans, Bolum bolum) { SqlConnection baglanti = new SqlConnection(@"Data Source=ASUS\SQLEXPRESS;Initial Catalog=UniPuan;Integrated Security=True"); baglanti.Open(); List <Bolum> bolumler = new List <FemClient.Bolum>(); bolumler.Add(bolum); var city = Sehir(bolumler); foreach (var item in city) { SqlCommand komut = new SqlCommand("UP_SP_CITY_SAVE", baglanti); komut.CommandType = System.Data.CommandType.StoredProcedure; komut.Parameters.AddWithValue("@CITYID", item.ilId); komut.Parameters.AddWithValue("@CITYNAME", item.ilAdi); var sonuc = komut.ExecuteNonQuery(); SqlCommand komut2 = new SqlCommand("INSERT into UP_ST_CITYDEPARTMENT (CITYID,DEPARTMENTID) values(@CITYID,@DEPARTMENTID)", baglanti); komut2.Parameters.AddWithValue("@CITYID", item.ilId); komut2.Parameters.AddWithValue("@DEPARTMENTID", bolum.BolumId); var sonuc2 = komut2.ExecuteNonQuery(); } baglanti.Close(); foreach (var item in city) { foreach (var blm in bolumler) { UniversiteCalSql(lisans, blm, item); } } }
private void lbBolumSecilen_SelectedIndexChanged(object sender, EventArgs e) { if (lbBolumSecilen.SelectedItem != null) { Bolum secilen = (Bolum)this.lbBolumSecilen.SelectedItem; this.lbBolumSecilen.Items.Remove(secilen); SehirYukle(); } }
private void lbBolum_SelectedValueChanged(object sender, EventArgs e) { if (lbBolum.SelectedItem != null) { Bolum secilen = (Bolum)this.lbBolum.SelectedItem; if (this.lbBolumSecilen.Items.OfType <Bolum>().Count(t => t.BolumId == secilen.BolumId) == 0) { this.lbBolumSecilen.Items.Add(secilen); } SehirYukle(); } }