// ---------------------------------------------------------------//
public int editProject(Project project, Connection conn) throws SQLException {
PreparedStatement prepStmt = null;
int rtrn = -1;
java.util.Date date = new java.util.Date();
Timestamp currentdate = new Timestamp(date.getTime());
conn = select();
String sql =
"UPDATE PROJECTS SET PROJ_NAME=?,MODIFIED_AT=?,MODIFIED_BY=?,PROJ_ACTIVE=?,PROJ_BUDGET=?,PROJ_DEADLINE=?,PROJ_DESCRIPTION=?,PROJ_FROM=?,PROJ_TYPE=?,PROJ_TO=?,CUST_ID=?,ROWVERSION=ROWVERSION+1"
+ "WHERE PROJ_ID=?";
prepStmt = conn.prepareStatement(sql);
prepStmt.setString(1, project.getName());
prepStmt.setTimestamp(2, currentdate);
prepStmt.setString(3, project.getModified_by());
if (project.isActive()) prepStmt.setString(4, "Y");
else prepStmt.setString(4, "N");
if (project.getBudget() != -1) prepStmt.setFloat(5, project.getBudget());
else prepStmt.setInt(5, 0);
if (project.getNextDeadline() == null) prepStmt.setDate(6, null);
else prepStmt.setDate(6, new java.sql.Date(project.getNextDeadline().getTime()));
prepStmt.setString(7, project.getDescription());
prepStmt.setDate(8, new java.sql.Date(project.getStartDate().getTime()));
prepStmt.setString(9, project.getProjectType());
if (project.getEndDate() == null) prepStmt.setDate(10, null);
else prepStmt.setDate(10, new java.sql.Date(project.getEndDate().getTime()));
prepStmt.setInt(11, project.getCustomerID());
prepStmt.setInt(12, project.getProjectID());
prepStmt.executeUpdate();
rtrn = project.getProjectID();
return rtrn;
}
// ---------------------------------------------------------------//
public int insertProject(Project project, Connection conn) throws SQLException {
PreparedStatement prepStmt = null;
int rtrn = -1;
java.util.Date date = new java.util.Date();
Timestamp currentdate = new Timestamp(date.getTime());
conn = select();
String sql =
"INSERT INTO PROJECTS(PROJ_ID,PROJ_NAME,INSERTED_AT,INSERTED_BY,MODIFIED_AT,MODIFIED_BY,PROJ_ACTIVE,PROJ_BUDGET,PROJ_DEADLINE,PROJ_DESCRIPTION,PROJ_FROM,PROJ_TYPE,PROJ_TO,CUST_ID,ROWVERSION)"
+ " VALUES(PROJ_SEQ.NEXTVAL,?,?,?,?,?,?,?,?,?,?,?,?,?,?)";
String cols[] = {"PROJ_ID"};
prepStmt = conn.prepareStatement(sql, cols);
prepStmt.setString(1, project.getName());
prepStmt.setTimestamp(2, currentdate);
prepStmt.setString(3, project.getInserted_by());
prepStmt.setDate(4, null);
prepStmt.setString(5, null);
if (project.isActive()) prepStmt.setString(6, "Y");
else prepStmt.setString(6, "N");
if (project.getBudget() != -1) prepStmt.setFloat(7, project.getBudget());
else prepStmt.setInt(7, 0);
if (project.getNextDeadline() == null) prepStmt.setDate(8, null);
else prepStmt.setDate(8, new java.sql.Date(project.getNextDeadline().getTime()));
prepStmt.setString(9, project.getDescription());
prepStmt.setDate(10, new java.sql.Date(project.getStartDate().getTime()));
prepStmt.setString(11, project.getProjectType());
if (project.getEndDate() == null) prepStmt.setDate(12, null);
else prepStmt.setDate(12, new java.sql.Date(project.getEndDate().getTime()));
prepStmt.setInt(13, project.getCustomerID());
prepStmt.setInt(14, project.getRowversion());
prepStmt.executeUpdate();
ResultSet rs = prepStmt.getGeneratedKeys();
if (rs.next()) {
rtrn = rs.getInt(1);
}
rs.close();
return rtrn;
}