private void gridK() { ; txtSil.Text = ""; lvKategori.Items.Clear(); cBaglanti bgl = new cBaglanti(); MySqlConnection con = new MySqlConnection(bgl.baglanti); MySqlCommand cmd1 = new MySqlCommand("select * from kategori", con); con.Open(); MySqlDataReader dr1 = cmd1.ExecuteReader(); while (dr1.Read()) { cmb1.Items.Add(dr1["adi"]); } con.Close(); MySqlCommand cmd = new MySqlCommand("select * from kategori", con); con.Open(); MySqlDataReader dr = cmd.ExecuteReader(); while (dr.Read()) { ListViewItem item = new ListViewItem(dr["adi"].ToString()); lvKategori.Items.Add(item); } con.Close(); }
private void btnEkle_Click(object sender, EventArgs e) { cBaglanti bgl = new cBaglanti(); //cBilgilendirme tab = new cBilgilendirme(); cUrunler urun = new cUrunler(); MySqlConnection con = new MySqlConnection(bgl.baglanti); con.Open(); for (int i = 0; i < Convert.ToInt32(ndAdet.Value); i++) { string no = lvUrunler.SelectedItems[0].SubItems[0].Text; string adi = lvUrunler.SelectedItems[0].SubItems[1].Text; string fiyati = lvUrunler.SelectedItems[0].SubItems[2].Text; MySqlCommand kmt = new MySqlCommand("insert into siparis(masa_id,urun_id) values(" + cBilgilendirme._buttonId + "," + no + ")", con); kmt.ExecuteNonQuery(); string[] row = { no, adi, fiyati }; ListViewItem item = new ListViewItem(row); lvSiparis.Items.Add(item); } txtUrun.Text = ""; ndAdet.Value = 1; tutar(); }
private void btnSHesap_Click(object sender, EventArgs e) { cBaglanti bgl = new cBaglanti(); MySqlConnection con = new MySqlConnection(bgl.baglanti); float Ttl = 0; for (int i = 0; i < lvSiparis.Items.Count; i++) { if (lvSiparis.Items[i].Checked) { MySqlCommand cmdTtl = new MySqlCommand("select u.fiyati from urunler u, siparis s where s.masa_id=" + cBilgilendirme._buttonId + " and u.id=s.urun_id and u.id=" + lvSiparis.Items[i].SubItems[0].Text, con); con.Open(); Ttl += Convert.ToSingle((cmdTtl.ExecuteScalar().ToString()).Replace('.', ',')); con.Close(); MySqlCommand cmdDelete = new MySqlCommand("delete from siparis where masa_id=" + cBilgilendirme._buttonId + " and urun_id=" + lvSiparis.Items[i].SubItems[0].Text + " order by urun_id limit 1 ", con); con.Open(); cmdDelete.ExecuteNonQuery(); con.Close(); } } hTarih(Ttl); lvSiparis.Items.Clear(); grid(); }
private void cmbKatagori_SelectedIndexChanged(object sender, EventArgs e) { lvUrunler.Items.Clear(); cBaglanti bgl = new cBaglanti(); MySqlConnection connet = new MySqlConnection(bgl.baglanti); MySqlCommand kmt = new MySqlCommand("select * from urunler where kId=" + (cmbKatagori.SelectedItem as cKategori).Id + "", connet); List <cUrunler> urn = new List <cUrunler>(); connet.Open(); MySqlDataReader drUrunler = kmt.ExecuteReader(); while (drUrunler.Read()) { ListViewItem item = new ListViewItem(drUrunler["id"].ToString()); item.SubItems.Add(drUrunler["adi"].ToString()); item.SubItems.Add(drUrunler["fiyati"].ToString()); lvUrunler.Items.Add(item); cUrunler urun = new cUrunler(); urun.Id = Convert.ToInt32(drUrunler["id"]); urun.kId = Convert.ToInt32(drUrunler["kId"]); urun.Adi = drUrunler["adi"].ToString(); urun.fiyat = Convert.ToSingle(drUrunler["fiyati"]); urn.Add(urun); } }
private void getir() { string gun = dateTimePicker1.Value.ToString("dd"); string ay = dateTimePicker1.Value.ToString("MM"); string yil = dateTimePicker1.Value.ToString("yyyy"); DateTime dt = DateTime.Now; string gun1 = dt.Day + ""; string ay1 = dt.Month + ""; string yil1 = dt.Year + ""; lvHesap.Items.Clear(); cBaglanti bgl = new cBaglanti(); MySqlConnection con = new MySqlConnection(bgl.baglanti); MySqlCommand cmdgetir = new MySqlCommand("select * from hesap where gun=" + gun + " and ay=" + ay + " and yil=" + yil, con); con.Open(); MySqlDataReader dr = cmdgetir.ExecuteReader(); while (dr.Read()) { ListViewItem item = new ListViewItem(dr["Total"].ToString()); string saat = dr["saat"].ToString(); string dakika = dr["dakika"].ToString(); string saniye = dr["saniye"].ToString(); item.SubItems.Add(saat + ":" + dakika + ":" + saniye); lvHesap.Items.Add(item); } con.Close(); MySqlCommand cmdgun1 = new MySqlCommand("select sum(Total) from hesap where gun=" + gun1 + " and ay=" + ay1 + " and yil=" + yil1, con); con.Open(); lblGK.Text = cmdgun1.ExecuteScalar().ToString(); con.Close(); MySqlCommand cmday1 = new MySqlCommand("select sum(Total) from hesap where ay=" + ay1 + " and yil=" + yil1, con); con.Open(); lblAK.Text = cmday1.ExecuteScalar().ToString(); con.Close(); MySqlCommand cmdyil1 = new MySqlCommand("select sum(Total) from hesap where yil=" + yil1, con); con.Open(); lblYK.Text = cmdyil1.ExecuteScalar().ToString(); con.Close(); MySqlCommand cmdsgun = new MySqlCommand("select sum(Total) from hesap where gun=" + gun + " and ay=" + ay + " and yil=" + yil, con); con.Open(); lblSGK.Text = cmdsgun.ExecuteScalar().ToString(); con.Close(); MySqlCommand cmdsay = new MySqlCommand("select sum(Total) from hesap where ay=" + ay + " and yil=" + yil, con); con.Open(); lblSAK.Text = cmdsay.ExecuteScalar().ToString(); con.Close(); MySqlCommand cmdsyil = new MySqlCommand("select sum(Total) from hesap where yil=" + yil, con); con.Open(); lblSYK.Text = cmdsyil.ExecuteScalar().ToString(); con.Close(); }
private void btnGEkle_Click(object sender, EventArgs e) { cBaglanti bgl = new cBaglanti(); MySqlConnection con = new MySqlConnection(bgl.baglanti); MySqlCommand cmd = new MySqlCommand("insert into kategori(adi) values('" + txtKategori.Text + "')", con); con.Open(); cmd.ExecuteNonQuery(); gridK(); }
private void btnGSil_Click(object sender, EventArgs e) { cBaglanti bgl = new cBaglanti(); MySqlConnection con = new MySqlConnection(bgl.baglanti); MySqlCommand cmd = new MySqlCommand("delete from kategori where adi='" + txtSil.Text + "'", con); con.Open(); cmd.ExecuteNonQuery(); gridK(); }
private void btnKGuncelle_Click(object sender, EventArgs e) { cBaglanti bgl = new cBaglanti(); MySqlConnection con = new MySqlConnection(bgl.baglanti); MySqlCommand cmd = new MySqlCommand("update kategori set adi='" + txtKategori.Text + "' where adi='" + txtSil.Text + "'", con); con.Open(); cmd.ExecuteNonQuery(); gridK(); }
private string cozum(string a) { cBaglanti bgl = new cBaglanti(); MySqlConnection con = new MySqlConnection(bgl.baglanti); MySqlCommand cmd = new MySqlCommand("select * from kategori where Id=" + a, con); con.Open(); MySqlDataReader dr = cmd.ExecuteReader(); while (dr.Read()) { a = dr["adi"].ToString(); } con.Close(); return(a); }
private void btnSil_Click(object sender, EventArgs e) { cBaglanti bgl = new cBaglanti(); MySqlConnection con = new MySqlConnection(bgl.baglanti); MySqlCommand cmd = new MySqlCommand("select id from kategori where adi='" + cmb1.SelectedItem + "'", con); con.Open(); string id = cmd.ExecuteReader().ToString(); con.Close(); MySqlCommand cmd1 = new MySqlCommand("delete from urunler where adi='" + txtAd2.Text + "' and fiyati='" + txtfiyat2.Text + "' and kId='" + id + "'", con); con.Open(); cmd1.ExecuteNonQuery(); gridU(); }
private void gridU() { lvUrunler.Items.Clear(); cBaglanti bgl = new cBaglanti(); MySqlConnection con = new MySqlConnection(bgl.baglanti); MySqlCommand kmt = new MySqlCommand("select * from kategori", con); List <cKategori> ktgr = new List <cKategori>(); con.Open(); MySqlDataReader drKategori = kmt.ExecuteReader(); while (drKategori.Read()) { cKategori kt = new cKategori(); kt.Id = Convert.ToInt32(drKategori["Id"]); kt.adi = drKategori["adi"].ToString(); ktgr.Add(kt); } con.Close(); MySqlCommand cmd = new MySqlCommand("select * from urunler", con); con.Open(); MySqlDataReader dr = cmd.ExecuteReader(); while (dr.Read()) { ListViewItem item = new ListViewItem(dr["id"].ToString()); item.SubItems.Add(dr["adi"].ToString()); item.SubItems.Add(dr["fiyati"].ToString()); item.SubItems.Add(cozum(dr["kId"].ToString())); //int a = Convert.ToInt32(dr["kId"]); //con.Close(); //MySqlCommand cmda = new MySqlCommand("select adi from kategori where Id=" + a, con); //con.Open(); //MySqlDataReader dra = cmda.ExecuteReader(); //con.Close(); //string b = dra.ToString(); //item.SubItems.Add(b); lvUrunler.Items.Add(item); } con.Close(); }
private void tutar() { cBaglanti bgl = new cBaglanti(); MySqlConnection con = new MySqlConnection(bgl.baglanti); cTable masa = new cTable(); MySqlCommand cmd = new MySqlCommand("select SUM(u.fiyati) from urunler u, siparis s where s.masa_id=" + cBilgilendirme._buttonId + " and u.id=s.urun_id ", con); con.Open(); label2.Text = cmd.ExecuteScalar() + "₺"; double total = 0; for (int i = 0; i < lvSiparis.Items.Count; i++) { if (lvSiparis.Items[i].Checked) { total += Convert.ToDouble((lvSiparis.Items[i].SubItems[2].Text).Replace(".", ",")); } } label4.Text = total + "₺"; }
private void grid() { if (this.InvokeRequired) { this.Invoke(new DelegateStandardPattern(grid)); } else { tutar(); label2.Text = "0₺"; lblMasa.Text = cBilgilendirme._buttonText; cBaglanti bgl = new cBaglanti(); MySqlConnection connet = new MySqlConnection(bgl.baglanti); MySqlCommand kmt = new MySqlCommand("select * from kategori", connet); List <cKategori> ktgr = new List <cKategori>(); connet.Open(); MySqlDataReader drKategori = kmt.ExecuteReader(); while (drKategori.Read()) { cKategori kt = new cKategori(); kt.Id = Convert.ToInt32(drKategori["Id"]); kt.adi = drKategori["adi"].ToString(); ktgr.Add(kt); } cmbKatagori.DataSource = ktgr; cmbKatagori.DisplayMember = "adi"; connet.Close(); MySqlCommand cmd = new MySqlCommand("select u.id,u.adi,u.fiyati from urunler u, siparis s where s.masa_id=" + cBilgilendirme._buttonId + " and u.id=s.urun_id ", connet); connet.Open(); MySqlDataReader dr = cmd.ExecuteReader(); while (dr.Read()) { ListViewItem item = new ListViewItem(dr["id"].ToString()); item.SubItems.Add(dr["adi"].ToString()); item.SubItems.Add(dr["fiyati"].ToString()); lvSiparis.Items.Add(item); } tutar(); } }
private void hTarih(float Ttl) { cBaglanti bgl = new cBaglanti(); MySqlConnection baglanti = new MySqlConnection(bgl.baglanti); DateTime tarh = DateTime.Now; int gun = tarh.Day; int ay = tarh.Month; int yil = tarh.Year; int saat = tarh.Hour; int dakika = tarh.Minute; int saniye = tarh.Second; MySqlCommand kmtIns = new MySqlCommand("ınsert into hesap(Total,gun,ay,yil,saat,dakika,saniye) values(@ttl," + gun + "," + ay + "," + yil + "," + saat + "," + dakika + "," + saniye + ")", baglanti); kmtIns.Parameters.Add("@ttl", MySqlDbType.Float); kmtIns.Parameters["@ttl"].Value = Ttl; baglanti.Open(); kmtIns.ExecuteNonQuery(); baglanti.Close(); }
private void btnEkle_Click(object sender, EventArgs e) { cBaglanti bgl = new cBaglanti(); MySqlConnection con = new MySqlConnection(bgl.baglanti); MySqlCommand cmd = new MySqlCommand("select * from kategori where adi='" + cmb1.SelectedItem + "'", con); con.Open(); MySqlDataReader dr = cmd.ExecuteReader(); string id = ""; while (dr.Read()) { id = dr["id"].ToString(); } con.Close(); MySqlCommand cmd1 = new MySqlCommand("insert into urunler(kId,adi,fiyati) values('" + id + "','" + txtAd1.Text + "','" + txtfiyat1.Text + "')", con); con.Open(); cmd1.ExecuteNonQuery(); con.Close(); gridU(); }
private void btnHesap_Click(object sender, EventArgs e) { cBaglanti bgl = new cBaglanti(); MySqlConnection baglanti = new MySqlConnection(bgl.baglanti); MySqlCommand kmtTtl = new MySqlCommand("select sum(u.fiyati) from urunler u, siparis s where s.masa_id=" + cBilgilendirme._buttonId + " and u.id=s.urun_id", baglanti); baglanti.Open(); float Ttl = Convert.ToSingle(kmtTtl.ExecuteScalar()); baglanti.Close(); hTarih(Ttl); MySqlCommand kmtdel = new MySqlCommand("delete from siparis where masa_id=" + cBilgilendirme._buttonId, baglanti); baglanti.Open(); kmtdel.ExecuteNonQuery(); baglanti.Close(); lvSiparis.Items.Clear(); grid(); }
private void frmMasalar_Load(object sender, EventArgs e) { cBaglanti bgl = new cBaglanti(); Button[] btn = { btnMasa1, btnMasa2, btnMasa3, btnMasa4, btnMasa5, btnMasa6, btnMasa7, btnMasa8, btnMasa9, btnMasa10, btnMasa11, btnMasa12, btnMasa13, btnMasa14, btnMasa15 }; MySqlConnection con = new MySqlConnection(bgl.baglanti); for (int i = 0; i < 15; i++) { MySqlCommand cmd = new MySqlCommand("select * from siparis where masa_id=" + i + "", con); con.Open(); MySqlDataReader drCmd = cmd.ExecuteReader(); if (drCmd.Read()) { btn[i].BackColor = Color.Green; } else { btn[i].BackColor = Color.Red; } con.Close(); } MySqlCommand cmdm = new MySqlCommand("select * from masalar", con); con.Open(); MySqlDataReader dr = cmdm.ExecuteReader(); List <cTable> tbl = new List <cTable>(); while (dr.Read()) { cTable masa = new cTable(); masa.Id = Convert.ToInt32(dr["id"]); masa.Adi = dr["adi"].ToString(); tbl.Add(masa); } }
private void btnGiris_Click(object sender, EventArgs e) { string name = txtName.Text; string pass = txtPass.Text; cBaglanti con = new cBaglanti(); MySqlConnection connect = new MySqlConnection(con.baglanti); MySqlCommand cmd = new MySqlCommand("select * from personel where pName='" + name + "' and pPass='******'", connect); connect.Open(); MySqlDataReader dr = cmd.ExecuteReader(); if (dr.Read()) { this.Hide(); frmLobi lobi = new frmLobi(); lobi.Show(); } else { MessageBox.Show("Hatalı Ad veya Şifre!"); } }