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);
}
}
