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();
}
