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