public ActionResult Shared(int pageIndex = 1, int pageSize = 20) { DM_NGUOIDUNGBusiness = Get <DM_NGUOIDUNGBusiness>(); ChiaSeTaiLieuBusiness = Get <ChiaSeTaiLieuBusiness>(); ChiaSeTaiLieuViewModel model = new ChiaSeTaiLieuViewModel(); var listUser = DM_NGUOIDUNGBusiness.GetByRole(ConfigurationManager.AppSettings["RoleShare"], user.ID); model.ListUserRequest = listUser; model.ListUserShare = listUser; var searchModel = new ChiaSeTaiLieuSearchModel(); searchModel.USER_CHIA_SE = user.ID; model.PageList = ChiaSeTaiLieuBusiness.GetPage(searchModel, pageIndex, pageSize); model.ListStatus = new List <SelectListItem>() { new SelectListItem { Text = "Chờ chia sẻ", Value = SHARE_STATUS_CONSTANT.PHE_DUYET_CHIA_SE.ToString() }, new SelectListItem { Text = "Đã chia sẻ", Value = SHARE_STATUS_CONSTANT.DA_CHIA_SE.ToString() }, }; SessionManager.Remove("SharedSearchModel"); return(View(model)); }
public JsonResult SearchApprove(FormCollection form) { ChiaSeTaiLieuBusiness = Get <ChiaSeTaiLieuBusiness>(); var searchModel = SessionManager.GetValue("ShareApproveSearchModel") as ChiaSeTaiLieuSearchModel; if (searchModel == null) { searchModel = new ChiaSeTaiLieuSearchModel(); searchModel.pageSize = 20; } searchModel.USER_YEU_CAU = form["USER_YEU_CAU"].ToIntOrNULL(); searchModel.STATUS = form["STATUS"].ToIntOrNULL(); searchModel.KEYWORD = form["KEYWORD"]; SessionManager.SetValue("ShareApproveSearchModel", searchModel); var data = ChiaSeTaiLieuBusiness.GetPage(searchModel, 1, searchModel.pageSize); return(Json(data)); }
public JsonResult getApproveRequest(int indexPage, string sortQuery, int pageSize) { ChiaSeTaiLieuBusiness = Get <ChiaSeTaiLieuBusiness>(); var searchModel = SessionManager.GetValue("ShareApproveSearchModel") as ChiaSeTaiLieuSearchModel; if (!string.IsNullOrEmpty(sortQuery)) { if (searchModel == null) { searchModel = new ChiaSeTaiLieuSearchModel(); } searchModel.sortQuery = sortQuery; if (pageSize > 0) { searchModel.pageSize = pageSize; } SessionManager.SetValue("ShareApproveSearchModel", searchModel); } var data = ChiaSeTaiLieuBusiness.GetPage(searchModel, indexPage, pageSize); return(Json(data)); }
public PageListResultBO <ChiaSeTaiLieuBO> GetPage(ChiaSeTaiLieuSearchModel searchModel, int pageIndex, int pageSize) { var query = (from share in this.context.CHIASE_TAILIEU join userRQ in this.context.DM_NGUOIDUNG on share.USER_YEU_CAU equals userRQ.ID join userShare in this.context.DM_NGUOIDUNG on share.USER_CHIA_SE equals userShare.ID into group1 from gUserShare in group1.DefaultIfEmpty() join userApprove in this.context.DM_NGUOIDUNG on share.USER_PHE_DUYET equals userApprove.ID into group2 from gUserApprove in group2.DefaultIfEmpty() orderby share.ID descending select new ChiaSeTaiLieuBO { DATE_CHIA_SE = share.DATE_CHIA_SE, DATE_YEU_CAU = share.DATE_YEU_CAU, ID = share.ID, DATE_PHE_DUYET = share.DATE_PHE_DUYET, STATUS = share.STATUS, TIEUDE = share.TIEUDE, USER_CHIA_SE = share.USER_CHIA_SE, USER_NAME_CHIA_SE = gUserShare.HOTEN, USER_NAME_YEU_CAU = userRQ.HOTEN, USER_YEU_CAU = share.USER_YEU_CAU, USER_PHE_DUYET = share.USER_PHE_DUYET, USER_NAME_PHE_DUYET = gUserApprove.HOTEN }); if (searchModel != null) { if (searchModel.STATUS.HasValue) { query = query.Where(x => x.STATUS == searchModel.STATUS); } if (searchModel.USER_CHIA_SE.HasValue) { query = query.Where(x => x.USER_CHIA_SE == searchModel.USER_CHIA_SE); } if (searchModel.USER_YEU_CAU.HasValue) { query = query.Where(x => x.USER_YEU_CAU == searchModel.USER_YEU_CAU); } if (searchModel.USER_PHE_DUYET.HasValue) { query = query.Where(x => x.USER_PHE_DUYET == searchModel.USER_PHE_DUYET); } if (!string.IsNullOrEmpty(searchModel.KEYWORD)) { query = query.Where(x => x.TIEUDE.IndexOf(searchModel.KEYWORD) >= 0); } if (!string.IsNullOrEmpty(searchModel.sortQuery)) { query = query.OrderBy(searchModel.sortQuery); } else { query = query.OrderByDescending(x => x.ID); } } var model = new PageListResultBO <ChiaSeTaiLieuBO>(); var dataPageList = query.ToPagedList(pageIndex, pageSize); var listData = dataPageList.ToList(); foreach (var item in listData) { if (item.STATUS.HasValue) { if (item.STATUS == SHARE_STATUS_CONSTANT.YEU_CAU_CHIA_SE) { item.STR_STATUS = "Chờ phê duyệt chia sẻ"; } else if (item.STATUS == SHARE_STATUS_CONSTANT.PHE_DUYET_CHIA_SE) { item.STR_STATUS = "Chờ chia sẻ"; } else if (item.STATUS == SHARE_STATUS_CONSTANT.DA_CHIA_SE) { item.STR_STATUS = "Đã chia sẻ"; } else { item.STR_STATUS = "Không chia sẻ"; } } } model.Count = dataPageList.Count; model.ListItem = listData; model.TotalPage = dataPageList.PageCount; return(model); }