private void frmSiparis_Load(object sender, EventArgs e) { lblMasaNo.Text = cGenel._ButtonValue; cMasalar ms = new cMasalar(); tableId = ms.TableGetbyNumber(cGenel._ButtonName); 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); 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); }
private void frmMasalar_Load(object sender, EventArgs e) { 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 (item.Name == "btnMasa" + dr["ID"].ToString() && dr["DURUM"].ToString() == "1") { item.BackgroundImage = (System.Drawing.Image.FromFile("C:\\Users\\yenib\\Desktop\resto\\images\\masa.PNG")); } else if (item.Name == "btnMasa" + dr["ID"].ToString() && dr["DURUM"].ToString() == "2") { cMasalar ms = new cMasalar(); DateTime dt1 = Convert.ToDateTime(ms.SessionSum(2)); DateTime dt2 = DateTime.Now; string st1 = Convert.ToDateTime(ms.SessionSum(2)).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ün ", fark.Days) :"", fark.Hours > 0 ? string.Format("{0} saat ", fark.Hours) :"", fark.Minutes > 0 ? string.Format("{0} Dakika ", fark.Minutes) :"").Trim() + "\n\n\nMasa" + dr["ID"].ToString(); item.BackgroundImage = (System.Drawing.Image.FromFile("C:\\Users\\yenib\\Desktop\\dolu.PNG")); } else if (item.Name == "btnMasa" + dr["ID"].ToString() && dr["DURUM"].ToString() == "3") { item.BackgroundImage = (System.Drawing.Image.FromFile("C:\\Users\\yenib\\Desktop\\acık.PNG")); } else if (item.Name == "btnMasa" + dr["ID"].ToString() && dr["DURUM"].ToString() == "4") { item.BackgroundImage = (System.Drawing.Image.FromFile("C:\\Users\\yenib\\Desktop\\rezerve.PNG")); } } } } }
private void btnSiparis_Click(object sender, EventArgs e) { cMasalar masa = new cMasalar(); cAdisyon newAddition = new cAdisyon(); bool sonuc = false; if (masa.TableGetbyState(tableId, 1) == true) { newAddition.ServisTurNo = 1; newAddition.PersonelId = 1; newAddition.MasaId = tableId; newAddition.Tarih = DateTime.Now; } }