public String SiteMap()
{
/*
* Cache = 38
* Vertice = 41
* Nifor = 1043
* Unocero= 37
*/
var id = 38;
Sitemap sitemap = new Sitemap();
sitemap.Add(new SitemapLocation
{
ChangeFrequency = SitemapLocation.eChangeFrequency.weekly,
Url = "Http://cache.news"
});
var getNews = MagazineService.GetNewsByMagazineId(id);
foreach (var item in getNews)
{
sitemap.Add(new SitemapLocation
{
ChangeFrequency = SitemapLocation.eChangeFrequency.never,
Url = "Http://cache.news/noticia/" + item.NewsId + "/" + item.Permalink
});
}
var getXml = sitemap.WriteSitemapToFile(AppDomain.CurrentDomain.BaseDirectory + "sitemap.xml");
//MUESTRA EN PANTALLA EL XML
var doc = XDocument.Load(AppDomain.CurrentDomain.BaseDirectory + "/Content/Sitemaps/" + getNews[0].Category.Magazine.Title + "sitemap.xml");
string encodedXml = HttpUtility.HtmlEncode(doc);
return(encodedXml);
}
public ActionResult MagazineNews(Int32 id)
{
var user = UserService.GetCurrentUser();
var relation = UserService.UserInMagazine(id, user.UserId);
if (!relation || !ModelState.IsValid)
{
return(RedirectToAction("Index", "Magazines"));
}
Request.Cookies.Remove("MagazineId");
SetCookie("MagazineId", id, true);
if (Request.Cookies["MagazineId"].Value == null)
{
SetMessage("Lo sentimos, ha ocurrido un error. Inténtelo de nuevo.", BootstrapAlertTypes.Danger); return(RedirectToAction("Index", "Magazines"));
}
var magazine = MagazineService.GetMagazineById(id);
if (magazine == null)
{
SetMessage("Lo sentimos, la revista no existe. Inténtelo de nuevo con una distinta.", BootstrapAlertTypes.Danger);
return(RedirectToAction("Index", "Magazines"));
}
var mostUsedCat = MagazineService.MostUsedCat(id);
var mostViewedCat = MagazineService.MostViewedCat(id);
var mostUsedCatName = "Ninguna";
if (mostUsedCat != null)
{
mostUsedCatName = mostUsedCat.Name;
}
var mostViewedCatName = "Ninguna";
if (mostViewedCat != null)
{
mostViewedCatName = mostViewedCat.Name;
}
var mostViewedCatCount = 0;
if (mostViewedCat != null)
{
mostViewedCatCount = MagazineService.GetVisitsByCategoryId(mostViewedCat.CategoryId);
}
var mostUsedCatCount = 0;
if (mostUsedCat != null)
{
mostUsedCatCount = MagazineService.MostUsedCatCount(mostUsedCat.CategoryId);
}
var newsAndVisits = MagazineService.GetNewsWithVisitsByMagazineId(id);
var viewsCounts = 0;
if (newsAndVisits != null)
{
viewsCounts = newsAndVisits.TotalVisits;
}
var newsCount = 0;
if (newsAndVisits != null)
{
newsCount = newsAndVisits.TotalNews;
}
var model = new MagazineIndexViewModel
{
MagazineId = id,
MostUsedCat = mostUsedCatName,
MostViewedCat = mostViewedCatName,
MostViewedCatCount = mostViewedCatCount,
MostUsedCatCount = mostUsedCatCount,
ViewsCount = viewsCounts,
NewsCount = newsCount,
};
//TOP 10 STATISTICS
var GetNews = MagazineService.GetNewsByMagazineId(id);
var top10Count = new List <Last10CountModel>();
foreach (var item in GetNews)
{
var addNew = new Last10CountModel
{
NewsId = item.NewsId,
NewTitle = item.Title,
Count = (item.VisitsCount ?? 0)
};
top10Count.Add(addNew);
}
var top10Visited = top10Count.OrderByDescending(x => x.Count).Take(10);
var last10Published = top10Count.Take(10);
ViewBag.Top10Visited = JsonConvert.SerializeObject(top10Visited);
ViewBag.Last10Published = JsonConvert.SerializeObject(last10Published);
//REPORTES
var reportsList = MagazineService.GetMyReports(id);
var reportList = new List <ReportViewModel>();
foreach (var item in reportsList)
{
var report = new ReportViewModel
{
ReportId = item.MediaId,
Impact = MagazineService.getProm(item.MediaId),
MediaName = MagazineService.getMedioName(item.MediaId)
};
reportList.Add(report);
}
ViewBag.Reports = null;
if (reportsList.Count > 0)
{
ViewBag.Reports = reportList;
}
ViewBag.JsonReports = JsonConvert.SerializeObject(reportList);
return(View(model));
}