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