package json_package;

import java.io.IOException;
import java.io.Serializable;
import java.sql.Connection;
import java.sql.SQLException;
import java.text.ParseException;
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 main_package.DataBaseConnection;
import main_package.DataBaseMethods;
import main_package.SavingAccountInfo;

import org.json.simple.JSONArray;
import org.json.simple.JSONObject;

@ViewScoped
@ManagedBean(name="savingTransferList")
public class SavingTransferListJsonBean  implements Serializable
{

	String json;
	Date startDate;
	
	public SavingTransferListJsonBean() throws ParseException 
	{
		Map<String, String> params =FacesContext.getCurrentInstance().
                getExternalContext().getRequestParameterMap();
       
		String userid = params.get("userid");
		
		 if(userid.contains("'"))
			{
		 userid="";
			}
		
			JSONObject mainobj = new JSONObject();
			JSONArray arr=new JSONArray();
					
			 DataBaseMethods dbm=new DataBaseMethods();
			 Connection conn=DataBaseConnection.JAVAConnection();
			 String acc=dbm.savingAccountByShareHolderNo(userid);
			 ArrayList<SavingAccountInfo> list=dbm.savingAppUserTransferList(acc,conn);
			 
			 if(list.size()>0)
			 {
				 for(SavingAccountInfo ff: list)
				 {
					 JSONObject obj = new JSONObject();
					 	
			    	 obj.put("sno",ff.getSno());
			    	 obj.put("accNo",ff.getAccountNo());
			    	 obj.put("amount",ff.getAmount());
			    	 obj.put("date",ff.getStrEntryDate());
			    	 obj.put("name",ff.getFirst_applicant_name());
			    	  
				     arr.add(obj); 
				 }
			 }
			 	
			      
			     try {
						conn.close();
					} catch (SQLException e) {
						// TODO Auto-generated catch block
						e.printStackTrace();
					}
		    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;
	}
}
