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);
}
}
