Added NOLOCK option to the table
Changed the logic to insert tickets. Now it will check for ProfileId, WalletTypeId, ExpiryDate
Improved the way the transaction is rollbacked
Removed the httpErrors as it can be handled from IIS Error Pages
Bug Fixes and usage of CTE
Added the createdon column to track row entries
Change the CK_Content_Value constraint to all rollbacks of tickets
Created stored procedure to upload tickets based on the transaction id
Implemented the ticket upload business function
Removed the httpErrors as it can be handled on IIS Error Page