public void TickMarkTest()
{
TickMark tick = new TickMark("Test", 0);
Assert.AreEqual("Test", tick.GetName());
Assert.AreEqual(0, tick.GetXPlacement());
}
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 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 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;
}
