//public static DataTable TumKitaplariGetir()
//{
// SqlCommand com = new SqlCommand("select * from Kitap");
//}
public static ArrayList KitapGetir2(string pKitapAd, int pKategoriId, int pYazarId, int pYayinEviId)
{
SqlCommand com = new SqlCommand("KitapGetir", con);
com.CommandType = CommandType.StoredProcedure;
com.Parameters.AddWithValue("@KitapAd", pKitapAd);
com.Parameters.AddWithValue("@KategoriId", pKategoriId);
com.Parameters.AddWithValue("@YazarId", pYazarId);
com.Parameters.AddWithValue("@YayinEviId", pYayinEviId);
DoxaMethodsDAL.Facade.Connection.ConOpen(con);
ArrayList liste = new ArrayList();
SqlDataReader dr = com.ExecuteReader();
while (dr.Read())
{
DoxaKutuphaneDAL.Entity.Kitap k = new DoxaKutuphaneDAL.Entity.Kitap();
k.KitapAd = dr["KitapAd"].ToString();
k.KategoriId = Convert.ToInt32(dr["KategoriId"]);
k.YazarId = Convert.ToInt32(dr["YazarId"]);
k.YayinEviId = Convert.ToInt32(dr["YayinEviId"]);
liste.Add(k);
}
DoxaMethodsDAL.Facade.Connection.ConClose(con);
dr.Close();
return(liste);
}
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 !!!");
}
}
public void KitapDoldur()
{
cmbKitapAdAra.Items.Clear();
SqlCommand com = new SqlCommand("select * from Kitap", con);
DoxaMethodsDAL.Facade.Connection.ConOpen(con);
SqlDataReader dr = com.ExecuteReader();
while (dr.Read())
{
DoxaKutuphaneDAL.Entity.Kitap k = new DoxaKutuphaneDAL.Entity.Kitap();
k.KitapId = Convert.ToInt32(dr["KitapId"]);
k.KitapAd = dr["KitapAd"].ToString();
cmbKitapAdAra.Items.Add(k);
}
DoxaMethodsDAL.Facade.Connection.ConClose(con);
dr.Close();
}
