private Result <int> DeleteDetail(CodeMapperDetailItem entity)
{
var sql = $@"DELETE FROM dbo.[CodeMapperDetails]
WHERE CodeMapperId = @CodeMapperId
AND ActionCodeId = @CodeMapperId;";
return(_commandRepository.ExecuteSqlNonQuery(sql, new { CodeMapperId = entity.CodeMapperId, ActionCodeId = entity.ActionCodeId }));
}
private Result <int> UpdateDetail(CodeMapperDetailItem entity)
{
var sql = $@"UPDATE dbo.[CodeMapperDetails]
SET AccountingCode = @AccountingCode,
CreditAccountId = @CreditAccountId,
DebitAccountId = @DebitAccountId
WHERE CodeMapperId = @CodeMapperId
AND ActionCodeId = @CodeMapperId;";
return(_commandRepository.ExecuteSqlNonQuery(sql, new
{
CodeMapperId = entity.CodeMapperId,
ActionCodeId = entity.ActionCodeId,
AccountingCode = entity.AccountingCode,
CreditAccountId = entity.CreditAccountId,
DebitAccountId = entity.DebitAccountId
}));
}
private bool _IsDirtyCode(CodeMapperDetailItem y, CodeMapperDetailItem x) => y.ActionCode == x.ActionCode && (y.AccountingCode != x.AccountingCode || y.CreditAccountId != x.CreditAccountId || y.DebitAccountId != x.DebitAccountId);
