public void DeleteFlashcard(Flashcard target) { SQLiteConnection connection = new SQLiteConnection { ConnectionString = connectionString }; connection.Open(); // Create an SQL Command SQLiteCommand deleteCommand = new SQLiteCommand(); // Fill SQL command parameters. deleteCommand.Connection = connection; deleteCommand.CommandType = System.Data.CommandType.Text; deleteCommand.CommandText = "DELETE FROM Flashcards WHERE ID=@ID;"; var idParam = new SQLiteParameter("@ID", target.ID); idParam.DbType = System.Data.DbType.Int32; deleteCommand.Parameters.Add(idParam); // Execute the command. deleteCommand.ExecuteNonQuery(); connection.Close(); }
public void AddFlashcard(Flashcard addition) { SQLiteConnection connection = new SQLiteConnection { ConnectionString = connectionString }; connection.Open(); // Create an SQL Command SQLiteCommand insertCommand = new SQLiteCommand(); // Fill SQL command parameters. insertCommand.Connection = connection; insertCommand.CommandType = System.Data.CommandType.Text; insertCommand.CommandText = "INSERT INTO Flashcards (FrontSide, BackSide) VALUES(@frontSide, @backSide);"; var frontSideParam = new SQLiteParameter("@frontSide", addition.ShowFront()); frontSideParam.DbType = System.Data.DbType.String; insertCommand.Parameters.Add(frontSideParam); var backSideParam = new SQLiteParameter("@backSide", addition.ShowBack()); backSideParam.DbType = System.Data.DbType.String; insertCommand.Parameters.Add(backSideParam); // Execute the command. insertCommand.ExecuteNonQuery(); connection.Close(); }
/// <summary> /// Convert tab separated values to a list of flashcards. /// </summary> /// <param name="contents">text with as many lines as there are flashcards.</param> /// <returns>a list of flashcards</returns> public static IList <Flashcard> FromTabSeparatedValues(string contents) { var flashcards = new List <Flashcard>(); if (string.IsNullOrEmpty(contents)) { return(flashcards); } string[] lines = contents.Split(new char[] { '\n' }); foreach (string line in lines) { if (!string.IsNullOrEmpty(line)) { flashcards.Add(Flashcard.FromTabSeparatedValues(line)); } } return(flashcards); }
public IList <Flashcard> GetFlashcards() { SQLiteConnection connection = new SQLiteConnection { ConnectionString = connectionString }; connection.Open(); // Create an SQL Command. SQLiteCommand command = new SQLiteCommand(); // Fill SQL command parameters. command.Connection = connection; command.CommandType = System.Data.CommandType.Text; command.CommandText = "SELECT ID, FrontSide, BackSide FROM Flashcards;"; // Execute the command. SQLiteDataReader dataReader = command.ExecuteReader(); // Read data and show to the console. // Read data and show to the console IList <Flashcard> flashcards = new List <Flashcard>(); while (dataReader.Read()) { var flashcard = new Flashcard(dataReader.GetString(1), dataReader.GetString(2)); flashcard.ID = dataReader.GetInt32(0); flashcards.Add(flashcard); } connection.Close(); return(flashcards); }