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