/// <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); }