private void PopulateApplyLoans()
        {
            LoanService loanService = new LoanService();
            DataView dtVw = loanService.GetApplyLoans(0, string.Empty);
            if (dtVw != null)
            {
                grdView1.DataSource = dtVw;
                grdView1.DataBind();

            }
        }
        private void PopulateUserDropdown()
        {
            LoanService usrv = new LoanService();

            drpUser.DataSource = usrv.GetBorrowers(0);
            drpUser.DataTextField = "name";
            drpUser.DataValueField = "id";
            drpUser.DataBind();

            drpUser.SelectedValue = GlobalObjects.User.ID.ToString();
        }
        private void PopulateGrid()
        {
            string query = this.txtSearch.Text.Trim();
            LoanService loanService = new LoanService();
            DataView dtVw = loanService.GetAllByUser(id,query);
            if (dtVw != null)
            {
                grdView.DataSource = dtVw;
                grdView.DataBind();

            }
        }