public List <AdmissionReportViewModel> GetAdmissionReport(int Facility_Id, int page) { var models = db.CYCA_NewAdmissionsFacilityReport(Facility_Id).ToList(); var viewModels = new List <AdmissionReportViewModel>(); foreach (var m in models) { viewModels.Add(new AdmissionReportViewModel { Facility_Id = m.Facility_Id, ProvinceName = m.Province, RegionName = m.Region, CenterName = m.FacilityName, AdmissionDate = Convert.ToDateTime(m.Admission_Date).ToShortDateString(), FullName = m.FullName, admissionReason = m.Admission_Reason, Age = m.Age, Gender = m.Description }); } var pageSize = 10; var count = viewModels.Count(); var data = viewModels.Skip(page * pageSize).Take(pageSize).ToList(); this.ViewBag.MaxPage = (count / pageSize) - (count % pageSize == 0 ? 1 : 0); this.ViewBag.Page = page; return(data); }