//Create a sortable observable collection to hold the TravelPackage data public static ObservableCollection <TravelPack> GetData() { var travelPackages = new ObservableCollection <TravelPack>(); const string GetTravelQuery = "SELECT * FROM PackageTable"; 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 = GetTravelQuery; using (SqliteDataReader reader = cmd.ExecuteReader()) { while (reader.Read()) { var package = new TravelPack(); package.dcode = reader.GetString(1); package.dest = reader.GetString(2); package.locate = reader.GetString(3); package.descript = reader.GetString(4); package.HW = reader.GetInt32(5); package.FAM = reader.GetInt32(6); package.ADV = reader.GetInt32(7); package.CRU = reader.GetInt32(8); package.WED = reader.GetInt32(9); package.SPA = reader.GetInt32(10); package.AMUSE = reader.GetInt32(11); package.HISTORIC = reader.GetInt32(12); package.CAMP = reader.GetInt32(13); package.ENTERTAIN = reader.GetInt32(14); package.hw = reader.GetInt32(15); package.fam = reader.GetInt32(16); package.adv = reader.GetInt32(17); package.cru = reader.GetInt32(18); package.wed = reader.GetInt32(19); package.priceLow = reader.GetInt32(20); package.priceHigh = reader.GetInt32(21); package.DESTId = reader.GetInt32(22); package.refLink = reader.GetString(23); travelPackages.Add(package); } } } db.Close(); } } return(travelPackages); } catch { return(null); } }
public int CompareTo(object obj) { TravelPack package = obj as TravelPack; if (package == null) { throw new ArgumentException("Object is not a Travel Package"); } return(this.priceLow.CompareTo(package.priceLow)); }