public void CanLoadGundamDetails()
{
var repo = new MobileSuitRepositoryADO();
Detail_Result gundams = repo.GetDetails(2);
Assert.AreEqual("UC", gundams.Century);
Assert.AreEqual(79, gundams.Year);
Assert.AreEqual("Custom", gundams.Type);
Assert.AreEqual("Red", gundams.Interior);
Assert.AreEqual("Red", gundams.Color);
Assert.AreEqual("Zaku II Char Custom", gundams.Name);
}
public Detail_Result GetDetails(int MobileSuitId)
{
Detail_Result MobileSuit = new Detail_Result();
using (var cn = new SqlConnection(Settings.GetConnectionString()))
{
SqlCommand cmd = new SqlCommand("MobileSuitSelectDetails", cn);
cmd.CommandType = System.Data.CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@InventoryNumber", MobileSuitId);
cn.Open();
using (SqlDataReader rdr = cmd.ExecuteReader())
{
if (rdr.Read())
{
MobileSuit.Name = rdr["Name"].ToString();
MobileSuit.SerialNumber = rdr["SerialNumber"].ToString();
MobileSuit.Type = rdr["TypeName"].ToString();
MobileSuit.Year = (int)rdr["Year"];
MobileSuit.Century = rdr["CenturyName"].ToString();
MobileSuit.Make = rdr["MakeName"].ToString();
MobileSuit.Model = rdr["ModelName"].ToString();
MobileSuit.BodyStyle = rdr["BodyStyleName"].ToString();
MobileSuit.Weapon = rdr["WeaponName"].ToString();
MobileSuit.Color = rdr["ColorName"].ToString();
MobileSuit.Interior = rdr["Interior"].ToString();
MobileSuit.MSRP = (int)rdr["MSRP"];
MobileSuit.SalePrice = (int)rdr["SalePrice"];
MobileSuit.Description = rdr["Description"].ToString();
MobileSuit.InventoryNumber = MobileSuitId;
if (rdr["Image"] != DBNull.Value)
{
MobileSuit.Image = rdr["Image"].ToString();
}
}
}
}
return(MobileSuit);
}
