//Ledger
public IEnumerable <GeneralLedgerLine> GetGeneralLedgerLines(DrOrCrSide drOrCr)
{
var drCr = _db.GeneralLedgerLines
.Include(gl => gl.GeneralLedgerHeader)
.Include(gl => gl.Account)
.Where(l => l.DrCr == drOrCr)
.AsEnumerable();
return(drCr);
}
public GeneralLedgerLine CreateGeneralLedgerLine(DrOrCrSide DrCr, int accountId, decimal amount)
{
var line = new GeneralLedgerLine()
{
DrCr = DrCr,
AccountId = accountId,
Amount = amount,
};
return(line);
}
public static GeneralLedgerLine Create(Account account, DrOrCrSide drOrCr, decimal amount)
{
//Validation Rules: TODO
//Account can not be null
//Amount can not be zero or less
//DrCr should be valid
var line = new GeneralLedgerLine
{
AccountId = account.Id,
Account = account,
DrCr = drOrCr,
Amount = amount
};
return(line);
}
private static IEnumerable <MasterGeneralLedger> BuildMasterGeneralLedger(
IEnumerable <GeneralLedgerLine> generalLedgerLines, DrOrCrSide drOrCr)
{
var masterGeneralLedgers = generalLedgerLines
.Select(l => new MasterGeneralLedger
{
Id = l.Id,
TransactionNo = l.GeneralLedgerHeader.Id,
Reference = l.GeneralLedgerHeader.Description,
AccountId = l.AccountId,
AccountCode = l.Account.AccountCode.ToString(),
AccountName = l.Account.AccountName,
Date = l.GeneralLedgerHeader.Date,
Debit = drOrCr == DrOrCrSide.Dr ? l.Amount : 0,
Credit = drOrCr == DrOrCrSide.Cr ? l.Amount : 0,
});
return(masterGeneralLedgers);
}
private decimal GetDebitCreditBalance(DrOrCrSide side)
{
decimal balance = 0;
if (side == DrOrCrSide.Dr)
{
var dr = from d in GeneralLedgerLines
where d.DrCr == DrOrCrSide.Dr
select d;
balance = dr.Sum(d => d.Amount);
}
else
{
var cr = from d in GeneralLedgerLines
where d.DrCr == DrOrCrSide.Cr
select d;
balance = cr.Sum(d => d.Amount);
}
return(balance);
}
private decimal GetDebitCreditBalance(DrOrCrSide side)
{
decimal balance = 0;
if (side == DrOrCrSide.Dr)
{
var dr = from d in GeneralLedgerLines
where d.DrCr == DrOrCrSide.Dr
select d;
balance = dr.Sum(d => d.Amount);
}
else
{
var cr = from d in GeneralLedgerLines
where d.DrCr == DrOrCrSide.Cr
select d;
balance = cr.Sum(d => d.Amount);
}
return balance;
}
public GeneralLedgerLine CreateGeneralLedgerLine(DrOrCrSide DrCr, int accountId, decimal amount)
{
var line = new GeneralLedgerLine()
{
DrCr = DrCr,
AccountId = accountId,
Amount = amount,
};
return line;
}
private decimal GetDebitCreditBalance(DrOrCrSide side)
{
return(side == DrOrCrSide.Dr ?
GeneralLedgerLines.Where(l => l.DrCr == DrOrCrSide.Dr).Sum(l => l.Amount) :
GeneralLedgerLines.Where(l => l.DrCr == DrOrCrSide.Cr).Sum(l => l.Amount));
}
