public ActionResult PageInforIndex(int?page, int?catalogry, int?state)
{
int pageNum = (page ?? 1);
ContentItemIndexViewModel model = new ContentItemIndexViewModel();
IQueryable <ContentItem> tmp = cms_db.GetlstContentItem().Where(s => (s.MicrositeID == null || s.MicrositeID == 0) &&
s.StateId != (int)EnumCore.StateType.da_xoa && s.ObjTypeId == (int)EnumCore.ObjTypeId.page_infor);
if (catalogry.HasValue && catalogry.Value != 0)
{
tmp = tmp.Where(s => s.CategoryId == catalogry);
model.ContentCatalogry = catalogry.Value;
}
if (state.HasValue && state.Value != 0)
{
tmp = tmp.Where(s => s.StateId == state);
model.ContentState = state.Value;
}
if (tmp.Count() < (int)EnumCore.BackendConst.page_size)
{
pageNum = 1;
}
model.pageNum = pageNum;
model.lstMainContent = tmp.OrderByDescending(c => c.ContentItemId).ToPagedList(pageNum, (int)EnumCore.BackendConst.page_size);
model.lstContentState = cms_db.Getclasscatagory((int)EnumCore.ClassificationScheme.state_type);
model.lstContentCatalogry = cms_db.Getclasscatagory((int)EnumCore.ClassificationScheme.page_infor);
return(View(model));
}
public ActionResult Index(int?page, int?ContentCatalogry, int?ContentState,
int?TickerPackage, string FillterContenName, string Datetime)
{
int pageNum = (page ?? 1);
ContentItemIndexViewModel model = new ContentItemIndexViewModel();
IQueryable <ContentItem> tmp = cms_db.GetlstContentItem().Where(s => (s.MicrositeID == null || s.MicrositeID == 0) && s.StateId != (int)EnumCore.StateType.da_xoa && s.ObjTypeId == (int)EnumCore.ObjTypeId.tin_tuc);
if (ContentCatalogry.HasValue && ContentCatalogry.Value != 0)
{
tmp = tmp.Where(s => s.CategoryId == ContentCatalogry);
model.ContentCatalogry = ContentCatalogry.Value;
}
if (ContentState.HasValue && ContentState.Value != 0)
{
tmp = tmp.Where(s => s.StateId == ContentState);
model.ContentState = ContentState.Value;
}
if (TickerPackage.HasValue && TickerPackage.Value != 0)
{
foreach (ContentItem _val in tmp)
{
List <ContentPackage> lstpackageofticker = cms_db.GetlstObjContentPackage(_val.ContentItemId, (int)EnumCore.ObjTypeId.tin_tuc);
if (!lstpackageofticker.Select(s => s.PackageId).Contains(TickerPackage.Value))
{
tmp = tmp.Where(s => s.ContentItemId != _val.ContentItemId);
}
}
model.TickerPackage = TickerPackage.Value;
}
if (!String.IsNullOrEmpty(FillterContenName))
{
tmp = tmp.Where(s => s.ContentTitle.ToLower().Contains(FillterContenName.ToLower()));
model.FillterContenName = FillterContenName;
}
if (!String.IsNullOrEmpty(Datetime))
{
model.Datetime = Datetime;
model.StartDT = this.SpritDateTime(model.Datetime)[0];
model.EndDT = this.SpritDateTime(model.Datetime)[1];
tmp = tmp.Where(s => s.CrtdDT > model.StartDT && s.CrtdDT < model.EndDT);
}
if (tmp.Count() < (int)EnumCore.BackendConst.page_size)
{
pageNum = 1;
}
model.pageNum = pageNum;
model.lstMainContent = tmp.OrderByDescending(c => c.ContentItemId).ToPagedList(pageNum, (int)EnumCore.BackendConst.page_size);
foreach (ContentItem _val in model.lstMainContent)
{
List <ContentPackage> lstNewsContentPackage = cms_db.GetlstObjContentPackage(_val.ContentItemId, (int)EnumCore.ObjTypeId.tin_tuc);
foreach (ContentPackage item in lstNewsContentPackage)
{
_val.CateMicrositeName = _val.CateMicrositeName + " - " + item.PackageName;
}
}
model.lstFillterContentState = new SelectList(cms_db.Getclasscatagory((int)EnumCore.ClassificationScheme.state_type), "value", "text");
model.lstFillterContentCatalogry = new SelectList(cms_db.Getclasscatagory((int)EnumCore.ClassificationScheme.tin_tuc_bai_viet), "value", "text");
model.lstPackage = new SelectList(cms_db.GetObjSelectListPackage(), "value", "text");
return(View(model));
}
