Unity3D C# Sample Project WEBAPI, AUTHETICATION, SQL NOTIFICATIONS
Budget: $30 – $250 USD
I'm looking for a sample project using Unity3D, .NET WebAPI, and SQL Server, all written in C#.
1) Install local based Sql Server Express
2 tables,
users table (username) columns
scores table (username, level, score) columns
2) Web API .net c# project to read a score, update a score, insert a score
3) Unity project with 3 buttons, read, insert, update. Clicking on the buttons will either read, update or insert a score using API.
The project should authenticate with API, get a token and use the token for making the read, insert, read call.
If token isn't valid when read, insert, update is called it should return a unauthorized response.
To get a token you would pass a username, it will look up in table if user exists and then generate a expiring token and send back to user to make the subsequent API calls.
4) Lastly, I want to have sql server express notifications, some type of agent should be setup.
If the user has the application open on the phone and I goto the database and make a CHANGE to a score for a level, the user should have a popup appear on the screen.
Note, the user should only be subscribed to data he is interested in, for example I want to register to any scores changed for a level or whatever I want to make up a key.
For testing
I should be able to locally host the web api, install the UNITY project to my phone, and call the API.
I should be able to make a database score change and see a popup comeup on my phone that score is changed.
Document steps to setup the environment locally on my PC.
Requirements:
- Unity3D component that interacts with .NET WebAPI.
- The .NET WebAPI should handle sample data.
Ideal Skills:
- Proficient in Unity3D and C#.
- Experience with .NET WebAPI and SQL Server.
- Ability to create interactive applications.
1) Install local based Sql Server Express
2 tables,
users table (username) columns
scores table (username, level, score) columns
2) Web API .net c# project to read a score, update a score, insert a score
3) Unity project with 3 buttons, read, insert, update. Clicking on the buttons will either read, update or insert a score using API.
The project should authenticate with API, get a token and use the token for making the read, insert, read call.
If token isn't valid when read, insert, update is called it should return a unauthorized response.
To get a token you would pass a username, it will look up in table if user exists and then generate a expiring token and send back to user to make the subsequent API calls.
4) Lastly, I want to have sql server express notifications, some type of agent should be setup.
If the user has the application open on the phone and I goto the database and make a CHANGE to a score for a level, the user should have a popup appear on the screen.
Note, the user should only be subscribed to data he is interested in, for example I want to register to any scores changed for a level or whatever I want to make up a key.
For testing
I should be able to locally host the web api, install the UNITY project to my phone, and call the API.
I should be able to make a database score change and see a popup comeup on my phone that score is changed.
Document steps to setup the environment locally on my PC.
Requirements:
- Unity3D component that interacts with .NET WebAPI.
- The .NET WebAPI should handle sample data.
Ideal Skills:
- Proficient in Unity3D and C#.
- Experience with .NET WebAPI and SQL Server.
- Ability to create interactive applications.