package com.reallinkbilling.resource;

import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;

import org.apache.struts2.dispatcher.SessionMap;

public class GetNewIdForNewEntry {
	
	
	public static int getNewIdForNewEntry(String tableName, String columnName, SessionMap<String, Object> sessionMap, Connection connection)
	{
		int newId = 0;
		

		PreparedStatement preparedStatement= null;
		ResultSet resultSet = null;
		
		String sql = "";
		
	  		String shopId = (String) sessionMap.get("shopId");
    		String shopCode = (String) sessionMap.get("shopCode");

			try
			{
				if(sessionMap != null)
				{
					sql = "SELECT "
							+ columnName
							+ " FROM "
							+ tableName
							+ " WHERE "
							+ "shop_id = ? "
							+ "AND "
							+ "shop_code = ? "
							+ "ORDER BY "
							+ columnName
							+ " DESC LIMIT 1";
					
				
						preparedStatement = connection.prepareStatement(sql);
						preparedStatement.setString(1, shopId);
						preparedStatement.setString(2, shopCode);
						
						resultSet = preparedStatement.executeQuery();
					
						if(resultSet.next())
						{
							if(!(resultSet.getString(1) == null))
							{
								newId = resultSet.getInt(1) + 1;					
							}
							
						}else
						{
							newId = 1;
						}
				}
				
			
			} catch (SQLException e) {
				//e.printStackTrace();
				newId = 0;
				
			}finally {
				if(resultSet != null)
				{
					try {
						resultSet.close(); resultSet = null;
					} catch (SQLException e) {
						
					}
				}
				if(preparedStatement != null)
				{
					try {preparedStatement.close(); preparedStatement = null;} catch (SQLException e) {}
				}
				
				
			}
		
		
		
		return newId;
	}

}
