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