public int Add(tblUserGame userGamedata)
{
string sQry = "INSERT INTO [tblUserGame] ([UserID],[GameID],[GameValueID],[IsConfirmed],[IsDeleted]) " +
"VALUES('" + userGamedata.UserID + "','" + userGamedata.GameID + "','" + userGamedata.GameValueID + "','" + userGamedata.IsConfirmed + "','" + false + "');SELECT SCOPE_IDENTITY();";
int retVal = ExecuteCRUDByQuery(sQry);
return(retVal);
}
private tblUserGame GetGameInfoByRow(DataRow dr)
{
tblUserGame userGame = new tblUserGame();
userGame.GameID = Convert.ToInt32(dr["GameID"]);
userGame.UserID = Convert.ToInt32(dr["UserID"]);
userGame.GameValueID = Convert.ToInt32(dr["GameValueID"]);
userGame.IsConfirmed = Convert.ToBoolean(dr["IsConfirmed"]);
return(userGame);
}
public tblUserGame Find(int gameID)
{
tblUserGame userGameData = new tblUserGame();
string sQry = "SELECT * FROM [tblUserGame] WHERE [GameID]=" + gameID;
DataTable dtUserGameInfo = ExecuteQuery(sQry);
if (dtUserGameInfo != null)
{
DataRow dr = dtUserGameInfo.Rows[0];
userGameData = GetGameInfoByRow(dr);
}
return(userGameData);
}
public IActionResult GetUserGameById(int gameID)
{
tblUserGame userGamedata = _userGameService.Find(gameID);
if (userGamedata == null)
{
return(NotFound());
}
else
{
return(new ObjectResult(userGamedata));
}
}
public IActionResult PostUserGame([FromBody] tblUserGame userGamedata)
{
if (userGamedata == null)
{
return(BadRequest());
}
int retVal = _userGameService.Add(userGamedata);
if (retVal > 0)
{
return(Ok());
}
else
{
return(NotFound());
}
}
