protected void LinkAccount(object sender, EventArgs e) { SagicorLifeServices.SagicorLifeConnectSoapClient client = new SagicorLifeServices.SagicorLifeConnectSoapClient(); if (client.CheckSagicor(AccountNumber.Text, AccountEmail.Text, AccountPhoneNum.Text)) { string inCmd = "insert into LinkedSagicorAccounts values (@CustUserName, @FlowAccNum)"; SqlCommand cmd = new SqlCommand(inCmd, con); cmd.Parameters.AddWithValue("@CustUserName", CustomerID); cmd.Parameters.AddWithValue("@FlowAccNum", AccountNumber.Text); cmd.ExecuteNonQuery(); Response.Redirect("~/LinkFlowSagicor.aspx"); } else { LinkStatus.Visible = true; StatusText.Text = "No account with entered credentials were found"; } }