public virtual PagedList <HopDong> GetAllHopDong(string mahopdong = "",
string tenhopdong = "",
int pageIndex = 0,
int pageSize = int.MaxValue,
bool showHidden = false,
int OwnerID = 0,
ENTrangThaiHopDong trangthai = ENTrangThaiHopDong.TatCa)
{
var query = _hopdongRepository.Table;
if (!showHidden)
{
query = query.Where(m => m.TrangThaiID != (int)ENTrangThaiHopDong.Huy);
}
if (!String.IsNullOrWhiteSpace(mahopdong))
{
query = query.Where(m => m.MaHopDong.Contains(mahopdong));
}
if (!String.IsNullOrWhiteSpace(tenhopdong))
{
query = query.Where(m => m.TenHopDong.Contains(tenhopdong));
}
if (trangthai != ENTrangThaiHopDong.TatCa)
{
query = query.Where(m => m.TrangThaiID == (int)trangthai);
}
if (OwnerID > 0)
{
query = query.Where(m => m.NguoiTaoID == OwnerID);
}
query = query.OrderBy(m => m.MaHopDong);
return(new PagedList <HopDong>(query, pageIndex, pageSize));
}
public ActionResult ListHopDong(DataSourceRequest command, HopDongListModel model)
{
if (!_permissionService.Authorize(StandardPermissionProvider.QLHopDong))
{
return(AccessDeniedView());
}
int nguoitaoid = _workContext.CurrentCustomer.Id;
ENTrangThaiHopDong trangthaiid = ENTrangThaiHopDong.TatCa;
if (_permissionService.Authorize(StandardPermissionProvider.CVSaleManager))
{
nguoitaoid = model.NguoiTaoId;
trangthaiid = (ENTrangThaiHopDong)model.TrangThaiID;
}
var hopdongs = _chonveService.GetAllHopDong(model.TimMaHopDong, model.TimTenHopDong,
command.Page - 1, command.PageSize, false, nguoitaoid, trangthaiid);
var gridModel = new DataSourceResult
{
Data = hopdongs.Select(x =>
{
var m = x.ToModel();
m.TrangThaiText = x.TrangThai.GetLocalizedEnum(_localizationService, _workContext);
return(m);
}),
Total = hopdongs.TotalCount
};
return(Json(gridModel));
}