public List <Beneficiary> GetBeneficiaries()
{
List <Beneficiary> beneficiaries = new List <Beneficiary>();
string connectionString = Settings.Default.SqlConnection;
SqlConnection conn = new SqlConnection(connectionString);
string query = "getBeneficiaries";
SqlCommand cmd = new SqlCommand(query, conn);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@policyNumber", policyNumber);
conn.Open();
SqlDataReader reader = cmd.ExecuteReader();
while (reader.Read())
{
PAG340MiddleWare.Beneficiary newBeneficiary = new Beneficiary();
newBeneficiary.PolicyNumber = policyNumber;
newBeneficiary.getDataWithReader(reader);
beneficiaries.Add(newBeneficiary);
}
return(beneficiaries);
}
