/* 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");