public int AddPracticePlanGame(PracticePlanGame newPracticePlanGame)
{
using var db = new SqlConnection(_connectionString);
var sqlForNewPracticePlanGame = @"INSERT INTO [dbo].[PracticePlanGames]
([Name]
,[PracticePlanId]
,[GameId]
,[PracticeDate]
,[UserNotes]
,[IsCompleted]
,[IsActive])
OUTPUT INSERTED.Id
VALUES
(@name, @practicePlanId, @gameId, @practiceDate, @userNotes, @isCompleted, 1)";
var newId = db.ExecuteScalar <int>(sqlForNewPracticePlanGame, newPracticePlanGame);
return(newId);
//var sqlToGetPracticePlanGame = "select * from PracticePlanGames where Id = @id";
//var parameterForPracticePlanGame = new { id = newId };
//var newPracticePlanGameObject = db.QueryFirstOrDefault<PracticePlanGame>(sqlToGetPracticePlanGame, parameterForPracticePlanGame);
//return newPracticePlanGameObject;
}
public PracticePlanGame UpdatePracticePlanGame(int ppgId, PracticePlanGame ppgObject)
{
using var db = new SqlConnection(_connectionString);
var sqlToUpdatePracticePlanGame = @"UPDATE [dbo].[PracticePlanGames]
SET [Name] = @name
,[PracticeDate] = @practiceDate
,[UserNotes] = @userNotes
,[IsCompleted] = @isCompleted
,[IsActive] = @isActive
OUTPUT INSERTED.*
WHERE Id = @ppgId";
var parameterForPracticePlanGame = new {
ppgObject.Name,
ppgObject.PracticeDate,
ppgObject.UserNotes,
ppgObject.IsCompleted,
ppgObject.IsActive,
ppgId,
};
var updatedPpgObject = db.QueryFirstOrDefault <PracticePlanGame>(sqlToUpdatePracticePlanGame, parameterForPracticePlanGame);
return(updatedPpgObject);
}
public IActionResult AddPracticePlanGame(PracticePlanGame newPracticePlanGame)
{
var newPracticePlanObject = _practicePlanGameRepo.AddPracticePlanGame(newPracticePlanGame);
return(Created($"/api/practiceplangames/{newPracticePlanGame.Id}", newPracticePlanObject));
}
public IActionResult UpdatePracticePlanGameRecord(int id, PracticePlanGame ppgObject)
{
var updatedPpgObject = _practicePlanGameRepo.UpdatePracticePlanGame(id, ppgObject);
return(Ok(updatedPpgObject));
}
