//FILE: myapp/client/generated/TodoBean.java
package myapp.client.generated;

public class TodoBean
{
    private int todoId; 
    private String description; 
    private int rank; 
     
    public TodoBean() 
    {
        super();
    }   

    public void setTodoId(int _n) { todoId=_n; } 
    public int getTodoId() { return todoId; } 

    public void setDescription(String _n) { description=_n; } 
    public String getDescription() { return description; } 

    public void setRank(int _n) { rank=_n; } 
    public int getRank() { return rank; } 
      
}
//FILE: myapp/client/generated/AttributeBean.java
package myapp.client.generated;

public class AttributeBean
{
    private String name; 
    private String displayName; 
     
    public AttributeBean() 
    {
        super();
    }   

    public void setName(String _n) { name=_n; } 
    public String getName() { return name; } 

    public void setDisplayName(String _n) { displayName=_n; } 
    public String getDisplayName() { return displayName; } 
      
}
//FILE: myapp/client/generated/IdLabel.java
package myapp.client.generated;

public class IdLabel
{
    private String id; 
    private String label; 
     
    public IdLabel() 
    {
        super();
    }   

    public void setId(String _n) { id=_n; } 
    public String getId() { return id; } 

    public void setLabel(String _n) { label=_n; } 
    public String getLabel() { return label; } 
      
}

//FILE: myapp/client/generated/DoneService.java
package myapp.client.generated;

import java.sql.*;
import java.util.*;

import myapp.client.generated.TodoBean;
import myapp.client.generated.AttributeBean;
import myapp.client.generated.IdLabel;


public interface DoneService
{
    public List<TodoBean> getTodoList()
    throws SQLException;

     
    public int getNextSequenceValue()
    throws SQLException;

     
    public int getMaxRank()
    throws SQLException;

     
    public void insertTask(int id, String description, int rank)
    throws SQLException;  

     
    public int addNewTask(String task)
    throws SQLException;

 
}
//FILE: myapp/server/generated/DoneServiceImpl.java
package myapp.server.generated;

import java.sql.*;
import java.util.*;


import myapp.server.common.BaseService;
import myapp.client.generated.DoneService;

import myapp.client.generated.TodoBean;
import myapp.client.generated.AttributeBean;
import myapp.client.generated.IdLabel;


public class DoneServiceImpl extends BaseService implements DoneService
{
    public List<TodoBean> getTodoList()
    throws SQLException
    {
        Connection connection = getConnection();
        PreparedStatement pstmt= connection.prepareCall(
            "select todo_id, description, rank "+ 
            "from t_todo "+ 
            "order by rank ");
        ResultSet resultSet=pstmt.executeQuery();
        List<TodoBean> c = new ArrayList<TodoBean>();
        while ( resultSet.next() )
        {
            c.add(resultSetToTodoBean( resultSet ) );
        }
        resultSet.close();
        pstmt.close();
        returnConnection(connection);
        return c;
    }

    public int getNextSequenceValue()
    throws SQLException
    {
        Connection connection = getConnection();
        PreparedStatement pstmt= connection.prepareCall(
            "select nextval('seq_todo') ");
        ResultSet resultSet=pstmt.executeQuery();
        
        resultSet.next();
        int o=resultSetToInt( resultSet);
        resultSet.close();
        pstmt.close();
        returnConnection(connection);
        return o;
    }

    public int getMaxRank()
    throws SQLException
    {
        Connection connection = getConnection();
        PreparedStatement pstmt= connection.prepareCall(
            "select max(rank) from t_todo ");
        ResultSet resultSet=pstmt.executeQuery();
        
        resultSet.next();
        int o=resultSetToInt( resultSet);
        resultSet.close();
        pstmt.close();
        returnConnection(connection);
        return o;
    }

 
    public void insertTask(int id, String description, int rank)
    throws SQLException
    {
        Connection connection = getConnection();
        PreparedStatement stmt= connection.prepareCall(
            "insert into t_todo(todo_id, description, rank) "+ 
            "values(?, ?, ?) ");

        stmt.setInt(1,id); 
        stmt.setString(2,description); 
        stmt.setInt(3,rank); 
        stmt.execute();
        stmt.close();
        returnConnection(connection);
    }
  
    public int addNewTask(String task)
    throws SQLException
    {
        int newId=getNextSequenceValue();
        int newRank=1+getMaxRank();
        insertTask(newId,task,newRank);
        return newId;
    } 



    private TodoBean resultSetToTodoBean(ResultSet resultSet)
    throws SQLException
    {
       TodoBean o = new TodoBean();
       o.setTodoId( resultSet.getInt(1)); 
       o.setDescription( resultSet.getString(2)); 
       o.setRank( resultSet.getInt(3)); 
       return o;
    }

    private AttributeBean resultSetToAttributeBean(ResultSet resultSet)
    throws SQLException
    {
       AttributeBean o = new AttributeBean();
       o.setName( resultSet.getString(1)); 
       o.setDisplayName( resultSet.getString(2)); 
       return o;
    }

    private IdLabel resultSetToIdLabel(ResultSet resultSet)
    throws SQLException
    {
       IdLabel o = new IdLabel();
       o.setId( resultSet.getString(1)); 
       o.setLabel( resultSet.getString(2)); 
       return o;
    }


    private int resultSetToInt(ResultSet resultSet)
    throws SQLException
    {
       return resultSet.getInt(1);
    }
 
}