package com.softserve.academy.food.dao;
import org.hibernate.Query;
import org.springframework.stereotype.Repository;
import com.softserve.academy.food.entity.eOrder;
import java.util.ArrayList;
import java.util.List;
@Repository
public class HibernateOrder extends Dao
{
public ArrayList<eOrder> Create(ArrayList<eOrder> list)
{
ArrayList<eOrder> save = new ArrayList<eOrder>();
for (eOrder obj : list)
{
obj.setId( (Integer) sessionFactory.getCurrentSession().save( obj ));
save.add(obj);
}
return save;
}
public eOrder Create(eOrder order)
{
if (order!=null)
{
order.setId( (Integer)sessionFactory.getCurrentSession().save( order ) );
}
return order;
}
public void Delete(int id)
{
Query query;
query = sessionFactory.getCurrentSession().createQuery("delete from eOrder where id = " + id);
query.executeUpdate();
}
public void DeleteAll()
{
Query query;
query = sessionFactory.getCurrentSession().createQuery("delete from eOrder");
query.executeUpdate();
}
@SuppressWarnings("unchecked")
public eOrder Read(eOrder order)
{
int id = order.getId();
List<eOrder> list = sessionFactory.getCurrentSession().createQuery( "from eOrder where id = "+id ).list();
if (list.isEmpty())
{
return order;
}
return list.get(0);
}
@SuppressWarnings("unchecked")
public eOrder Read(int id)
{
eOrder order = new eOrder();
List<eOrder> list = sessionFactory.getCurrentSession().createQuery("from eOrder where id = "+id).list();
if (list.isEmpty())
{
return order;
}
return list.get(0);
}
@SuppressWarnings("unchecked")
public ArrayList<eOrder> ReadAll()
{
return (ArrayList<eOrder>) sessionFactory.getCurrentSession().createQuery("from eOrder").list();
}
}