public void AddItem(ListMaker newItem) { MySqlConnection conn = DB.Connection(); conn.Open(); var cmd = conn.CreateCommand() as MySqlCommand; cmd.CommandText = @"INSERT INTO categories_items (category_id, item_id) VALUES (@CategoryId, @ItemId);"; MySqlParameter category_id = new MySqlParameter(); category_id.ParameterName = "@CategoryId"; category_id.Value = _id; cmd.Parameters.Add(category_id); MySqlParameter item_id = new MySqlParameter(); item_id.ParameterName = "@ItemId"; item_id.Value = newItem.GetId(); cmd.Parameters.Add(item_id); cmd.ExecuteNonQuery(); conn.Close(); if (conn != null) { conn.Dispose(); } }
public override bool Equals(System.Object otherItem) { if (!(otherItem is ListMaker)) { return(false); } else { ListMaker newItem = (ListMaker)otherItem; bool idEquality = (this.GetId() == newItem.GetId()); bool descriptionEquality = (this.GetDescription() == newItem.GetDescription()); return(idEquality && descriptionEquality); } }