第 3 回 品質の高いコード作成 (2) - その 1

public static int GetProductStocks(int productId)
     {
         int result;            
         SqlConnection cn = new SqlConnection(constr);
         SqlCommand cmd = new SqlCommand();

         cmd.Connection = cn;
         cmd.CommandText = "SELECT UnitsInStock FROM Products" +
             " WHERE ProductID = @ProductID";
         SqlParameter parmProdID = cmd.Parameters.Add
             ("@ProductID", SqlDbType.Int);
         parmProdID.Value = productId;
         try
         {
             cn.Open();
             result = (Int16)cmd.ExecuteScalar();
         }
         catch
         {
             result = int.MaxValue;
         }
         finally
         {
             cn.Close();
             cmd.Dispose();
             cn.Dispose();
         }
         return (result);
     }

public class UnitTest1
    {
        public UnitTest1()
        {
            //
            // TODO: コンストラクタ ロジックをここに追加してください
            //
        }
        
        追加テスト属性

       [TestMethod]
        public void TestGetProductName()
        {
            int productId = 1;
            string expected = "Chai";
            string actual;
            actual = MyLibs.MyComp1.GetProductName(productId);
            Assert.AreEqual(expected, actual);
        }

        [TestMethod]
        public void TestGetProductStocks()
        {
            int productId = 1;
            int expected = 39;
            int actual;
            actual = MyLibs.MyComp1.GetProductStocks(productId);
            Assert.AreEqual(expected, actual);
        }
    }

[TestMethod]
        public void TestGetProductName()
        {
            int productId = 1;
            string expected = "Chaix";
            string actual;
            actual = MyLibs.MyComp1.GetProductName(productId);
            Assert.AreEqual(expected, actual);
        }