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