private static void CreateDatabase() { try { string folderPath = Environment.GetFolderPath(Environment.SpecialFolder.Personal); System.IO.Directory.CreateDirectory(folderPath); string databaseFilePath = System.IO.Path.Combine(folderPath, "FinancialProfile.db"); using (var db = new SQLite.Net.SQLiteConnection(new SQLite.Net.Platform.XamarinIOS.SQLitePlatformIOS(), databaseFilePath)) { db.CreateTable <FinancialProfileDomain>(); if (db.Table <FinancialProfileDomain>().Count() == 0) { var FinancialProfile = new FinancialProfileDomain() { Question = "When is your birthday?", DataType = "DateTime" }; db.Insert(FinancialProfile); var question = db.Get <FinancialProfileDomain>(1); FinancialProfile = new FinancialProfileDomain() { Question = "What is your net worth?", DataType = "Int" }; db.Insert(FinancialProfile); FinancialProfile = new FinancialProfileDomain() { Question = "How much do you make each month after taxes including 1099, w2, 401k, and ira contributions?", DataType = "Int" }; db.Insert(FinancialProfile); FinancialProfile = new FinancialProfileDomain() { Question = "How much do you spend each month on your house?", DataType = "Int" }; db.Insert(FinancialProfile); FinancialProfile = new FinancialProfileDomain() { Question = "How much do you spend each month on your car?", DataType = "Int" }; db.Insert(FinancialProfile); FinancialProfile = new FinancialProfileDomain() { Question = "How much do you spend each month on everything else?", DataType = "Int" }; db.Insert(FinancialProfile); } } } catch (SQLiteException ex) { var t = ex; } }
static public Product GetProduct(string Name) { return(SQConnectionProduct.Get <Product>(Name)); }
static public Alcohol GetAlcohol(string Name) { return(SQConnectionAlcohol.Get <Alcohol>(Name)); }