public IEnumerable<Catalog> ReadDB(int? pID)
{
IEnumerable<Catalog> iCatalog;
CatalogDataContext db = new CatalogDataContext();
iCatalog = db.ZNodeCatalogs.AsEnumerable()
.Select(row => new Catalog
{
catalogID = row.CatalogID,
isActive = row.IsActive,
title = row.Name,
portalID = (!row.PortalID.HasValue) ? 0 : (int)row.PortalID
});
if (pID.HasValue)
{
iCatalog = iCatalog.Where(row => row.portalID == pID);
}
return iCatalog;
}
public IEnumerable<PortalCatalog> ReadDB(int? pID)
{
IEnumerable<PortalCatalog> iCatalog;
PortalCatalogDataContext db = new PortalCatalogDataContext();
CatalogDataContext dbCat = new CatalogDataContext();
iCatalog = db.ZNodePortalCatalogs.AsEnumerable()
.Join( dbCat.ZNodeCatalogs,
_PCat => _PCat.CatalogID,
_CData => _CData.CatalogID,
(_PCat, _CData) => new
{
_CData.Name,
_CData.IsActive,
_PCat.CatalogID,
_PCat.LocaleID,
_PCat.PortalCatalogID,
_PCat.PortalID,
_PCat.Theme,
_PCat.CSS
}
)
.Select(row => new PortalCatalog
{
catalogID = row.CatalogID,
CSS = row.CSS,
portalID = row.PortalID,
localeID = row.LocaleID,
portalCatalogID = row.PortalCatalogID,
name = row.Name,
theme = row.Theme,
isActive = row.IsActive
});
if (pID.HasValue)
{
iCatalog = iCatalog.Where(row => row.portalID == pID);
}
return iCatalog;
}
