public static Book Find(int bookId) { MySqlConnection conn = DB.Connection(); conn.Open(); var cmd = conn.CreateCommand() as MySqlCommand; cmd.CommandText = @"SELECT * FROM books WHERE id = (@bookId);"; MySqlParameter book_id = new MySqlParameter(); book_id.ParameterName = "@bookId"; book_id.Value = bookId; cmd.Parameters.Add(book_id); var rdr = cmd.ExecuteReader() as MySqlDataReader; string BookName = ""; int BookId = 0; while (rdr.Read()) { BookId = rdr.GetInt32(0); BookName = rdr.GetString(1); } Book foundBook = new Book(BookName, BookId); conn.Close(); if (conn != null) { conn.Dispose(); } Console.WriteLine(foundBook.GetName()); return(foundBook); }
public override bool Equals(System.Object otherBookName) { if (!(otherBookName is Book)) { return(false); } else { Book newBook = (Book)otherBookName; bool idEquality = (this.GetId() == newBook.GetId()); bool nameEquality = (this.GetName() == newBook.GetName()); return(idEquality && nameEquality); } }
public override bool Equals(System.Object otherBook) { if (!(otherBook is Book)) { return(false); } else { Book newBook = (Book)otherBook; bool areIdsEqual = (this.GetId() == newBook.GetId()); bool areNameEqual = (this.GetName() == newBook.GetName()); bool areauthor_idEqual = (this.GetAuthorId() == newBook.GetAuthorId()); bool areYearEqual = (this.GetYear() == newBook.GetYear()); return(areIdsEqual && areNameEqual && areauthor_idEqual && areYearEqual); } }