public JsonResult GetRunningTotals(DateTime date, TransactionInquiryTypes.InquiryType inquiryType) { try { return(Json(Repo.GetTransactionRunningTotal(Utilities.ShortDateString(date), inquiryType), JsonRequestBehavior.AllowGet)); } catch (Exception ex) { Log.Error(ex.Message); throw; } }
public string GetTransactionRunningTotal(DateTime date, TransactionInquiryTypes.InquiryType inquiryType) { IQueryable <TRANSACTIONS> amount; switch (inquiryType) { case TransactionInquiryTypes.InquiryType.Expenses: amount = db.TRANSACTIONS.Where(t => t.TRANSACTION_DATE == date && t.IS_DEBIT); break; case TransactionInquiryTypes.InquiryType.Income: amount = db.TRANSACTIONS.Where(t => t.TRANSACTION_DATE == date && !t.IS_DEBIT); break; default: amount = db.TRANSACTIONS; break; } return(amount.Any() ? amount.Sum(a => a.TRANSACTION_AMOUNT).ToString(CultureInfo.CurrentCulture) : "0"); }