/// <summary>
/// Adds the given transportation to the database.
/// </summary>
/// <param name="transportation">The transportation object to add to the database.</param>
public static void AddTransportation(Transportation transportation)
{
string sqlQuery = $"INSERT INTO TRANSPORTATIONS (TRANSPORTATION_ID, NAME, CITY_PERCENTAGE, HIGHWAY_PERCENTAGE, " +
$"DISTANCE_ORIGINAL, SELECTED_DISTANCE_UNIT_INDEX, REPETITION_FREQUENCY_INDEX, REPETITION_AMOUNT) VALUES (" +
$"{transportation.TransportationID}, '{transportation.TransportationName}', {transportation.CityPercentage}, " +
$"{transportation.HighwayPercentage}, {transportation.TotalDistanceOriginal}, {(int)transportation.DistanceUnitOriginal}, " +
$"{(int)transportation.RepeatFrequency}, {transportation.RepeatAmount});";
ExecuteQuery(sqlQuery);
}
private void AddTransportation_Click(object sender, MouseButtonEventArgs e)
{
Transportation = new Transportation()
{
TransportationID = SqlKernel.GetAvailableTransportationID(),
TransportationName = NameTextBox.Text,
CityPercentage = 100 - (int)RoadTypeSlider.Value,
HighwayPercentage = (int)RoadTypeSlider.Value,
TotalDistanceOriginal = float.Parse(DistanceTextBox.Text),
DistanceUnitOriginal = (DistanceUnit)DistanceTypeComboBox.SelectedIndex,
RepeatFrequency = RepeatFrequency.WEEK,
RepeatAmount = 5
};
DialogResult = true;
}
/// <summary>
/// Returns all the transportations registered in the database.
/// </summary>
/// <returns>A list with Transportation objects that are found in the database.</returns>
public static List <Transportation> GetTransportations()
{
// Get the data.
DataTable dataTable = ExecuteQuery("SELECT * FROM TRANSPORTATIONS;");
// Create and populate the vehicles' list.
List <Transportation> transportations = new List <Transportation>();
foreach (DataRow dataRow in dataTable.Rows)
{
Transportation transportation = new Transportation(dataRow);
transportations.Add(transportation);
}
// Return the list, empty or otherwise.
return(transportations);
}
