public static void WriteCurrentLoggedPersonalFincanceToVariables(PersonalFinanceModel owner) { // Write to the local static CompanyVariables the data so it // can be used and displayed on the application CompanyVariables.CompanyName = owner.OwnerName; CompanyVariables.Currency = owner.Currency; CompanyVariables.CurrentLoggedInUserID = owner.LinkedUserID; }
public static void SaveNewPersonalFincance(PersonalFinanceModel owner) { using (IDbConnection cnn = new SQLiteConnection(LoadConnectionString())) { cnn.Execute("insert into PersonalFinances (LinkedUserID, OwnerName, TotalIncome, Expenses, HouseRents, Debts, Currency, BusinessType)" + " values (@LinkedUserID, @OwnerName, @TotalIncome, @Expenses, @HouseRents, @Debts, @Currency, @BusinessType)", owner); } }
private void CreateCompanyModel() { PersonalFinanceModel owner = new PersonalFinanceModel(); owner.OwnerName = ownerNameTextBox.Text; owner.TotalIncome = double.Parse(ownerTotalIncome.Text); owner.Expenses = double.Parse(expensesTextBox.Text); owner.Currency = (string)currencyComboBox.SelectedItem; owner.LinkedUserID = CompanyVariables.CurrentLoggedInUserID; owner.HouseRents = double.Parse(houseRentsTextBox.Text); owner.Debts = double.Parse(debtsTextBox.Text); owner.TotalSpending += double.Parse(owner.CurrentMonthSpent); SqliteDataAccess.UpdateCompanyType(currentUser, "PersonalFinance"); SqliteDataAccess.SaveNewPersonalFincance(owner); IMClassLibrary.Helper.HelperClass.WriteCurrentLoggedPersonalFincanceToVariables(owner); }