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.application.FacesMessage;
import javax.faces.bean.ManagedBean;
import javax.faces.bean.ViewScoped;
import javax.faces.context.ExternalContext;
import javax.faces.context.FacesContext;

import main_package.DataBaseConnection;
import main_package.DataBaseMethods;
import main_package.DataBaseMethodsDuplicate;
import main_package.UserInfo;

import org.json.simple.JSONArray;
import org.json.simple.JSONObject;

@ManagedBean(name="otpVerifyJson")
@ViewScoped

public class OtpVerifyJson implements Serializable
{
	String json;
	
	public OtpVerifyJson() 
	{
		Map<String, String> params =FacesContext.getCurrentInstance().
                getExternalContext().getRequestParameterMap();
       
		String branchId = params.get("branchId");
		String centerName = params.get("centerName");
		String centerCode=params.get("centerCode");
		String descriptoin=params.get("descriptoin");
		String dsaCode=params.get("dsaCode");

		 if(centerName.contains("'") || centerCode.contains("'") || descriptoin.contains("'") || dsaCode.contains("'"))
				{
			 centerName="";
			 centerCode="";
			 descriptoin="";
			 dsaCode="";
				}

	   
     Connection conn=DataBaseConnection.JAVAConnection();
     JSONObject mainobj = new JSONObject();
			JSONArray arr=new JSONArray();

			JSONObject obj = new JSONObject();
			
			String status="";
			boolean duplicate=new DataBaseMethodsDuplicate().centerDuplicacy(centerName,centerCode,conn);
			if(duplicate==true)
			{
				status="Duplicate Center Found... Please Change Either Name Or Code";
			}
			else if(centerName.equalsIgnoreCase(""))
			{
				status="Please Enter Valid Center Name... ";
			}
			else
			{
				int i =new DataBaseMethods().addCenter(Integer.parseInt(branchId),centerName,centerCode,descriptoin, dsaCode,"","",conn);
		    	 if(i==1)
		    	 {
		    		 status="Center Add Successfully";
		    	 }
		    	 else
		    	 {
		    		status="Something went wrong.";
		    	 }
			}
	    	 
			 obj.put("st",status);
	    	  
		     arr.add(obj); 
		      

	    mainobj.put("track", arr);

		json=mainobj.toJSONString();
	
		try {
			conn.close();
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
		//int i=new DatabaseMethods1().news(concern);
		  
	}
	
	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;
	}
}	
