// Gets all transactions public ActionResult Transactions() { // Null handling if (Session["loggedInState"] == null) { return Redirect("/403.html"); } bool state = (bool)Session["loggedInState"]; if (state == true) { // Creates the models var transModel = new TransactionModel(); var orderModel = new OrderModel(); var custModel = new CustomerModel(); var bankModel = new BankingModel(); // Gets the complete list var tl = transModel.ListTransactions(); if (tl.Count != 0) { // Attaches associated order / customer / bank to transaction foreach (var trans in tl) { // Acquires, and adds the order to transaction Order order = null; if (trans.OrderID != 0) { order = orderModel.SearchOrder(trans.OrderID); } // Acquires, and adds the customer to transaction Customer cust = null; if (trans.CustomerID != 0) { cust = custModel.SearchCustomers(trans.CustomerID); } // Acquires, and adds the bank to transaction Bank bank = null; if (trans.BankID != 0) { bank = bankModel.SearchBank(trans.BankID); } } } // Returns the list return View(tl); } else { // If not logged in return Redirect("/login.html"); } }
// Create transaction public int create(int orderID, int custID, int bankID) { // Establishes transaction model TransactionModel transModel = new TransactionModel(); // Holds the new transaction Transaction newTrans = new Transaction(); // Stored details for the transaction newTrans.DateOfOrder = DateTime.Now; newTrans.OrderID = orderID; newTrans.CustomerID = custID; newTrans.BankID = bankID; // Adds object to the database int transactionID = transModel.CreateTransaction(newTrans); // Returns the transactionID return transactionID; }