private void button1_Click(object sender, RoutedEventArgs e)
{
Match mat = Regex.Match(tb_personen.Text, "[0-9]*");
Match mat2 = Regex.Match(tb_e_dat.Text, "[0-9]{2}-[0-9]{2}-[0-9]{4} [0-9]{2}:[0-9]{2}:[0-9]{2}");
Match mat3 = Regex.Match(tb_s_dat.Text, "[0-9]{2}-[0-9]{2}-[0-9]{4} [0-9]{2}:[0-9]{2}:[0-9]{2}");
if (mat.Success && mat2.Success && mat3.Success)
{
using (TransportServiceClient tsc = new TransportServiceClient())
{
boeking boek = tsc.boekTransport(this.trans.transport_id, 3, tb_s_dat.Text, tb_e_dat.Text, Int32.Parse(tb_personen.Text));
if(boek == null)
{
textBlock1.Foreground = Brushes.Red;
textBlock1.Text = "Error tijdens boeken";
} else {
OracleConnection oc = CommonMethods.GetConnection();
oc.Open();
OracleCommand ocmd = oc.CreateCommand();
ocmd.CommandText = String.Format("INSERT INTO BOOKING (IDENTIFIER, IDENTIFIER2, TYPE, END_PERSOON) VALUES ('{0}', '{1}', '{2}', '{3}')",
boek.boekings_id,
boek.transport_id,
"transport",
CommonMethods.loginUser.id);
ocmd.ExecuteNonQuery();
oc.Close();
CommonMethods.GetFrame(this).Navigate(new ResultPage());
}
}
}
else
{
textBlock1.Text = "Foute invoer";
textBlock1.Foreground = Brushes.Red;
}
}
