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

import java.sql.Connection;
import java.sql.SQLException;
import java.sql.Statement;
import java.util.ArrayList;
import java.util.List;
import java.util.Map;

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

import com.air.exceptions.AirException;
import com.air.form.AddressForm;
import com.air.model.Address;
import com.air.model.LoginUser;
import com.air.persistence.DataSrcUtil;
import com.air.persistence.IsqlDataSource;
import com.air.util.ValHelper;

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

	private static Log log = LogFactory.getLog(AddTakeSelfAddressUtil.class);
	private AddTakeSelfAddressUtil() {
		// TODO Auto-generated constructor stub
	}
	
	public static class AddTakeSelfAddressUtilHolder{
		static AddTakeSelfAddressUtil addTakeSelfAddressUtil = new AddTakeSelfAddressUtil();
	}
	
	public static AddTakeSelfAddressUtil getInstance(){
		return AddTakeSelfAddressUtilHolder.addTakeSelfAddressUtil;
	}
	
	public boolean addTakeSelfAddress(AddressForm addressForm)throws AirException{
		int result = 0;
		String sSql = "insert take_ticket_self_address(city,detail) values('"+addressForm.getCity()+"','"+addressForm.getAddress()+"')"; 
		IsqlDataSource src = DataSrcUtil.getInstance().getDataSource();
		Connection conn = null;
		try
		{
			conn = src.getConnection();
			Statement stmt = conn.createStatement();
			result = src.executeUpdate(stmt,sSql);
		}
		catch(SQLException se)
		{
			se.printStackTrace();
			log.error("addTakeSelfAddress() caught SQLException: " + se);
		}
		catch(Exception ex)
		{
			ex.printStackTrace();
			log.error("addTakeSelfAddress() caught Exception: " + ex);
		}
		finally
		{
			src.closeConn(conn);
		}
		if(result>0){
			return true;
		}
		return false;
	}
	
	public List<Address> getAddressByCity(String cty)throws AirException{
		List<Address> list = new ArrayList<Address>();
		List<Map<String,String>> result = new ArrayList<Map<String,String>>();
		String sSql = "select * from take_ticket_self_address where city='"+cty+"'";
       
		IsqlDataSource src = DataSrcUtil.getInstance().getDataSource();
		Connection conn = null;
		log.debug("retrieveFight() -- sSql["+ sSql+ "]");
		try
		{
			conn = src.getConnection();
			result = src.executeRetrieve(conn, sSql);
		}
		catch(SQLException se)
		{
			log.error("getUsers() caught SQLException: " + se);
		}
		catch(Exception ex)
		{
			log.error("getUsers() caught Exception: " + ex);
		}
		finally
		{
			src.closeConn(conn);
		}
		if(!result.isEmpty())
		{
			int size = result.size();
			
			for( int i=0;i<size;i++)
			{
				Map<String,String> resultMap = result.get(i);
				String id = ValHelper.getInstance().getValue(resultMap, "ttsaid");
				String city = ValHelper.getInstance().getValue(resultMap, "city");
				String detail = ValHelper.getInstance().getValue(resultMap, "detail");
				
				Address address = new Address();
				address.setId(id);
				address.setCity(city);
				address.setAddress(detail);	
			    list.add( address );
			}
		}
		return list;
	}
}