//Method for adding a new player to the database public void PlayerCreate(PlayerDO player) { //Defining SqlConnection for this method SqlConnection scon = new SqlConnection(_conn); //Beginning the processes try { //Defining a variable for the SqlCommand, as well as the stored proc and connection we're using SqlCommand createPlayer = new SqlCommand("PLAYER_ADD", scon); //Defining what kind of command our SqlCommand is createPlayer.CommandType = CommandType.StoredProcedure; //opening sql connection scon.Open(); //Adding in all the variables. Format: ("@SqlVariable", C#VariableValue) createPlayer.Parameters.AddWithValue("@Name", player.Name); createPlayer.Parameters.AddWithValue("@PeakRating", player.PeakRating); createPlayer.Parameters.AddWithValue("@BirthDate", player.BirthDate); createPlayer.Parameters.AddWithValue("@Dead", player.Dead); createPlayer.Parameters.AddWithValue("@CountryOfOrigin", player.CountryOfOrigin); createPlayer.Parameters.AddWithValue("@CountryRepresented", player.CountryRepresented); //telling the code to use the stored procedure createPlayer.ExecuteNonQuery(); } //Catch for any errors that may happen catch (Exception ex) { //passing in the exception that was thrown to the errorhandler ErrorHandlerDAL.ErrorLogger(ex); } //finally cleans up any last loose ends finally { //closing SqlConnection scon.Close(); //disposing of the SqlConnection scon.Dispose(); } }
//Method to pass in all information gathered from a user and update a player's information in the database public ActionResult UpdatePlayer(PlayerPO form) { //Declaring an action result variable, but assigning it to null to reassign later ActionResult result = null; //Checks to see if the UI form is filled out correctly if (ModelState.IsValid) { //Beginning of processes try { //passing the UI form information to run through our mapper, and assigning it to a DO object PlayerDO dataObject = MapPlayerTF.PlayerPOtoDO(form); //calling on a DAL access field to allow us to use a specific method within, while passing in the DO object _dataAccess.PlayerUpdate(dataObject); } //catch to record any exceptions that crop up catch (Exception ex) { //call to method to record necessary information ErrorFile.ErrorHandlerPL(ex); } //finally to tie up any loose ends finally { } //assigns a page redirection to our variable result = RedirectToAction("Index", "Player"); } //section of code that runs if the form is not valid else { //assigns a page redirection to our variable result = View(form); } //runs the portion of code that is necessary for the situation return(result); }
public void init() { _playerDO = new PlayerDO(); }