import java.sql.*;
import javax.swing.*;
import net.proteanit.sql.DbUtils;
import java.awt.event.*;
import java.awt.*;
import java.io.ByteArrayOutputStream;
import java.io.File;
import java.io.FileInputStream;
import java.io.FileOutputStream;
import java.text.MessageFormat;
import java.text.SimpleDateFormat;
import java.util.Calendar;
import java.util.GregorianCalendar;
import java.util.logging.Level;
import java.util.logging.Logger;

public class FoodsJFrame extends javax.swing.JFrame {

Connection conn=null;
ResultSet rs = null;
PreparedStatement pst=null;
public FoodsJFrame() {
    initComponents();
    conn=JavaConnector.ConnectorDb();
    Update_Table();
    Fill_Combo();
}

public void Close()
{

    this.setVisible(false);
    this.dispose();
}

private void Fill_Combo()
{
    try
    {
        String sql="Select * from Product_food";
        pst=conn.prepareStatement(sql);
        rs=pst.executeQuery();
        while(rs.next()){
        String Name=rs.getString("Name");
        cmb_select.addItem(Name);
        }
    }
    catch(Exception e)
    {
        JOptionPane.showMessageDialog(null, e);
    }
    finally
    {
        try
        {
            rs.close();
            pst.close();

        }
        catch(Exception e)
        {

        }
    }
}

private void Update_Table()
{
    try
    {
        String sql="Select * from Product_food";
        pst=conn.prepareStatement(sql);
        rs=pst.executeQuery();
        tbl_foods.setModel(DbUtils.resultSetToTableModel(rs));
    }
    catch(Exception e)
    {
        JOptionPane.showMessageDialog(null, e);
    }
    finally
    {
        try
        {
            rs.close();
            pst.close();

        }
        catch(Exception e)
        {

        }
    }
}

private void txt_searchKeyReleased(java.awt.event.KeyEvent evt) {
    try
    {
        String sql = "Select * from Product_food where ID=?";
        pst=conn.prepareStatement(sql);
        pst.setString(1, txt_search.getText());
        rs=pst.executeQuery();
        if(rs.next())
        {
            String add1 = rs.getString("ID");
            txt_proid.setText(add1);
            String add2 = rs.getString("Name");
            txt_name.setText(add2);
            String add3 = rs.getString("Category");
            txt_category.setText(add3);
            Double add4 = rs.getDouble("Price");
            txt_price.setText(Double.toString(add4));
            Date add5 = rs.getDate("Date");
            txt_adddate.setDate(add5);
            byte[] add6 = rs.getBytes("Image");
            format = new ImageIcon(add6);
            lbl_img.setIcon(format);

        }
    }
    catch(Exception e)
    {
        JOptionPane.showMessageDialog(null, e);
    }

    try
    {
        String sql = "Select * from Product_food where Name=?";
        pst=conn.prepareStatement(sql);
        pst.setString(1, txt_search.getText());
        rs=pst.executeQuery();
        if(rs.next())
        {
            String add1 = rs.getString("ID");
            txt_proid.setText(add1);
            String add2 = rs.getString("Name");
            txt_name.setText(add2);
            String add3 = rs.getString("Category");
            txt_category.setText(add3);
            Double add4 = rs.getDouble("Price");
            txt_price.setText(Double.toString(add4));
            Date add5 = rs.getDate("Date");
            txt_adddate.setDate(add5);
            byte[] add6 = rs.getBytes("Image");
            format = new ImageIcon(add6);
            lbl_img.setIcon(format);

        }
    }
    catch(Exception e)
    {
        JOptionPane.showMessageDialog(null, e);
    }
}

private void cmb_selectPopupMenuWillBecomeInvisible(javax.swing.event.PopupMenuEvent evt)     {

    String tmp = (String)cmb_select.getSelectedItem();
    String sql = "Select * from Product_food where Name=?";

    try
    {

        pst=conn.prepareStatement(sql);
        pst.setString(1, tmp);
        rs=pst.executeQuery();
        if(rs.next())
        {
            String add1 = rs.getString("ID");
            txt_proid.setText(add1);
            String add2 = rs.getString("Name");
            txt_name.setText(add2);
            String add3 = rs.getString("Category");
            txt_category.setText(add3);
            Double add4 = rs.getDouble("Price");
            txt_price.setText(Double.toString(add4));
            Date add5 = rs.getDate("Date");
            txt_adddate.setDate(add5);
            byte[] add6 = rs.getBytes("Image");
            format = new ImageIcon(add6);
            lbl_img.setIcon(format);

        }
    }
    catch(Exception e)
    {
        JOptionPane.showMessageDialog(null, e);
    }
}


private void btn_clearActionPerformed(java.awt.event.ActionEvent evt) {

    txt_proid.setText(" ");
    txt_name.setText(" ");
    txt_category.setText(" ");
    txt_price.setText(" ");
    txt_adddate.setDate(null);
    lbl_img.setIcon(null);

}

private void btn_updateActionPerformed(java.awt.event.ActionEvent evt) {
    try
    {
        String value1 = txt_proid.getText();
        String value2 = txt_name.getText();
        String value3 = txt_category.getText();
        String value4 = txt_price.getText();
        String value5 = txt_adddate.getDateFormatString();
        byte[] value6 = lbl_img.getText().getBytes();

        String sql = "Update Product_food set ID='"+value1+"',Name='"+value2+"',Category='"+value3+"',Price='"+value4+"',Date='"+value5+"',Image='"+value6+"' where ID='"+value1+"' ";
        pst=conn.prepareStatement(sql);
        pst.execute();
        JOptionPane.showMessageDialog(null, "Updated");
    } catch(Exception e)
    {
        JOptionPane.showMessageDialog(null, e);
    }
    Update_Table();
}

private void btn_addActionPerformed(java.awt.event.ActionEvent evt) {
    String sql = "Insert into Product_food (ID,Name,Category,Price,Date,Image) values (?,?,?,?,?,?)";
    try
    {
        pst=conn.prepareStatement(sql);


        pst.setString(1, txt_proid.getText());
        pst.setString(2, txt_name.getText());
        pst.setString(3, txt_category.getText());
        pst.setString(4, txt_price.getText());
        pst.setString(5, ((JTextField)txt_adddate.getDateEditor().getUiComponent()).getText());
        pst.setBytes(6, person_image);


        pst.execute();
        JOptionPane.showMessageDialog(null, "Saved");
    }
    catch(Exception e)
    {
        JOptionPane.showMessageDialog(null, e);
    }
    Update_Table();
}

private void btn_deleteActionPerformed(java.awt.event.ActionEvent evt) {
    int p = JOptionPane.showConfirmDialog(null, "Do you really want to delete?", "Delete", JOptionPane.YES_NO_OPTION);
    if(p==0)
    {
        String sql = "Delete from Product_food where ID=?";
        try
        {
            pst=conn.prepareStatement(sql);

            pst.setString(1, txt_proid.getText());

            pst.execute();
            JOptionPane.showMessageDialog(null, "Deleted");
        }
        catch(Exception e)
        {
            JOptionPane.showMessageDialog(null, e);
        }
        Update_Table();
    }
}

private void tbl_foodsKeyReleased(java.awt.event.KeyEvent evt) {
    if(evt.getKeyCode() == KeyEvent.VK_DOWN || evt.getKeyCode() == KeyEvent.VK_UP)
    {
        try
    {
        int raw = tbl_foods.getSelectedRow();
        String Table_Click = (tbl_foods.getModel().getValueAt(raw, 0).toString());
        String sql = "Select * from Product_food where ID='"+Table_Click+"' ";
        pst=conn.prepareStatement(sql);
        rs=pst.executeQuery();
        if(rs.next())
        {
            String add1 = rs.getString("ID");
            txt_proid.setText(add1);
            String add2 = rs.getString("Name");
            txt_name.setText(add2);
            String add3 = rs.getString("Category");
            txt_category.setText(add3);
            Double add4 = rs.getDouble("Price");
            txt_price.setText(Double.toString(add4));
            Date add5 = rs.getDate("Date");
            txt_adddate.setDate(add5);
            byte[] add6 = rs.getBytes("Image");
            format = new ImageIcon(add6);
            lbl_img.setIcon(format);


        }
    }
    catch(Exception e)
    {
        JOptionPane.showMessageDialog(null, e);
    }
    }
}

private void tbl_foodsMouseClicked(java.awt.event.MouseEvent evt) {
    int raw = tbl_foods.getSelectedRow();
    String Table_Click = (tbl_foods.getModel().getValueAt(raw, 0).toString());
    try
    {
        String sql = "Select Image from Product_food where ID='"+Table_Click+"'";
        pst=conn.prepareStatement(sql);
        rs=pst.executeQuery();
        if(rs.next())
        {
            byte[] imagedata = rs.getBytes("Image");
            format = new ImageIcon(imagedata);
            lbl_img.setIcon(format);
        }
    }
    catch(Exception e)
    {
        e.printStackTrace();
    }

    try
    {

        String sql = "Select * from Product_food where ID='"+Table_Click+"' ";
        pst=conn.prepareStatement(sql);
        rs=pst.executeQuery();
        if(rs.next())
        {
            String add1 = rs.getString("ID");
            txt_proid.setText(add1);
            String add2 = rs.getString("Name");
            txt_name.setText(add2);
            String add3 = rs.getString("Category");
            txt_category.setText(add3);
            Double add4 = rs.getDouble("Price");
            txt_price.setText(Double.toString(add4));
            Date add5 = rs.getDate("Date");
            txt_adddate.setDate(add5);
            byte[] add6 = rs.getBytes("Image");
            format = new ImageIcon(add6);
            lbl_img.setIcon(format);


        }
    }
    catch(Exception e)
    {
        JOptionPane.showMessageDialog(null, e);
    }
}

private void btn_browseActionPerformed(java.awt.event.ActionEvent evt) {
    JFileChooser chooser = new JFileChooser();
    chooser.showOpenDialog(null);
    File f = chooser.getSelectedFile(); //file
    //File f = chooser.getCurrentDirectory(); //folder
    filename = f.getAbsolutePath();

    ImageIcon imageIcon = new ImageIcon(new ImageIcon(filename).getImage().getScaledInstance(lbl_img.getWidth(), lbl_img.getHeight(), Image.SCALE_DEFAULT));
    lbl_img.setIcon(imageIcon);
    txt_imgpath.setText(filename);



    try
    {
        File image  = new File(filename);
        FileInputStream fis = new FileInputStream(image);

        ByteArrayOutputStream bos = new ByteArrayOutputStream();
        byte[] buf = new byte[1024];
        for(int readNum; (readNum=fis.read(buf))!=-1;)
        {
            bos.write(buf,0,readNum);
        }
        person_image=bos.toByteArray();
    }
    catch(Exception e)
    {
        JOptionPane.showMessageDialog(null, e);
    }
}