public override AppDto GetById(Guid Id)
 {
     using (UnitOfNhibernate op = new UnitOfNhibernate())
     {
         op.BeginTransaction();
         SQLAppEntity entity = op.Query <SQLAppEntity>().Where(x => x.Id.Equals(Id)).FirstOrDefault();
         return(ConvertEntityToDto(entity));
     }
 }
 public AppDto GetByName(string Name)
 {
     using (UnitOfNhibernate op = new UnitOfNhibernate())
     {
         op.BeginTransaction();
         SQLAppEntity entity = op.Query <SQLAppEntity>().Where(x => x.Name.Equals(Name)).FirstOrDefault();
         return(ConvertEntityToDto(entity));
     }
 }
        internal static AppDto ConvertEntityToDto(SQLAppEntity entity)
        {
            AppDto result = new AppDto();

            if (entity != null)
            {
                result.Id   = entity.Id;
                result.Name = entity.Name;
            }
            return(result);
        }
 public override void Save(AppDto dto)
 {
     using (UnitOfNhibernate op = new UnitOfNhibernate())
     {
         op.BeginTransaction();
         SQLAppEntity entity = op.Query <SQLAppEntity>().Where(x => x.Id.Equals(dto.Id)).FirstOrDefault();
         if (entity == null)
         {
             entity = new SQLAppEntity();
         }
         entity.Name = dto.Name;
         op.SaveOrUpdate(entity);
         op.Commit();
     }
 }
        public override void Delete(AppDto dto)
        {
            using (UnitOfNhibernate op = new UnitOfNhibernate())
            {
                op.BeginTransaction();
                SQLAppEntity entity = op.Query <SQLAppEntity>().Where(x => x.Id.Equals(dto.Id)).FirstOrDefault();
                if (entity != null)
                {
                    List <SQLLogEntity> logList = op.Query <SQLLogEntity>().Where(x => x.App.Id.Equals(entity.Id)).ToList();
                    if (logList != null && logList.Count > 0)
                    {
                        foreach (SQLLogEntity log in logList)
                        {
                            op.Delete(log);
                        }
                    }
                    op.Delete(entity);

                    op.Commit();
                }
            }
        }