[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()