public boolean addEHVSS(EHVSS ehvss, ErrorBean errorBean) {
ArrayList<EHVSS> ehvssList = new ArrayList<EHVSS>();
boolean added;
try {
Connection connection = DatabaseConnection.getConnection("mms_new");
ehvssList = getByCode(ehvss.getCode());
if (ehvssList == null || ehvssList.size() == 0) {
PreparedStatement ps =
connection.prepareStatement(
"insert into EHVSS(code, name, location, region, circle, division) VALUES(?,?,?,?,?,?)");
ps.setString(1, ehvss.getCode());
ps.setString(2, ehvss.getName());
ps.setString(3, "DUMMY");
ps.setString(4, ehvss.getRegion());
ps.setString(5, "DUMMY");
ps.setString(6, "DUMMY");
ps.executeUpdate();
added = true;
ps.close();
} else {
errorBean.setErrorMessage("EHVSS Code Already Exist. Please provide Different EHVSS Code");
added = false;
}
} catch (SQLException e) {
added = false;
System.out.println("Exception in [updateUser]" + e);
}
return added;
}
public EHVSS addEHVSS(EHVSS ehvss) {
try {
Connection connection = DatabaseConnection.getConnection("mms_new");
PreparedStatement ps =
connection.prepareStatement(
"insert into EHVSS(code, name, location, region, circle, division) VALUES(?,?,?,?,?,?)");
ps.setString(1, ehvss.getCode());
ps.setString(2, ehvss.getName());
ps.setString(3, "DUMMY");
ps.setString(4, ehvss.getRegion());
ps.setString(5, "DUMMY");
ps.setString(6, "DUMMY");
ps.executeUpdate();
ResultSet resultSet = ps.executeQuery("select last_insert_id() as 'id'");
resultSet.next();
int id = resultSet.getInt("id");
ehvss.setId(String.valueOf(id));
resultSet.close();
ps.close();
} catch (SQLException e) {
System.out.println("Exception in [addEHVSS(EHVSS)]" + e);
}
return ehvss;
}
public ArrayList<String> getAllEhvssNamesWithId() {
ArrayList<EHVSS> ehvssRecords = getAll();
ArrayList<String> ehvssNames = new ArrayList<String>();
for (EHVSS ehvss : ehvssRecords) {
ehvssNames.add(ehvss.getName() + "(ID:" + ehvss.getId() + ")");
}
return ehvssNames;
}
public ArrayList<String> getEhvssNamesByCircle(String circle) {
ArrayList<EHVSS> ehvssRecords = getByCircle(circle);
ArrayList<String> ehvssNames = new ArrayList<String>();
for (EHVSS ehvss : ehvssRecords) {
ehvssNames.add(ehvss.getName());
}
return ehvssNames;
}
public ArrayList<String> getEhvssNamesByRegion(String region) {
ArrayList<EHVSS> ehvssRecords = getByRegion(region);
ArrayList<String> ehvssNames = new ArrayList<String>();
for (EHVSS ehvss : ehvssRecords) {
ehvssNames.add(ehvss.getName());
}
return ehvssNames;
}
public EHVSS updateEHVSS(EHVSS ehvss) {
try {
Connection connection = DatabaseConnection.getConnection("mms_new");
PreparedStatement ps =
connection.prepareStatement(
"update EHVSS set code=?,name=?,location=?,region=?,circle=?,division=? where id=?");
ps.setString(1, ehvss.getCode());
ps.setString(2, ehvss.getName());
ps.setString(3, "DUMMY");
ps.setString(4, ehvss.getRegion());
ps.setString(5, "DUMMY");
ps.setString(6, "DUMMY");
ps.setInt(7, Integer.parseInt(ehvss.getId()));
ps.executeUpdate();
ps.close();
} catch (SQLException e) {
System.out.println("Exception in [updateEHVSS(EHVSS)]" + e);
}
return ehvss;
}