package proxy;

import java.sql.*;
import connector.Searcher;

public class OrdersManager {

	private static Searcher s = new Searcher();
	private static ExecutorProxy e = new ExecutorProxy();
	
	public static int[] insertOrders(Statement stmt) throws SQLException,
			BatchUpdateException {
/*		for(int i=0;i<10;i++){
			insert("Ono"+i, "CID"+i%5, "shipment"+i,"2007-6-"+i, "2008-1-"+i) ;
		}*/
		
		insert("Ono00001","CID0001","next day delivery","2007-01-15","2007-01-14");
		insert("Ono00002","CID0002","regular post","2007-04-10","2007-04-09");
		insert("Ono00003","CID0008","regular post","2007-05-09","2007-05-08");
		insert("Ono00004","CID0009","regular post","2007-02-22","2007-02-21");
		insert("Ono00005","CID0010","next day delivery","2007-03-26","2007-03-24");
		insert("Ono00006","CID0016","regular post","2007-04-14","2007-04-12");
		insert("Ono00007","CID0017","next day delivery","2007-01-16","2007-01-15");
		insert("Ono00008","CID0018","regular post","2007-04-11","2007-04-10");
		insert("Ono00009","CID0019","regular post","2007-05-10","2007-05-09");
		insert("Ono00010","CID0020","regular post","2007-02-23","2007-02-22");
		insert("Ono00011","CID0003","next day delivery","2007-03-27","2007-03-25");
		insert("Ono00012","CID0020","regular post","2007-04-15","2007-04-13");
		insert("Ono00013","CID0001","next day delivery","2007-01-17","2007-01-16");
		insert("Ono00014","CID0004","regular post","2007-04-12","2007-04-11");
		insert("Ono00015","CID0005","regular post","2007-05-11","2007-05-10");
		insert("Ono00016","CID0006","regular post","2007-02-24","2007-02-23");
		insert("Ono00017","CID0007","next day delivery","2007-03-28","2007-03-26");
		insert("Ono00018","CID0008","regular post","2007-04-16","2007-04-14");
		insert("Ono00019","CID0009","next day delivery","2007-01-18","2007-01-17");
		insert("Ono00020","CID0013","regular post","2007-04-13","2007-04-12");
		insert("Ono00021","CID0011","regular post","2007-05-12","2007-05-11");
		insert("Ono00022","CID0012","regular post","2007-02-25","2007-02-24");
		insert("Ono00023","CID0011","next day delivery","2007-03-29","2007-03-27");
		insert("Ono00024","CID0014","regular post","2007-04-17","2007-04-15");
		insert("Ono00025","CID0015","next day delivery","2007-01-19","2007-01-18");
		insert("Ono00026","CID0016","regular post","2007-04-14","2007-04-13");
		insert("Ono00027","CID0017","regular post","2007-05-13","2007-05-12");
		insert("Ono00028","CID0018","regular post","2007-02-26","2007-02-25");
		insert("Ono00029","CID0019","next day delivery","2007-03-30","2007-03-28");
		insert("Ono00030","CID0020","regular post","2007-04-18","2007-04-16");

		return null;
	}

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

	public static int insert(String Ono, String CID, String shipment,
			String shippingDate, String dateArrived) {
		String query = "insert into Orders values(" + Checker.checkNull(Ono) + ","
				+ Checker.checkNull(CID) + "," + Checker.checkNull(shipment) + ","
				+ Checker.checkNull(shippingDate) + ","
				+ Checker.checkNull(dateArrived) + ");";
		return e.execute(query);
	}

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

	public static String getNewOrderID(){
			String ID = pre;
			String last = s.getLastID(TablesManager.orders);
			if(last == null) return "Ono00000";
	 		int num = Integer.parseInt(last.substring(3));
			num++;
			last = String.valueOf(num);
			for(int i = last.length() ;i< 5;i++)
				ID = ID.concat("0");
			ID = ID.concat(last);
			return ID;
		}

	private static final String pre = "Ono";


}