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