public async Task <IActionResult> Get(long id)
{
try
{
var result = await _repo.GetJournalEntryById(id);
//Mapping FROM database entity to Dto
var dto = new JournalEntryHeaderDto();
dto.Id = result.Id;
dto.Date = result.Date;
dto.ReferenceNo = result.ReferenceNo;
dto.Memo = result.Memo;
dto.Posted = result.Posted;
//lines
foreach (var lineItem in result.JournalEntryLines)
{
var line = new JournalEntryLineDto();
line.AccountId = lineItem.AccountId;
line.DrCrId = (int)lineItem.DrCr;
line.Amount = lineItem.Amount;
line.Memo = lineItem.Memo;
//add to master
dto.Lines.Add(line);
}
return(Ok(dto));
}
catch (Exception e)
{
return(BadRequest(e.Message));
}
}
public async Task <IActionResult> Get(int includePosted = 1)
{
var journalEntries = await _repo.GetJournalEntries();
var journalEntryDtosList = new List <JournalEntryHeaderDto>();
//mapping from db entity to Dto
foreach (var je in journalEntries)
{
var journalEntryDto = new JournalEntryHeaderDto()
{
Id = je.Id,
Date = je.Date,
Memo = je.Memo,
ReferenceNo = je.ReferenceNo,
Posted = je.Posted
};
foreach (var line in je.JournalEntryLines)
{
var lineDto = new JournalEntryLineDto
{
Id = line.Id,
AccountId = line.AccountId,
Amount = line.Amount,
DrCrId = (int)line.DrCr,
Memo = line.Memo
};
journalEntryDto.Lines.Add(lineDto);
}
// is this journal entry ready for posting?
if (!journalEntryDto.Posted &&
journalEntryDto.Lines.Count >= 2 &&
(journalEntryDto.DebitAmount == journalEntryDto.CreditAmount) &&
(journalEntryDto.DebitAmount != 0))
{
journalEntryDto.ReadyForPosting = true;
}
journalEntryDtosList.Add(journalEntryDto);
}
//now prepare a simple model for grid
var entries = new List <JournalEntryDto>();
foreach (var item in journalEntryDtosList)
{
var entry = new JournalEntryDto
{
Id = item.Id,
Date = item.Date,
Debit = item.DebitAmount,
Credit = item.CreditAmount,
ReferenceNo = item.ReferenceNo,
Memo = item.Memo,
Posted = item.Posted,
ReadyForPosting = item.ReadyForPosting
};
entries.Add(entry);
}
return(Ok(entries));
}
public async Task <IActionResult> SaveJournal([FromBody] JournalEntryHeaderDto journalEntryDto)
{
var anyDuplicate = journalEntryDto.Lines.GroupBy(x => x.AccountId).Any(g => g.Count() > 1);
if (anyDuplicate)
{
return(BadRequest("One or more journal entry lines has duplicate account."));
}
var isNew = journalEntryDto.Id == 0;
JournalEntryHeader journalEntry = null;
if (isNew)
{
//inserting
journalEntry = new JournalEntryHeader();
}
else
{
//editing
journalEntry = await _db.JournalEntryHeaders
.Where(j => j.Id == journalEntryDto.Id)
.Include(j => j.JournalEntryLines)
.FirstOrDefaultAsync();
//get all oldLines
var oldLines = await _db.JournalEntryLines
.Where(l => l.JournalEntryHeaderId == journalEntryDto.Id)
.ToListAsync();
//Remove these lines
_db.JournalEntryLines.RemoveRange(oldLines);
//Save to db
await _db.SaveChangesAsync();
}
//mapping - master
journalEntry.Date = journalEntryDto.Date;
journalEntry.ReferenceNo = journalEntryDto.ReferenceNo;
journalEntry.Memo = journalEntryDto.Memo;
//lines
foreach (var line in journalEntryDto.Lines)
{
var journalLine = new JournalEntryLine
{
AccountId = line.AccountId,
DrCr = (DrOrCrSide)line.DrCrId,
Amount = line.Amount,
Memo = line.Memo
};
journalEntry.JournalEntryLines.Add(journalLine);
}
//save to db
if (isNew)
{
_db.JournalEntryHeaders.Add(journalEntry);
}
else
{
_db.JournalEntryHeaders.Update(journalEntry);
}
await _db.SaveChangesAsync();
return(Ok(journalEntry));
}
