public StateOrRegionCollection FetchByQuery(Query qry)
{
StateOrRegionCollection coll = new StateOrRegionCollection();
coll.LoadAndCloseReader(qry.ExecuteReader());
return(coll);
}
/// <summary>
/// Fetches the state or region by country code.
/// </summary>
/// <param name="code">The code.</param>
/// <returns></returns>
public StateOrRegionCollection FetchStateOrRegionByCountryCode(string code)
{
IDataReader reader = SPs.FetchStateOrRegionByCountryCode(code).GetReader();
StateOrRegionCollection stateOrRegionCollection = new StateOrRegionCollection();
stateOrRegionCollection.LoadAndCloseReader(reader);
return(stateOrRegionCollection);
}
public StateOrRegionCollection FetchAll()
{
StateOrRegionCollection coll = new StateOrRegionCollection();
Query qry = new Query(StateOrRegion.Schema);
coll.LoadAndCloseReader(qry.ExecuteReader());
return(coll);
}
public StateOrRegionCollection FetchByID(object StateOrRegionId)
{
StateOrRegionCollection coll = new StateOrRegionCollection().Where("StateOrRegionId", StateOrRegionId).Load();
return(coll);
}