// GET: Transactions/Details/5
public ActionResult Details(string id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
// Get an instance of current transaction
Transaction Transaction = db.Transactions.Find(id);
if (Transaction == null)
{
return(HttpNotFound());
}
//find most recent transactions
var transactions = db.Transactions.Where(t => t.TransactionType == Transaction.TransactionType).Where(t => t.BankAccountID == Transaction.BankAccountID).OrderByDescending(t => t.Date).Take(5);
// Populate view model and load the final view
TransactionsDetailsViewModel tdvm = new TransactionsDetailsViewModel();
tdvm.Transaction = Transaction;
tdvm.Transactions = transactions.ToList();
return(View(tdvm));
}
public TransactionDetailsPage(IPageService pageService, IRepository repository, TransactionDto transaction)
{
InitializeComponent();
this.pageService = pageService;
this.repository = repository;
transDetailVM = new TransactionsDetailsViewModel(pageService, repository, transaction);
BindingContext = transDetailVM;
}
public ActionResult Details(int id, string accountNumber)
{
var transaction = unitOfWork.Transactions.GetTransaction(id);
var viewModel = new TransactionsDetailsViewModel()
{
Transactions = transaction,
AccountNumber = accountNumber
};
return(View(viewModel));
}
// GET: Transactions
public ActionResult Index(string accountNumber)
{
var bankAccount = unitOfWork.BankAccounts.GetBankAccountWithTransactions(accountNumber);
var transactions = bankAccount.DebitTransactions.Concat(bankAccount.CreditTransactions);
var orderedTransactions = transactions.OrderByDescending(t => t.ValueDateTime);
var viewModel = new TransactionsDetailsViewModel()
{
Transactions = orderedTransactions,
AccountNumber = accountNumber
};
return(View(viewModel));
}
// GET: Transactions/Details/5
public ActionResult Details(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
Transaction transaction = db.Transactions.Find(id);
if (transaction == null)
{
return(HttpNotFound());
}
if (transaction.CheckingAccountAffected != null)
{
CheckingAccount checkingAccount = transaction.CheckingAccountAffected;
var query = from t in checkingAccount.Transactions
where t.TransactionType.Equals(transaction.TransactionType)
select t;
query.OrderBy(t => t.TransactionDate);
List <Transaction> prelist = query.ToList();
List <Transaction> list = new List <Transaction>();
if (prelist.Count() == 1)
{
list.Add(prelist[0]);
}
else if (prelist.Count() == 2)
{
list.Add(prelist[0]); list.Add(prelist[1]);
}
else if (prelist.Count() == 3)
{
list.Add(prelist[0]); list.Add(prelist[1]); list.Add(prelist[2]);
}
else if (prelist.Count() == 4)
{
list.Add(prelist[0]); list.Add(prelist[1]); list.Add(prelist[2]); list.Add(prelist[3]);
}
else
{
list.Add(prelist[0]); list.Add(prelist[1]); list.Add(prelist[2]); list.Add(prelist[3]); list.Add(prelist[4]);
}
TransactionsDetailsViewModel model = new TransactionsDetailsViewModel {
TransactionID = id, Transaction = transaction, FiveTransactions = list
};
return(View(model));
}
else if (transaction.SavingsAccountAffected != null)
{
SavingsAccount savingsAccount = transaction.SavingsAccountAffected;
var query = from t in savingsAccount.Transactions
where t.TransactionType.Equals(transaction.TransactionType)
select t;
query.OrderBy(t => t.TransactionDate);
List <Transaction> prelist = query.ToList();
List <Transaction> list = new List <Transaction>();
if (prelist.Count() == 1)
{
list.Add(prelist[0]);
}
else if (prelist.Count() == 2)
{
list.Add(prelist[0]); list.Add(prelist[1]);
}
else if (prelist.Count() == 3)
{
list.Add(prelist[0]); list.Add(prelist[1]); list.Add(prelist[2]);
}
else if (prelist.Count() == 4)
{
list.Add(prelist[0]); list.Add(prelist[1]); list.Add(prelist[2]); list.Add(prelist[3]);
}
else
{
list.Add(prelist[0]); list.Add(prelist[1]); list.Add(prelist[2]); list.Add(prelist[3]); list.Add(prelist[4]);
}
TransactionsDetailsViewModel model = new TransactionsDetailsViewModel {
TransactionID = id, Transaction = transaction, FiveTransactions = list
};
return(View(model));
}
else if (transaction.IRAccountAffected != null)
{
IRAccount iRAccount = transaction.IRAccountAffected;
var query = from t in iRAccount.Transactions
where t.TransactionType.Equals(transaction.TransactionType)
select t;
query.OrderBy(t => t.TransactionDate);
List <Transaction> prelist = query.ToList();
List <Transaction> list = new List <Transaction>();
if (prelist.Count() == 1)
{
list.Add(prelist[0]);
}
else if (prelist.Count() == 2)
{
list.Add(prelist[0]); list.Add(prelist[1]);
}
else if (prelist.Count() == 3)
{
list.Add(prelist[0]); list.Add(prelist[1]); list.Add(prelist[2]);
}
else if (prelist.Count() == 4)
{
list.Add(prelist[0]); list.Add(prelist[1]); list.Add(prelist[2]); list.Add(prelist[3]);
}
else
{
list.Add(prelist[0]); list.Add(prelist[1]); list.Add(prelist[2]); list.Add(prelist[3]); list.Add(prelist[4]);
}
TransactionsDetailsViewModel model = new TransactionsDetailsViewModel {
TransactionID = id, Transaction = transaction, FiveTransactions = list
};
return(View(model));
}
else
{
StockPortfolio stockPortfolio = transaction.StockPortfolioAffected;
var query = from t in stockPortfolio.Transactions
where t.TransactionType.Equals(transaction.TransactionType)
select t;
query.OrderBy(t => t.TransactionDate);
List <Transaction> prelist = query.ToList();
List <Transaction> list = new List <Transaction>();
if (prelist.Count() == 1)
{
list.Add(prelist[0]);
}
else if (prelist.Count() == 2)
{
list.Add(prelist[0]); list.Add(prelist[1]);
}
else if (prelist.Count() == 3)
{
list.Add(prelist[0]); list.Add(prelist[1]); list.Add(prelist[2]);
}
else if (prelist.Count() == 4)
{
list.Add(prelist[0]); list.Add(prelist[1]); list.Add(prelist[2]); list.Add(prelist[3]);
}
else
{
list.Add(prelist[0]); list.Add(prelist[1]); list.Add(prelist[2]); list.Add(prelist[3]); list.Add(prelist[4]);
}
TransactionsDetailsViewModel model = new TransactionsDetailsViewModel {
TransactionID = id, Transaction = transaction, FiveTransactions = list
};
return(View(model));
}
}
private void RefreshTransactions(TransactionsDetailsViewModel obj) => RefreshTransactions();
