public Task <int> OmitByApportionAsync(ReceiptApportion receiptApportion, CancellationToken token = default(CancellationToken))
{
var query = @"
UPDATE Receipt SET
Apportioned = @Apportioned
, CustomerId = @CustomerId
, SectionId = @SectionId
, DeleteAt = GETDATE()
, UpdateBy = @UpdateBy
, UpdateAt = GETDATE()
WHERE Id = @Id
AND UpdateAt = @UpdateAt";
return(dbHelper.ExecuteAsync(query, receiptApportion, token));
}
public Task <ReceiptApportion> UpdateApportionAsync(ReceiptApportion apportion, CancellationToken token = default(CancellationToken))
{
var query = @"
UPDATE Receipt
SET Apportioned = @Apportioned
, CustomerId = @CustomerId
, SectionId = @SectionId
, ExcludeFlag = @ExcludeFlag
, ExcludeCategoryId = @ExcludeCategoryId
, ExcludeAmount = @ExcludeAmount
, RemainAmount = RemainAmount - @ExcludeAmount
, AssignmentFlag = CASE WHEN @ExcludeAmount = ReceiptAmount THEN 2
WHEN @ExcludeAmount <> 0 THEN 1
ELSE 0 END
,UpdateBy = @UpdateBy
,UpdateAt = GETDATE()
OUTPUT inserted.*
WHERE Id = @Id AND UpdateAt = @UpdateAt ";
return(dbHelper.ExecuteAsync <ReceiptApportion>(query, apportion, token));
}
