Beispiel #1
0
        public static void LoadOperations()
        {
            OperationMapper.Update(User, OperationsGroups, Importances, Frequencies, TransactionTypes, TransferTypes);
            Operations = OperationMapper.ConvertToBusinessLogicEntitiesCollection(OperationAdapter.GetAll($"user_id={User.Id}")).ToList();

            if (Operations.Count > 0)
            {
                var filter = "";
                foreach (var operation in Operations)
                {
                    filter += $"operation_id={operation.Id} OR ";
                }
                filter = filter.Substring(0, filter.Length - 4);

                RelationMapper.Update(Operations, Tags);
                var relations     = RelationMapper.ConvertToBusinessLogicEntitiesCollection(OperationTagRelationAdapter.GetAll(filter));
                var relTags       = relations.Item1;
                var relOperations = relations.Item2;

                foreach (var operation in Operations)
                {
                    operation.SetDetailsList(OperationDetailsMapper.ConvertToBusinessLogicEntitiesCollection(OperationDetailsAdapter.GetAll($"operation_id={operation.Id}")));
                    operation.SetTags(relTags.Where(r => r.RelatedId == operation.Id));
                }

                foreach (var tag in Tags)
                {
                    tag.SetOperations(relOperations.Where(r => r.TagId == tag.Id));
                }
            }
        }
Beispiel #2
0
        public void Can_Map_RelationType_Property()
        {
            // Act
            string column = new RelationMapper(TestHelper.GetMockSqlContext(), TestHelper.CreateMaps()).Map("RelationTypeId");

            // Assert
            Assert.That(column, Is.EqualTo("[umbracoRelation].[relType]"));
        }
Beispiel #3
0
        public void Can_Map_Comment_Property()
        {
            // Act
            string column = new RelationMapper(MockSqlContext(), CreateMaps()).Map("Comment");

            // Assert
            Assert.That(column, Is.EqualTo("[umbracoRelation].[comment]"));
        }
Beispiel #4
0
        public void Can_Map_Datetime_Property()
        {
            // Act
            string column = new RelationMapper(MockSqlContext(), CreateMaps()).Map("CreateDate");

            // Assert
            Assert.That(column, Is.EqualTo("[umbracoRelation].[datetime]"));
        }
Beispiel #5
0
    public void Can_Map_ChildId_Property()
    {
        // Act
        var column = new RelationMapper(TestHelper.GetMockSqlContext(), TestHelper.CreateMaps()).Map("ChildId");

        // Assert
        Assert.That(column, Is.EqualTo("[umbracoRelation].[childId]"));
    }
Beispiel #6
0
        public void Can_Map_RelationType_Property()
        {
            // Act
            string column = new RelationMapper().Map(new SqlCeSyntaxProvider(), "RelationTypeId");

            // Assert
            Assert.That(column, Is.EqualTo("[umbracoRelation].[relType]"));
        }
Beispiel #7
0
        public void Can_Map_Comment_Property()
        {
            // Act
            string column = new RelationMapper().Map(new SqlCeSyntaxProvider(), "Comment");

            // Assert
            Assert.That(column, Is.EqualTo("[umbracoRelation].[comment]"));
        }
Beispiel #8
0
        public void Can_Map_Datetime_Property()
        {
            // Act
            string column = new RelationMapper().Map(new SqlCeSyntaxProvider(), "CreateDate");

            // Assert
            Assert.That(column, Is.EqualTo("[umbracoRelation].[datetime]"));
        }
        public void Can_Map_ChildId_Property()
        {
            // Arrange
            SqlSyntaxContext.SqlSyntaxProvider = new SqlCeSyntaxProvider();

            // Act
            string column = new RelationMapper().Map("ChildId");

            // Assert
            Assert.That(column, Is.EqualTo("[umbracoRelation].[childId]"));
        }
Beispiel #10
0
        public void Can_Map_Comment_Property()
        {
            // Arrange
            SqlSyntaxContext.SqlSyntaxProvider = SqlCeSyntax.Provider;

            // Act
            string column = new RelationMapper().Map("Comment");

            // Assert
            Assert.That(column, Is.EqualTo("[umbracoRelation].[comment]"));
        }
