package proxy;

import java.sql.*;

import connector.Executor;
import connector.Searcher;
public class InvoiceManager {
	
	private static Searcher s = new Searcher();
	private static ExecutorProxy e = new ExecutorProxy();

	public static int[] insertInvoices(Statement stmt) throws SQLException,
			BatchUpdateException {
/*		for(int i=0;i<30;i++){
			insert("Ono"+i%10, "BID"+i%19, i,i*1.5);
		}*/

		insert("Ono00001","BID00001",1,45.99);
		insert("Ono00004","BID00001",1,45.99);
		insert("Ono00002","BID00003",2,71.60);
		insert("Ono00011","BID00004",1,22.99);
		insert("Ono00006","BID00005",10,152.00);
		insert("Ono00007","BID00008",1,210.00);
		insert("Ono00008","BID00009",5,99.95);
		insert("Ono00010","BID00009",1,18.99);
		insert("Ono00012","BID00011",1,24.55);
		insert("Ono00003","BID00012",1,12.45);
		insert("Ono00009","BID00012",5,62.25);
		insert("Ono00005","BID00016",1,42.59);
		insert("Ono00013","BID00002",1,45.99);
		insert("Ono00014","BID00006",2,45.99);
		insert("Ono00015","BID00007",1,71.60);
		insert("Ono00016","BID00010",1,22.99);
		insert("Ono00017","BID00013",1,152.00);
		insert("Ono00018","BID00014",3,210.00);
		insert("Ono00019","BID00016",1,99.95);
		insert("Ono00020","BID00018",1,18.99);
		insert("Ono00021","BID00020",10,24.55);
		insert("Ono00022","BID00022",1,12.45);
		insert("Ono00023","BID00024",3,62.25);
		insert("Ono00024","BID00026",1,42.59);
		insert("Ono00025","BID00028",1,45.99);
		insert("Ono00026","BID00030",4,45.99);
		insert("Ono00027","BID00032",1,71.60);
		insert("Ono00028","BID00034",1,22.99);
		insert("Ono00029","BID00036",1,152.00);
		insert("Ono00030","BID00038",5,210.00);
		insert("Ono00001","BID00040",1,99.95);
		insert("Ono00002","BID00042",1,18.99);
		insert("Ono00003","BID00044",6,24.55);
		insert("Ono00004","BID00046",1,12.45);
		insert("Ono00005","BID00048",2,62.25);
		insert("Ono00006","BID00050",1,42.59);
		insert("Ono00007","BID00052",1,45.99);
		insert("Ono00008","BID00054",1,45.99);
		insert("Ono00009","BID00056",10,71.60);
		insert("Ono00010","BID00058",1,22.99);
		insert("Ono00011","BID00060",5,152.00);
		insert("Ono00012","BID00062",5,210.00);
		insert("Ono00013","BID00064",1,99.95);
		insert("Ono00014","BID00066",1,18.99);
		insert("Ono00015","BID00068",1,24.55);
		insert("Ono00016","BID00070",1,12.45);
		insert("Ono00017","BID00072",2,62.25);
		insert("Ono00018","BID00074",1,42.59);
		insert("Ono00019","BID00076",1,45.99);
		insert("Ono00020","BID00078",1,45.99);
		insert("Ono00021","BID00080",3,71.60);
		insert("Ono00022","BID00082",1,22.99);
		insert("Ono00023","BID00084",1,152.00);
		insert("Ono00024","BID00086",10,210.00);
		insert("Ono00025","BID00088",1,99.95);
		insert("Ono00026","BID00090",3,18.99);
		insert("Ono00027","BID00092",1,24.55);
		insert("Ono00028","BID00094",1,12.45);
		insert("Ono00029","BID00096",4,62.25);
		insert("Ono00030","BID00098",1,42.59);
		insert("Ono00001","BID00100",1,45.99);
		insert("Ono00002","BID00102",1,45.99);
		insert("Ono00003","BID00104",5,71.60);
		insert("Ono00004","BID00106",1,22.99);
		insert("Ono00005","BID00108",1,152.00);
		insert("Ono00006","BID00110",6,210.00);
		insert("Ono00007","BID00112",1,99.95);
		insert("Ono00008","BID00114",2,18.99);
		insert("Ono00009","BID00116",1,24.55);
		insert("Ono00010","BID00118",1,12.45);
		insert("Ono00011","BID00120",1,62.25);
		insert("Ono00012","BID00122",10,42.59);
		insert("Ono00013","BID00124",1,42.60);
		insert("Ono00014","BID00126",5,42.61);
		insert("Ono00015","BID00128",5,42.62);
		insert("Ono00016","BID00130",1,42.63);
		insert("Ono00017","BID00132",1,42.64);
		insert("Ono00018","BID00134",1,45.99);
		insert("Ono00019","BID00136",1,45.99);
		insert("Ono00020","BID00138",2,71.60);
		insert("Ono00021","BID00140",1,22.99);
		insert("Ono00022","BID00142",1,152.00);
		insert("Ono00023","BID00144",1,210.00);
		insert("Ono00024","BID00146",3,99.95);
		insert("Ono00025","BID00148",1,18.99);
		insert("Ono00026","BID00150",1,24.55);
		insert("Ono00027","BID00152",10,12.45);
		insert("Ono00028","BID00154",1,62.25);
		insert("Ono00029","BID00156",3,42.59);
		insert("Ono00030","BID00158",1,45.99);
		insert("Ono00001","BID00160",1,45.99);
		insert("Ono00002","BID00162",4,71.60);
		insert("Ono00003","BID00164",1,22.99);
		insert("Ono00004","BID00166",1,152.00);
		insert("Ono00005","BID00168",1,210.00);
		insert("Ono00006","BID00170",5,99.95);
		insert("Ono00007","BID00172",1,18.99);
		insert("Ono00008","BID00174",1,24.55);
		insert("Ono00009","BID00176",6,12.45);
		insert("Ono00010","BID00178",1,62.25);
		
		return null;
	}

	public static int insert(String[] args) {
		if (args.length != 4) {
			System.err.print("InvoiceManeger arguments input error.");
			return -1;
		}
		String query = "insert into invoice values(";
		return e.execute(Checker.argsInsert(query, args));
	}

	public static int insert(String Ono, String BID, int qty,
			double billedPrice) {
		String query = "insert into Invoice values(" + Checker.checkNull(Ono)
				+ "," + Checker.checkNull(BID) + "," + qty + "," + billedPrice
				+ ");";
		return e.execute(query);
	}

	public static int deleteByOno(String Ono) throws SQLException,
			BatchUpdateException {
		String query = "delete from Invoice where Ono = " + Checker.checkNull(Ono)
				+ ";";
		return e.execute(query);
	}

	public static int deleteByBID(String BID) {
		String query = "delete from Invoice where BID =" + Checker.checkNull(BID)
				+ ";";
		return e.execute(query);
	}

}