protected void btnSignUp_Click1(object sender, EventArgs e)
{
if (tbPass1.Text.Equals(tbPass2.Text))
{
DBconnection dbc = new DBconnection();
string qu = "Exec sp_InsertUser @un='" + tbName.Text + "', @em='" + tbEmail.Text + "',@uph='" + tbPhone.Text + "',@udob='" + Convert.ToDateTime(tbDOB.Text) + "',@pas='******'";
bool r = dbc.iud(qu);
Response.Write("<script> alert('Successful sign up') </script>");
}
else
{
Response.Write("<script> alert('Invalid sign up. Passwords do not match')</script>");
}
}
protected void btnConfirm_Click(object sender, EventArgs e)
{
DBconnection dbl = new DBconnection();
string que = "Exec sp_InsertLoan @uid=" + ab + ",@pro='" + ddProfession.Text + "',@am=" + Convert.ToDouble(tbAmount.Text) + ",@sal=" + Convert.ToDouble(tbSalary.Text) + ",@dep=" + Convert.ToInt32(tbDependencies.Text) + ",@rea='" + ddReason.Text + "',@ts=" + Convert.ToInt32(tbTimeSpan.Text) + ",@inte=" + Convert.ToDouble(lblInter.Text) + ",@insta=" + Convert.ToDouble(lblInstallments.Text);
bool k = dbl.iud(que);
if (k == true)
{
Response.Write("<script>alert('Loan Requested')</script>");
}
if (k == false)
{
Response.Write("<script>alert('Loan could not be requested')</script>");
}
}