public List <Gallery> GetGalleries()
{
using (Hammer.Core.Models.SiteDataContext db = new Hammer.Core.Models.SiteDataContext())
{
var list = from l in db.Galleries.AsEnumerable()
select l;
return(list.ToList());
}
}
public List <Video> GetVideos()
{
using (Hammer.Core.Models.SiteDataContext db = new Hammer.Core.Models.SiteDataContext())
{
var list = from l in db.Videos.AsEnumerable()
select l;
return(list.ToList());
}
}
public List <GalleryDetail> GetGalleryDetails()
{
using (Hammer.Core.Models.SiteDataContext db = new Hammer.Core.Models.SiteDataContext())
{
var list = from l in db.GalleryDetails.AsEnumerable()
where l.GalleryID == 2
select l;
return(list.ToList());
}
}
public List <BlogCategory> GetCategories()
{
using (Hammer.Core.Models.SiteDataContext db = new Hammer.Core.Models.SiteDataContext())
{
var list = from l in db.BlogCategories.AsEnumerable()
where l.CategoryName != "公司介绍"
select l;
return(list.ToList());
}
}
public List <Blog> GetBulletin()
{
using (Hammer.Core.Models.SiteDataContext db = new Hammer.Core.Models.SiteDataContext())
{
var list = from l in db.Blogs.AsEnumerable()
where l.CategoryID == 7
select l;
return(list.ToList());
}
}
public List <Blog> GetBlogs(int id)
{
using (Hammer.Core.Models.SiteDataContext db = new Hammer.Core.Models.SiteDataContext())
{
var list = from l in db.Blogs.AsEnumerable()
where l.CategoryID == id
orderby l.SortOrder descending
select l;
return(list.ToList());
}
}
public List <SelectListItem> GetCourse()
{
using (Hammer.Core.Models.SiteDataContext db = new Hammer.Core.Models.SiteDataContext())
{
var list = from l in db.Blogs.AsEnumerable()
where l.CategoryID == 1 && l.IsPublic == true
orderby l.BlogID descending
select new SelectListItem {
Text = l.BlogTitle, Value = l.BlogID.ToString()
};
return(list.ToList());
}
}
public List <SelectListItem> GetBlogCategoryList()
{
using (Hammer.Core.Models.SiteDataContext db = new Hammer.Core.Models.SiteDataContext())
{
var list = from l in db.BlogCategories.AsEnumerable()
where l.CategoryName != "公司介绍"
orderby l.CategoryName
select new SelectListItem {
Value = l.CategoryID.ToString(), Text = l.CategoryName
};
return(list.ToList());
}
}
