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); }