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