public static Models.WebContext.WebNews Get(int id)
{
using (var db = new Models.WebContext.WebDbContext())
{
return db.News.Find(id);
}
}
public static List<Models.WebContext.WebNews> GetNewsHomepage()
{
using(var db = new Models.WebContext.WebDbContext())
{
var news = db.News.Where(c => c.Active == true).OrderByDescending(c => c.Date).Take(15).ToList();
return news;
}
}
public static List<Models.WebContext.WebDownloads> GetDownloads()
{
using(var db = new Models.WebContext.WebDbContext())
{
var downs = db.Downloads.Where(c => c.Active == true).OrderByDescending(c => c.Principal).ToList();
return downs;
}
}
public static List<Models.WebContext.WebSlider> GetSlidersHomepage()
{
using(var db = new Models.WebContext.WebDbContext())
{
var sliders = db.Sliders.Where(c => c.Active == true).OrderByDescending(c => c.Id).ToList();
return sliders;
}
}
