package main_package;

import java.io.Serializable;
import java.sql.Connection;
import java.sql.SQLException;
import java.util.ArrayList;

import javax.faces.application.FacesMessage;
import javax.faces.component.UIComponent;
import javax.faces.context.FacesContext;
import javax.servlet.http.HttpSession;
import javax.faces.bean.ManagedBean;
import javax.faces.bean.ViewScoped;


@ManagedBean(name="manageDsa")
@ViewScoped

public class ManageDsaBean implements Serializable
{
	
	String address,name,code,commissionType,numType,maxNum,mobile,limitVal,id,commission_type;
	boolean text=true;
	double commissionValue=0;
	ArrayList<LoanInfo> commissionListDsa;
	ArrayList<String> com= new ArrayList<>();
	ArrayList<DsaListInfo> llist;
	DsaListInfo selectedVar;
	double commission_value;
	ArrayList<LoanInfo> detailsList= new ArrayList<>();
	DataBaseMethods obj=new DataBaseMethods();
	
	public ManageDsaBean()
	{
		HttpSession ss=(HttpSession) FacesContext.getCurrentInstance().getExternalContext().getSession(false);
		int branchId =(int) ss.getAttribute("branchId");
		Connection conn=DataBaseConnection.JAVAConnection();
		llist = obj.viewAllDsa(branchId,conn);
		code= obj.dsaAccountNo(branchId,conn);
		try {
			conn.close();
		} catch (Exception e) {
			// TODO: handle exception
		}
	}
	
//	public void add()
//	{
//		int re=0;
//		Connection conn=DataBaseConnection.JAVAConnection();
//		re= obj.adddsa(code,name.toUpperCase(),address.toUpperCase(),mobile,"",0,"",conn);
//		
//		if(re>0)
//		{
//			FacesContext.getCurrentInstance().addMessage(null, new FacesMessage("DSA Add Sucessfully"));
//			code= obj.dsaAccountNo(conn);
//			address=name=mobile=commissionType="";
//			commissionValue=0;
//			llist = obj.viewAllDsa(conn);
//		}
//		else
//		{
//			FacesContext.getCurrentInstance().addMessage(null, new FacesMessage("Error Occured!!!"));
//		}
//		try {
//			conn.close();
//		} catch (Exception e) {
//			// TODO: handle exception
//		}
//		
//		
//	}
	
	public void commissionValue()
	{
		limitVal="";
		if(commissionType.equals("flat"))
		{
			limitVal="6";
		}
		else
		{
			limitVal="2";
		}
		
		text= false;
		FacesContext context= FacesContext.getCurrentInstance();
		int sno=  (int) UIComponent.getCurrentComponent(context).getAttributes().get("val");
		for(LoanInfo ff: commissionListDsa)
		{
			if(ff.getSno()-1==sno-1)
			{
				commissionListDsa.get(sno-1).setCommissionType(commissionType);
				
			}
		}
	}
	
	public void edit()
	{
		address=selectedVar.getAddress();
		name=selectedVar.getName();
		code=selectedVar.getCode();
		mobile=selectedVar.getMobile();
		id=selectedVar.getId();
		commission_type=selectedVar.getCommission_type();
		commission_value=selectedVar.getCommission_value();
		detailsList= obj.detailsList(selectedVar.getCode());
	}

	public void update()
	{
		HttpSession ss=(HttpSession) FacesContext.getCurrentInstance().getExternalContext().getSession(false);
		int branchId =(int) ss.getAttribute("branchId");
		int i=0;
		for(LoanInfo ff: detailsList)
		{
			if(ff.getCommissionType() == null || ff.getCommissionType().isEmpty()||String.valueOf(ff.getCommission())==null||String.valueOf(ff.getCommission()).isEmpty())
			{
				  i = obj.updateDsa(ff.getId(), name, mobile, address,"",0);
			}
			else
			{
				  i = obj.updateDsa(ff.getId(), name, mobile, address,ff.getCommissionType(),ff.getCommission());
			}
		}
				
		 if(i>0)
		 {
			 FacesContext.getCurrentInstance().addMessage(null, new FacesMessage("DSA Detail update Sucessfully"));
			 Connection conn=DataBaseConnection.JAVAConnection();
			 llist = obj.viewAllDsa(branchId,conn);
			 try {
					conn.close();
				} catch (SQLException e) {
					// TODO Auto-generated catch block
					e.printStackTrace();
				}
		 }
		 else
		 {
			 FacesContext.getCurrentInstance().addMessage(null, new FacesMessage("Error Occuered!!!"));
		 }
	}
	
