// GET: ModuleArea/Module
public ActionResult Index()
{
var searchModel = new ModuleSearchDTO();
SessionManager.SetValue("ModuleSearch", new ModuleSearchDTO());
ModuleIndexViewModel viewModel = new ModuleIndexViewModel()
{
GroupData = _moduleService.GetDataByPage(searchModel)
};
return(View(viewModel));
}
public JsonResult SearchData(FormCollection form)
{
var searchModel = SessionManager.GetValue("ModuleSearch") as ModuleSearchDTO;
if (searchModel == null)
{
searchModel = new ModuleSearchDTO();
searchModel.pageSize = 20;
}
searchModel.QueryCode = form["QUERY_CODE"];
searchModel.QueryName = form["QUERY_NAME"];
searchModel.QueryIcon = form["QUERY_ICON"];
searchModel.QueryClassCss = form["QUERY_CLASS_CSS"];
searchModel.QueryStyleCss = form["QUERY_STYLE_CSS"];
searchModel.QueryIsShow = !string.IsNullOrEmpty(form["QUERY_SHOW"]) ? (bool?)(int.Parse(form["QUERY_SHOW"]) > 0) : null;
SessionManager.SetValue("ModuleSearch", searchModel);
var data = _moduleService.GetDataByPage(searchModel, 1);
return(Json(data));
}
public JsonResult GetData(int indexPage, string sortQuery, int pageSize)
{
var searchModel = SessionManager.GetValue("ModuleSearch") as ModuleSearchDTO;
if (searchModel == null)
{
searchModel = new ModuleSearchDTO();
}
if (!string.IsNullOrEmpty(sortQuery))
{
searchModel.sortQuery = sortQuery;
}
if (pageSize > 0)
{
searchModel.pageSize = pageSize;
}
SessionManager.SetValue("ModuleSearch", searchModel);
var data = _moduleService.GetDataByPage(searchModel, indexPage, pageSize);
return(Json(data));
}
public PageListResultBO <ModuleDTO> GetDataByPage(ModuleSearchDTO searchParams, int pageIndex = 1, int pageSize = 20)
{
var queryResult = (from module in this._moduleRepository.GetAllAsQueryable()
join operation in this._operationRepository.GetAllAsQueryable()
on module.Id equals operation.ModuleId
into groupOperation
select new ModuleDTO()
{
Id = module.Id,
Code = module.Code,
Name = module.Name,
IsShow = module.IsShow,
Order = module.Order,
Icon = module.Icon,
ClassCss = module.ClassCss,
StyleCss = module.StyleCss,
OperationQuantity = groupOperation.Count()
});
if (searchParams != null)
{
if (!string.IsNullOrEmpty(searchParams.QueryCode))
{
searchParams.QueryCode = searchParams.QueryCode.Trim().ToLower();
queryResult = queryResult.Where(x => x.Code.Trim().ToLower().Contains(searchParams.QueryCode));
}
if (!string.IsNullOrEmpty(searchParams.QueryName))
{
searchParams.QueryName = searchParams.QueryName.Trim().ToLower();
queryResult = queryResult.Where(x => x.Name.Trim().ToLower().Contains(searchParams.QueryName));
}
if (searchParams.QueryIsShow != null)
{
queryResult = queryResult.Where(x => x.IsShow == searchParams.QueryIsShow.Value);
}
if (!string.IsNullOrEmpty(searchParams.QueryIcon))
{
searchParams.QueryIcon = searchParams.QueryIcon.Trim().ToLower();
queryResult = queryResult.Where(x => x.Icon.Trim().ToLower().Contains(searchParams.QueryIcon));
}
if (!string.IsNullOrEmpty(searchParams.QueryClassCss))
{
searchParams.QueryClassCss = searchParams.QueryClassCss.Trim().ToLower();
queryResult = queryResult.Where(x => x.ClassCss.Trim().ToLower().Contains(searchParams.QueryClassCss));
}
if (!string.IsNullOrEmpty(searchParams.QueryStyleCss))
{
searchParams.QueryStyleCss = searchParams.QueryStyleCss.Trim().ToLower();
queryResult = queryResult.Where(x => x.StyleCss.Trim().ToLower().Contains(searchParams.QueryStyleCss));
}
if (!string.IsNullOrEmpty(searchParams.sortQuery))
{
queryResult = queryResult.OrderBy(searchParams.sortQuery);
}
else
{
queryResult = queryResult.OrderBy(x => x.Order)
.ThenBy(x => x.Name);
}
}
else
{
queryResult = queryResult.OrderBy(x => x.Order)
.ThenBy(x => x.Name);
}
var result = new PageListResultBO <ModuleDTO>();
if (pageSize == -1)
{
var pagedList = queryResult.ToList();
result.Count = pagedList.Count;
result.TotalPage = 1;
result.ListItem = pagedList;
}
else
{
var dataPageList = queryResult.ToPagedList(pageIndex, pageSize);
result.Count = dataPageList.TotalItemCount;
result.TotalPage = dataPageList.PageCount;
result.ListItem = dataPageList.ToList();
}
return(result);
}
