public IQueryable <GYM.COMMON.Model.ViewModel.MemberRegistrationGridModel> GetAll(GYM.COMMON.Library.QueryParameters queryParameters, int userId)
{
IQueryable <GYM.COMMON.Model.ViewModel.MemberRegistrationGridModel> allItems = (from member in _context.MemberRegistration
where member.Createdby == userId
join plan in _context.PlanMaster on member.PlanID equals plan.PlanID
join scheme in _context.SchemeMaster on member.SchemeID equals scheme.SchemeID
select new GYM.COMMON.Model.ViewModel.MemberRegistrationGridModel()
{
MemberName = member.MemberFName + '|' + member.MemberMName + '|' + member.MemberLName,
MemberNo = member.MemberNo,
JoiningDate = member.JoiningDate,
SchemeName = scheme.SchemeName,
PlanName = plan.PlanName,
MemberId = member.MemberId,
Contactno = member.Contactno,
EmailId = member.EmailId
}).AsQueryable().OrderBy("MemberId",
queryParameters.IsDescending());
if (queryParameters.HasQuery())
{
allItems = allItems
.Where(x => x.MemberName.ToLowerInvariant().Contains(queryParameters.Query.ToLowerInvariant()));
}
return(allItems
.Skip(queryParameters.PageCount * (queryParameters.Page - 1))
.Take(queryParameters.PageCount));
}
public static bool HasQuery(this QueryParameters queryParameters)
{
return(!String.IsNullOrEmpty(queryParameters.Query));
}
public static bool HasNext(this QueryParameters queryParameters, int totalCount)
{
return(queryParameters.Page < (int)GetTotalPages(queryParameters, totalCount));
}
public static double GetTotalPages(this QueryParameters queryParameters, int totalCount)
{
return(Math.Ceiling(totalCount / (double)queryParameters.PageCount));
}
public static bool HasPrevious(this QueryParameters queryParameters)
{
return(queryParameters.Page > 1);
}
