private void frmSiparis_Load(object sender, EventArgs e) { this.WindowState = System.Windows.Forms.FormWindowState.Maximized; lblMasaNo.Text = cGenel._ButtonValue; cMasalar ms = new cMasalar(); TableId = ms.TableGetByNumber(cGenel._ButtonName); if (ms.TableGetByState(TableId, 2) == 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); btn4.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); // ms.MasalariDurumaGoreGetir(cbMasalar); }
private void button2_Click(object sender, EventArgs e) { if (MessageBox.Show("Masayı Silmek İstediğinizden Emin Misiniz?", "Dikkat!", MessageBoxButtons.YesNo, MessageBoxIcon.Warning) == DialogResult.Yes) { cAdisyon a = new cAdisyon(); a.AdisyonuSil(Convert.ToInt32(lblAdisyonId.Text)); cMasalar cms = new cMasalar(); int masaid = masalar.TableGetByNumber(cGenel._ButtonName); cms.MasaDurumuDegistir(masaid); this.Close(); frmMasalar frm = new frmMasalar(); frm.Show(); } }
private void frmMasalar_Load(object sender, EventArgs e) { this.WindowState = System.Windows.Forms.FormWindowState.Maximized; SqlConnection con = new SqlConnection(gnl.conString); SqlCommand cmd = new SqlCommand("Select DURUM,ID from MASALAR", con); SqlDataReader dr = null; if (con.State == ConnectionState.Closed) { con.Open(); } dr = cmd.ExecuteReader(); while (dr.Read()) { foreach (Control item in this.Controls) { if (item is Button) { if (Convert.ToInt32(dr["ID"]) < 10) { if (item.Name == "btnMasa0" + dr["ID"].ToString() && dr["DURUM"].ToString() == "1") { item.BackgroundImage = (System.Drawing.Image)(Properties.Resources.yesil); } else if (item.Name == "btnMasa0" + dr["ID"].ToString() && dr["DURUM"].ToString() == "2") { cMasalar ms = new cMasalar(); //DateTime dt1 = Convert.ToDateTime(ms.SessionSum()); //DateTime dt2 = DateTime.Now; //string st1 = Convert.ToDateTime(ms.SessionSum(1)).ToShortTimeString(); //string st2 = DateTime.Now.ToShortTimeString(); //DateTime t1 = dt1.AddMinutes(DateTime.Parse(st1).TimeOfDay.TotalMinutes); //DateTime t2 = dt2.AddMinutes(DateTime.Parse(st2).TimeOfDay.TotalMinutes); //var fark = t2 - t1; //item.Text = String.Format("{0}{1}{2}", // fark.Days > 0 ? string.Format("{0}G.", fark.Days) : " ", // fark.Hours > 0 ? string.Format("{0}S.", fark.Hours) : " ", // fark.Minutes > 0 ? string.Format("{0}Dk.", fark.Minutes) : "").Trim() + "\nMasa" + dr["ID"].ToString(); item.BackgroundImage = (System.Drawing.Image)(Properties.Resources.kirmizi); } } else if (Convert.ToInt32(dr["ID"]) >= 10) { if (item.Name == "btnMasa" + dr["ID"].ToString() && dr["DURUM"].ToString() == "1") { item.BackgroundImage = (System.Drawing.Image)(Properties.Resources.yesil); } else if (item.Name == "btnMasa" + dr["ID"].ToString() && dr["DURUM"].ToString() == "2") { cMasalar ms = new cMasalar(); //DateTime dt1 = Convert.ToDateTime(ms.SessionSum()); //DateTime dt2 = DateTime.Now; //string st1 = Convert.ToDateTime(ms.SessionSum(1)).ToShortTimeString(); //string st2 = DateTime.Now.ToShortTimeString(); //DateTime t1 = dt1.AddMinutes(DateTime.Parse(st1).TimeOfDay.TotalMinutes); //DateTime t2 = dt2.AddMinutes(DateTime.Parse(st2).TimeOfDay.TotalMinutes); //var fark = t2 - t1; //item.Text = String.Format("{0}{1}{2}", // fark.Days > 0 ? string.Format("{0}G.", fark.Days) : " ", // fark.Hours > 0 ? string.Format("{0}S.", fark.Hours) : " ", // fark.Minutes > 0 ? string.Format("{0}Dk.", fark.Minutes) : "").Trim() + "\nMasa" + dr["ID"].ToString(); item.BackgroundImage = (System.Drawing.Image)(Properties.Resources.kirmizi); } } } } } }
private void btnSiparis_Click(object sender, EventArgs e) { /* * 1-masa boş * 2-masa dolu */ cMasalar Masa = new cMasalar(); cAdisyon NewAddition = new cAdisyon(); cSiparis SaveOrder = new cSiparis(); frmMasalar ms = new frmMasalar(); bool sonuc = false; if (Masa.TableGetByState(TableId, 1) == true) { NewAddition.PERSONELID = 1; NewAddition.MASAID = TableId; NewAddition.TARIH = DateTime.Now; sonuc = NewAddition.SetByAdditionNew(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.Adet = Convert.ToInt32(lvYeniEklenenler.Items[i].SubItems[2].Text); SaveOrder.AdisyonId = NewAddition.GetByAddition(TableId); SaveOrder.UrunId = Convert.ToInt32(lvYeniEklenenler.Items[i].SubItems[1].Text); SaveOrder.SetSaveOrder(SaveOrder); } } if (silinenler.Count > 0) { foreach (string item in silinenler) { SaveOrder.SetDeleteOrder(Convert.ToInt32(item)); } } this.Close(); ms.Show(); } }