public void TickMarkTest()
{
TickMark tick = new TickMark("Test", 0);
Assert.AreEqual("Test", tick.GetName());
Assert.AreEqual(0, tick.GetXPlacement());
}
public void ClearTickMarkTest()
{
TimeLine tline = new TimeLine("Test");
TickMark tick = new TickMark("Test", 0);
tline.ClearTicks();
List<TickMark> test = tline.GetTicks();
Assert.AreEqual(0, test.Count());
tline.NewTickMark(tick);
Assert.AreEqual(1, test.Count());
}
public void TimeLineTest()
{
TimeLine timeline = new TimeLine("Test");
TickMark tick = new TickMark("Test", 0);
Assert.AreEqual(13, timeline.GetID());
Assert.AreEqual(Convert.ToDateTime("1/1/1900 12:00:00 AM"), timeline.GetStartDate());
Assert.AreEqual(Convert.ToDateTime("1/1/1900 12:00:00 AM"), timeline.GetEndDate());
Assert.AreEqual(1, timeline.GetTicks().Count());
TickMark first = timeline.GetTicks().First();
Assert.AreEqual(tick.GetName(), first.GetName());
Assert.AreEqual(tick.GetXPlacement(), first.GetXPlacement());
}
public static void AddTick(string mapName, int pos, string label)
{
RoadMap map = new RoadMap(mapName);
TimeLine TL = map.GetTimeline();
if(TL== null)
{
map.CreateTimeLine(mapName);
}
TL = map.GetTimeline();
TickMark tickmark = new TickMark(label, pos);
TL.NewTickMark(tickmark);
}
public void CreateandDeleteTickMarkTest()
{
TimeLine tline = new TimeLine("Test");
TickMark tick = new TickMark("NEWTest", 0);
List<TickMark> ticklist = tline.GetTicks();
Assert.AreEqual(1, ticklist.Count());
Assert.IsTrue(tline.NewTickMark(tick));
ticklist = tline.GetTicks();
Assert.AreEqual(2, ticklist.Count());
Assert.IsTrue(tline.DeleteTickMark(tick));
ticklist = tline.GetTicks();
Assert.AreEqual(1, ticklist.Count());
}
public bool NewTickMark(TickMark tick)
{
bool toReturn = false;
//add Tickmark
mTicks.Add(tick);
using (SqlConnection conn = new SqlConnection(ConfigurationManager.ConnectionStrings["connstring"].ConnectionString))
{
using (SqlCommand cmd = new SqlCommand())
{
cmd.CommandText = "INSERT INTO [dbo].[TickMark] ( Name, XPlacement, TimelineName ) VALUES (@tname,@X,@Timeline)";
cmd.Parameters.AddWithValue("@tname", tick.GetName());
cmd.Parameters.AddWithValue("@X", tick.GetXPlacement());
cmd.Parameters.AddWithValue("@Timeline", mName);
cmd.Connection = conn;
conn.Open();
if (cmd.ExecuteNonQuery()!=0)
{
toReturn = true;
}
conn.Close();
}
}
return toReturn;
}
public TimeLine(string roadmapname)
{
using (SqlConnection conn = new SqlConnection(ConfigurationManager.ConnectionStrings["connstring"].ConnectionString))
{
//using (SqlCommand cmd = new SqlCommand())
//{
// cmd.CommandText = "SELECT Name, StartDate, EndDate FROM [dbo].[Timeline] WHERE RoadmapName =@Rname";
// cmd.Parameters.AddWithValue("@Rname", roadmapname);
// mReader = mDatabase.executereadparams(cmd);
// mReader.Read();
// // mName = mReader.GetString(0);
// // mStartDate = mReader.GetDateTime(1);
// // mEndDate = mReader.GetDateTime(2);
//}
mName = roadmapname;
using (SqlCommand cmd = new SqlCommand())
{
cmd.CommandText = "INSERT INTO [dbo].[Timeline] (Name, RoadmapName) VALUES (@name,@Rname)";
cmd.Parameters.AddWithValue("@Rname", roadmapname);
cmd.Parameters.AddWithValue("@name", mName);
cmd.Connection = conn;
conn.Open();
try
{
cmd.ExecuteNonQuery();
}
catch (Exception ex) { }
conn.Close();
}
using (SqlCommand cmd2 = new SqlCommand())
{
cmd2.CommandText = "SELECT Name, XPlacement FROM [dbo].[TickMark] WHERE TimelineName =@Tname";
cmd2.Parameters.AddWithValue("@Tname", mName);
cmd2.Connection = conn;
conn.Open();
using (SqlDataReader Reader = cmd2.ExecuteReader())
{
while (Reader.Read())
{
TickMark tick = new TickMark(Reader.GetString(0).ToString(), Reader.GetInt32(1));
mTicks.Add(tick);
}
}
conn.Close();
}
using (SqlCommand cmd3 = new SqlCommand())
{
cmd3.CommandText = "SELECT Name, StartDate, EndDate FROM [dbo].[Timeline] WHERE RoadmapName =@Rname";
cmd3.Parameters.AddWithValue("@Rname", roadmapname);
cmd3.Connection = conn;
conn.Open();
using (SqlDataReader Reader = cmd3.ExecuteReader())
{
Reader.Read();
mName = Reader.GetString(0);
}
conn.Close();
}
}
//mDatabase.connect();
//mReader = mDatabase.executeread("SELECT Name, StartDate, EndDate FROM [dbo].[Timeline] WHERE RoadmapName = '" + roadmapname + "'");
//mReader.Read();
//mName = mReader.GetString(0);
//mStartDate = mReader.GetDateTime(1);
//mEndDate = mReader.GetDateTime(2);
//mDatabase.close();
//mDatabase.connect();
//mReader = mDatabase.executeread("SELECT Name, XPlacement FROM [dbo].[TickMark] WHERE TimelineName = '" + mName + "'");
//while (mReader.Read())
//{
// TickMark tick = new TickMark(mReader.GetString(0).ToString(), mReader.GetInt32(1));
// mTicks.Add(tick);
//}
//mDatabase.close();
}
public bool DeleteTickMark(TickMark tick)
{
bool toReturn = false;
//delete Tickmark
mTicks.Remove(tick);
using (SqlConnection conn = new SqlConnection(ConfigurationManager.ConnectionStrings["connstring"].ConnectionString))
{
using (SqlCommand cmd = new SqlCommand())
{
cmd.CommandText = "DELETE FROM [dbo].[TickMark] WHERE Name = @tName AND TimelineName =@timeline";
cmd.Parameters.AddWithValue("@tName", tick.GetName());
cmd.Parameters.AddWithValue("@timeline", mName);
cmd.Connection = conn;
conn.Open();
if (cmd.ExecuteNonQuery()!=0)
{
toReturn = true;
}
conn.Close();
}
}
return toReturn;
}
public static void EditTickLocation(string mapName, float pos, string label)
{
TickMark tickmark = new TickMark(label, (int)pos);
tickmark.EditTickLocation((int)pos, mapName);
}
