public extras load_extras(int booking_ref)
{
sql = "SELECT * FROM extras WHERE booking_ref='" + booking_ref + "';";
cmd.CommandText = sql;
sdr = cmd.ExecuteReader();
extras extra = new extras();
while (sdr.Read())
{
if (booking_ref == Int32.Parse(sdr.GetString(7)))
{
extra.Ref = Int32.Parse(sdr.GetString(0));
extra.Breakfast_price = Double.Parse(sdr.GetString(1));
extra.Breakfast_num = Int32.Parse(sdr.GetString(2));
extra.Evening_meal_price = Double.Parse(sdr.GetString(3));
extra.Evening_meal_num = Int32.Parse(sdr.GetString(4));
extra.Car_hire_price = Double.Parse(sdr.GetString(5));
extra.Car_hire_start = sdr.GetString(6);
extra.Car_hire_end = sdr.GetString(7);
extra.Car_hire_name = sdr.GetString(8);
extra.BookingRef = Int32.Parse(sdr.GetString(9));
}
}
sdr.Close();
return(extra);
Extras extraWin = new Extras();
extraWin.Show();
//extraWin.txtBox_extras_ref.Text = extra.Ref.ToString();
extraWin.txtBox_booking_ref.Text = booking_ref.ToString();
extraWin.txtBox_breakfast.Text = extra.Breakfast_num.ToString();
extraWin.txtBox_evening_meal.Text = extra.Evening_meal_num.ToString();
extraWin.datepicker_start.Text = extra.Car_hire_start;
extraWin.datepicker_end.Text = extra.Car_hire_end;
extraWin.txtBox_car_hire_name.Text = extra.Car_hire_name;
if (extraWin.datepicker_start.Text == "0001-01-01")
{
extraWin.datepicker_start.Text = "";
}
if (extraWin.datepicker_end.Text == "0001-01-01")
{
extraWin.datepicker_end.Text = "";
}
}
