package main_package;

import java.io.Serializable;
import java.sql.Connection;
import java.sql.SQLException;
import java.util.ArrayList;
import java.util.Date;
import java.util.List;

import javax.faces.application.FacesMessage;
import javax.faces.bean.ManagedBean;
import javax.faces.bean.ViewScoped;
import javax.faces.context.FacesContext;
import javax.faces.model.SelectItem;
import javax.servlet.http.HttpSession;

import other_package.DataBaseMethodsOther;

@ManagedBean(name="savingAccount")
@ViewScoped
public class SavingAccountBean implements Serializable
{
	private static final long serialVersionUID = 1L;
	public static List<String> list;
	Date requestDate;
	String accountNo,shareHolderNo, dsaCode;
	double amount=0.0,interest,minBal,accCloseCharge;
	int minDaysForClose;
	boolean show, disDsa;
	UserInfo selectedUser;
	ArrayList<SelectItem> dsaList;
	DataBaseMethods obj=new DataBaseMethods();
	int branchId;
	
	public SavingAccountBean()
	{
		HttpSession ss=(HttpSession) FacesContext.getCurrentInstance().getExternalContext().getSession(true);
		 branchId = (int) ss.getAttribute("branchId");
		Connection conn=DataBaseConnection.JAVAConnection();
		String userId=obj.userId();
		dsaList=obj.allDsaList(branchId,"Loan",conn);
		if(obj.userType().equals("employee"))
		{
			dsaCode=obj.dsaCodeByEmpUserId(userId, conn);
			disDsa=true;
		}		
		
		try {
			conn.close();
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
	}
	
	public List<String> completeText(String name)
	{
		HttpSession ss=(HttpSession) FacesContext.getCurrentInstance().getExternalContext().getSession(true);
		 branchId = (int) ss.getAttribute("branchId");
		list=new DataBaseAutoCompAndDuplicate().shareHolderAllNo(branchId,name);
     	return list;
	}
	public void shareHolderDetails()
	{
		HttpSession ss=(HttpSession) FacesContext.getCurrentInstance().getExternalContext().getSession(true);
		 branchId = (int) ss.getAttribute("branchId");
		Connection conn=DataBaseConnection.JAVAConnection();
		shareHolderNo=shareHolderNo.substring(0,shareHolderNo.indexOf("/"));
		ArrayList<UserInfo> list=new ArrayList<UserInfo>();
		list=new DataBaseMethodsOther().allSavingAccountBean(shareHolderNo);
		if(list.size()>0)
		{
			FacesContext.getCurrentInstance().addMessage(null, new FacesMessage("Saving Account Is Already Opened By This Share Holder"));
		}
		else
		{
			selectedUser=obj.userInfoByShareHolderNo(shareHolderNo,conn);
			if(selectedUser!=null)
			{
				show=true;
		        accountNo=obj.savingAccountNo(branchId); 	
		        requestDate=new Date(); 
			}
			else
			{
				show=false;
				FacesContext fc=FacesContext.getCurrentInstance();
				fc.addMessage(null, new FacesMessage("Invalid Share Holder No"));
			}
		}
		
		try {
			conn.close();
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
	}
	
   public void addAccount()
   {
	   HttpSession ss=(HttpSession) FacesContext.getCurrentInstance().getExternalContext().getSession(true);
		 branchId = (int) ss.getAttribute("branchId");
	   amount=0.0;
	   boolean z=new DataBaseMethodsDuplicate().savingAccountNoDuplicacy(accountNo);
	   if(z==true)
	   {
			accountNo=obj.savingAccountNo(branchId); 	
	   }
	   int i=obj.addSavingAcount(branchId,shareHolderNo,accountNo,requestDate,amount,interest,minBal,minDaysForClose,accCloseCharge,dsaCode,selectedUser.getCenterId());
	   if(i>=1)
	   {
		   FacesContext fc=FacesContext.getCurrentInstance();
		   fc.addMessage(null, new FacesMessage("Saving Account Added Succesfully"));
		   //obj.userDeposit(accountNo,String.valueOf(amount),new Date(), "Cash",null,null,null,"approved");
		   shareHolderNo=accountNo="";
	       requestDate=null;
	       amount=interest=0.0;
	       show=false;
	   }
	   else
	   {
		   FacesContext fc=FacesContext.getCurrentInstance();
		   fc.addMessage(null, new FacesMessage("An Error Occured... Please Try Again")); 
	   }
   }
	
	public double getInterest() {
		return interest;
	}
	public void setInterest(double interest) {
		this.interest = interest;
	}
	public Date getRequestDate() {
		return requestDate;
	}
	public void setRequestDate(Date requestDate) {
		this.requestDate = requestDate;
	}
	public boolean isShow() {
		return show;
	}
	public void setShow(boolean show) {
		this.show = show;
	}
	public String getShareHolderNo() {
		return shareHolderNo;
	}
	public void setShareHolderNo(String shareHolderNo) {
		this.shareHolderNo = shareHolderNo;
	}
	public UserInfo getSelectedUser() {
		return selectedUser;
	}
	public void setSelectedUser(UserInfo selectedUser) {
		this.selectedUser = selectedUser;
	}
	public String getAccountNo() {
		return accountNo;
	}
	public void setAccountNo(String accountNo) {
		this.accountNo = accountNo;
	}
	public double getAmount() {
		return amount;
	}
	public void setAmount(double amount) {
		this.amount = amount;
	}
	public double getMinBal() {
		return minBal;
	}
	public void setMinBal(double minBal) {
		this.minBal = minBal;
	}
	public double getAccCloseCharge() {
		return accCloseCharge;
	}
	public void setAccCloseCharge(double accCloseCharge) {
		this.accCloseCharge = accCloseCharge;
	}
	public int getMinDaysForClose() {
		return minDaysForClose;
	}
	public void setMinDaysForClose(int minDaysForClose) {
		this.minDaysForClose = minDaysForClose;
	}

	public String getDsaCode() {
		return dsaCode;
	}

	public void setDsaCode(String dsaCode) {
		this.dsaCode = dsaCode;
	}

	public boolean isDisDsa() {
		return disDsa;
	}

	public void setDisDsa(boolean disDsa) {
		this.disDsa = disDsa;
	}

	public ArrayList<SelectItem> getDsaList() {
		return dsaList;
	}

	public void setDsaList(ArrayList<SelectItem> dsaList) {
		this.dsaList = dsaList;
	}
}
