public static DataTableReader SelectUserByEmail(string email) { var attrValue = DB_IO.AttrValue(); attrValue[UserEnt.email] = email; return(DB_IO.SelectReader(DB_IO.DB_Interface.pr_select_users, attrValue)); }
public static int SelectCategoryTypeIdByDesignation(string designation) { var attrValue = DB_IO.AttrValue(); attrValue[CategoryTypeEnt.designation] = designation; return((int)DB_IO.SelectScalar(DB_IO.DB_Interface.pr_select_category_types, attrValue)); }
// ---------------------------------------------------------------------------------------------- // TRANSACTIONS --------------------------------------------------------------------------------- // ---------------------------------------------------------------------------------------------- public static DataTableReader SelectAccountTransactions(int account_id) { var attrValue = DB_IO.AttrValue(); attrValue[DB_API.TransactionEnt.account_id] = account_id; return(DB_IO.SelectReader(DB_IO.DB_Interface.pr_select_transactions, attrValue)); }
public static DataTableReader SelectUserMoneyAccounts(string email) { var attrValue = DB_IO.AttrValue(); attrValue[MoneyAccountEnt.user_email] = email; return(DB_IO.SelectReader(DB_IO.DB_Interface.pr_select_user_money_accounts, attrValue)); }
public static DataTableReader SelectMoneyAccountUsers(int account_id) { var attrValue = DB_IO.AttrValue(); attrValue[MoneyAccountEnt.account_id] = account_id; return(DB_IO.SelectReader(DB_IO.DB_Interface.pr_select_user_money_accounts, attrValue)); }
public static void DeleteMoneyAccount(int account_id) { var attrValue = DB_IO.AttrValue(); attrValue[MoneyAccountEnt.account_id] = account_id; DB_IO.Delete(DB_IO.DB_Interface.pr_delete_money_account, attrValue); }
// ---------------------------------------------------------------------------------------------- // LOANS ---------------------------------------------------------------------------------------- // ---------------------------------------------------------------------------------------------- public static DataTableReader SelectAccountLoans(int account_id) { var attrValue = DB_IO.AttrValue(); attrValue[CategoryEnt.account_id] = account_id; return(DB_IO.SelectReader(DB_IO.DB_Interface.pr_select_loans, attrValue)); }
// ---------------------------------------------------------------------------------------------- // USERS ---------------------------------------------------------------------------------------- // ---------------------------------------------------------------------------------------------- public static bool ExistsUser(string email) { var attrValue = DB_IO.AttrValue(); attrValue[DB_API.UserEnt.email] = email; return(DB_IO.Exists(DB_IO.DB_Interface.pr_exists_user, attrValue)); }
public static int SelectTransactionTypeIdByName(string designation) { var attrValue = DB_IO.AttrValue(); attrValue[TransactionTypeEnt.designation] = designation; return((int)DB_IO.SelectScalar(DB_IO.DB_Interface.pr_select_transaction_types, attrValue)); }
public static DataTableReader SelectWallet(int wallet_id) { var attrValue = DB_IO.AttrValue(); attrValue[DB_API.WalletEnt.wallet_id] = wallet_id; return(DB_IO.SelectReader(DB_IO.DB_Interface.pr_select_wallets, attrValue)); }
public static DataTableReader SelectBudget(int budget_id) { var attrValue = DB_IO.AttrValue(); attrValue[DB_API.BudgetEnt.budget_id] = budget_id; return(DB_IO.SelectReader(DB_IO.DB_Interface.pr_select_budgets, attrValue)); }
public static DataTableReader SelectAccountGoals(int account_id) { var attrValue = DB_IO.AttrValue(); attrValue[DB_API.GoalEnt.account_id] = account_id; return(DB_IO.SelectReader(DB_IO.DB_Interface.pr_select_goals, attrValue)); }
public static void DeleteUser(string email) { var attrValue = DB_IO.AttrValue(); attrValue[UserEnt.email] = email; DB_IO.Delete(DB_IO.DB_Interface.pr_delete_user, attrValue); }
public static void DeleteTransaction(int transaction_id) { var attrValue = DB_IO.AttrValue(); attrValue[DB_API.TransactionEnt.transaction_id] = transaction_id; DB_IO.Delete(DB_IO.DB_Interface.pr_delete_transaction, attrValue); }
// ---------------------------------------------------------------------------------------------- // MONEY ACCOUNTS ------------------------------------------------------------------------------- // ---------------------------------------------------------------------------------------------- public static bool ExistsMoneyAccount(int account_id) { var attrValue = DB_IO.AttrValue(); attrValue[DB_API.MoneyAccountEnt.account_id] = account_id; return(DB_IO.Exists(DB_IO.DB_Interface.pr_exists_money_account, attrValue)); }
// ---------------------------------------------------------------------------------------------- // STOCKS --------------------------------------------------------------------------------------- // ---------------------------------------------------------------------------------------------- public static DataTableReader SelectAllAccountPurchasedStocks(int account_id) { var attrValue = DB_IO.AttrValue(); attrValue[DB_API.StockEnt.account_id] = account_id; return(DB_IO.SelectReader(DB_IO.DB_Interface.pr_select_purchased_stocks, attrValue)); }
public static string SelectCategoryTypeDesignationById(int category_type_id) { var attrValue = DB_IO.AttrValue(); attrValue[CategoryTypeEnt.category_type_id] = category_type_id; return((string)DB_IO.SelectScalar(DB_IO.DB_Interface.pr_select_category_types, attrValue)); }
public static string SelectTransactionTypeNameById(int transaction_tpe_id) { var attrValue = DB_IO.AttrValue(); attrValue[TransactionTypeEnt.transaction_type_id] = transaction_tpe_id; return((string)DB_IO.SelectScalar(DB_IO.DB_Interface.pr_select_transaction_types, attrValue)); }
public static DataTableReader SelectCategory(int category_id) { var attrValue = DB_IO.AttrValue(); attrValue[CategoryEnt.category_id] = category_id; return(DB_IO.SelectReader(DB_IO.DB_Interface.pr_select_categories, attrValue)); }
public static int SelectRecurenceIdbyDesignation(string designation) { var attrValue = DB_IO.AttrValue(); attrValue[RecurrenceEnt.designation] = designation; Console.WriteLine(DB_IO.SelectScalar(DB_IO.DB_Interface.pr_select_recurrences, attrValue)); return((int)DB_IO.SelectScalar(DB_IO.DB_Interface.pr_select_recurrence_id, attrValue)); }
public static DataTableReader SelectWalletByName(int account_id, string name) { var attrValue = DB_IO.AttrValue(); attrValue[DB_API.WalletEnt.account_id] = account_id; attrValue[DB_API.WalletEnt.name] = name; return(DB_IO.SelectReader(DB_IO.DB_Interface.pr_select_wallets, attrValue)); }
public static void MoneyAccountRemoveUser(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.Delete(DB_IO.DB_Interface.pr_money_account_remove_user, attrValue); }
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); }
// ---------------------------------------------------------------------------------------------- // STATS ---------------------------------------------------------------------------------------- // ---------------------------------------------------------------------------------------------- public static DataTableReader SelectAnnualStatistics(int account_id, int year) { var attrValue = DB_IO.AttrValue(); attrValue[DB_API.Statistics.account_id] = account_id; attrValue[DB_API.Statistics.year] = year; return(DB_IO.SelectFromUDFTable(DB_IO.DB_Interface.udf_annual_statistics, attrValue)); }
public static bool ExistsLoan(int account_id, string name) { var attrValue = new Dictionary <System.Enum, Object> { { LoanEnt.account_id, account_id }, { LoanEnt.name, name } }; return(DB_IO.Exists(DB_IO.DB_Interface.pr_select_loans, attrValue)); }
public static void DeleteStocksByCompany(int accountID, string company, double purchasePrice, double askPrice) { var attrValue = DB_IO.AttrValue(); attrValue[DB_API.StockEnt.account_id] = accountID; attrValue[DB_API.StockEnt.company] = company; attrValue[DB_API.StockEnt.purchase_price] = purchasePrice; attrValue[DB_API.StockEnt.ask_price] = askPrice; DB_IO.Delete(DB_IO.DB_Interface.pr_delete_purchased_stocks, attrValue); }
public static void DeleteStockByTicker(int accountID, int ticker, double purchasePrice, double askPrice) { var attrValue = DB_IO.AttrValue(); attrValue[DB_API.StockEnt.account_id] = accountID; attrValue[DB_API.StockEnt.ticker] = ticker; attrValue[DB_API.StockEnt.purchase_price] = purchasePrice; attrValue[DB_API.StockEnt.ask_price] = askPrice; DB_IO.Delete(DB_IO.DB_Interface.pr_delete_purchased_stocks, attrValue); }
public static DataTableReader SelectLoan(int account_id, string loan_name) { var attrValue = new Dictionary <System.Enum, Object> { { LoanEnt.account_id, account_id }, { LoanEnt.name, loan_name } }; return(DB_IO.SelectReader(DB_IO.DB_Interface.pr_select_loans, attrValue)); }
// ---------------------------------------------------------------------------------------------- // BUDGETS -------------------------------------------------------------------------------------- // ---------------------------------------------------------------------------------------------- public static DataTableReader SelectUserCategoryBudgets(int account_id, int category_id) { var attrValue = new Dictionary <System.Enum, Object> { { BudgetEnt.account_id, account_id }, { BudgetEnt.category_id, category_id } }; return(DB_IO.SelectReader(DB_IO.DB_Interface.pr_select_budgets_by_category_id, attrValue)); }
public static DataTableReader SelectGoal(int account_id, string goal_name) { var attrValue = new Dictionary <System.Enum, Object> { { GoalEnt.account_id, account_id }, { GoalEnt.name, goal_name } }; return(DB_IO.SelectReader(DB_IO.DB_Interface.pr_select_goals, attrValue)); }