package main_package;

import java.io.Serializable;
import java.sql.Connection;
import java.sql.SQLException;
import java.text.SimpleDateFormat;
import java.util.ArrayList;
import java.util.Date;

import javax.faces.application.FacesMessage;
import javax.faces.bean.ManagedBean;
import javax.faces.bean.ViewScoped;
import javax.faces.context.FacesContext;
import javax.servlet.http.HttpSession;

import report_package.DataBaseReportMethods;

@ManagedBean(name="dueAmountForNachTransaction")
@ViewScoped
public class DueAmountForNachTransactionBean implements Serializable
{
	Date searchDate=new Date();
	ArrayList<NachInfo> list;
	int total=0;
	String strSearchDate;
	
	public void searchData()
	{
		HttpSession ss=(HttpSession) FacesContext.getCurrentInstance().getExternalContext().getSession(false);
		int branchId = (int) ss.getAttribute("branchId");
		Connection conn=DataBaseConnection.JAVAConnection();
		
		String nachNo=new DataBaseMethods().checkSMessageApiDetailFromTable("nach_no","", conn);
		if(nachNo!=null && !nachNo.equalsIgnoreCase(""))
		{
			list=new DataBaseReportMethods().dueAmountListForNachTransaction(branchId,searchDate);
			strSearchDate=new SimpleDateFormat("dd/MM/yyyy").format(searchDate);
			total=list.size();
		}
		else
		{
			FacesContext.getCurrentInstance().addMessage(null, new FacesMessage("Please Contact to Administrator for update NACH Re. No. in this Software. !!!"));
		}
		try {
			conn.close();
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
	}

	public Date getSearchDate() {
		return searchDate;
	}

	public void setSearchDate(Date searchDate) {
		this.searchDate = searchDate;
	}

	public ArrayList<NachInfo> getList() {
		return list;
	}

	public void setList(ArrayList<NachInfo> list) {
		this.list = list;
	}

	public int getTotal() {
		return total;
	}

	public void setTotal(int total) {
		this.total = total;
	}

	public String getStrSearchDate() {
		return strSearchDate;
	}

	public void setStrSearchDate(String strSearchDate) {
		this.strSearchDate = strSearchDate;
	}
	
	
}
