public override void saveToDataBase()
{
holder.saveToDataBase();
String connectionString = PAG340MiddleWare.Properties.Settings.Default.SqlConnection;
SqlConnection conn = new SqlConnection(connectionString);
String query = "addPolicy";
SqlCommand cmd = new SqlCommand(query);
cmd.CommandType = System.Data.CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@policyNumber", policyNumber);
cmd.Parameters.AddWithValue("@holderID", holder.ID);
cmd.Parameters.AddWithValue("@empID", representativeAgent.ID);
cmd.Parameters.AddWithValue("@holderDOB", holder.BirthDate);
if (fathersAgeAtDeath > 0)
{
cmd.Parameters.AddWithValue("@fatherDeath", fathersAgeAtDeath);
}
if (fathersAgeAtDeath > 0)
{
cmd.Parameters.AddWithValue("@motherDeath", fathersAgeAtDeath);
}
cmd.Parameters.AddWithValue("@cigsPerDay", cigsPerDay);
cmd.Parameters.AddWithValue("@smokeHistory", smokingHis);
cmd.Parameters.AddWithValue("@sysBP", systolicBldPressure);
cmd.Parameters.AddWithValue("@aGramsFat", gramsFatPerDay);
int booleanValue = (heartDisease) ? 1 : 0;
cmd.Parameters.AddWithValue("@heartDisease", booleanValue);
booleanValue = (cancer) ? 1 : 0;
cmd.Parameters.AddWithValue("@cancer", booleanValue);
booleanValue = (hospitalized) ? 1 : 0;
cmd.Parameters.AddWithValue("@hospitalized", booleanValue);
cmd.Parameters.AddWithValue("@dangerousActivities", dangerousActivities);
cmd.Parameters.AddWithValue("@startDate", startDate);
//if(endDate.ToString() != "00010101") cmd.Parameters.AddWithValue("@endDate", endDate);
cmd.Parameters.AddWithValue("@payoffAmount", payOffAmount);
cmd.Parameters.AddWithValue("@monthlyPremium", premium);
cmd.Connection = conn;
conn.Open();
cmd.ExecuteNonQuery();
conn.Close();
beneficiary.saveToDataBase();
}
