public bool updateWaluta(Waluta waluta) { try { using (var connection = new SQLiteConnection(System.IO.Path.Combine(folder, "Waluty.db"))) { connection.Query <Waluta>("UPDATE Waluta set Data=?,Kupno=?,Sprzedaz=? Where Kod=?", waluta.Data, waluta.Kupno, waluta.Sprzedaz, waluta.Kod); return(true); } } catch (SQLiteException e) { Log.Info("SQLiteEX", e.Message); return(false); } }
public bool InsertIntoWaluta(Waluta waluta) { try { using (var connection = new SQLiteConnection(System.IO.Path.Combine(folder, "Waluty.db"))) { connection.Insert(waluta); return(true); } } catch (SQLiteException e) { Log.Info("SQLiteEX", e.Message); return(false); } }
void UpdateData(List <TabelaC.RootObject> mItems) { for (int i = 0; i < mItems[0].rates.Count; i++) { Waluta awaluta = new Waluta() { Id = i, Data = DateTime.Parse(mItems[0].effectiveDate), Nazwa = mItems[0].rates[i].currency, Kod = mItems[0].rates[i].code, Kupno = mItems[0].rates[i].bid, Sprzedaz = mItems[0].rates[i].ask }; db.updateWaluta(awaluta); } mWaluta = db.selectWaluta(); ListViewAdapter adapter = new ListViewAdapter(this, mWaluta); mListView.Adapter = adapter; }
void AddData(List <TabelaA.RootObject> mItems) { for (int i = 0; i < mItems[0].rates.Count; i++) { Waluta awaluta = new Waluta() { Id = i, Data = DateTime.Parse(mItems[0].effectiveDate), Nazwa = mItems[0].rates[i].currency, Kod = mItems[0].rates[i].code, Średni = mItems[0].rates[i].mid }; db.InsertIntoWaluta(awaluta); } mClient1 = new WebClient(); mUrl1 = new System.Uri("http://api.nbp.pl/api/exchangerates/tables/c/?format=json"); mClient1.DownloadDataAsync(mUrl1); mClient1.DownloadDataCompleted += MClient_DownloadDataCompleted1; }