public bool DeleteTickMark(TickMark tick) { mDatabase.connect(); bool toReturn = false; //delete Tickmark mTicks.Remove(tick); if (mDatabase.executewrite("DELETE FROM [dbo].[TickMark] WHERE Name = '" + tick.GetName() + "' AND TimelineID = '" + mID + "'")) { toReturn = true; } mDatabase.close(); return toReturn; }
public TimeLine(string roadmapname) { mDatabase.connect(); mReader = mDatabase.executeread("SELECT ID, StartDate, EndDate FROM [dbo].[Timeline] WHERE RoadmapName = '" + roadmapname + "'"); mReader.Read(); mID = mReader.GetInt32(0); mStartDate = mReader.GetDateTime(1); mEndDate = mReader.GetDateTime(2); mDatabase.close(); mDatabase.connect(); mReader = mDatabase.executeread("SELECT Name, XPlacement FROM [dbo].[TickMark] WHERE TimelineID = '" + mID + "'"); while (mReader.Read()) { TickMark tick = new TickMark(mReader.GetString(0).ToString(), mReader.GetInt32(1)); mTicks.Add(tick); } mDatabase.close(); }
public bool NewTickMark(TickMark tick) { mDatabase.connect(); bool toReturn = false; //add Tickmark mTicks.Add(tick); if (mDatabase.executewrite("INSERT INTO [dbo].[TickMark] ( Name, XPlacement, TimelineID ) VALUES (" + "'" + tick.GetName() + "'" + ',' + "'" + tick.GetXPlacement() + "'" + ',' + "'" + mID + "')")) { toReturn = true; } mDatabase.close(); return toReturn; }