Initial Development Code
Created the readme.md
Output parameter @TRANSACTION_ID
Set @TRANSACTION_CODE and RE THROW exception
1. Order the UsagePreference based on ID
2. Check ActiveCredit & ActiveRate > 0
Changed the address type to VARCHAR(20)
Upgrades the Microsoft.AspNet.WebApi.Core reference 5.2.0
Nuget Package Removed
1. Microsoft.AspNet.WebApi.Core : 5.1
2. Microsoft.AspNet.WebApi.Client: 5.1
Update the error string and device address reference
Fixed the case issue
Rollback transaction implementation
Update the Game.Transaction table reference
1. Corrected the typo mistake on [Game].[Transactions] table
2. Removed [IsRollbacked] columns
3. Added [ParentTransactionId] column to hold the parent transaction id
4. Removed constraints [CK_Transactions_Value], [CK_Transactions_Actual] & [CK_TransactionDetail_Value] to allow rollback transaction negative values
5.
1. Update the reference to [Game].[Trasnactions] table
2. Added colums [ExpiryType] & [ExpiryValue] for table [Wallet].[Content]
3. Modified the update statement to set the expiry date of the wallet based on the [ExpiryType] & [ExpiryValue]
Added colums [ExpiryType] & [ExpiryValue] for table [Wallet].[Content]
Applied  class navbar-inverse for the navigation bar
Added the NOLOCK hint. \#2 issue is resolved now
#2 : Resolved the issue by ordering the records descending.
Removed transactional inserts and updates from the loop. Instead all inserts are on table variables
Added some comments on all return statements