package main_package;

import java.io.IOException;
import java.io.Serializable;
import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.util.ArrayList;

import javax.faces.application.FacesMessage;
import javax.faces.bean.ManagedBean;
import javax.faces.bean.ViewScoped;
import javax.faces.context.FacesContext;

@ManagedBean(name="basicSetupDashboard")
@ViewScoped

public class BasicSetupDashBean implements Serializable 
{
	
	String branchName,branchCode,address1,address2,address3,address4,mobile,userName,password;
	DataBaseMethods dbObj= new DataBaseMethods();
	DataBaseMethodRahul dbr= new DataBaseMethodRahul();
	ArrayList<LastBranchDetailsListInfo> lastBranchDetials ;
	
	public BasicSetupDashBean() 
	{   
		LastBranchCode();
		lastBranchArraylist();
	}
		
	
	public void lastBranchArraylist()
	{	
		lastBranchDetials = new ArrayList<>();
		
		try(Connection conn = DataBaseConnection.JAVAConnection()){
		 
			String query = " select * from firm_detail where id = ?";
            
			try(PreparedStatement ps = conn.prepareStatement(query) ){
				
				ps.setInt(1, 2);
				
				ResultSet rs = ps.executeQuery();
			
				if(rs.next()) {
					
		    	LastBranchDetailsListInfo ll = new LastBranchDetailsListInfo();
				
		    	ll.setId(rs.getString("id"));
		    	ll.setAddress1(rs.getString("address1"));
		    	System.out.println("lll :"+rs.getString("address1"));
		    	ll.setAddress2(rs.getString("address2"));
		    	ll.setAddress3(rs.getString("address3"));
		    	ll.setAddress4(rs.getString("address4"));
		    	ll.setName(rs.getString("name"));
		    	ll.setLogo(rs.getString("logo"));
		    	ll.setFile_upload_path(rs.getString("file_upload_path"));
		    	ll.setFile_view_path(rs.getString("file_view_path"));
		    	ll.setMobile_no(rs.getString("mobile_no"));
		    	ll.setMember_age_limit(rs.getString("member_age_limit"));
		    	ll.setDealer_percent(rs.getString("dealer_percent"));
		    	ll.setSoftware_validity(rs.getString("software_validity"));
		    	System.out.println("software validity :"+rs.getString("software_validity"));
		    	ll.setSent_by(rs.getString("sent_by"));
		    	ll.setBranch_code(rs.getString("branch_code"));
		    	ll.setBranch_name(rs.getString("branch_name"));
		    	ll.setBranch_start(rs.getString("branch_start"));
		    	ll.setScheme_start(rs.getString("scheme_start"));

			     lastBranchDetials.add(ll);
				
				}
				
				
			}catch(Exception e){
				
				e.printStackTrace();
				
			}
			
		}catch(Exception e){
			
			e.printStackTrace();
			
		}
		
	}
	
	public void LastBranchCode() {
		
		int nextBranch=0;
		
		try(Connection conn = DataBaseConnection.JAVAConnection()){
     
			
			String query = "SELECT branch_code FROM firm_detail ORDER BY branch_code DESC LIMIT 1;";

			try(PreparedStatement ps = conn.prepareStatement(query)){
				
				ResultSet rs = ps.executeQuery();
				
				while(rs.next()) {
					
					nextBranch = rs.getInt("branch_code");
					nextBranch = nextBranch+1;
					branchCode = String.valueOf(nextBranch);
				}
				
				
			}catch(Exception  e) {
				
				e.printStackTrace();
				
			}
			
			
		}catch(Exception e ) {
			
			e.printStackTrace();
			
		}
		
	}
	
	public void submitBranch() throws IOException
	{ 
		
		branchCode=branchCode.toUpperCase();
		if(branchCode.contains("S") || branchCode.contains("R"))
		{
			FacesContext.getCurrentInstance().addMessage(null, new FacesMessage("Branch Code can not contain R & S"));
		}
		else
		{   			
			//if(branchCode.length()==3)
			{
				
				Connection con = DataBaseConnection.JAVAConnection();
				boolean checkBranch = dbObj.checkBranchCodeName(branchCode,branchName,con);
				
				if(checkBranch == true)
				{   
					FacesContext.getCurrentInstance().addMessage(null, new FacesMessage("Branch Code or Branch Name is already exist..."));
				}
				else
				{
					String r = dbr.insertFirmDetails(lastBranchDetials,mobile, address1, address2, address3, address4, branchCode, branchName,userName,password, con);
					
					if(r.equals("1"))
					{
						branchCode=branchName=address1=address2=address3=address4="";
						FacesContext.getCurrentInstance().addMessage(null, new FacesMessage("Branch Added Successfully"));
						
					}
					else
					{
						//FacesContext.getCurrentInstance().addMessage(null, new FacesMessage("Error occured try again..."));
					}
				}
				try {
					con.close();
				} catch (Exception e) {
					// TODO: handle exception
				}
			}
			/*else
			{
				FacesContext.getCurrentInstance().addMessage(null, new FacesMessage("Branch Code must have 3 character"));
			}*/
		}
		
		
	}

	public String getBranchName() {
		return branchName;
	}

	public void setBranchName(String branchName) {
		this.branchName = branchName;
	}

	public String getBranchCode() {
		return branchCode;
	}

	public void setBranchCode(String branchCode) {
		this.branchCode = branchCode;
	}

	public String getAddress1() {
		return address1;
	}

	public void setAddress1(String address1) {
		this.address1 = address1;
	}

	public String getAddress2() {
		return address2;
	}

	public void setAddress2(String address2) {
		this.address2 = address2;
	}

	public String getAddress3() {
		return address3;
	}

	public void setAddress3(String address3) {
		this.address3 = address3;
	}

	public String getAddress4() {
		return address4;
	}

	public void setAddress4(String address4) {
		this.address4 = address4;
	}

	public String getMobile() {
		return mobile;
	}

	public void setMobile(String mobile) {
		this.mobile = mobile;
	}


	public String getUserName() {
		return userName;
	}


	public void setUserName(String userName) {
		this.userName = userName;
	}


	public String getPassword() {
		return password;
	}


	public void setPassword(String password) {
		this.password = password;
	}
	
	
	
}
