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); }