public void EditStrategyPointTest() { StrategyPoint sp = new StrategyPoint("Test", "TEST"); Assert.IsTrue(sp.EditDescription("NEW")); Assert.AreEqual("NEW", sp.GetDescription()); Assert.IsTrue(sp.EditName("NEW")); Assert.AreEqual("NEW", sp.GetName()); StrategyPoint testsp = new StrategyPoint("NEW", "NEW"); Assert.AreEqual("NEW", sp.GetName()); Assert.AreEqual("NEW", sp.GetDescription()); Assert.IsTrue(sp.EditName("Test")); Assert.IsTrue(sp.EditDescription("TEST")); }
//Reorders strategy points to insert one in the middle public void ReOrderStrategyPoint(string currname,string desc, bool isFirst) { //Get current strategy point StrategyPoint current = new StrategyPoint(currname, desc, mName); int index = (int)Char.GetNumericValue(currname[8]) + 1; string nextID = "StratBox"+index.ToString(); string nextdesc=null; //Move next one up string selectname = null; if (isFirst) selectname = currname; else selectname = nextID; using (SqlConnection conn = new SqlConnection(ConfigurationManager.ConnectionStrings["connstring"].ConnectionString)) { using (SqlCommand cmd = new SqlCommand()) { cmd.CommandText = "SELECT Description FROM [dbo].[StrategyPoint] WHERE Name=@sname AND RoadmapName=@Rname"; cmd.Parameters.AddWithValue("@sname", selectname); cmd.Parameters.AddWithValue("@Rname", mName); cmd.Connection = conn; conn.Open(); using (SqlDataReader Reader = cmd.ExecuteReader()) { if (Reader.HasRows) { Reader.Read(); nextdesc = Reader.GetString(0); } Reader.Close(); } conn.Close(); } } //Continue moving strat points up one StrategyPoint next = new StrategyPoint(nextID, nextdesc, mName); StrategyPoint nextdummy = new StrategyPoint(currname, nextdesc, mName); if (nextdesc != null) { nextdummy.EditName(nextID); ReOrderStrategyPoint(nextID, nextdesc, false); } }