public ApiAdapter(IDataBaseManagerFactory dbEngine, string address, string port, string table, string login, string password)
{
DbManager = new DatabaseManager(dbEngine, address, port, table, login, 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);
FilterAdapter = new FilterAdapter(DbConnector);
DashboardAdapter = new DashboardAdapter(DbConnector);
DashboardFilterRelationAdapter = new DashboardFilterRelationAdapter(DbConnector);
BankAdapter = new BankAdapter(DbConnector);
SettingsAdapter = new SettingsAdapter(DbConnector);
SchematicTypeAdapter = new SchematicTypeAdapter(DbConnector);
SchematicAdapter = new SchematicAdapter(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();
TagRelationMapper = new RelationTagMapper();
OperationMapper = new OperationMapper();
OperationsGroupMapper = new OperationsGroupMapper();
FilterMapper = new FilterMapper();
DashboardMapper = new DashboardMapper();
DashboardFilterMapper = new DashboardFilterMapper();
BankMapper = new BankMapper();
SettingsMapper = new SettingsMapper();
SchematicTypeMapper = new SchematicTypeMapper();
SchematicMapper = new SchematicMapper();
}
public void UpdateOperationsGroupComplex(ApiOperationsGroup group)
{
var dalObjects = OperationsGroupMapper.ConvertToDALEntity(group);
var dalOperationsGroup = dalObjects.Group;
var dalOperationsGroupTags = dalObjects.Tags;
var dalOperations = dalObjects.Operations;
var id = Update(dalOperationsGroup, OperationsGroupAdapter);
foreach (var dalOperationsGroupTag in dalOperationsGroupTags)
{
dalOperationsGroupTag.UpdateOperationsGroupId(id.Value);
Update(dalOperationsGroupTag, OperationsGroupRelationAdapter);
}
foreach (var dalOperation in dalOperations)
{
UpdateOperationComplex(dalOperation);
}
}
public List <ApiOperationsGroup> GetOperationsGroups(ApiUser user, List <ApiOperation> operations, List <ApiFrequency> frequencies, List <ApiImportance> importances, List <ApiTransactionType> types, List <ApiTag> tags)
{
var groups = OperationsGroupAdapter.GetAll($"user_id={user.Id}");
var filter = "";
foreach (var group in groups)
{
filter += $"operation_group_id={group.Id} OR ";
}
if (filter.Length > 4)
{
filter = filter.Substring(0, filter.Length - 4);
}
var relations = OperationsGroupRelationAdapter.GetAll(filter).ToList();
OperationsGroupMapper.Update(OperationMapper, importances, tags, frequencies, operations, user, relations, types);
return(OperationsGroupMapper.ConvertToApiEntitiesCollection(OperationsGroupAdapter.GetAll($"user_id={user.Id}")).ToList());
}
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();
}
public static void LoadOperationsGroups()
{
OperationsGroupMapper.Update(User, Importances, Frequencies);
OperationsGroups = OperationsGroupMapper.ConvertToBusinessLogicEntitiesCollection(OperationsGroupAdapter.GetAll($"user_id={User.Id}")).ToList();
if (OperationsGroups.Count > 0)
{
var filter = "";
foreach (var group in OperationsGroups)
{
filter += $"operation_group_id={group.Id} OR ";
}
filter = filter.Substring(0, filter.Length - 4);
OperationsGroupRelationMapper.Update(Tags);
var relations = OperationsGroupRelationMapper.ConvertToBusinessLogicEntitiesCollection(OperationsGroupRelationAdapter.GetAll(filter));
foreach (var group in OperationsGroups)
{
group.SetTags(relations.Where(r => r.RelatedId == group.Id));
}
}
}
