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