public List <ExtendedSelectListItem> GetSitemapListURLByContent(int domainID, string selectedUrl)
{
tbl_ContentType type = ContentTypeRepository.GetByType(ContentType.Content);
if (type == null)
{
return(null);
}
List <ExtendedSelectListItem> sections = new List <ExtendedSelectListItem>();
foreach (var section in SitemapRepository.GetByContentTypeID(type.ContentTypeID, domainID).OrderBy(c => c.SM_OrderBy))
{
var parent = sections.FirstOrDefault(s => s.ID == section.SM_ParentID);
if (sections.Contains(parent))
{
string appendix = String.Empty;
int level = parent.Level;
while (level > 0)
{
appendix += " "; level--;
}
sections.Insert(sections.IndexOf(parent) + 1, new ExtendedSelectListItem
{
Text = appendix + section.SM_Name,
Value = section.SM_URL,
Selected = section.SM_URL == selectedUrl,
Level = parent.Level + 1,
ID = section.SiteMapID
});
}
else
{
sections.Add(new ExtendedSelectListItem
{
Text = section.SM_Name,
Value = section.SM_URL,
Selected = section.SM_URL == selectedUrl,
Level = 1,
ID = section.SiteMapID
});
}
}
return(sections);
}
public List <tbl_Content> GetContentByContentType(ContentType contentType, int domainID, int top)
{
tbl_ContentType type = ContentTypeRepository.GetByType(contentType);
if (type == null)
{
return(null);
}
var sitemaps = SitemapRepository.GetByContentTypeID(type.ContentTypeID, domainID)
.Where(c => (contentType != ContentType.Blog || (c.SM_Live && (c.SM_PublishDate == null || c.SM_PublishDate <= DateTime.Now))))
.OrderByDescending(b => b.SM_Date).Take(top);
if (sitemaps == null || sitemaps.Count() == 0)
{
return(null);
}
return(sitemaps.Select(s => s.tbl_Content.Where(c => c.C_Approved && !c.C_Deleted).OrderByDescending(c => c.C_ModificationDate).FirstOrDefault()).Where(b => b != null).ToList());
}
public List <ExtendedSelectListItem> GetSitemapListByContent(int domainID, int selectedSitemapID)
{
tbl_ContentType type = ContentTypeRepository.GetByType(ContentType.Content);
if (type == null)
{
return(null);
}
List <ExtendedSelectListItem> sections = new List <ExtendedSelectListItem>();
foreach (var section in SitemapRepository.GetByContentTypeID(type.ContentTypeID, domainID).OrderBy(c => c.SM_OrderBy))
{
var parent = sections.FirstOrDefault(s => s.Value == section.SM_ParentID.ToString());
if (sections.Contains(parent))
{
sections.Insert(sections.IndexOf(parent) + 1, new ExtendedSelectListItem
{
Text = section.SM_Name,
Value = section.SiteMapID.ToString(),
Selected = section.SiteMapID == selectedSitemapID,
Level = parent != null ? parent.Level + 1 : 1
});
}
else
{
sections.Add(new ExtendedSelectListItem
{
Text = section.SM_Name,
Value = section.SiteMapID.ToString(),
Selected = section.SiteMapID == selectedSitemapID,
Level = parent != null ? parent.Level + 1 : 1
});
}
}
return(sections);
}
public List <tbl_SiteMap> GetSitemapByContentType(ContentType contentType, int domainID)
{
tbl_ContentType type = ContentTypeRepository.GetByType(contentType);
if (type == null)
{
return(new List <tbl_SiteMap>());
}
var sitemaps = SitemapRepository.GetByContentTypeID(type.ContentTypeID, domainID).ToList();
switch (contentType)
{
case ContentType.Product:
sitemaps = sitemaps.Where(s => s.tbl_Products != null).ToList();
break;
case ContentType.Category:
sitemaps = sitemaps.Where(s => s.tbl_ProdCategories != null).ToList();
break;
}
return(sitemaps);
}