public ArrayList getTrips()
{
MySql.Data.MySqlClient.MySqlConnection conn;
string myConnectionString = ConfigurationManager.ConnectionStrings["PhpMySqlRemoteDB"].ConnectionString;
conn = new MySql.Data.MySqlClient.MySqlConnection();
try
{
conn.ConnectionString = myConnectionString;
conn.Open();
ArrayList tripArray = new ArrayList();
MySql.Data.MySqlClient.MySqlDataReader mySQLReader = null;
string sqlString = "SELECT * FROM Trips";
MySql.Data.MySqlClient.MySqlCommand cmd = new MySql.Data.MySqlClient.MySqlCommand(sqlString, conn);
mySQLReader = cmd.ExecuteReader();
while (mySQLReader.Read())
{
Trip t = new Trip();
t.TripID = mySQLReader.GetInt32(0);
t.Username = mySQLReader.GetString(1);
t.From_City_Country = mySQLReader.GetString(2);
t.To_City_Country = mySQLReader.GetString(3);
t.TransportationType = mySQLReader.GetString(4);
t.OutboundTripDetails_Day = mySQLReader.GetDateTime(5);
t.OutboundTripDetails_Time = mySQLReader.GetTimeSpan(6);
t.OutboundTripDetails_Duration = mySQLReader.GetFloat(7);
t.AddAReturnTrip = mySQLReader.GetBoolean(8);
t.ReturnTripDetails_Day = mySQLReader.GetDateTime(9);
t.ReturnTripDetails_Time = mySQLReader.GetTimeSpan(10);
t.ReturnTripDetails_Duration = mySQLReader.GetFloat(11);
t.AvailableWeight = mySQLReader.GetFloat(12);
t.ExcludedCategories = mySQLReader.GetString(13);
t.TripNote = mySQLReader.GetString(14);
tripArray.Add(t);
}
return(tripArray);
}
catch (MySql.Data.MySqlClient.MySqlException ex)
{
throw ex;
}
finally
{
conn.Close();
}
}