private void timer1_Tick(object sender, EventArgs e)
{
DbHandeler db = new DbHandeler();
label2.Text = DateTime.Now.Hour + ":" + DateTime.Now.Minute.ToString ("00");
label3.Text = ( SystemInformation.PowerStatus.BatteryLifePercent * 100 ) + "%";
Tafelbezet[] bezet = db.TafelsBezet();
Tafelbezet[] gereserveerd = db.TafelsRes();
double OwnTime =
Convert.ToDouble(string.Format("{0}.{1}", DateTime.Now.Hour, DateTime.Now.Minute));
for(int i = 0; i < bezet.Length; i++){
switch (i) {
case 0:
btn_tafel1.BackColor = bezet[i].bezet ? Color.IndianRed : Color.DarkKhaki;
if (btn_tafel1.BackColor == Color.IndianRed) break;
btn_tafel1.BackColor = gereserveerd[i].bezet ? Color.DeepSkyBlue : Color.DarkKhaki;
break;
case 1:
btn_tafel2.BackColor = bezet[i].bezet ? Color.IndianRed : Color.DarkKhaki;
if (btn_tafel2.BackColor == Color.IndianRed) break;
btn_tafel2.BackColor = gereserveerd[i].bezet ? Color.DeepSkyBlue : Color.DarkKhaki;
break;
case 2:
btn_tafel3.BackColor = bezet[i].bezet ? Color.IndianRed : Color.DarkKhaki;
if (btn_tafel3.BackColor == Color.IndianRed) break;
btn_tafel3.BackColor = gereserveerd[i].bezet ? Color.DeepSkyBlue : Color.DarkKhaki;
break;
case 3:
btn_tafel4.BackColor = bezet[i].bezet ? Color.IndianRed : Color.DarkKhaki;
if (btn_tafel4.BackColor == Color.IndianRed) break;
btn_tafel4.BackColor = gereserveerd[i].bezet ? Color.DeepSkyBlue : Color.DarkKhaki;
break;
case 4:
btn_tafel5.BackColor = bezet[i].bezet ? Color.IndianRed : Color.DarkKhaki;
if (btn_tafel5.BackColor == Color.IndianRed) break;
btn_tafel5.BackColor = gereserveerd[i].bezet ? Color.DeepSkyBlue : Color.DarkKhaki;
break;
case 5:
btn_tafel6.BackColor = bezet[i].bezet ? Color.IndianRed : Color.DarkKhaki;
if (btn_tafel6.BackColor == Color.IndianRed) break;
btn_tafel6.BackColor = gereserveerd[i].bezet ? Color.DeepSkyBlue : Color.DarkKhaki;
break;
case 6:
btn_tafel7.BackColor = bezet[i].bezet ? Color.IndianRed : Color.DarkKhaki;
if (btn_tafel7.BackColor == Color.IndianRed) break;
btn_tafel7.BackColor = gereserveerd[i].bezet ? Color.DeepSkyBlue : Color.DarkKhaki;
break;
case 7:
btn_tafel8.BackColor = bezet[i].bezet ? Color.IndianRed : Color.DarkKhaki;
if (btn_tafel8.BackColor == Color.IndianRed) break;
btn_tafel8.BackColor = gereserveerd[i].bezet ? Color.DeepSkyBlue : Color.DarkKhaki;
break;
case 8:
btn_tafel9.BackColor = bezet[i].bezet ? Color.IndianRed : Color.DarkKhaki;
if (btn_tafel9.BackColor == Color.IndianRed) break;
btn_tafel9.BackColor = gereserveerd[i].bezet ? Color.DeepSkyBlue : Color.DarkKhaki;
break;
case 9:
btn_tafel10.BackColor = bezet[i].bezet ? Color.IndianRed : Color.DarkKhaki;
if (btn_tafel10.BackColor == Color.IndianRed) break;
btn_tafel10.BackColor = gereserveerd[i].bezet ? Color.DeepSkyBlue : Color.DarkKhaki;
break;
}
}
}
private void timer1_Tick(object sender, EventArgs e)
{
DbHandeler db = new DbHandeler();
label2.Text = DateTime.Now.Hour + ":" + DateTime.Now.Minute.ToString("00");
label3.Text = (SystemInformation.PowerStatus.BatteryLifePercent * 100) + "%";
Tafelbezet[] bezet = db.TafelsBezet();
Tafelbezet[] gereserveerd = db.TafelsRes();
double OwnTime =
Convert.ToDouble(string.Format("{0}.{1}", DateTime.Now.Hour, DateTime.Now.Minute));
for (int i = 0; i < bezet.Length; i++)
{
switch (i)
{
case 0:
btn_tafel1.BackColor = bezet[i].bezet ? Color.IndianRed : Color.DarkKhaki;
if (btn_tafel1.BackColor == Color.IndianRed)
{
break;
}
btn_tafel1.BackColor = gereserveerd[i].bezet ? Color.DeepSkyBlue : Color.DarkKhaki;
break;
case 1:
btn_tafel2.BackColor = bezet[i].bezet ? Color.IndianRed : Color.DarkKhaki;
if (btn_tafel2.BackColor == Color.IndianRed)
{
break;
}
btn_tafel2.BackColor = gereserveerd[i].bezet ? Color.DeepSkyBlue : Color.DarkKhaki;
break;
case 2:
btn_tafel3.BackColor = bezet[i].bezet ? Color.IndianRed : Color.DarkKhaki;
if (btn_tafel3.BackColor == Color.IndianRed)
{
break;
}
btn_tafel3.BackColor = gereserveerd[i].bezet ? Color.DeepSkyBlue : Color.DarkKhaki;
break;
case 3:
btn_tafel4.BackColor = bezet[i].bezet ? Color.IndianRed : Color.DarkKhaki;
if (btn_tafel4.BackColor == Color.IndianRed)
{
break;
}
btn_tafel4.BackColor = gereserveerd[i].bezet ? Color.DeepSkyBlue : Color.DarkKhaki;
break;
case 4:
btn_tafel5.BackColor = bezet[i].bezet ? Color.IndianRed : Color.DarkKhaki;
if (btn_tafel5.BackColor == Color.IndianRed)
{
break;
}
btn_tafel5.BackColor = gereserveerd[i].bezet ? Color.DeepSkyBlue : Color.DarkKhaki;
break;
case 5:
btn_tafel6.BackColor = bezet[i].bezet ? Color.IndianRed : Color.DarkKhaki;
if (btn_tafel6.BackColor == Color.IndianRed)
{
break;
}
btn_tafel6.BackColor = gereserveerd[i].bezet ? Color.DeepSkyBlue : Color.DarkKhaki;
break;
case 6:
btn_tafel7.BackColor = bezet[i].bezet ? Color.IndianRed : Color.DarkKhaki;
if (btn_tafel7.BackColor == Color.IndianRed)
{
break;
}
btn_tafel7.BackColor = gereserveerd[i].bezet ? Color.DeepSkyBlue : Color.DarkKhaki;
break;
case 7:
btn_tafel8.BackColor = bezet[i].bezet ? Color.IndianRed : Color.DarkKhaki;
if (btn_tafel8.BackColor == Color.IndianRed)
{
break;
}
btn_tafel8.BackColor = gereserveerd[i].bezet ? Color.DeepSkyBlue : Color.DarkKhaki;
break;
case 8:
btn_tafel9.BackColor = bezet[i].bezet ? Color.IndianRed : Color.DarkKhaki;
if (btn_tafel9.BackColor == Color.IndianRed)
{
break;
}
btn_tafel9.BackColor = gereserveerd[i].bezet ? Color.DeepSkyBlue : Color.DarkKhaki;
break;
case 9:
btn_tafel10.BackColor = bezet[i].bezet ? Color.IndianRed : Color.DarkKhaki;
if (btn_tafel10.BackColor == Color.IndianRed)
{
break;
}
btn_tafel10.BackColor = gereserveerd[i].bezet ? Color.DeepSkyBlue : Color.DarkKhaki;
break;
}
}
}
