<%@ page language="java"
import="java.sql.*, java.io.*, java.util.*, users.databases.*"
errorPage="error.jsp"
%>
<%
/***** VARIABLE DECLARATION and INITIALIZATION *****/
String strMainDB = "product_pgpClientInfoDB";
String strPageID = "mempwdedj";// USE TO IDENTIFY MESSAGE ON tmpTblMessages IF BELONGS TO THIS PAGE
String strMessage = "
Please fill up the following:";
String strFileName = "";
int intUserID = Integer.parseInt(request.getParameter("uid"));
int intCompanyID = Integer.parseInt(request.getParameter("cid"));
int intCounter = Integer.parseInt(request.getParameter("ctr"));
byte bytDeptID = Byte.parseByte(request.getParameter("did"));
String strFrom = request.getParameter("fr");
/***** END OF VARIABLE DECLARATION *****/
String SQLstmt = "SELECT LogOnStatus FROM tblLogOn WHERE Usr_ID=" + intUserID + ";";
users.connect(strMainDB);
ResultSet rs = users.listQuery(SQLstmt);
byte bytLogStatus = 0;
while (rs.next()) {
bytLogStatus = rs.getByte("LogOnStatus");
}
if (bytLogStatus != 1) { // LOG CHECK RESULT - LOG-OUT, DISPLAYS HOME PAGE
%>
<%
} else { // LOG CHECK RESULT - LOG-ON, PROCEED DISPLAYING ACTUAL PAGE
SQLstmt = "SELECT * FROM tmpTblMessages WHERE Usr_ID=" + intUserID + " AND Co_ID=" + intCompanyID +
" AND Page_ID='" + strPageID + "';";
rs = users.listQuery(SQLstmt);
while (rs.next()) {
strMessage = rs.getString("Message");
}
SQLstmt = "DELETE FROM tmpTblMessages WHERE Usr_ID=" + intUserID + " AND Co_ID=" + intCompanyID +
" AND Page_ID='" + strPageID + "';";
users.updateData(SQLstmt);
users.disconnect();
if (strFrom.equals("main")) {
switch (bytDeptID) {
case 6:
strFileName = "bpmain.jsp?uid=" + intUserID + "&cid=" + intCompanyID + "&did=6&srt=0&p1=0&p2=40";
break;
case 7:
strFileName = "bpmain.jsp?uid=" + intUserID + "&cid=" + intCompanyID + "&did=7&srt=0&p1=0&p2=40";
break;
case 8:
strFileName = "bdmain.jsp?uid=" + intUserID + "&cid=" + intCompanyID + "&did=8";
break;
case 9:
strFileName = "bdmain.jsp?uid=" + intUserID + "&cid=" + intCompanyID + "&did=9";
break;
case 11:
strFileName = "cpmain.jsp?uid=" + intUserID + "&cid=" + intCompanyID + "&did=11&p1=0&p2=5";
break;
default:
strFileName = "ofcmain.jsp?uid=" + intUserID + "&cid=" + intCompanyID + "&did=" + bytDeptID;
} // END OF SWITCH
} else {
strFileName = "usrmain.jsp?uid=" + intUserID + "&cid=" + intCompanyID + "&did=" + bytDeptID;
} // END OF if (strFrom.equals("main"))
if (strMessage.equals("ok") || intCounter==100000) {
/***** MERGING WITH MAIN HTML CODES STARTS HERE *****/
%>
Infinity
<% } else { %>
Change Password
<%= strMessage %>
<% } // END OF if (strMessage.equals("ok")) %>
<% } // END OF if (bytLogStatus != 1) %>