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> 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> 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> 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); } }
public Task<List<FlickrImage>> GetFlickrImagesCollectionAsync() { try { List<FlickrImage> images; using (var context = new FerrariDataContext()) { IQueryable<FlickrImage> itemsCollection = from itms in context.GetTable<FlickrImage>() select itms; images = itemsCollection.ToList(); } return Task.FromResult<List<FlickrImage>>(images); } catch (Exception) { return null; } }
public Task<List<Item>> GetItemsCollectionByCategoryAsync(string itemCategory) { try { List<Item> items; using (var context = new FerrariDataContext()) { IQueryable<Item> itemsCollection = from itms in context.GetTable<Item>() select itms; items = itemsCollection.Where(item => item.Category == itemCategory).ToList(); } return Task.FromResult(items); } catch (Exception) { return null; } }
public Task<List<Tweet>> GetTweetsCollectionAsync() { try { List<Tweet> tweets; using (var context = new FerrariDataContext()) { IQueryable<Tweet> itemsCollection = from itms in context.GetTable<Tweet>() select itms; tweets = itemsCollection.ToList(); } return Task.FromResult(tweets); } catch (Exception) { return null; } }
public Task<List<YoutubeVideo>> GetVideosCollectionAsync() { try { List<YoutubeVideo> videos; using (var context = new FerrariDataContext()) { IQueryable<YoutubeVideo> vdeos = from itms in context.GetTable<YoutubeVideo>() select itms; videos = vdeos.ToList(); } return Task.FromResult<List<YoutubeVideo>>(videos); } catch (Exception) { return null; } }