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);
}
