// Check for an invalid manager id
cursor = database.cursor("select * from cl_person where p_id = " +
request.mgr);
if (cursor.next() == false)
badmgr = true;
else
badmgr = false;
cursor.close();
if (badmgr)
// Try again
redirect("ma-badmgr.htm");
// Find a unique id
project.lock();
if (project.nextEnrollID == null)
// Property doesn't exist, do a database lookup
project.nextEnrollID = getNewID("cl_enroll", "e_id");
else
// Increment the previous value
project.nextEnrollID = 1 + parseInt(project.nextEnrollID);
project.unlock();
// Get the class info
cursor = database.cursor("select * from cl_master where c_id = " +
request.id);
cursor.next();
// Get the course manager's info
cmgr = database.cursor("select * from cl_person where p_id = " +
cursor.c_mgr);
cmgr.next();
// Get the student manager's info
smgr = database.cursor("select * from cl_person where p_id = " +
request.mgr);
smgr.next();
// Get the user's info
user = database.cursor("select * from cl_person where p_id = " +
client.uid);
user.next();
// Figure out who the send the request to (course or student manager)
if (cursor.c_email_ind == "C")
{
tomail = cmgr.p_email;
toname = cmgr.p_name;
}
else
{
tomail = smgr.p_email;
toname = smgr.p_name;
}
tomail = trim(tomail);
toname = trim(toname);
// Update the enrollment table
now = new Date();
database.execute("insert into cl_enroll values(" +
cursor.c_id + "," +
project.nextEnrollID + "," +
client.uid + "," +
smgr.p_id + ",'" +
dbdate(now) + "',null,null,null,null)");
// Craft a short message for e-mail
msg = trim(user.p_name) + " would like to enroll in " +
trim(cursor.c_title);
// Generate a prompt
write("A message has been generated asking for
" +
trim(cursor.c_title) + "
");
write("Please click "Send Mail" to send it to " + tomail +
"
");
user.close();
smgr.close();
cmgr.close();
cursor.close();