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.servlet.http.HttpSession;

@ManagedBean(name = "manageCityName")
@ViewScoped
public class ManageCityNameBean implements Serializable
{
	String cityName;
	public ArrayList<BankInfo> viewCityName;
	boolean showdetail;
    DataBaseMethods obj=new DataBaseMethods();
    
	public ManageCityNameBean() 
	{
		HttpSession ss=(HttpSession) FacesContext.getCurrentInstance().getExternalContext().getSession(false);
		int branchId =(int) ss.getAttribute("branchId");
		Connection conn=DataBaseConnection.JAVAConnection();
		viewCityName = obj.cityNameViewList(branchId,conn);
		try {
			conn.close();
		} catch (Exception e) {
			// TODO: handle exception
		}

	}

	public void cityName() 
	{
		HttpSession ss=(HttpSession) FacesContext.getCurrentInstance().getExternalContext().getSession(false);
		int branchId =(int) ss.getAttribute("branchId");
		Connection conn=DataBaseConnection.JAVAConnection();
		int i=obj.addCityName(cityName.toUpperCase(),branchId,conn);
		if(i>0)
		{
			FacesContext.getCurrentInstance().addMessage(null, new FacesMessage("City Name Add Sucessfully."));
			viewCityName = obj.cityNameViewList(branchId,conn);
			cityName="";
		}
		else
		{
			FacesContext.getCurrentInstance().addMessage(null, new FacesMessage("Error Occured!!!"));
		}


		try {
			conn.close();
		} catch (Exception e) {
			// TODO: handle exception
		}

	}

	public String getcityName() {
		return cityName;
	}

	public void setcityName(String cityName) {
		this.cityName = cityName;
	}

	public ArrayList<BankInfo> getviewCityName() {
		return viewCityName;
	}

	public void setviewCityName(ArrayList<BankInfo> viewCityName) {
		this.viewCityName = viewCityName;
	}

	public boolean isShowdetail() {
		return showdetail;
	}

	public void setShowdetail(boolean showdetail) {
		this.showdetail = showdetail;
	}

	
}
