public async Task<string> GetCategoryName(int categoryId)
{
var name = String.Empty;
var db = new SQLiteAsyncConnection(App.DBPath);
var _category = await db.FindAsync<Category>(c => c.Id == categoryId);
if (_category != null)
name = _category.Name;
return name;
}
internal static async Task<IEnumerable<SessionHeaderItem>> GetByIdsAsync(SQLiteAsyncConnection conn, List<int> ids)
{
var results = new List<SessionHeaderItem>();
foreach (var id in ids)
{
var session = await conn.FindAsync<SessionHeaderItem>(id);
if (session != null)
results.Add(session);
}
// return...
return results;
}
public async Task<CategoryViewModel> GetCategory(int categoryId)
{
var category = new CategoryViewModel();
var db = new SQLiteAsyncConnection(App.DBPath);
var _category = await db.FindAsync<Category>(c => c.Id == categoryId);
if (_category == null)
return null;
category.Id = _category.Id;
category.Name = _category.Name;
return category;
}
private async void Button_Click_1(object sender, RoutedEventArgs e)
{
string baza = comboboxusunzbazy.SelectedValue.ToString();
string slowko = comboboxslowkodousuniecia.SelectedValue.ToString();
string[] tablica = slowko.Split(new[] {'.'});
if (baza.Equals("eFiszki"))
{
baza = "AppData";
}
var path = Windows.Storage.ApplicationData.Current.LocalFolder.Path + @"\" + baza + ".sqlite";
var db = new SQLiteAsyncConnection(path);
var maxid = 0;
List<UserDefaultDataBase> result = await db.QueryAsync<UserDefaultDataBase>("Select max(id) as Id From UserDefaultDataBase");
foreach (var item in result)
{
maxid = item.Id;
}
int indeksdousuniecia = Convert.ToInt32(tablica[0]);
var all = await db.QueryAsync<UserDefaultDataBase>("Select * From UserDefaultDataBase");
var del = await db.FindAsync<UserDefaultDataBase>(u => u.Id == indeksdousuniecia);
await db.DeleteAsync(del);
//Debug.WriteLine("maksymalny indeks: " + maxid + ", indeks do usuniecia:" + indeksdousuniecia);
//if (maxid != indeksdousuniecia)
//{
// List<UserDefaultDataBase> updateid = await db.QueryAsync<UserDefaultDataBase>("Select * From UserDefaultDataBase Where Id = ?", new object[] { maxid });
// var update = updateid.First();
// update.Id += 100;
// update.SlowkoEn = "toz to dziala";
// await db.UpdateAsync(update);
// Debug.WriteLine("Update indeksu:" + maxid + " na " + indeksdousuniecia);
// //foreach (var i in updateid)
// //{
// // Debug.WriteLine(i.Id);
// //}
// //await db.QueryAsync<UserDefaultDataBase>("Update UserDefaultDataBase set id= ? where id=?", new object[] {maxid, indeksdousuniecia });
// //foreach (var i in updateid)
// //{
// // var update = updateid.First();
// // update.Id = indeksdousuniecia;
// // await db.UpdateAsync(update);
// //}
//}
comboboxslowkodousuniecia.Items.Clear();
setcomboslowko();
}
public async Task<string> GetBackContent(int cardId)
{
string backContent = String.Empty;
var db = new SQLiteAsyncConnection(App.DBPath);
var _card = await db.FindAsync<Card>(c1 => c1.Id == cardId);
if (_card != null)
backContent = _card.BackContent;
return backContent;
}
public async Task<CardViewModel> GetCard(int cardId)
{
var card = new CardViewModel();
var db = new SQLiteAsyncConnection(App.DBPath);
var _card = await db.FindAsync<Card>(c1 => c1.Id == cardId);
if (_card == null)
return null;
card.Id = _card.Id;
card.FrontContent = _card.FrontContent;
card.BackContent = _card.BackContent;
card.DeckId = _card.DeckId;
return card;
}
public async Task<string> GetDeckDescription(int deckId)
{
var description = String.Empty;
var db = new SQLiteAsyncConnection(App.DBPath);
var _deck = await db.FindAsync<Deck>(d1 => d1.Id == deckId);
if (_deck != null)
{
description = _deck.Description;
}
return description;
}
public async Task<string> GetDeckTitle(int deckId)
{
var title = String.Empty;
var db = new SQLiteAsyncConnection(App.DBPath);
var _deck = await db.FindAsync<Deck>(d1 => d1.Id == deckId);
if (_deck != null)
{
title = _deck.Title;
}
return title;
}
public async Task<DeckViewModel> GetDeck(int deckId)
{
var deck = new DeckViewModel();
var db = new SQLiteAsyncConnection(App.DBPath);
var _deck = await db.FindAsync<Deck>(d1 => d1.Id == deckId);
if (_deck == null)
return null;
deck.Id = _deck.Id;
deck.Title = _deck.Title;
deck.Author = _deck.Author;
deck.Subject = _deck.Subject;
deck.Description = _deck.Description;
deck.CategoryId = _deck.CategoryId;
return deck;
}
public async Task <BankAccountFundsTransfer> GetBankAccountFundsTransfer(int transferId)
{
BankAccountFundsTransfer transfer = await connection.FindAsync <BankAccountFundsTransfer>(transferId);
return(transfer);
}
