static void Main()
{
// create an object to execute the tasks
LibraryDBTasks taskExecutor = new LibraryDBTasks();
Console.Write("Enter pass: "******"--------------------------------------------");
// task 02 - find a book by name
Console.Write("Enter the book's name: ");
string bookName = Console.ReadLine();
taskExecutor.FindABookByName(bookName, pass);
Console.WriteLine("--------------------------------------------");
// task 03 - add new book
//creating the book object
Book bookToAdd = new Book("Book", 3, "10/04/2000", "4-231-432-23-432");
// executing the task
taskExecutor.AddBook(bookToAdd, pass);
Console.WriteLine("Book added!");
Console.WriteLine("--------------------------------------------");
}
public void AddBook(Book bookToAdd, string password)
{
// connect to the database
MySqlConnection dbCon = new MySqlConnection(dbConnection + password);
// open the database
dbCon.Open();
// the sql query string to insert the book
string addBook = string.Format("INSERT INTO books (Title, AuthorID, PublishDate, ISBN)" +
"VALUES ('{0}', {1}, STR_TO_DATE('{2}','%d/%m/%Y'), '{3}')", bookToAdd.title, bookToAdd.authorID, bookToAdd.date, bookToAdd.isbn);
using (dbCon)
{
MySqlCommand addNewBook = new MySqlCommand(addBook, dbCon);
addNewBook.ExecuteNonQuery();
}
}
