private void frmFilmEkle_Load(object sender, EventArgs e)
{
SqlCommand com = new SqlCommand("select * from kategori", con);
con.Open();
SqlDataReader dr = com.ExecuteReader();
while (dr.Read())
{
SinemaDAL.Entity.Kategori k = new SinemaDAL.Entity.Kategori();
k.KategoriId = Convert.ToInt32(dr["KategoriId"]);
k.KategoriAd = dr["KategoriAd"].ToString();
cmbKategori.Items.Add(k);
}
con.Close();
}
public void ComboDoldur()
{
cmbKategoriAra.Items.Clear();
SqlCommand com = new SqlCommand("select * from Kategori", con);
con.Open();
SqlDataReader dr = com.ExecuteReader();
while (dr.Read())
{
SinemaDAL.Entity.Kategori k = new SinemaDAL.Entity.Kategori();
k.KategoriId = Convert.ToInt32(dr["KategoriId"]);
k.KategoriAd = dr["KategoriAd"].ToString();
cmbKategoriAra.Items.Add(k);
cmbKategoriGunc.Items.Add(k);
}
con.Close();
}
private void button1_Click(object sender, EventArgs e)
{
SqlCommand com = new SqlCommand("KategoriSil", con);
com.CommandType = CommandType.StoredProcedure;
SinemaDAL.Entity.Kategori k = (SinemaDAL.Entity.Kategori)comboBox1.SelectedItem;
com.Parameters.AddWithValue("@id", k.KategoriId);
con.Open();
com.ExecuteNonQuery();
con.Close();
MessageBox.Show("Kategori Silindi");
ComboDoldur();
}
private void btnFilmAra_Click(object sender, EventArgs e)
{
if (chkKategoriAd.Checked)
{
listView1.Items.Clear();
SqlCommand com = new SqlCommand("FilmAraKategori", con);
com.CommandType = CommandType.StoredProcedure;
com.Parameters.AddWithValue("@KategoriId", ((SinemaDAL.Entity.Kategori)cmbKategoriAra.SelectedItem).KategoriId);
con.Open();
SqlDataReader dr = com.ExecuteReader();
while (dr.Read())
{
ListViewItem li = new ListViewItem();
SinemaDAL.Entity.Kategori k = new SinemaDAL.Entity.Kategori();
k.KategoriId = Convert.ToInt32(dr["KategoriId"]);
k.KategoriAd = dr["KategoriAd"].ToString();
li.SubItems.Add(k.KategoriAd);
SinemaDAL.Entity.Film f = new SinemaDAL.Entity.Film();
f.FilmAd = dr["FilmAd"].ToString();
f.FilmAciklama = dr["Aciklama"].ToString();
f.Sure = Convert.ToInt32(dr["Sure"]);
li.SubItems.Add(f.FilmAciklama);
li.SubItems.Add(f.Sure.ToString());
li.Tag = dr["FilmId"].ToString();
li.Text = f.FilmAd;
listView1.Items.Add(li);
}
con.Close();
}
else if (chkFilmAd.Checked)
{
listView1.Items.Clear();
SqlCommand com = new SqlCommand("FilmAraAd", con);
com.CommandType = CommandType.StoredProcedure;
com.Parameters.AddWithValue("@FilmAd", txtFilmAdiAra.Text);
con.Open();
SqlDataReader dr = com.ExecuteReader();
while (dr.Read())
{
ListViewItem li = new ListViewItem();
SinemaDAL.Entity.Kategori k = new SinemaDAL.Entity.Kategori();
k.KategoriId = Convert.ToInt32(dr["KategoriId"]);
k.KategoriAd = dr["KategoriAd"].ToString();
li.SubItems.Add(k.KategoriAd);
SinemaDAL.Entity.Film f = new SinemaDAL.Entity.Film();
f.FilmAd = dr["FilmAd"].ToString();
f.FilmAciklama = dr["Aciklama"].ToString();
f.Sure = Convert.ToInt32(dr["Sure"]);
li.SubItems.Add(f.FilmAciklama);
li.SubItems.Add(f.Sure.ToString());
li.Tag = dr["FilmId"].ToString();
li.Text = f.FilmAd;
listView1.Items.Add(li);
}
con.Close();
}
else if (chkFilmSure.Checked)
{
listView1.Items.Clear();
SqlCommand com = new SqlCommand("FilmAraSure", con);
com.CommandType = CommandType.StoredProcedure;
com.Parameters.AddWithValue("@Sure", txtFilmSuresiAra.Text);
con.Open();
SqlDataReader dr = com.ExecuteReader();
while (dr.Read())
{
ListViewItem li = new ListViewItem();
SinemaDAL.Entity.Kategori k = new SinemaDAL.Entity.Kategori();
k.KategoriId = Convert.ToInt32(dr["KategoriId"]);
k.KategoriAd = dr["KategoriAd"].ToString();
li.SubItems.Add(k.KategoriAd);
SinemaDAL.Entity.Film f = new SinemaDAL.Entity.Film();
f.FilmAd = dr["FilmAd"].ToString();
f.FilmAciklama = dr["Aciklama"].ToString();
f.Sure = Convert.ToInt32(dr["Sure"]);
li.SubItems.Add(f.FilmAciklama);
li.SubItems.Add(f.Sure.ToString());
li.Tag = dr["FilmId"].ToString();
li.Text = f.FilmAd;
listView1.Items.Add(li);
}
con.Close();
}
}
