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