public static CityCollection GetCollection()
{
CityCollection tempList = null;
using (SqlConnection myConnection = new SqlConnection(AppConfiguration.ConnectionString))
{
using (SqlCommand myCommand = new SqlCommand("usp_GetCity", myConnection))
{
myCommand.CommandType = CommandType.StoredProcedure;
myCommand.Parameters.AddWithValue("@QueryId", SelectTypeEnum.GetCollection);
myConnection.Open();
using (SqlDataReader myReader = myCommand.ExecuteReader())
{
if (myReader.HasRows)
{
tempList = new CityCollection();
while (myReader.Read())
{
tempList.Add(FillDataRecord(myReader));
}
}
myReader.Close();
}
}
}
return(tempList);
}
/// <summary>
/// Loads a collection of City objects from the database.
/// </summary>
/// <returns>A collection containing all of the City objects in the database.</returns>
public static CityCollection LoadCollection(string spName, SqlParameter[] parms)
{
CityCollection result = new CityCollection();
using (SqlDataReader reader = SqlHelper.Default.ExecuteReader(spName, parms))
{
while (reader.Read())
{
City tmp = new City();
tmp.LoadFromReader(reader);
result.Add(tmp);
}
}
return(result);
}
/// <summary>
/// Initializes a new instance of the <see cref="ViewModel"/> class.
/// </summary>
public PersonViewModel()
{
_gridCutCommand = new DelegateCommand(Cut);
_gridCopyCommand = new DelegateCommand(Copy);
_gridPasteCommand = new DelegateCommand(Paste);
_gridDeleteCommand = new DelegateCommand(Delete);
_expandCommand = new DelegateCommand(Expand);
_collapseCommand = new DelegateCommand(Collapse);
_sortAscendingCommand = new DelegateCommand(SortAscending);
_sortDescendingCommand = new DelegateCommand(SortDescending);
_clearSortingCommand = new DelegateCommand(ClearSorting);
_bestFitCommand = new DelegateCommand(BestFit);
_addAboveCommand = new DelegateCommand(AddAbove);
_addBelowCommand = new DelegateCommand(AddBelow);
_addAsChildCommand = new DelegateCommand(AddAsChild);
persons = this.CreateGenericPersonData(5, 8);
cityCollection = new ObservableCollection <string>();
foreach (var item in city)
{
CityCollection.Add(item);
}
}
