public async Task <MarkerModel?> GetMarkerModel(string markerId)
{
LoggingService.Trace("Querying MarkersDatabase.GetMarkerModel");
if (string.IsNullOrEmpty(markerId))
{
return(null);
}
var databaseConnection = await GetDatabaseConnection <MarkerDatabaseModel>().ConfigureAwait(false);
var dbLock = databaseConnection.GetConnection().Lock();
try
{
var markerDatabaseModel = databaseConnection.GetConnection().Get <MarkerDatabaseModel>(markerId);
return(markerDatabaseModel != null?
MarkerDatabaseModel.ToMarkerModel(markerDatabaseModel) :
new MarkerModel());
}
catch (Exception e)
{
LoggingService.Error(e, "Error Querying MarkersDatabase.GetMarkerModel");
return(null);
}
finally
{
dbLock.Dispose();
}
}
public async Task <int> SaveMarkerModel(MarkerModel markerModel, string operationId)
{
LoggingService.Trace("Querying MarkersDatabase.SaveMarkerModel");
var databaseConnection = await GetDatabaseConnection <MarkerDatabaseModel>().ConfigureAwait(false);
var dbLock = databaseConnection.GetConnection().Lock();
try
{
var markerDatabaseModel = MarkerDatabaseModel.ToMarkerDatabaseModel(markerModel);
markerDatabaseModel.OpId = operationId;
databaseConnection.GetConnection().InsertOrReplaceWithChildren(markerDatabaseModel);
return(0);
}
catch (Exception e)
{
LoggingService.Error(e, "Error Querying MarkersDatabase.SaveMarkerModel");
return(1);
}
finally
{
dbLock.Dispose();
}
}
public static MarkerModel ToMarkerModel(MarkerDatabaseModel markerDatabaseModel)
{
return(new MarkerModel()
{
Id = markerDatabaseModel.Id,
PortalId = markerDatabaseModel.PortalId,
Type = markerDatabaseModel.Type,
Comment = markerDatabaseModel.Comment,
AssignedTo = markerDatabaseModel.AssignedTo,
AssignedTeam = markerDatabaseModel.AssignedTeam,
AssignedNickname = markerDatabaseModel.AssignedNickname,
CompletedBy = markerDatabaseModel.CompletedBy,
CompletedId = markerDatabaseModel.CompletedId,
State = markerDatabaseModel.State,
Order = markerDatabaseModel.Order,
Zone = markerDatabaseModel.Zone
});
}
