/// <summary> /// Get All Members from database and bind here. /// </summary> public void BindMember() { gvMembers.PageSize = PageSize; MembersPaymentViewModel model = client.GetAllPayentMembers(ParlourId, txtPolicyNo.Text, txtIDNo.Text, PageSize, PageNum, SortBy, SortOrder); gvMembers.DataSource = model.MemberList; gvMembers.DataBind(); //gvMembers.Columns[1].Visible = false; }
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); }