//Buy cryptocurrency public void newBuy() { if (PriceUsd != null) { var test = float.Parse(PriceUsd); var test2 = float.Parse(SelectedCrypto.PriceUsd.Replace("$", ""), CultureInfo.InvariantCulture.NumberFormat); float yourbuy = test / test2; DateTime localDate = DateTime.Now; Date = localDate.ToString(); BuySellModel BuyAsset = new BuySellModel(selectedCrypto.Name, PriceUsd, yourbuy.ToString(), SelectedCrypto.ImageUrl, Date); //Add data for push on sqlite CryptoModelDAL.InsertIfNotExistS(BuyAsset); //Push data on sqlite } }
public static bool DeleteBuyAsset(BuySellModel c) { bool b = false; using (SQLiteConnection db = DbConnection.GetConnection()) { lock (DbConnection.Locker) { foreach (BuySellModel u in db.Table <BuySellModel>()) { if (u.ID == c.ID) { db.Delete(u); } } } } return(b); }
public static int InsertIfNotExistS(BuySellModel s) { int result = 0; int test = 0; using (SQLiteConnection db = DbConnection.GetConnection()) { lock (DbConnection.Locker) { if (!db.Table <BuySellModel>().Any(a => a.Name == s.Name && a.PriceUsd == s.PriceUsd)) { if ((test = db.Insert(s)) > 0) { result = s.ID; } } } } return(result); }
//Delete asset item list when click and accept public void DoSomething() { Asset = SelectedMe; CryptoModelDAL.DeleteBuyAsset(Asset); }