public void SaveSearchRequest(SearchRequest searchRequest)
{
var found = RetrieveSearchRequest(searchRequest.Term, searchRequest.Type);
if (found != null && found.Count == 1)
{
found[0].TimeStamp = searchRequest.TimeStamp;
found[0].MediaDescription = searchRequest.MediaDescription;
found[0].MediaTitle = searchRequest.MediaTitle;
found[0].MediaLicense = searchRequest.MediaLicense;
found[0].MediaUrlSmall = searchRequest.MediaUrlSmall;
found[0].MediaUrlMedium = searchRequest.MediaUrlMedium;
found[0].MediaUserAvatar = searchRequest.MediaUserAvatar;
found[0].MediaUserName = searchRequest.MediaUserName;
found[0].CacheCallResponseUrl = searchRequest.CacheCallResponseUrl;
this.SqliteDb.Update(found[0]);
}
else
{
if (found != null && found.Count == 0)
{
AddSearchRequest(searchRequest);
}
else
{
if (found != null)
{
foreach (var item in found)
{
DeleteSearchRequest(item.Id);
}
}
AddSearchRequest(searchRequest);
}
}
}
public void AddSearchRequest(SearchRequest searchRequest)
{
LoggingService.LogInformation("writing to db 'SearchRequest'", "AppDatabase.AddSearchRequest");
var found = RetrieveSearchRequest(searchRequest.Term, searchRequest.Type);
if (found != null && found.Count() > 0)
{
found[0].TimeStamp = searchRequest.TimeStamp;
this.SqliteDb.Update(found[0]);
//await mstSolution.UpdateAsync(solution);
}
else
{
this.SqliteDb.Insert(searchRequest);
}
Messenger.Default.Send<GeneralSystemWideMessage>(new GeneralSystemWideMessage("inserting ...") { Identifier = "DB", SourceId = "SearchRequest" });
}
