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