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); }
public static void SavePageMap(int varRegionId, PageCollection items) { QueryCommandCollection coll = new SubSonic.QueryCommandCollection(); //delete out the existing QueryCommand cmdDel = new QueryCommand("DELETE FROM dashCommerce_Content_Page_Region_Map WHERE RegionId=@RegionId", Region.Schema.Provider.Name); cmdDel.AddParameter("@RegionId", varRegionId); coll.Add(cmdDel); DataService.ExecuteTransaction(coll); foreach (Page item in items) { PageRegionMap varPageRegionMap = new PageRegionMap(); varPageRegionMap.SetColumnValue("RegionId", varRegionId); varPageRegionMap.SetColumnValue("PageId", item.GetPrimaryKeyValue()); varPageRegionMap.Save(); } }
public PageCollection FetchByID(object PageId) { PageCollection coll = new PageCollection().Where("PageId", PageId).Load(); return(coll); }