private void frmSiparis_Load(object sender, EventArgs e) { lblMasaNo.Text = cGenel._ButtonValue; cMasalar ms = new cMasalar(); tableId = ms.TableGetByNumber(cGenel._ButtonValue); if (ms.TableGetByState(tableId, 2) == true || ms.TableGetByState(tableId, 4) == true) { cAdisyon Ad = new cAdisyon(); AdditionId = Ad.getByAddition(tableId); cSiparis orders = new cSiparis(); orders.getByOrder(lvSiparisler, AdditionId); } btn1.Click += new EventHandler(islem); btn2.Click += new EventHandler(islem); btn3.Click += new EventHandler(islem); btnn4.Click += new EventHandler(islem); btn5.Click += new EventHandler(islem); btn6.Click += new EventHandler(islem); btn7.Click += new EventHandler(islem); btn8.Click += new EventHandler(islem); btn9.Click += new EventHandler(islem); btn0.Click += new EventHandler(islem); }
public bool setSaveOrder(cSiparis Bilgiler) { bool sonuc = false; NpgsqlConnection con = new NpgsqlConnection(gnl.connString); NpgsqlCommand cmd = new NpgsqlCommand("Insert Into \"Satislar\"(\"ADISYONID\",\"URUNID\",\"ADET\",\"MASAID\") values (@AdisyonNo, @UrunId, @Adet, @masaId", con); try { if (con.State == ConnectionState.Closed) { con.Open(); } cmd.Parameters.AddWithValue("@AdisyonNo", SqlDbType.Int).Value = Bilgiler._adisyonID; cmd.Parameters.AddWithValue("@UrunId", SqlDbType.Int).Value = Bilgiler._urunId; cmd.Parameters.AddWithValue("@Adet", SqlDbType.Int).Value = Bilgiler._adet; cmd.Parameters.AddWithValue("@masaId", SqlDbType.Int).Value = Bilgiler._masaId; sonuc = Convert.ToBoolean(cmd.ExecuteNonQuery()); } catch (SqlException ex) { string hata = ex.Message; } finally { con.Dispose(); con.Close(); } return(sonuc); }
private void btnSiparis_Click(object sender, EventArgs e) { cMasalar masa = new cMasalar(); frmMasalar ms = new frmMasalar(); cAdisyon newAddition = new cAdisyon(); cSiparis saveOrder = new cSiparis(); bool sonuc = false; if (masa.TableGetByState(tableId, 1) == true) { newAddition.ServisTurNo = 1; newAddition.PersonelId1 = 1; newAddition.MasaId = tableId; newAddition.Tarih = DateTime.Now; sonuc = newAddition.setByAdditionel(newAddition); masa.setChangeTableState(cGenel._ButtonName, 2); if (lvSiparisler.Items.Count > 0) { for (int i = 0; i < lvSiparisler.Items.Count; i++) { saveOrder.MasaId = tableId; saveOrder.UrunId = Convert.ToInt32(lvSiparisler.Items[i].SubItems[2].Text); saveOrder.AdisyonID = newAddition.getByAddition(tableId); saveOrder.Adet = Convert.ToInt32(lvSiparisler.Items[i].SubItems[1].Text); saveOrder.setSaveOrder(saveOrder); } this.Close(); ms.Show(); } } else if (masa.TableGetByState(tableId, 2) == true) { if (lvYeniEklenenler.Items.Count > 0) { for (int i = 0; i < lvYeniEklenenler.Items.Count; i++) { saveOrder.MasaId = tableId; saveOrder.UrunId = Convert.ToInt32(lvYeniEklenenler.Items[i].SubItems[1].Text); saveOrder.UrunId = newAddition.getByAddition(tableId); saveOrder.UrunId = Convert.ToInt32(lvYeniEklenenler.Items[i].SubItems[2].Text); saveOrder.setSaveOrder(saveOrder); } } if (silinenler.Count > 0) { foreach (string item in silinenler) { saveOrder.setDeleteOrder(Convert.ToInt32(item)); } } this.Close(); ms.Show(); } }
private void lvSiparisler_DoubleClick(object sender, EventArgs e) { if (lvSiparisler.Items.Count > 0) { if (lvSiparisler.SelectedItems[0].SubItems[4].Text != "0") { cSiparis saveorder = new cSiparis(); saveorder.setDeleteOrder(Convert.ToInt32(lvSiparisler.Items[0].SubItems[4].Text)); } else { for (int i = 0; i < lvYeniEklenenler.Items.Count; i++) { if (lvYeniEklenenler.Items[i].SubItems[4].Text == lvSiparisler.SelectedItems[0].SubItems[5].Text) { lvYeniEklenenler.Items.RemoveAt(i); } } } lvSiparisler.Items.RemoveAt(lvSiparisler.SelectedItems[0].Index); } }