private void AddCollectionItem(GifCollectionItem gifCollectionItem)
{
_gifCollectionServiceObj.InsertGifCollectionItem(gifCollectionItem);
GifCollections.Add(gifCollectionItem);
NewCollectionName = String.Empty;
}
private GifCollectionItem CreateCollection()
{
GifCollectionItem gifCollectionItem = new GifCollectionItem(NewCollectionName);
gifCollectionItem.Id = _gifCollectionServiceObj.GetLastGifCollectionItemId() + 1;
return(gifCollectionItem);
}
public GifDataItem GetGifDataItem(GifDataItem gifDataItem, GifCollectionItem gifCollectionItem)
{
try
{
List <GifDataItem> existingItems = sqliteConnection.Query <GifDataItem>
($"select * from GifDataItem where Id = '{gifDataItem.Id}' and GifCollectionId = '{gifCollectionItem.Id}'");
return((existingItems.Count != 0) ? existingItems[0] : null);
//return sqliteConnection.GetAsync<GifDataItem>(gifDataItem.Id).Result;
}
catch (Exception exception)
{
Debug.WriteLine(exception.Message);
throw;
}
}
private void AddGifDataItemToCollection(GifCollectionItem gifCollectionItem)
{
GifDataItem existingItem = _gifDataServiceObj.GetGifDataItem(_gifDataItem, gifCollectionItem);
// If the gif does not previously exist in the collection
if (existingItem == null)
{
_gifDataItem.GifCollectionId = gifCollectionItem.Id;
_gifDataServiceObj.InsertGifDataItem(_gifDataItem);
}
else
{
GifCollectionItem priorCollectionItem = _gifCollectionServiceObj.GetGifCollectionItem(existingItem.GifCollectionId);
MainThread.BeginInvokeOnMainThread
(
() =>
{
CoreMethods.DisplayAlert("Oops", $"Gif already exists in the { priorCollectionItem.Name } collection.", "Ok");
}
);
}
}
public void UpdateGifCollectionItem(GifCollectionItem gifCollectionItem)
{
sqliteConnection.Update(gifCollectionItem);
}
public void InsertGifCollectionItem(GifCollectionItem gifCollectionItem)
{
sqliteConnection.Insert(gifCollectionItem);
}
public void DeleteGifCollection(GifCollectionItem gifCollectionItem)
{
sqliteConnection.Delete(gifCollectionItem);
}
