public void deactivateAgent(int oldAgentId, int newAgentId)
	{
		int numRows;
		
		//update sql statement constructed
        String sql = "UPDATE agents SET agtposition='Inactive' WHERE AgentId=" + oldAgentId;
        	
        //System.out.println(sql);
        try 
        {
        	PreparedStatement preparedStatement = conn.prepareStatement(sql);
        	
        	// execute update SQL statement
        	numRows =  preparedStatement.executeUpdate();
        	if (numRows == 0)
        	{
        		System.out.println("update failed");
        	}
        	else
        	{
        		System.out.println("updated " + numRows + " row(s)");
        		conn.commit();
        	}
        } catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}       
        
        sql = "UPDATE customers SET agentid="+newAgentId+" WHERE agentid=" + oldAgentId;
    	
        try 
        {
        	PreparedStatement preparedStatement = conn.prepareStatement(sql);        	
        	// execute update SQL statement
        	numRows =  preparedStatement.executeUpdate();
        	if (numRows == 0)
        	{
        		System.out.println("customer update failed");
        	}
        	else
        	{
        		System.out.println("customer updated " + numRows + " row(s)");
        		conn.commit();
        	}
        } catch (SQLException e) {
			e.printStackTrace();
		}         
        
	}