public Entities.Dashboard GetUserDashboard(Guid userId)
{
var transactions = _context.Set <Entities.Transaction>();
var customers = _context.Set <Entities.Customer>();
int transactionCount = transactions.Count(t => t.Customer.UserId == userId);
var customerList = customers.Where(c => c.UserId == userId)
.Select(c => new Entities.Customer
{
Id = c.Id,
ReceivableBalance = c.ReceivableBalance,
DebtBalance = c.DebtBalance,
})
.ToList();
return(new Entities.Dashboard
{
Customers = customerList,
TransactionCount = transactionCount
});
}
/// <summary>
/// sets and returns new entities which is different from main entity
/// </summary>
/// <typeparam name="TNewEntity"></typeparam>
/// <returns></returns>
protected DbSet <TNewEntity> GetEntities <TNewEntity>() where TNewEntity : EntityBase
{
return(_context.Set <TNewEntity>());
}
public PostgreSqlDbRepository(BlackCoveredLedgerDbContext context)
{
_context = context;
Entities = _context.Set <TEntity>();
}