package hrm_package;

import java.io.Serializable;
import java.sql.Connection;
import java.sql.SQLException;
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 main_package.DataBaseConnection;
import main_package.DataBaseMethods;
import main_package.DataBaseMethodsSalary;
import main_package.EmpInfo;

@ManagedBean(name="hrmBasic")
@ViewScoped
public class HrmBasicBean implements Serializable
{
	String groupName, name;
	DataBaseMethodsSalary dbms=new DataBaseMethodsSalary();
	ArrayList<EmpInfo> list;
	EmpInfo selectedRow;
	
	public HrmBasicBean() 
	{
		list=dbms.viewHrmBasicData();
	}

	public void addData()
	{
		Connection conn=DataBaseConnection.JAVAConnection();
		boolean check=dbms.checkHrmBasicDuplicacy(groupName, name.trim(), conn);
		if(check==false)
		{
			int i=dbms.addHrmBasicData(groupName, name.trim(), conn);
			if(i>0)
			{
				FacesContext.getCurrentInstance().addMessage(null, new FacesMessage(name+" "+groupName+" Add Sucessfully."));
				name="";
				list=dbms.viewHrmBasicData();
			}
			else
			{
				FacesContext.getCurrentInstance().addMessage(null, new FacesMessage("Error Occured!!!") );
			}
		}
		else
		{
			FacesContext.getCurrentInstance().addMessage(null, new FacesMessage(name+" Name Already Exist in "+groupName+" Group."));
		}
		
		try {
			conn.close();
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
	}

	public void deleteData()
	{
		Connection conn=DataBaseConnection.JAVAConnection();
		int k=dbms.deleteHrmBasicData(selectedRow.getId(), conn);
		if(k>0)
		{
			FacesContext.getCurrentInstance().addMessage(null, new FacesMessage(selectedRow.getName()+" Delete Sucessfully.") );
			list=dbms.viewHrmBasicData();
		}
		else
		{
			FacesContext.getCurrentInstance().addMessage(null, new FacesMessage("Error Occured!!!") );
		}
		try {
			conn.close();
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
	}
	

	public String getName() {
		return name;
	}

	public void setName(String name) {
		this.name = name;
	}

	public ArrayList<EmpInfo> getList() {
		return list;
	}

	public void setList(ArrayList<EmpInfo> list) {
		this.list = list;
	}

	public String getGroupName() {
		return groupName;
	}

	public void setGroupName(String groupName) {
		this.groupName = groupName;
	}

	public EmpInfo getSelectedRow() {
		return selectedRow;
	}

	public void setSelectedRow(EmpInfo selectedRow) {
		this.selectedRow = selectedRow;
	}
	
	
}
