private void btnGoBack_Click(object sender, EventArgs e) { frmMasalar form_Masalar = new frmMasalar(); form_Masalar.Show(); this.Hide(); }
} // Hesap Kaydı butonu private void btnTables_Click(object sender, EventArgs e) { frmMasalar form_Masalar = new frmMasalar(); form_Masalar.Show(); this.Hide(); } // Masalar butonu
private void btnGoBack_Click(object sender, EventArgs e) { frmMasalar main = new frmMasalar(); main.Show(); this.Hide(); }
private void btnPay_Click(object sender, EventArgs e) { int Day = DateTime.Now.Day; int Month = DateTime.Now.Month; int Year = DateTime.Now.Year; int Hour = DateTime.Now.Hour; int Minute = DateTime.Now.Minute; int Second = DateTime.Now.Second; string Date = Day + "." + Month + "." + Year + " " + Hour + ":" + Minute + ":" + Second; //AraToplam = Math.Round(AraToplam, 2, MidpointRounding.AwayFromZero); //KDVTutari = Math.Round(KDVTutari, 2, MidpointRounding.AwayFromZero); //IndirimTutari = Math.Round(IndirimTutari, 2, MidpointRounding.AwayFromZero); //ToplamTutar = Math.Round(ToplamTutar, 2, MidpointRounding.AwayFromZero); cmd = new OleDbCommand(); cmd.Connection = con; cmd.CommandText = "INSERT INTO HesapHareketleri(PersonelKodu,OdemeTuruKodu,AraToplam,KdvTutari,Indirim,ToplamTutar,Tarih) VALUES(@PK,@OTK,@AT,@KDV,@DIS,@TT,@Tarih)"; if (con.State == ConnectionState.Closed) { con.Open(); } cmd.Parameters.AddWithValue("@PK", frmLogin.PersonelKodu); cmd.Parameters.AddWithValue("@OTK", int.Parse(cbPayType.SelectedValue.ToString())); cmd.Parameters.AddWithValue("@AT", Math.Round((double)AraToplam, 2)); cmd.Parameters.AddWithValue("@KDV", Math.Round((double)KDVTutari, 2)); cmd.Parameters.AddWithValue("@DIS", Math.Round((double)IndirimTutari, 2)); cmd.Parameters.AddWithValue("@TT", Math.Round((double)ToplamTutar, 2)); cmd.Parameters.AddWithValue("@Tarih", Date); cmd.ExecuteNonQuery(); if (Indirim) { cmd = new OleDbCommand(); cmd.Connection = con; cmd.CommandText = "DELETE FROM IndirimKodlari WHERE Kod=@Kod"; cmd.Parameters.AddWithValue("@Kod", IndirimKodu); cmd.ExecuteNonQuery(); } cmd = new OleDbCommand(); cmd.Connection = con; cmd.CommandText = "DELETE FROM Adisyon WHERE MasaKodu=@mkodu"; cmd.Parameters.AddWithValue("@mkodu", MasaKodu); cmd.ExecuteNonQuery(); cmd = new OleDbCommand(); cmd.Connection = con; cmd.CommandText = "UPDATE Masalar SET Durum=1 WHERE MasaKodu=@mkodu"; cmd.Parameters.AddWithValue("@mkodu", MasaKodu); cmd.ExecuteNonQuery(); cmd = new OleDbCommand(); cmd.Connection = con; cmd.CommandText = "INSERT INTO PersonelHareketleri(PersonelKodu,Islem,Tarih) VALUES(@pkodu,@islem,@tarih)"; cmd.Parameters.AddWithValue("@pkodu", frmLogin.PersonelKodu); cmd.Parameters.AddWithValue("@islem", MasaNumarasi + " Numaralı masanın ödemesini gerçekleştirdi."); cmd.Parameters.AddWithValue("@tarih", Date); cmd.ExecuteNonQuery(); MessageBox.Show("Ödeme işlemi başarıyla tamamlandı ve kayıtlara işlendi.", "Bilgi"); frmMasalar form_Masalar = new frmMasalar(); form_Masalar.Show(); this.Hide(); }
private void btnSwap_Click(object sender, EventArgs e) { if (rbBos.Checked) { if (con.State == ConnectionState.Closed) { con.Open(); } cmd = new OleDbCommand(); cmd.Connection = con; cmd.CommandText = "UPDATE Adisyon SET MasaKodu=@ymkodu WHERE MasaKodu=@mkodu"; cmd.Parameters.AddWithValue("@ymkodu", lbSecondTable.SelectedValue); cmd.Parameters.AddWithValue("@mkodu", lbFirstTable.SelectedValue); cmd.ExecuteNonQuery(); cmd = new OleDbCommand(); cmd.Connection = con; cmd.CommandText = "UPDATE Masalar SET Durum=1 WHERE MasaKodu=@mkodu"; cmd.Parameters.AddWithValue("@mkodu", lbFirstTable.SelectedValue); cmd.ExecuteNonQuery(); cmd = new OleDbCommand(); cmd.Connection = con; cmd.CommandText = "UPDATE Masalar SET Durum=2 WHERE MasaKodu=@mkodu"; cmd.Parameters.AddWithValue("@mkodu", lbSecondTable.SelectedValue); cmd.ExecuteNonQuery(); MessageBox.Show("Masa " + lbFirstTable.Text + ", Masa " + lbSecondTable.Text + "'ye taşınmıştır.", "Bilgi"); frmMasalar frm = new frmMasalar(); frm.Show(); this.Hide(); } else if (rbDolu.Checked) { if (con.State == ConnectionState.Closed) { con.Open(); } cmd = new OleDbCommand(); cmd.Connection = con; cmd.CommandText = "INSERT INTO MasaTasima SELECT * FROM Adisyon WHERE MasaKodu=@mkodu"; cmd.Parameters.AddWithValue("@mkodu", lbFirstTable.SelectedValue); cmd.ExecuteNonQuery(); cmd = new OleDbCommand(); cmd.Connection = con; cmd.CommandText = "DELETE FROM Adisyon WHERE MasaKodu=@mkodu"; cmd.Parameters.AddWithValue("@mkodu", lbFirstTable.SelectedValue); cmd.ExecuteNonQuery(); cmd = new OleDbCommand(); cmd.Connection = con; cmd.CommandText = "UPDATE Adisyon SET MasaKodu=@ymkodu WHERE MasaKodu=@mkodu"; cmd.Parameters.AddWithValue("@ymkodu", lbFirstTable.SelectedValue); cmd.Parameters.AddWithValue("@mkodu", lbSecondTable.SelectedValue); cmd.ExecuteNonQuery(); cmd = new OleDbCommand(); cmd.Connection = con; cmd.CommandText = "UPDATE MasaTasima SET MasaKodu=@ymkodu WHERE MasaKodu=@mkodu"; cmd.Parameters.AddWithValue("@ymkodu", lbSecondTable.SelectedValue); cmd.Parameters.AddWithValue("@mkodu", lbFirstTable.SelectedValue); cmd.ExecuteNonQuery(); cmd = new OleDbCommand(); cmd.Connection = con; cmd.CommandText = "INSERT INTO Adisyon SELECT * FROM MasaTasima WHERE MasaKodu=@mkodu"; cmd.Parameters.AddWithValue("@mkodu", lbSecondTable.SelectedValue); cmd.ExecuteNonQuery(); cmd = new OleDbCommand(); cmd.Connection = con; cmd.CommandText = "DELETE FROM MasaTasima WHERE MasaKodu=@mkodu"; cmd.Parameters.AddWithValue("@mkodu", lbSecondTable.SelectedValue); cmd.ExecuteNonQuery(); MessageBox.Show("Masa " + lbFirstTable.Text + " ile Masa " + lbSecondTable.Text + " değiştirilmiştir.", "Bilgi"); frmMasalar frm = new frmMasalar(); frm.Show(); this.Hide(); } }