protected void BtnDeleteUser_ServerClick(object sender, EventArgs e)
 {
     SourceUsersEdit.Delete();
     GvwDetails.DataBind();
     GvwAccounts.DataBind();
     ScriptManager.RegisterStartupScript(BtnDeleteUser, GetType(), "DeleteUserDetModal",
                                         @"$('#DeleteUserDetModal').modal('hide');", true);
 }
 protected void BtnUpdateUserDet_ServerClick(object sender, EventArgs e)
 {
     if (IsValid)
     {
         FvwUserDet.UpdateItem(true);
         GvwDetails.DataBind();
         GvwAccounts.DataBind();
         ScriptManager.RegisterStartupScript(BtnUpdateUserDet, GetType(), "editUserModal",
                                             @"$('#editUserModal').modal('hide');", true);
         ScriptManager.RegisterStartupScript(BtnUpdateUserDet, GetType(), "UpdateNotifModal",
                                             @"$('#UpdateNotifModal').modal('toggle');", true);
     }
 }
        protected void BtnSearchUserlGrid_Click(object sender, EventArgs e)
        {
            if (TbxSearchUserlGrid.Text != string.Empty)
            {
                string h_user = CleanString(TbxSearchUserlGrid.Text);
                SourceUsers.SelectCommand = "SELECT borrowerID, firstName, middleName, lastName, " +
                                            "countryName, cityName FROM completeBorrowerData WHERE " +
                                            $"CONTAINS(firstName,'\"{h_user}*\"') OR CONTAINS(middleName,'\"{h_user}*\"') " +
                                            $"OR CONTAINS(lastName,'\"{h_user}*\"') OR CONTAINS(countryName,'\"{h_user}*\"') " +
                                            $"OR CONTAINS(cityName,'\"{h_user}*\"')";
            }

            GvwDetails.DataBind();
        }