public async Task <List <OperationModel> > GetOperationModels()
{
LoggingService.Trace("Querying OperationsDatabase.GetOperationModels");
var databaseConnection = await GetDatabaseConnection <OperationDatabaseModel>().ConfigureAwait(false);
var dbLock = databaseConnection.GetConnection().Lock();
try
{
var operationDatabaseModelList = databaseConnection.GetConnection().GetAllWithChildren <OperationDatabaseModel>();
return(operationDatabaseModelList.Select(x => OperationDatabaseModel.ToOperationModel(x)).ToList());
}
catch (Exception e)
{
LoggingService.Error(e, "Error OperationsDatabase.GetOperationModels");
return(new List <OperationModel>());
}
finally
{
dbLock.Dispose();
}
}
public async Task <OperationModel?> GetOperationModel(string operationId)
{
LoggingService.Trace("Querying OperationsDatabase.GetOperationModel");
if (string.IsNullOrEmpty(operationId))
{
return(null);
}
var databaseConnection = await GetDatabaseConnection <OperationDatabaseModel>().ConfigureAwait(false);
var dbLock = databaseConnection.GetConnection().Lock();
try
{
var operationDatabaseModel = databaseConnection.GetConnection().GetWithChildren <OperationDatabaseModel>(operationId);
return(operationDatabaseModel != null?
OperationDatabaseModel.ToOperationModel(operationDatabaseModel) :
null);
}
catch (Exception e)
{
return(null);
}
finally
{
dbLock.Dispose();
}
}
