public void ActionIndex(MSearchModel model)
{
// Lay thong tin user dang nhap
int loaiTV = 0, userId = 0;
CPUserEntity user = CPLogin.CurrentUserOnWeb;
if (user != null)
{
loaiTV = user.MenuID;
userId = user.ID;
}
// Lay id chuyen muc la "Tin noi bo"
int tinNoiBoId = 0;
WebMenuEntity menu = WebMenuService.Instance.CreateQuery()
.Where(o => o.Activity == true && o.Code == "TinNoiBo")
.ToSingle();
if (menu != null)
{
tinNoiBoId = menu.ID;
}
var dbQuery = ModNewsService.Instance.CreateQuery()
.Where(o => o.Activity == true)
.Where(!string.IsNullOrEmpty(model.Keyword), o => o.Name.Contains(model.Keyword))
.WhereIn(o => o.MenuID, WebMenuService.Instance.GetChildIDForWeb_Cache("News", 0, ViewPage.CurrentLang.ID));
if (userId == 0)
{ // Neu khong dang nhap thi khong cho phep tim kiem tin noi bo va tin canh bao
dbQuery = dbQuery
.Where(o => o.MenuID != tinNoiBoId && o.WarnNews == false);
}
else
{ // Neu dang nhap thi cho phep tim kiem tin noi bo va tin canh bao ung voi user duoc phep xem
string userIds = userId.ToString();
if (loaiTV > 0)
{
dbQuery = dbQuery.Where(o => o.LoaiThanhVienID == 0 || o.LoaiThanhVienID == null || (o.LoaiThanhVienID > 0 && o.LoaiThanhVienID == loaiTV));
}
dbQuery = dbQuery.Where(o => o.WarnNews == false || (o.WarnNews == true && o.WarnUserIDs.Contains(userIds)));
}
dbQuery = dbQuery
.OrderByDesc(o => o.Order)
.Take(PageSize)
.Skip(PageSize * model.Page);
ViewBag.Data = dbQuery.ToList();
model.TotalRecord = dbQuery.TotalRecord;
model.PageSize = PageSize;
ViewBag.Model = model;
}
public void ActionIndex(MSearchModel model)
{
var dbQuery = ModNewsService.Instance.CreateQuery()
.Where(o => o.Activity == true)
.Where(!string.IsNullOrEmpty(model.Keyword), o => o.Name.Contains(model.Keyword))
.WhereIn(o => o.MenuID, WebMenuService.Instance.GetChildIDForWeb_Cache("News", 0, ViewPage.CurrentLang.ID))
.OrderByDesc(o => o.Order)
.Take(PageSize)
.Skip(PageSize * model.Page);
ViewBag.Data = dbQuery.ToList();
model.TotalRecord = dbQuery.TotalRecord;
model.PageSize = PageSize;
ViewBag.Model = model;
}
public void ActionIndex(MSearchModel model)
{
var dbQuery = ModNewsService.Instance.CreateQuery()
.Where(o => o.Activity == true)
.Where(!string.IsNullOrEmpty(model.Keyword), o => o.Name.Contains(model.Keyword))
.WhereIn(o => o.MenuID, WebMenuService.Instance.GetChildIDForWeb_Cache("News", 0, ViewPage.CurrentLang.ID))
.OrderByDesc(o => o.Order)
.Take(PageSize)
.Skip(PageSize * model.Page);
ViewBag.Data = dbQuery.ToList();
model.TotalRecord = dbQuery.TotalRecord;
model.PageSize = PageSize;
ViewBag.Model = model;
}