private void OpenDbFile()
{
try
{
temp.Flights_list.Clear();
fList = DBConnection.GetInstance().GetAllFlights();
foreach (Flight flight in fList.Flights_list)
{
temp.Add(flight);
}
FlightListDG.ItemsSource = fList.Flights_list;
}
catch (Exception ex)
{
string errMsg = "";
if (ex.Message == "Unable to connect to any of the specified MySQL hosts.")
{
errMsg = "Підключіть веб-сервер MySQL та виконайте команду Файл-Завантажити";
}
else
{
errMsg = "Для завантаження файлу виконайте команду Файл-Завантажити";
}
ErrorShow(ex, errMsg, MessageBoxButton.OK, MessageBoxImage.Error);
}
}
public static List <Flight> SelectXY(FlightList flightList, string city, TimeSpan deptime)
{
List <Flight> selectedFlights = new List <Flight>();
foreach (Flight flight in flightList.Flights_list)
{
if (flight.city.Equals(city) && (flight.depature_time.Equals(deptime) || flight.depature_time.CompareTo(deptime) == -1))
{
selectedFlights.Add(flight);
}
}
return(selectedFlights);
}
public static List <Flight> SelectX(FlightList flightList, string city)
{
List <Flight> selectedFlights = new List <Flight>();
foreach (Flight flight in flightList.Flights_list)
{
if (flight.city.Equals(city))
{
selectedFlights.Add(flight);
}
}
return(selectedFlights);
}
public override bool Equals(object obj)
{
FlightList list = (FlightList)obj;
if (list.Flights_list.Count != this.Flights_list.Count)
{
return(false);
}
for (int i = 0; i < list.Flights_list.Count; i++)
{
if (!list.Flights_list[i].Equals(this.Flights_list[i]))
{
return(false);
}
}
return(true);
}
public FlightList GetAllFlights()
{
string commandString = "SELECT * FROM rozklad;";
MySqlCommand command = new MySqlCommand();
MySqlConnection conn = new MySqlConnection(connStr);
command.CommandText = commandString;
command.Connection = conn;
MySqlDataReader reader;
command.Connection.Open();
reader = command.ExecuteReader();
int i = 0;
FlightList flightList = new FlightList();
while (reader.Read())
{
flightList.Add(new Flight((int)reader["id"], (string)reader["number"], (string)reader["city"],
(System.TimeSpan)reader["depature_time"], (int)reader["free_seats"]));
i += 1;
}
reader.Close();
return(flightList);
}
