Example #1
0
        public bool RemoveListening(Listening listening)
        {
            bool result = false;

            ISession session = SessionFactory.GetSession();

            ITransaction tx = session.BeginTransaction();

            try
            {
                ListeningEntity dataEntity = session.CreateCriteria <ListeningEntity>().
                                             Add(Restrictions.Eq("ID", listening.ID)).UniqueResult <ListeningEntity>();

                if (dataEntity != null)
                {
                    session.Delete(dataEntity);

                    tx.Commit();
                }

                result = true;
            }
            catch (Exception ex)
            {
                Logger.Write(ex);
                tx.Rollback();
            }
            finally
            {
                session.Close();
                tx.Dispose();
            }

            return(result);
        }
Example #2
0
        public bool SaveListening(Listening listening)
        {
            bool result = false;

            ISession session = SessionFactory.GetSession();

            ITransaction tx = session.BeginTransaction();

            try
            {
                EntityConverter converter = new EntityConverter();

                ListeningEntity dataEntity = converter.FromBusinessEntity(listening);

                session.SaveOrUpdate(dataEntity);

                tx.Commit();

                listening.ID = dataEntity.ID;

                result = true;
            }
            catch (Exception ex)
            {
                Logger.Write(ex);
                tx.Rollback();
            }
            finally
            {
                session.Close();
                tx.Dispose();
            }

            return(result);
        }
Example #3
0
        public ListeningEntity FromBusinessEntity(Listening businessEntity)
        {
            if (businessEntity == null)
            {
                return(null);
            }

            ListeningEntity dataEntity = new ListeningEntity()
            {
                ID           = businessEntity.ID,
                ListenRating = businessEntity.ListenRating,
                PrivateMarks = businessEntity.PrivateMarks,
                Review       = businessEntity.Review,
                Comments     = businessEntity.Comments,
                Date         = businessEntity.Date,
                Album        = new AlbumEntity()
                {
                    ID = businessEntity.Album.ID
                },
                Mood  = FromBusinessEntity(businessEntity.Mood),
                Place = FromBusinessEntity(businessEntity.Place)
            };

            return(dataEntity);
        }
Example #4
0
        public IPagedList <Listening> GetListenings(ILoadOptions options)
        {
            IPagedList <Listening> result = new PagedList <Listening>();

            if (options == null)
            {
                return(result);
            }

            if (options.MaxResults <= 0)
            {
                return(result);
            }

            ISession session = SessionFactory.GetSession();

            try
            {
                DetachedCriteria countCriteria = GetListeningsImpl(options);
                DetachedCriteria listCriteria  = GetListeningsImpl(options);

                countCriteria.SetProjection(Projections.RowCount());
                countCriteria.ClearOrders();

                listCriteria.
                SetFirstResult(options.FirstResult).
                SetMaxResults(options.MaxResults);

                IMultiCriteria multiCriteria = session.CreateMultiCriteria();
                multiCriteria.Add(countCriteria);
                multiCriteria.Add(listCriteria);


                IList queryResult = multiCriteria.List();

                result.TotalItems = (int)((IList)queryResult[0])[0];

                IList recordsList = (IList)queryResult[1];

                EntityConverter entityConverter = new EntityConverter();

                foreach (var e in recordsList)
                {
                    ListeningEntity dataEntity     = e as ListeningEntity;
                    Listening       businessEntity = entityConverter.FromDataEntity(dataEntity);
                    result.Add(businessEntity);
                }
            }
            catch (Exception ex)
            {
                Logger.Write(ex);
            }
            finally
            {
                session.Close();
            }

            return(result);
        }
Example #5
0
        public Listening FromDataEntity(ListeningEntity dataEntity)
        {
            if (dataEntity == null)
            {
                return(null);
            }

            Listening businessEntity = new Listening()
            {
                ID           = dataEntity.ID,
                Date         = dataEntity.Date,
                ListenRating = dataEntity.ListenRating,
                PrivateMarks = dataEntity.PrivateMarks,
                Review       = dataEntity.Review,
                Comments     = dataEntity.Comments
            };

            businessEntity.Album = FromDataEntity(dataEntity.Album, AlbumConvertOptions.Small);
            businessEntity.Mood  = FromDataEntity(dataEntity.Mood, MoodConvertOptions.Short);
            businessEntity.Place = FromDataEntity(dataEntity.Place, PlaceConvertOptions.Short);

            return(businessEntity);
        }