public static void FillDatabase()
{
List <Category> categories = new List <Category>
{
new Category("Non-alcohol"),
new Category("Alcohol")
};
DatabaseHandler.Instance().GetConnection().InsertAll(categories);
}
public static void FillDatabase()
{
List <Cocktail> cocktails = new List <Cocktail>
{
new Cocktail("43 Aardbeien", "Stamp de aardbeien fijn en doe deze in een cocktailglas met ijs. Schenk vervolgens de ingredienten in het glas en roer stevig.", 12.7, 1, 1, "https://www.cocktailgids.nl/images/43-aardbeien.jpg"),
new Cocktail("43 Bitter", "Goed shaken met ijs en serveren in een cocktailglas.", 24.9, 1, 1, "https://www.licor43.nl/wp-content/uploads/2016/06/balon-43_1048x1048_White-V1-533x0-c-default.jpg"),
new Cocktail("43 Blanco", "Schudden en schenken over ijsblokjes", 8, 1, 1, "https://via.placeholder.com/1920x1080")
};
DatabaseHandler.Instance().GetConnection().InsertAll(cocktails);
}
public static void FillDatabase()
{
List <User> users = new List <User>
{
new User("minoruser", "password", new DateTime(2001, 4, 13)),
new User("majoruser", "pass", new DateTime(1999, 3, 23)),
new User("jurriaan", "roelen", new DateTime(2000, 4, 4))
};
DatabaseHandler.Instance().GetConnection().InsertAll(users);
}
public static List <Cocktail> GetAll()
{
if (DatabaseHandler.Instance().currentUser.IsLock)
{
return(DatabaseHandler.Instance().GetConnection().Query <Cocktail>("SELECT * FROM Cocktail WHERE Category = 2 OR AlcoholPercentage = 0"));
}
else
{
return(DatabaseHandler.Instance().GetConnection().Query <Cocktail>("SELECT * FROM Cocktail"));
}
}
public static User Register(string username, string password, DateTime birthDate)
{
//Check if username is unique
if (Query("SELECT * FROM User WHERE Username = ?", new object[] { username }) != null)
{
return(null);
}
User u = new User(username, password, birthDate);
DatabaseHandler.Instance().GetConnection().Insert(u);
return(Query("SELECT * FROM User WHERE Username = ? AND BirthDate = ?", new object[] { username, birthDate }));
}
public static void FillDatabase()
{
List <Ingredient> ingredients = new List <Ingredient>
{
new Ingredient("Wodka"),
new Ingredient("Licor 43"),
new Ingredient("Cointreau"),
new Ingredient("Aardbeien"),
new Ingredient("7 Up"),
new Ingredient("Ijs"),
new Ingredient("Kruidenbitter"),
new Ingredient("Melk")
};
DatabaseHandler.Instance().GetConnection().InsertAll(ingredients);
}
private async void LoginBtn_Clicked(object sender, EventArgs e)
{
if (UsernameBox.Text.Length > 0 && PasswordBox.Text.Length > 0)
{
User user = User.Login(UsernameBox.Text, PasswordBox.Text);
if (user == null)
{
await DisplayAlert("No Access", "The username and password combination is incorrect", "OK");
}
else
{
DatabaseHandler.Instance().currentUser = user;
await Navigation.PushAsync(new MainPage());
}
}
else
{
await DisplayAlert("No Input", "Please provide an username and password", "OK");
}
}
public static void FillDatabase()
{
List <Glass> glasses = new List <Glass>
{
new Glass("Onbekend"),
new Glass("Gin tonic"),
new Glass("Hurricane"),
new Glass("Martini"),
new Glass("Margarita"),
new Glass("Bacardi"),
new Glass("Schot Zwiedel"),
new Glass("Royal Leerdam"),
new Glass("Longdrink"),
new Glass("Shot"),
new Glass("Tiki"),
new Glass("Tumbler")
};
DatabaseHandler.Instance().GetConnection().InsertAll(glasses);
}
public static void FillDatabase()
{
List <CocktailIngredient> cocktailIngredients = new List <CocktailIngredient>
{
new CocktailIngredient(1, 1, "30 ml"),
new CocktailIngredient(1, 2, "10 ml"),
new CocktailIngredient(1, 3, "10 ml"),
new CocktailIngredient(1, 4, "2"),
new CocktailIngredient(1, 5, "1"),
new CocktailIngredient(1, 6, "1"),
new CocktailIngredient(2, 2, "60 ml"),
new CocktailIngredient(2, 7, "30 ml"),
new CocktailIngredient(2, 6, "2"),
new CocktailIngredient(3, 2, "30 ml"),
new CocktailIngredient(3, 6, "90 ml"),
new CocktailIngredient(3, 8, "1")
};
DatabaseHandler.Instance().GetConnection().InsertAll(cocktailIngredients);
}
public LoginPage()
{
InitializeComponent();
if (DatabaseHandler.Instance().GetConnection().Table <Allergy>().Count() == 0)
{
Allergy.FillDatabase();
}
if (DatabaseHandler.Instance().GetConnection().Table <AllergyIngredient>().Count() == 0)
{
AllergyIngredient.FillDatabase();
}
if (DatabaseHandler.Instance().GetConnection().Table <Category>().Count() == 0)
{
Category.FillDatabase();
}
if (DatabaseHandler.Instance().GetConnection().Table <Cocktail>().Count() == 0)
{
Cocktail.FillDatabase();
}
if (DatabaseHandler.Instance().GetConnection().Table <CocktailIngredient>().Count() == 0)
{
CocktailIngredient.FillDatabase();
}
if (DatabaseHandler.Instance().GetConnection().Table <Glass>().Count() == 0)
{
Glass.FillDatabase();
}
if (DatabaseHandler.Instance().GetConnection().Table <Ingredient>().Count() == 0)
{
Ingredient.FillDatabase();
}
if (DatabaseHandler.Instance().GetConnection().Table <User>().Count() == 0)
{
User.FillDatabase();
}
}
public static User Query(string query, object[] param)
{
return(DatabaseHandler.Instance().GetConnection().FindWithQuery <User>(query, param));
}
public App()
{
InitializeComponent();
DatabaseHandler.Instance();
MainPage = new NavigationPage(new LoginPage());
}