private List<TransactionViewModel> GetAllTransactions() { List<TransactionViewModel> l_tvm = new List<TransactionViewModel>(); foreach(Transaction t in db.Transactions.ToList()) { TransactionViewModel tvm = new TransactionViewModel(); tvm.username = t.Account.username; tvm.name = t.Account.first_name + " " + t.Account.last_name; decimal total = 0; foreach(TransactionItem ti in t.TransactionItems.ToList()) { total += (ti.item_price * ti.quantity); } tvm.total = total; tvm.date = t.date_of_transaction; tvm.id = t.id; tvm.transaction_status = t.TransactionStatus.value; l_tvm.Add(tvm); } return l_tvm; }
public ActionResult GetFilteredTransactions(string datebefore, string dateafter) { if (datebefore == null || dateafter == null || datebefore.Contains("undefined") || dateafter.Contains("undefined")) { return new HttpStatusCodeResult(HttpStatusCode.BadRequest); } else { DateTime d_b = Convert.ToDateTime(datebefore); DateTime d_a = Convert.ToDateTime(dateafter); if (d_b > d_a) { return new HttpStatusCodeResult(HttpStatusCode.BadRequest); } else { List<TransactionViewModel> l_tvm = new List<TransactionViewModel>(); foreach (Transaction t in db.Transactions.Where(x => DbFunctions.TruncateTime(x.date_of_transaction) <= d_a && d_b <= DbFunctions.TruncateTime(x.date_of_transaction)).OrderBy(x => x.date_of_transaction).ToList()) { TransactionViewModel tvm = new TransactionViewModel(); tvm.username = t.Account.username; tvm.name = t.Account.first_name + " " + t.Account.last_name; decimal total = 0; foreach (TransactionItem ti in t.TransactionItems.ToList()) { total += (ti.item_price * ti.quantity); } tvm.total = total; tvm.date = t.date_of_transaction; tvm.id = t.id; tvm.transaction_status = t.TransactionStatus.value; l_tvm.Add(tvm); } return PartialView("TransactionContents", l_tvm); } } }