package hrm_package;

import java.io.Serializable;
import java.sql.Connection;
import java.sql.SQLException;
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;

import org.primefaces.context.RequestContext;

import main_package.DataBaseConnection;
import main_package.DataBaseMethods;
import main_package.DataBaseMethodsSalary;
import main_package.EmpInfo;

@ViewScoped
@ManagedBean(name="editEmployee")
public class EditEmployeeBean implements Serializable
{
	String id, name, fname, address, mobile, center="0", uname, pwd,strPwd, paddress, altContactNo, nickName, emailId, gender;
	String maritalStatus, bloodGroup, category, religion, department, designation, pinCode, city, pfAcc, uan;
	String panCard, dlNo, aadharCard, voterId, passport, rationCard, tenth, twelveth, graduation, other, bankName, bankAccountNo, bankBranch, bankIfsc;
	ArrayList<SelectItem> maritalStatusList, bloodGroupList, categoryList, religionList, departmentList, designationList;
	Date  dob, doj, anniversaryDate;
	double leave, salary;
	EmpInfo selected;
	int backDays;
	boolean cibilCheck;
	
	DataBaseMethods obj=new DataBaseMethods();
	DataBaseMethodsSalary dbms=new DataBaseMethodsSalary();
	
	public EditEmployeeBean() 
	{
		HttpSession ss=(HttpSession) FacesContext.getCurrentInstance().getExternalContext().getSession(false);
		selected=(EmpInfo) ss.getAttribute("selectedRow");
		
		
		Connection conn =DataBaseConnection.JAVAConnection();

		maritalStatusList=dbms.hrmBasicList("Marital Status", conn);
		departmentList=dbms.hrmBasicList("Department", conn);
		designationList=dbms.hrmBasicList("Designation", conn);
		bloodGroupList=dbms.hrmBasicList("Blood Group", conn);
		religionList=dbms.hrmBasicList("Religion", conn);
		categoryList=dbms.hrmBasicList("Category", conn);
		
		name=selected.getName();
		nickName=selected.getNickName();
		fname=selected.getFname();
		emailId=selected.getEmailId();
		dob=selected.getDob();
		doj=selected.getDoj();
		anniversaryDate=selected.getAnniversaryDate();
		gender=selected.getGender();
		department=selected.getDepartmentId();
		designation=selected.getDesignationId();
		bloodGroup=selected.getBloodGroupId();
		religion=selected.getReligionId();
		category=selected.getCategoryId();
		maritalStatus=selected.getMaritalStatusId();
		city=selected.getCity();
		pinCode=selected.getPinCode();
		address=selected.getAddress();
		paddress=selected.getpAddress();
		mobile=selected.getMobile();
		altContactNo=selected.getAltContactNo();
		panCard=selected.getPanCard();
		dlNo=selected.getDlNo();
		aadharCard=selected.getAadharCard();
		voterId=selected.getVoterId();
		passport=selected.getPassport();
		rationCard=selected.getRationCard();
		tenth=selected.getTenth();
		twelveth=selected.getTwelveth();
		graduation=selected.getGraduation();
		other=selected.getOther();
		anniversaryDate=selected.getAnniversaryDate();
		salary=selected.getSalary();
		leave=selected.getLeaves();
		
		backDays=selected.getBackDays();
		bankName=selected.getBankName();
		bankAccountNo=selected.getBankAccountNo();
		bankBranch=selected.getBankBranch();
		bankIfsc=selected.getBankIfsc();
		pfAcc=selected.getPfAcc();
		uan=selected.getUan();
		cibilCheck=selected.isCibilCheck();
		
		try {
			conn.close();
		} catch (Exception e) {
			// TODO: handle exception
		}

	}
	
	
	public String update()
	{
		int i=obj.updateEmployee(name, fname, dob, doj, address, mobile, center,selected.getId(),leave,salary, paddress, altContactNo, nickName, emailId, gender, maritalStatus, 
				bloodGroup, category, religion, department, designation, pinCode, city, panCard, dlNo, aadharCard, voterId, passport, rationCard, tenth, twelveth,
				graduation, other, anniversaryDate,backDays,bankName,bankAccountNo,bankBranch,bankIfsc,pfAcc,uan,cibilCheck);
		if(i>=1)
		{
			obj.updateDsa(selected.getDsaCode(), name, mobile, address,"",0);
			if(!mobile.equalsIgnoreCase(selected.getMobile()))
			{
				Connection conn=DataBaseConnection.JAVAConnection();
				obj.updateContactInLoginTable(selected.getUname(),mobile,conn);
				
				try {
					conn.close();
				} catch (SQLException e) {
					// TODO Auto-generated catch block
					e.printStackTrace();
				}
			}
			FacesContext.getCurrentInstance().addMessage(null, new FacesMessage("Employee Details Updated Successfully!"));
			
			return "manageEmployee.xhtml";
		}
		else
		{
			FacesContext.getCurrentInstance().addMessage(null, new FacesMessage("Error Occur.Please Check!"));
			return "";
		}
	}


