//Create DataBase For CoffeeSettings public void CreateDataBase() { try { using (var connection = new SQLiteConnection(System.IO.Path.Combine(_folder, "CoffeeSettings.db"))) { //Create/Load DB //connection.DeleteAll<CoffeeSettings>(); //Clean the DB connection.CreateTable <CoffeeSettings>(); //Fill DB If Empty if (!connection.Table <CoffeeSettings>().Any()) { CoffeeSettings coffeeSettings = new CoffeeSettings { Price = 1.00M, CoffeeName = "SmallCoffee", CoffeeQuantity = 100, MilkQuantity = 0, CoffeeStregth = 3 }; connection.Insert(coffeeSettings); coffeeSettings = new CoffeeSettings() { Price = 1.50M, CoffeeName = "LargeCoffee", CoffeeQuantity = 150, MilkQuantity = 0, CoffeeStregth = 3 }; connection.Insert(coffeeSettings); coffeeSettings = new CoffeeSettings() { Price = 2.00M, CoffeeName = "LatteMacchiato", CoffeeQuantity = 20, MilkQuantity = 130, CoffeeStregth = 3 }; connection.Insert(coffeeSettings); coffeeSettings = new CoffeeSettings() { Price = 2.00M, CoffeeName = "Cappuccino", CoffeeQuantity = 50, MilkQuantity = 100, CoffeeStregth = 3 }; connection.Insert(coffeeSettings); } } } catch (SQLException ex) { Log.Info("SQLiteEx", ex.Message); } }
// ReSharper disable once UnusedMember.Global public bool DeleteTableCoffeeSettings(CoffeeSettings coffeeSettings) { try { using (var connection = new SQLiteConnection(System.IO.Path.Combine(_folder, "CoffeeSettings.db"))) { connection.Delete(coffeeSettings); return(true); } } catch (SQLException ex) { Log.Info("SQLiteEx", ex.Message); return(false); } }
public void UpdateTableCoffeeSettings(CoffeeSettings coffeeSettings) { try { using (var connection = new SQLiteConnection(System.IO.Path.Combine(_folder, "CoffeeSettings.db"))) { connection.Query <CoffeeSettings>( "UPDATE CoffeeSettings SET CoffeeQuantity=?,MilkQuantity=?,CoffeeStregth=? WHERE CoffeeName=?", coffeeSettings.CoffeeQuantity, coffeeSettings.MilkQuantity, coffeeSettings.CoffeeStregth, coffeeSettings.CoffeeName); } } catch (SQLException ex) { Log.Info("SQLiteEx", ex.Message); } }