package json_package;

import java.io.IOException;
import java.io.Serializable;
import java.sql.Connection;
import java.sql.SQLException;
import java.util.Map;

import javax.faces.bean.ManagedBean;
import javax.faces.bean.ViewScoped;
import javax.faces.context.ExternalContext;
import javax.faces.context.FacesContext;
import javax.servlet.http.HttpSession;

import main_package.DataBaseConnection;
import main_package.DataBaseMethods;
import main_package.UserInfo;

import org.json.simple.JSONArray;
import org.json.simple.JSONObject;

@ManagedBean(name="apiHitJson")
@ViewScoped

public class ApiHitJsonBean implements Serializable
{
	String json;
	
	public ApiHitJsonBean() 
	{
		Map<String, String> params =FacesContext.getCurrentInstance().
                getExternalContext().getRequestParameterMap();
       
        
		String userId = params.get("userId");
		String apiNo = params.get("apiNo");
		String apiService = params.get("apiService");
		
		if(userId.contains("'"))
		{
			userId="";
		}
		
		
		DataBaseMethods dbm=new DataBaseMethods();
		
		
		  JSONObject mainobj = new JSONObject();
				JSONArray arr=new JSONArray();
			   
 			    	 JSONObject obj = new JSONObject();
 			    	
 			    	int apiBal=dbm.checkApiBalance(apiService);
 			    	
 			    	if(apiBal>0)
 			    	{
 			    		 String status="";
 	 			    	int i =new DataBaseMethods().addApiHitData(apiService, apiNo, userId);
 	 			    	 if(i>=1)
 	 			    	 {
 	 			    		 status="API Record Add Successfully";
 	 			    	 }
 	 			    	 else
 	 			    	 {
 	 			    		status="Something went wrong.";
 	 			    	 }
 	 			    	 
 				    	 obj.put("status", status);
 				    	 obj.put("apiBal", apiBal);
 			    	}
 			    	
			    	 
				      arr.add(obj);
				    	
	
			    mainobj.put("track", arr);

			json=mainobj.toJSONString();
	}
	
	public void renderJson() throws IOException {
 	    FacesContext facesContext = FacesContext.getCurrentInstance();
 	    ExternalContext externalContext = facesContext.getExternalContext();
 	    externalContext.setResponseContentType("application/json");
 	    externalContext.setResponseCharacterEncoding("UTF-8");
 	    externalContext.getResponseOutputWriter().write(json);
 	    facesContext.responseComplete();
 	    
 	    
 	}

	public String getJson() {
		return json;
	}

	public void setJson(String json) {
		this.json = json;
	}
	
}
