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