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