public void AddTraveller(Travel t)
{
using (SqlCommand insertCommand = new SqlCommand(
"INSERT INTO Travel2 (Destination, Name , PassportNO , Departure , ReturnDate , MethodOfTravel ) VALUES" + "(@Destination, @TravellerName , @TravellerPassport , @DepartureDate , @ReturnDate , @MethodOfTravel ) ", conn))
{
insertCommand.Parameters.AddWithValue("@Destination", t.Destination);
insertCommand.Parameters.AddWithValue("@TravellerName", t.TravellerName);
insertCommand.Parameters.AddWithValue("@TravellerPassport", t.TravellerPassport);
insertCommand.Parameters.AddWithValue("@DepartureDate", t.DepartureDate.ToString("MM-dd-yyyy"));
insertCommand.Parameters.AddWithValue("@ReturnDate", t.ReturnDate.ToString("MM-dd-yyyy"));
insertCommand.Parameters.AddWithValue("@MethodOfTravel", t.MethodOfTravel.ToString());
insertCommand.ExecuteNonQuery();
}
}
private void btnAddTrip_Click(object sender, RoutedEventArgs e)
{
//Travel currTravel = new Travel();
string destination = tbDestination.Text;
string name = tbName.Text;
string passportNo = tbPassportNo.Text;
DateTime departure = DateTime.Parse(dpDep.Text);
DateTime returnDate = DateTime.Parse(dpDep.Text);
if (returnDate.Date < departure.Date)
{
MessageBox.Show("Invalid Return Date. Needs to be after Departure");
return;
}
string methodOfTravelStr = cbxMethodTravel.Text;
Travel.TravelEnum methodOfTravel;
if (!Enum.TryParse <Travel.TravelEnum>(methodOfTravelStr, out methodOfTravel))
{
throw new InvalidCastException("Enum value invalid: " + methodOfTravelStr);
}
try
{
if (currTravel == null)
{
Travel t = new Travel(destination, name, passportNo, departure, returnDate, methodOfTravel);
Globals.db.AddTraveller(t);
}
else
{
currTravel.Destination = destination;
currTravel.TravellerName = name;
currTravel.TravellerPassport = passportNo;
currTravel.DepartureDate = departure;
currTravel.ReturnDate = returnDate;
currTravel.MethodOfTravel = methodOfTravel;
}
this.DialogResult = true;
}
catch (SqlException ex)
{
MessageBox.Show(this, ex.Message, "Database Error", MessageBoxButton.OK, MessageBoxImage.Error);
}
}
private void lvTravel_MouseDoubleClick(object sender, MouseButtonEventArgs e)
{
Travel currPerson = lvTravel.SelectedItem as Travel;
if (currPerson == null)
{
return;
}
AddTravelDialog dlg = new AddTravelDialog(this);
if (dlg.ShowDialog() == true)
{
RefreshList();
MessageBox.Show("Seccess!");
}
}