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