	public String getId() {
		return id;
	}


	public void setId(String id) {
		this.id = id;
	}


	public String getName() {
		return name;
	}


	public void setName(String name) {
		this.name = name;
	}


	public String getFname() {
		return fname;
	}


	public void setFname(String fname) {
		this.fname = fname;
	}


	public String getAddress() {
		return address;
	}


	public void setAddress(String address) {
		this.address = address;
	}


	public String getMobile() {
		return mobile;
	}


	public void setMobile(String mobile) {
		this.mobile = mobile;
	}


	public String getCenter() {
		return center;
	}


	public void setCenter(String center) {
		this.center = center;
	}


	public String getUname() {
		return uname;
	}


	public void setUname(String uname) {
		this.uname = uname;
	}


	public String getPwd() {
		return pwd;
	}


	public void setPwd(String pwd) {
		this.pwd = pwd;
	}


	public String getStrPwd() {
		return strPwd;
	}


	public void setStrPwd(String strPwd) {
		this.strPwd = strPwd;
	}


	public String getPaddress() {
		return paddress;
	}


	public void setPaddress(String paddress) {
		this.paddress = paddress;
	}


	public String getAltContactNo() {
		return altContactNo;
	}


	public void setAltContactNo(String altContactNo) {
		this.altContactNo = altContactNo;
	}


	public String getNickName() {
		return nickName;
	}


	public void setNickName(String nickName) {
		this.nickName = nickName;
	}


	public String getEmailId() {
		return emailId;
	}


	public void setEmailId(String emailId) {
		this.emailId = emailId;
	}


	public String getGender() {
		return gender;
	}


	public void setGender(String gender) {
		this.gender = gender;
	}


	public String getMaritalStatus() {
		return maritalStatus;
	}


	public void setMaritalStatus(String maritalStatus) {
		this.maritalStatus = maritalStatus;
	}


	public String getBloodGroup() {
		return bloodGroup;
	}


	public void setBloodGroup(String bloodGroup) {
		this.bloodGroup = bloodGroup;
	}


	public String getCategory() {
		return category;
	}


	public void setCategory(String category) {
		this.category = category;
	}


	public String getReligion() {
		return religion;
	}


	public void setReligion(String religion) {
		this.religion = religion;
	}


	public String getDepartment() {
		return department;
	}


	public void setDepartment(String department) {
		this.department = department;
	}


	public String getDesignation() {
		return designation;
	}


	public void setDesignation(String designation) {
		this.designation = designation;
	}


	public String getPinCode() {
		return pinCode;
	}


	public void setPinCode(String pinCode) {
		this.pinCode = pinCode;
	}


	public String getCity() {
		return city;
	}


	public void setCity(String city) {
		this.city = city;
	}


	public String getPanCard() {
		return panCard;
	}


	public void setPanCard(String panCard) {
		this.panCard = panCard;
	}


	public String getDlNo() {
		return dlNo;
	}


	public void setDlNo(String dlNo) {
		this.dlNo = dlNo;
	}


	public String getAadharCard() {
		return aadharCard;
	}


	public void setAadharCard(String aadharCard) {
		this.aadharCard = aadharCard;
	}


	public String getVoterId() {
		return voterId;
	}


	public void setVoterId(String voterId) {
		this.voterId = voterId;
	}


	public String getPassport() {
		return passport;
	}


	public void setPassport(String passport) {
		this.passport = passport;
	}


	public String getRationCard() {
		return rationCard;
	}


