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.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.DataBaseMethodsDuplicate;

import org.json.simple.JSONArray;
import org.json.simple.JSONObject;

@ViewScoped
@ManagedBean(name="loanDetailJson")
public class LoanDetailJson implements Serializable
{
	String json;
	
	public LoanDetailJson() throws ParseException 
	{
		Map<String, String> params =FacesContext.getCurrentInstance().
                getExternalContext().getRequestParameterMap();
       
		String id = params.get("id");
		String loanDate = params.get("loanDate");
		String loanAmount = params.get("loanAmount");
		String terms = params.get("terms");
		String emi = params.get("emi");
		String frequency = params.get("frequency");
		String firstEmiDate = params.get("firstEmiDate");
		String loanRemark = params.get("loanRemark");
		
		
		DateFormat formatter = new SimpleDateFormat("dd/MM/yyyy");
		Date loanDateDt=formatter.parse(loanDate);
		Date firstEmiDateDt=formatter.parse(firstEmiDate);
		

	    
     Connection conn=DataBaseConnection.JAVAConnection();
     String status="";
     
     int i=new DatabaseMethods1().appLoanDataInsert(loanDateDt, loanAmount, terms, emi, frequency, firstEmiDateDt, loanRemark, id);
     if(i>0)
     {
    	 status="Data Insert Sucessfully.";
     }
     else
     {
    	 status="Something Went Wrong.";
     }
     
			JSONArray arr=new JSONArray();
			JSONObject obj = new JSONObject();
			
			
			obj.put("st",status);
		     arr.add(obj); 
	    	 
			
		     json=arr.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;
	}
}
