Mobile and Desktop Application
- C#,
- ADO.NET,
- Win Forms,
- jQuery Mobile,
- Bootstrap,
- CSS3 Animations,
- MS Server Database
/Trivia-Master - UILayer
CLIENT SIDE CODE ( Contains Mobile and Desktop Versions UI)
IAsyncHttpHandler, Session, Cookies, MultiView, Validators, BundleConfig, Master Pages. Json Helper Class named as JsonHelper.cs for retrieving list ob objects in JSON format
SERVER SIDE CODE (Contains Models And Data Access Objects to each Model)
/Trivia-Master - DALayer
[x] Stored Procedures , [x] Models, [x] Dataset, [x] Datatables, [x] SqlConnection.
DTableExtension.cs - generic helper class using for creating dynamically instance of models with it individual properties .
Example One of Stored Procedure :
SELECT
Player.image AS Picture,
Player.email AS Email,
Player.username AS Username,
Player.registration_date AS Registration_Date,
row_number() OVER(ORDER BY avg(Game.score) DESC) AS Place,
Game.player_id AS PlayerId,
sum(Game.score) AS TotalScore,
avg(Game.score) AS AverageScore,
count(Game.id) AS TotalGames
FROM Game
INNER JOIN Player
ON Game.player_id=Player.id
GROUP BY Game.player_id,
Player.username,Player.email,Player.image,Player.registration_date)
As Fafa
WHERE Fafa.PlayerId = @PlayerId ```
The result is :
____________________________
Picture resized and renamed : Email: Username: Registration Date: Place: PlayerID: TotalScore: AverageScode : TotalGames:
_______________________________________________________________________________________________________________________________
27bfe528-df0b-42dc-9110-28137a92de0ejinge.jpg [email protected] jinji 2015-11-27 16:38:37.957 1 1 27 27 1