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; } }
public override void ViewDidLoad() { base.ViewDidLoad(); buttonSave.TouchUpInside += HandleTouchUpInsideSave; record = repository.Get(1); labelQuestion.Text = record.Question; // Perform any additional setup after loading the view, typically from a nib. }
private void HandleTouchUpInsideSave(object sender, EventArgs ea) { record.Answer = DateTime.Parse(dateBirthday.Date.ToString()).ToShortDateString(); repository.Update(record); UIStoryboard storyboard = UIStoryboard.FromName("Main", null); var controller = (OtherQuestionController)storyboard.InstantiateViewController("OtherQuestionController"); for (int i = 2; i < 7; i++) { record = repository.Get(i); if (record.Answer == null || record.Answer == "") { controller.Id = i; this.PresentViewController(controller, true, null); break; } if (i == 7) { controller.Id = 7; this.PresentViewController(controller, true, null); break; } } }
public FinancialProfileDomain Update(FinancialProfileDomain item) { db.Update(item); return(Get(item.Id)); }
private void GetQuestion(int Id) { record = repository.Get(Id); }