public static void MoneyAccountAddUser(int account_id, string user_email) { var attrValue = DB_IO.AttrValue(); attrValue[MoneyAccountEnt.account_id] = account_id; attrValue[MoneyAccountEnt.user_email] = user_email; DB_IO.Insert(DB_IO.DB_Interface.pr_money_account_add_user, attrValue); }
public static void DeleteCategory(int category_id, int account_id) { var attrValue = new Dictionary <System.Enum, Object> { { CategoryEnt.category_id, category_id }, { CategoryEnt.account_id, account_id } }; DB_IO.Insert(DB_IO.DB_Interface.pr_delete_category, attrValue); }
public static void InsertPurchasedStock(int account_id, string company, double purchase_price) { var attrValue = new Dictionary <System.Enum, Object> { { StockEnt.account_id, account_id }, { StockEnt.company, company }, { StockEnt.purchase_price, purchase_price }, }; DB_IO.Insert(DB_IO.DB_Interface.pr_insert_purchased_stock, attrValue); }
public static void AddCategoryToAccount(int account_id, string name, int type_id) { var attrValue = new Dictionary <System.Enum, Object> { { CategoryEnt.account_id, account_id }, { CategoryEnt.name, name }, { CategoryEnt.category_type_id, type_id } }; DB_IO.Insert(DB_IO.DB_Interface.pr_insert_category, attrValue); }
public static void AddSubCategoryToAccount(int parentOrSisterCategory_id, int account_id, string name, int category_type) { var attrValue = new Dictionary <System.Enum, Object> { { CategoryEnt.category_id, parentOrSisterCategory_id }, { CategoryEnt.account_id, account_id }, { CategoryEnt.name, name }, { CategoryEnt.category_type_id, category_type } }; DB_IO.Insert(DB_IO.DB_Interface.pr_insert_subcategory, attrValue); }
public static void InsertMoneyAccount(string user_email, string account_name, Decimal?balance = null, Decimal?patrimony = null) { var attrValue = new Dictionary <System.Enum, Object> { { MoneyAccountEnt.user_email, user_email }, { MoneyAccountEnt.account_name, account_name }, { MoneyAccountEnt.balance, balance }, { MoneyAccountEnt.patrimony, patrimony } }; DB_IO.Insert(DB_IO.DB_Interface.pr_insert_money_account, attrValue); }
// ---------------------------------------------------------------------------------------------- // GOALS ---------------------------------------------------------------------------------------- // ---------------------------------------------------------------------------------------------- public static void InsertGoal(int account_id, int category_id, string name, double amount, DateTime term) { var attrValue = new Dictionary <System.Enum, Object> { { GoalEnt.account_id, account_id }, { GoalEnt.category_id, category_id }, { GoalEnt.amount, amount }, { GoalEnt.term, term }, { GoalEnt.name, name } }; DB_IO.Insert(DB_IO.DB_Interface.pr_insert_goal, attrValue); }
public static void InsertBudget(int account_id, int category_id, double amount, DateTime startDate, DateTime endDate) { var attrValue = new Dictionary <System.Enum, Object> { { BudgetEnt.account_id, account_id }, { BudgetEnt.category_id, category_id }, { BudgetEnt.amount, amount }, { BudgetEnt.start_date, startDate }, { BudgetEnt.end_date, endDate }, }; DB_IO.Insert(DB_IO.DB_Interface.pr_insert_budget, attrValue); }
public static void InsertLoan(int account_id, string name, double amount, double current_debt, DateTime term, double interest) { var attrValue = new Dictionary <System.Enum, Object> { { LoanEnt.account_id, account_id }, { LoanEnt.name, name }, { LoanEnt.initial_amount, amount }, { LoanEnt.current_debt, current_debt }, { LoanEnt.term, term }, { LoanEnt.interest, interest } }; DB_IO.Insert(DB_IO.DB_Interface.pr_insert_loan, attrValue); }
public static void InsertTransaction(int account_id, int category_id, int from_wallet_id, int to_wallet_id, int transaction_type_id, double amount, DateTime date, string location, string notes) { var attrValue = new Dictionary <System.Enum, Object> { { TransactionEnt.account_id, account_id }, { TransactionEnt.category_id, category_id }, { TransactionEnt.from_wallet_id, from_wallet_id }, { TransactionEnt.to_wallet_id, to_wallet_id }, { TransactionEnt.transaction_type_id, transaction_type_id }, { TransactionEnt.amount, amount }, { TransactionEnt.date, date }, { TransactionEnt.location, location }, { TransactionEnt.notes, notes }, }; DB_IO.Insert(DB_IO.DB_Interface.pr_insert_transaction, attrValue); }
public static void InsertUser(string username, string email, string fname, string mname, string lname, string cardNo, int periodicity, DateTime term, bool active) { var attrValue = new Dictionary <System.Enum, Object> { { UserEnt.user_name, username }, { UserEnt.email, email }, { UserEnt.fname, fname }, { UserEnt.mname, mname }, { UserEnt.lname, lname }, { UserEnt.card_number, cardNo }, { UserEnt.periodicity, periodicity }, { UserEnt.term, term }, { UserEnt.active_subscription, active } }; DB_IO.Insert(DB_IO.DB_Interface.pr_insert_user, attrValue); }