public int Update(int gameId, tblGames gameInfo)
{
string sQry = "UPDATE [tblGames] SET [GameName]='" + gameInfo.GameName + "',[StartDate]='" + gameInfo.StartDate + "',[StartTime]='" + gameInfo.StartTime + "',[EndDate]='" + gameInfo.EndDate + "',[EndTime]='" + gameInfo.EndTime + "' WHERE [GameID]=" + gameId;
int retVal = ExecuteUpdateQuery(sQry);
return(retVal);
}
public int Update(int gameId, tblGames gameInfo)
{
string sQry = "UPDATE [tblGames] SET [IsGameStart]='" + gameInfo.IsGameStart + "',[IsGamePause]='" + gameInfo.IsGamePause + "',[IsGameFinish]='" + gameInfo.IsGameFinish + "' WHERE [GameID]=" + gameId;
int retVal = ExecuteUpdateQuery(sQry);
return(retVal);
}
public int UpdateWinnigValues(tblGames gameInfo)
{
string sQry = "UPDATE [tblGames] SET [WinValue1]='" + gameInfo.WinValue1 + "',[WinValue2]='" + gameInfo.WinValue2 + "',[WinValue3]='" + gameInfo.WinValue3 + "',[WinValue4]='" + gameInfo.WinValue4 + "',[WinValue5]='" + gameInfo.WinValue5 + "',[WinValue6]='" + gameInfo.WinValue6 + "' WHERE [GameID]=" + gameInfo.GameID;
int retVal = ExecuteUpdateQuery(sQry);
return(retVal);
}
public int Add(tblGames gameInfo)
{
string sQry = "INSERT INTO [tblGames] ([GameName],[WinValue1],[WinValue2],[WinValue3],[WinValue4],[WinValue5],[WinValue6],[IsDeleted],[IsGameStart],[IsGamePause],[IsGameFinish],[StartDate],[StartTime],[EndDate],[EndTime]) " +
"VALUES('" + gameInfo.GameName + "','" + gameInfo.WinValue1 + "','" + gameInfo.WinValue2 + "','" +
gameInfo.WinValue3 + "','" + gameInfo.WinValue4 + "','" + gameInfo.WinValue5 + "','" + gameInfo.WinValue6 + "','" + false + "','" + gameInfo.IsGameStart + "','" + gameInfo.IsGamePause + "','" + gameInfo.IsGameFinish + "','" + gameInfo.StartDate + "','" + gameInfo.StartTime + "','" + gameInfo.EndDate + "','" + gameInfo.EndTime + "');SELECT SCOPE_IDENTITY();";
int retVal = ExecuteCRUDByQuery(sQry);
return(retVal);
}
public tblGames GetLastWinner()
{
tblGames gameData = new tblGames();
string sQry = "SELECT TOP 1 * FROM dbo.tblGames WHERE ISNULL(winValue1,-1)<>-1 ORDER BY EndDate DESC ";
DataTable dtGameInfo = ExecuteQuery(sQry);
if (dtGameInfo != null)
{
DataRow dr = dtGameInfo.Rows[0];
gameData = GetGameInfoByRow(dr);
}
return(gameData);
}
public tblGames Find(int id)
{
tblGames gameData = new tblGames();
string sQry = "SELECT * FROM [tblGames] WHERE [GameID]=" + id;
DataTable dtGameInfo = ExecuteQuery(sQry);
if (dtGameInfo != null)
{
DataRow dr = dtGameInfo.Rows[0];
gameData = GetGameInfoByRow(dr);
}
return(gameData);
}
public IActionResult GetGameInfoById(int id)
{
tblGames gameInfo = _gameInfoService.Find(id);
if (gameInfo == null)
{
return(NotFound());
}
else
{
return(new ObjectResult(gameInfo));
}
}
public IActionResult PostGameInfo([FromBody] tblGames gameInfo)
{
if (gameInfo == null)
{
return(BadRequest());
}
int retVal = _gameInfoService.Add(gameInfo);
if (retVal > 0)
{
return(Ok());
}
else
{
return(NotFound());
}
}
public IActionResult UpdateWinnigValues([FromBody] tblGames gameInfo)
{
if (_gameInfoService.Find(gameInfo.GameID) == null)
{
return(NotFound());
}
int retVal = _gameInfoService.UpdateWinnigValues(gameInfo);
if (retVal > 0)
{
return(Ok());
}
else
{
return(NotFound());
}
}
public IActionResult UpdateGameStatus([FromBody] tblGames gameInfo)
{
if (gameInfo == null)
{
return(BadRequest());
}
int retVal = _userGameService.Update(gameInfo.GameID, gameInfo);
if (retVal > 0)
{
return(Ok());
}
else
{
return(NotFound());
}
}
private tblGames GetGameInfoByRow(DataRow dr)
{
tblGames gameInfo = new tblGames();
gameInfo.GameID = Convert.ToInt32(dr["GameID"]);
gameInfo.GameName = Convert.ToString(dr["GameName"]);
gameInfo.WinValue1 = Convert.ToInt32(dr["WinValue1"]);
gameInfo.WinValue2 = Convert.ToInt32(dr["WinValue2"]);
gameInfo.WinValue3 = Convert.ToInt32(dr["WinValue3"]);
gameInfo.WinValue4 = Convert.ToInt32(dr["WinValue4"]);
gameInfo.WinValue5 = Convert.ToInt32(dr["WinValue5"]);
gameInfo.WinValue6 = Convert.ToInt32(dr["WinValue6"]);
gameInfo.IsDeleted = Convert.ToBoolean(dr["IsDeleted"]);
gameInfo.WinnerImage = Convert.ToString(dr["WinnerImage"]);
gameInfo.WinValueList = new int[6] {
Convert.ToInt32(dr["WinValue1"].ToString()), Convert.ToInt32(dr["WinValue2"].ToString()), Convert.ToInt32(dr["WinValue3"].ToString()), Convert.ToInt32(dr["WinValue4"].ToString()), Convert.ToInt32(dr["WinValue5"].ToString()), Convert.ToInt32(dr["WinValue6"].ToString())
};
return(gameInfo);
}
public IActionResult PutGameInfo(int id, [FromBody] tblGames gameInfo)
{
if (gameInfo == null || id != gameInfo.GameID)
{
return(BadRequest());
}
if (_gameInfoService.Find(id) == null)
{
return(NotFound());
}
int retVal = _gameInfoService.Update(id, gameInfo);
if (retVal > 0)
{
return(Ok());
}
else
{
return(NotFound());
}
}
