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