public JsonResult Items(int pageNumber)
{
var model = new Contents();
model.GetContentPageWiseReleaseAll(pageNumber, PageSize);
var sb = new StringBuilder();
foreach (Content cnt in model)
{
sb.Append(cnt.ToUnorderdListItem);
}
return Json(new
{
ListItems = sb.ToString()
});
}
private Contents LoadRecentArticles()
{
var cnts = new Contents();
cnts.GetContentPageWiseReleaseAll(1, CountOfNewsItemsOnHomepage);
return cnts;
}
public ActionResult Index()
{
var model = new Contents();
model.GetContentPageWiseReleaseAll(1, PageSize);
return View(model);
}
protected void Page_Load(object sender, EventArgs e)
{
int minWordCount = 300;
string siteDomain = string.Format("{0}/", GeneralConfigs.SiteDomain);
Response.Clear();
Response.ContentType = "text/xml";
var writer = new XmlTextWriter(Response.OutputStream, Encoding.UTF8);
writer.WriteStartDocument();
writer.WriteStartElement("urlset");
writer.WriteAttributeString("xmlns", "http://www.sitemaps.org/schemas/sitemap/0.9");
writer.WriteString(Environment.NewLine);
// home
writer.WriteStartElement("url");
writer.WriteElementString("loc", siteDomain);
writer.WriteElementString("lastmod", String.Format("{0:yyyy-MM-dd}", DateTime.UtcNow));
writer.WriteElementString("changefreq", "daily");
writer.WriteElementString("priority", "1.0");
writer.WriteEndElement();
writer.WriteString(Environment.NewLine);
// news
var contents = new Contents();
contents.GetContentPageWiseReleaseAll(1, 10000);
foreach (Content c1 in contents)
{
string text = c1.ContentDetail;
if (text.Split(' ').Length < minWordCount) continue;
writer.WriteStartElement("url");
writer.WriteElementString("loc", string.Format("{0}news/{1}", siteDomain, c1.ContentKey.ToLower()));
DateTime lastmod = c1.ReleaseDate;
if (c1.Comments != null && c1.Comments.Count > 0)
{
lastmod = c1.Comments[c1.Comments.Count - 1].CreateDate;
}
writer.WriteElementString("lastmod", String.Format("{0:yyyy-MM-dd}", lastmod));
writer.WriteElementString("changefreq", "monthly");
writer.WriteElementString("priority", "0.8");
writer.WriteEndElement();
writer.WriteString(Environment.NewLine);
}
using (var context = new DasKlubDbContext())
{
List<ForumCategory> forumCategory = context.ForumCategory
.OrderBy(x => x.CreateDate)
.ToList();
foreach (ForumCategory category in forumCategory)
{
ForumCategory category1 = category;
IQueryable<ForumSubCategory> subForums =
context.ForumSubCategory.Where(x => x.ForumCategoryID == category1.ForumCategoryID);
using (var context2 = new DasKlubDbContext())
{
foreach (ForumSubCategory thread in subForums)
{
string text = thread.Description;
IQueryable<ForumPost> allPosts =
context2.ForumPost.Where(x => x.ForumSubCategoryID == thread.ForumSubCategoryID);
var allPostText = new StringBuilder();
foreach (ForumPost item in allPosts)
{
allPostText.Append(item.Detail);
}
allPostText.Append(text);
if (allPostText.ToString().Split(' ').Length < minWordCount)
{
continue;
}
writer.WriteStartElement("url");
writer.WriteElementString("loc", thread.SubForumURL.ToString().ToLower());
ForumSubCategory thread1 = thread;
ForumPost lastPost = context2.ForumPost
.Where(post => post.ForumSubCategoryID == thread1.ForumSubCategoryID)
.OrderByDescending(post => post.CreateDate).FirstOrDefault();
writer.WriteElementString("lastmod",
lastPost != null
? String.Format("{0:yyyy-MM-dd}", lastPost.CreateDate)
: String.Format("{0:yyyy-MM-dd}", thread.CreateDate));
writer.WriteElementString("changefreq", "daily");
writer.WriteElementString("priority", "0.8");
writer.WriteEndElement();
writer.WriteString(Environment.NewLine);
int totalCount =
context2.ForumPost.Count(x => x.ForumSubCategoryID == thread.ForumSubCategoryID);
int pageCount = (totalCount + ForumController.PageSize - 1)/
ForumController.PageSize;
if (pageCount <= 1) continue;
for (int i = 2; i <= pageCount; i++)
{
writer.WriteStartElement("url");
writer.WriteElementString("loc",
string.Format("{0}/{1}", thread.SubForumURL, i).ToLower());
writer.WriteElementString("lastmod", String.Format("{0:yyyy-MM-dd}", thread.CreateDate));
writer.WriteElementString("changefreq", "weekly");
writer.WriteElementString("priority", "0.8");
writer.WriteEndElement();
writer.WriteString(Environment.NewLine);
}
}
}
}
}
writer.WriteEndElement();
writer.WriteEndDocument();
writer.Flush();
Response.End();
}
