public void AddMember(Member newMember)
{
MySqlConnection conn = DB.Connection();
conn.Open();
var cmd = conn.CreateCommand() as MySqlCommand;
cmd.CommandText = @"INSERT INTO members_books (book_id, member_id) VALUES (@BookId, @MemberId);";
MySqlParameter book_id = new MySqlParameter();
book_id.ParameterName = "@BookId";
book_id.Value = _id;
cmd.Parameters.Add(book_id);
MySqlParameter member_id = new MySqlParameter();
member_id.ParameterName = "@MemberId";
member_id.Value = newMember.GetId();
cmd.Parameters.Add(member_id);
cmd.ExecuteNonQuery();
conn.Close();
if (conn != null)
{
conn.Dispose();
}
}
public override bool Equals(System.Object otherMember)
{
if (!(otherMember is Member))
{
return(false);
}
else
{
Member newMember = (Member)otherMember;
return(this.GetId().Equals(newMember.GetId()));
}
}