public bool addSavedCards(string emailId, decimal cardNo) { bool status = false; SavedCards sobj = new SavedCards(); try { sobj.EmailId = emailId; sobj.CardNumber = cardNo; Context.SavedCards.Add(sobj); Context.SaveChanges(); status = true; } catch (Exception e) { Console.WriteLine(e.Message); status = false; } return(status); }
public Deck(List <Card> NewCards) { SavedCards.AddRange(NewCards); Cards.AddRange(SavedCards); }
public async void SavePack_Click(object sender, RoutedEventArgs e) { try { bool isAlreadyInDatabase = false; AppBarButton button = new AppBarButton { }; button = sender as AppBarButton; int packnumber = 1; packnumber = Convert.ToInt32(button.Label.Substring(13, 1)); using (SQLite.Net.SQLiteConnection db = new SQLite.Net.SQLiteConnection(new SQLite.Net.Platform.WinRT.SQLitePlatformWinRT(), App.path)) { int sizeQuery = db.Table<SavedCards>().Where(packs => packs.PackNumber == packnumber && packs.NounWord == currentModel.Noun && packs.Image == currentModel.Image && packs.VerbWord == currentModel.Verb && packs.AdjectiveWord == currentModel.Adjective).Count(); if (sizeQuery > 0) { isAlreadyInDatabase = true; } if (isAlreadyInDatabase == false) { int size = db.Table<SavedCards>().Where(me => me.PackNumber == packnumber).Count(); if (size < 12) { try { SavedCards savedcard = new SavedCards() { VerbWord = currentModel.Verb, AdjectiveWord = currentModel.Adjective, NounWord = currentModel.Noun, Image = currentModel.Image, CardNumber = size, PackNumber = packnumber }; db.Insert(savedcard); } catch (Exception error) { Debug.WriteLine(error.Message); } } else { var dialog = new MessageDialog("Pack " + packnumber + " has maximum number of cards!"); await dialog.ShowAsync(); } } else { var dialog = new MessageDialog("This card is already in the database"); await dialog.ShowAsync(); } } } catch (Exception error) { Debug.WriteLine(error.Message); } }