/* Check to make sure we are connected to the database before allowing access to the home page. If not connected, go connect and initialize; otherwise, welcome the user.\ */ if(!database.connected()) redirect("init.htm"); project.lock(); if (client.primary_action == "insert") { database.execute("insert into primary_coverage (employee_ssn, plan_code, medicare_elig, medicare_no, medicaid_no) values (" + client.ssn + ", " + 9 + ", '" + request.medicare_elig + "', '" + request.medicare_no + "', '" + request.medicaid_no + "')"); } if (client.primary_action == "update") { database.execute("update primary_coverage set medicare_elig = '" + request.medicare_elig + "', medicare_no = '" + request.medicare_no + "', medicaid_no = '" + request.medicaid_no + "' where employee_ssn = " + client.ssn + ""); } if (client.secondary_action == "insert") { database.execute("insert into secondary_coverage (employee_ssn, plan_name, effective_date, participant_name, policy_no, group_no) values (" + client.ssn + ", '" + request.plan_name + "', '" + request.effective_date + "', '" + request.participant_name + "', '" + request.policy_no + "', '" + request.group_no + "')"); } if (client.secondary_action == "update") { database.execute("update secondary_coverage set plan_name = '" + request.plan_name + "', effective_date = '" + request.effective_date + "', participant_name = '" + request.participant_name + "', policy_no = '" + request.policy_no + "', group_no = '" + request.group_no + "' where employee_ssn = " + client.ssn + ""); } if (client.previous_action == "insert") { database.execute("insert into previous_coverage (employee_ssn, prev_cov_thisplan, names, effective_date1, employment_status, prev_cov_withco, prior_carrier, effective_date2) values (" + client.ssn + ", '" + request.prev_cov_thisplan + "', '" + request.names + "', '" + request.effective_date1 + "', '" + request.employment_status + "', '" + request.prev_cov_withco + "', '" + request.prior_carrier + "', '" + request.effective_date2 + "')"); } if (client.previous_action == "update") { database.execute("update previous_coverage set prev_cov_thisplan = '" + request.prev_cov_thisplan + "', names = '" + request.names + "', effective_date1 = '" + request.effective_date1 + "', employment_status = '" + request.employment_status + "', prev_cov_withco = '" + request.prev_cov_withco + "', prior_carrier = '" + request.prior_carrier + "', effective_date2 = '" + request.effective_date2 + "' where employee_ssn = " + client.ssn + ""); } database.execute("update status set cs3 = 'yes' where employee_ssn = " + client.ssn + ""); project.unlock(); redirect("areas.htm");