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