package main_package;

import java.io.Serializable;
import java.sql.Connection;
import java.sql.SQLException;
import java.util.ArrayList;
import java.util.Date;
import java.util.List;

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="addEmp")
@ViewScoped

public class AddEmployeeBean implements Serializable 
{
	
	private static final long serialVersionUID = 1L;
	String companyName, name, fname, address, mobile, center="0", uname, pwd,strPwd, paddress, altContactNo, nickName, emailId, gender, code;
	String maritalStatus, bloodGroup, category, religion, department, designation, pinCode, city, pfAcc, uan ,esic;
	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;
	DataBaseMethods obj=new DataBaseMethods();
	DataBaseMethodsSalary dbms=new DataBaseMethodsSalary();
    List<SelectItem> branchList = new ArrayList<SelectItem>();
    int branchId, backDays;
    String lableEmpCode;
    
    boolean cibilCheck;
	DbYashwant dby =new DbYashwant();
	
	public AddEmployeeBean() 
	{
		
		HttpSession ss=(HttpSession) FacesContext.getCurrentInstance().getExternalContext().getSession(true);
	    String branchUserId=(String) ss.getAttribute("branchUserId");
		
		doj=new Date();
		Connection conn =DataBaseConnection.JAVAConnection();
		uname=pwd="";

		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);
		branchList = new DataBaseMethods().branchList(branchUserId, conn);
		try {
			conn.close();
		} catch (Exception e) {
			// TODO: handle exception
		}

	}
	
	public void findDsaCode()
	{
		HttpSession ss=(HttpSession) FacesContext.getCurrentInstance().getExternalContext().getSession(true);
		companyName=(String) ss.getAttribute("companyName");
//    	System.out.println("Company Name :"+companyName);
		
		Connection conn =DataBaseConnection.JAVAConnection();
		code= obj.dsaAccountNo(branchId,conn);  //DSA Code is Merge in Employee 05 Jan 2019 by Mr. Chetan Garg
		
		lableEmpCode = dby.manageEmployeeId(code);
		
	
		
		
//        System.out.println("ccc :"+code);
        
//        if(companyName.equalsIgnoreCase("FINAZONE MICRO SERVICES FOUNDATION")) {
//        	
//        	String in = code;
//        	code = in.replaceFirst("^EMP", "FMSF"); // "FMSF-101000066"
//       
//        	
//        	
//        }

   }
	
	
	
	
	public void checkDsaCode() throws SQLException
	{
		Connection conn =DataBaseConnection.JAVAConnection();
		int i=dby.checkDsaCodeDulicate(code, conn);
		
		System.out.println("ii"+i);
		
		if(i==1)
		{
			findDsaCode();
			FacesContext.getCurrentInstance().addMessage(null, new FacesMessage("DSA Code Already exist"));

		}
		
		
	}
	
	public void addEmployee()
	{
		Connection conn =DataBaseConnection.JAVAConnection();
		boolean check=new DataBaseMethodsDuplicate().checkLoginDuplicacy(uname,conn);
		if(check==false)
		{
			int i=obj.registerEmployee(name, fname, dob, doj, address, mobile, center, uname, pwd, 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, code,branchId,backDays,bankName, bankAccountNo, bankBranch, bankIfsc, pfAcc,uan,cibilCheck,esic);
			if(i>=1)
			{
				FacesContext.getCurrentInstance().addMessage(null, new FacesMessage("Employee Registered!"));
				obj.insertEmployeeInLogin(uname,pwd,"employee",mobile,branchId,conn);
				obj.adddsa(branchId,code,name.toUpperCase(),address,mobile,"",0,"",conn);
				name=fname=address=mobile=center=uname=pwd=strPwd=paddress=altContactNo="";
				nickName= emailId=rationCard= tenth= twelveth= graduation= other=
				gender= maritalStatus= bloodGroup= category= religion= department= designation= pinCode= city= panCard= dlNo= aadharCard= voterId=passport="";
				anniversaryDate=new Date();
				doj=new Date();
				leave=0;
				salary=0;
				dob=null;
				
				try {
					conn.close();
				} catch (Exception e) {
					// TODO: handle exception
				}
			}
			else
			{
				FacesContext.getCurrentInstance().addMessage(null, new FacesMessage("Error occur.Please check!"));
			}
		}
		else
		{
			FacesContext.getCurrentInstance().addMessage(null, new FacesMessage("Username : "+uname+" ,already exist please "
																				+ "try something different! "));
		}
	}

	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 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 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 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 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 getAnniversaryDate() {
		return anniversaryDate;
	}

	public void setAnniversaryDate(Date anniversaryDate) {
		this.anniversaryDate = anniversaryDate;
	}

	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 DataBaseMethods getObj() {
		return obj;
	}

	public void setObj(DataBaseMethods obj) {
		this.obj = obj;
	}

	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 List<SelectItem> getBranchList() {
		return branchList;
	}

	public void setBranchList(List<SelectItem> branchList) {
		this.branchList = branchList;
	}

	public int getBranchId() {
		return branchId;
	}

	public void setBranchId(int branchId) {
		this.branchId = branchId;
	}

	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;
	}

	public String getCode() {
		return code;
	}

	public void setCode(String code) {
		this.code = code;
	}

	public String getEsic() {
		return esic;
	}

	public void setEsic(String esic) {
		this.esic = esic;
	}

	public String getCompanyName() {
		return companyName;
	}

	public void setCompanyName(String companyName) {
		this.companyName = companyName;
	}

	public String getLableEmpCode() {
		return lableEmpCode;
	}

	public void setLableEmpCode(String lableEmpCode) {
		this.lableEmpCode = lableEmpCode;
	}


	
}
