sales2.java

import java.awt.EventQueue;

import javax.swing.JFrame;
import javax.swing.JLabel;
import javax.swing.JOptionPane;
import javax.swing.JTextField;
import javax.swing.JPanel;
import javax.swing.border.EmptyBorder;
import java.awt.Font;
import javax.swing.JTextArea;
import javax.swing.JSeparator;
import javax.swing.JButton;
import javax.swing.JComboBox;
import javax.swing.SwingConstants;
import java.awt.Component;
import java.awt.Rectangle;
import java.awt.event.ActionListener;
import java.sql.Connection;
import java.sql.Date;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.Statement;
import java.text.DateFormat;
import java.text.SimpleDateFormat;
import java.awt.event.ActionEvent;
import com.toedter.calendar.JCalendar;
import com.toedter.components.JLocaleChooser;
import com.toedter.calendar.JDateChooser;
import java.awt.Color;
import javax.swing.ImageIcon;

public class sales2 {

	public JFrame frmAmElectronics;
	private JTextField t2;
	private JTextField t3;
	private JTextField t4;
	private JTextField t6;
	private JTextField t5;
	Double gst=(double) 0.00d, ta=(double) 0.00d;
	private JTextField c1;
	int qty1,qty2;
	private JTextField t1;

	/**
	 * Launch the application.
	 */
	public static void main(String[] args) {
		EventQueue.invokeLater(new Runnable() {
			public void run() {
				try {
					sales2 window = new sales2();
					window.frmAmElectronics.setVisible(true);
				} catch (Exception e) {
					e.printStackTrace();
				}
			}
		});
	}

	/**
	 * Create the application.
	 */
	public sales2() {
		initialize();
	}

