public int ChangeSKU(ChangeSKU cs) { SqlConnection connection = new SqlConnection(Connection.connectionString()); SqlCommand command = new SqlCommand("usp_changeSKU"); command.CommandType = CommandType.StoredProcedure; command.Parameters.Add(new SqlParameter("@ItemID", cs.itemID)); command.Parameters.Add(new SqlParameter("@NewSKU", cs.newSKU)); command.Connection = connection; connection.Open(); SqlDataAdapter adapter = new SqlDataAdapter(command); DataTable table = new DataTable(); adapter.Fill(table); connection.Close(); if (table.Rows.Count > 0 && table.Rows[0][0].ToString() == cs.newSKU.ToString()) { return(1); } else { return(0); } }
public void ChangeSKUTest() { ChangeSKU cs = new ChangeSKU(); cs.itemID = GetItemID(); cs.newSKU = "1"; int result = controller.ChangeSKU(cs); Assert.AreEqual(result, 1); }