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