//Method that allows user to input the information they want to update public ActionResult UpdateUser(int UserId) { //declaring object using model PlayerPO UserPO userToUpdate = new UserPO(); //Beginning of processes try { //declare List using Model UserDO, and use it to store all information on the game recovered by using a DAL access call UserDO item = _dataAccess.UserReadByID(UserId); //assign all data to object using a mapper userToUpdate = MapUserTF.UserDOtoPO(item); } //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 { } //Sends the data in the list to the view to be seen by the user. return(View(userToUpdate)); }
//Method of getting the general information of a game from the database, and sending it up to the user public ActionResult Index() { //declaring list using model GamePO List <GamePO> mappedGame = new List <GamePO>(); //Beginning of processes try { //declaring list using Model GameDO in order to retrieve database information List <GameDO> allGames = _dataAccess.GameReadAll(); //loop to get all objects assigned appropriately foreach (GameDO dataObject in allGames) { //assign our PO list all of the values that were in the DO list via mapper mappedGame.Add(MapGameTF.GameDOtoPO(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 { } //Sends the data in the list to the view to be seen by the user. return(View(mappedGame)); }
//Method to search the database for a player by the name of the player public ActionResult ReadPlayerByName(string winner, int wins) { //declaring list using model GamePO List <PlayerPO> mappedPlayer = new List <PlayerPO>(); //Beginning of processes try { //declaring list using Model PlayerDO in order to retrieve database information List <PlayerDO> player = _dataAccess.PlayerReadByName(winner); //loop to get all objects assigned appropriately foreach (PlayerDO dataObject in player) { //assign our PO list all of the values that were in the DO list via mapper mappedPlayer.Add(MapPlayerTF.PlayerDOtoPO(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 { } //Sends the data in the list to the view to be seen by the user. return(View(mappedPlayer)); }
//Method to call data back from the database consisting of the player name, and their win total public ActionResult PlayersByWins() { //declaring list using model WinsPO List <WinsPO> players = new List <WinsPO>(); //Beginning of processes try { //declaring list using Model Wins in order to retrieve database information List <WinsDO> player = _dataAccess.OrderByWinCount(); //loop to get all objects assigned appropriately foreach (WinsDO dataObject in player) { //assign our PO list all of the values that were in the DO list via mapper players.Add(MapWinnersTF.WinsDOtoPO(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 { } //Sends the User to the View page return(View(players)); }
//Method that governs user login public ActionResult UserLogin(LoginPO form) { //Declaring an action result variable, but assigning it to null to reassign later ActionResult result = View(form); //Checks to see if the UI form is filled out correctly if (ModelState.IsValid) { //Beginning of processes try { //passing the UI form information to make the DAL call, run through our mapper, and assigning it to a DO object LoginPO user = MapLoginTF.LoginDOtoPO(_dataAccess.ValidLogin(form.Username)); //Checks if the password from the user input and the password from the database associated with the username match if (user.Password == form.Password) { //Sets the Session role id equal to the UserRoleId called back from the database Session["UserRoleId"] = user.UserRoleId; //Sets the Username the user inputed equal to the session username Session["Username"] = user.Username; //redirects the user to the specified page result = RedirectToAction("Index", "Home"); //Sets the session timeout for 20 minutes Session.Timeout = 20; } //if passwords do not match else { //sets result to loop back to the form result = View(form); } } //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 { } } //Code that runs if the model state isn't valid else { //sets result to loop back to the form result = View(form); } //sends appropriate response back to the user return(result); }
//Method that adds a user public ActionResult AddUser() { //Beginning of processes try { } //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 { } //Sends the user to the view return(View()); }
//Takes in the information that a user wants to update about a certain game public ActionResult UpdateGame(int gameId) { //declaring object using model GamePO GamePO gameToUpdate = new GamePO(); //Beginning of processes try { //declare List using Model GameDO, and use it to store all information on the game recovered by using a DAL access call GameDO item = _dataAccess.GameReadByID(gameId); //assign all data to object using a mapper gameToUpdate = MapGameTF.GameDOtoPO(item); //establish list to hold all data on all players as recovered by the DAL access call List <PlayerDO> players = _playerAccess.PlayerReadAll(); //declare list to hold relevant data from full DAL call List <SelectListItem> options = new List <SelectListItem>(); foreach (PlayerDO dataObject in players) { //Declare list to hold player names SelectListItem option = new SelectListItem(); //make list aspect equal dataObject variable option.Text = dataObject.Name; //make list aspect equal dataObject variable option.Value = dataObject.PlayerId.ToString(); //take object "option", and add it to list "options" options.Add(option); } //set object value of PlayersDropDown equal to values of "options" gameToUpdate.PlayersDropDown = options; } //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 { } //Sends the data in the list to the view to be seen by the user. return(View(gameToUpdate)); }
//Method for deleting a game from the database public ActionResult DeleteGame(int gameId) { //Beginning of processes try { //using DAL access to call on the game delete method, and passing in the game id _dataAccess.GameDelete(gameId); } //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 { } //redirects to the specified page return(RedirectToAction("Index", "Game")); }
//Method that deletes a user from the database public ActionResult DeleteUser(int UserId) { //Beginning of processes try { //passes playerId in to the player delete method to delete the player assigned to the id _dataAccess.UserDelete(UserId); } //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 { } //sends a page redirection to our user return(RedirectToAction("Index", "User")); }
//Method for taking in the necessary data to add a new game to the database public ActionResult AddGame() { //declaring object using model GamePO GamePO game = new GamePO(); //Beginning of processes try { //declare List using Model PlayerDO, and use it to store all information on all players recovered by using a DAL access call List <PlayerDO> players = _playerAccess.PlayerReadAll(); //Declare list to hold player names List <SelectListItem> options = new List <SelectListItem>(); //loop to get all objects assigned appropriately foreach (PlayerDO dataObject in players) { //Declare new object to temporarily hold data SelectListItem option = new SelectListItem(); //make list aspect equal dataObject variable option.Text = dataObject.Name; //make list aspect equal dataObject variable option.Value = dataObject.PlayerId.ToString(); //take object "option", and add it to list "options" options.Add(option); } //set object value of PlayersDropDown equal to values of "options" game.PlayersDropDown = options; } //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 { } //Sends the data in the list to the view to be seen by the user. return(View(game)); }
//Method to pass information into the database and update the necessary game public ActionResult UpdateGame(GamePO 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 GameDO dataObject = MapGameTF.GamePOtoDO(form); //calling on a DAL access field to allow us to use a specific method within, while passing in the DO object _dataAccess.GameUpdate(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", "Game"); } //section of code that runs if the form is not valid else { //assigning a value to our variable that will be used if the form isn't valid result = View(form); } //runs the portion of code that is necessary for the situation return(result); }