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);