public static Entity.Film FilmGetir(int id)
{
SqlConnection con = new SqlConnection("server=.;database=sinema;uid=sa;pwd=123");
SqlCommand com = new SqlCommand("prc_FilmGetirId", con);
com.CommandType = CommandType.StoredProcedure;
com.Parameters.AddWithValue("@FilmId", id);
con.Open();
SqlDataReader dr = com.ExecuteReader();
Entity.Film f = null;
while (dr.Read())
{
f = new SinemaDAL.Entity.Film();
f.FilmId = Convert.ToInt32(dr["FilmId"]);
f.FilmAd = dr["FilmAd"].ToString();
f.FilmAciklama = dr["Aciklama"].ToString();
f.KategoriId = Convert.ToInt32(dr["KategoriID"]);
f.Sure = Convert.ToInt32(dr["Sure"]);
}
dr.Close();
con.Close();
return(f);
}
public static ArrayList FilmGetir()
{
SqlConnection con = new SqlConnection("server=.;database=sinema;uid=sa;pwd=123");
SqlCommand com = new SqlCommand("prc_FilmGetir", con);
com.CommandType = CommandType.StoredProcedure;
ArrayList filmlistesi = new ArrayList();
con.Open();
SqlDataReader dr = com.ExecuteReader();
while (dr.Read())
{
Entity.Film f = new SinemaDAL.Entity.Film();
f.FilmId = Convert.ToInt32(dr["FilmId"]);
f.FilmAd = dr["FilmAd"].ToString();
f.FilmAciklama = dr["Aciklama"].ToString();
f.KategoriId = Convert.ToInt32(dr["KategoriID"]);
f.Sure = Convert.ToInt32(dr["Sure"]);
filmlistesi.Add(f);
}
dr.Close();
con.Close();
return(filmlistesi);
}
public void ComboDoldur()
{
cmbFilmSil.Items.Clear();
SqlCommand com = new SqlCommand("select * from Film ", con);
con.Open();
SqlDataReader dr = com.ExecuteReader();
while (dr.Read())
{
SinemaDAL.Entity.Film f = new SinemaDAL.Entity.Film();
f.FilmId = Convert.ToInt32(dr["FilmId"]);
f.FilmAd = dr["FilmAd"].ToString();
cmbFilmSil.Items.Add(f);
}
con.Close();
}
private void button1_Click(object sender, EventArgs e)
{
SqlCommand com = new SqlCommand("prc_FilmSil", con);
com.CommandType = CommandType.StoredProcedure;
SinemaDAL.Entity.Film f = (SinemaDAL.Entity.Film)cmbFilmSil.SelectedItem;
com.Parameters.AddWithValue("@FilmId", f.FilmId);
con.Open();
com.ExecuteNonQuery();
con.Close();
MessageBox.Show("Film 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();
}
}
