public Task <ReceiptInput> UpdateReceiptInputAsync(ReceiptInput receipt, CancellationToken token = default(CancellationToken))
{
var query = @"
UPDATE Receipt
SET CurrencyId = @CurrencyId
, ReceiptCategoryId = @ReceiptCategoryId
, CustomerId = @CustomerId
, SectionId = @SectionId
, RecordedAt = @RecordedAt
, ReceiptAmount = @ReceiptAmount
, RemainAmount = @RemainAmount
, PayerName = @PayerName
, PayerNameRaw = @PayerNameRaw
, DueAt = @DueAt
, Note1 = @Note1
, Note2 = @Note2
, Note3 = @Note3
, Note4 = @Note4
, BillNumber = @BillNumber
, BillBankCode = @BillBankCode
, BillBranchCode = @BillBranchCode
, BillDrawAt = @BillDrawAt
, BillDrawer = @BillDrawer
, UpdateBy = @UpdateBy
, UpdateAt = GETDATE()
OUTPUT inserted.*
WHERE Id = @Id
AND UpdateAt = @UpdateAt";
return(dbHelper.ExecuteAsync <ReceiptInput>(query, receipt, token));
}
public Task <ReceiptInput> UpdateCustomerIdAsync(ReceiptInput receipt, CancellationToken token = default(CancellationToken))
{
var query = @"
UPDATE Receipt
SET CustomerId = @CustomerId
, UpdateBy = @UpdateBy
, UpdateAt = GETDATE()
OUTPUT inserted.*
WHERE Id = @Id
AND UpdateAt = @UpdateAt";
return(dbHelper.ExecuteAsync <ReceiptInput>(query, receipt, token));
}
