private void limparTabela() {
DefaultTableModel modelo = (DefaultTableModel) this.tbCargos.getModel();
int numLinhas = tbCargos.getRowCount();
for (int i = 0; i < numLinhas; i++) {
modelo.removeRow(0);
}
}
public void removeRow() {
try {
if (tblUnitList.getSelectedRow() < 0) {
Message.showWarning("Please select in the table");
return;
}
// if (((Number) model.getValueAt(0, 2)).intValue() > 0) {
// deleteUnitList.add((Integer) model.getValueAt(tblUnitList.getSelectedRow(),
// 4));
// }
if (userTask >= GlobalMode.EDIT
&& (int) model.getValueAt(tblUnitList.getSelectedRow(), 4) > 0) {
if (JOptionPane.showConfirmDialog(
this,
"This unit is already in use. This will be permanently delete to the database. Do you still want to continue?",
"WARNING",
JOptionPane.YES_NO_OPTION)
== JOptionPane.YES_OPTION) {
totalLeaseArea -=
((Number) model.getValueAt(tblUnitList.getSelectedRow(), 1)).doubleValue();
rDB.deleteRentalDetailID(
((Number) model.getValueAt(tblUnitList.getSelectedRow(), 4)).intValue(),
totalLeaseArea);
model.removeRow(tblUnitList.getSelectedRow());
}
} else {
totalLeaseArea -=
((Number) model.getValueAt(tblUnitList.getSelectedRow(), 1)).doubleValue();
model.removeRow(tblUnitList.getSelectedRow());
}
} catch (Exception e) {
Message.showError(e.getMessage());
}
}
private void jButton5ActionPerformed(
java.awt.event.ActionEvent evt) { // GEN-FIRST:event_jButton5ActionPerformed
int rows2Delete = jTable1.getSelectedRowCount();
int[] selectedRows = jTable1.getSelectedRows();
if (rows2Delete < 1) {
java.awt.Toolkit.getDefaultToolkit().beep();
javax.swing.JOptionPane.showMessageDialog(this, "There are no selected rows to delete!");
} else {
if (rows2Delete > 1) {
for (int i = 0; i < selectedRows.length; i++) {
javax.swing.table.DefaultTableModel defTableModel =
(javax.swing.table.DefaultTableModel) jTable1.getModel();
defTableModel.removeRow(selectedRows[i]);
}
} else {
javax.swing.table.DefaultTableModel defTableModel =
(javax.swing.table.DefaultTableModel) jTable1.getModel();
defTableModel.removeRow(jTable1.getSelectedRow());
}
} // Add your handling code here:
} // GEN-LAST:event_jButton5ActionPerformed
@Override
public void actionPerformed(ActionEvent e) {
ID = (Integer) hashRoomType.get(boxRoomTypeID.getSelectedItem().toString());
IDSTATUS = (Integer) hashRoomStatus.get(boxRoomStatusID.getSelectedItem().toString());
if (e.getSource() == buttonInsert) {
try {
Rooms rooms = new Rooms(txtRoomNumber.getText(), txtDescription.getText(), ID, IDSTATUS);
RoomsController.roomsController.save(rooms);
int c = model.getRowCount();
for (int i = c - 1; i >= 0; i--) {
model.removeRow(i);
jRoom.revalidate();
}
all();
JOptionPane.showMessageDialog(this, "ok");
} catch (Exception ex) {
ex.printStackTrace();
}
}
if (e.getSource() == buttonUpdate) {
try {
Rooms rooms = new Rooms(txtRoomNumber.getText(), txtDescription.getText(), ID, IDSTATUS);
rooms.setRoomID(IDROOM);
RoomsController.roomsController.update(rooms);
int c = model.getRowCount();
for (int i = c - 1; i >= 0; i--) {
model.removeRow(i);
jRoom.revalidate();
}
all();
JOptionPane.showMessageDialog(this, "Update to succeed !");
} catch (Exception ex) {
ex.printStackTrace();
}
}
if (e.getSource() == buttonDelete) {
try {
List<CheckIn> temp = CheckInController.checkInController.all();
for (int i = 0; i < temp.size(); i++) {
if (IDROOM == temp.get(i).getRoomID()) {
this.error = 0;
} else {
this.error = 0;
RoomsController.roomsController.delete(IDROOM);
int c = model.getRowCount();
for (int ii = c - 1; ii >= 0; ii--) {
model.removeRow(ii);
jRoom.revalidate();
}
all();
}
}
JOptionPane.showMessageDialog(this, "Delete to succeed !");
} catch (Exception ex) {
JOptionPane.showMessageDialog(this, "can't delete row bcause check still !");
}
}
if (e.getSource() == buttonRefresh) {}
}
@SuppressWarnings("unchecked")
@Override
public int loop() {
synchronized (lock) {
try {
if (!ui.isVisible()) handler.stopMod(getName());
World world = minecraft.getWorld();
JTable list = ui.getList();
DefaultTableModel model = (DefaultTableModel) list.getModel();
TableRowSorter<TableModel> sorter = (TableRowSorter<TableModel>) list.getRowSorter();
if (world != null) {
Player currentPlayer = minecraft.getPlayer();
int playerX = (int) java.lang.Math.round(currentPlayer.getX());
int playerY = (int) java.lang.Math.round(currentPlayer.getY());
int playerZ = (int) java.lang.Math.round(currentPlayer.getZ());
ArrayList<Block> blocks = new ArrayList<Block>();
for (int x = playerX - radius; x < playerX + radius; x++)
for (int y = playerY - radius; y < playerY + radius; y++)
for (int z = playerZ - radius; z < playerZ + radius; z++)
if (world.getBlockIDAt(x, y, z) == blockID) blocks.add(new Block(x, y, z));
label:
for (int row = 0; row < model.getRowCount(); row++) {
int x = (Integer) model.getValueAt(row, 1);
int y = (Integer) model.getValueAt(row, 2);
int z = (Integer) model.getValueAt(row, 3);
for (Block block : blocks) {
if (x == block.getX() && y == block.getY() && z == block.getZ()) {
model.setValueAt(getDistanceTo(x, y, z, currentPlayer), row, 0);
continue label;
}
}
model.removeRow(row);
}
label:
for (Block block : blocks) {
for (int row = 0; row < model.getRowCount(); row++) {
int x = (Integer) model.getValueAt(row, 1);
int y = (Integer) model.getValueAt(row, 2);
int z = (Integer) model.getValueAt(row, 3);
if (x == block.getX() && y == block.getY() && z == block.getZ()) continue label;
}
model.addRow(
new Object[] {
getDistanceTo(block.getX(), block.getY(), block.getZ(), minecraft.getPlayer()),
block.getX(),
block.getY(),
block.getZ()
});
}
sorter.sort();
list.repaint();
} else {
for (int i = model.getRowCount() - 1; i >= 0; i--) model.removeRow(i);
}
} catch (Exception exception) {
}
}
return 500;
}
private void btnEliminarMouseClicked(
java.awt.event.MouseEvent evt) { // GEN-FIRST:event_btnEliminarMouseClicked
DefaultTableModel modelo = (DefaultTableModel) tabla.getModel();
int indice = tabla.getSelectedRow();
if (indice != -1) {
modelo.removeRow(indice);
} else {
modelo.removeRow(modelo.getRowCount() - 1);
}
} // GEN-LAST:event_btnEliminarMouseClicked
private void ClearButtonActionPerformed(
java.awt.event.ActionEvent evt) { // GEN-FIRST:event_ClearButtonActionPerformed
DefaultTableModel dtm = (DefaultTableModel) IPTable.getModel();
while (dtm.getRowCount() > 0) {
dtm.removeRow(0);
}
dtm = (DefaultTableModel) PacketInfoTable.getModel();
while (dtm.getRowCount() > 0) dtm.removeRow(0);
PacketDataTextArea.setText(null);
// TODO add your handling code here:
} // GEN-LAST:event_ClearButtonActionPerformed
private void btnGuardarActionPerformed(
java.awt.event.ActionEvent evt) { // GEN-FIRST:event_btnGuardarActionPerformed
// TODO add your handling code here:
if (!txtnombre.getText().isEmpty()) {
mthunidadmedidas obj = new mthunidadmedidas();
obj.setNombre(txtnombre.getText());
if (obj.save_unidad()) {
// Este metodo es para volver el modelo de la tabla a como era al inicio, entonces la clase
// toma el modelo y vuelve a cargar los datos ya actualizados
try {
DefaultTableModel modelo = (DefaultTableModel) tablaunidadmedidas.getModel();
int filas = tablaunidadmedidas.getRowCount();
for (int i = 0; filas > i; i++) {
modelo.removeRow(0);
}
mthunidadmedidas para_actualizar = new mthunidadmedidas();
para_actualizar.tabla_unidad();
limpiar();
} catch (Exception e) {
JOptionPane.showMessageDialog(null, "Error al limpiar la tabla.");
}
JOptionPane.showMessageDialog(this, "Datos guardados");
} else {
JOptionPane.showMessageDialog(this, "Error al guardar datos");
}
} else {
JOptionPane.showMessageDialog(this, "Por favor llene todos los campos");
}
} // GEN-LAST:event_btnGuardarActionPerformed
private void jButtonMoveUpActionPerformed(
java.awt.event.ActionEvent evt) { // GEN-FIRST:event_jButtonMoveUpActionPerformed
if (jTable1.getSelectedRow() > 0) {
DefaultTableModel dtm = (DefaultTableModel) jTable1.getModel();
int[] indices = jTable1.getSelectedRows();
for (int i = indices.length - 1; i >= 0; --i) {
if (indices[i] == 0) continue;
Object val = jTable1.getValueAt(indices[i], 0);
dtm.removeRow(indices[i]);
dtm.insertRow(indices[i] - 1, new Object[5]);
setRowValues((MeterInterval) val, indices[i] - 1);
indices[i]--;
}
DefaultListSelectionModel dlsm = (DefaultListSelectionModel) jTable1.getSelectionModel();
dlsm.setValueIsAdjusting(true);
dlsm.clearSelection();
for (int i = 0; i < indices.length; ++i) {
dlsm.addSelectionInterval(indices[i], indices[i]);
}
dlsm.setValueIsAdjusting(false);
}
} // GEN-LAST:event_jButtonMoveUpActionPerformed
private void pcodeKeyReleased(java.awt.event.KeyEvent evt) { // GEN-FIRST:event_pcodeKeyReleased
// TODO add your handling code here:
String code = pcode.getText();
int tblsize = tblProduct_model.getRowCount();
for (int i = 0; i < tblsize; i++) {
tblProduct_model.removeRow(0);
}
pdesc.setText("");
if (!code.trim().equals("")) {
OptionGroup_Controller group = new OptionGroup_Controller();
String groupName = group.seekGroup(code);
if (groupName != null && !groupName.equals("")) {
pdesc.setText(groupName);
setDataToGrid(group.getOptionDetail(code));
} else {
pdesc.setText("**** GroupFile Error ****");
}
}
if (evt.getKeyCode() == java.awt.event.KeyEvent.VK_ENTER) {
if (!pdesc.getText().equals("**** GroupFile Error ****")
&& !pdesc.getText().trim().equals("")) {
option.requestFocus();
}
}
} // GEN-LAST:event_pcodeKeyReleased
public void displayQuizOptions() {
// displays the the quizzes the pupil can do based on their skill level
int quizNum = 0;
int total = 0;
String quizSkill = "";
try {
DatabaseConnect.init();
Connection conn = DatabaseConnect.getConnection();
Statement stmt = conn.createStatement();
String query = "SELECT * FROM QUIZ where QUIZ_LEVEL ='" + skillLevel + "'";
ResultSet result = stmt.executeQuery(query);
DefaultTableModel model = (DefaultTableModel) tblQuiz.getModel();
while (model.getRowCount() > 0) {
model.removeRow(0);
}
if (result != null) {
while (result.next()) {
quizNum = result.getInt("QUIZ_NUMBER");
total = result.getInt("TOTAL_POINTS");
quizSkill = result.getString("QUIZ_LEVEL");
int number = NumQuestions(quizNum);
model.addRow(new Object[] {quizNum, quizSkill, total, number});
}
}
stmt.close();
conn.close();
result.close();
} // end try
catch (Exception ex) {
System.err.print("SQLException: ");
System.err.println(ex.getMessage());
}
} // END method
public void actionPerformed(ActionEvent e) {
if (e.getActionCommand().equals("Add Column")) {
PopMessage.popMsg("Invalid new column for this window");
// defaultModel.addColumn("AddColumn");
}
if (e.getActionCommand().equals("Add Row")) defaultModel.addRow(new Vector());
if (e.getActionCommand().equals("Remove Column")) {
PopMessage.popMsg("Invalid new column for this window");
// int columncount = defaultModel.getColumnCount() - 1;
// if (columncount >= 0) {
// TableColumnModel columnModel = table.getColumnModel();
// TableColumn tableColumn = columnModel.getColumn(columncount);
// columnModel.removeColumn(tableColumn);
// defaultModel.setColumnCount(columncount);
// }
}
if (e.getActionCommand().equals("Remove Row")) {
int rowcount = defaultModel.getRowCount() - 1;
if (rowcount >= 0) {
defaultModel.removeRow(rowcount);
defaultModel.setRowCount(rowcount);
}
}
table.revalidate();
}
private void jButton3ActionPerformed(
java.awt.event.ActionEvent evt) { // GEN-FIRST:event_jButton3ActionPerformed
// TODO add your handling code here:
try {
Class.forName("com.mysql.jdbc.Driver");
// MENYIAPKAN KONEKSI DAN PARAMETERNYA
String urldb = "jdbc:mysql://localhost:3306/hotel";
String user = "******";
String password = "";
Connection koneksi = DriverManager.getConnection(urldb, user, password);
// Query SQL dan Eksekuusinya
Statement st = koneksi.createStatement();
String strSQL = "delete from master_costumer where id_ktp='" + txtid.getText() + "'";
st.executeUpdate(strSQL);
tblModel.removeRow(row);
txtid.setText("");
txtnama.setText("");
txtalamat.setText("");
st.close();
koneksi.close();
} catch (ClassNotFoundException cnfe) {
System.out.println("KESALAHAN SAAT" + "ME-LOAD DRIVER JDBC \n" + cnfe.getMessage());
} catch (SQLException sqle) {
System.out.println(
"KESALAHAN SAAT KONEKSI ATAU " + "KESALAHAN QUERY SQL \n" + sqle.getMessage());
}
} // GEN-LAST:event_jButton3ActionPerformed
private void btnEliminarTodoMouseClicked(
java.awt.event.MouseEvent evt) { // GEN-FIRST:event_btnEliminarTodoMouseClicked
DefaultTableModel modelo = (DefaultTableModel) tabla.getModel();
for (int i = modelo.getRowCount() - 1; i >= 0; i--) {
modelo.removeRow(i);
}
} // GEN-LAST:event_btnEliminarTodoMouseClicked
public void loadTableData() {
while (tableModel1.getRowCount() > 0) {
tableModel1.removeRow(0);
}
vatList = dbValue.getVatDetail();
yearList = dbValue.getFinancialYearDetail();
/*
* Collections.sort(yearList, new Comparator<FinancialYearModal>() {
*
* @Override public int compare(FinancialYearModal year1,
* FinancialYearModal year2) {
*
* if(year1.getStartYear()==year2.getStartYear()) return 0; else return
* year1.getStartYear()-year2.getStartYear();
*
* } });
*/
for (int i = 0; i < vatList.size(); i++) {
int startYear = 0, endYear = 0;
vatModel = vatList.get(i);
for (FinancialYearModal yearModel : yearList) {
if (yearModel.getYearId() == vatModel.getYearId()) {
startYear = yearModel.getStartYear();
endYear = yearModel.getEndYear();
}
}
tableModel1.addRow(new Object[] {i + 1, vatModel.getVatPercent(), startYear, endYear});
}
}
/** Method to update the friend's list. */
public void updateFriends() {
// Clear rows
int count = friendListData.getRowCount();
boolean online = false;
for (int i = 0; i < count; i++) friendListData.removeRow(0);
// Add rows
for (Client c : Constants.getFriends()) {
if (c.isOnline()) {
switch (c.getStatus()) {
case 0:
if (!c.isPlayedSound()) {
online = true;
c.setPlayedSound(true);
}
friendListData.addRow(new Object[] {Constants.onlineIcon, c.getUsername()});
break;
case 1:
friendListData.addRow(new Object[] {Constants.awayIcon, c.getUsername()});
break;
case 2:
friendListData.addRow(new Object[] {Constants.dndIcon, c.getUsername()});
break;
}
} else {
friendListData.addRow(new Object[] {Constants.offlineIcon, c.getUsername()});
}
}
repaint();
if (Constants.isPlaySounds() && online) Constants.getAudioPlayer().play(AudioPlayer.ONLINE);
}
public void llenarTabla() {
// limpiar tabla
try {
DefaultTableModel model = (DefaultTableModel) tabla.getModel();
int filas = tabla.getRowCount();
for (int i = 0; filas > i; i++) {
model.removeRow(0);
}
} catch (Exception e) {
System.out.println("Error al limpiar tabla:" + e);
}
// fin de limpiar tabla
String[] registros = new String[4];
conexion nc = new conexion();
try {
Connection n = nc.conectar();
Statement st = n.createStatement();
ResultSet rs = st.executeQuery("SELECT codigo,item,price,stock FROM inventario");
while (rs.next()) {
registros[0] = rs.getString("codigo");
registros[1] = rs.getString("item");
registros[2] = rs.getString("price");
registros[3] = rs.getString("stock");
((DefaultTableModel) tabla.getModel()).addRow(registros);
}
} catch (Exception e) {
System.out.println(e);
}
nc.cerrarConexion();
}
private static void updateRegisteredKeypairsTable() {
DefaultTableModel defaultTableModel = (DefaultTableModel) keypairsTable.getModel();
while (defaultTableModel.getRowCount() != 0) {
defaultTableModel.removeRow(0);
}
keypairs.clear();
ArrayList<KeypairPOJO> registeredKeypairs = null;
try {
registeredKeypairs = KeypairDAO.getKeypairs();
} catch (Exception e) {
e.printStackTrace();
}
if (registeredKeypairs != null) {
for (KeypairPOJO keypair : registeredKeypairs) {
defaultTableModel.addRow(
new String[] {
keypair.getKeypairDescription(), keypair.getGenerationTimestampAsString()
});
keypairs.add(keypair);
}
}
keypairsTable.setModel(defaultTableModel);
}
/**
* Выводит в таблицу результат поиска
*
* @param findGenre поиск по имени или все: ByName, ByAllGenres
* @param str название жанра
*/
private void showTable(FindGenre findGenre, String str) {
if (strings == null) {
strings = new ArrayList<>();
} else {
strings.clear();
}
DefaultTableModel model = (DefaultTableModel) jTable1.getModel();
for (int i = jTable1.getRowCount(); i > 0; i--) {
model.removeRow(i - 1);
}
try {
switch (findGenre) {
case ByName:
strings = ctrl.findGenreByName(str);
break;
case ByAllGenres:
strings = ctrl.findAllGenre();
break;
}
} catch (IOException e) {
Logger.getLogger(GenreFrame.class.getName()).log(Level.SEVERE, null, e);
errorMessage("Ошибка при открытии файла");
} catch (ClassNotFoundException ex) {
Logger.getLogger(GenreFrame.class.getName()).log(Level.SEVERE, null, ex);
errorMessage("ClassNotFoundException!");
}
for (String string : strings) {
model.addRow(new Object[] {string});
}
}
private void updateTable(List list, final DefaultTableModel dftm) {
int num = dftm.getRowCount();
for (int i = 0; i < num; i++) dftm.removeRow(0);
Iterator iterator = list.iterator();
TbKhinfo khInfo;
while (iterator.hasNext()) {
List info = (List) iterator.next();
Item item = new Item();
item.setId((String) info.get(0));
item.setName((String) info.get(1));
khInfo = Dao.getKhInfo(item);
Vector rowData = new Vector();
rowData.add(khInfo.getId().trim());
rowData.add(khInfo.getKhname().trim());
rowData.add(khInfo.getAddress().trim());
rowData.add(khInfo.getJian().trim());
rowData.add(khInfo.getBianma().trim());
rowData.add(khInfo.getTel().trim());
rowData.add(khInfo.getFax().trim());
rowData.add(khInfo.getLian().trim());
rowData.add(khInfo.getLtel().trim());
rowData.add(khInfo.getMail().trim());
rowData.add(khInfo.getXinhang().trim());
rowData.add(khInfo.getHao().trim());
dftm.addRow(rowData);
}
}
/**
* Listens for a topic being removed from the space for either a MainMenuController or a
* ChatroomController.
*/
@Override
public void notify(RemoteEvent remoteEvent) throws UnknownEventException, RemoteException {
try {
// Get the event that triggered the notification
AvailabilityEvent availEvent = (AvailabilityEvent) remoteEvent;
JMSTopicDeleted topicDeleted = (JMSTopicDeleted) availEvent.getEntry();
if (isChatroomController) {
// If the listener is for a ChatroomController, inform the given
// chatroom that the chatroom's topic has been deleted
chatroomController.handleTopicDeleted();
} else {
// If the listener is for a MainMenuController, remove the given
// topic from the MainMenuController's topic list.
DefaultTableModel topicTableModel = mainMenuController.getTopicTableModel();
// Loop through all of the topics in the MainMenuController's
// topic list and remove the one that was deleted
for (int i = 0; i < topicTableModel.getRowCount(); i++) {
UUID topicIdInTable = (UUID) topicTableModel.getValueAt(i, 3);
JMSTopic topicRemoved = topicDeleted.getTopic();
UUID topicDeletedId = topicRemoved.getId();
if (topicIdInTable.equals(topicDeletedId)) {
topicTableModel.removeRow(i);
break;
}
}
}
} catch (Exception e) {
System.err.println("Failed to remove topic from list or send notifications to users.");
e.printStackTrace();
}
}
private void buscar() {
CategoriaBL objCategoriaBL = new CategoriaBL();
DefaultTableModel temp = (DefaultTableModel) this.tbCategoria.getModel();
for (int i = temp.getRowCount() - 1; i >= 0; --i) {
temp.removeRow(i);
}
String temp1 = "";
for (int i = 0; i < this.txtNombre.getText().length(); ++i) {
if (this.txtNombre.getText().charAt(i) != '\'') {
temp1 += this.txtNombre.getText().charAt(i);
}
}
String temp2 = "";
for (int i = 0; i < this.txtDescripcion.getText().length(); ++i) {
if (this.txtDescripcion.getText().charAt(i) != '\'') {
temp2 += this.txtDescripcion.getText().charAt(i);
}
}
ArrayList<CategoriaBE> alstResultado = objCategoriaBL.buscarCategoria(temp2, temp1);
for (int i = 0; i < alstResultado.size(); ++i) {
Object[] nuevo = {
alstResultado.get(i).getIdCategoria(),
alstResultado.get(i).getNombre(),
alstResultado.get(i).getDescripcion()
};
temp.addRow(nuevo);
}
this.txtDescripcion.setText("");
this.txtNombre.setText("");
}
private void jButton4ActionPerformed(
java.awt.event.ActionEvent evt) { // GEN-FIRST:event_jButton4ActionPerformed
int respuesta =
JOptionPane.showConfirmDialog(
this,
"¿Desea suprimir el contacto?\n" + salidaSeleccionada.getCod_salida(),
"Confirmación",
JOptionPane.YES_NO_OPTION,
JOptionPane.WARNING_MESSAGE);
// Comprobar si se ha pulsado Aceptar o Cancelar
if (respuesta == JOptionPane.YES_OPTION) {
salidaSeleccionada.getCod_salida();
gestionSalidas.delete(salidaSeleccionada.getCod_salida());
modelTablaSalidas.removeRow(jTable1.getSelectedRow());
} else {
// Si no se ha seleccionado un contacto de la lista hay que notificarlo
JOptionPane.showMessageDialog(
this,
"Debe seleccionar un contacto previamente",
"Atención",
JOptionPane.WARNING_MESSAGE);
}
observaciones.setText("");
jLabelFecha.setText("");
jLabelHora.setText("");
jLabelNombreVol.setText("");
jLabelNombreCor.setText("");
} // GEN-LAST:event_jButton4ActionPerformed
private void removeSelectedRows() {
DefaultTableModel model = (DefaultTableModel) jtable.getModel();
int[] rows = jtable.getSelectedRows();
for (int i = 0; i < rows.length; i++) {
model.removeRow(rows[i] - i);
}
}
/**
* Updates the content of the table.
*
* <p>This method will be called by an observable element.
*
* <ul>
* <li>If the observable is a {@link MailSaver} object, a new row will be added to the table,
* and the {@link UIModel} will be updated;
* <li>If the observable is a {@link ClearAllButton} object, all the cells of the table will be
* removed, and the {@link UIModel} will be updated.
* </ul>
*
* @param o the observable element which will notify this class.
* @param arg optional parameters (an {@code EmailModel} object, for the case of a {@code
* MailSaver} observable) containing all the information about the email.
*/
@Override
public void update(Observable o, Object arg) {
if (o instanceof MailSaver) {
EmailModel email = (EmailModel) arg;
String subject;
try {
subject = MimeUtility.decodeText(email.getSubject());
} catch (UnsupportedEncodingException e) {
LOGGER.error("", e);
subject = email.getSubject();
}
model.addRow(
new Object[] {
dateFormat.format(email.getReceivedDate()), email.getFrom(), email.getTo(), subject
});
UIModel.INSTANCE.getListMailsMap().put(nbElements++, email.getFilePath());
} else if (o instanceof ClearAllButton) {
// Delete information from the map
UIModel.INSTANCE.getListMailsMap().clear();
// Remove elements from the list
try {
while (nbElements > 0) {
model.removeRow(--nbElements);
}
} catch (ArrayIndexOutOfBoundsException e) {
LOGGER.error("", e);
}
}
}
private void clearForm() {
int tblsize = tblProduct_model.getRowCount();
for (int i = 0; i < tblsize; i++) {
tblProduct_model.removeRow(0);
}
option.setText("");
}
/** Method edit employee on database and edit on employee table */
private void editEmp() {
parent.doBlur();
// Get Id employee selected
String empID = view.getTblEmp().getValueAt(view.getTblEmp().getSelectedRow(), 0).toString();
// Get employee from database
Employee emp = AccessEmp.getInstance().getEmpInfo(new Integer(empID));
// Create instance of Employee edit dialog and display it
editEmp = new EditEmployeeController(new EditEmployeeDialog(parent.getView()), emp);
editEmp.getView().setVisible(true);
// Update data on database
if (editEmp.getEmp() != null) {
if (AccessEmp.getInstance().editEmp(editEmp.getEmp())) {
JOptionPane.showMessageDialog(
view,
Messages.getString("EmployeeController.14"), // $NON-NLS-1$
Messages.getString("EmployeeController.15"),
JOptionPane.INFORMATION_MESSAGE);
// Remove old data on table model
empModel.removeRow(view.getTblEmp().getSelectedRow());
// Add new row
empModel.addRow(emp.toVector());
} else {
JOptionPane.showMessageDialog(
view,
Messages.getString("EmployeeController.16") // $NON-NLS-1$
+ Messages.getString("EmployeeController.17"),
Messages.getString("EmployeeController.18"), // $NON-NLS-1$
JOptionPane.ERROR_MESSAGE);
}
}
parent.doBlur();
// Set selection to employee book
view.getTblEmp().changeSelection(view.getTblEmp().getRowCount() - 1, 0, false, false);
}
private void removeButtonActionPerformed(
java.awt.event.ActionEvent evt) { // GEN-FIRST:event_removeButtonActionPerformed
if (outputTable.getSelectedRow() != -1) {
DefaultTableModel model = (DefaultTableModel) this.outputTable.getModel();
model.removeRow(outputTable.getSelectedRow());
}
} // GEN-LAST:event_removeButtonActionPerformed
/** Delete an employee */
private void deleteEmp() {
parent.doBlur();
int sure =
JOptionPane.showConfirmDialog(
parent.getView(),
Messages.getString("EmployeeController.7"),
Messages.getString("EmployeeController.8"), // $NON-NLS-1$
JOptionPane.YES_NO_OPTION,
JOptionPane.INFORMATION_MESSAGE);
if (sure == JOptionPane.OK_OPTION) {
// Get Id employee selected
String empID = view.getTblEmp().getValueAt(view.getTblEmp().getSelectedRow(), 0).toString();
if (!AccessEmp.getInstance().deleteEmp(Integer.parseInt(empID))) {
JOptionPane.showMessageDialog(
parent.getView(),
Messages.getString("EmployeeController.9") // $NON-NLS-1$
+ Messages.getString("EmployeeController.10"), // $NON-NLS-1$
Messages.getString("EmployeeController.11"),
JOptionPane.ERROR_MESSAGE);
} else {
JOptionPane.showMessageDialog(
parent.getView(),
Messages.getString("EmployeeController.12"),
Messages.getString("EmployeeController.13"), // $NON-NLS-1$
JOptionPane.INFORMATION_MESSAGE);
empModel.removeRow(view.getTblEmp().getSelectedRow());
}
}
tableFocus();
parent.doBlur();
}
private void listaFacturasMouseClicked(
java.awt.event.MouseEvent evt) { // GEN-FIRST:event_listaFacturasMouseClicked
try {
if (rsVenta == null || listaFacturas.getSelectedIndex() == -1) {
return;
}
rsVenta.absolute(listaFacturas.getSelectedIndex() + 1);
lbNumeroVenta.setText(rsVenta.getString("id_venta"));
lbNombre.setText(
rsVenta.getString("nombre_cliente") + " " + rsVenta.getString("apellido_cliente"));
lbCedulaRif.setText(rsVenta.getString("cedula_rif"));
lbfecha.setText(rsVenta.getDate("fecha_venta").toString());
lbDireccion.setText(rsVenta.getString("domicilio_cliente"));
String sql =
"SELECT venta.id_venta, detalle_venta.cantidad,detalle_venta.importe, "
+ "producto.nombre_producto,producto.descripcion_producto, producto.id_producto, producto.precio_producto "
+ "FROM public.venta "
+ "INNER JOIN public.detalle_venta ON venta.id_venta=detalle_venta.id_venta "
+ "INNER JOIN public.producto ON detalle_venta.id_producto=producto.id_producto "
+ "WHERE venta.id_venta ="
+ rsVenta.getInt("id_venta")
+ "ORDER BY id_venta ";
Statement st =
Conexion.getConnection()
.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE, ResultSet.CONCUR_READ_ONLY);
ResultSet rs = st.executeQuery(sql);
int cant = modeloTabla.getRowCount();
for (int i = 0; i < cant; i++) {
modeloTabla.removeRow(0);
}
float subTotal = 0f;
while (rs.next()) {
subTotal += rs.getFloat("precio_producto") * rs.getInt("cantidad");
modeloTabla.addRow(
new Object[] {
rs.getInt("id_producto"),
rs.getString("nombre_producto"),
rs.getString("descripcion_producto"),
rs.getInt("cantidad"),
rs.getFloat("precio_producto"),
subTotal
});
}
tfSubTotal.setText(subTotal + "");
tfIva.setText((subTotal * 0.12) + "");
tfTotal.setText(rsVenta.getFloat("total_venta") + "");
} catch (SQLException ex) {
Logger.getLogger(cliente.class.getName()).log(Level.SEVERE, null, ex);
}
} // GEN-LAST:event_listaFacturasMouseClicked
