public IQueryable<ResourceSites> GetActiveSites()
{
ResourceSitesDataContext dc = new ResourceSitesDataContext();
IQueryable<ResourceSites> Result = from s in dc.ResourceSites
where s.Active.Equals(true)
select s;
return Result;
}
public object GetActiveList()
{
HttpContext context = HttpContext.Current;
if (context.Cache["ActiveResourceList" ] == null)
{
ResourceSitesDataContext dc = new ResourceSitesDataContext();
IQueryable<vActiveResourceSites> Result = dc.vActiveResourceSites.OrderBy(p => p.Name);
context.Cache.Insert("ActiveResourceList", Result, null, DateTime.Now.AddMinutes(CachingTime), TimeSpan.Zero);
}
return (IQueryable<vActiveResourceSites>)context.Cache["ActiveResourceList" ];
}
public IQueryable <vResourseSiteCats> GetActiveSites()
{
ResourceSitesDataContext dc = new ResourceSitesDataContext();
return(dc.vResourseSiteCats.Where(p => p.ActiveCat.Equals(true)));
}
public vResourseSiteCats GetSingleSite(int SiteCatCode)
{
ResourceSitesDataContext dc = new ResourceSitesDataContext();
return(dc.vResourseSiteCats.SingleOrDefault(p => p.Code.Equals(SiteCatCode)));
}
public object GetRandResources()
{
ResourceSitesDataContext dc = new ResourceSitesDataContext();
return dc.vRandDataResources;
}
public BaseBOLResourseSiteCats(params int[] MCodes)
{
MasterCode = Convert.ToInt32(MCodes[0]);
dataContext = new ResourceSitesDataContext();
}
public BaseBOLResourceSites()
{
dataContext = new ResourceSitesDataContext();
}
