package main_package;

import java.io.Serializable;
import java.sql.Connection;
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.faces.model.SelectItem;
import javax.servlet.http.HttpSession;
@ManagedBean(name="addDsaCommision")
@ViewScoped

public class AddDsaCommisionBean implements Serializable {

	ArrayList<SelectItem> dsaList;
	Date creditDate=new Date();
	double amount,totalAmount=0;
	String type,userNo="all",emiNo="all",dsaCode;
	ArrayList<DsaListInfo> dslist=new ArrayList<>();
	DataBaseMethods obj=new DataBaseMethods();
	DsaListInfo selectedType;
	int branchId;
	public AddDsaCommisionBean ()
	{
		HttpSession ss=(HttpSession) FacesContext.getCurrentInstance().getExternalContext().getSession(false);
		branchId = (int) ss.getAttribute("branchId");
		Connection conn=DataBaseConnection.JAVAConnection();
		dsaList=obj.allDsaList(branchId,"",conn);
		dslist=obj.dsaCommisionList(branchId,conn);
		for(DsaListInfo tt :dslist)
		{
			totalAmount +=tt.getAmount();
		}
		try {
			conn.close();
		} catch (Exception e) {
			// TODO: handle exception
		}
	}


	
	public String dsaCommision() 
	{
		totalAmount=0;
	Connection conn=DataBaseConnection.JAVAConnection();
	String aa=obj.addDsaCommision(branchId,conn,type,userNo,emiNo,creditDate,amount,dsaCode);
	if(aa.equals("i"))
	{
		FacesContext.getCurrentInstance().addMessage(null, new FacesMessage("add Successfully"));
		dslist=obj.dsaCommisionList(branchId,conn);
		for(DsaListInfo tt :dslist)
		{
			totalAmount +=tt.getAmount();
		}
		type="";
		amount=0;
		dsaCode="";
		creditDate=null;
		
	}
	else
	{
		FacesContext.getCurrentInstance().addMessage(null, new FacesMessage("Some Error Occured !!"));
	}
	try {
		conn.close();
	} catch (Exception e) {
		// TODO: handle exception
	}
		return "";
	}
	
	
	
	
	
	public void delete()
	{
		HttpSession ss=(HttpSession) FacesContext.getCurrentInstance().getExternalContext().getSession(false);
		int branchId = (int) ss.getAttribute("branchId");
		totalAmount=0;
		Connection conn=DataBaseConnection.JAVAConnection();
		int i=new DataBaseMethods().deleteFromDsaCommissionTableById(selectedType.getId());
		if(i>0)
		{
			FacesContext.getCurrentInstance().addMessage(null, new FacesMessage("Delete Sucessfully."));
			dslist=obj.dsaCommisionList(branchId,conn);
			for(DsaListInfo tt :dslist)
			{
				totalAmount +=tt.getAmount();
			}
			
			
		}
		else
		{
			FacesContext.getCurrentInstance().addMessage(null, new FacesMessage("Some Error Occured!!!"));
		}
	}
	

	
	public ArrayList<SelectItem> getDsaList() {
		return dsaList;
	}


	public void setDsaList(ArrayList<SelectItem> dsaList) {
		this.dsaList = dsaList;
	}


	public Date getCreditDate() {
		return creditDate;
	}


	public void setCreditDate(Date creditDate) {
		this.creditDate = creditDate;
	}


	public double getAmount() {
		return amount;
	}


	public void setAmount(double amount) {
		this.amount = amount;
	}


	public String getType() {
		return type;
	}


	public void setType(String type) {
		this.type = type;
	}


	public String getUserNo() {
		return userNo;
	}


	public void setUserNo(String userNo) {
		this.userNo = userNo;
	}


	public String getEmiNo() {
		return emiNo;
	}


	public void setEmiNo(String emiNo) {
		this.emiNo = emiNo;
	}



	public String getDsaCode() {
		return dsaCode;
	}



	public void setDsaCode(String dsaCode) {
		this.dsaCode = dsaCode;
	}



	public ArrayList<DsaListInfo> getDslist() {
		return dslist;
	}



	public void setDslist(ArrayList<DsaListInfo> dslist) {
		this.dslist = dslist;
	}



	public DataBaseMethods getObj() {
		return obj;
	}



	public void setObj(DataBaseMethods obj) {
		this.obj = obj;
	}



	public DsaListInfo getSelectedType() {
		return selectedType;
	}



	public void setSelectedType(DsaListInfo selectedType) {
		this.selectedType = selectedType;
	}



	public double getTotalAmount() {
		return totalAmount;
	}



	public void setTotalAmount(double totalAmount) {
		this.totalAmount = totalAmount;
	}
}
