} // end method ReadGamer() //The CreateGamer method //Purpose: To create a GamingCenter entry //Parameters: A GamingCenter object represented as _gamer //Return: None public void CreateGamer(GamingCenter _gamer) { //Create SQL command - INSERT INTO GC table using given values string cmdText = @" INSERT INTO dbo.GamingCenter (FirstName, LastName, UserID, GameType, ItemType, IsUVUStudent, Date) VALUES (@firstName, @lastName, @userID, @gameType, @itemType, @isUVUStudent, @date) --Get primary key of new entry SELECT Id = Scope_Identity()"; //Create new SqlCommand and execute query using (SqlCommand cmd = new SqlCommand(cmdText, _conn)) { //Add all parameters to command object cmd.Parameters.AddWithValue("@firstName", _gamer.FirstName); cmd.Parameters.AddWithValue("@lastName", _gamer.LastName); cmd.Parameters.AddWithValue("@userID", _gamer.UserID); cmd.Parameters.AddWithValue("@gameType", _gamer.GameType.ToString()); cmd.Parameters.AddWithValue("@itemType", _gamer.ItemType.ToString()); cmd.Parameters.AddWithValue("@isUVUStudent", _gamer.IsUVUStudent); cmd.Parameters.AddWithValue("@date", _gamer.Date); //Create new SqlDatReader and execute reader using (SqlDataReader reader = cmd.ExecuteReader()) { //If data exists - READ if (reader.Read()) { //Get return value from table, convert to int, and save _gamer.Id = Convert.ToInt32(reader["Id"]); } // end if } // end using } // end using } // end method CreateGamer()
} // end method ReadAllGamingCenter() //The ReadGamer method //Purpose: To read the specified gamer from the GamingCenter table //Parameters: An int represented as _id //Return: A gamer in the form of a GamingCenter object public GamingCenter ReadGamer(int _id) { //Create SQL command - SELECT all data members from GC table with given id string cmdText = @" SELECT Id, FirstName, LastName, UserID, GameType, ItemType, IsUVUStudent, Date FROM dbo.GamingCenter WHERE Id = @id"; //Create new GamingCenter object and initialize to null GamingCenter gamer = null; //Create new SqlCommand and execute query using (SqlCommand cmd = new SqlCommand(cmdText, _conn)) { //Add id parameter to command object cmd.Parameters.AddWithValue("@id", _id); //Create new SqlDatReader and execute reader using (SqlDataReader reader = cmd.ExecuteReader()) { //If data exists - READ if (reader.Read()) { //Create new GamingCenter object gamer = new GamingCenter(); //Read values and save gamer.Id = (int)reader["Id"]; gamer.FirstName = (string)reader["FirstName"]; gamer.LastName = (string)reader["LastName"]; gamer.UserID = (string)reader["UserID"]; gamer.GameType = (GameType)Enum.Parse(typeof(GameType), (string)reader["GameType"]); gamer.ItemType = (ItemType)Enum.Parse(typeof(ItemType), (string)reader["ItemType"]); gamer.IsUVUStudent = (bool)reader["IsUVUStudent"]; gamer.Date = (DateTime)reader["Date"]; } // end if } // end using } // end using return(gamer); } // end method ReadGamer()
} // end method Dispose //The ReadAllGamingCenter method //Purpose: To read all gamers from the GamingCenter table //Parameters: None //Return: A list of GamingCenter objects in the form of a list public List <GamingCenter> ReadAllGamingCenter() { //Create SQL command - SELECT all data members from GC table string cmdText = @" SELECT Id, FirstName, LastName, UserID, GameType, ItemType, IsUVUStudent, Date FROM dbo.GamingCenter"; //Create list of GamingCenter objects List <GamingCenter> list = new List <GamingCenter>(); //Create new SqlCommand and execute query using (SqlCommand cmd = new SqlCommand(cmdText, _conn)) { //Create new SqlDatReader and execute reader using (SqlDataReader reader = cmd.ExecuteReader()) { //While data exists - READ while (reader.Read()) { //Create new GamingCenter object GamingCenter gamer = new GamingCenter(); //Read values and save gamer.Id = (int)reader["Id"]; gamer.FirstName = (string)reader["FirstName"]; gamer.LastName = (string)reader["LastName"]; gamer.UserID = (string)reader["UserID"]; gamer.GameType = (GameType)Enum.Parse(typeof(GameType), (string)reader["GameType"]); gamer.ItemType = (ItemType)Enum.Parse(typeof(ItemType), (string)reader["ItemType"]); gamer.IsUVUStudent = (bool)reader["IsUVUStudent"]; gamer.Date = (DateTime)reader["Date"]; //Add gamer to list list.Add(gamer); } // end while } // end using } // end using return(list); } // end method ReadAllGamingCenter()
} // end method CreateGamer() //The UpdateGamer method //Purpose: To update a GamingCenter entry //Parameters: A GamingCenter object represented as _gamer //Return: None public void UpdateGamer(GamingCenter _gamer) { //Create SQL command - UPDATE GC table and SET given values, for gamer with specified Id string cmdText = @" UPDATE dbo.GamingCenter SET FirstName = @firstName, LastName = @lastName, UserID = @userID, GameType = @gameType, ItemType = @itemType, IsUVUStudent = @isUVUStudent, Date = @date WHERE Id = @id"; //Create new SqlCommand and execute query using (SqlCommand cmd = new SqlCommand(cmdText, _conn)) { //Add all parameters to command object cmd.Parameters.AddWithValue("@firstName", _gamer.FirstName); cmd.Parameters.AddWithValue("@lastName", _gamer.LastName); cmd.Parameters.AddWithValue("@userID", _gamer.UserID); cmd.Parameters.AddWithValue("@gameType", _gamer.GameType.ToString()); cmd.Parameters.AddWithValue("@itemType", _gamer.ItemType.ToString()); cmd.Parameters.AddWithValue("@isUVUStudent", _gamer.IsUVUStudent); cmd.Parameters.AddWithValue("@date", _gamer.Date); cmd.Parameters.AddWithValue("@id", _gamer.Id); //Run the query and save rowCount int rowCount = cmd.ExecuteNonQuery(); //If rowCount is less than 1 if (rowCount < 1) { //Throw exception throw new Exception("No rows were updated in UpdateGamer()"); } // end if } // end using } // end method UpdateGamer()