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;


@ManagedBean(name="dealers")
@ViewScoped

public class dealerBean implements Serializable {
	
	public String name,mobile,address,email,gst,pan,aadhar,accountNumber,ifscCode,bankCode;;
	ArrayList<dealerInfo> dealerList;
	
	dealerInfo selected;
	
	
	DbYashwant dby = new DbYashwant();
	
	
	public dealerBean()
	{
		viewData();
	}
	
	public void update()
	{
		Connection conn = DataBaseConnection.JAVAConnection();
		int i= dby.editDealer(conn, selected);
		if(i>0)
		{
			FacesContext fc=FacesContext.getCurrentInstance();
			fc.addMessage(null, new FacesMessage("Updated Sucessfully"));
			viewData();
		}
	}
	
	
	public void add()
	{
		Connection conn =DataBaseConnection.JAVAConnection();
		int i= dby.addDealer(conn,name,mobile,address,email,gst,pan,aadhar,accountNumber,ifscCode,bankCode);
		
		if(i>0)
		{
			FacesContext fc=FacesContext.getCurrentInstance();
			fc.addMessage(null, new FacesMessage("Dealer Add Sucessfully"));
			viewData();
			reset();
		}
		
	}
	
	public void delete()
	{
		Connection conn =DataBaseConnection.JAVAConnection();
		int i= dby.deleteDealer(conn, selected);
		
		if(i>0)
		{
			FacesContext fc=FacesContext.getCurrentInstance();
			fc.addMessage(null, new FacesMessage("Deleted Sucessfully"));

			viewData();
		}
	}
	public void viewData()
	{
		Connection conn =DataBaseConnection.JAVAConnection();
		dealerList=dby.selectDealer(conn);
		
	}

	public void reset()
	{
		
		name=mobile=address=email=gst=pan=aadhar="";
		
	}
	
	public String getName() {
		return name;
	}

	public void setName(String name) {
		this.name = name;
	}

	public String getMobile() {
		return mobile;
	}

	public void setMobile(String mobile) {
		this.mobile = mobile;
	}

	public String getAddress() {
		return address;
	}

	public void setAddress(String address) {
		this.address = address;
	}

	public String getEmail() {
		return email;
	}

	public void setEmail(String email) {
		this.email = email;
	}

	public String getGst() {
		return gst;
	}

	public void setGst(String gst) {
		this.gst = gst;
	}

	public String getPan() {
		return pan;
	}

	public void setPan(String pan) {
		this.pan = pan;
	}

	public String getAadhar() {
		return aadhar;
	}

	public void setAadhar(String aadhar) {
		this.aadhar = aadhar;
	}

	public ArrayList<dealerInfo> getDealerList() {
		return dealerList;
	}

	public void setDealerList(ArrayList<dealerInfo> dealerList) {
		this.dealerList = dealerList;
	}


	public dealerInfo getSelected() {
		return selected;
	}


	public void setSelected(dealerInfo selected) {
		this.selected = selected;
	}

	public String getAccountNumber() {
		return accountNumber;
	}

	public void setAccountNumber(String accountNumber) {
		this.accountNumber = accountNumber;
	}

	public String getIfscCode() {
		return ifscCode;
	}

	public void setIfscCode(String ifscCode) {
		this.ifscCode = ifscCode;
	}

	public String getBankCode() {
		return bankCode;
	}

	public void setBankCode(String bankCode) {
		this.bankCode = bankCode;
	}
	
	

}
