/// <summary>
///
/// </summary>
/// <returns></returns>
public static List <Ferry> GetAllFerries()
{
List <Ferry> ferries = new List <Ferry>();
DBUtility.HandleConnection((MySqlCommand command) =>
{
command.CommandText = "SELECT * FROM ferries;";
using (MySqlDataReader reader = command.ExecuteReader())
{
while (reader.Read())
{
ferries.Add(new Ferry()
{
FerryId = reader.GetInt32("id"),
FerryName = reader.GetString("name"),
FerrySize = reader.GetString("size"),
PassengerCapacity = reader.GetInt32("passenger_capacity"),
VehicleCapacity = reader.GetInt32("vehicle_capacity"),
Municipality = reader.GetString("municipality"),
Dock = DockHandler.GetDock(reader.GetInt32("dock_id"))
});
}
}
});
return(ferries);
}
/// <summary>
///
/// </summary>
/// <param name="ferryId"></param>
/// <returns></returns>
public static Ferry GetFerry(int ferryId)
{
Ferry ferry = null;
DBUtility.HandleConnection((MySqlCommand command) =>
{
command.CommandText = "SELECT * FROM ferries WHERE id = @id;";
command.Parameters.AddWithValue("@id", ferryId);
using (MySqlDataReader reader = command.ExecuteReader())
{
if (reader.Read())
{
ferry = new Ferry()
{
FerryId = reader.GetInt32("id"),
FerryName = reader.GetString("name"),
FerrySize = reader.GetString("size"),
PassengerCapacity = reader.GetInt32("passenger_capacity"),
VehicleCapacity = reader.GetInt32("vehicle_capacity"),
Municipality = reader.GetString("municipality"),
Dock = DockHandler.GetDock(reader.GetInt32("dock_id"))
};
}
}
});
return(ferry);
}
/// <summary>
///
/// </summary>
/// <param name="routeId"></param>
/// <returns></returns>
public static Route GetRoute(int routeId)
{
Route route = null;
DBUtility.HandleConnection((MySqlCommand command) =>
{
command.CommandText = "SELECT * FROM routes WHERE id = @id;";
command.Parameters.AddWithValue("@id", routeId);
using (MySqlDataReader reader = command.ExecuteReader())
{
if (reader.Read())
{
route = new Route()
{
Depature = DockHandler.GetDock(reader.GetInt32("departure_dock_id")).DockName, //This is stupid, it should be a dock object
Destination = DockHandler.GetDock(reader.GetInt32("destination_dock_id")).DockName, //This is stupid, it should be a dock object
Duration = reader.GetInt32("duration"),
RouteId = reader.GetInt32("id")
};
}
}
});
return(route);
}
/// <summary>
///
/// </summary>
/// <returns></returns>
public static List <Route> GetAllRoutes()
{
List <Route> routes = new List <Route>();
DBUtility.HandleConnection((MySqlCommand command) =>
{
command.CommandText = "SELECT * FROM routes;";
using (MySqlDataReader reader = command.ExecuteReader())
{
while (reader.Read())
{
routes.Add(new Route()
{
Depature = DockHandler.GetDock(reader.GetInt32("departure_dock_id")).DockName, //This is stupid, it should be a dock object
Destination = DockHandler.GetDock(reader.GetInt32("destination_dock_id")).DockName, //This is stupid, it should be a dock object
Duration = reader.GetInt32("duration"),
RouteId = reader.GetInt32("id")
});
}
}
});
return(routes);
}
public Dock GetDock(int dockId)
{
return(DockHandler.GetDock(dockId));
}