private IEnumerable <string> GetAllCategories(ITransactionsService transactionsService)
{
return(transactionsService.GetAll(x => !string.IsNullOrEmpty(x.Category))
.Select(x => x.Category)
.OrderBy(x => x)
.Distinct());
}
public IActionResult Get()
{
var accounts = _accountService.GetAll().ToList();
if (accounts.Count == 0)
{
return(Ok(new List <Models.Account>()));
}
foreach (var account in accounts)
{
var transactions = _transactionsService.GetAll(account.AccountId).ToList();
account.Transactions = transactions;
}
return(Ok(accounts));
}
public IEnumerable <Transaction> GetTransactionsFiltered(ITransactionsService transactionsService)
{
var transactions = transactionsService
.GetAll(x => ApplyDateFilter(x) &&
ApplyCategoriesFilter(x) &&
ApplySearchFilter(x) &&
!x.Ignored);
var allCats = GetAllCategories(transactionsService);
this.Categories = this.Categories.Union(allCats.Select(x => new SelectListItem()
{
Text = x, Value = x
})).ToList();
return(transactions);
}
public IActionResult Index()
{
var all = _transactionsService.GetAll()
.Where(x => x.Product.ExciseCode == "E420")
.Select(x => new TransactionsViewModel
{
Flowmeter = x.DeviceId,
TransactionNumber = x.Sequence,
EndDate = x.StopTime.ToString(),
Receipt = x.Product.Name,
DensityAt15 = x.Density15.ToString(),
Mass = x.Mass.ToString(),
VolumeAt15 = x.StdVolume.ToString(),
FlowDirection = x.Direction.Direction.ToString()
});
var byDate = all.Where(x => x.FlowDirection == "OUTPUT")
.Select(x => new
{
Date = x.EndDate.Substring(0, 10),
Volume15 = decimal.Parse(x.VolumeAt15),
Mass = decimal.Parse(x.Mass),
})
.GroupBy(x => x.Date)
.Select(g => new TransactionsByDateViewModel
{
Date = g.Key,
Volume15 = g.Sum(x => x.Volume15).ToString(),
Mass = g.Sum(x => x.Mass).ToString()
});
var modelsContainer = new List <object>();
modelsContainer.Add(all);
modelsContainer.Add(byDate);
return(this.View(modelsContainer));
}
public async Task <IEnumerable <TransactionModel> > GetAll(int month, int year)
{
var transactions = await _transactionService.GetAll(month, year);
return(_mapper.Map <IEnumerable <TransactionModel> >(transactions));
}
public IActionResult GetAll()
{
var transactions = _transactionsService.GetAll();
return(Ok(transactions));
}
