public class Payment {
 
	private int InvoiceNo;
	private String Date;
	private String Time;
	private int TableNo;
	private String PayMode;
	private String ProductName;
	private int Qty;
	private String Size;
	private double UnitPrice;
	private double TotalPrice;
	private double SubTotal;
	private float GST;
	private float SurCharge;
	private float MemDisc;
	private float DelCharge;
	private double GrandTotal;
	private double Tendered;
	private double Changed;
	private String Name;
	private int CreditCardNo;
	private String CreditCardType;
	private String ExpDate;
	private int CVC;
 
	public String getName() {
		return Name;
	}
 
	public void setName(String name) {
		this.Name = name;
	}
 
	public int getCreditNo() {
		return CreditCardNo;
	}
 
	public void setCreditNo(int creditNo) {
		this.CreditCardNo = creditNo;
	}
 
	public String getExpiryDate() {
		return ExpDate;
	}
 
	public void setExpiryDate(String expiryDate) {
		ExpDate = expiryDate;
	}
 
	public String getCreditType() {
		return CreditCardType;
	}
 
	public void setCreditType(String creditType) {
		this.CreditCardType = creditType;
	}
 
	public int getCVC() {
		return CVC;
	}
 
	public void setCVC(int cvc) {
		CVC = cvc;
	}
 
	public float getGST() {
		return GST;
	}
 
	public void setGST(float gst) {
		GST = gst;
	}
 
	public Payment() {
		// TODO Auto-generated constructor stub
	}
 
	public boolean retrieveProduct(){
		  // declare local variables
 
		boolean success = false;
 
		ResultSet rs = null;
 
		DBController db = new DBController();
 
		// step 1 of using DBcontroller, passing data source name setup during last practical
 
		db.setUp("SweetParadise");
 
		// declare the SQL 
 
		String dbQuery = "SELECT * FROM PAYMENT WHERE InvoiceNo =" + InvoiceNo;
 
		// step 2 of using DBcontroller, for retrieve SQL use readRequest method
 
		rs = db.readRequest(dbQuery);
 
		try{
 
		   if (rs.next()){
 
		        InvoiceNo = rs.getInt("InvoiceNo");
 
		        /*name = rs.getString("ProductName");
 
		        image = rs.getString("ProductImage");
 
		        unitPrice = rs.getDouble("ProductUnitPrice");   
		        */
		        success = true;     
		   }
		}
 
		catch (Exception e) {
		   e.printStackTrace();
		}
 
		// step 3 of using DBcontroller
		db.terminate();
		return success;		 
		 }
 
	public boolean createPayment(){
 
		  // declare local variables
 
		boolean success = false;
 
		ResultSet rs = null;
 
		DBController db = new DBController();
 
		// step 1 of using DBcontroller, passing data source name setup during last practical
 
		db.setUp("SweetParadise");
 
		// declare the SQL 
 
		String dbQuery = "INSERT INTO PAYMENT(InvoiceNo, Date, Time, TableNo, PayMode, ";
 
		dbQuery = dbQuery + "ProductName, Qty, Size, UnitPrice, TotalPrice, ";
 
		dbQuery = dbQuery + "SubTotal, GST, SurCharge, MemDisc, DelCharge, GrandTotal, ";
 
		dbQuery = dbQuery + "Tendered, Changed, Name, CreditCardNo, CreditCardType, ExpDate, CVC) ";
 
		dbQuery = dbQuery + "VALUES (" + InvoiceNo + ",'" + Date + "', " + Time + ", ";
 
		dbQuery = dbQuery + "'" + TableNo + "', '" + PayMode + "' , '" + ProductName + "', '" + Qty + "',";
 
		dbQuery = dbQuery + "'" +  Size + "', '" + UnitPrice + "', '" + TotalPrice + "', ";
 
		dbQuery = dbQuery + "'" + SubTotal + "', '" + GST + "', '" + SurCharge + "', '" + MemDisc + "', " ;
 
		dbQuery = dbQuery + "'" + DelCharge + "', '" + GrandTotal + "', '" + Tendered + "', '" + Changed + "', '" + Name + "',";
 
		dbQuery = dbQuery + "'" + CreditCardNo + "', '" + CreditCardType + "', '" + ExpDate + "', '" + CVC + "')";
 
 
 
		// step 2 of using DBcontroller, use updateRequestKey method if you want the value of 
 
		// the key back (usually, if the key is autoNumber)
 
		rs = db.updateRequestKey(dbQuery);
 
 
 
		try{
 
 
 
		   if (rs.next()){
 
 
 
 
		        // this will return the ID which is a autoNumber primary key 
 
			    InvoiceNo = rs.getInt("InvoiceNo");
 
		        success = true;     
 
		   }
 
 
 
		}
 
		catch (Exception e) {
 
		   e.printStackTrace();
 
 
 
		}
 
		// step 3 of using DBcontroller
 
		db.terminate();
 
		return success;	 
 
		 }
 
 
 
	/*public static ArrayList<Product> getProductByCategory(int inCatID){
 
 
 
		  // declare local variables
 
		ArrayList<Product> pdtList = new ArrayList<Product>();
 
 
 
		ResultSet rs = null;
 
		DBController db = new DBController();
 
 
 
		// step 1 of using DBcontroller, passing data source name setup during last practical
 
		db.setUp("myDatabase");
 
		String dbQuery = "SELECT * FROM PRODUCTS WHERE ProductCategoryID = " + inCatID; 
 
 
 
		// step 2 of using DBcontroller, use updateRequest method 
 
		rs = db.readRequest(dbQuery);
 
 
 
		try{
 
 
 
		   while (rs.next()){
 
		        int pdtID = rs.getInt("ProductID");
 
		        int pdtCatID = rs.getInt("ProductCategoryID");
 
		        String pdtName = rs.getString("ProductName");
 
		        String pdtImage = rs.getString("ProductImage");
 
		        double pdtUnitPrice = rs.getDouble("ProductUnitPrice");   
 
		        Product pdt = new Product(pdtID, pdtCatID, pdtName, pdtImage, pdtUnitPrice);   
 
		        pdtList.add(pdt);   
 
		   }
 
		}
 
		catch (Exception e) {
 
		   e.printStackTrace();
 
		}
 
		// step 3 of using DBcontroller 
 
		db.terminate();
 
		return pdtList;		 
 
		 }
 
	*/
 
	public static void main(String[] args) {
 
		Payment p1 = new Payment();
 
		p1.setName("test");
 
		p1.setCreditNo(3567843);
 
		System.out.println(p1.createPayment());
 
	}
 
}