public TafelOverzicht() { InitializeComponent(); //vertelt welke persoon er is ingelogd Subtext.Text = "Welkom " + Login.persoon; List <Tafels> tafels = new List <Tafels>(); Methodes methode = new Methodes(); SqlConnection conn; methode.ConnectDatabase(out conn); //Connect to database string connString = ConfigurationManager .ConnectionStrings["MayaMayaDatabase"] .ConnectionString; conn = new SqlConnection(connString); conn.Open(); SqlCommand command = new SqlCommand("select * from Tafels ", conn); SqlDataReader reader = command.ExecuteReader(); //int tafelstatus = 2; oude code //int tafelnummer = 1; while (reader.Read()) { Tafels status = new Tafels(); status.tafelstatus = (int)reader["Beschikbaarheid"]; status.tafelnummers = (int)reader["TAFELNUMMER"]; tafels.Add(status); } //ga alle tafels en kijk welke welke status heeft foreach (Tafels tafel in tafels) { if (tafel.tafelstatus == 2)//bezet { Control table = Controls["Tafel" + tafel.tafelnummers]; table.BackColor = Color.Blue; Control lable = Controls["TafelLabel" + tafel.tafelnummers]; lable.BackColor = Color.Blue; lable.Text = "Bezet"; } else if (tafel.tafelstatus == 3)//in verwerking { Control table = Controls["Tafel" + tafel.tafelnummers]; table.BackColor = Color.Red; Control lable = Controls["TafelLabel" + tafel.tafelnummers]; lable.BackColor = Color.Red; lable.Text = "Bezig"; } else if (tafel.tafelstatus == 4)//klaar voor servering { Control table = Controls["Tafel" + tafel.tafelnummers]; table.BackColor = Color.Green; Control lable = Controls["TafelLabel" + tafel.tafelnummers]; lable.BackColor = Color.Green; lable.Text = "Gereed"; } else //vrij (1 is vrij) { Control control = Controls["Tafel" + tafel.tafelnummers]; control.BackColor = Color.Yellow; Control lable = Controls["TafelLabel" + tafel.tafelnummers]; lable.BackColor = Color.Yellow; lable.Text = "Vrij"; } } /** oude code was voor als verbeteringen niet werken dan had ik toch nog wat * tafelstatus = (int)reader["Beschikbaarheid"]; * tafelnummer = (int)reader["TAFELNUMMER"]; * * * * switch(tafelnummer) * { * * case 1: * if (tafelstatus == 2)//bezet * { * Tafel1.BackColor = Color.Blue; * TafelLabel1.BackColor = Color.Blue; * TafelLabel1.Text = "Bezet"; * } * else if (tafelstatus == 3)//in verwerking * { * Tafel1.BackColor = Color.Red; * TafelLabel1.BackColor = Color.Red; * TafelLabel1.Text = "Bezig"; * * } * else if (tafelstatus == 4)//klaar voor servering * { * Tafel1.BackColor = Color.Green; * TafelLabel1.BackColor = Color.Green; * TafelLabel1.Text = "Gereed"; * * } * else //vrij (1 is vrij) * { * Tafel1.BackColor = Color.Yellow; * TafelLabel1.BackColor = Color.Yellow; * TafelLabel1.Text = "Vrij"; * } * break; * * case 2: * if (tafelstatus == 2)//bezet * { * Tafel2.BackColor = Color.Blue; * TafelLabel2.BackColor = Color.Blue; * TafelLabel2.Text = "Bezet"; * } * else if (tafelstatus == 3)//in verwerking * { * Tafel2.BackColor = Color.Red; * TafelLabel2.BackColor = Color.Red; * TafelLabel2.Text = "Bezig"; * } * else if (tafelstatus == 4)//klaar voor reservering * { * Tafel2.BackColor = Color.Green; * TafelLabel2.BackColor = Color.Green; * TafelLabel2.Text = "Gereed"; * } * else //vrij (1 is vrij) * { * Tafel2.BackColor = Color.Yellow; * TafelLabel2.BackColor = Color.Yellow; * TafelLabel2.Text = "Vrij"; * } * break; * * case 3: * if (tafelstatus == 2)//bezet * { * Tafel3.BackColor = Color.Blue; * TafelLabel3.BackColor = Color.Blue; * TafelLabel3.Text = "Bezet"; * } * else if (tafelstatus == 3)//in verwerking * { * Tafel3.BackColor = Color.Red; * TafelLabel3.BackColor = Color.Red; * TafelLabel3.Text = "Bezig"; * } * else if (tafelstatus == 4)//klaar voor reservering * { * Tafel3.BackColor = Color.Green; * TafelLabel3.BackColor = Color.Green; * TafelLabel3.Text = "Gereed"; * } * else //vrij (1 is vrij) * { * Tafel3.BackColor = Color.Yellow; * TafelLabel3.BackColor = Color.Yellow; * TafelLabel3.Text = "Vrij"; * } * break; * * case 4: * if (tafelstatus == 2)//bezet * { * Tafel4.BackColor = Color.Blue; * TafelLabel4.BackColor = Color.Blue; * TafelLabel4.Text = "Bezet"; * } * else if (tafelstatus == 3)//in verwerking * { * Tafel4.BackColor = Color.Red; * TafelLabel4.BackColor = Color.Red; * TafelLabel4.Text = "Bezig"; * } * else if (tafelstatus == 4)//klaar voor reservering * { * Tafel4.BackColor = Color.Green; * TafelLabel4.BackColor = Color.Green; * TafelLabel4.Text = "Gereed"; * } * else //vrij (1 is vrij) * { * Tafel4.BackColor = Color.Yellow; * TafelLabel4.BackColor = Color.Yellow; * TafelLabel4.Text = "Vrij"; * } * break; * case 5: * if (tafelstatus == 2)//bezet * { * Tafel5.BackColor = Color.Blue; * TafelLabel5.BackColor = Color.Blue; * TafelLabel5.Text = "Bezet"; * } * else if (tafelstatus == 3)//in verwerking * { * Tafel5.BackColor = Color.Red; * TafelLabel5.BackColor = Color.Red; * TafelLabel5.Text = "Bezig"; * } * else if (tafelstatus == 4)//klaar voor reservering * { * Tafel5.BackColor = Color.Green; * TafelLabel5.BackColor = Color.Green; * TafelLabel5.Text = "Gereed"; * } * else //vrij (1 is vrij) * { * Tafel5.BackColor = Color.Yellow; * TafelLabel5.BackColor = Color.Yellow; * TafelLabel5.Text = "Vrij"; * } * break; * * case 6: * if (tafelstatus == 2)//bezet * { * Tafel6.BackColor = Color.Blue; * TafelLabel6.BackColor = Color.Blue; * TafelLabel6.Text = "Bezet"; * } * else if (tafelstatus == 3)//in verwerking * { * Tafel6.BackColor = Color.Red; * TafelLabel6.BackColor = Color.Red; * TafelLabel6.Text = "Bezig"; * } * else if (tafelstatus == 4)//klaar voor reservering * { * Tafel6.BackColor = Color.Green; * TafelLabel6.BackColor = Color.Green; * TafelLabel6.Text = "Gereed"; * } * else //vrij (1 is vrij) * { * Tafel6.BackColor = Color.Yellow; * TafelLabel6.BackColor = Color.Yellow; * TafelLabel6.Text = "Vrij"; * } * break; * * case 7: * if (tafelstatus == 2)//bezet * { * Tafel7.BackColor = Color.Blue; * TafelLabel7.BackColor = Color.Blue; * TafelLabel7.Text = "Bezet"; * } * else if (tafelstatus == 3)//in verwerking * { * Tafel7.BackColor = Color.Red; * TafelLabel7.BackColor = Color.Red; * TafelLabel7.Text = "Bezig"; * } * else if (tafelstatus == 4)//klaar voor reservering * { * Tafel7.BackColor = Color.Green; * TafelLabel7.BackColor = Color.Green; * TafelLabel7.Text = "Gereed"; * } * else //vrij (1 is vrij) * { * Tafel7.BackColor = Color.Yellow; * TafelLabel7.BackColor = Color.Yellow; * TafelLabel7.Text = "Vrij"; * } * break; * * case 8: * if (tafelstatus == 2)//bezet * { * Tafel8.BackColor = Color.Blue; * TafelLabel8.BackColor = Color.Blue; * TafelLabel8.Text = "Bezet"; * } * else if (tafelstatus == 3)//in verwerking * { * Tafel8.BackColor = Color.Red; * TafelLabel8.BackColor = Color.Red; * TafelLabel8.Text = "Bezig"; * } * else if (tafelstatus == 4)//klaar voor reservering * { * Tafel8.BackColor = Color.Green; * TafelLabel8.BackColor = Color.Green; * TafelLabel8.Text = "Gereed"; * } * else //vrij (1 is vrij) * { * Tafel8.BackColor = Color.Yellow; * TafelLabel8.BackColor = Color.Yellow; * TafelLabel8.Text = "Vrij"; * } * break; * * case 9: * if (tafelstatus == 2)//bezet * { * Tafel9.BackColor = Color.Blue; * TafelLabel9.BackColor = Color.Blue; * TafelLabel9.Text = "Bezet"; * } * else if (tafelstatus == 3)//in verwerking * { * Tafel9.BackColor = Color.Red; * TafelLabel9.BackColor = Color.Red; * TafelLabel9.Text = "Bezig"; * } * else if (tafelstatus == 4)//klaar voor reservering * { * Tafel9.BackColor = Color.Green; * TafelLabel9.BackColor = Color.Green; * TafelLabel9.Text = "Gereed"; * } * else //vrij (1 is vrij) * { * Tafel9.BackColor = Color.Yellow; * TafelLabel9.BackColor = Color.Yellow; * TafelLabel9.Text = "Vrij"; * } * break; * * case 10: * if (tafelstatus == 2)//bezet * { * Tafel10.BackColor = Color.Blue; * TafelLabel10.BackColor = Color.Blue; * TafelLabel10.Text = "Bezet"; * } * else if (tafelstatus == 3)//in verwerking * { * Tafel10.BackColor = Color.Red; * TafelLabel10.BackColor = Color.Red; * TafelLabel10.Text = "Bezig"; * } * else if (tafelstatus == 4)//klaar voor reservering * { * Tafel10.BackColor = Color.Green; * TafelLabel10.BackColor = Color.Green; * TafelLabel10.Text = "Gereed"; * } * else //vrij (1 is vrij) * { * Tafel10.BackColor = Color.Yellow; * TafelLabel10.BackColor = Color.Yellow; * TafelLabel10.Text = "Vrij"; * } * break; * } * * * * * * } */ conn.Close(); }
private void reserveerTafelButton_Click(object sender, EventArgs e) { int tafelstatus = 0; string selected = ""; try { selected = TafelSelectBox.SelectedItem.ToString(); } catch { string errormessage = "je moet wel een tafel aanklikken als je op reserveren drukt"; string errorcaption = "ERROR"; MessageBoxButtons errorbuttons = MessageBoxButtons.OK; DialogResult errorresult; errorresult = MessageBox.Show(errormessage, errorcaption, errorbuttons); } string message = selected + " is gereserveerd"; string caption = "Reservering"; MessageBoxButtons buttons = MessageBoxButtons.OK; DialogResult result; int gekozenTafel = 0; switch (selected) { case "Tafel1": gekozenTafel = 1; break; case "Tafel2": gekozenTafel = 2; break; case "Tafel3": gekozenTafel = 3; break; case "Tafel4": gekozenTafel = 4; break; case "Tafel5": gekozenTafel = 5; break; case "Tafel6": gekozenTafel = 6; break; case "Tafel7": gekozenTafel = 7; break; case "Tafel8": gekozenTafel = 8; break; case "Tafel9": gekozenTafel = 9; break; case "Tafel10": gekozenTafel = 10; break; default: gekozenTafel = 0; break; } Tafels.reserveering(gekozenTafel, out tafelstatus); if (tafelstatus != 1) { message = selected + " kan niet worden gereserveert\n er zitten hier al mensen"; } else { message = selected + " is gereserveerd"; Tafels.reserveeringDeel2(gekozenTafel); } result = MessageBox.Show(message, caption, buttons); //the message word in de code samen gezet en het eind resultaat word hier getoond }
public TafelOverzicht() { InitializeComponent(); //vertelt welke persoon er is ingelogd Subtext.Text = "Welkom "+ Login.persoon; List<Tafels> tafels = new List<Tafels>(); Methodes methode = new Methodes(); SqlConnection conn; methode.ConnectDatabase(out conn); //Connect to database string connString = ConfigurationManager .ConnectionStrings["MayaMayaDatabase"] .ConnectionString; conn = new SqlConnection(connString); conn.Open(); SqlCommand command = new SqlCommand("select * from Tafels ", conn); SqlDataReader reader = command.ExecuteReader(); //int tafelstatus = 2; oude code //int tafelnummer = 1; while (reader.Read()) { Tafels status = new Tafels(); status.tafelstatus = (int)reader["Beschikbaarheid"]; status.tafelnummers = (int)reader["TAFELNUMMER"]; tafels.Add(status); } //ga alle tafels en kijk welke welke status heeft foreach (Tafels tafel in tafels) if (tafel.tafelstatus == 2)//bezet { Control table = Controls["Tafel" + tafel.tafelnummers]; table.BackColor = Color.Blue; Control lable = Controls["TafelLabel" + tafel.tafelnummers]; lable.BackColor = Color.Blue; lable.Text = "Bezet"; } else if (tafel.tafelstatus == 3)//in verwerking { Control table = Controls["Tafel" + tafel.tafelnummers]; table.BackColor = Color.Red; Control lable = Controls["TafelLabel" + tafel.tafelnummers]; lable.BackColor = Color.Red; lable.Text = "Bezig"; } else if (tafel.tafelstatus == 4)//klaar voor servering { Control table = Controls["Tafel" + tafel.tafelnummers]; table.BackColor = Color.Green; Control lable = Controls["TafelLabel" + tafel.tafelnummers]; lable.BackColor = Color.Green; lable.Text = "Gereed"; } else //vrij (1 is vrij) { Control control = Controls["Tafel" + tafel.tafelnummers]; control.BackColor = Color.Yellow; Control lable = Controls["TafelLabel" + tafel.tafelnummers]; lable.BackColor = Color.Yellow; lable.Text = "Vrij"; } /** oude code was voor als verbeteringen niet werken dan had ik toch nog wat tafelstatus = (int)reader["Beschikbaarheid"]; tafelnummer = (int)reader["TAFELNUMMER"]; switch(tafelnummer) { case 1: if (tafelstatus == 2)//bezet { Tafel1.BackColor = Color.Blue; TafelLabel1.BackColor = Color.Blue; TafelLabel1.Text = "Bezet"; } else if (tafelstatus == 3)//in verwerking { Tafel1.BackColor = Color.Red; TafelLabel1.BackColor = Color.Red; TafelLabel1.Text = "Bezig"; } else if (tafelstatus == 4)//klaar voor servering { Tafel1.BackColor = Color.Green; TafelLabel1.BackColor = Color.Green; TafelLabel1.Text = "Gereed"; } else //vrij (1 is vrij) { Tafel1.BackColor = Color.Yellow; TafelLabel1.BackColor = Color.Yellow; TafelLabel1.Text = "Vrij"; } break; case 2: if (tafelstatus == 2)//bezet { Tafel2.BackColor = Color.Blue; TafelLabel2.BackColor = Color.Blue; TafelLabel2.Text = "Bezet"; } else if (tafelstatus == 3)//in verwerking { Tafel2.BackColor = Color.Red; TafelLabel2.BackColor = Color.Red; TafelLabel2.Text = "Bezig"; } else if (tafelstatus == 4)//klaar voor reservering { Tafel2.BackColor = Color.Green; TafelLabel2.BackColor = Color.Green; TafelLabel2.Text = "Gereed"; } else //vrij (1 is vrij) { Tafel2.BackColor = Color.Yellow; TafelLabel2.BackColor = Color.Yellow; TafelLabel2.Text = "Vrij"; } break; case 3: if (tafelstatus == 2)//bezet { Tafel3.BackColor = Color.Blue; TafelLabel3.BackColor = Color.Blue; TafelLabel3.Text = "Bezet"; } else if (tafelstatus == 3)//in verwerking { Tafel3.BackColor = Color.Red; TafelLabel3.BackColor = Color.Red; TafelLabel3.Text = "Bezig"; } else if (tafelstatus == 4)//klaar voor reservering { Tafel3.BackColor = Color.Green; TafelLabel3.BackColor = Color.Green; TafelLabel3.Text = "Gereed"; } else //vrij (1 is vrij) { Tafel3.BackColor = Color.Yellow; TafelLabel3.BackColor = Color.Yellow; TafelLabel3.Text = "Vrij"; } break; case 4: if (tafelstatus == 2)//bezet { Tafel4.BackColor = Color.Blue; TafelLabel4.BackColor = Color.Blue; TafelLabel4.Text = "Bezet"; } else if (tafelstatus == 3)//in verwerking { Tafel4.BackColor = Color.Red; TafelLabel4.BackColor = Color.Red; TafelLabel4.Text = "Bezig"; } else if (tafelstatus == 4)//klaar voor reservering { Tafel4.BackColor = Color.Green; TafelLabel4.BackColor = Color.Green; TafelLabel4.Text = "Gereed"; } else //vrij (1 is vrij) { Tafel4.BackColor = Color.Yellow; TafelLabel4.BackColor = Color.Yellow; TafelLabel4.Text = "Vrij"; } break; case 5: if (tafelstatus == 2)//bezet { Tafel5.BackColor = Color.Blue; TafelLabel5.BackColor = Color.Blue; TafelLabel5.Text = "Bezet"; } else if (tafelstatus == 3)//in verwerking { Tafel5.BackColor = Color.Red; TafelLabel5.BackColor = Color.Red; TafelLabel5.Text = "Bezig"; } else if (tafelstatus == 4)//klaar voor reservering { Tafel5.BackColor = Color.Green; TafelLabel5.BackColor = Color.Green; TafelLabel5.Text = "Gereed"; } else //vrij (1 is vrij) { Tafel5.BackColor = Color.Yellow; TafelLabel5.BackColor = Color.Yellow; TafelLabel5.Text = "Vrij"; } break; case 6: if (tafelstatus == 2)//bezet { Tafel6.BackColor = Color.Blue; TafelLabel6.BackColor = Color.Blue; TafelLabel6.Text = "Bezet"; } else if (tafelstatus == 3)//in verwerking { Tafel6.BackColor = Color.Red; TafelLabel6.BackColor = Color.Red; TafelLabel6.Text = "Bezig"; } else if (tafelstatus == 4)//klaar voor reservering { Tafel6.BackColor = Color.Green; TafelLabel6.BackColor = Color.Green; TafelLabel6.Text = "Gereed"; } else //vrij (1 is vrij) { Tafel6.BackColor = Color.Yellow; TafelLabel6.BackColor = Color.Yellow; TafelLabel6.Text = "Vrij"; } break; case 7: if (tafelstatus == 2)//bezet { Tafel7.BackColor = Color.Blue; TafelLabel7.BackColor = Color.Blue; TafelLabel7.Text = "Bezet"; } else if (tafelstatus == 3)//in verwerking { Tafel7.BackColor = Color.Red; TafelLabel7.BackColor = Color.Red; TafelLabel7.Text = "Bezig"; } else if (tafelstatus == 4)//klaar voor reservering { Tafel7.BackColor = Color.Green; TafelLabel7.BackColor = Color.Green; TafelLabel7.Text = "Gereed"; } else //vrij (1 is vrij) { Tafel7.BackColor = Color.Yellow; TafelLabel7.BackColor = Color.Yellow; TafelLabel7.Text = "Vrij"; } break; case 8: if (tafelstatus == 2)//bezet { Tafel8.BackColor = Color.Blue; TafelLabel8.BackColor = Color.Blue; TafelLabel8.Text = "Bezet"; } else if (tafelstatus == 3)//in verwerking { Tafel8.BackColor = Color.Red; TafelLabel8.BackColor = Color.Red; TafelLabel8.Text = "Bezig"; } else if (tafelstatus == 4)//klaar voor reservering { Tafel8.BackColor = Color.Green; TafelLabel8.BackColor = Color.Green; TafelLabel8.Text = "Gereed"; } else //vrij (1 is vrij) { Tafel8.BackColor = Color.Yellow; TafelLabel8.BackColor = Color.Yellow; TafelLabel8.Text = "Vrij"; } break; case 9: if (tafelstatus == 2)//bezet { Tafel9.BackColor = Color.Blue; TafelLabel9.BackColor = Color.Blue; TafelLabel9.Text = "Bezet"; } else if (tafelstatus == 3)//in verwerking { Tafel9.BackColor = Color.Red; TafelLabel9.BackColor = Color.Red; TafelLabel9.Text = "Bezig"; } else if (tafelstatus == 4)//klaar voor reservering { Tafel9.BackColor = Color.Green; TafelLabel9.BackColor = Color.Green; TafelLabel9.Text = "Gereed"; } else //vrij (1 is vrij) { Tafel9.BackColor = Color.Yellow; TafelLabel9.BackColor = Color.Yellow; TafelLabel9.Text = "Vrij"; } break; case 10: if (tafelstatus == 2)//bezet { Tafel10.BackColor = Color.Blue; TafelLabel10.BackColor = Color.Blue; TafelLabel10.Text = "Bezet"; } else if (tafelstatus == 3)//in verwerking { Tafel10.BackColor = Color.Red; TafelLabel10.BackColor = Color.Red; TafelLabel10.Text = "Bezig"; } else if (tafelstatus == 4)//klaar voor reservering { Tafel10.BackColor = Color.Green; TafelLabel10.BackColor = Color.Green; TafelLabel10.Text = "Gereed"; } else //vrij (1 is vrij) { Tafel10.BackColor = Color.Yellow; TafelLabel10.BackColor = Color.Yellow; TafelLabel10.Text = "Vrij"; } break; } } */ conn.Close(); }