/**
 * 
 */
package com.air.backend.util;

import java.sql.Connection;
import java.sql.SQLException;
import java.sql.Statement;

import org.apache.commons.logging.Log;
import org.apache.commons.logging.LogFactory;

import com.air.exceptions.AirException;
import com.air.form.DestineForm;
import com.air.model.Passenger;
import com.air.persistence.DataSrcUtil;
import com.air.persistence.IsqlDataSource;

/**
 * @author jelly_yang
 *
 */
public class AddDestineUtil {

	private static Log log = LogFactory.getLog(QueryFightUtil.class);
	private AddDestineUtil() {
		// TODO Auto-generated constructor stub
	}

	public static class  AddDestineUtilHolder{
		static AddDestineUtil addDestineUtil = new AddDestineUtil();
	}
	
	public static AddDestineUtil getInstance(){
		return AddDestineUtilHolder.addDestineUtil;
	}
	
	public String addDestine(DestineForm destineForm)throws AirException{
		int result = 0;
		String sSql = "insert into destine(fid,adult_num,child_num,baby_num,contact_person,contact_phone," + 
		              "insurance_price,insurance_num,distribute_style,pay_style,send_address,post_address," +
		              "take_self_address,send_date,send_time,post,status) " + 
		              " values("+destineForm.getFightId()+",'"+destineForm.getAdultNum()+"','"+
		              destineForm.getChildNum()+"','"+destineForm.getBabyNum()+"','"+destineForm.getContactPerson()+"','"+
		              destineForm.getContactPhone()+"',"+Double.parseDouble(destineForm.getInsurancePrice())+","+Double.parseDouble(destineForm.getInsuranceNum())+",'"+
		              destineForm.getDistributeStyle()+"','"+destineForm.getPayStyle()+"','"+
		              destineForm.getSendAddress()+"','"+destineForm.getPostAddress()+"','"+
		              destineForm.getTakeSelfAddress()+"','"+destineForm.getSendDate()+"','"+destineForm.getSendTime()+"','"+destineForm.getPost()+"','正在處理中')";
		IsqlDataSource src = DataSrcUtil.getInstance().getDataSource();
		Connection conn = null;
		log.debug("addDestine() -- sSql["+ sSql+ "]");
		try
		{
			conn = src.getConnection();
			Statement stmt = conn.createStatement();
			result = src.executeUpdate(stmt, sSql);
		}
		catch(SQLException se)
		{
			log.error("addDestine() caught SQLException: " + se);
		}
		catch(Exception ex)
		{
			log.error("addDestine() caught Exception: " + ex);
		}
		finally
		{
			src.closeConn(conn);
		}
		if(result==0){
			return "0";
		}
		return destineForm.getFightId();
	}
	
	public boolean addPassengers(Passenger passenger)throws AirException{
		int result = 0;
		String sSql = "insert into passenger(name,credentials,number,fid,born_date) " + 
		              " values('"+passenger.getName()+"','"+passenger.getCredentials()+"','"+
		              passenger.getNumber()+"',"+passenger.getFightId()+",'"+passenger.getBornDate()+"')";
		IsqlDataSource src = DataSrcUtil.getInstance().getDataSource();
		Connection conn = null;
		log.debug("addDestine() -- sSql["+ sSql+ "]");
		try
		{
			conn = src.getConnection();
			Statement stmt = conn.createStatement();
			result = src.executeUpdate(stmt, sSql);
		}
		catch(SQLException se)
		{
			log.error("addDestine() caught SQLException: " + se);
		}
		catch(Exception ex)
		{
			log.error("addDestine() caught Exception: " + ex);
		}
		finally
		{
			src.closeConn(conn);
		}
		if(result==0){
			return false;
		}
		return true;
	}
}