public int CompareTo(object obj)
{
HealthTravel healthPackage = obj as HealthTravel;
if (healthPackage == null)
{
throw new ArgumentException("Object is not a Travel Package");
}
return(this.rank.CompareTo(healthPackage.rank));
}
//Create a sortable observable collection to hold the Health & Wellness TravelPackage data
public static ObservableCollection <HealthTravel> GetHealthData()
{
var healthPackages = new ObservableCollection <HealthTravel>();
const string GetHealthQuery = "SELECT * FROM PackageTable WHERE HealthWell=1";
try
{
using (SqliteConnection db = new SqliteConnection("Filename=PackagesData.db"))
{
db.Open();
if (db.State == System.Data.ConnectionState.Open)
{
using (SqliteCommand cmd = db.CreateCommand())
{
cmd.CommandText = GetHealthQuery;
using (SqliteDataReader reader = cmd.ExecuteReader())
{
while (reader.Read())
{
var health = new HealthTravel();
health.dcode = reader.GetString(1);
health.dest = reader.GetString(2);
health.locate = reader.GetString(3);
health.descript = reader.GetString(4);
health.rank = reader.GetInt32(5);
health.SPA = reader.GetInt32(10);
health.AMUSE = reader.GetInt32(11);
health.HISTORIC = reader.GetInt32(12);
health.CAMP = reader.GetInt32(13);
health.ENTERTAIN = reader.GetInt32(14);
health.cat = reader.GetInt32(15);
health.priceLow = reader.GetInt32(20);
health.priceHigh = reader.GetInt32(21);
health.destid = reader.GetInt32(22);
health.refLink = reader.GetString(23);
healthPackages.Add(health);
}
}
}
db.Close();
}
}
return(healthPackages);
}
catch
{
return(null);
}
}
