package com.reallinkbilling.utils;

import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;

import org.apache.struts2.dispatcher.SessionMap;

public class DeleteAccountClosingBalLastEntry {
	
	public static boolean deleteAccountClosingBalLastEntry(String accountId, Connection connection, String entryDate, SessionMap<String, Object> sessionMap)
	{
		boolean entryDeleted = false;
		
		
		String shopId = (String) sessionMap.get("shopId");
		String shopCode = (String) sessionMap.get("shopCode");
		
		PreparedStatement preparedStatement= null;
		ResultSet resultSet = null;
		
		String sql = "";
		
		try
		{
			sql = "SELECT * "
					+ "FROM "
					+ "datewise_closing_balance "
					+ "WHERE "
					+ "closeing_bal_date = STR_TO_DATE(?,'%d-%m-%Y') "
					+ "AND "
					+ "account_id = ? "
					+ "AND "
					+ "shop_id = ? "
					+ "AND "
					+ "shop_code = ?";
			
			preparedStatement = connection.prepareStatement(sql);
			
			preparedStatement.setString(1, entryDate);
			preparedStatement.setString(2, accountId);
			preparedStatement.setString(3, shopId);
			preparedStatement.setString(4, shopCode);
			
			resultSet = preparedStatement.executeQuery();
			
			int rowCount = 0;
			
			resultSet.last();
			
			rowCount = resultSet.getRow();
			
			resultSet.beforeFirst();
			
			
			
			if(rowCount == 1)
			{
				
				if(resultSet != null)
				{
					resultSet.close();
					resultSet = null;					
				}
				
				if(preparedStatement != null)
				{
					preparedStatement.close();
					preparedStatement = null;
				}
				
				
				sql = "DELETE "
						+ "FROM "
						+ "datewise_closing_balance "
						+ "WHERE "
						+ "closeing_bal_date = STR_TO_DATE(?,'%d-%m-%Y') "
						+ "AND "
						+ "account_id = ?";
				
				preparedStatement = connection.prepareStatement(sql);
				
				preparedStatement.setString(1, entryDate);
				preparedStatement.setString(2, accountId);
				
				int k = preparedStatement.executeUpdate();
				
				
				if(k>0)
				{
					entryDeleted = true;
				}
			}
			else
			{
				entryDeleted = true;
			}
		
		
			
		}
		catch (SQLException e) {
			entryDeleted = false;
			
		}
		catch (Exception e) {
			entryDeleted = false;
		}finally {
			if(resultSet != null)
			{
				try {resultSet.close(); resultSet = null;}catch(SQLException sqe){}   					
			}
			if(preparedStatement != null)
			{
				try {preparedStatement.close(); preparedStatement = null;} catch (SQLException e) {}
			}
			
			
		}
	
		
		return entryDeleted;
		
	}

}
