/* 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 transaction (ssn, trans_type, trans_desc, other_desc, e_effective_date, e_qual_event, c_effective_date, c_qual_event) values (" + client.ssn + ", '" + request.trans_type + "', '" + request.trans_desc + "', '" + request.other_desc + "', '" + request.e_effective_date + "', '" + request.e_qual_event + "', '" + request.c_effective_date + "', '" + request.c_qual_event + "')");
} else {
database.execute("update transaction set trans_type = '" + request.trans_type + "', trans_desc = '" + request.trans_desc + "', other_desc = '" + request.other_desc + "', e_effective_date = '" + request.e_effective_date + "', e_qual_event = '" + request.e_qual_event + "', c_effective_date = '" + request.c_effective_date + "', c_qual_event = '" + request.c_qual_event + "' where ssn = " + client.ssn + "");
}
database.execute("update status set cs1 = 'yes' where employee_ssn = " + client.ssn + "");
project.unlock();
redirect("areas.htm");