public ActionResult Index()
{
FollowingModel model = new FollowingModel();
EFILE_CHIASE_SEARCHBO searchModel = new EFILE_CHIASE_SEARCHBO();
searchModel.USER_ID = GetUserInfo().ID;
EFILE_CHIASEBusiness = Get <EFILE_CHIASEBusiness>();
model.ListChiaSe = EFILE_CHIASEBusiness.GetDaTaByPage(searchModel);
SessionManager.SetValue("FollowingSearch", searchModel);
return(View(model));
}
public JsonResult getData(int indexPage, string sortQuery, int pageSize)
{
EFILE_CHIASEBusiness = Get <EFILE_CHIASEBusiness>();
var searchModel = SessionManager.GetValue("FollowingSearch") as EFILE_CHIASE_SEARCHBO;
if (searchModel == null)
{
searchModel = new EFILE_CHIASE_SEARCHBO();
}
if (!string.IsNullOrEmpty(sortQuery))
{
searchModel.sortQuery = sortQuery;
if (pageSize > 0)
{
searchModel.pageSize = pageSize;
}
SessionManager.SetValue("FollowingSearch", searchModel);
}
searchModel.USER_ID = GetUserInfo().ID;
var data = EFILE_CHIASEBusiness.GetDaTaByPage(searchModel, indexPage, pageSize);
return(Json(data));
}
public PageListResultBO <THUMUC_LUUTRU_BO> GetDaTaByPage(EFILE_CHIASE_SEARCHBO searchModel, int pageIndex = 1, int pageSize = 20)
{
var query = from chiase in this.context.EFILE_CHIASE
join nguoidung in this.context.DM_NGUOIDUNG
on chiase.SHARING_BY equals nguoidung.ID
into group1
from g1 in group1.DefaultIfEmpty()
join donvi in this.context.CCTC_THANHPHAN
on chiase.DONVI_ID equals donvi.ID
into group4
from g4 in group4.DefaultIfEmpty()
join folder in this.context.THUMUC_LUUTRU
on chiase.ITEM_ID equals folder.ID
into group2
from g2 in group2.DefaultIfEmpty()
join file in this.context.TAILIEUDINHKEM
on chiase.ITEM_ID equals file.TAILIEU_ID
into group3
from g3 in group3.DefaultIfEmpty()
where chiase.USER_ID.HasValue && chiase.USER_ID == searchModel.USER_ID &&
(!chiase.TUNGAY.HasValue || (chiase.TUNGAY.HasValue && chiase.TUNGAY.Value <= DateTime.Today)) &&
(!chiase.DENNGAY.HasValue || (chiase.DENNGAY.HasValue && chiase.DENNGAY.Value >= DateTime.Today))
select new THUMUC_LUUTRU_BO
{
ACCESS_MODIFIER = g2.ACCESS_MODIFIER,
TENTHUMUC = chiase.IS_FOLDER.HasValue && !chiase.IS_FOLDER.Value ? g3.TENTAILIEU : g2.TENTHUMUC,
ID = chiase.ITEM_ID.HasValue ? chiase.ITEM_ID.Value : 0,
IS_THUMUC = chiase.IS_FOLDER.HasValue && !chiase.IS_FOLDER.Value ? false : true,
THUMUCCHA = g3.DINHDANG_FILE,
TEN_NGUOITAO = g1.HOTEN,
TEN_DONVI = g4.NAME,
DONVI_ID = chiase.DONVI_ID,
USER_ID = chiase.USER_ID,
NGAYTAO = chiase.NGAY_CHIASE,
//PERMISSION = chiase.IS_FOLDER.HasValue && !chiase.IS_FOLDER.Value ? g3.PERMISSION : g2.PERMISSION
PERMISSION = chiase.PERMISSION
//DENNGAY = chiase.DENNGAY,
//GHICHU = chiase.GHICHU,
//ID = chiase.ID,
//ITEM_ID = chiase.ITEM_ID,
//IS_FOLDER = chiase.IS_FOLDER,
//NGAY_CHIASE = chiase.NGAY_CHIASE,
//SHARING_BY = chiase.SHARING_BY,
//TEN_NGUOIDUNG = g1.HOTEN,
//TEN_TAILIEU = (chiase.IS_FOLDER.HasValue && !chiase.IS_FOLDER.Value ? g3.TENTAILIEU : ""),
//TEN_THUMUC = (chiase.IS_FOLDER.HasValue && chiase.IS_FOLDER.Value ? g2.TENTHUMUC : ""),
//TUNGAY = chiase.TUNGAY,
//USER_ID = chiase.USER_ID
};
query = query.GroupBy(x => x.ID).Select(y => y.FirstOrDefault());
if (searchModel != null)
{
if (!string.IsNullOrEmpty(searchModel.sortQuery))
{
query = query.OrderBy(searchModel.sortQuery);
}
else
{
query = query.OrderBy(x => x.TENTHUMUC);
}
}
else
{
query = query.OrderBy(x => x.TENTHUMUC);
}
var resultmodel = new PageListResultBO <THUMUC_LUUTRU_BO>();
if (pageSize == -1)
{
var dataPageList = query.ToList();
resultmodel.Count = dataPageList.Count;
resultmodel.TotalPage = 1;
resultmodel.ListItem = dataPageList;
}
else
{
var dataPageList = query.ToPagedList(pageIndex, pageSize);
resultmodel.Count = dataPageList.TotalItemCount;
resultmodel.TotalPage = dataPageList.PageCount;
resultmodel.ListItem = dataPageList.ToList();
}
return(resultmodel);
}