	public void setRationCard(String rationCard) {
		this.rationCard = rationCard;
	}


	public String getTenth() {
		return tenth;
	}


	public void setTenth(String tenth) {
		this.tenth = tenth;
	}


	public String getTwelveth() {
		return twelveth;
	}


	public void setTwelveth(String twelveth) {
		this.twelveth = twelveth;
	}


	public String getGraduation() {
		return graduation;
	}


	public void setGraduation(String graduation) {
		this.graduation = graduation;
	}


	public String getOther() {
		return other;
	}


	public void setOther(String other) {
		this.other = other;
	}


	public ArrayList<SelectItem> getMaritalStatusList() {
		return maritalStatusList;
	}


	public void setMaritalStatusList(ArrayList<SelectItem> maritalStatusList) {
		this.maritalStatusList = maritalStatusList;
	}


	public ArrayList<SelectItem> getBloodGroupList() {
		return bloodGroupList;
	}


	public void setBloodGroupList(ArrayList<SelectItem> bloodGroupList) {
		this.bloodGroupList = bloodGroupList;
	}


	public ArrayList<SelectItem> getCategoryList() {
		return categoryList;
	}


	public void setCategoryList(ArrayList<SelectItem> categoryList) {
		this.categoryList = categoryList;
	}


	public ArrayList<SelectItem> getReligionList() {
		return religionList;
	}


	public void setReligionList(ArrayList<SelectItem> religionList) {
		this.religionList = religionList;
	}


	public ArrayList<SelectItem> getDepartmentList() {
		return departmentList;
	}


	public void setDepartmentList(ArrayList<SelectItem> departmentList) {
		this.departmentList = departmentList;
	}


	public ArrayList<SelectItem> getDesignationList() {
		return designationList;
	}


	public void setDesignationList(ArrayList<SelectItem> designationList) {
		this.designationList = designationList;
	}


	public Date getDob() {
		return dob;
	}


	public void setDob(Date dob) {
		this.dob = dob;
	}


	public Date getDoj() {
		return doj;
	}


	public void setDoj(Date doj) {
		this.doj = doj;
	}


	public Date getAnniversaryDate() {
		return anniversaryDate;
	}


	public void setAnniversaryDate(Date anniversaryDate) {
		this.anniversaryDate = anniversaryDate;
	}


	public double getLeave() {
		return leave;
	}


	public void setLeave(double leave) {
		this.leave = leave;
	}


	public double getSalary() {
		return salary;
	}


	public void setSalary(double salary) {
		this.salary = salary;
	}


	public EmpInfo getSelected() {
		return selected;
	}


	public void setSelected(EmpInfo selected) {
		this.selected = selected;
	}


	public DataBaseMethods getObj() {
		return obj;
	}


	public void setObj(DataBaseMethods obj) {
		this.obj = obj;
	}


	public DataBaseMethodsSalary getDbms() {
		return dbms;
	}


	public void setDbms(DataBaseMethodsSalary dbms) {
		this.dbms = dbms;
	}


	public String getPfAcc() {
		return pfAcc;
	}


	public void setPfAcc(String pfAcc) {
		this.pfAcc = pfAcc;
	}


	public String getUan() {
		return uan;
	}


	public void setUan(String uan) {
		this.uan = uan;
	}


	public String getBankName() {
		return bankName;
	}


	public void setBankName(String bankName) {
		this.bankName = bankName;
	}


	public String getBankAccountNo() {
		return bankAccountNo;
	}


	public void setBankAccountNo(String bankAccountNo) {
		this.bankAccountNo = bankAccountNo;
	}


	public String getBankBranch() {
		return bankBranch;
	}


	public void setBankBranch(String bankBranch) {
		this.bankBranch = bankBranch;
	}


	public String getBankIfsc() {
		return bankIfsc;
	}


	public void setBankIfsc(String bankIfsc) {
		this.bankIfsc = bankIfsc;
	}


	public int getBackDays() {
		return backDays;
	}


	public void setBackDays(int backDays) {
		this.backDays = backDays;
	}


	public boolean isCibilCheck() {
		return cibilCheck;
	}


	public void setCibilCheck(boolean cibilCheck) {
		this.cibilCheck = cibilCheck;
	}
	
}
