package main_package;

import java.io.Serializable;
import java.sql.Connection;
import java.util.ArrayList;

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="category")
@ViewScoped

public class categoryBean implements Serializable{

	private static final long serialVersionUID = 1L;

	String categoryName,securityType;
	
	categoryInfo selected;
	int branchId;
	
	ArrayList<categoryInfo>categoryList;
	ArrayList<SelectItem> securityTypelist;
	
	DataBaseMethodsRaviK dbrk = new DataBaseMethodsRaviK();
	DataBaseMethods db = new DataBaseMethods();
	
	public categoryBean() {
		    Connection conn = DataBaseConnection.JAVAConnection();
			HttpSession ss = (HttpSession) FacesContext.getCurrentInstance().getExternalContext().getSession(true);
			branchId = (int) ss.getAttribute("branchId");
			selectData();
			securityTypelist = dbrk.secureLoanTypeListr(branchId,conn);
		
		
	}
		
	public void add() 
		{
			Connection conn = DataBaseConnection.JAVAConnection();
			 int i = dbrk.addCategory(conn,categoryName,securityType);
			 
			 if(i>0)
			 {
				 reset();
				 FacesContext fc=FacesContext.getCurrentInstance();
					fc.addMessage(null, new FacesMessage("Category Add Sucessfully"));
			 }
			 selectData();
		
	}
	
	public void selectData()
	{	
		Connection conn = DataBaseConnection.JAVAConnection();
		categoryList=dbrk.selectCategory(conn);
	}
	
	public void update()
	{
		Connection conn =DataBaseConnection.JAVAConnection();
		
		int i = dbrk.editCategory(conn, selected);
		if(i>0)
		{
			 selectData();
			 FacesContext fc=FacesContext.getCurrentInstance();
				fc.addMessage(null, new FacesMessage("Updated Sucessfully"));
		 }
		
	}
	
	public void delete()
	{
		Connection conn =DataBaseConnection.JAVAConnection();
		int i=dbrk.deleteCategory(conn, selected);
		
		if(i>0)
		{
			 FacesContext fc=FacesContext.getCurrentInstance();
				fc.addMessage(null, new FacesMessage("Product Deleted Sucessfully"));
				selectData();
		}
		
	}
	
	
	public void reset()
	{
		categoryName=securityType="";
	}
	
	
	
	
	
	
	//GETTERS AND SETTERS
	
	public String getCategoryName() {
		return categoryName;
	}


	public void setCategoryName(String categoryName) {
		this.categoryName = categoryName;
	}


	public String getSecurityType() {
		return securityType;
	}


	public void setSecurityType(String securityType) {
		this.securityType = securityType;
	}

	public categoryInfo getSelected() {
		return selected;
	}

	public void setSelected(categoryInfo selected) {
		this.selected = selected;
	}

	public ArrayList<categoryInfo> getCategoryList() {
		return categoryList;
	}

	public void setCategoryList(ArrayList<categoryInfo> categoryList) {
		this.categoryList = categoryList;
	}

	public int getBranchId() {
		return branchId;
	}

	public void setBranchId(int branchId) {
		this.branchId = branchId;
	}

	public ArrayList<SelectItem> getSecurityTypelist() {
		return securityTypelist;
	}

	public void setSecurityTypelist(ArrayList<SelectItem> securityTypelist) {
		this.securityTypelist = securityTypelist;
	}



}
