// Process the request
private String processRequest(HttpServletRequest request, HttpServletResponse response) {
String command = request.getParameter("command");
String id = request.getParameter("id");
String description = request.getParameter("description");
String status = request.getParameter("rstatus");
status = (status != null && status.compareTo(" ") > 0) ? status : null;
String outLine = "";
// String nextScript = "home.jsp";
String nextScript = request.getParameter("nextscript");
OutputStream toClient;
HttpSession session = request.getSession();
boolean success = false;
String userIDs = (String) session.getAttribute("user.id");
long userID = Long.parseLong(userIDs);
command = (command != null && command.compareTo(" ") > 0) ? command : "form";
nextScript = (nextScript != null && nextScript.compareTo(" ") > 0) ? nextScript : "roles.jsp";
// inputstring = (inputstring != null && inputstring.compareTo(" ") > 0) ? inputstring : "";
DbConn myConn = null;
try {
Context initCtx = new InitialContext();
// String csiSchema = (String) initCtx.lookup("java:comp/env/csi-schema-path");
String acronym = (String) initCtx.lookup("java:comp/env/SystemAcronym");
myConn = new DbConn();
String csiSchema = myConn.getSchemaPath();
if (command.equals("add")) {
Role item = new Role();
item.setDescription(description);
item.setStatus(status);
getPermissions(request, item);
getPositions(request, item);
item.add(myConn, userID);
GlobalMembership.refresh(myConn);
success = true;
outLine = "";
} else if (command.equals("update")) {
Role item = new Role(myConn, Long.parseLong(id));
item.setDescription(description);
item.setStatus(status);
getPermissions(request, item);
getPositions(request, item);
item.save(myConn, userID);
GlobalMembership.refresh(myConn);
success = true;
outLine = "";
} else if (command.equals("drop")) {
Role item = new Role(myConn, Long.parseLong(id));
item.drop(myConn, userID);
success = true;
outLine = "Role " + item.getDescription() + " Removed";
} else if (command.equals("test")) {
outLine = "test";
}
} catch (IllegalArgumentException e) {
outLine = outLine + "IllegalArgumentException caught: " + e.getMessage();
ALog.logActivity(userID, "csi", 0, "Role error: '" + outLine + "'");
// log(outLine);
} catch (NullPointerException e) {
outLine = outLine + "NullPointerException caught: " + e.getMessage();
ALog.logActivity(userID, "csi", 0, "Role error: '" + outLine + "'");
// log(outLine);
}
// catch (IOException e) {
// outLine = outLine + "IOException caught: " + e.getMessage();
// ALog.logActivity(userID, "csi", 0, "Role error: '" + outLine + "'");
// //log(outLine);
// }
catch (Exception e) {
outLine = outLine + "Exception caught: " + e.getMessage();
ALog.logActivity(userID, "csi", 0, "Role error: '" + outLine + "'");
// log(outLine);
} finally {
try {
generateResponse(outLine, command, nextScript, success, response);
} catch (Exception i) {
}
myConn.release();
// log("Test log message\n");
}
return outLine;
}
// Process the request
private String processRequest(HttpServletRequest request, HttpServletResponse response) {
HttpSession session = request.getSession();
String userIDs = (String) session.getAttribute("user.id");
userIDs = (userIDs != null && userIDs.compareTo(" ") > 0) ? userIDs : "0";
long userID = Long.parseLong(userIDs);
String command = request.getParameter("command");
String template = request.getParameter("template");
String pageHash = request.getParameter("pagehash");
String pageTitle = request.getParameter("pagetitle");
String pageDescription = request.getParameter("pagedescription");
String outLine = "";
String nextScript = request.getParameter("nextscript");
OutputStream toClient;
boolean success = false;
// System.out.println("userid=" + userID + ", id=" + id + ", command=" + command);
command = (command != null && command.compareTo(" ") > 0) ? command : "form";
nextScript = (nextScript != null && nextScript.compareTo(" ") > 0) ? nextScript : "simple1.jsp";
// inputstring = (inputstring != null && inputstring.compareTo(" ") > 0) ? inputstring : "";
DbConn myConn = null;
try {
Context initCtx = new InitialContext();
// String csiSchema = (String) initCtx.lookup("java:comp/env/csi-schema-path");
// String acronym = (String) initCtx.lookup("java:comp/env/SystemAcronym");
myConn = new DbConn();
String csiSchema = myConn.getSchemaPath();
if (userID != 0) {
if (command.equals("add")) {
outLine = "";
} else if (command.equals("update")) {
outLine = "";
} else if (command.equals("updatepage")) {
UHash uPage = new UHash(pageHash, myConn);
// System.out.println("Got Here 1");
if (template.equals("simple1")) {
TextItem title = new TextItem(uPage.get("title"), myConn);
title.setText(pageTitle);
title.save(myConn);
TextItem description = new TextItem(uPage.get("description"), myConn);
description.setText(pageDescription);
description.save(myConn);
} else if (template.equals("simple2")) {
}
} else if (command.equals("test")) {
outLine = "test";
}
success = true;
}
} catch (IllegalArgumentException e) {
outLine = outLine + "IllegalArgumentException caught: " + e.getMessage();
ALog.logActivity(userID, "csi", 0, pageHash + " error: '" + outLine + "'");
// log(outLine);
} catch (NullPointerException e) {
outLine = outLine + "NullPointerException caught: " + e.getMessage();
ALog.logActivity(userID, "csi", 0, pageHash + " error: '" + outLine + "'");
// log(outLine);
}
// catch (IOException e) {
// outLine = outLine + "IOException caught: " + e.getMessage();
// ALog.logActivity(userID, "csi", 0, pageHash + " error: '" + outLine + "'");
// //log(outLine);
// }
catch (Exception e) {
outLine = outLine + "Exception caught: " + e.getMessage();
ALog.logActivity(userID, "csi", 0, pageHash + " error: '" + outLine + "'");
// log(outLine);
} finally {
try {
generateResponse(outLine, command, nextScript, success, response);
} catch (Exception i) {
}
myConn.release();
// log("Test log message\n");
}
return outLine;
}
public void lookup(int orgid, int year, DbConn myConn) {
String outLine = "";
ResultSet rs = null;
Statement stmt = null;
// get *active* organizations
// get organization name and acronym
try {
Connection conn = myConn.conn;
stmt = conn.createStatement();
String sqlcode = null;
String wherestring = null;
String orderby = " order by name ";
if (orgid > 0) {
wherestring = " where isactive = 'T' AND id=" + orgid;
sqlcode =
"SELECT id, name, acronym, isactive, porgid FROM "
+ SCHEMAPATH
+ ".ORGANIZATION "
+ wherestring;
} else {
wherestring = " where isactive = 'T'";
sqlcode =
"SELECT id, name, acronym, isactive, porgid FROM "
+ SCHEMAPATH
+ ".ORGANIZATION "
+ wherestring
+ orderby;
}
// System.out.println(sqlcode);
rs = stmt.executeQuery(sqlcode);
while (rs.next()) {
System.out.println(
"/************** "
+ rs.getString("name")
+ ", "
+ rs.getInt("id")
+ " **************/");
SelfAssessment sa = new SelfAssessment();
SelfAssessment[] item = sa.getSAList(myConn, "id", 0, orgid, year);
for (int i = 0; i < item.length; i++) {
System.out.println("/**************" + "**************/");
sanumber = item[i].getSANumber(item[i].getOrgid(), item[i].getDivid(), myConn);
System.out.println("sanumber: " + sanumber);
teamleadid = Integer.valueOf(item[i].getTeamleadid());
String teamleadname = null;
teamleadname = item[i].getTeamleadname(teamleadid, myConn);
System.out.println("teamleadname: " + teamleadname);
title = item[i].getTitle();
System.out.println("title: " + title);
purpose = item[i].getPurpose();
System.out.println("purpose: " + purpose);
scheduleddate = item[i].getScheduleddate();
System.out.println("scheduleddate: " + scheduleddate);
rescheduleddate = item[i].getRescheduleddate();
System.out.println("rescheduleddate: " + rescheduleddate);
signeddate = item[i].getSigneddate();
System.out.println("signeddate: " + signeddate);
cancelleddate = item[i].getCancelleddate();
System.out.println("cancelleddate: " + cancelleddate);
cancelledrationale = item[i].getCancelledrationale();
System.out.println("cancelledrationale: " + cancelledrationale);
comments = item[i].getComments();
System.out.println("comments: " + comments);
hascirs = item[i].getHascirs();
System.out.println("hascirs: " + hascirs);
asstype = item[i].getAsstype();
System.out.println("asstype: " + asstype);
assobj = item[i].getAssobj();
System.out.println("assobj: " + assobj);
crlevels = item[i].getCrlevels();
System.out.println("crlevels: " + crlevels);
crnums = item[i].getCrnums();
System.out.println("crnums: " + crnums);
llnums = item[i].getLlnums();
System.out.println("llnums: " + llnums);
}
}
} catch (SQLException e) {
outLine = outLine + "SQLException caught: " + e.getMessage();
// log(outLine);
// gov.ymp.csi.db.ALog.logError(myConn, 0,"N/A",0, outLine + " - SelfAssessment lookup");
} catch (Exception e) {
outLine = outLine + "Exception caught: " + e.getMessage();
// log(outLine);
// gov.ymp.csi.db.ALog.logError(myConn, 0,"N/A",0, outLine);
} finally {
if (rs != null)
try {
rs.close();
} catch (Exception i) {
}
if (stmt != null)
try {
stmt.close();
} catch (Exception i) {
}
}
}