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