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