public List <ManagerBookEntry> getAllBooks()
{
connectMySQLDatabase();
List <ManagerBookEntry> bookList = new List <ManagerBookEntry>();
string query = "select * from manager_book_entry";
MySqlCommand mySqlCommand = new MySqlCommand(query, connection);
MySqlDataReader mySqlDataReader = mySqlCommand.ExecuteReader();
while (mySqlDataReader.Read())
{
ManagerBookEntry managerBookEntry = new ManagerBookEntry(
mySqlDataReader.GetInt32("book_id"),
mySqlDataReader.GetString("book_name"),
mySqlDataReader.GetInt32("book_publish_year"),
mySqlDataReader.GetString("writer_name"),
mySqlDataReader.GetInt32("quantity_of_book"),
mySqlDataReader.GetString("catagory_name"),
mySqlDataReader.GetBoolean("is_available")
);
bookList.Add(managerBookEntry);
}
mySqlDataReader.Close();
closeConnection();
return(bookList);
}
internal void addNewBookEntry(ManagerBookEntry managerBookEntry)
{
connectMySQLDatabase();
string query = "INSERT INTO manager_book_entry (book_id, book_name, "
+ "book_publish_year, writer_name, quantity_of_book, "
+ " is_available, catagory_name) VALUES (NULL, "
+ "'" + managerBookEntry.BookName + "', '" + managerBookEntry.BookPublishYear.ToString() + "', '"
+ managerBookEntry.WriterName + "', '" + managerBookEntry.QuantityOfBook.ToString() + "', '"
+ (managerBookEntry.AvailableBook == true ? 1 : 0) + "', '" + managerBookEntry.CatagoryName + "')";
MySqlCommand mySqlCommand = new MySqlCommand(query, connection);
MySqlDataReader mySqlDataReader = mySqlCommand.ExecuteReader();
mySqlDataReader.Close();
closeConnection();
}
public ManagerAddBookInfoForm()
{
this.managerBookEntry = new ManagerBookEntry();
InitializeComponent();
}
