public int Renew(InsuranceApplication ia)
{
SqlConnection con = new SqlConnection("server=SREERAJ-PC;integrated security=true;database=obs");
SqlCommand cmd = new SqlCommand("RenewInsuranceApplication", con);
cmd.CommandType = CommandType.StoredProcedure;
SqlParameter p1 = cmd.Parameters.AddWithValue("@CRN", ia.Crn);
SqlParameter p2 = cmd.Parameters.AddWithValue("@QID", ia.Qid);
SqlParameter returnParam = new SqlParameter();
returnParam.Value = ParameterDirection.ReturnValue;
con.Open();
cmd.ExecuteNonQuery();
return Convert.ToInt32(returnParam.Value);
}
protected void Button1_Click(object sender, EventArgs e)
{
InsuranceApplication ia = new InsuranceApplication();
ia.Crn = Convert.ToInt32(TextBox1.Text);
ia.Qid = Convert.ToInt32(TextBox2.Text);
BALInsurance bi = new BALInsurance();
int i = bi.Renew(ia);
if (i > 0)
{
Label3.Text = "Renewal Success";
}
else
{
Label3.Text = "Renewal Failure";
}
}
public int Renew(InsuranceApplication ia)
{
DALInsurance di = new DALInsurance();
return di.Renew(ia);
}
public int Approve(InsuranceApplication ia)
{
DALInsurance di = new DALInsurance();
return di.Approve(ia);
}
public int Apply(InsuranceApplication ia)
{
return dal.Apply(ia);
}