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); } }