import java.rmi.*;
import java.rmi.server.*;
import java.io.*;
import java.sql.*;
import java.awt.*;
import javax.swing.*;
import java.awt.event.*;
import javax.swing.event.*;
import Biometrics.CFingerPrint;
import Biometrics.CFingerPrintGraphics;
import java.awt.image.*;
import javax.imageio.*;
import java.io.File;
import java.lang.Exception ;
import java.awt.Color;
import java.awt.event.*;

//===============================================================================

public class MyServer extends UnicastRemoteObject implements MyInterface
{

	  	
	  private CFingerPrint m_finger1 = new CFingerPrint();
	  private CFingerPrint m_finger2 = new CFingerPrint();

	  private CFingerPrintGraphics m_fingergfx = new CFingerPrintGraphics();

	  private BJPanel m_panel1 = new BJPanel();
 	  private BJPanel m_panel2 = new BJPanel();

	  private BufferedImage m_bimage1 = new BufferedImage(m_finger1.FP_IMAGE_WIDTH ,m_finger1.FP_IMAGE_HEIGHT,BufferedImage.TYPE_INT_RGB );
	  private BufferedImage m_bimage2 = new BufferedImage(m_finger2.FP_IMAGE_WIDTH ,m_finger2.FP_IMAGE_HEIGHT,BufferedImage.TYPE_INT_RGB );

	  private double finger1[] = new double[m_finger1.FP_TEMPLATE_MAX_SIZE];
 	  private double finger2[] = new double[m_finger2.FP_TEMPLATE_MAX_SIZE];

 	Container cp;
	
	//====================================================================
	  
	public MyServer() throws RemoteException
	{
	   System.out.println("SERVER STARTED....");
	}

	//========================================================================


	public String getacno() throws RemoteException
	{

 	  int acno=0, pin = 0;
	  String result ="";

	  try
	   {		

		Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
		Connection con = DriverManager.getConnection("Jdbc:Odbc:bankodbc");
		Statement stmt = con.createStatement();
		ResultSet rs= stmt.executeQuery("select max(Acc_no) as acno from Single_acc_Details");
		while (rs.next())
		{
		   acno = rs.getInt("acno");
		}
		con.close();

		acno = acno+1;
		pin = acno * 111;

		result = acno +","+ pin;
 	 }
	catch(Exception e)
	   {
		System.out.println(e);
	   }
	   return result;	      

	}



public String getacno1() throws RemoteException
	{

 	  int acno=0, pin = 0;
	  String result ="";

	  try
	   {		

		Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
		Connection con = DriverManager.getConnection("Jdbc:Odbc:bankodbc");
		Statement stmt = con.createStatement();
		ResultSet rs= stmt.executeQuery("select max(Acc_no) as acno from Joint_acc_Details");
		while (rs.next())
		{
		   acno = rs.getInt("acno");
		}
		con.close();

		acno = acno+1;
		pin = acno * 111;

		result = acno +","+ pin;
 	 }
	catch(Exception e)
	   {
		System.out.println(e);
	   }
	   return result;	      

	}




