public void update(int updateIndex[], Vector updateValue) { StringBuffer select = new StringBuffer(); select.append(columns[0]).append(" = ").append(Integer.toString(employeeID())); String updateString = getUpdateString(updateIndex, updateValue, table, columns, col_types, select.toString()); try { Application.dbConnection().execute(updateString); Application.dbConnection().commit(); } catch (SQLException e) { logger.warn("Update failed " + updateString, e); } }
public void relations() { String fetchSpec = null; Vector v = null; fetchSpec = SubMenu.getByMenuID(menuID()); v = Application.dbConnection().fetch(new SubMenu(), fetchSpec); setSubMenus(v); }
public void relations() { String fetchSpec = PosProfile.getByID(profile()); Vector v = Application.dbConnection().fetch(new PosProfile(), fetchSpec); if (v.size() > 0) { posProfile = (PosProfile) v.elementAt(0); } else { logger.warn("Pos Profile not found for employee " + employeeID()); } }
public void add() { StringBuffer str = new StringBuffer(); str.append("insert into ").append(table).append(" values ("); str.append("null, "); // trigger on ID str.append(Integer.toString(logonNo())).append(", "); str.append(Integer.toString(logonPass())).append(", "); str.append(Integer.toString(profile())).append(", "); str.append(quoteString(firstName())).append(", "); str.append(quoteString(lastName())).append(", "); str.append(quoteString(middleInitial())).append(", "); str.append(quoteString(SSN())).append(", "); str.append(Integer.toString(salaryGrade())).append(","); str.append(Double.toString(hourlyWage())).append(")"); try { Application.dbConnection().execute(str.toString()); Application.dbConnection().commit(); } catch (SQLException e) { logger.warn("Update failed " + str.toString(), e); } }
public void populate(ResultSet rset) { try { setMenuID(rset.getInt("menu_id")); setConfigNo(rset.getInt("config_no")); setMenuXLoc(rset.getInt("xpos")); setMenuYLoc(rset.getInt("ypos")); setMenuHeight(rset.getInt("height")); setMenuWidth(rset.getInt("width")); setPixWidth(rset.getInt("pix_width")); setPixHeight(rset.getInt("pix_height")); setName(rset.getString("name")); } catch (java.sql.SQLException e) { Application.dbConnection().setException(e); } }
public void populate(ResultSet rset) { try { setEmployeeID(rset.getInt("employee_id")); setLogonNo(rset.getInt("logon_no")); setLogonPass(rset.getInt("logon_pass")); setProfile(rset.getInt("profile")); setFirstName(rset.getString("fname")); setLastName(rset.getString("lname")); setMiddleInitial(rset.getString("mi")); setSSN(rset.getString("ssn")); setSalaryGrade(rset.getInt("sal_grade")); setHourlyWage((double) rset.getFloat("hourly_wage")); } catch (java.sql.SQLException e) { Application.dbConnection().setException(e); } }
public void logon() { Timestamp stamp = new Timestamp((new Date()).getTime()); SimpleDateFormat df = new SimpleDateFormat("yyyy-mm-dd hh:mm:ss"); try { Application.dbConnection() .execute( "INSERT into Employee_Timesheet (employee_id, logon_time, hourly_wage) VALUES (" + employeeID() + ",now(), " + hourlyWage() + ")"); } catch (SQLException e) { logger.fatal( "Could not insert logon time for employee:" + employeeID() + " who logged on at " + df.format(stamp), e); } }
public Vector parents() { String fetchSpec = PosConfig.getByID(configNo()); Vector v = Application.dbConnection().fetch(new PosConfig(), fetchSpec); return v; }
public void logoff() { Timestamp stamp = new Timestamp((new Date()).getTime()); SimpleDateFormat df = new SimpleDateFormat("yyyy-mm-dd hh:mm:ss"); try { ResultSet rs = Application.dbConnection() .executeWithResult( "SELECT max(employee_time_sheet_id) from Employee_TimeSheet where employee_id = " + employeeID()); if (rs.next()) { int timesheet_id = rs.getInt(1); Application.dbConnection() .execute( "UPDATE Employee_Timesheet SET logoff_time = now() WHERE employee_time_sheet_id = " + timesheet_id); ResultSet rs2 = Application.dbConnection() .executeWithResult( "SELECT logon_time, logoff_time, hourly_wage from Employee_Timesheet where employee_time_sheet_id = " + timesheet_id); rs2.next(); float hourlyWage = rs2.getFloat("hourly_wage"); // NOTE This is hacked to get the logoff time back from the DB. Some DB's apparently // transpose the time, so as long as it's consistent amountOwed will be OK Timestamp logon_time = rs2.getTimestamp("logon_time"); Timestamp logoff_time = rs2.getTimestamp("logoff_time"); double hoursWorked = (logoff_time.getTime() - logon_time.getTime()) / (1000.0d * 60.0d * 60.0d); double amountOwed = hourlyWage * hoursWorked; Application.dbConnection() .execute( "UPDATE Employee_Timesheet SET amount_owed = " + amountOwed + " WHERE employee_time_sheet_id = " + timesheet_id); } else { logger.error( "Could not find an appropriate logon entry for employee " + employeeID() + " who logged off at " + df.format(stamp)); } } catch (SQLException e) { logger.fatal( "Could not insert logoff time for employee:" + employeeID() + " who logged off at " + df.format(stamp), e); } }