	public void delete()
	{
		HttpSession ss=(HttpSession) FacesContext.getCurrentInstance().getExternalContext().getSession(false);
		int branchId =(int) ss.getAttribute("branchId");
		 String idp = selectedVar.getId();
		 int i = obj.deletedsa(idp);
		 if(i>0)
		 {
			 FacesContext.getCurrentInstance().addMessage(null, new FacesMessage("Delete Sucessfully"));
			 Connection conn=DataBaseConnection.JAVAConnection();
			 llist = obj.viewAllDsa(branchId,conn);
			 try {
				conn.close();
			} catch (SQLException e) {
				// TODO Auto-generated catch block
				e.printStackTrace();
			}
		 }
		 else
		 {
			 FacesContext.getCurrentInstance().addMessage(null, new FacesMessage("Error Occuered!!!"));
		 }
	}
	
	
	public ArrayList<DsaListInfo> getLlist() {
		return llist;
	}
	public void setLlist(ArrayList<DsaListInfo> llist) {
		this.llist = llist;
	}
	
	public DsaListInfo getSelectedVar() {
		return selectedVar;
	}
	public void setSelectedVar(DsaListInfo selectedVar) {
		this.selectedVar = selectedVar;
	}

	public String getId() {
		return id;
	}

	public void setId(String id) {
		this.id = id;
	}

	
	public String getCommission_type() {
		return commission_type;
	}

	public ArrayList<LoanInfo> getDetailsList() {
		return detailsList;
	}

	

	public void setDetailsList(ArrayList<LoanInfo> detailsList) {
		this.detailsList = detailsList;
	}

	public void setCommission_type(String commission_type) {
		this.commission_type = commission_type;
	}

	public double getCommission_value() {
		return commission_value;
	}

	public void setCommission_value(double commission_value) {
		this.commission_value = commission_value;
	}
	
	
	public String getAddress() {
		return address;
	}
	
	public void setAddress(String address) {
		this.address = address;
	}
	
	public String getName() {
		return name;
	}
	
	public void setName(String name) {
		this.name = name;
	}
	
	public String getCode() {
		return code;
	}
	
	public void setCode(String code) {
		this.code = code;
	}
	
	public String getMobile() {
		return mobile;
	}
	
	public void setMobile(String mobile) {
		this.mobile = mobile;
	}
	
	public String getCommissionType() {
		return commissionType;
	}
	
	public void setCommissionType(String commissionType) {
		this.commissionType = commissionType;
	}
	
	public double getCommissionValue() {
		return commissionValue;
	}
	
	public void setCommissionValue(double commissionValue) {
		this.commissionValue = commissionValue;
	}
	
	
	public boolean isText() {
		return text;
	}
	
	public void setText(boolean text) {
		this.text = text;
	}
	
	public String getNumType() {
		return numType;
	}
	
	public void setNumType(String numType) {
		this.numType = numType;
	}
	
	public String getMaxNum() {
		return maxNum;
	}
	
	public void setMaxNum(String maxNum) {
		this.maxNum = maxNum;
	}
	
	
	
	public String getLimitVal() {
		return limitVal;
	}
	
	public void setLimitVal(String limitVal) {
		this.limitVal = limitVal;
	}
	
	public ArrayList<String> getCom() {
		return com;
	}
	
	public void setCom(ArrayList<String> com) {
		this.com = com;
	}
	
	public ArrayList<LoanInfo> getCommissionListDsa() {
		return commissionListDsa;
	}
	
	public void setCommissionListDsa(ArrayList<LoanInfo> commissionListDsa) {
		this.commissionListDsa = commissionListDsa;
	}
	

}
