// GET: DmNhomDanhmucArea/DmNhomDanhmuc
public ActionResult Index()
{
var searchModel = new DM_NhomDanhmucSearchDTO();
SessionManager.SetValue(SessionSearchString, null);
var data = _dm_NhomDanhmucService.GetDataByPage(null);
return(View("Index", data));
}
public PageListResultBO <DM_NhomDanhmucDTO> GetDataByPage(DM_NhomDanhmucSearchDTO searchParams, int pageIndex = 1, int pageSize = 20)
{
var query = (from nhomDanhmuc in this._dM_NhomDanhmucRepository.GetAllAsQueryable()
select new DM_NhomDanhmucDTO()
{
Id = nhomDanhmuc.Id,
GroupCode = nhomDanhmuc.GroupCode,
GroupName = nhomDanhmuc.GroupName
});
if (searchParams != null)
{
if (!String.IsNullOrEmpty(searchParams.QueryCode))
{
query = query.Where(x => x.GroupCode.Contains(searchParams.QueryCode));
}
if (!String.IsNullOrEmpty(searchParams.QueryName))
{
query = query.Where(x => x.GroupName.Contains(searchParams.QueryName));
}
if (!string.IsNullOrEmpty(searchParams.sortQuery))
{
query = query.OrderBy(searchParams.sortQuery);
}
else
{
query = query.OrderByDescending(x => x.Id);
}
}
else
{
query = query.OrderByDescending(x => x.Id);
}
var result = new PageListResultBO <DM_NhomDanhmucDTO>();
if (pageSize == -1)
{
var pagedList = query.ToList();
result.Count = pagedList.Count;
result.TotalPage = 1;
result.ListItem = pagedList;
}
else
{
var dataPageList = query.ToPagedList(pageIndex, pageSize);
result.Count = dataPageList.TotalItemCount;
result.TotalPage = dataPageList.PageCount;
result.ListItem = dataPageList.ToList();
}
return(result);
}
public JsonResult SearchData(FormCollection form)
{
var searchModel = SessionManager.GetValue(SessionSearchString) as DM_NhomDanhmucSearchDTO;
if (searchModel == null)
{
searchModel = new DM_NhomDanhmucSearchDTO();
searchModel.pageSize = 20;
}
searchModel.QueryName = form["QueryName"];
searchModel.QueryCode = form["QueryCode"].ToUpper();
SessionManager.SetValue(SessionSearchString, searchModel);
var data = _dm_NhomDanhmucService.GetDataByPage(searchModel, 1, searchModel.pageSize);
return(Json(data));
}
public JsonResult GetData(int indexPage, string sortQuery, int pageSize)
{
var searchModel = SessionManager.GetValue(SessionSearchString) as DM_NhomDanhmucSearchDTO;
if (searchModel == null)
{
searchModel = new DM_NhomDanhmucSearchDTO();
}
if (!string.IsNullOrEmpty(sortQuery))
{
searchModel.sortQuery = sortQuery;
}
if (pageSize > 0)
{
searchModel.pageSize = pageSize;
}
SessionManager.SetValue(SessionSearchString, searchModel);
var data = _dm_NhomDanhmucService.GetDataByPage(searchModel, indexPage, pageSize);
return(Json(data));
}
