protected void Button1_Click(object sender, EventArgs e)
{
InsuranceApplication ia = new InsuranceApplication();
ia.Qid = Convert.ToInt32(TextBox1.Text);
ia.ChassissNo = TextBox2.Text;
ia.EngineNo = Convert.ToInt32(TextBox3.Text);
bal.Apply(ia);
}
//[Route("InsuranceApplication")]
public IHttpActionResult PostinsuranceForm(dynamic InsForm)
{
try
{
if (InsForm != null)
{
try
{
int uid = InsForm.Userid;
int Iid = (from l in db.InsuranceApplications
where l.UserID == uid
select l.PolicyNo).First();
return(Ok("You have already applied for Insurance.Your Policy number is " + Iid.ToString() + " .Please use this number for future claim. "));
}
catch
{
int uid = InsForm.Userid;
int fid = (from l in db.FarmerLands
where l.UserID == uid
select l.FarmId).First();
InsuranceApplication insuranceApplication = new InsuranceApplication();
insuranceApplication.season = InsForm.season;
/*this.Insurance.season = season.value;
* this.Insurance.year = year.value;
* this.Insurance.cropname = cropname.value;
* this.Insurance.SumInsured = suminsured.value;
* this.Insurance.Area = area.value;
* this.Insurance.Userid = 1;*/
insuranceApplication.year = InsForm.year;
insuranceApplication.cropname = InsForm.cropname;
insuranceApplication.SumInsured = InsForm.SumInsured;
insuranceApplication.FarmId = fid;
insuranceApplication.UserID = uid;
db.InsuranceApplications.Add(insuranceApplication);
db.SaveChanges();
int PolicyNo = (from i in db.InsuranceApplications
where i.UserID == uid
select i.PolicyNo).FirstOrDefault();
return(Ok("Added succesufully.Your Policy number is " + PolicyNo.ToString() + " .Please use this number for future claim. "));
}
}
else
{
return(BadRequest("Data is not fatched from form"));
}
}
catch (Exception e)
{
return(BadRequest(e.Message));
}
}
public int Renew(InsuranceApplication InsuranceApplicationobj)
{
SqlCommand cmd = dbc.getSqlCommand("RenewInsuranceApplication");
cmd.CommandType = CommandType.StoredProcedure;
SqlParameter p1 = cmd.Parameters.AddWithValue("@CRN", InsuranceApplicationobj.Crn);
SqlParameter p2 = cmd.Parameters.AddWithValue("@QID", InsuranceApplicationobj.Qid);
SqlParameter returnParam = new SqlParameter();
returnParam.Value = ParameterDirection.ReturnValue;
dbc.con.Open();
cmd.ExecuteNonQuery();
return(Convert.ToInt32(returnParam.Value));
}
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));
}
public int Apply(InsuranceApplication ia)
{
SqlCommand cmd = dbc.getSqlCommand("ApplyQuotation");
cmd.CommandType = CommandType.StoredProcedure;
SqlParameter p1 = cmd.Parameters.AddWithValue("@qid", ia.Qid);
SqlParameter p2 = cmd.Parameters.AddWithValue("@chassiss_no", ia.ChassissNo);
SqlParameter p3 = cmd.Parameters.AddWithValue("@engine_no", ia.EngineNo);
SqlParameter returnParam = new SqlParameter();
returnParam.Value = ParameterDirection.ReturnValue;
dbc.con.Open();
cmd.ExecuteNonQuery();
dbc.con.Close();
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));
}
