Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- private void SetConnection()
- {
- sql_con = new SQLiteConnection
- ("Data Source=c:\Dev\MYApp.sqlite;Version=3;New=False;Compress=True;");
- }
- private void ExecuteQuery(string txtQuery)
- {
- SetConnection();
- sql_con.Open();
- sql_cmd = sql_con.CreateCommand();
- sql_cmd.CommandText = txtQuery;
- sql_cmd.ExecuteNonQuery();
- sql_con.Close();
- }
- public void Create(Book book)
- {
- string txtSqlQuery = "INSERT INTO Book (Id, Title, Language, PublicationDate, Publisher, Edition, OfficialUrl, Description, EBookFormat) ";
- txtSqlQuery += string.Format("VALUES (@{0},@{1},@{2},@{3},@{4},@{5},@{6},@{7},{8})",
- book.Id, book.Title, book.Language, book.PublicationDate, book.Publisher, book.Edition, book.OfficialUrl, book.Description, book.EBookFormat);
- try
- {
- ExecuteQuery(txtSqlQuery);
- }
- catch (Exception ex )
- {
- throw new Exception(ex.Message);
- }
- }
- sql_cmd.ExecuteNonQuery();
- public void Create(Book book) {
- SQLiteCommand insertSQL = new SQLiteCommand("INSERT INTO Book (Id, Title, Language, PublicationDate, Publisher, Edition, OfficialUrl, Description, EBookFormat) VALUES (?,?,?,?,?,?,?,?,?)", sql_con);
- insertSQL.Parameters.Add(book.Id);
- insertSQL.Parameters.Add(book.Title);
- insertSQL.Parameters.Add(book.Language);
- insertSQL.Parameters.Add(book.PublicationDate);
- insertSQL.Parameters.Add(book.Publisher);
- insertSQL.Parameters.Add(book.Edition);
- insertSQL.Parameters.Add(book.OfficialUrl);
- insertSQL.Parameters.Add(book.Description);
- insertSQL.Parameters.Add(book.EBookFormat);
- try {
- insertSQL.ExecuteNonQuery();
- }
- catch (Exception ex) {
- throw new Exception(ex.Message);
- }
- }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement