Software Development

​DESCRIPTION We have a casino link system storing data in SQL and need a promotional software to check certain parameters from the database (visits, points, member data etc.) and if the criteria is met to print a thermal ticket with XXXXXX information (templates). Let's assume we setup the following promotions: Print a ticket if a player fulfills the criteria: at least 6 visits the last 3 months. Print a ticket if a player accumulated at least 300 points on his last visit and is a Silver Member. Print a ticket if the player has a Birthday. Print a ticket if a player accumulated at least 1000 points the last Month regardless visits. Print a ticket if the player has 0 visits the last 3 months (lapsed player). Print a ticket if he it's his second visit. All promotions needs to run simultaneously and I will also need reports for each promotion with possibility to export to excel for analysis. Below there is technical information to connect to the database. The drDS service is already implemented at the Sunborn server. drDS is a web service that provides a RESTful API (the default port of the service is 2012). Documentation for the playerBasicInfo: playerBasicInfo Call /api/custom/casino/table/playerBasicInfo Parameters cardNumber (Int64): The card number of the player. playerId (Int64): The player id of the player. Example /api/custom/casino/table/playerBasicInfo?cardNumber=2925543604&playerId=50001 Returns: result: a list of playerBasicInfo objects playerId (Int64): The id of the player. cardSerNr (Int64): The card number of the player. firstName (String): The first name of the player. lastName (String): The last name of the player. cardLevel (Int64): The card level of the player. dateOfBirth (String): The date of birth of the player. status (String): The status of the player (ok, card locked, banned, …). picture (Byte[]): The most recent picture of the player. oldResult - The previous result if the service in calculating a new one. calcTime - Time used for server side data retrieval and calculations in miliseconds. isCached - True if the result is cached on the service. isRunning - True if a calculation is being performed by the server (use oldResult). Example calls for the playerBasicInfo (can be tested in the web browser on the server): - [login to view URL] -> gets all the players (images are excluded here - because of the response size), - [login to view URL] -> gets the player by playerId (player image is included here as a base64 encoded string), - [login to view URL] -> gets the player by cardNumber (player image is included here as a base64 encoded string). These results of the calls can be returned in various formats: JSON ([login to view URL]), XML ([login to view URL]), CSV ([login to view URL]) and JSV ([login to view URL]). The response in JSON format (for [login to view URL]) : { "result": [ { "playerId": 50001, "cardSerNr": 2925543604, "firstName": "Sample", "lastName": "Player 2", "cardLevel": 1, "dateOfBirth": "16.5.1980 0:00:00", "status": "Ok", "picture": "" } ], "calcTime": 14, "isCached": false, "isRunning": false } -