public static MembersPaymentViewModel GetAllPayentMembers(Guid ParlourId, string PolicyNo, string IDNumber, int PageSize, int PageNum, string SortBy, string SortOrder) { DataSet ds = MemberPaymetsDAL.GetAllPayentMembersdt(ParlourId, PolicyNo, IDNumber, PageSize, PageNum, SortBy, SortOrder); DataTable dr = ds.Tables[0]; MembersPaymentViewModel objViewModel = new MembersPaymentViewModel(); objViewModel.MemberList = FuneralHelper.DataTableMapToList <MembersPaymentModel>(dr, true); objViewModel.TotalRecord = Convert.ToInt64(ds.Tables[1].Rows[0]["TotalRecord"].ToString()); return(objViewModel); }