当我在MVC视图中尝试第二个页面时，ToPagedList并没有给出值

Question

我使用实体框架在Asp.net MVC中获取记录。为此，我使用PagedList进行分页。在这种情况下，当我为第1页获取记录时，它会给我适当的记录，而我试图为第二页获取记录，它不会返回记录。

public MW_AppointmentsWithCount CurrentAppointmentsWithLanguage(int PatientID, int languageId, int page, int pageSize)
{
MW_AppointmentsWithCount lstAppCount = new MW_AppointmentsWithCount();
using (MWCoreEntity db = new MWCoreEntity())
{
List<MW_Appointments> result = db.MW_Appointments.Where(x => x.PatientID == PatientID && x.Status < 5).ToList();
foreach (var item in result)
{
item.MW_Consultants = db.MW_Consultants.Where(x => x.UserId == item.ConsultantID && x.LanguageID == languageId).FirstOrDefault();
}
lstAppCount.mW_Appointments = result;
lstAppCount.totalCount = result.Count();
PagedList<MW_Appointments> model = new PagedList<MW_Appointments>(result, page, pageSize);
//in below line when there is page 2 then it's giving 0 values. While in model there is records as per pageSize and page.
lstAppCount.mW_Appointments = model.ToPagedList(page, pageSize).ToList();
return lstAppCount;
}
}

Answer 1

MW_AppointmentsWithCount CurrentAppointmentsWithLanguage(int PatientID, int languageId, int page, int pageSize)
{
MW_AppointmentsWithCount lstAppCount = new MW_AppointmentsWithCount();
using (MWCoreEntity db = new MWCoreEntity())
{
List<MW_Appointments> result = db.MW_Appointments.Where(x => x.PatientID == PatientID && x.Status < 5).ToList();
foreach (var item in result)
{
item.MW_Consultants = db.MW_Consultants.Where(x => x.UserId == item.ConsultantID && x.LanguageID == languageId).FirstOrDefault();
}
lstAppCount.mW_Appointments = result;
lstAppCount.totalCount = result.Count();
return result.ToPagedList(page, pageSize);

}
}