/// <summary>
/// Sets the TransactionManager form values equal to the field values of a specified transaction.
/// </summary>
/// <param name="transID">Int: transaction ID representing the transaction from which to pull field values.</param>
/// <param name="transType">Combobox: transaction type combobox.</param>
/// <param name="account">Combobox: account list combobox.</param>
/// <param name="categories">Combobox: categories list combobox.</param>
/// <param name="vendors">Combobox: vendors list combobox.</param>
/// <param name="amount">TextBox: amount text box.</param>
/// <param name="date">DateTimePicker.</param>
/// <param name="description">TextBox: description.</param>
public void LoadTransaction(int transID, ComboBox transType, ComboBox account, ComboBox categories, ComboBox vendors, TextBox amount, DateTimePicker date, TextBox description)
{
TransactionsWithNames transaction = GetTransaction(transID);
transType.SelectedIndex = transType.FindStringExact(transaction.TransactionType);
account.SelectedIndex = account.FindStringExact(transaction.Account);
amount.Text = transaction.Amount.ToString();
date.Value = transaction.TransactionDate;
categories.SelectedIndex = categories.FindStringExact(transaction.Category);
vendors.SelectedIndex = vendors.FindStringExact(transaction.Vendor);
description.Text = transaction.Description;
}
/// <summary>
/// Creates and returns a TransactionsWithNames object based on the passed transaction ID.
/// </summary>
/// <param name="transID">Int: transaction ID for which transaction field data will be used to generate the TransactionsWithNames object.</param>
/// <returns>TransactionsWithNames object filled with data matching the passed transaction ID.</returns>
private TransactionsWithNames GetTransaction(int transID)
{
TransactionsWithNames transaction = new TransactionsWithNames();
IQueryable <Transactions> transactionQuery =
from trans in Transactions
where trans.TransactionID == transID
select trans;
foreach (Transactions trans in transactionQuery)
{
transaction.TransactionID = trans.TransactionID;
transaction.TransactionType = trans.TransactionType;
transaction.Account = GetAccountName(trans.AccountID);
transaction.Amount = (decimal)trans.Amount;
transaction.TransactionDate = trans.TransactionDate;
transaction.Category = GetCategoryName(trans.CategoryID);
transaction.Vendor = GetVendorName(trans.VendorID);
transaction.Description = trans.Description;
}
return(transaction);
}
/// <summary>
/// Gets a list of TransactionsWithNames objects for the calling budget. Each object contains the details of a unique transaction.
/// </summary>
/// <returns>List TransactionsWithNames objects, each object contains the details of a unique transaction.</returns>
private List <TransactionsWithNames> GetTransactionsList()
{
List <TransactionsWithNames> transactions = new List <TransactionsWithNames>();
IQueryable <Transactions> transactionsQuery =
from trans in Transactions
orderby trans.TransactionDate descending
select trans;
foreach (Transactions item in transactionsQuery)
{
TransactionsWithNames itemToAdd = new TransactionsWithNames();
itemToAdd.TransactionID = item.TransactionID;
itemToAdd.TransactionDate = item.TransactionDate;
itemToAdd.TransactionType = item.TransactionType;
itemToAdd.Account = GetAccountName(item.AccountID);
itemToAdd.Category = GetCategoryName(item.CategoryID);
itemToAdd.Vendor = GetVendorName(item.VendorID);
itemToAdd.Amount = (decimal)item.Amount;
itemToAdd.Description = item.Description;
transactions.Add(itemToAdd);
}
return(transactions);
}
