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