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));
}
