public RegionCollection FetchByQuery(Query qry)
{
RegionCollection coll = new RegionCollection();
coll.LoadAndCloseReader(qry.ExecuteReader());
return(coll);
}
public RegionCollection FetchAll()
{
RegionCollection coll = new RegionCollection();
Query qry = new Query(Region.Schema);
coll.LoadAndCloseReader(qry.ExecuteReader());
return(coll);
}
public RegionCollection FetchRegionsByPageIdAndTemplateRegionId(int pageId, int templateRegionId)
{
IDataReader reader = SPs.FetchRegionsByPageIdAndTemplateRegionId(pageId, templateRegionId).GetReader();
RegionCollection regionCollection = new RegionCollection();
regionCollection.LoadAndCloseReader(reader);
return(regionCollection);
}
public static MettleSystems.dashCommerce.Content.RegionCollection GetRegionCollection(int varPageId)
{
SubSonic.QueryCommand cmd = new SubSonic.QueryCommand(
"SELECT * FROM dashCommerce_Content_Region INNER JOIN dashCommerce_Content_Page_Region_Map ON " +
"dashCommerce_Content_Region.RegionId=dashCommerce_Content_Page_Region_Map.RegionId WHERE dashCommerce_Content_Page_Region_Map.PageId=@PageId", Page.Schema.Provider.Name);
cmd.AddParameter("@PageId", varPageId, DbType.Int32);
IDataReader rdr = SubSonic.DataService.GetReader(cmd);
RegionCollection coll = new RegionCollection();
coll.LoadAndCloseReader(rdr);
return(coll);
}
