private void frmSiparis_Load(object sender, EventArgs e)
{
lblMasaNo.Text = cGenel._ButtonValue;
cMasalar ms = new cMasalar();
int tableId = ms.TableGetbyNumber(cGenel._ButtonName);
if (ms.TableGetbyState(tableId, 2) == true || ms.TableGetbyState(tableId, 4) == true)
{
cAdisyon Ad = new cAdisyon();
int AdditionId = Ad.getByAddition(tableId);
cSiparis orders = new cSiparis();
orders.getByOrder(lvSiparisler, AdditionId);
}
btn11.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)
{
MySqlConnection con = new MySqlConnection("Server=localhost;Database=itadakimasu;Uid=root;Pwd='';");
con.Open();
MySqlCommand cmd = new MySqlCommand("Select DURUM,ID from Masalar", con);
MySqlDataReader 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 = (Image)(Properties.Resources.masaBos);
}
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 = (Image)(Properties.Resources.masaDolu);
}
else if (item.Name == "btnMasa" + dr["ID"].ToString() && dr["DURUM"].ToString() == "3")
{
item.BackgroundImage = (Image)(Properties.Resources.masaAcik);
}
else if (item.Name == "btnMasa" + dr["ID"].ToString() && dr["DURUM"].ToString() == "4")
{
item.BackgroundImage = (Image)(Properties.Resources.masaRezerve1);
}
}
}
}
}
