//TEST: SPGETUSER_TEST
//Test that a specific user can be retrieved from the database
public void spGetUser_Test()
{
//ARRANGE
string testUserName = "******";
MyDataEntities db = new MyDataEntities();
//Grab a specific user based on their UserName to ensure that we can retreieve them from the DB
var array = db.Users.Where(x => x.UserName == testUserName).ToList();
ObjectResult <Store.Data.spGetUser_Result> result;
//ACT
int initialUserID = 0; int afterUserID = 0;
foreach (var item in array)
{
//Grab our User's ID
initialUserID = item.UserID;
//Then call our stored procedure
result = db.spGetUser(item.UserID);
foreach (var input in result)
{
//Store the returned User ID to compare later
afterUserID = input.UserID;
}
}
//ASSERT
//Check to see that our resulting User is the same as the User we were intending to grab
Assert.AreEqual(initialUserID, afterUserID);
}
