public Task<bool> SaveFlickrImagesCollectionAsync(List<FlickrImage> images)
{
if (images == null || images.Count == 0)
return Task.FromResult<bool>(false);
try
{
//Adding data to the local database
using (var context = new FerrariDataContext())
{
var oldImages = context.Images;
context.Images.DeleteAllOnSubmit(oldImages);
context.SubmitChanges();
foreach (FlickrImage item in images)
{
context.GetTable<FlickrImage>().InsertOnSubmit(item);
}
context.SubmitChanges();
}
return Task.FromResult<bool>(true);
}
catch (Exception exc)
{
return Task.FromResult<bool>(false);
}
}
public Task<bool> SaveTweetsCollectionAsync(List<Tweet> tweets)
{
if (tweets == null || tweets.Count == 0)
return Task.FromResult(false);
try
{
//Adding data to the local database
using (var context = new FerrariDataContext())
{
Table<Tweet> oldTweets = context.GetTable<Tweet>();
context.GetTable<Tweet>().DeleteAllOnSubmit(oldTweets);
context.SubmitChanges();
foreach (Tweet tweet in tweets)
{
context.GetTable<Tweet>().InsertOnSubmit(tweet);
}
context.SubmitChanges();
}
return Task.FromResult(true);
}
catch (Exception exc)
{
return Task.FromResult(false);
}
}
public Task<bool> SaveItemsCollectionAsync(List<Item> items)
{
if (items == null || items.Count == 0)
return Task.FromResult<bool>(false);
try
{
//Adding data to the local database
using (var context = new FerrariDataContext())
{
var oldItems = context.GetTable<Item>().Where(entity => entity.Category == items.FirstOrDefault().Category);
context.GetTable<Item>().DeleteAllOnSubmit(oldItems);
context.SubmitChanges();
foreach (Item item in items)
{
context.GetTable<Item>().InsertOnSubmit(item);
}
context.SubmitChanges();
}
return Task.FromResult<bool>(true);
}
catch (Exception exc)
{
return Task.FromResult<bool>(false);
}
}
public Task<bool> SaveVideosCollectionAsync(List<YoutubeVideo> videos)
{
if (videos == null || videos.Count == 0)
return Task.FromResult<bool>(false);
try
{
//Adding data to the local database
using (var context = new FerrariDataContext())
{
var oldVideos = context.GetTable<YoutubeVideo>();
context.GetTable<YoutubeVideo>().DeleteAllOnSubmit(oldVideos);
context.SubmitChanges();
foreach (var video in videos)
{
context.GetTable<YoutubeVideo>().InsertOnSubmit(video);
}
context.SubmitChanges();
}
return Task.FromResult<bool>(true);
}
catch (Exception exc)
{
return Task.FromResult<bool>(false);
}
}