Advertisement
Guest User

Untitled

a guest
Jun 19th, 2019
80
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.94 KB | None | 0 0
  1. private void SetConnection()
  2. {
  3. sql_con = new SQLiteConnection
  4. ("Data Source=c:\Dev\MYApp.sqlite;Version=3;New=False;Compress=True;");
  5. }
  6.  
  7. private void ExecuteQuery(string txtQuery)
  8. {
  9. SetConnection();
  10. sql_con.Open();
  11. sql_cmd = sql_con.CreateCommand();
  12. sql_cmd.CommandText = txtQuery;
  13. sql_cmd.ExecuteNonQuery();
  14. sql_con.Close();
  15. }
  16.  
  17. public void Create(Book book)
  18. {
  19. string txtSqlQuery = "INSERT INTO Book (Id, Title, Language, PublicationDate, Publisher, Edition, OfficialUrl, Description, EBookFormat) ";
  20. txtSqlQuery += string.Format("VALUES (@{0},@{1},@{2},@{3},@{4},@{5},@{6},@{7},{8})",
  21. book.Id, book.Title, book.Language, book.PublicationDate, book.Publisher, book.Edition, book.OfficialUrl, book.Description, book.EBookFormat);
  22. try
  23. {
  24. ExecuteQuery(txtSqlQuery);
  25. }
  26. catch (Exception ex )
  27. {
  28. throw new Exception(ex.Message);
  29. }
  30. }
  31.  
  32. sql_cmd.ExecuteNonQuery();
  33.  
  34. public void Create(Book book) {
  35. SQLiteCommand insertSQL = new SQLiteCommand("INSERT INTO Book (Id, Title, Language, PublicationDate, Publisher, Edition, OfficialUrl, Description, EBookFormat) VALUES (?,?,?,?,?,?,?,?,?)", sql_con);
  36. insertSQL.Parameters.Add(book.Id);
  37. insertSQL.Parameters.Add(book.Title);
  38. insertSQL.Parameters.Add(book.Language);
  39. insertSQL.Parameters.Add(book.PublicationDate);
  40. insertSQL.Parameters.Add(book.Publisher);
  41. insertSQL.Parameters.Add(book.Edition);
  42. insertSQL.Parameters.Add(book.OfficialUrl);
  43. insertSQL.Parameters.Add(book.Description);
  44. insertSQL.Parameters.Add(book.EBookFormat);
  45. try {
  46. insertSQL.ExecuteNonQuery();
  47. }
  48. catch (Exception ex) {
  49. throw new Exception(ex.Message);
  50. }
  51. }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement