public ActionResult UpdateGame(long GameId)
{
//sets response
ActionResult responce;
try
{
//instantiate updategame by game id
GameDO updategame = _GameDataAccess.ViewGameByGameId(GameId);
//maps from do to po
Game gamedetails = _Mapper.MapDoToPo(updategame);
//checks
if (updategame.GameId > 0)
{
responce = View(gamedetails);
}
else
{
responce = RedirectToAction("ViewAllGames", "Game");
}
}
catch (SqlException sqlex)
{
_Logger.ErrorLog(MethodBase.GetCurrentMethod().DeclaringType.Name, MethodBase.GetCurrentMethod().Name, sqlex);
responce = RedirectToAction("Index", "Home");
}
catch (Exception ex)
{
_Logger.ErrorLog(MethodBase.GetCurrentMethod().DeclaringType.Name, MethodBase.GetCurrentMethod().Name, ex);
responce = RedirectToAction("Index", "Home");
}
return(responce);
}
public ActionResult UpdateGame(int specificGame = default(int))
{
// Only administrators and contributors can update games.
ActionResult response = null;
if ((Session["UserRole"] != null && (int)Session["UserRole"] < 3) || specificGame != 0)
{
try
{
//Give the user the game's information to be updated.
GameDO gameObject = _dataAccess.GameDetails(specificGame);
GamePO displayGame = Mapper.GameDOtoPO(gameObject);
response = View(displayGame);
}
catch (Exception ex)
{
Logger.Log(ex);
//If there is an issue, send the user to the game's index.
response = RedirectToAction("Index", "Games");
}
finally { }
}
else
{
response = RedirectToAction("Index", "Games");
}
return(response);
}
public ActionResult CreateGame(GamePO form)
{
ActionResult response = null;
if ((Int64)Session["RoleID"] == 3)
{
GameDL dl = new GameDL();
GameMap map = new GameMap();
if (ModelState.IsValid)
{
GameDO gameDO = map.GamePOToDO(form);
dl.CreateGame(gameDO);
response = RedirectToAction("Index");
}
else
{
response = View(form);
}
}
else
{
response = RedirectToAction("Index");
}
return(response);
}
public void UpdateGame(GameDO gameUpdate)
{
try
{
using (SqlConnection connectionGamestore = new SqlConnection(_ConnectionString))
using (SqlCommand updateGame = new SqlCommand("GAME_UPDATE", connectionGamestore))
{
//sets commmand type
updateGame.CommandType = CommandType.StoredProcedure;
//sets timeout
updateGame.CommandTimeout = 60;
//takes in these parameters
updateGame.Parameters.AddWithValue("@GameId", gameUpdate.GameId);
updateGame.Parameters.AddWithValue("@Title", gameUpdate.Title);
updateGame.Parameters.AddWithValue("@Description", gameUpdate.Description);
updateGame.Parameters.AddWithValue("@Developing_Company", gameUpdate.DevelopingCompany);
updateGame.Parameters.AddWithValue("@Condition", gameUpdate.GameCondition);
updateGame.Parameters.AddWithValue("@Price", gameUpdate.Price);
//open the connection
connectionGamestore.Open();
updateGame.ExecuteNonQuery();
}
}
catch (SqlException sqlex)
{
_Logger.ErrorLog(MethodBase.GetCurrentMethod().DeclaringType.Name, MethodBase.GetCurrentMethod().Name, sqlex);
}
catch (Exception ex)
{
_Logger.ErrorLog(MethodBase.GetCurrentMethod().DeclaringType.Name, MethodBase.GetCurrentMethod().Name, ex);
}
}
public ActionResult UpdateGame(Game form)
{
//setting the response
ActionResult response;
//check
if (ModelState.IsValid)
{
try
{
//mapping gamedo to po
GameDO gameDO = _Mapper.MapPoToDo(form);
_GameDataAccess.UpdateGame(gameDO);
response = RedirectToAction("ViewAllGames", "Game");
}
catch (SqlException sqlex)
{
_Logger.ErrorLog(MethodBase.GetCurrentMethod().DeclaringType.Name, MethodBase.GetCurrentMethod().Name, sqlex);
response = RedirectToAction("Index", "Home");
}
catch (Exception ex)
{
_Logger.ErrorLog(MethodBase.GetCurrentMethod().DeclaringType.Name, MethodBase.GetCurrentMethod().Name, ex);
response = RedirectToAction("Index", "Home");
}
}
else
{
response = View(form);
}
return(response);
}
public void CreateGame(GameDO gameObject)
{
try
{
using (SqlConnection connection = new SqlConnection(connectionString))
{
SqlCommand command = new SqlCommand("CREATE_GAME", connection);
command.CommandType = CommandType.StoredProcedure;
connection.Open();
command.Parameters.AddWithValue("@gameTitle", gameObject.GameTitle);
command.Parameters.AddWithValue("@romanNumeral", gameObject.RomanNumeral);
command.Parameters.AddWithValue("@releaseDate", gameObject.ReleaseDate);
command.Parameters.AddWithValue("@copiesSold", gameObject.CopiesSold);
command.Parameters.AddWithValue("@gameSummary", gameObject.GameSummary);
command.Parameters.AddWithValue("@price", gameObject.Price);
command.ExecuteNonQuery();
connection.Close();
command.Dispose();
connection.Dispose();
}
}
catch (Exception ex)
{
ErrorLog error = new ErrorLog();
error.Log(ex, "CreateGame", "DAL", "Error");
}
}
/// <summary>
/// Filters data while reading from the database.
/// </summary>
/// <param name="reader">SqlDataReader to read from the database</param>
/// <returns>Returns a GameDO with filtered information</returns>
public GameDO MapReaderToSingle(SqlDataReader reader)
{
GameDO gameDO = new GameDO();
if (reader["GameID"] != DBNull.Value)
{
gameDO.GameID = (int)reader["GameID"];
}
if (reader["Title"] != DBNull.Value)
{
gameDO.Title = (string)reader["Title"];
}
if (reader["ReleaseDate"] != DBNull.Value)
{
gameDO.ReleaseDate = (string)reader["ReleaseDate"];
}
if (reader["Developer"] != DBNull.Value)
{
gameDO.Developer = (string)reader["Developer"];
}
if (reader["Platform"] != DBNull.Value)
{
gameDO.Platform = (string)reader["Platform"];
}
return(gameDO);
}
public void AddGame(GameDO GameToCreate)
{
try
{
using (SqlConnection connection = new SqlConnection(_ConnectionString))
using (SqlCommand command = new SqlCommand("GAME_CREATE", connection))
{
command.CommandType = CommandType.StoredProcedure;
command.CommandTimeout = 60;
command.Parameters.AddWithValue("@Price", GameToCreate.Price);
command.Parameters.AddWithValue("@Title", GameToCreate.Title);
command.Parameters.AddWithValue("@Description", GameToCreate.Description);
command.Parameters.AddWithValue("@Developing_Company", GameToCreate.DevelopingCompany);
command.Parameters.AddWithValue("@Condition", GameToCreate.GameCondition);
connection.Open();
command.ExecuteNonQuery();
connection.Close();
}
}
catch (SqlException sqlex)
{
_Logger.ErrorLog(MethodBase.GetCurrentMethod().DeclaringType.Name, MethodBase.GetCurrentMethod().Name, sqlex);
}
}
public ActionResult Index()
{
Game gamepo = new Game();
try
{
List <CalculationBO> table = new List <CalculationBO>();
List <GameOrderDO> gameorder = new List <GameOrderDO>();
gameorder = _GameOrderDataAccess.ViewAllGameOrders();
foreach (GameOrderDO view in gameorder)
{
CalculationBO businesObject = new CalculationBO();
businesObject.GameId = view.GameId;
businesObject.GameOrderId = view.GameOrderId;
businesObject.Price = view.Price;
table.Add(businesObject);
}
long value = calc.Total(table);
GameDO gamedo = new GameDO();
gamedo = game.ViewGameByGameId(value);
gamepo = mapper.MapDoToPo(gamedo);
}
catch
{
}
return(View(gamepo));
}
public ActionResult ViewCart()
{
List <long> cart = (List <long>)Session["Cart"];
List <Game> mappedGames = new List <Game>();
try
{
foreach (long gameId in cart)
{
//call on game dao then call on method
GameDO game = _GameDataAccess.ViewGameByGameId(gameId);
mappedGames.Add(_Mapper.MapDoToPo(game));
}
}
catch (SqlException sqlex)
{
_Logger.ErrorLog(MethodBase.GetCurrentMethod().DeclaringType.Name, MethodBase.GetCurrentMethod().Name, sqlex);
}
catch (Exception ex)
{
_Logger.ErrorLog(MethodBase.GetCurrentMethod().DeclaringType.Name, MethodBase.GetCurrentMethod().Name, ex);
}
return(View(mappedGames));
}
public GameDO MapReaderToSingle(SqlDataReader reader)
{
GameDO result = new GameDO();
if (reader["GameId"] != DBNull.Value)
{
result.GameId = (long)reader["GameId"];
}
if (reader["Title"] != DBNull.Value)
{
result.Title = (string)reader["Title"];
}
if (reader["Description"] != DBNull.Value)
{
result.Description = (string)reader["Description"];
}
if (reader["Developing Company"] != DBNull.Value)
{
result.DevelopingCompany = (string)reader["Developing Company"];
}
if (reader["Condition"] != DBNull.Value)
{
result.GameCondition = (string)reader["Condition"];
}
if (reader["Price"] != DBNull.Value)
{
result.Price = (decimal)reader["Price"];
}
return(result);
}
public List <GameDO> ViewGameID()
{
List <GameDO> gameList = new List <GameDO>();
try
{
using (SqlConnection connection = new SqlConnection(connectionString))
{
SqlCommand command = new SqlCommand("VIEW_GAME_IDS", connection);
command.CommandType = CommandType.StoredProcedure;
connection.Open();
SqlDataReader reader = command.ExecuteReader();
while (reader.Read())
{
GameDO gameObject = new GameDO();
gameObject.GameID = reader.GetInt64(0);
gameObject.GameTitle = reader.GetString(1);
gameList.Add(gameObject);
}
connection.Close();
command.Dispose();
connection.Dispose();
}
}
catch (Exception ex)
{
ErrorLog error = new ErrorLog();
error.Log(ex, "ViewGameID", "DAL", "Error");
}
return(gameList);
}
/// <summary>
/// Displays the information for a specific game
/// </summary>
/// <param name="id">ID of the game needing to be displayed</param>
/// <returns>Returns a result based on status</returns>
public ActionResult GameDetails(int id)
{
ActionResult response;
ReviewVM viewModel = new ReviewVM();
//check id
if (id > 0)
{
//if id is valid, access the database
try
{
//set game
GameDO gameDO = _GameDataAccess.ViewGameByID(id);
viewModel.Game = _GameMapper.MapDOtoPO(gameDO);
//instantiate lists
List <ReviewDO> gameReviews = _ReviewDataAccess.ViewReviews();
List <ReviewPO> mappedReviews = new List <ReviewPO>();
viewModel.ReviewsList = new List <ReviewPO>();
//map reviews to a list of POs
foreach (ReviewDO reviewDO in gameReviews)
{
//get review information
ReviewPO reviewPO = _ReviewMapper.MapDOtoPO(reviewDO);
//get game information for title
GameDO reviewGame = _GameDataAccess.ViewGameByID(reviewPO.GameID);
reviewPO.GameTitle = gameDO.Title;
//get user information for username
UserDO userDO = _UserDataAccess.ViewUserByID(reviewPO.UserID);
reviewPO.Username = userDO.Username;
mappedReviews.Add(reviewPO);
}
//filter list and map to view model
viewModel.ReviewsList = mappedReviews.Where(n => n.GameID == viewModel.Game.GameID).ToList();
response = View(viewModel);
}
catch (Exception ex)
{
//log error
_Logger.ErrorLog(MethodBase.GetCurrentMethod().DeclaringType.Name, MethodBase.GetCurrentMethod().Name, ex);
response = RedirectToAction("Error", "Home");
}
finally { }
}
else
{
//if id is not valid, return to game list
response = RedirectToAction("Index", "Game");
}
return(response);
}
public List <GameDO> ViewGames()
{
List <GameDO> gameList = new List <GameDO>();
try
{
using (SqlConnection connection = new SqlConnection(connectionString))
{
SqlCommand command = new SqlCommand("VIEW_GAMES", connection);
command.CommandType = CommandType.StoredProcedure;
connection.Open();
SqlDataReader reader = command.ExecuteReader();
while (reader.Read())
{
GameDO gameObject = new GameDO();
gameObject.GameID = reader.GetInt64(0);
gameObject.GameTitle = reader.GetString(1);
if (!reader.IsDBNull(2))
{
gameObject.RomanNumeral = reader.GetString(2);
}
else
{
}
gameObject.ReleaseDate = reader.GetString(3);
if (!reader.IsDBNull(4))
{
gameObject.CopiesSold = reader.GetInt32(4);
}
else
{
}
gameObject.GameSummary = reader.GetString(5);
if (!reader.IsDBNull(6))
{
gameObject.Price = reader.GetDecimal(6);
}
else
{
}
gameList.Add(gameObject);
}
connection.Close();
command.Dispose();
connection.Dispose();
}
}
catch (Exception ex)
{
ErrorLog error = new ErrorLog();
error.Log(ex, "ViewGames", "DAL", "Error");
}
return(gameList);
}
public List <GameDO> ViewGames()
{
//Setting the variables to be used for this method.
SqlConnection connectionToSql = null;
SqlCommand storedProcedure = null;
SqlDataReader reader = null;
List <GameDO> gameList = new List <GameDO>();
GameDO gameObject = new GameDO();
try
{
//Set up for connecting to SQL, using the stored procedure and how to access the information.
connectionToSql = new SqlConnection(_connectionString);
storedProcedure = new SqlCommand("OBTAIN_GAMES", connectionToSql);
storedProcedure.CommandType = System.Data.CommandType.StoredProcedure;
//Opens the connection to SQL.
connectionToSql.Open();
//Tell SQLDataReader to gather the information from SQL as determined by the stored procedure.
reader = storedProcedure.ExecuteReader();
//Cycle through the database and apply each property in SQL to an object
//Then add that object to a list of objects.
while (reader.Read())
{
gameObject = new GameDO();
gameObject.GameID = int.Parse(reader["GameID"].ToString());
gameObject.GameName = reader["GameName"].ToString();
gameObject.ReleaseYear = short.Parse(reader["ReleaseYear"].ToString());
gameObject.Genre = reader["Genre"].ToString();
gameObject.Developer = reader["Developer"].ToString();
gameObject.Publisher = reader["Publisher"].ToString();
gameObject.Platform = reader["Platform"].ToString();
gameObject.Download = reader["Download"].ToString();
gameObject.Picture = reader["Picture"].ToString();
gameObject.Description = reader["Description"].ToString();
gameList.Add(gameObject);
}
}
catch (Exception ex)
{
LoggerDAL.Log(ex, "Fatal");
//If an issue occurs, the result would likely be fatal, throw the exception.
throw ex;
}
finally
{
//When the connection has been established, close and dispose the connection before finishing.
if (connectionToSql != null)
{
connectionToSql.Close();
connectionToSql.Dispose();
}
}
return(gameList);
}
//This method id called to the the game's information if a comment fails to add.
private void FillTempData(int specificGame = default(int))
{
//Gets the game information and sets the temp data for a specific game.
GameDO game = _gameDataAccess.GameDetails(specificGame);
if (game != null)
{
TempData["GameName"] = game.GameName;
}
}
public ActionResult AddGame(Game form)
{
ActionResult response;
// checks role
if (Session["RoleId"] != null && (long)Session["RoleId"] == 5)
{
try
{
//check modelstate
if (ModelState.IsValid)
{
//maps dataObject new game DO
GameDO dataObject = new GameDO();
dataObject.GameId = form.GameId;
dataObject.Title = form.Title;
dataObject.Description = form.Description;
dataObject.DevelopingCompany = form.DevelopingCompany;
dataObject.GameCondition = form.Condition;
dataObject.Price = form.Price;
//Adds a game based off the dao
_GameDataAccess.AddGame(dataObject);
//Temporarily holds onto the title
TempData["Title"] = dataObject.Title;
response = RedirectToAction("AddGame", "Game");
}
else
{ // sets the response to View the form
response = View(form);
}
}
//catches and exception and logs it
catch (SqlException sqlex)
{
_Logger.ErrorLog(MethodBase.GetCurrentMethod().DeclaringType.Name, MethodBase.GetCurrentMethod().Name, sqlex);
response = RedirectToAction("AllUsers", "Account");
}
catch (Exception ex)
{
_Logger.ErrorLog(MethodBase.GetCurrentMethod().DeclaringType.Name, MethodBase.GetCurrentMethod().Name, ex);
response = RedirectToAction("AllUsers", "Account");
}
}
else//if the check fails sets the response
{
response = RedirectToAction("Login", "Account");
}
return(response);
}
public GamePO MapDOtoPO(GameDO gameDO)
{
GamePO gamePO = new GamePO();
gamePO.GameID = gameDO.GameID;
gamePO.Title = gameDO.Title;
gamePO.ReleaseDate = gameDO.ReleaseDate;
gamePO.Developer = gameDO.Developer;
gamePO.Platform = gameDO.Platform;
return(gamePO);
}
public GameDO GameDetails(int GameID)
{
//Setting the variables to be used for this method.
SqlConnection connectionToSql = null;
SqlCommand storedProcedure = null;
SqlDataReader reader = null;
GameDO gameObject = new GameDO();
try
{
//Set up for connecting to SQL, using the stored procedure and how to access the information.
connectionToSql = new SqlConnection(_connectionString);
storedProcedure = new SqlCommand("VIEW_GAME", connectionToSql);
storedProcedure.CommandType = System.Data.CommandType.StoredProcedure;
//Applies the game Id given to the method to the stored procedure.
storedProcedure.Parameters.AddWithValue("@GameID", GameID);
//Opens the connection to SQL.
connectionToSql.Open();
//Tell SQLDataReader to gather the information from SQL as determined by the stored procedure.
reader = storedProcedure.ExecuteReader();
//Reads all the information in SQL via the stored procedure and applies the data to the object.
while (reader.Read())
{
gameObject.GameID = int.Parse(reader["GameID"].ToString());
gameObject.GameName = reader["GameName"].ToString();
gameObject.ReleaseYear = short.Parse(reader["ReleaseYear"].ToString());
gameObject.Genre = reader["Genre"].ToString();
gameObject.Developer = reader["Developer"].ToString();
gameObject.Publisher = reader["Publisher"].ToString();
gameObject.Platform = reader["Platform"].ToString();
gameObject.Download = reader["Download"].ToString();
gameObject.Picture = reader["Picture"].ToString();
gameObject.Description = reader["Description"].ToString();
}
}
catch (Exception ex)
{
LoggerDAL.Log(ex, "Fatal");
//If an issue occurs, the result would likely be fatal, throw the exception.
throw ex;
}
finally
{
//When the connection has been established, close and dispose the connection before finishing.
if (connectionToSql != null)
{
connectionToSql.Close();
connectionToSql.Dispose();
}
}
return(gameObject);
}
public GameDO MapPoToDo(Game from)
{
GameDO to = new GameDO();
to.GameId = from.GameId;
to.Title = from.Title;
to.Description = from.Description;
to.DevelopingCompany = from.DevelopingCompany;
to.GameCondition = from.Condition;
to.Price = from.Price;
return(to);
}
public ActionResult ViewGameComments(int specificGame = default(int))
{
ActionResult response = null;
try
{
//Access the comments if a GameID is given
if (specificGame != 0)
{
//Store the game's information, proceed if the game at given ID exists.
GameDO game = _gameDataAccess.GameDetails(specificGame);
if (game != null)
{
//Get game comments from the database, map them to presentation,
//pass them to the ViewModel.
List <CommentDO> commentList = _dataAccess.ViewGameComments(specificGame);
List <CommentPO> displayComments = Mapper.ListCommentDOtoPO(commentList);
ViewCommentPO viewComment = new ViewCommentPO(displayComments);
//Get and set game name.
TempData["GameName"] = game.GameName;
//Attach user information.
if (Session["UserID"] == null)
{
viewComment.Comment.GameID = specificGame;
}
else
{
viewComment.Comment.GameID = specificGame;
viewComment.Comment.UserID = (int)Session["UserID"];
}
response = View(viewComment);
}
//No game found, redirect to game index.
else
{
response = RedirectToAction("Index", "Games");
}
}
else
{
response = RedirectToAction("Index", "Games");
}
}
catch (Exception ex)
{
Logger.Log(ex);
response = RedirectToAction("Index", "Games");
}
finally { }
return(response);
}
public Game MapDoToPo(GameDO from)
{
Game to = new Game();
to.GameId = from.GameId;
to.Title = from.Title;
to.Description = from.Description;
to.DevelopingCompany = from.DevelopingCompany;
to.Condition = from.GameCondition;
to.Price = from.Price;
return(to);
}
//Method for assigning data from database values to c# values
private static GameDO RowToItem(DataRow iSource)
{
//establishing new object
GameDO to = new GameDO();
//pulling "Value" from SQL, casting it or converting it as necessary, and assigning it to it's c# equivalent
to.GameId = (long)iSource["GameId"];
//Checking if SQL value is null or not, and if not, proceeds into the if
if (iSource["WhitePlayer"] != DBNull.Value)
{
//pulling "Value" from SQL, casting it or converting it as necessary, and assigning it to it's c# equivalent
to.WhiteName = iSource["WhitePlayer"].ToString();
}
//Checking if SQL value is null or not, and if not, proceeds into the if
if (iSource["WhiteRating"] != DBNull.Value)
{
//pulling "Value" from SQL, casting it or converting it as necessary, and assigning it to it's c# equivalent
to.WhiteRating = (int)iSource["WhiteRating"];
}
//Checking if SQL value is null or not, and if not, proceeds into the if
if (iSource["BlackPlayer"] != DBNull.Value)
{
//pulling "Value" from SQL, casting it or converting it as necessary, and assigning it to it's c# equivalent
to.BlackName = iSource["BlackPlayer"].ToString();
}
//Checking if SQL value is null or not, and if not, proceeds into the if
if (iSource["BlackRating"] != DBNull.Value)
{
//pulling "Value" from SQL, casting it or converting it as necessary, and assigning it to it's c# equivalent
to.BlackRating = (int)iSource["BlackRating"];
}
//Checking if SQL value is null or not, and if not, proceeds into the if
if (iSource["Location"] != DBNull.Value)
{
//pulling "Value" from SQL, casting it or converting it as necessary, and assigning it to it's c# equivalent
to.Location = iSource["Location"].ToString();
}
//Checking if SQL value is null or not, and if not, proceeds into the if
if (iSource["DatePlayed"] != DBNull.Value)
{
//pulling "Value" from SQL, casting it or converting it as necessary, and assigning it to it's c# equivalent
to.DatePlayed = (DateTime)iSource["DatePlayed"];
}
//Checking if SQL value is null or not, and if not, proceeds into the if
if (iSource["Winner"] != DBNull.Value)
{
//pulling "Value" from SQL, casting it or converting it as necessary, and assigning it to it's c# equivalent
to.Winner = iSource["Winner"].ToString();
}
//Return all data to previous method
return(to);
}
public GamePO GameDOToPO(GameDO gameDO)
{
GamePO gamePO = new GamePO();
gamePO.GameID = gameDO.GameID;
gamePO.GameTitle = gameDO.GameTitle;
gamePO.RomanNumeral = gameDO.RomanNumeral;
gamePO.ReleaseDate = gameDO.ReleaseDate;
gamePO.CopiesSold = gameDO.CopiesSold;
gamePO.GameSummary = gameDO.GameSummary;
gamePO.Price = gameDO.Price;
return(gamePO);
}
public GameDO ViewGameByID(Int64 GameID)
{
GameDO gameObject = new GameDO();
try
{
using (SqlConnection connection = new SqlConnection(connectionString))
{
SqlCommand command = new SqlCommand("VIEW_GAME_BY_ID", connection);
command.CommandType = CommandType.StoredProcedure;
connection.Open();
command.Parameters.AddWithValue("@gameID", GameID);
SqlDataReader reader = command.ExecuteReader();
reader.Read();
gameObject.GameID = reader.GetInt64(0);
gameObject.GameTitle = reader.GetString(1);
if (!reader.IsDBNull(2))
{
gameObject.RomanNumeral = reader.GetString(2);
}
else
{
}
gameObject.ReleaseDate = reader.GetString(3);
if (!reader.IsDBNull(4))
{
gameObject.CopiesSold = reader.GetInt32(4);
}
else
{
}
gameObject.GameSummary = reader.GetString(5);
if (!reader.IsDBNull(6))
{
gameObject.Price = reader.GetDecimal(6);
}
else
{
}
connection.Close();
command.Dispose();
connection.Dispose();
}
}
catch (Exception ex)
{
ErrorLog error = new ErrorLog();
error.Log(ex, "ViewGameByID", "DAL", "Error");
}
return(gameObject);
}
//Method for viewing more specific details of a game
public GameDO GameReadByID(long gameId)
{
//Defining SqlConnection for this method
SqlConnection scon = null;
//Establishing a new data adapter
SqlDataAdapter iDReader = null;
//Establishing a new data table
DataTable table = new DataTable();
//Establishing new object using model GameDO
GameDO game = new GameDO();
//Beginning of method processes
try
{
scon = new SqlConnection(_conn);
//Defining a variable for the SqlCommand, as well as the stored proc and connection we're using
SqlCommand readRowById = new SqlCommand("GAME_READ_BY_ID", scon);
//Defining what kind of command our SqlCommand is
readRowById.CommandType = CommandType.StoredProcedure;
//Adding in all the variables. Format: ("@SqlVariable", C#VariableValue)
readRowById.Parameters.AddWithValue("@GameId", gameId);
//opening sql connection
scon.Open();
//defining our adapter and what command it uses
iDReader = new SqlDataAdapter(readRowById);
//telling the code to use the stored procedure
readRowById.ExecuteNonQuery();
//telling code to use the data table to fill itself
iDReader.Fill(table);
//setting our object equal to all information pulled from database by running it through a mapper
game = GameListMap.DataTableToList(table).FirstOrDefault();
}
//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 for viewing more specific details of a game
return(game);
}
public ActionResult Delete(long GameId)
{
//set response
ActionResult response;
// do a check
if (Session["RoleId"] != null && (long)Session["RoleId"] == 5)
{
try
{
//pulls from database to push one game
GameDO game = _GameDataAccess.ViewGameByGameId(GameId);
//adding delete function
Game deletedGame = _Mapper.MapDoToPo(game);
//deleting game by id
GameId = deletedGame.GameId;
//check id CANT be default or less than 0
if (GameId > 0)
{
//delteing the game
_GameDataAccess.DeleteGame(GameId);
//once deleted rta to view all games
response = RedirectToAction("ViewAllGames", "Game");
}
else
{
response = RedirectToAction("ViewAllGames", "Game");
}
}
catch (SqlException sqlex)
{
_Logger.ErrorLog(MethodBase.GetCurrentMethod().DeclaringType.Name, MethodBase.GetCurrentMethod().Name, sqlex);
response = RedirectToAction("Index", "Home");
}
catch (Exception ex)
{
_Logger.ErrorLog(MethodBase.GetCurrentMethod().DeclaringType.Name, MethodBase.GetCurrentMethod().Name, ex);
response = RedirectToAction("Index", "Home");
}
}
else
{
response = RedirectToAction("Login", "Account");
}
return(RedirectToAction("ViewAllGames", "Game"));
}
// game datails grabs the id of that game and shows the details
public ActionResult GameDetails(long GameId)
{
ActionResult result;
try
{
//check
if (Session["RoleId"] != null && (long)Session["RoleId"] >= 3)
{
//instantiate game by game id
GameDO game = _GameDataAccess.ViewGameByGameId(GameId);
//maps from do to po
Game detailsGame = _Mapper.MapDoToPo(game);
//check
if (detailsGame.GameId > 0)
{
//returns the view
result = View(detailsGame);
}
else
{
//result = rta to view all games
result = RedirectToAction("ViewAllGames", "Game");
}
}
//if check fails
else
{
result = RedirectToAction("Login", ("Account"));
}
}
catch (SqlException sqlex)
{
_Logger.ErrorLog(MethodBase.GetCurrentMethod().DeclaringType.Name, MethodBase.GetCurrentMethod().Name, sqlex);
result = RedirectToAction("Index", "Home");
}
catch (Exception ex)
{
_Logger.ErrorLog(MethodBase.GetCurrentMethod().DeclaringType.Name, MethodBase.GetCurrentMethod().Name, ex);
result = RedirectToAction("Index", "Home");
}
return(result);
}
//Map the properties from the DataAccess to the Presentation.
public static GamePO GameDOtoPO(GameDO from)
{
GamePO to = new GamePO();
to.GameID = from.GameID;
to.GameName = from.GameName;
to.ReleaseYear = from.ReleaseYear;
to.Genre = from.Genre;
to.Developer = from.Developer;
to.Publisher = from.Publisher;
to.Platform = from.Platform;
to.Download = from.Download;
to.Picture = from.Picture;
to.Description = from.Description;
return(to);
}
/// <summary>
/// Reads one record from the Games table in the GAMEGROOVE database
/// </summary>
/// <param name="gameID">ID of the game needing to be viewed</param>
/// <returns></returns>
public GameDO ViewGameByID(int gameID)
{
GameDO game = new GameDO();
//catch errors while accessing the database
try
{
//connect to sql, run stored procedure
using (SqlConnection connection = new SqlConnection(_ConnectionString))
using (SqlCommand command = new SqlCommand("VIEW_GAME_BY_ID", connection))
{
command.CommandType = CommandType.StoredProcedure;
command.CommandTimeout = 60;
//set parameter for stored procedure
command.Parameters.AddWithValue("@GameID", gameID);
connection.Open();
//read from the database, uses [if] statement to read only one record
using (SqlDataReader reader = command.ExecuteReader())
{
if (reader.Read())
{
game = _Mapper.MapReaderToSingle(reader);
}
}
}
}
//catch sqlexceptions for accurate logging
catch (SqlException ex)
{
//log error
_Logger.ErrorLog(MethodBase.GetCurrentMethod().DeclaringType.Name, MethodBase.GetCurrentMethod().Name, ex);
throw ex;
}
//catch further exceptions
catch (Exception ex)
{
//log error
_Logger.ErrorLog(MethodBase.GetCurrentMethod().DeclaringType.Name, MethodBase.GetCurrentMethod().Name, ex);
throw ex;
}
finally { }
return(game);
}
