public static void createInsurance(int memberID)
{
string connection = "server=localhost; User Id=root; password=8milerun; database=csc430project;";
MySqlConnection con = new MySqlConnection(connection);
con.Open();
var query = "INSERT INTO insurance(memberID, insuranceCompany, insurancePolicy, groupNumber) VALUES(@memberID, @insuranceCo, @insurancePol, @groupNum);";
MySqlCommand cmd = new MySqlCommand(query, con);
cmd.Parameters.AddWithValue("@memberID", memberID);
cmd.Parameters.AddWithValue("@insuranceCo", Insurance.getInsuranceCompany());
cmd.Parameters.AddWithValue("@insurancePol", Insurance.getInsurancePolicy());
cmd.Parameters.AddWithValue("@groupNum", Insurance.getGroupNumber());
cmd.ExecuteNonQuery();
con.Close();
}
public static void updateInsurance(int tempMemberID)
{
string connection = "server=localhost; User Id=root; password=8milerun; database=csc430project;";
MySqlConnection con = new MySqlConnection(connection);
con.Open();
var query = "UPDATE insurance SET memberID = @memberID, insuranceCompany = @insuranceCo, insurancePolicy = @insurancePol, groupNumber = @groupNum WHERE memberID = @tempMemberID;";
MySqlCommand cmd = new MySqlCommand(query, con);
cmd.Parameters.AddWithValue("@tempMemberID", tempMemberID);
cmd.Parameters.AddWithValue("@memberID", Insurance.getMemberID());
cmd.Parameters.AddWithValue("@insuranceCo", Insurance.getInsuranceCompany());
cmd.Parameters.AddWithValue("@insurancePol", Insurance.getInsurancePolicy());
cmd.Parameters.AddWithValue("@groupNum", Insurance.getGroupNumber());
cmd.ExecuteNonQuery();
con.Close();
}