public PageCollection FetchByQuery(Query qry)
{
PageCollection coll = new PageCollection();
coll.LoadAndCloseReader(qry.ExecuteReader());
return(coll);
}
public PageCollection FetchAll()
{
PageCollection coll = new PageCollection();
Query qry = new Query(Page.Schema);
coll.LoadAndCloseReader(qry.ExecuteReader());
return(coll);
}
public static MettleSystems.dashCommerce.Content.PageCollection GetPageCollection(int varRegionId)
{
SubSonic.QueryCommand cmd = new SubSonic.QueryCommand(
"SELECT * FROM dashCommerce_Content_Page INNER JOIN dashCommerce_Content_Page_Region_Map ON " +
"dashCommerce_Content_Page.PageId=dashCommerce_Content_Page_Region_Map.PageId WHERE dashCommerce_Content_Page_Region_Map.RegionId=@RegionId", Region.Schema.Provider.Name);
cmd.AddParameter("@RegionId", varRegionId, DbType.Int32);
IDataReader rdr = SubSonic.DataService.GetReader(cmd);
PageCollection coll = new PageCollection();
coll.LoadAndCloseReader(rdr);
return(coll);
}
