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