package com.reallinkbilling.resource;

import java.io.IOException;
import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;

import org.apache.struts2.dispatcher.SessionMap;

import com.reallinkbilling.db.GetDBConnection;

public class CheckAlreadyAvailable {
	
	
	private String[] result = new String[2];
	
	public String[] checkAvaibility(String tableName, String columnName, String condition, String value, SessionMap<String, Object> sessionMap)
	{
		
		String shopId = (String) sessionMap.get("shopId");
		String shopCode = (String) sessionMap.get("shopCode");
		
		Connection connection = null;
		PreparedStatement preparedStatement= null;
		ResultSet resultSet = null;
		
		String sql = "";
		String db = (String) sessionMap.get("db");
		
	
			try
			{
				if(sessionMap != null)
				{
						if(condition.equals("NA"))						
						{
							
							connection = GetDBConnection.getDBConnection(db);
							connection.setAutoCommit(false);
							
							sql = "SELECT * "
									+ "FROM "
									+ tableName + ""
									+ " WHERE " + columnName + " = ? "
											+ "AND "
											+ "shop_id = ? "
											+ "AND "
											+ "shop_code = ? ";
							
							preparedStatement = connection.prepareStatement(sql);
						
							
							preparedStatement.setString(1, value);
							preparedStatement.setString(2, shopId);
							preparedStatement.setString(3, shopCode);
							resultSet = preparedStatement.executeQuery();
									
							if(resultSet.next())
							{
								result[0] = "true";
								result[1] = "success";
							}
							else
							{
								result[0] = "false";
								result[1] = "success";
							}
						
						
					}
					else
					{
						
						connection = GetDBConnection.getDBConnection(db);
						connection.setAutoCommit(false);
						
						sql = "SELECT * FROM "
								+ tableName + ""
								+ " WHERE " 
								+ "shop_id = ? "
								+ "AND "
								+ "shop_code = ? "
								+ "AND "
								+ columnName + " = ? "+condition+"";
						
						preparedStatement = connection.prepareStatement(sql);
						
					
						preparedStatement.setString(1, shopId);
						preparedStatement.setString(2, shopCode);
						preparedStatement.setString(3, value);
					
					
						resultSet = preparedStatement.executeQuery();
								
						if(resultSet.next())
						{
							result[0] = "true";
							result[1] = "success";
						}
						else
						{
							result[0] = "false";
							result[1] = "success";
						}
					
					}
				}
			} catch (SQLException e) {
				
				result[1] = result[1] + e.getErrorCode()+" || "+e.getMessage() +" || Unable to Check Availablity";
				
			} catch (IOException e) {
			
				result[1] = result[1] + e.getMessage()+" || "+e.getCause()+" || Unable to Check Availablity";
				
			}finally {
				if(resultSet != null)
				{
					try {
						resultSet.close(); resultSet = null;
					} catch (SQLException e) {
						
					}
				}
				if(preparedStatement != null)
				{
					try {preparedStatement.close(); preparedStatement = null;} catch (SQLException e) {}
				}
				if(connection != null)
				{
					
					try {connection.close(); connection = null;}catch (SQLException e) {}
				}
				
			}
       
		
		
		
		return result;
		
	}

}
