protected void btnApprove_Click(object sender, EventArgs e)
    {
        String customerid;
        String appid=Session["ApplicationId"].ToString();

        ApplicationBL abl = new ApplicationBL();
        CustomerBL cbl = new CustomerBL();
        AccountBL acbl = new AccountBL();

        abl.UpdateApplicationStatus(appid, 3);
        customerid= cbl.InsertCustomer(appid);
        acbl.InsertAccount(appid, customerid);

        Response.Redirect("/ScheinyNickelBank.WebUI/ApplicationConfirm.aspx");
    }
    public void BindAccountData()
    {
        AccountBL abl = new AccountBL();
        DataSet ads = abl.GetAccount(customerid);

        ddlAccountsTran.DataTextField = "account_number";
        ddlAccountsTran.DataSource = ads;
        ddlAccountsTran.DataBind();

        ddlAccountsDepWdwl.DataTextField = "account_number";
        ddlAccountsDepWdwl.DataSource = ads;
        ddlAccountsDepWdwl.DataBind();

        gvAccountSummary.DataSource = ads;
        gvAccountSummary.DataBind();
    }