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