/// <summary>
/// Get all bookers from the database
/// </summary>
private void GetBookersFromDB()
{
Database db = new Database();
db.CreateCommand("SELECT id,firstname FROM BOOKERS");
db.OpenConnection();
db.ExecuteCommand();
OracleDataReader dr = db.DataReader;
while (dr.Read())
{
Booker booker = new Booker(dr.GetInt16(0), dr.GetString(1));
BookerList.Add(booker);
comboBox1.Items.Add(booker.Name);
}
db.CloseConnection();
}
/// <summary>
/// check if all fields are filled in
/// </summary>
/// <returns>bool</returns>
private bool authenticateStep2()
{
bool boxesFilled = true;
panel3.Controls.Clear();
int StartX = 0;
int StartY = 0;
for (int i = 0; i < nameErrorLabels.Count; i++)
{
nameErrorLabels[i].Visible = false;
}
for (int i = 0; i < additionalName.Count; i++)
{
if (additionalName[i].Text == "")
{
boxesFilled = false;
nameErrorLabels[i].Visible = true;
}
Booker boeker = new Booker();
boeker.Name = additionalName[i].Text;
boeker.PhoneNumber = additionalPhone[i].Text;
medeboekers.Add(boeker);
{
Label lbName = new Label();
lbName.Text = "Naam";
lbName.Location = new Point(StartX, StartY + (i * 25));
Label lbPhone = new Label();
lbPhone.Text = "Telefoonnummer";
lbPhone.Location = new Point(StartX, StartY + (i * 25) + 25);
Label lbS4Name = new Label();
lbS4Name.AutoSize = true;
lbS4Name.Text = boeker.Name;
lbS4Name.Location = new Point(StartX + 110, StartY + (i * 25));
Label lbS4Phone = new Label();
lbS4Phone.AutoSize = true;
lbS4Phone.Text = (boeker.PhoneNumber == "") ? "Geen telefoonnummer..." : boeker.PhoneNumber;
lbS4Phone.Location = new Point(StartX + 110, StartY + (i * 25) + 25);
panel3.Controls.Add(lbName);
panel3.Controls.Add(lbPhone);
panel3.Controls.Add(lbS4Name);
panel3.Controls.Add(lbS4Phone);
StartY += 30;
}
}
return boxesFilled;
}
