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)); }