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