Beispiel #11
0
        public IActionResult GetRelations([FromBody] GetRelationsRequest value)
        {
            var session = this.GetSession(value.Session, true);

            T2D.Entities.BaseThing thing =
                this.Find(value.ThingId)
                .Include(t => t.ThingAttributes)
                .Include(t => t.ThingRelations)
                .FirstOrDefault()
            ;

            if (thing == null)
            {
                return(BadRequest($"Thing '{value.ThingId}' do not exists."));
            }

            var role = this.RoleMapper.EnumToEntity(value.Role);

            //TODO: check that session has right to
            if (!AttributeSecurity.QueryRelationsRight(thing, session, role))
            {
                return(BadRequest($"Not enough priviledges to query relations for thing {value.ThingId}."));
            }


            var ret = new GetRelationsResponse();

            ret.RelationThings = new List <GetRelationsResponse.RelationsThings>();

            foreach (var group in thing.ThingRelations.GroupBy(tr => tr.RelationId))
            {
                var rt = new GetRelationsResponse.RelationsThings
                {
                    Relation = RelationMapper.FromEntityId(group.Key).ToString(),
                    Things   = new List <GetRelationsResponse.RelationsThings.IdTitle>(),
                };
                foreach (var th in group)
                {
                    var thingIdTitle = new GetRelationsResponse.RelationsThings.IdTitle {
                        ThingId = ThingIdHelper.Create(th.Thing2_Fqdn, th.Thing2_US)
                    };
                    var thing2 = this.Find(th.Thing2_Fqdn, th.Thing2_US);
                    if (thing2 != null)
                    {
                        thingIdTitle.Title = thing2.Title;
                    }
                    rt.Things.Add(thingIdTitle);
                }
                ret.RelationThings.Add(rt);
            }
            return(Ok(ret));
        }
Beispiel #12
0
        private static int InsertRelation(RelTag tag, Operation operation)
        {
            if (tag.IsDirty)
            {
                var newId = OperationTagRelationAdapter.Insert(RelationMapper.ConvertToDALEntity(tag, operation));
                tag.UpdateId(newId);
                tag.IsDirty = false;
                var relOperation = tag.Tag.Operations.Where(o => o.Operation == operation).First();
                relOperation.UpdateId(newId);
                relOperation.IsDirty = false;
            }

            return(tag.Id.Value);
        }
Beispiel #13
0
        public static void SetService()
        {
            Settings = new Settings2();

            var dataBaseData = ConfigurationManager.DataBaseData();

            DbManager   = new DatabaseManager(new MySqlConnectionFactory(), dataBaseData.Address, dataBaseData.Port, dataBaseData.Table, dataBaseData.Login, dataBaseData.Password);
            DbConnector = new DbConnector(DbManager);

            LanguageAdapter                = new LanguageAdapter(DbConnector);
            UserAdapter                    = new UserAdapter(DbConnector);
            UserDetailsAdapter             = new UserDetailsAdapter(DbConnector);
            TransactionTypeAdapter         = new TransactionTypeAdapter(DbConnector);
            TransferTypeAdapter            = new TransferTypeAdapter(DbConnector);
            FrequencyAdapter               = new FrequencyAdapter(DbConnector);
            ImportanceAdapter              = new ImportanceAdapter(DbConnector);
            TagAdapter                     = new TagAdapter(DbConnector);
            OperationAdapter               = new OperationAdapter(DbConnector);
            OperationDetailsAdapter        = new OperationDetailsAdapter(DbConnector);
            OperationTagRelationAdapter    = new OperationTagAdapter(DbConnector);
            OperationsGroupAdapter         = new OperationsGroupAdapter(DbConnector);
            OperationsGroupRelationAdapter = new OperationsGroupTagAdapter(DbConnector);

            LanguageMapper                = new LanguageMapper();
            UserMapper                    = new UserMapper();
            UserDetailsMapper             = new UserDetailsMapper();
            TransactionTypeMapper         = new TransactionTypeMapper();
            TransferTypeMapper            = new TransferTypeMapper();
            FrequencyMapper               = new FrequencyMapper();
            ImportanceMapper              = new ImportanceMapper();
            TagMapper                     = new TagMapper();
            OperationMapper               = new OperationMapper();
            OperationDetailsMapper        = new OperationDetailsMapper();
            RelationMapper                = new RelationMapper();
            OperationsGroupMapper         = new OperationsGroupMapper();
            OperationsGroupRelationMapper = new OperationsGroupRelationMapper();

            SetMainConfigurations();
        }
Beispiel #14
0
 private static void DeleteRelation(RelTag tag, Operation operation)
 {
     operation.RemoveTag(tag);
     OperationTagRelationAdapter.Delete(RelationMapper.ConvertToDALEntity(tag, operation));
 }