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