public bool FilmSatisAdetGuncelle(FilmSatis fs) { bool Sonuc = false; SqlCommand comm = new SqlCommand("Update FilmSatis set Adet=@Adet,BirimFiyat=@BirimFiyat Where SatisNo=@SatisNo", conn); comm.Parameters.Add("@Adet", SqlDbType.Int).Value = fs.Adet; comm.Parameters.Add("@SatisNo", SqlDbType.Int).Value = fs.SatisNo; comm.Parameters.Add("@BirimFiyat", SqlDbType.Money).Value = fs.BirimFiyat; if (conn.State == ConnectionState.Closed) { conn.Open(); } try { Sonuc = Convert.ToBoolean(comm.ExecuteNonQuery()); } catch (SqlException ex) { string hata = ex.Message; } finally { conn.Close(); } return(Sonuc); }
public bool SatisKaydet(FilmSatis fs) { bool Sonuc = false; SqlCommand comm = new SqlCommand("Insert into FilmSatis (Tarih,FilmNo,MusteriNo,Adet,BirimFiyat) values(@Tarih,@FilmNo,@MusteriNo,@Adet,@BirimFiyat)", conn); comm.Parameters.Add("@Tarih", SqlDbType.DateTime).Value = fs.Tarih; comm.Parameters.Add("@FilmNo", SqlDbType.Int).Value = fs.FilmNo; comm.Parameters.Add("@MusteriNo", SqlDbType.Int).Value = fs.MusteriNo; comm.Parameters.Add("@Adet", SqlDbType.Int).Value = fs.Adet; comm.Parameters.Add("@BirimFiyat", SqlDbType.Money).Value = fs.BirimFiyat; if (conn.State == ConnectionState.Closed) { conn.Open(); } try { Sonuc = Convert.ToBoolean(comm.ExecuteNonQuery()); } catch (SqlException e) { string mesaj = e.Message; } finally { conn.Close(); } return(Sonuc); }
public bool SatisSil(FilmSatis fs) { bool Sonuc = false; SqlCommand comm = new SqlCommand("Update FilmSatis set Silindi=1 Where SatisNo=@SatisNo", conn); comm.Parameters.Add("@SatisNo", SqlDbType.Int).Value = fs.SatisNo; if (conn.State == ConnectionState.Closed) { conn.Open(); } try { Sonuc = Convert.ToBoolean(comm.ExecuteNonQuery()); } catch (SqlException ex) { string hata = ex.Message; } finally { conn.Close(); } return(Sonuc); }
private void frmFilmSatis_Load(object sender, EventArgs e) { this.Top = 0; this.Left = 0; txtTarih.Text = DateTime.Now.ToShortDateString(); FilmSatis fs = new Model.FilmSatis(); fs.SatislariGoster(lvSatislar, txtToplamAdet, txtToplamTutar); }