[TestMethod] // TestMethod attribute public void CreateGamer() { //Call ConfigMgr to get connection string, and save it string connectionString = ConfigurationManager.ConnectionStrings["GamingCenterDBConnectionString"].ConnectionString; //Create new GCDB object using connString, and open connection using (GamingCenterDirectoryDB db = new GamingCenterDirectoryDB(connectionString)) { //Create new GamingCenter object and initialize given values GamingCenter gamer = new GamingCenter() { Id = -1, // database will re-populate id FirstName = "Jane", LastName = "Doe", UserID = "0000000", GameType = GameType.Xbox, ItemType = ItemType.Generic, IsUVUStudent = true, Date = new DateTime(2016, 1, 1) }; // end constructor //Create gamer entry db.CreateGamer(gamer); //Verify Id is NOT negative Assert.IsTrue(gamer.Id > 0); } // end using } // end method createGamer()
[TestMethod] // TestMethod attribute public void UpdateGamer() { //Call ConfigMgr to get connection string, and save it string connectionString = ConfigurationManager.ConnectionStrings["GamingCenterDBConnectionString"].ConnectionString; //Create new GCDB object using connString, and open connection using (GamingCenterDirectoryDB db = new GamingCenterDirectoryDB(connectionString)) { //Create new GamingCenter object and initialize given values GamingCenter gamer = new GamingCenter() { Id = -1, // database will re-populate id FirstName = "Monkey", LastName = "McTester", UserID = "9999999", GameType = GameType.Foos, ItemType = ItemType.Ball, IsUVUStudent = true, Date = new DateTime(2015, 2, 2) }; // end constructor //Create gamer entry db.CreateGamer(gamer); //Verify Id is NOT negative Assert.IsTrue(gamer.Id > 0); //Change all properties to different values gamer.FirstName = "Champ"; gamer.LastName = "Awesometon"; gamer.UserID = "1010101"; gamer.GameType = GameType.PS4; gamer.ItemType = ItemType.Generic; gamer.IsUVUStudent = false; gamer.Date = new DateTime(2000, 10, 10); //Update the entry db.UpdateGamer(gamer); //Read gamer back in and verify changes were made GamingCenter gamerCopy = db.ReadGamer(gamer.Id); Assert.AreEqual(gamer.FirstName, gamerCopy.FirstName); Assert.AreEqual(gamer.LastName, gamerCopy.LastName); Assert.AreEqual(gamer.UserID, gamerCopy.UserID); Assert.AreEqual(gamer.GameType, gamerCopy.GameType); Assert.AreEqual(gamer.ItemType, gamerCopy.ItemType); Assert.AreEqual(gamer.IsUVUStudent, gamerCopy.IsUVUStudent); Assert.AreEqual(gamer.Date, gamerCopy.Date); } // end using } // end method UpdateGamer()
public ActionResult Create(GamingModel _gamer) { //If model is BAD - user validation failed if (AuditModel(_gamer) == -1) { //Return the model and List options _gamer.GameTypeOptions = _gameTypeOptions; _gamer.ItemTypeOptions = _itemTypeOptions; return(View(_gamer)); } // end if else // Model is GOOD { try { //Create instance of DAL, and pass connection string by calling ConnectionString property using (GamingCenterDirectoryDB db = new GamingCenterDirectoryDB(ConnectionString)) { //Create new GamingCenter object GamingCenter dbGamer = new GamingCenter(); //Get each data member of the GamingModel object and save as the corresponding data member of the GamingCenter object dbGamer.FirstName = _gamer.FirstName; dbGamer.LastName = _gamer.LastName; dbGamer.UserID = _gamer.UserID; dbGamer.GameType = (GameType)Enum.Parse(typeof(GameType), _gamer.GameType); dbGamer.ItemType = (ItemType)Enum.Parse(typeof(ItemType), _gamer.ItemType); dbGamer.IsUVUStudent = _gamer.IsUVUStudent; dbGamer.Date = _gamer.Date; //Add Gamer to the db db.CreateGamer(dbGamer); } // end using //Return a 302 redirect action to Index page return(RedirectToAction("Index")); } // end try catch { //Return a HttpStatusCodeResult object, and set status code as 500 (InternalServerError) and pass string to print return(new HttpStatusCodeResult(HttpStatusCode.InternalServerError, "Internal Server Error ")); } // end catch } // end else } // end method POST Create()
[TestMethod] // TestMethod attribute public void DeleteGamer() { //Call ConfigMgr to get connection string, and save it string connectionString = ConfigurationManager.ConnectionStrings["GamingCenterDBConnectionString"].ConnectionString; //Create new GCDB object using connString, and open connection using (GamingCenterDirectoryDB db = new GamingCenterDirectoryDB(connectionString)) { //Create new GamingCenter object and initialize given values GamingCenter gamer = new GamingCenter() { Id = -1, // database will re-populate id FirstName = "Ender", LastName = "Gameless", UserID = "1111111", GameType = GameType.Pong, ItemType = ItemType.PongSet, IsUVUStudent = false, Date = new DateTime(2009, 4, 11) }; // end constructor //Create gamer entry db.CreateGamer(gamer); //Verify Id is NOT negative Assert.IsTrue(gamer.Id > 0); //Delete the entry db.DeleteGamer(gamer.Id); //Get the recently deleted gamer GamingCenter gamerOld = db.ReadGamer(gamer.Id); //Verify the entry is null Assert.IsTrue(gamerOld == null); } // end using } // end method DeleteGamer()