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