public ActionResult Delete(int id, GamingModel _gamer)
{
try
{
//Create instance of DAL, and pass connection string by calling ConnectionString property
using (GamingCenterDirectoryDB db = new GamingCenterDirectoryDB(ConnectionString))
{
//Call DAL to delete gamer from database
db.DeleteGamer(id);
} // end using
//Return a 302 redirect action to Index page
return(RedirectToAction("Index"));
} // end try
catch (KeyNotFoundException) // gamer _id was bad
{
//Return 404 - Not found status code
return(new HttpStatusCodeResult(
HttpStatusCode.NotFound,
string.Format("Gamer with id={0} unknown", id)));
} // end catch
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 method POST Delete()
[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()