public static List <Location> getLocations(Location.LocationType type)
{
List <Location> p = new List <Location>();
SQLiteCommand command = new SQLiteCommand(
"SELECT name, ID, ParentID FROM " + type.ToString(),
dbConnection);
SQLiteDataReader reader = command.ExecuteReader();
System.Console.Out.WriteLine(command.ToString());
while (reader.Read())
{
p.Add(new Location(reader.GetString(0), type, reader.GetInt32(1), reader.GetInt32(2)));
}
return(p);
}
public static List <Location> getLocationsInLocation(Location.LocationType type, int parentID)
{
List <Location> p = new List <Location>();
SQLiteCommand command = new SQLiteCommand(
"SELECT name, ID, ParentID FROM " + type.ToString() + " " +
" WHERE ParentID = @ParentID",
dbConnection);
command.Parameters.AddWithValue("ParentID", parentID);
SQLiteDataReader reader = command.ExecuteReader();
System.Console.Out.WriteLine(command.ToString());
while (reader.Read())
{
p.Add(new Location(reader.GetString(0), type, reader.GetInt32(1), reader.GetInt32(2)));
}
return(p);
}
