void ButtonAssignElectronicToItem_Click(object sender, ReflectorButtonEventArgs e)
{
if (ItemManagmentState.current_item == null)
{
Banner.Show("Need to select an\nitem description to assign.");
return;
}
if (ItemManagmentState.current_electronic == null)
{
Banner.Show("Need to select a\nElectronic Pack to assign.");
return;
}
DataRow result = MySQLRelationTable.AddGroupMember(ItemManagmentState.item_dataset.floor_item_map
, ItemManagmentState.current_electronic
, ItemManagmentState.current_item
, false
, true
, true);
if (result != null)
{
result["paper_item_name"] = ItemManagmentState.current_item["item_name"];
result["floor_name"] = ItemManagmentState.current_electronic.ToString();
result["electronic_item"] = true;
ItemManagmentState.RefreshLists();
}
}
void ButtonAssignMiscToItem_Click(object sender, ReflectorButtonEventArgs e)
{
DataRow result = MySQLRelationTable.AddGroupMember(ItemManagmentState.item_dataset.floor_item_map
, ItemManagmentState.current_misc
, ItemManagmentState.current_item
, false
, true);
result["paper_item_name"] = ItemManagmentState.current_item["item_name"];
result["floor_name"] = ItemManagmentState.current_misc.ToString();
result["misc_item"] = true;
}
void ButtonAssignMacroToItem_Click(object sender, ReflectorButtonEventArgs e)
{
if (ItemManagmentState.current_item == null)
{
MessageBox.Show("Need to select an item description to assign.");
return;
}
DataRow result = MySQLRelationTable.AddGroupMember(ItemManagmentState.item_dataset.floor_item_map
, ItemManagmentState.current_macro
, ItemManagmentState.current_item
, false
, true
, true);
if (result != null)
{
result["paper_item_name"] = ItemManagmentState.current_item["item_name"];
result["floor_name"] = ItemManagmentState.current_macro.ToString();
result["macro_item"] = true;
}
}
void ButtonAssignPaperToItem_Click(object sender, ReflectorButtonEventArgs e)
{
DataRow[] previous_row = ItemManagmentState.item_dataset.floor_item_map.Select(
XDataTable.ID(ItemManagmentState.current_item.Table)
+ "='"
+ ItemManagmentState.current_item[XDataTable.ID(ItemManagmentState.current_item.Table)] + "'");
if (previous_row.Length == 0)
{
previous_row = ItemManagmentState.item_dataset.floor_item_map.Select(
"paper_item_name"
+ "='"
+ DsnConnection.Escape(DsnConnection.ConnectionMode.NativeDataTable
, DsnConnection.ConnectionFlavor.Unknown
, ItemManagmentState.current_item[XDataTable.Name(ItemManagmentState.current_item.Table)].ToString()) + "'");
}
if (previous_row.Length > 0)
{
previous_row[0]["floor_paper_name_id"] = ItemManagmentState.current_paper["floor_paper_name_id"];
previous_row[0]["paper_item_name"] = ItemManagmentState.current_item["item_name"];
previous_row[0]["floor_name"] = ItemManagmentState.current_paper.ToString();
previous_row[0]["paper_item"] = true;
//ItemManagmentState.current_floor_paper_paper_items.
}
else
{
DataRow result = MySQLRelationTable.AddGroupMember(ItemManagmentState.item_dataset.floor_item_map
, ItemManagmentState.current_paper
, ItemManagmentState.current_item
, false
, true);
result["paper_item_name"] = ItemManagmentState.current_item["item_name"];
result["floor_name"] = ItemManagmentState.current_paper.ToString();
result["paper_item"] = true;
}
}
