private void NewMark_Click(object sender, RoutedEventArgs e)
{
var mark = new SnippetMark();
mark.SnippetId = this.Snippet.Id;
this.Snippet.Marks.Add(mark);
this.marksLst.SelectedIndex = this.Snippet.Marks.Count - 1;
this.RenderSelection();
}
private void Update(string id, SnippetMark mark)
{
string sql = "UPDATE snippetmarks SET SnippetId=@SnippetId, Line=@Line, StartPoint=@StartPoint, EndPoint=@EndPoint WHERE Id=@Id";
var transaction = Connection.BeginTransaction();
SQLiteCommand command = new SQLiteCommand(sql, Connection);
command.Parameters.AddWithValue("@SnippetId", mark.SnippetId);
command.Parameters.AddWithValue("@Line", mark.Line);
command.Parameters.AddWithValue("@StartPoint", mark.StartPoint);
command.Parameters.AddWithValue("@EndPoint", mark.EndPoint);
command.Parameters.AddWithValue("@Id", id);
command.ExecuteNonQuery();
transaction.Commit();
}
public SnippetMark AddMark(SnippetMark mark)
{
string sql = "INSERT INTO snippetmarks(Id, SnippetId, Line, StartPoint, EndPoint) VALUES (@Id, @SnippetId, @Line, @StartPoint, @EndPoint);";
var transaction = Connection.BeginTransaction();
SQLiteCommand command = new SQLiteCommand(sql, Connection);
command.Parameters.AddWithValue("@Id", mark.Id);
command.Parameters.AddWithValue("@SnippetId", mark.SnippetId);
command.Parameters.AddWithValue("@Line", mark.Line);
command.Parameters.AddWithValue("@StartPoint", mark.StartPoint);
command.Parameters.AddWithValue("@EndPoint", mark.EndPoint);
command.ExecuteNonQuery();
transaction.Commit();
return(mark);
}
public void Update(SnippetMark mark)
{
this.Update(mark.Id, mark);
}
public void Swap(SnippetMark mark1, SnippetMark mark2)
{
this.Update(mark1.Id, mark2);
this.Update(mark2.Id, mark1);
}