	public String SingleData(String accno,String Fnm,String Mnm,String lnm,String dtob,String gender,String addr,String pno,String educ,String sal,byte buf[],String balance,String summ,String type,String pin) throws RemoteException
	{
	   String result="";
	   Boolean exists=false;
	   int acno = 0;
	   try
	   {
		File f1 = new File("thumb/"+ Fnm+"_"+accno+".jpg");
		String fullname = f1.getAbsolutePath();
		FileOutputStream outStream = new FileOutputStream(fullname);
		outStream.write(buf);
		outStream.close();

		Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
		Connection con = DriverManager.getConnection("Jdbc:Odbc:bankodbc");
		Statement stmt = con.createStatement();
		
		

		ResultSet rs= stmt.executeQuery("select max(Acc_no) as acno from Single_acc_Details");
		while (rs.next())
		{
		   acno = rs.getInt("acno");
		}
		


		acno = acno+1;	

			
		stmt.executeUpdate("insert into Single_acc_Details(Acc_no,Fname,Mname,Lname,DOB,Sex,Address,Ph_no,Edu, Salary,Fingerprint,Init_bal,Summary,Type_acc,pin) values("+accno+",'"+Fnm+"','"+Mnm+"','"+lnm+"','"+dtob+"','"+gender+"','"+addr+"','"+pno+"','"+educ+"','"+sal+"','"+ fullname +"','"+balance+"','"+summ+"','"+type+"',"+ pin +")");
		result="Data Saved";
		

//		stmt.executeUpdate("insert into Single_acc_Details(Acc_no,Fname,Mname,Lname,DOB,Sex,Address,Ph_no,Edu, Salary,Fingerprint,Init_bal,Summary,Type_acc) values('"+accno+"','"+Fnm+"','"+Mnm+"','"+lnm+"','"+dtob+"','"+gender+"','"+addr+"','"+pno+"','"+educ+"','"+sal+"','"+ fullname +"','"+balance+"','"+summ+"','"+type+"')");

		con.close();

	   }
	   catch(Exception e)
	   {
		System.out.println(e);
	   }
	   return result;
	}

	//==========================================================================

	public String JointData(String accno,String Fnm1,String Mnm1,String lnm1,String dtob1,String gender1,String addr1,String pno1,String educ1,String sal1,byte buf[],String Fnm2,String Mnm2,String lnm2,String dtob2,String gender2,String addr2,String pno2,String educ2,String sal2,byte buf1[],String balance,String summ,String type, String pin) throws RemoteException
	{
	   String result="";
	   Boolean exists=false;
	 int acno = 0;
	   try
	   {
		File f1 = new File("thumb/"+ Fnm1+"_"+accno+".jpg");
		String fullname = f1.getAbsolutePath();
		FileOutputStream outStream = new FileOutputStream(fullname);
		outStream.write(buf);
		outStream.close();

		File f2 = new File("thumb/"+ Fnm2+"_"+accno+".jpg");
		String fullname1 = f2.getAbsolutePath();
		FileOutputStream outStream1 = new FileOutputStream(fullname1);
		outStream1.write(buf1);
		outStream1.close();

		Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
		Connection con = DriverManager.getConnection("Jdbc:Odbc:bankodbc");
		Statement stmt = con.createStatement();
		

		ResultSet rs= stmt.executeQuery("select max(Acc_no) as acno from Joint_acc_Details");
		while (rs.next())
		{
		   acno = rs.getInt("acno");
		}
		


		acno = acno+1;	

					
		stmt.executeUpdate("insert into Joint_acc_Details(Acc_no,Fname1,Mname1,Lname1,DOB1,Sex1,Address1,Ph_no1,Edu1,Salary1,Fingerprint1,Fname2,Mname2,Lname2,DOB2,Sex2,Address2,Ph_no2,Edu2,Salary2,Fingerprint2,Init_bal,Summary,Type_acc,pin) values("+ acno +",'"+Fnm1+"','"+Mnm1+"','"+lnm1+"','"+dtob1+"','"+gender1+"','"+addr1+"','"+pno1+"','"+educ1+"','"+sal1+"','"+fullname+"','"+Fnm2+"','"+Mnm2+"','"+lnm2+"','"+dtob2+"','"+gender2+"','"+addr2+"','"+pno2+"','"+educ2+"','"+sal2+"','"+fullname1+"','"+balance+"','"+summ+"','"+type+"',"+ pin +")");
		result="Data Saved";
		

//		stmt.executeUpdate("insert into Joint_acc_Details(Acc_no,Fname1,Mname1,Lname1,DOB1,Sex1,Address1,Ph_no1,Edu1,Salary1,Fingerprint1,Fname2,Mname2,Lname2,DOB2,Sex2,Address2,Ph_no2,Edu2,Salary2,Fingerprint2,Init_bal,Summary,Dt,Type_acc) values('"+accno+"','"+Fnm1+"','"+Mnm1+"','"+lnm1+"','"+dtob1+"','"+gender1+"','"+addr1+"','"+pno1+"','"+educ1+"','"+sal1+"','"+fullname+"','"+Fnm2+"','"+Mnm2+"','"+lnm2+"','"+dtob2+"','"+gender2+"','"+addr2+"','"+pno2+"','"+educ2+"','"+sal2+"','"+fullname1+"','"+balance+"','"+summ+"','"+type+"')");
		con.close();
	   }
	   catch(Exception e)
	   {
		System.out.println(e);
	   }
	   return result;
	}

