public Task <int> UpdateAsync(KanaHistoryPaymentAgency KanaHistoryPayment, CancellationToken token = default(CancellationToken))
{
var query = @"
MERGE INTO KanaHistoryPaymentAgency AS target
USING (
SELECT @CompanyId CompanyId
, @PayerName PayerName
, @SourceBankName SourceBankName
, @SourceBranchName SourceBranchName
, @PaymentAgencyId PaymentAgencyId
) AS source
ON (
target.CompanyId = source.CompanyId
AND target.PayerName = source.PayerName
AND target.SourceBankName = source.SourceBankName
AND target.SourceBranchName = source.SourceBranchName
AND target.PaymentAgencyId = source.PaymentAgencyId
)
WHEN MATCHED THEN
UPDATE
SET HitCount = HitCount + @HitCount
, UpdateBy = @UpdateBy
, UpdateAt = @UpdateAt
WHEN NOT MATCHED THEN
INSERT ( CompanyId, PayerName, SourceBankName, SourceBranchName, PaymentAgencyId, HitCount, CreateBy, CreateAt, UpdateBy, UpdateAt)
VALUES (@CompanyId, @PayerName, @SourceBankName, @SourceBranchName, @PaymentAgencyId, @HitCount, @CreateBy, @CreateAt, @UpdateBy, @UpdateAt)
;
";
return(dbHelper.ExecuteAsync(query, KanaHistoryPayment, token));
}
public Task <int> DeleteAsync(KanaHistoryPaymentAgency history, CancellationToken token = default(CancellationToken))
{
var query = @"
DELETE KanaHistoryPaymentAgency
WHERE CompanyId = @CompanyId
AND PayerName = @PayerName
AND SourceBankName = @SourceBankName
AND SourceBranchName = @SourceBranchName
AND PaymentAgencyId = @PaymentAgencyId";
return(dbHelper.ExecuteAsync(query, history, token));
}
public async Task <int> DeleteAsync(KanaHistoryPaymentAgency history, CancellationToken token = default(CancellationToken)) => await deleteKanaHistoryPaymentAgencyQueryProcessor.DeleteAsync(history, token);
public async Task <int> Delete(KanaHistoryPaymentAgency history, CancellationToken token) => await kanaHistoryPaymentAgencyProcessor.DeleteAsync(history, token);
