public static List<News> GetNews(out long PageCount,
long? NewsId = null, string NewsText = null,
DateTime? FromDate = null, DateTime? ToDate = null,
NewsStatusType? newsStatusType = NewsStatusType.Confirmed,
int? newsCategoryId = null,
int PageIndex = 0, int PageSize = DefaultPageSize)
{
int? newsStatusTypeId = null;
if (newsStatusType.HasValue)
newsStatusTypeId = (int)newsStatusType;
using (var ctx = new BMIKidsEntities(ConnectionString))
{
var q = from m in ctx.News.Include("NewsCategories")
where (!NewsId.HasValue || m.NewsId == NewsId) &&
(!FromDate.HasValue || m.CreateDateTime >= FromDate) &&
(!ToDate.HasValue || m.CreateDateTime <= ToDate) &&
(!newsCategoryId.HasValue || m.NewsCategories.Any(o => o.NewsCategoryId == newsCategoryId)) &&
(!newsStatusTypeId.HasValue || m.Status == newsStatusTypeId) &&
(string.IsNullOrEmpty(NewsText) || m.Summary.Contains(NewsText) || m.Body.Contains(NewsText))
orderby m.CreateDateTime descending
select m;
PageCount = q.LongCount();
return q.Skip(PageIndex * PageSize).Take(PageSize).ToList();
}
}
public static IEnumerable<DynamicPageType> GetDynamicPageType()
{
using (var e = new BMIKidsEntities(ConnectionString))
{
var q = from a in e.DynamicPageTypes
select a;
return q.ToList();
}
}
public static void SaveDynamicPage(DynamicPage p)
{
using (var ctx = new BMIKidsEntities(ConnectionString))
{
ctx.DynamicPages.ApplyChanges(p);
ctx.SaveChanges();
p.AcceptChanges();
}
}
public static DynamicPage GetDynamicPageById(long? PageId)
{
using (var e = new BMIKidsEntities(ConnectionString))
{
var q = from a in e.DynamicPages
where (!PageId.HasValue || a.PageId == PageId.Value)
select a;
return q.FirstOrDefault();
}
}
public static News GetNews(long? NewsId = null)
{
using (var ctx = new BMIKidsEntities(ConnectionString))
{
var q = from m in ctx.News.Include("NewsCategories")
where (!NewsId.HasValue || m.NewsId == NewsId)
select m;
return q.FirstOrDefault();
}
}
public static void SaveNews(News news)
{
using (var ctx = new BMIKidsEntities(ConnectionString))
{
if (news.ChangeTracker.State == ObjectState.Unchanged)
news.MarkAsModified();
ctx.News.ApplyChanges(news);
ctx.SaveChanges();
news.AcceptChanges();
}
}
public static List<NewsCategory> GetNewsCategory(int? NewsCategoryId = null, String NewsCategoryName = null,bool? IsVisible=true, int PageIndex = 1, int PageSize = DefaultPageSize)
{
using (var ctx = new BMIKidsEntities(ConnectionString))
{
var q = from m in ctx.NewsCategories
where (!NewsCategoryId.HasValue || m.NewsCategoryId == NewsCategoryId) &&
(!IsVisible.HasValue || m.IsVisibleCategory == IsVisible) &&
(string.IsNullOrEmpty(NewsCategoryName) || m.NewsCategoryName == NewsCategoryName)
orderby m.NewsCategoryName
select m;
return q.Skip((PageIndex - 1) * PageSize).Take(PageSize).ToList();
}
}
public static List<DynamicPage> GetDynamicPage(out int RecordCount, long? PageId = null,
int[] PageTypeIds = null, string PageName = null,
long? ParentPageId = null,
int _PageSize = DefaultPageSize, int Currentpage = 1)
{
using (var e = new BMIKidsEntities(ConnectionString))
{
if (PageTypeIds != null && PageTypeIds.Any())
{
var q = from a in e.DynamicPages.WhereIn(o => o.PageTypeId, PageTypeIds)
where
(!PageId.HasValue || a.PageId == PageId.Value) &&
(!ParentPageId.HasValue || a.ParentPageId == ParentPageId.Value) &&
(string.IsNullOrEmpty(PageName) || a.PageName == PageName)
orderby a.PageId ascending
select a;
RecordCount = q.Count();
return q.Skip((Currentpage - 1) * _PageSize).Take(_PageSize).ToList();
}
else
{
var q = from a in e.DynamicPages
where
(!PageId.HasValue || a.PageId == PageId.Value) &&
(!ParentPageId.HasValue || a.ParentPageId == ParentPageId.Value) &&
(string.IsNullOrEmpty(PageName) || a.PageName == PageName)
orderby a.PageId ascending
select a;
RecordCount = q.Count();
return q.Skip((Currentpage - 1) * _PageSize).Take(_PageSize).ToList();
}
}
}