	//===========================================================================

	public String RemoveDataJ(String accno) throws RemoteException
	{
	       try
 	       {
		Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
		Connection con = DriverManager.getConnection("Jdbc:Odbc:bankodbc");
		Statement stmt = con.createStatement();
		stmt.executeUpdate("delete from Joint_acc_Details where Acc_no = "+accno);
		con.close();
	       }
	       catch(Exception e)
	       {
		System.out.println(e);
	       }
	   return "Account Deleted";
	}	

	//==============================================================================

	public String RemoveDataS(String accno) throws RemoteException
	{
	       try
 	       {
		System.out.println(accno);
		Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
		Connection con = DriverManager.getConnection("Jdbc:Odbc:bankodbc");
		Statement stmt = con.createStatement();
		stmt.executeUpdate("delete from Single_acc_Details where Acc_no = "+accno);
		con.close();
	       }
	       catch(Exception e)
	       {
		System.out.println(e);
	       }
	   return "Account Deleted";
	}	


//=====================================================================================

	public String ProgressSingle(byte buf[], String pin) throws RemoteException 
	{
	  	String upath="";
		String tpath="";
		String retval="";
		boolean found = false;
		int i=1;
		String fname="";
		String lname="";
		String accno="",balnc="";
	   try {
		
		i++;
		File f1 = new File("Single/thumb.jpg");
		String fullname = f1.getAbsolutePath();

		FileOutputStream outStream = new FileOutputStream(fullname);

		outStream.write(buf);
		outStream.close();

		upath = f1.getAbsolutePath();

		Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");

		Connection con = DriverManager.getConnection("Jdbc:Odbc:bankodbc");

		Statement stmt = con.createStatement();

		ResultSet rs = stmt.executeQuery("select * from Single_acc_Details where pin="+ pin);
		while(rs.next())
		{
                          accno= rs.getString("Acc_no");
		  fname = rs.getString("Fname");
		  lname = rs.getString("Lname");
		  tpath=rs.getString("Fingerprint");
		   balnc=rs.getString("Init_bal");


     //================Matching Process=========================================			



     //picture1
    //Set picture new

    m_bimage1=ImageIO.read(new File(upath)) ;

    m_panel1.setBufferedImage(m_bimage1);

    //Send image for skeletinization

    m_finger1.setFingerPrintImage(m_bimage1) ;

    finger1=m_finger1.getFingerPrintTemplate();

     //See what skeletinized image looks like

    m_bimage1 = m_finger1.getFingerPrintImageDetail();
    m_panel1.setBufferedImage(m_bimage1);
   
        
    //picture2
    //Set picture new
    //  m_bimage2=ImageIO.read(new File(tpath)) ;

    m_bimage2=ImageIO.read(new File(tpath)) ;
    m_panel2.setBufferedImage(m_bimage2);

    //Send image for skeletinization

    m_finger2.setFingerPrintImage(m_bimage2) ;
    finger2=m_finger2.getFingerPrintTemplate();

    //See what skeletinized image looks like

    m_bimage2 = m_finger2.getFingerPrintImageDetail();
    m_panel2.setBufferedImage(m_bimage2);
    
         
        

    double result = m_finger1.Match(finger1 , finger2,65,false);

    if(result >= 90)
    {
      found = true;
      break;

    }