public override bool Equals(System.Object otherAuthor) { if (!(otherAuthor is Author)) { return(false); } else { Author newAuthor = (Author)otherAuthor; bool idEquality = this.GetAuthorId().Equals(newAuthor.GetAuthorId()); bool nameEquality = this.GetAuthorName().Equals(newAuthor.GetAuthorName()); return(idEquality && nameEquality); } }
public void AddAuthor(Author newAuthor) { MySqlConnection conn = DB.Connection(); conn.Open(); var cmd = conn.CreateCommand() as MySqlCommand; cmd.CommandText = @"INSERT INTO authors_books (book_id, author_id) VALUES (@BookId, @AuthorId);"; cmd.Parameters.Add(new MySqlParameter("@BookId", _bookId)); cmd.Parameters.Add(new MySqlParameter("@AuthorId", newAuthor.GetAuthorId())); cmd.ExecuteNonQuery(); conn.Close(); if (conn != null) { conn.Dispose(); } }