public MemoryLine Delete(MemoryLine entity)
{
using (ISession session = SessionFactory.OpenSession())
using (ITransaction transaction = session.BeginTransaction())
{
session.Delete(entity);
transaction.Commit();
}
return(entity);
}
public MemoryLine GetMemoryWithGuestList(Guid id)
{
MemoryLine entity;
MemoryLine memoryLineAlias = null;
User guestAlias = null;
using (ISession session = SessionFactory.OpenSession())
{
entity = session.QueryOver(() => memoryLineAlias)
.JoinAlias(() => memoryLineAlias.Guests, () => guestAlias)
.Where(() => memoryLineAlias.Id == id)
.SingleOrDefault();
}
return(entity);
}
public List <MemoryLine> GetByUser(Guid id)
{
IList <MemoryLine> entity;
using (ISession session = SessionFactory.OpenSession())
{
MemoryLine memoryLineAlias = null;
User hostAlias = null;
User guestAlias = null;
//TODO: Validate
entity = session.QueryOver(() => memoryLineAlias)
.JoinAlias(() => memoryLineAlias.Host, () => hostAlias)
.Left.JoinAlias(() => memoryLineAlias.Guests, () => guestAlias)
.Where(() => hostAlias.Id == id || guestAlias.Id == id)
.OrderBy(x => x.CreatedAt)
.Desc
.List();
}
return(entity as List <MemoryLine>);
}
