/* 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.action == "insert") {
database.execute("insert into dependent (employee_ssn, ssn, name, action, birthdate, relationship, pcp_name, pcp_no, prev_seen, obgyn_name, obgyn_no, obgyn_prev_seen, medicare, medicare_no, medicaid_no, handicapped, full_time_student, school, grad_date) values (" + client.ssn + ", " + request.ssn + ", '" + request.name + "', '" + request.action + "', '" + request.birthdate + "', '" + request.relationship + "', '" + request.pcp_name + "', '" + request.pcp_no + "', '" + request.prev_seen + "', '" + request.obgyn_name + "', '" + request.obgyn_no + "', '" + request.obgyn_prev_seen + "', '" + request.medicare + "', '" + request.medicare_no + "', '" + request.medicaid_no + "', '" + request.handicapped + "', '" + request.full_time_student + "', '" + request.school + "', '" + request.grad_date + "')");
} else {
database.execute("update dependent set name = '" + request.name + "', action = '" + request.action + "', birthdate = '" + request.birthdate + "', relationship = '" + request.relationship + "', pcp_name = '" + request.pcp_name + "', pcp_no = '" + request.pcp_no + "', prev_seen = '" + request.prev_seen + "', obgyn_name = '" + request.obgyn_name + "', obgyn_no = '" + request.obgyn_no + "', obgyn_prev_seen = '" + request.obgyn_prev_seen + "', medicare = '" + request.medicare + "', medicare_no = '" + request.medicare_no + "', medicaid_no = '" + request.medicaid_no + "', handicapped = '" + request.handicapped + "', full_time_student = '" + request.full_time_student + "', school = '" + request.school + "', grad_date = '" + request.grad_date + "' where employee_ssn = " + client.ssn + " and ssn = " + request.ssn + "");
}
database.execute("update status set cs4 = 'yes' where employee_ssn = " + client.ssn + "");
project.unlock();
redirect("dep.htm");