public void Update(Mobile_Suit MobileSuit)
{
using (var cn = new SqlConnection(Settings.GetConnectionString()))
{
SqlCommand cmd = new SqlCommand("MobileSuitUpdate", cn);
cmd.CommandType = System.Data.CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@InventoryNumber", MobileSuit.InventoryNumber);
cmd.Parameters.AddWithValue("@SerialNumber", MobileSuit.SerialNumber);
cmd.Parameters.AddWithValue("@TypeID", MobileSuit.TypeID);
cmd.Parameters.AddWithValue("@Name", MobileSuit.Name);
cmd.Parameters.AddWithValue("@Year", MobileSuit.Year);
cmd.Parameters.AddWithValue("@CenturyID", MobileSuit.CenturyID);
cmd.Parameters.AddWithValue("@MakeModelID", MobileSuit.MakeModelID);
cmd.Parameters.AddWithValue("@BodyStyleID", MobileSuit.BodyStyleID);
cmd.Parameters.AddWithValue("@WeaponID", MobileSuit.WeaponID);
cmd.Parameters.AddWithValue("@ColorID", MobileSuit.ColorID);
cmd.Parameters.AddWithValue("@Interior", MobileSuit.Interior);
cmd.Parameters.AddWithValue("@MSRP", MobileSuit.MSRP);
cmd.Parameters.AddWithValue("@SalePrice", MobileSuit.SalePrice);
cmd.Parameters.AddWithValue("@Description", MobileSuit.Description);
cmd.Parameters.AddWithValue("@Image", MobileSuit.Image);
cmd.Parameters.AddWithValue("@UserID", MobileSuit.UserID);
cmd.Parameters.AddWithValue("@Featured", MobileSuit.Featured);
cn.Open();
cmd.ExecuteNonQuery();
}
}
public void CanInsertMobileSuit()
{
Mobile_Suit MobileSuit = new Mobile_Suit();
var repo = new MobileSuitRepositoryADO();
MobileSuit.UserID = "11111111-1111-1111-1111-111111111111";
MobileSuit.BodyStyleID = 1;
MobileSuit.ColorID = 2;
MobileSuit.Interior = 2;
MobileSuit.Description = "Custom Red Zaku II, Customized for peak performance for commanders of the Zeon army. 3x Faster than the base model with an added shield attatchment. ";
MobileSuit.MakeModelID = 2;
MobileSuit.MSRP = 120000;
MobileSuit.SalePrice = 100000;
MobileSuit.SerialNumber = "0123456789";
MobileSuit.TypeID = 2;
MobileSuit.WeaponID = 1;
MobileSuit.Year = 0079;
MobileSuit.Name = "Zaku II Commander Type";
MobileSuit.Image = "Placeholder.Jpeg";
MobileSuit.CenturyID = 1;
MobileSuit.Featured = true;
repo.Insert(MobileSuit);
Assert.AreEqual(7, MobileSuit.InventoryNumber);
}
public Mobile_Suit GetById(int MobileSuitId)
{
Mobile_Suit MobileSuit = new Mobile_Suit();
using (var cn = new SqlConnection(Settings.GetConnectionString()))
{
SqlCommand cmd = new SqlCommand("MobileSuitSelect", cn);
cmd.CommandType = System.Data.CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@InventoryNumber", MobileSuitId);
cn.Open();
using (SqlDataReader rdr = cmd.ExecuteReader())
{
if (rdr.Read())
{
MobileSuit.SerialNumber = rdr["SerialNumber"].ToString();
MobileSuit.TypeID = (int)rdr["TypeID"];
MobileSuit.Name = rdr["Name"].ToString();
MobileSuit.Year = (int)rdr["Year"];
MobileSuit.CenturyID = (int)rdr["CenturyID"];
MobileSuit.MakeModelID = (int)rdr["MakeModelID"];
MobileSuit.BodyStyleID = (int)rdr["BodyStyleID"];
MobileSuit.WeaponID = (int)rdr["WeaponID"];
MobileSuit.ColorID = (int)rdr["ColorID"];
MobileSuit.Interior = (int)rdr["Interior"];
MobileSuit.MSRP = (int)rdr["MSRP"];
MobileSuit.SalePrice = (int)rdr["SalePrice"];
MobileSuit.Description = rdr["Description"].ToString();
if (rdr["Image"] != DBNull.Value)
{
MobileSuit.Image = rdr["Image"].ToString();
}
MobileSuit.UserID = rdr["UserID"].ToString();
MobileSuit.InventoryNumber = MobileSuitId;
}
}
}
return(MobileSuit);
}
