/*
 * To change this template, choose Tools | Templates
 * and open the template in the editor.
 */
package com.bestray.transtracking.views;

import com.bestray.transtracking.controller.TaskController;
import com.bestray.transtracking.exceptions.TransTrackException;
import com.bestray.trastrack.domain.Code;
import com.bestray.trastrack.domain.Task;
import java.sql.ResultSet;
import java.util.Vector;
import javax.swing.JOptionPane;
import javax.swing.RowFilter;
import javax.swing.table.TableModel;
import javax.swing.table.TableRowSorter;
import org.apache.commons.lang.StringUtils;
import com.bestray.transtracking.util.CollectionUtil;
import java.awt.Color;
import java.awt.Component;
import java.awt.Font;
import javax.swing.ListSelectionModel;
import javax.swing.table.TableCellRenderer;


/**
 *
 * @author Bitu
 */
public class TaskMaster extends javax.swing.JPanel {

    /**
     * Creates new form TaskMaster
     */
    
    ResultSet rs = null;
    
    public TaskMaster() {
        populateData();
        initComponents();
    }

    /**
     * This method is called from within the constructor to initialize the form.
     * WARNING: Do NOT modify this code. The content of this method is always
     * regenerated by the Form Editor.
     */
    @SuppressWarnings("unchecked")
    // <editor-fold defaultstate="collapsed" desc="Generated Code">//GEN-BEGIN:initComponents
    private void initComponents() {

        jPanel1 = new javax.swing.JPanel();
        jLabel1 = new javax.swing.JLabel();
        jLabel2 = new javax.swing.JLabel();
        jLabel3 = new javax.swing.JLabel();
        jLabel4 = new javax.swing.JLabel();
        jLabel5 = new javax.swing.JLabel();
        jLabel6 = new javax.swing.JLabel();
        jLabel7 = new javax.swing.JLabel();
        jLabel8 = new javax.swing.JLabel();
        maintenance_textfield = new javax.swing.JTextField();
        Maintenance_type_combobox = new javax.swing.JComboBox();
        Job_basis_combobox = new javax.swing.JComboBox();
        Job_frequency_TextField = new javax.swing.JTextField();
        Reminder_TextField = new javax.swing.JTextField();
        Lock_combobox = new javax.swing.JComboBox();
        jLabel13 = new javax.swing.JLabel();
        jLabel14 = new javax.swing.JLabel();
        jLabel15 = new javax.swing.JLabel();
        distancelb = new javax.swing.JLabel();
        distancetb = new javax.swing.JTextField();
        km = new javax.swing.JLabel();
        jLabel16 = new javax.swing.JLabel();
        jScrollPane1 = new javax.swing.JScrollPane();
        Task_table = new javax.swing.JTable(){
            public boolean isCellEditable(int row, int column){
                return false;
            }
            public Component prepareRenderer(TableCellRenderer renderer, int rowIndex, int vColIndex) {
                Component c = super.prepareRenderer(renderer, rowIndex, vColIndex);
                if (rowIndex % 2 == 0 && !isCellSelected(rowIndex, vColIndex)) {
                    c.setForeground(Color.BLACK);
                    c.setBackground(new Color(200, 225, 250));
                }
                else if(rowIndex % 2 == 0 && isCellSelected(rowIndex, vColIndex)){
                    c.setForeground(Color.WHITE);
                    c.setBackground(Color.BLUE);
                }
                else if(rowIndex % 2 != 0 && isCellSelected(rowIndex, vColIndex)){
                    c.setForeground(Color.WHITE);
                    c.setBackground(Color.BLUE);
                }
                else {
                    c.setForeground(Color.BLACK);
                    c.setBackground(getBackground());
                }
                return c;
            }
        };
        jPanel2 = new javax.swing.JPanel();
        tsearchlb = new javax.swing.JLabel();
        tmsearchtb = new javax.swing.JTextField();
        tmsearchbt = new javax.swing.JButton();
        tmrefreshbt = new javax.swing.JButton();
        tmsavebt = new javax.swing.JButton();
        tmdeletebt = new javax.swing.JButton();
        tmeditbt = new javax.swing.JButton();
        jLabel9 = new javax.swing.JLabel();
        jLabel10 = new javax.swing.JLabel();
        jLabel11 = new javax.swing.JLabel();
        jLabel12 = new javax.swing.JLabel();

        setBackground(new java.awt.Color(200, 225, 250));
        setOpaque(false);
        setPreferredSize(new java.awt.Dimension(1051, 623));

        jPanel1.setBackground(new java.awt.Color(200, 225, 250));
        jPanel1.setBorder(javax.swing.BorderFactory.createEtchedBorder());
        jPanel1.setOpaque(false);

        jLabel1.setFont(new java.awt.Font("Microsoft Sans Serif", 1, 12)); // NOI18N
        jLabel1.setText("Maintenance Name :");

        jLabel2.setFont(new java.awt.Font("Microsoft Sans Serif", 1, 12)); // NOI18N
        jLabel2.setText("Type :");

        jLabel3.setFont(new java.awt.Font("Microsoft Sans Serif", 1, 12)); // NOI18N
        jLabel3.setText("Basis Of Job :");

        jLabel4.setFont(new java.awt.Font("Microsoft Sans Serif", 1, 12)); // NOI18N
        jLabel4.setText("Job Frequency :");

        jLabel5.setFont(new java.awt.Font("Microsoft Sans Serif", 1, 12)); // NOI18N
        jLabel5.setText("Remind Before :");

        jLabel6.setFont(new java.awt.Font("Microsoft Sans Serif", 1, 12)); // NOI18N
        jLabel6.setText("Lock :");

        jLabel7.setFont(new java.awt.Font("Microsoft Sans Serif", 1, 12)); // NOI18N
        jLabel7.setText("Days");

        jLabel8.setFont(new java.awt.Font("Microsoft Sans Serif", 1, 12)); // NOI18N
        jLabel8.setText("Days");

        maintenance_textfield.addKeyListener(new java.awt.event.KeyAdapter() {
            public void keyPressed(java.awt.event.KeyEvent evt) {
                maintenance_textfieldKeyPressed(evt);
            }
        });

        Maintenance_type_combobox.setModel(new javax.swing.DefaultComboBoxModel(codeList1));
        Maintenance_type_combobox.setSelectedIndex(-1);

        Job_basis_combobox.setModel(new javax.swing.DefaultComboBoxModel(codeList2));
        Job_basis_combobox.setSelectedIndex(-1);
        Job_basis_combobox.addItemListener(new java.awt.event.ItemListener() {
            public void itemStateChanged(java.awt.event.ItemEvent evt) {
                Job_basis_comboboxItemStateChanged(evt);
            }
        });
        Job_basis_combobox.addActionListener(new java.awt.event.ActionListener() {
            public void actionPerformed(java.awt.event.ActionEvent evt) {
                Job_basis_comboboxActionPerformed(evt);
            }
        });

        Lock_combobox.setModel(new javax.swing.DefaultComboBoxModel(new String[] { "NO", "YES" }));
        Lock_combobox.setSelectedIndex(-1);

        jLabel13.setFont(new java.awt.Font("Tahoma", 1, 12)); // NOI18N
        jLabel13.setForeground(new java.awt.Color(255, 0, 0));
        jLabel13.setText("*");

        jLabel14.setFont(new java.awt.Font("Tahoma", 1, 12)); // NOI18N
        jLabel14.setForeground(new java.awt.Color(255, 0, 0));
        jLabel14.setText("*");

        jLabel15.setFont(new java.awt.Font("Tahoma", 1, 12)); // NOI18N
        jLabel15.setForeground(new java.awt.Color(255, 0, 0));
        jLabel15.setText("*");

        distancelb.setFont(new java.awt.Font("Microsoft Sans Serif", 1, 12)); // NOI18N
        distancelb.setText("Distance :");
        distancelb.setVisible(false);

        distancetb.setVisible(false);

        km.setFont(new java.awt.Font("Microsoft Sans Serif", 1, 12)); // NOI18N
        km.setText("K.M.");
        km.setVisible(false);

        jLabel16.setFont(new java.awt.Font("Tahoma", 1, 12)); // NOI18N
        jLabel16.setForeground(new java.awt.Color(255, 0, 0));
        jLabel16.setText("*");
        jLabel16.setVisible(false);

        javax.swing.GroupLayout jPanel1Layout = new javax.swing.GroupLayout(jPanel1);
        jPanel1.setLayout(jPanel1Layout);
        jPanel1Layout.setHorizontalGroup(
            jPanel1Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
            .addGroup(jPanel1Layout.createSequentialGroup()
                .addContainerGap()
                .addGroup(jPanel1Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
                    .addComponent(jLabel13)
                    .addComponent(jLabel14)
                    .addComponent(jLabel15))
                .addGap(1, 1, 1)
                .addGroup(jPanel1Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
                    .addComponent(jLabel1)
                    .addComponent(jLabel2)
                    .addComponent(jLabel3)
                    .addComponent(jLabel4)
                    .addComponent(jLabel5)
                    .addComponent(jLabel6))
                .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)
                .addGroup(jPanel1Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
                    .addComponent(maintenance_textfield, javax.swing.GroupLayout.PREFERRED_SIZE, 303, javax.swing.GroupLayout.PREFERRED_SIZE)
                    .addComponent(Lock_combobox, javax.swing.GroupLayout.PREFERRED_SIZE, 78, javax.swing.GroupLayout.PREFERRED_SIZE)
                    .addComponent(Maintenance_type_combobox, javax.swing.GroupLayout.PREFERRED_SIZE, 170, javax.swing.GroupLayout.PREFERRED_SIZE)
                    .addGroup(jPanel1Layout.createSequentialGroup()
                        .addComponent(Job_basis_combobox, javax.swing.GroupLayout.PREFERRED_SIZE, 167, javax.swing.GroupLayout.PREFERRED_SIZE)
                        .addGap(58, 58, 58)
                        .addComponent(jLabel16)
                        .addGap(0, 0, 0)
                        .addComponent(distancelb)
                        .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)
                        .addComponent(distancetb, javax.swing.GroupLayout.PREFERRED_SIZE, 100, javax.swing.GroupLayout.PREFERRED_SIZE)
                        .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)
                        .addComponent(km))
                    .addGroup(jPanel1Layout.createSequentialGroup()
                        .addGroup(jPanel1Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.TRAILING, false)
                            .addComponent(Reminder_TextField, javax.swing.GroupLayout.Alignment.LEADING, javax.swing.GroupLayout.DEFAULT_SIZE, 154, Short.MAX_VALUE)
                            .addComponent(Job_frequency_TextField, javax.swing.GroupLayout.Alignment.LEADING))
                        .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)
                        .addGroup(jPanel1Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
                            .addComponent(jLabel7)
                            .addComponent(jLabel8))))
                .addContainerGap(434, Short.MAX_VALUE))
        );

        jPanel1Layout.linkSize(javax.swing.SwingConstants.HORIZONTAL, new java.awt.Component[] {Job_basis_combobox, Maintenance_type_combobox});

        jPanel1Layout.setVerticalGroup(
            jPanel1Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
            .addGroup(jPanel1Layout.createSequentialGroup()
                .addContainerGap()
                .addGroup(jPanel1Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)
                    .addComponent(jLabel1)
                    .addComponent(maintenance_textfield, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)
                    .addComponent(jLabel13))
                .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.UNRELATED, javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE)
                .addGroup(jPanel1Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)
                    .addComponent(jLabel2)
                    .addComponent(Maintenance_type_combobox, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)
                    .addComponent(jLabel14))
                .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.UNRELATED, javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE)
                .addGroup(jPanel1Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)
                    .addComponent(Job_basis_combobox, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)
                    .addComponent(jLabel3)
                    .addComponent(jLabel15)
                    .addComponent(distancelb)
                    .addComponent(distancetb, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)
                    .addComponent(km)
                    .addComponent(jLabel16))
                .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.UNRELATED, javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE)
                .addGroup(jPanel1Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)
                    .addComponent(jLabel4)
                    .addComponent(Job_frequency_TextField, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)
                    .addComponent(jLabel8))
                .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.UNRELATED, javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE)
                .addGroup(jPanel1Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)
                    .addComponent(jLabel5)
                    .addComponent(Reminder_TextField, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)
                    .addComponent(jLabel7))
                .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.UNRELATED, javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE)
                .addGroup(jPanel1Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)
                    .addComponent(jLabel6)
                    .addComponent(Lock_combobox, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE))
                .addGap(13, 13, 13))
        );

        jScrollPane1.setBackground(new java.awt.Color(200, 225, 250));
        jScrollPane1.setPreferredSize(new java.awt.Dimension(452, 415));

        Task_table.getTableHeader().setFont(new Font("SansSerif", Font.BOLD, 12));
        Task_table.setModel(new javax.swing.table.DefaultTableModel(
            taskData,header)
    );
    Task_table.getColumnModel().getColumn(0).setPreferredWidth(77);
    Task_table.getColumnModel().getColumn(0).setMaxWidth(77);
    Task_table.setRowHeight(20);
    Task_table.setShowHorizontalLines(false);
    Task_table.setShowVerticalLines(false);
    Task_table.setSelectionMode(ListSelectionModel.SINGLE_SELECTION);
    Task_table.addMouseListener(new java.awt.event.MouseAdapter() {
        public void mouseClicked(java.awt.event.MouseEvent evt) {
            Task_tableMouseClicked(evt);
        }
    });
    jScrollPane1.setViewportView(Task_table);

    jPanel2.setBackground(new java.awt.Color(200, 225, 250));
    jPanel2.setOpaque(false);

    tsearchlb.setFont(new java.awt.Font("Microsoft Sans Serif", 1, 12)); // NOI18N
    tsearchlb.setText("Search :");

    tmsearchtb.addKeyListener(new java.awt.event.KeyAdapter() {
        public void keyTyped(java.awt.event.KeyEvent evt) {
            tmsearchtbKeyTyped(evt);
        }
    });

    tmsearchbt.setFont(new java.awt.Font("Microsoft Sans Serif", 1, 12)); // NOI18N
    tmsearchbt.setIcon(new javax.swing.ImageIcon(getClass().getResource("/images/search.png"))); // NOI18N
    tmsearchbt.setText("Search");
    tmsearchbt.setMaximumSize(new java.awt.Dimension(85, 25));
    tmsearchbt.setMinimumSize(new java.awt.Dimension(85, 25));
    tmsearchbt.setOpaque(false);
    tmsearchbt.setPreferredSize(new java.awt.Dimension(85, 25));
    tmsearchbt.addActionListener(new java.awt.event.ActionListener() {
        public void actionPerformed(java.awt.event.ActionEvent evt) {
            tmsearchbtActionPerformed(evt);
        }
    });

    tmrefreshbt.setFont(new java.awt.Font("Microsoft Sans Serif", 1, 12)); // NOI18N
    tmrefreshbt.setIcon(new javax.swing.ImageIcon(getClass().getResource("/images/refresh.png"))); // NOI18N
    tmrefreshbt.setText("Reset");
    tmrefreshbt.setOpaque(false);
    tmrefreshbt.setPreferredSize(new java.awt.Dimension(85, 25));
    tmrefreshbt.addActionListener(new java.awt.event.ActionListener() {
        public void actionPerformed(java.awt.event.ActionEvent evt) {
            tmrefreshbtActionPerformed(evt);
        }
    });

    tmsavebt.setFont(new java.awt.Font("Microsoft Sans Serif", 1, 12)); // NOI18N
    tmsavebt.setIcon(new javax.swing.ImageIcon(getClass().getResource("/images/save 2.png"))); // NOI18N
    tmsavebt.setText("Save");
    tmsavebt.setMaximumSize(new java.awt.Dimension(85, 25));
    tmsavebt.setMinimumSize(new java.awt.Dimension(85, 25));
    tmsavebt.setOpaque(false);
    tmsavebt.setPreferredSize(new java.awt.Dimension(85, 25));
    tmsavebt.addActionListener(new java.awt.event.ActionListener() {
        public void actionPerformed(java.awt.event.ActionEvent evt) {
            tmsavebtActionPerformed(evt);
        }
    });

    tmdeletebt.setFont(new java.awt.Font("Microsoft Sans Serif", 1, 12)); // NOI18N
    tmdeletebt.setIcon(new javax.swing.ImageIcon(getClass().getResource("/images/delete.png"))); // NOI18N
    tmdeletebt.setText("Delete");
    tmdeletebt.setMaximumSize(new java.awt.Dimension(85, 25));
    tmdeletebt.setMinimumSize(new java.awt.Dimension(85, 25));
    tmdeletebt.setOpaque(false);
    tmdeletebt.setPreferredSize(new java.awt.Dimension(85, 25));
    tmdeletebt.addActionListener(new java.awt.event.ActionListener() {
        public void actionPerformed(java.awt.event.ActionEvent evt) {
            tmdeletebtActionPerformed(evt);
        }
    });

    tmeditbt.setFont(new java.awt.Font("Microsoft Sans Serif", 1, 12)); // NOI18N
    tmeditbt.setIcon(new javax.swing.ImageIcon(getClass().getResource("/images/edit.png"))); // NOI18N
    tmeditbt.setText("Edit");
    tmeditbt.setMaximumSize(new java.awt.Dimension(85, 25));
    tmeditbt.setMinimumSize(new java.awt.Dimension(85, 25));
    tmeditbt.setOpaque(false);
    tmeditbt.setPreferredSize(new java.awt.Dimension(85, 25));
    tmeditbt.addActionListener(new java.awt.event.ActionListener() {
        public void actionPerformed(java.awt.event.ActionEvent evt) {
            tmeditbtActionPerformed(evt);
        }
    });

    javax.swing.GroupLayout jPanel2Layout = new javax.swing.GroupLayout(jPanel2);
    jPanel2.setLayout(jPanel2Layout);
    jPanel2Layout.setHorizontalGroup(
        jPanel2Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
        .addGroup(jPanel2Layout.createSequentialGroup()
            .addComponent(tsearchlb)
            .addGap(2, 2, 2)
            .addComponent(tmsearchtb, javax.swing.GroupLayout.PREFERRED_SIZE, 178, javax.swing.GroupLayout.PREFERRED_SIZE)
            .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)
            .addComponent(tmsearchbt, javax.swing.GroupLayout.PREFERRED_SIZE, 105, javax.swing.GroupLayout.PREFERRED_SIZE)
            .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED, 237, Short.MAX_VALUE)
            .addComponent(tmrefreshbt, javax.swing.GroupLayout.PREFERRED_SIZE, 105, javax.swing.GroupLayout.PREFERRED_SIZE)
            .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.UNRELATED)
            .addComponent(tmeditbt, javax.swing.GroupLayout.PREFERRED_SIZE, 105, javax.swing.GroupLayout.PREFERRED_SIZE)
            .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.UNRELATED)
            .addComponent(tmsavebt, javax.swing.GroupLayout.PREFERRED_SIZE, 105, javax.swing.GroupLayout.PREFERRED_SIZE)
            .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.UNRELATED)
            .addComponent(tmdeletebt, javax.swing.GroupLayout.PREFERRED_SIZE, 105, javax.swing.GroupLayout.PREFERRED_SIZE))
    );

    jPanel2Layout.linkSize(javax.swing.SwingConstants.HORIZONTAL, new java.awt.Component[] {tmdeletebt, tmeditbt, tmrefreshbt, tmsavebt, tmsearchbt});

    jPanel2Layout.setVerticalGroup(
        jPanel2Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
        .addGroup(javax.swing.GroupLayout.Alignment.TRAILING, jPanel2Layout.createSequentialGroup()
            .addGap(0, 0, 0)
            .addGroup(jPanel2Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)
                .addComponent(tmsearchtb, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)
                .addComponent(tmrefreshbt, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)
                .addComponent(tmsavebt, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)
                .addComponent(tmsearchbt, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)
                .addComponent(tsearchlb)
                .addComponent(tmdeletebt, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)
                .addComponent(tmeditbt, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE))
            .addGap(0, 0, 0))
    );

    jPanel2Layout.linkSize(javax.swing.SwingConstants.VERTICAL, new java.awt.Component[] {tmdeletebt, tmeditbt, tmrefreshbt, tmsavebt, tmsearchbt});

    jLabel9.setIcon(new javax.swing.ImageIcon(getClass().getResource("/images/task.png"))); // NOI18N

    jLabel10.setFont(new java.awt.Font("Microsoft Sans Serif", 1, 14)); // NOI18N
    jLabel10.setText("Task / Maintenance Information");

    jLabel11.setFont(new java.awt.Font("Microsoft Sans Serif", 1, 14)); // NOI18N
    jLabel11.setText("Task Master Database");

    jLabel12.setIcon(new javax.swing.ImageIcon(getClass().getResource("/images/database.png"))); // NOI18N

    javax.swing.GroupLayout layout = new javax.swing.GroupLayout(this);
    this.setLayout(layout);
    layout.setHorizontalGroup(
        layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
        .addGroup(layout.createSequentialGroup()
            .addContainerGap()
            .addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
                .addComponent(jScrollPane1, javax.swing.GroupLayout.Alignment.TRAILING, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE)
                .addComponent(jPanel1, javax.swing.GroupLayout.Alignment.TRAILING, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE)
                .addComponent(jPanel2, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE)
                .addGroup(layout.createSequentialGroup()
                    .addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
                        .addGroup(layout.createSequentialGroup()
                            .addComponent(jLabel9)
                            .addGap(2, 2, 2)
                            .addComponent(jLabel10))
                        .addGroup(layout.createSequentialGroup()
                            .addComponent(jLabel12)
                            .addGap(2, 2, 2)
                            .addComponent(jLabel11)))
                    .addGap(0, 0, Short.MAX_VALUE)))
            .addContainerGap())
    );
    layout.setVerticalGroup(
        layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
        .addGroup(layout.createSequentialGroup()
            .addContainerGap()
            .addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.TRAILING)
                .addComponent(jLabel9)
                .addComponent(jLabel10))
            .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)
            .addComponent(jPanel1, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)
            .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)
            .addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.TRAILING)
                .addComponent(jLabel12)
                .addComponent(jLabel11))
            .addGap(2, 2, 2)
            .addComponent(jScrollPane1, javax.swing.GroupLayout.PREFERRED_SIZE, 187, javax.swing.GroupLayout.PREFERRED_SIZE)
            .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)
            .addComponent(jPanel2, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)
            .addGap(117, 117, 117))
    );
    }// </editor-fold>//GEN-END:initComponents

    private void tmrefreshbtActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_tmrefreshbtActionPerformed
         clearAllFields();
         originalColor(); 
         Task_table.clearSelection();
         update_table();
         //tmsavebt.setEnabled(false);
        //tmeditbt.setEnabled(false);
        //tmdeletebt.setEnabled(false);
    }//GEN-LAST:event_tmrefreshbtActionPerformed

    private void tmeditbtActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_tmeditbtActionPerformed
        try{
        int row = Task_table.getSelectedRow();
        Object o = Task_table.getValueAt(row, 0);
        displayRowValues(Long.valueOf(o.toString()));
        }catch(Exception e){
            JOptionPane.showMessageDialog(null,"Record not selected for Edit");
        }
        //tmsavebt.setEnabled(true);
    }//GEN-LAST:event_tmeditbtActionPerformed

    private void tmsavebtActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_tmsavebtActionPerformed
        try{
        if (validateTask()) {
            
            task.setMaintenance_Name(maintenance_textfield.getText().toUpperCase());
            Code code = (Code)Maintenance_type_combobox.getSelectedItem();
            task.setJobTypeId(code.getId());
            Code code1 = (Code)Job_basis_combobox.getSelectedItem();
            task.setJobBasisId(code1.getId());
            if (StringUtils.isNotBlank(Job_frequency_TextField.getText())) {
                task.setJob_Frequency(Long.parseLong(Job_frequency_TextField.getText()));
            }else{
            task.setJob_Frequency(null);
        }
            if (StringUtils.isNotBlank(Reminder_TextField.getText())) {
                task.setRemind_Before(Long.parseLong(Reminder_TextField.getText()));
            }else{
            task.setRemind_Before(null);
        } 
             if(Lock_combobox.getSelectedItem() != null){
        task.setLock(Lock_combobox.getSelectedItem().toString().toUpperCase());
         }else{
           task.setLock("NO");
        }
             
            if(Job_basis_combobox.getSelectedItem().toString().equalsIgnoreCase("Distance")&&distancetb.getText()!=null){
                task.setDistance(Double.parseDouble(distancetb.getText()));
            }else{
                task.setDistance(0.0);
            }
        
            controller = new TaskController();
            controller.AddNewTask(task);
        
        
            JOptionPane.showMessageDialog(null,"Maintenace Information has been Saved");
            clearAllFields();
            originalColor();
            task = new Task();
            update_table();
            //tmeditbt.setEnabled(false);
            //tmdeletebt.setEnabled(false);
            //tmsavebt.setEnabled(false);
        
        }
        }
        catch(Exception e){
            JOptionPane.showMessageDialog(null, "Task Information not Saved!!!");
        }
                
    }//GEN-LAST:event_tmsavebtActionPerformed

    private void tmdeletebtActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_tmdeletebtActionPerformed
     
        int row = Task_table.getSelectedRow();
          if(row >= 0){
        Object o = Task_table.getValueAt(row, 0);
        
        try{
            if(JOptionPane.showConfirmDialog(null, "Do you want to delete the selected Record.","", JOptionPane.OK_CANCEL_OPTION)==0){
        controller.deleteTask(Long.valueOf(o.toString()));
        JOptionPane.showMessageDialog(null, "Maintenance Vehicle Information Deleted");
         update_table();
         clearAllFields();
         originalColor();
            }else{
                 update_table();
                   clearAllFields();
                   originalColor();
            }
        }catch(TransTrackException e){
            
         JOptionPane.showMessageDialog(null, e.getMessage());   
        }
        
          }else{
            JOptionPane.showMessageDialog(null,"Record not selected for Delete");
        }
       
        
         //tmeditbt.setEnabled(false);
        //tmdeletebt.setEnabled(false);
        //tmsavebt.setEnabled(false);
    }//GEN-LAST:event_tmdeletebtActionPerformed

    private void tmsearchbtActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_tmsearchbtActionPerformed

            String expr = tmsearchtb.getText().toUpperCase();
            update_table();
            sorter = new TableRowSorter<TableModel>();
            sorter = new TableRowSorter<TableModel>(Task_table.getModel());
            Task_table.setRowSorter(sorter);
            sorter.setRowFilter(RowFilter.regexFilter(expr));
            sorter.setSortKeys(null);

    }//GEN-LAST:event_tmsearchbtActionPerformed

    private void maintenance_textfieldKeyPressed(java.awt.event.KeyEvent evt) {//GEN-FIRST:event_maintenance_textfieldKeyPressed
        //tmsavebt.setEnabled(true);
        //tmrefreshbt.setEnabled(true);
    }//GEN-LAST:event_maintenance_textfieldKeyPressed

    private void Task_tableMouseClicked(java.awt.event.MouseEvent evt) {//GEN-FIRST:event_Task_tableMouseClicked
         //tmeditbt.setEnabled(true);
        //tmdeletebt.setEnabled(true);
        //tmrefreshbt.setEnabled(true);
    }//GEN-LAST:event_Task_tableMouseClicked

    private void Job_basis_comboboxActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_Job_basis_comboboxActionPerformed
        // TODO add your handling code here:
    }//GEN-LAST:event_Job_basis_comboboxActionPerformed

    private void tmsearchtbKeyTyped(java.awt.event.KeyEvent evt) {//GEN-FIRST:event_tmsearchtbKeyTyped
        String expr = tmsearchtb.getText().toUpperCase();
            update_table();
            sorter = new TableRowSorter<TableModel>();
            sorter = new TableRowSorter<TableModel>(Task_table.getModel());
            Task_table.setRowSorter(sorter);
            sorter.setRowFilter(RowFilter.regexFilter(expr));
            sorter.setSortKeys(null);
    }//GEN-LAST:event_tmsearchtbKeyTyped

    private void Job_basis_comboboxItemStateChanged(java.awt.event.ItemEvent evt) {//GEN-FIRST:event_Job_basis_comboboxItemStateChanged
        if(Job_basis_combobox.getSelectedItem()!=null&&Job_basis_combobox.getSelectedItem().toString().equalsIgnoreCase("Distance")){
            jLabel16.setVisible(true);
            distancelb.setVisible(true);
            distancetb.setVisible(true);
            km.setVisible(true);
        }
        else{
            jLabel16.setVisible(false);
            distancelb.setVisible(false);
            distancetb.setVisible(false);
            distancetb.setText(null);
            km.setVisible(false);
        }
    }//GEN-LAST:event_Job_basis_comboboxItemStateChanged

    // Variables declaration - do not modify//GEN-BEGIN:variables
    private javax.swing.JComboBox Job_basis_combobox;
    private javax.swing.JTextField Job_frequency_TextField;
    private javax.swing.JComboBox Lock_combobox;
    private javax.swing.JComboBox Maintenance_type_combobox;
    private javax.swing.JTextField Reminder_TextField;
    private javax.swing.JTable Task_table;
    private javax.swing.JLabel distancelb;
    private javax.swing.JTextField distancetb;
    private javax.swing.JLabel jLabel1;
    private javax.swing.JLabel jLabel10;
    private javax.swing.JLabel jLabel11;
    private javax.swing.JLabel jLabel12;
    private javax.swing.JLabel jLabel13;
    private javax.swing.JLabel jLabel14;
    private javax.swing.JLabel jLabel15;
    private javax.swing.JLabel jLabel16;
    private javax.swing.JLabel jLabel2;
    private javax.swing.JLabel jLabel3;
    private javax.swing.JLabel jLabel4;
    private javax.swing.JLabel jLabel5;
    private javax.swing.JLabel jLabel6;
    private javax.swing.JLabel jLabel7;
    private javax.swing.JLabel jLabel8;
    private javax.swing.JLabel jLabel9;
    private javax.swing.JPanel jPanel1;
    private javax.swing.JPanel jPanel2;
    private javax.swing.JScrollPane jScrollPane1;
    private javax.swing.JLabel km;
    private javax.swing.JTextField maintenance_textfield;
    private javax.swing.JButton tmdeletebt;
    private javax.swing.JButton tmeditbt;
    private javax.swing.JButton tmrefreshbt;
    private javax.swing.JButton tmsavebt;
    private javax.swing.JButton tmsearchbt;
    private javax.swing.JTextField tmsearchtb;
    private javax.swing.JLabel tsearchlb;
    // End of variables declaration//GEN-END:variables
    private TaskController controller;
    TableRowSorter<TableModel> sorter;
    private Vector<Code> codeList1 = new Vector<Code>();
    private Vector<Code> codeList2 = new Vector<Code>();
    private Vector<String> header;
    private Task task;
    private Vector<Vector<String>> taskData = new Vector<Vector<String>>();
    
    private void populateData() {
        controller = new TaskController();
        codeList1 = controller.getCodeList1();
        codeList2 = controller.getCodeList2();
        
        header = new Vector<String>();
        header.add("ID");
        header.add("Maintenance Name");
        header.add("Maintenance Type");
        header.add("Job Basis");
        header.add("Distance");
        header.add("Job Frequency");
        header.add("Reminder");
        header.add("Lock Status");
        try{
        taskData = controller.getAllTaskList();
        }catch(TransTrackException e){
            JOptionPane.showMessageDialog(null,e.getMessage());
        }
        task = new Task();        
    }
    
    private void clearAllFields(){
         task = new Task();   
         maintenance_textfield.setText("");
         Maintenance_type_combobox.setSelectedIndex(-1);
         Job_basis_combobox.setSelectedIndex(-1);
         Job_frequency_TextField.setText("");
         Reminder_TextField.setText("");
         Lock_combobox.setSelectedIndex(-1);
         tmsearchtb.setText("");
         distancelb.setVisible(false);
         distancetb.setVisible(false);
         distancetb.setText(null);
         km.setVisible(false);
    }

    private void changeColor(){
        maintenance_textfield.setBackground(new java.awt.Color(255, 255, 230));
        Maintenance_type_combobox.setBackground(new java.awt.Color(255, 255, 230));
        Job_basis_combobox.setBackground(new java.awt.Color(255, 255, 230));
        Job_frequency_TextField.setBackground(new java.awt.Color(255, 255, 230));
        Reminder_TextField.setBackground(new java.awt.Color(255, 255, 230));
        Lock_combobox.setBackground(new java.awt.Color(255, 255, 230));
        
    }
    
    private void originalColor(){
        
        maintenance_textfield.setBackground(new java.awt.Color(255,255,255));
        Maintenance_type_combobox.setBackground(new java.awt.Color(255,255,255));
        Job_basis_combobox.setBackground(new java.awt.Color(255,255,255));
        Job_frequency_TextField.setBackground(new java.awt.Color(255,255,255));
        Reminder_TextField.setBackground(new java.awt.Color(255,255,255));
        Lock_combobox.setBackground(new java.awt.Color(255,255,255));
    }
    
    private void displayRowValues(Long vehicleId)    {
        
         task = controller.getTaskRegistrationDetails(vehicleId);
        
        String s = "";
        
        if(task != null){
            
            changeColor();
            maintenance_textfield.setText(task.getMaintenance_Name());
            if(task.getJob_Frequency() != null && task.getJob_Frequency()>0){
            Job_frequency_TextField.setText(String.valueOf(task.getJob_Frequency()));
            }
            if(task.getRemind_Before() != null && task.getRemind_Before()>0){
            Reminder_TextField.setText(String.valueOf(task.getRemind_Before()));
            }
            Lock_combobox.setSelectedItem(task.getLock());
            if(task.getJobBasisId() != null){
                Job_basis_combobox.setSelectedIndex(CollectionUtil.getCodeIndex(codeList2, task.getJobBasisId()));
            }
            if(task.getJobTypeId() != null){
                Maintenance_type_combobox.setSelectedIndex(CollectionUtil.getCodeIndex(codeList1, task.getJobTypeId()));
            }
            if(task.getDistance()!=null&&task.getDistance()>0){
                distancetb.setText(String.valueOf(task.getDistance()));
            }
           
            
            }
        
        }    
    
    private void update_table() {
      
        populateData();
        Task_table.setModel(new javax.swing.table.DefaultTableModel(taskData,header));
        Task_table.getColumnModel().getColumn(0).setPreferredWidth(77);
        Task_table.getColumnModel().getColumn(0).setMaxWidth(77);
        sorter = new TableRowSorter<TableModel>();
	sorter = new TableRowSorter<TableModel>(Task_table.getModel());
	Task_table.setRowSorter(sorter);
        
    }
    
    private boolean validateTask() {
        
        boolean valid = true;
        
        if (this.maintenance_textfield.getText().trim().length() == 0) {
            JOptionPane.showMessageDialog(null, "Maintenance Name must not be Empty", "Error", JOptionPane.ERROR_MESSAGE);
            maintenance_textfield.requestFocus();
            valid = false;
        }
        else if (Maintenance_type_combobox.getSelectedIndex() == -1) {

            JOptionPane.showMessageDialog(null, "Type should be Selected", "Error", JOptionPane.ERROR_MESSAGE);
            Maintenance_type_combobox.requestFocus();
            valid = false;
       }
        else if (Job_basis_combobox.getSelectedIndex() == -1) {

            JOptionPane.showMessageDialog(null, "Basis of job should be Selected", "Error", JOptionPane.ERROR_MESSAGE);
            Job_basis_combobox.requestFocus();
            valid = false;
       }else if(Job_basis_combobox.getSelectedItem().toString().equalsIgnoreCase("Distance")&&(this.distancetb.getText().trim().length() == 0)){
            JOptionPane.showMessageDialog(null, "Distance should not be empty", "Error", JOptionPane.ERROR_MESSAGE);
            distancetb.requestFocus();
            valid = false;
        }else if(Job_basis_combobox.getSelectedItem().toString().equalsIgnoreCase("Distance")&&!(this.distancetb.getText().matches("^\\d*[\\.]?\\d*$"))){
            JOptionPane.showMessageDialog(null, "Distance should be Numerical", "Error", JOptionPane.ERROR_MESSAGE);
            distancetb.requestFocus();
            valid = false;
        }
        else if (!(this.Job_frequency_TextField.getText().matches("^[0-9]*$"))) {

            JOptionPane.showMessageDialog(null, "Job frequency should be Numerical", "Error", JOptionPane.ERROR_MESSAGE);
            Job_frequency_TextField.requestFocus();
            valid = false;
         }
        else if (!(this.Reminder_TextField.getText().matches("^[0-9]*$"))) {

            JOptionPane.showMessageDialog(null, "Remind Before should be Numerical", "Error", JOptionPane.ERROR_MESSAGE);
            Reminder_TextField.requestFocus();
            valid = false;
         }
    
    
        return valid;
    }

}