private void btnAra_Click(object sender, EventArgs e) { DoxaKutuphaneDAL.Entity.Kitap ktp = (DoxaKutuphaneDAL.Entity.Kitap)cmbKitapAdAra.SelectedItem; DoxaKutuphaneDAL.Entity.Kategori ktgr = (DoxaKutuphaneDAL.Entity.Kategori)cmbKategoriAra.SelectedItem; DoxaKutuphaneDAL.Entity.YayinEvi yyn = (DoxaKutuphaneDAL.Entity.YayinEvi)cmbYayinEviAra.SelectedItem; DoxaKutuphaneDAL.Entity.Yazar yzr = (DoxaKutuphaneDAL.Entity.Yazar)cmbYazarAdAra.SelectedItem; if (chkKategori.Checked && chkKitapAd.Checked && chkYayinEvi.Checked && chkYazarAd.Checked) { dataGridView1.DataSource = DoxaKutuphaneDAL.Facade.Kitap.KitapGetir(ktp.KitapAd, ktgr.KategoriId, yzr.YazarId, yyn.YayinEviId); } else if (chkKitapAd.Checked && chkKategori.Checked) { dataGridView1.DataSource = DoxaKutuphaneDAL.Facade.Kitap.KitapGetir(ktp.KitapAd, ktgr.KategoriId, 0, 0); } else if (chkKitapAd.Checked && chkYayinEvi.Checked) { dataGridView1.DataSource = DoxaKutuphaneDAL.Facade.Kitap.KitapGetir(ktp.KitapAd, 0, 0, yyn.YayinEviId); } else if (chkKitapAd.Checked && chkYazarAd.Checked) { dataGridView1.DataSource = DoxaKutuphaneDAL.Facade.Kitap.KitapGetir(ktp.KitapAd, 0, yzr.YazarId, 0); } else if (chkKategori.Checked && chkYayinEvi.Checked) { dataGridView1.DataSource = DoxaKutuphaneDAL.Facade.Kitap.KitapGetir("", ktgr.KategoriId, 0, yyn.YayinEviId); } else if (chkKategori.Checked && chkYazarAd.Checked) { dataGridView1.DataSource = DoxaKutuphaneDAL.Facade.Kitap.KitapGetir("", ktgr.KategoriId, yzr.YazarId, 0); } else if (chkYayinEvi.Checked && chkYazarAd.Checked) { dataGridView1.DataSource = DoxaKutuphaneDAL.Facade.Kitap.KitapGetir("", 0, yzr.YazarId, yyn.YayinEviId); } else if (chkKategori.Checked) { dataGridView1.DataSource = DoxaKutuphaneDAL.Facade.Kitap.KitapGetir("", ktgr.KategoriId, 0, 0); } else if (chkKitapAd.Checked) { dataGridView1.DataSource = DoxaKutuphaneDAL.Facade.Kitap.KitapGetir(ktp.KitapAd, 0, 0, 0); } else if (chkYayinEvi.Checked) { dataGridView1.DataSource = DoxaKutuphaneDAL.Facade.Kitap.KitapGetir("", 0, 0, yyn.YayinEviId); } else if (chkYazarAd.Checked) { dataGridView1.DataSource = DoxaKutuphaneDAL.Facade.Kitap.KitapGetir("", 0, yzr.YazarId, 0); } else { MessageBox.Show("Belanı Arıyosun BAK !!!"); } }
private void btnYazarEkle_Click(object sender, EventArgs e) { DoxaKutuphaneDAL.Entity.YayinEvi y = (DoxaKutuphaneDAL.Entity.YayinEvi)cmbYazarYynEvEkle.SelectedItem; bool kontrol = DoxaKutuphaneDAL.Facade.Yazar.YazarEkle(txtYazarAdEkle.Text, txtYazarSoyadEkle.Text, y.YayinEviId); if (kontrol) { MessageBox.Show("Mission is successful!"); } else { MessageBox.Show("There is a Problem!"); } }
private void btnYayinEvSil_Click(object sender, EventArgs e) { DoxaKutuphaneDAL.Entity.YayinEvi y = (DoxaKutuphaneDAL.Entity.YayinEvi)cmbYayinEvSil.SelectedItem; bool kontrol = DoxaKutuphaneDAL.Facade.YayinEvi.YayinEviSil(y.YayinEviId); if (kontrol) { MessageBox.Show("Yayın Evi Başarıyla silinmiştir"); } else { MessageBox.Show("Yayın Evi Silinemedi!"); } ComboDoldur(); cmbYayinEvSil.Text = ""; }
private void btnKitapEkle_Click(object sender, EventArgs e) { DoxaKutuphaneDAL.Entity.Kategori k = (DoxaKutuphaneDAL.Entity.Kategori)cmbKtgrAdEkleKtp.SelectedItem; DoxaKutuphaneDAL.Entity.YayinEvi yyn = (DoxaKutuphaneDAL.Entity.YayinEvi)cmbYynEvAdEkleKtp.SelectedItem; DoxaKutuphaneDAL.Entity.Yazar yzr = (DoxaKutuphaneDAL.Entity.Yazar)cmbYzrAdEkleKtp.SelectedItem; bool kontrol = DoxaKutuphaneDAL.Facade.Kitap.KitapEkle(txtKitapAdEkle.Text, k.KategoriId, yzr.YazarId, yyn.YayinEviId); if (kontrol) { MessageBox.Show("Mission is successful!"); } else { MessageBox.Show("There is a Problem!"); } }
public void YayinEviDoldur() { cmbYynEvAdEkleKtp.Items.Clear(); SqlCommand com = new SqlCommand("select * from YayinEvi", con); DoxaMethodsDAL.Facade.Connection.ConOpen(con); SqlDataReader dr = com.ExecuteReader(); while (dr.Read()) { DoxaKutuphaneDAL.Entity.YayinEvi y = new DoxaKutuphaneDAL.Entity.YayinEvi(); y.YayinEviId = Convert.ToInt32(dr["YayinEviId"]); y.YayinEviAd = dr["YayinEviAd"].ToString(); y.YayinEviAdres = Convert.ToString(dr["Adres"]); cmbYynEvAdEkleKtp.Items.Add(y); } DoxaMethodsDAL.Facade.Connection.ConClose(con); dr.Close(); }