package jsonPackage;

import java.io.IOException;
import java.sql.Connection;
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 org.json.simple.JSONObject;

import main_package.DataBaseConnection;
import main_package.DataBaseMethods;
import main_package.UserInfo;

@ManagedBean(name = "myNidhiShareholderData")
@ViewScoped

public class MyNidhiShareholderDataJson 
{
    private String json;

    public MyNidhiShareholderDataJson() 
    {
        JSONObject mainobj = new JSONObject();

        Connection conn = null;

        try
        {
            DataBaseMethods dbm = new DataBaseMethods();

            Map<String, String> params = FacesContext.getCurrentInstance().getExternalContext().getRequestParameterMap();

            String shareholderNo = params.get("shareholderNo");

            if(shareholderNo != null && !shareholderNo.trim().equals(""))
            {
                conn = DataBaseConnection.JAVAConnection();

                UserInfo ui = new UserInfo();

                ui = dbm.allShareHoldersForView(shareholderNo, ui);

                if(ui != null)
                {
                    JSONObject obj = new JSONObject();

                    obj.put("id", ui.getId());
                    obj.put("address", ui.getAddress());
                    obj.put("office_application_no", ui.getOffice_application_no());
                    obj.put("office_date", ui.getOffice_date() != null ? ui.getOffice_date().toString() : "");
                    obj.put("strOffcDate", ui.getStrOffcDate());
                    obj.put("shareHolderNo", ui.getShareHolderNo());
                    obj.put("first_applicantName", ui.getFirst_applicantName());
                    obj.put("dob", ui.getDob() != null ? ui.getDob().toString() : "");
                    obj.put("strdob", ui.getStrdob());
                    obj.put("father_husband_name", ui.getFather_husband_name());
                    obj.put("guardian_name", ui.getGuardian_name());
                    obj.put("guardian_relation", ui.getGuardian_relation());
                    obj.put("status", ui.getStatus());
                    obj.put("PAN", ui.getPAN());
                    obj.put("bank_accountNo", ui.getBank_accountNo());
                    obj.put("bank_name", ui.getBank_name());
                    obj.put("branch", ui.getBranch());
                    obj.put("contactNo", ui.getContactNo());
                    obj.put("nominee_name", ui.getNominee_name());
                    obj.put("centerCode", ui.getCenterCode());
                    obj.put("nominee_fatherName", ui.getNominee_fatherName());
                    obj.put("nominee_motherName", ui.getNominee_motherName());
                    obj.put("occupation", ui.getOccupation());
                    obj.put("bankIfsc", ui.getBankIfsc());
                    obj.put("nomineeBankName", ui.getNomineeBankName());
                    obj.put("appCheque", ui.getAppCheque());
                    obj.put("uniqueId", ui.getUniqueId());
                    obj.put("altMobileNo", ui.getAltMobileNo());

                    obj.put("nominee_relation", ui.getNominee_relation());
                    obj.put("nomRelation", ui.getNomRelation());

                    obj.put("nominee_dob", ui.getNominee_dob() != null ? ui.getNominee_dob().toString() : "");
                    obj.put("strNomDate", ui.getStrNomDate());

                    obj.put("nominee_address", ui.getNominee_address());
                    obj.put("nomBankBranch", ui.getNomBankBranch());
                    obj.put("nomBankAccNo", ui.getNomBankAccNo());
                    obj.put("nomBankIfscCode", ui.getNomBankIfscCode());
                    obj.put("nomMobileNo", ui.getNomMobileNo());

                    obj.put("noOfShare", ui.getNoOfShare());
                    obj.put("shareAmount", ui.getShareAmount());
                    obj.put("totalAmount", ui.getTotalAmount());

                    obj.put("category", ui.getCategory());
                    obj.put("perAddress", ui.getPerAddress());
                    obj.put("crNo", ui.getCrNo());
                    obj.put("payMode", ui.getPayMode());
                    obj.put("relation", ui.getRelation());
                    obj.put("g1C", ui.getG1C());

                    obj.put("applicant_photo", ui.getApplicant_photo());
                    obj.put("signPhoto", ui.getSignPhoto());
                    obj.put("formPhoto", ui.getFormPhoto());

                    obj.put("doc1Path", ui.getDoc1Path());
                    obj.put("doc2Path", ui.getDoc2Path());
                    obj.put("doc3Path", ui.getDoc3Path());
                    obj.put("doc4Path", ui.getDoc4Path());
                    obj.put("doc5Path", ui.getDoc5Path());
                    obj.put("doc6Path", ui.getDoc6Path());
                    obj.put("doc7Path", ui.getDoc7Path());
                    obj.put("doc8Path", ui.getDoc8Path());
                    obj.put("doc9Path", ui.getDoc9Path());
                    obj.put("doc10Path", ui.getDoc10Path());
                    obj.put("doc11Path", ui.getDoc11Path());

                    obj.put("bankNameCheque", ui.getBankNameCheque());
                    obj.put("chequeNo", ui.getChequeNo());

                    obj.put("transferFrom", ui.getTransferFrom());
                    obj.put("disable", ui.isDisable());

                    obj.put("voterId", ui.getVoterId());
                    obj.put("rationNo", ui.getRationNo());
                    obj.put("dlNo", ui.getDlNo());
                    obj.put("electBill", ui.getElectBill());
                    obj.put("resCert", ui.getResCert());
                    obj.put("gCheque", ui.getgCheque());
                    obj.put("tBill", ui.gettBill());

                    obj.put("transferBank", ui.getTransferBank());
                    obj.put("transferToBankName", ui.getTransferToBankName());

                    obj.put("gender", ui.getGender());
                    obj.put("maritalStatus", ui.getMaritalStatus());
                    obj.put("keyPersonName", ui.getKeyPersonName());
                    obj.put("keyPersonRelation", ui.getKeyPersonRelation());
                    obj.put("telephoneIndicator", ui.getTelephoneIndicator());
                    obj.put("noOfDependent", ui.getNoOfDependent());
                    obj.put("religion", ui.getReligion());
                    obj.put("stateCode", ui.getStateCode());
                    obj.put("pinCode", ui.getPinCode());

                    obj.put("maritalStatusLabel", ui.getMaritalStatusLabel());
                    obj.put("keyPersonRelationLabel", ui.getKeyPersonRelationLabel());
                    obj.put("telephoneIndicatorLabel", ui.getTelephoneIndicatorLabel());
                    obj.put("religionLabel", ui.getReligionLabel());
                    obj.put("stateCodeLabel", ui.getStateCodeLabel());

                    obj.put("city", ui.getCity());
                    obj.put("cityName", ui.getCityName());

                    obj.put("email", ui.getEmail());
                    obj.put("qualification", ui.getQualification());
                    obj.put("referenceBy", ui.getReferenceBy());
                    obj.put("remark", ui.getRemark());
                    obj.put("title", ui.getTitle());
                    obj.put("monthlyIncome", ui.getMonthlyIncome());

                    obj.put("nomAadhar", ui.getNomAadhar());
                    obj.put("nomPan", ui.getNomPan());

                    obj.put("brideFhname", ui.getBrideFhname());
                    obj.put("brideMname", ui.getBrideMname());
                    obj.put("brideAddress", ui.getBrideAddress());
                    obj.put("brideBusiness", ui.getBrideBusiness());
                    obj.put("brideBusinessPlace", ui.getBrideBusinessPlace());
                    obj.put("brideMobileNo", ui.getBrideMobileNo());
                    obj.put("brideRemark", ui.getBrideRemark());

                    obj.put("centerId", ui.getCenterId());

                    obj.put("nomTitle", ui.getNomTitle());
                    obj.put("nomGender", ui.getNomGender());

                    obj.put("latitude", ui.getLatitude());
                    obj.put("longitude", ui.getLongitude());

                    mainobj.put("shareholder", obj);
                }
                else
                {
                    mainobj.put("status", "error");
                    mainobj.put("message", "Shareholder not found");
                }
            }
            else
            {
                mainobj.put("status", "error");
                mainobj.put("message", "shareholderNo is required");
            }
        }
        catch(Exception e)
        {
            e.printStackTrace();

            mainobj.put("status", "error");
            mainobj.put("message", e.getMessage());
        }
        finally
        {
            try
            {
                if(conn != null)
                {
                    conn.close();
                }
            }
            catch(Exception e)
            {
                e.printStackTrace();
            }
        }

        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;
    }

}