	/**
	 * Initialize the contents of the frame.
	 */
	private void initialize() {
		frmAmElectronics = new JFrame();
		frmAmElectronics.getContentPane().setBackground(new Color(51, 51, 153));
		frmAmElectronics.setTitle("AM  Electronics");
		frmAmElectronics.setBounds(100, 100, 1217, 780);
		frmAmElectronics.setDefaultCloseOperation(JFrame.EXIT_ON_CLOSE);
		frmAmElectronics.getContentPane().setLayout(null);
		JButton b2 = new JButton("Next Product");
		
		
		
		
		JButton btnExit = new JButton("Finish");
		btnExit.addActionListener(new ActionListener() {
			public void actionPerformed(ActionEvent e) {
				
				
			}
				
				
			
		});
		
		JButton button = new JButton("Exit");
		button.addActionListener(new ActionListener() {
			public void actionPerformed(ActionEvent e) {
				
				int resp = JOptionPane.showConfirmDialog(null, "Are you sure you want to exit?");
				if(resp == 0)
				{
					frmAmElectronics.setVisible(false);
					frmAmElectronics.dispose();
					
					
					
				}
			}
		});
		
		t1 = new JTextField();
		t1.setBounds(568, 84, 86, 20);
		frmAmElectronics.getContentPane().add(t1);
		t1.setColumns(10);
		button.setFont(new Font("Cambria", Font.BOLD, 18));
		button.setBounds(762, 382, 110, 31);
		frmAmElectronics.getContentPane().add(button);
		btnExit.setBounds(600, 382, 108, 31);
		frmAmElectronics.getContentPane().add(btnExit);
		btnExit.setFont(new Font("Cambria", Font.BOLD, 14));
		

		try {
			Connection conObject=DriverManager.getConnection("jdbc:ucanaccess://d:/electronics1.accdb");
			Statement stmt = conObject.createStatement();
			String query  = "Select  top 1  sales_id from sales order by sales_id desc";
			ResultSet rs = stmt.executeQuery(query);		
			
			if(!rs.next())
				t1.setText(String.valueOf(1));
			else
			
				t1.setText(String.valueOf(rs.getInt(1)+1));
				
			
			
			stmt.close();
			conObject.close();
			}
			catch(Exception e1)
			{
				JOptionPane.showMessageDialog(null, e1);
			}
		
		
		JSeparator separator_1 = new JSeparator();
		separator_1.setBounds(424, 69, 314, 2);
		frmAmElectronics.getContentPane().add(separator_1);
		b2.setBounds(421, 382, 147, 31);
		frmAmElectronics.getContentPane().add(b2);
		b2.setFont(new Font("Cambria", Font.BOLD, 14));
		
		JLabel lblProdcutDetailsForm = new JLabel("Sales");
		lblProdcutDetailsForm.setBounds(570, 37, 116, 21);
		frmAmElectronics.getContentPane().add(lblProdcutDetailsForm);
		lblProdcutDetailsForm.setForeground(Color.BLACK);
		lblProdcutDetailsForm.setFont(new Font("Cambria", Font.BOLD, 15));
		
		JComboBox<String> c2 = new JComboBox<String>();
		c2.setBounds(570, 215, 138, 22);
		frmAmElectronics.getContentPane().add(c2);
		
		JComboBox<String> c1 = new JComboBox<String>();
		c1.setBounds(568, 177, 138, 22);
		frmAmElectronics.getContentPane().add(c1);

		
		
		
		JButton b1 = new JButton("Save");
		b1.setBounds(280, 382, 108, 31);
		frmAmElectronics.getContentPane().add(b1);
		b1.addActionListener(new ActionListener() {
			public void actionPerformed(ActionEvent e) {
			}
		});

		b1.setFont(new Font("Cambria", Font.BOLD, 14));
		
		b2.addActionListener(new ActionListener() {
			public void actionPerformed(ActionEvent e) 
			
			{
				
			}
		});
		
		JLabel lblPrice = new JLabel("Price");
		lblPrice.setBounds(433, 268, 82, 14);
		frmAmElectronics.getContentPane().add(lblPrice);
		lblPrice.setForeground(Color.BLACK);
		lblPrice.setFont(new Font("Cambria", Font.BOLD, 15));
		
		JLabel lblGst = new JLabel("GST (15%)");
		lblGst.setBounds(433, 300, 82, 14);
		frmAmElectronics.getContentPane().add(lblGst);
		lblGst.setForeground(Color.BLACK);
		lblGst.setFont(new Font("Cambria", Font.BOLD, 15));
		
		JLabel lblBrandId = new JLabel("Quantity");
		lblBrandId.setBounds(433, 243, 82, 14);
		frmAmElectronics.getContentPane().add(lblBrandId);
		lblBrandId.setForeground(Color.BLACK);
		lblBrandId.setFont(new Font("Cambria", Font.BOLD, 15));
		
		JLabel lblTotalAmount = new JLabel("Total Amount");
		lblTotalAmount.setBounds(433, 329, 100, 14);
		frmAmElectronics.getContentPane().add(lblTotalAmount);
		lblTotalAmount.setForeground(Color.BLACK);
		lblTotalAmount.setFont(new Font("Cambria", Font.BOLD, 15));
		
		JLabel lblBrandNsme = new JLabel("Product Name");
		lblBrandNsme.setBounds(433, 217, 116, 14);
		frmAmElectronics.getContentPane().add(lblBrandNsme);
		lblBrandNsme.setForeground(Color.BLACK);
		lblBrandNsme.setFont(new Font("Cambria", Font.BOLD, 15));
		
		
		t5 = new JTextField();
		t5.setBounds(570, 299, 138, 20);
		frmAmElectronics.getContentPane().add(t5);
		t5.setColumns(10);
		
		t6 = new JTextField();
		t6.setBounds(570, 330, 138, 20);
		frmAmElectronics.getContentPane().add(t6);
		t6.setEnabled(false);
		t6.setColumns(10);
		
		t3 = new JTextField();
		t3.setBounds(570, 244, 138, 20);
		frmAmElectronics.getContentPane().add(t3);
		t3.setColumns(10);
		
		t3.addActionListener(new ActionListener() {
			public void actionPerformed(ActionEvent e) 
			{
				
				gst= (Double.parseDouble(t4.getText())* 0.15);
				t5.setText(String.valueOf(gst));
			  
				 ta= (Double.parseDouble(t4.getText()) + gst ) * Integer.parseInt(t3.getText());
				  t6.setText(String.valueOf(ta));
			}
});
		
		t4 = new JTextField();
		t4.setBounds(570, 267, 138, 20);
		frmAmElectronics.getContentPane().add(t4);
		t4.setEnabled(false);
		t4.setColumns(10);
		
		t4.addActionListener(new ActionListener() {
			public void actionPerformed(ActionEvent e) 
			{
				
				 gst=  (Double.parseDouble(t4.getText())* 0.15);
				t5.setText(String.valueOf(gst));
			  
				 ta=  (Double.parseDouble(t4.getText()) + gst ) * Integer.parseInt(t3.getText());
				  t6.setText(String.valueOf(ta));
			}
});
		
		JSeparator separator_2 = new JSeparator();
		separator_2.setBounds(433, 205, 294, 2);
		frmAmElectronics.getContentPane().add(separator_2);
		
		
		JLabel lblSupplierName = new JLabel("Customer Name");
		lblSupplierName.setBounds(433, 178, 116, 16);
		frmAmElectronics.getContentPane().add(lblSupplierName);
		lblSupplierName.setForeground(Color.BLACK);
		lblSupplierName.setFont(new Font("Cambria", Font.BOLD, 15));
		
		JLabel lblProductName = new JLabel("Date");
		lblProductName.setBounds(433, 146, 100, 14);
		frmAmElectronics.getContentPane().add(lblProductName);
		lblProductName.setForeground(Color.BLACK);
		lblProductName.setFont(new Font("Cambria", Font.BOLD, 15));
		
		//c1 = new JTextField();
		//c1.setBounds(570, 177, 138, 20);
		//frmAmElectronics.getContentPane().add(c1);
		//c1.setColumns(10);
		
		JLabel lblProductNo = new JLabel("Invoice No");
		lblProductNo.setBounds(433, 114, 82, 21);
		frmAmElectronics.getContentPane().add(lblProductNo);
		lblProductNo.setForeground(Color.BLACK);
		lblProductNo.setFont(new Font("Cambria", Font.BOLD, 15));
		
		JDateChooser d1 = new JDateChooser();
		d1.setBounds(570, 146, 138, 20);
		frmAmElectronics.getContentPane().add(d1);
		d1.setDateFormatString("dd-MMM-yyyy");
		
		JLabel lblPurchaseId = new JLabel("Sales Id");
		lblPurchaseId.setBounds(433, 82, 82, 21);
		frmAmElectronics.getContentPane().add(lblPurchaseId);
		lblPurchaseId.setForeground(Color.BLACK);
		lblPurchaseId.setFont(new Font("Cambria", Font.BOLD, 15));
		
		
		
		t2 = new JTextField();
		t2.setBounds(570, 115, 138, 20);
		frmAmElectronics.getContentPane().add(t2);
		t2.setColumns(10);
		
		JLabel lblNewLabel = new JLabel("");
		lblNewLabel.setIcon(new ImageIcon("C:\\Users\\LENOVO\\Desktop\\project images\\dairy-1986532__340.jpg"));
		lblNewLabel.setBounds(0, 11, 1175, 757);
		frmAmElectronics.getContentPane().add(lblNewLabel);
		
		
		

		try {
			Connection conObject=DriverManager.getConnection("jdbc:ucanaccess://d:/electronics1.accdb");
			Statement stmt = conObject.createStatement();
			String query  = "Select  top 1  sales_id from sales order by sales_id desc";
			ResultSet rs = stmt.executeQuery(query);		
			
			if(!rs.next())
				t1.setText(String.valueOf(1));
			else
			{
				t1.setText(String.valueOf(rs.getInt(1)+1));
				//JOptionPane.showMessageDialog(null, String.valueOf(rs.getInt(1)));
			}
			
			stmt.close();
			conObject.close();
			}
			catch(Exception e1)
			{
				JOptionPane.showMessageDialog(null, e1);
			}
		
		try {
			Connection conObject=DriverManager.getConnection("jdbc:ucanaccess://d:/electronics1.accdb");
			Statement stmt = conObject.createStatement();
			String query  = "Select modelname from actual_product";
			ResultSet rs = stmt.executeQuery(query);		
			while(rs.next())
			{
				c2.addItem(rs.getString(2));
			}
			
			stmt.close();
			conObject.close();
			}
			catch(Exception e1)
			{
				JOptionPane.showMessageDialog(null, e1);
			}
		
		
	
	
	}
}