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)); } } }
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]")); }
public void Can_Map_Comment_Property() { // Act string column = new RelationMapper(MockSqlContext(), CreateMaps()).Map("Comment"); // Assert Assert.That(column, Is.EqualTo("[umbracoRelation].[comment]")); }
public void Can_Map_Datetime_Property() { // Act string column = new RelationMapper(MockSqlContext(), CreateMaps()).Map("CreateDate"); // Assert Assert.That(column, Is.EqualTo("[umbracoRelation].[datetime]")); }
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]")); }
public void Can_Map_RelationType_Property() { // Act string column = new RelationMapper().Map(new SqlCeSyntaxProvider(), "RelationTypeId"); // Assert Assert.That(column, Is.EqualTo("[umbracoRelation].[relType]")); }
public void Can_Map_Comment_Property() { // Act string column = new RelationMapper().Map(new SqlCeSyntaxProvider(), "Comment"); // Assert Assert.That(column, Is.EqualTo("[umbracoRelation].[comment]")); }
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]")); }
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]")); }
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)); }
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); }
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(); }
private static void DeleteRelation(RelTag tag, Operation operation) { operation.RemoveTag(tag); OperationTagRelationAdapter.Delete(RelationMapper.ConvertToDALEntity(tag, operation)); }