}// end method
/// <summary>
/// Button to make the transportation data be sent to the SQL DataBase.
/// </summary>
private void SqlWindow(object sender, RoutedEventArgs e)
{
var linqToSqlConnection = new LinqToSqlConnection();
var dataClassesDataContext = linqToSqlConnection.DataClassesDataContext;
try
{
var transportationDataLog = new TransportationDatum
{
Name_of_Seller = _transportationDataModel.Seller,
Number_of_Bags = _transportationDataModel.NumberOfBags,
Price = _transportationDataModel.Price,
Quality = _transportationDataModel.Quality,
Shipment_Number = _transportationDataModel.ShipmentNumber,
Total_Cost = _transportationDataModel.Result,
Truck_Company = _transportationDataModel.TruckingCompany,
Weight = _transportationDataModel.Weight,
Freight_Charges = _transportationDataModel.FreightCharges,
Date_of_Arrival = _transportationDataModel.DateOfArrival,
};
dataClassesDataContext.TransportationDatums.InsertOnSubmit(transportationDataLog);
dataClassesDataContext.SubmitChanges();
MessageBox.Show("The transportation data has been successfully inserted!");
}
catch (Exception exception)
{
MessageBox.Show("Data Unsuccessfully inserted" + "\n" + exception);
}// end try-catch block
}// end method
}// end method
/// <summary>
/// Deletes a row of data.
/// </summary>
/// <param name="sender">Object sender.</param>
/// <param name="e">Event handler.</param>
private void Button_Click(object sender, RoutedEventArgs e)
{
if (DataTable.SelectedItem != null && DataTable.SelectedItem.GetType() == typeof(TransportationDatum))
{
TransportationDatum transportationDatumToDelete = (TransportationDatum)DataTable.SelectedItem;
transportationSearchModel.DeleteRow(transportationDatumToDelete);
}
else
{
MessageBox.Show("No row to delete has been selected!");
}
}// end method
