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