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 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 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 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));
}
// ----------------------------------------------------------------------------------------------
// 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));
}
// ----------------------------------------------------------------------------------------------
// 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));
}
// ----------------------------------------------------------------------------------------------
// 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 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 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 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 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 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));
}
// ----------------------------------------------------------------------------------------------
// 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 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));
}
public static String SelectRecurrenceById(int id)
{
var attrValue = DB_IO.AttrValue();
attrValue[RecurrenceEnt.periodicity] = id;
var rdr = DB_IO.SelectReader(DB_IO.DB_Interface.pr_select_recurrences, attrValue);
rdr.Read();
return(rdr[RecurrenceEnt.designation.ToString()].ToString());
}
public static DataTableReader SelectFilteredTransactions(int?account_id = null, int?category_id = null,
int?wallet_id = null, int?transaction_id = null, int?transaction_type_id = null, double?min_amount = null,
double?max_amount = null, DateTime?start_date = null, DateTime?end_date = null, string location = null)
{
Console.WriteLine(account_id + ", " + category_id + ", " + wallet_id + ", " + transaction_id + ", " +
transaction_type_id + ", " + min_amount + ", " + max_amount + ", " + start_date + ", " + end_date + ", " +
location);
var attrValue = new Dictionary <System.Enum, Object>
{
{ DB_API.TransactionEnt.account_id, account_id },
{ DB_API.TransactionEnt.category_id, category_id },
{ DB_API.TransactionEnt.wallet_id, wallet_id },
{ DB_API.TransactionEnt.transaction_id, transaction_id },
{ DB_API.TransactionEnt.transaction_type_id, transaction_type_id },
{ DB_API.TransactionEnt.min_amount, min_amount },
{ DB_API.TransactionEnt.max_amount, max_amount },
{ DB_API.TransactionEnt.start_date, start_date },
{ DB_API.TransactionEnt.end_date, end_date },
{ DB_API.TransactionEnt.location, location }
};
return(DB_IO.SelectReader(DB_IO.DB_Interface.pr_select_transactions, attrValue));
}
public static DataTableReader SelectAllStocks()
{
return(DB_IO.SelectReader(DB_IO.DB_Interface.pr_select_stocks, DB_IO.AttrValue()));
}
public static DataTableReader SelectAllCategoryTypes()
{
return(DB_IO.SelectReader(DB_IO.DB_Interface.pr_select_category_types, DB_IO.AttrValue()));
}
public static DataTableReader SelectAllTransactionTypes()
{
return(DB_IO.SelectReader(DB_IO.DB_Interface.pr_select_transaction_types, DB_IO.AttrValue()));
}
// ----------------------------------------------------------------------------------------------
// RECURRENCE -----------------------------------------------------------------------------------
// ----------------------------------------------------------------------------------------------
public static DataTableReader SelectAllRecurrences()
{
return(DB_IO.SelectReader(DB_IO.DB_Interface.pr_select_recurrences, DB_IO.AttrValue()));
}