public enum DeliveryStatus {
    delivered,
    undelivered,
    toPickUp,
    toDelivery,
    pickedUp,
    notPickedUp
}

public enum LocationStatus  {
    Doreczono,
    PowrotDoMagazynu,
    OdebranoOdNadawcy,
    NieOdebranoOdNadawcy
}

public class Courier {
    private int id;
    //private String username;
    private User user;

    public User getUser() {
        return user;
    }

    public void setUser(User user) {
        this.user = user;
    }

    public int getId() {
        return id;
    }

    public void setId(int id) {
        this.id = id;
    }
/*
    public String getUsername() {
        return username;
    }
    public void setUsername(String username) {
        this.username = username;
    }
    */

}
public class CourierFunc {

    Courier courier;
    Session session;

    public CourierFunc(Courier courier) {
        this.courier = courier;
        this.session = DatabaseInit.getInstance().getSession();
    }

    //public List<Package> getTransportedPackage()
    public List<CourierData> getTransportedPackage(DeliveryStatus status)
        {
        session.beginTransaction();

        //Query q = session.createQuery("FROM Package WHERE courier = :c" );
        //Query q = session.createQuery("FROM CourierData WHERE ID_courier = :c" );
        //Query q = session.createQuery("SELECT TelephoneNumber, ReceiverFirstName, ReceiverLastName, ReceiverCity, ReceiverPostCode, ReceiverStreet, ReceiverHouseNumber, ReceiverApartmentNumber FROM CourierData WHERE ID_courier = :c AND DeliveredStatus = NULL" );
        Query q;
        if(status == null)
        {
            q = session.createQuery("FROM CourierData WHERE ID_courier = :c AND DeliveredStatus = 'toDelivery' OR DeliveredStatus = 'toPickUp'" );

        }
        else
        {
            q = session.createQuery("FROM CourierData WHERE ID_courier = :c AND DeliveredStatus = :s" );
            q.setParameter("s", status.toString());
        }
        q.setParameter("c", courier.getId());


        //List<Package> pack = q.list();
        //List<CourierData> pack = q.list();
        List<CourierData> pack = q.list();

        session.getTransaction().commit();
        return pack;
    }

    public int setDeliveryStatus(DeliveryStatus status, int packageNumber)
    {
        DeliveryStatus stat;
        LocationStatus loc;

        if(status == null)
            return -1;

        switch(status)
        {
            case delivered:
            {
                stat = DeliveryStatus.delivered;
                loc = LocationStatus.Doreczono;
                break;
            }
            case undelivered:
            {
                stat = DeliveryStatus.undelivered;
                loc = LocationStatus.PowrotDoMagazynu;
                break;
            }
            case pickedUp:
            {
                stat = DeliveryStatus.pickedUp;
                loc = LocationStatus.OdebranoOdNadawcy;
                break;
            }
            case notPickedUp:
            {
                stat = DeliveryStatus.notPickedUp;
                loc = LocationStatus.NieOdebranoOdNadawcy;
                break;
            }
            default:
            {
                return -1;
            }
        }

        session.beginTransaction();

        Query q  = session.createQuery("UPDATE Package SET DeliveredStatus = :s, location = :l WHERE id = :id");
        q.setParameter("s", stat.toString());
        q.setParameter("l", loc.toString());
        q.setParameter("id", packageNumber);

        int result = q.executeUpdate(); //TODO: usunac inta albo zrobic return

        session.getTransaction().commit();
        return result;
    }

}