package com.reallinkbilling.render;

import java.io.IOException;
import java.io.OutputStream;
import java.sql.Blob;
import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.util.Map;

import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import javax.servlet.http.HttpSession;

import org.apache.struts2.ServletActionContext;
import org.apache.struts2.dispatcher.SessionMap;
import org.apache.struts2.interceptor.SessionAware;

import com.opensymphony.xwork2.ActionSupport;
import com.reallinkbilling.db.GetDBConnection;


public class RenderCustomerImage extends ActionSupport implements SessionAware{
	/**
	 * 
	 */
	private static final long serialVersionUID = -1729089013207694534L;
	private HttpSession session;
	private SessionMap<String,Object> sessionMap;  
	
	public void rederCustImage(){
		// TODO Auto-generated method stub
		HttpServletResponse response = ServletActionContext.getResponse();
		HttpServletRequest request = ServletActionContext.getRequest();
		
		String custId = request.getParameter("custId");
		
		session=ServletActionContext.getRequest().getSession(false); 
		Connection connection = null;
   		PreparedStatement preparedStatement= null;	
   		ResultSet resultSet = null;
   		
   		String sql = "";
   		String db = (String) this.getSessionMap().get("db");
   		String shopId = (String) this.getSessionMap().get("shopId");
		String shopCode = (String) this.getSessionMap().get("shopCode");
   		try
   		{
   		
   		if(db!=null)
   		{
   			
			connection = GetDBConnection.getDBConnection(db);
   			
   			sql = "SELECT "
   					+ "customer_image "
   					+ "FROM "
   					+ "shop_customer_master "
   					+ "WHERE "
   					+ "shop_id = ? "
   					+ "AND "
   					+ "shop_code = ? "
   					+ "AND "
   					+ "customer_id = ? ";
   			
   			preparedStatement = connection.prepareStatement(sql);
   			preparedStatement.setString(1, shopId);
   			preparedStatement.setString(2, shopCode);
   			preparedStatement.setString(3,custId);
   			resultSet = preparedStatement.executeQuery();
   			if(resultSet.next())
   			{
	   			Blob ph = resultSet.getBlob("customer_image");
				byte data[] = ph.getBytes(1, (int) ph.length());
				OutputStream out = response.getOutputStream();
				out.write(data);
				out.flush();
				out.close();
   			}
   		}
   		}catch (SQLException e) {
			addActionError(e.getErrorCode()+ "| Connection Error !!!");
			
		}catch (IOException e) {
			addActionError(e.getMessage()+ "| Connection Error !!!");
		}
		finally
		{
			if(resultSet != null)
			{
				try {
					resultSet.close();
				} catch (SQLException e) {
					
				}
			}
			if(preparedStatement != null)
			{
				try {
					
					preparedStatement.close();
				} catch (SQLException e) {
					
				}
			}
			if(connection != null)
			{
				try {
					
					connection.close();
				} catch (SQLException e) {
					
					e.printStackTrace();
				}
			}
			
		}
		
		
	}
	public SessionMap<String, Object> getSessionMap() {
		return sessionMap;
	}

	public void setSessionMap(SessionMap<String, Object> sessionMap) {
		this.sessionMap = sessionMap;
	}

 
	public void setSession(Map<String, Object> map) {  
	    sessionMap=(SessionMap<String, Object>)map;  
	}


}