package json_package;

import java.io.IOException;
import java.io.Serializable;
//import java.sql.Connection;
//import java.sql.SQLException;
//import java.text.DateFormat;
import java.text.ParseException;
//import java.text.SimpleDateFormat;
//import java.util.ArrayList;
//import java.util.Date;
//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.faces.model.SelectItem;

//import main_package.BankInfo;
//import main_package.DataBaseConnection;
import main_package.DataBaseMethods;
import main_package.DataBaseMethodsRavi;
//import main_package.DataBaseMethodsSalary;
//import main_package.EmpInfo;
import main_package.UserInfo;

//import org.json.simple.JSONArray;
import org.json.simple.JSONObject;

@ManagedBean(name="directorDetailJson")
@ViewScoped
public class DirectorDetailJson implements Serializable
{
	String json;
	DataBaseMethods dbm=new DataBaseMethods();
    DataBaseMethodsRavi	 dbr = new DataBaseMethodsRavi();
//	ArrayList<UserInfo> list;
	
	public DirectorDetailJson() throws ParseException 
	{
       
//       list=dbm.directorDetail();
		UserInfo uu = dbr.directorDetail();
			
//		JSONObject mainobj = new JSONObject();
//		JSONArray arr=new JSONArray();
		    
		    
		    JSONObject mainobj = new JSONObject();
	        JSONObject obj = new JSONObject();
		
	        
//    	 for(UserInfo uu : list)
//		   {
//			   JSONObject obj = new JSONObject();
	        
//			   obj.put("sno",uu.getSno());
//			   obj.put("name", uu.getName());
//			   obj.put("fatherName",uu.getFather_husband_name());
//			   obj.put("mobile", uu.getMobile());
//			   obj.put("address",uu.getAddress());
//			   obj.put("photo",uu.getApplicant_photo());
//			   
//			   arr.add(obj);
//		   }
		    
	        obj.put("sno",uu.getSno());
		    obj.put("name", uu.getName());
	        obj.put("fatherName", uu.getFather_husband_name());
	        obj.put("mobile", uu.getMobile());
	        obj.put("address", uu.getAddress());
	        obj.put("photo", uu.getApplicant_photo());
	        
	        mainobj.put("track", obj);

//	    mainobj.put("track", arr);

	        json=mainobj.toJSONString();
	
		//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;
	}
}