public ActionResult AllReports(int?pageno) { //var Allreports = (from l in db.ReportMasters // join c in db.CategoryMasters // on l.CategoryId equals c.CategoryId // join p in db.PublisherMasters // on l.PublisherId equals p.PublisherId // orderby l.CreatedDate descending // //where l.FullDescription.Replace("<[^>]+>| ", "").Trim().Contains(@"<[^>]+>| ", "") // select new ReportVM // { // ReportTitle = l.ReportTitle, // ReportUrl = l.ReportURL, // FullDescription = l.FullDescription.Substring(0, 300), // NumberOfPage = l.NumberOfPage, // CategoryId = l.CategoryId, // PublishingDate = l.PublishingDate, // PriceSingleUser = l.PriceSingleUser, // CategoryName = c.CategoryName, // CategoryUrl=c.CategoryUrl, // PublisherName=p.CompanyName, // PublisherId=p.PublisherId, // PublishingUrl=p.PublisherUrl // }).ToList(); ViewBag.activemenu = "Report"; ObjectParameter count = new ObjectParameter("p_Count", 0); var Allreports = (from r in db.spNewAllLatestReport(pageno ?? 1, count).ToList() select new ReportVM { ReportTitle = r.ReportTitle, CategoryId = r.CategoryId, PublishingDate = Convert.ToDateTime(r.PublishingDate), ReportUrl = r.ReportUrl, PriceSingleUser = r.SinglePrice, FullDescription = r.LongDescription, NumberOfPage = r.NumberOfPages, CategoryName = r.CategoryName, CategoryUrl = r.CategoryUrl, PublisherName = r.PublisherName, PublisherId = r.PublisherId, PublishingUrl = r.publisherUrl, RepImageCat = 0 }).ToList(); foreach (var item in Allreports) { item.ReportImage = DDLGetparents(item.CategoryId); } var result = Allreports.Select(x => new ReportVM { ReportTitle = x.ReportTitle, ReportUrl = x.ReportUrl, FullDescription = Regex.Replace(x.FullDescription, @"<[^>]+>| ", "").Trim(), NumberOfPage = x.NumberOfPage, CategoryId = x.CategoryId, PublishingDate = x.PublishingDate, PriceSingleUser = x.PriceSingleUser, CategoryName = x.CategoryName, CategoryUrl = x.CategoryUrl, PublisherName = x.PublisherName, PublisherId = x.PublisherId, PublishingUrl = x.PublishingUrl, ReportImage = x.ReportImage }).ToList(); var reports = new StaticPagedList <ReportVM>(result, pageno ?? 1, 10, Convert.ToInt32(count.Value)); ViewBag.Totalreports = reports.TotalItemCount; ViewBag.Title = "All Latest Market Research Reports | Excellent Market Research"; ViewBag.Description = "Excellent Market Research Provides All Latest Market Research Reports of Different Categories and Custom Reports"; ViewBag.Keywords = "Latest Reports, Trending Reports, Custom Reports, "; return(View(reports)); }