Insert multiple rows into an IDO on event

unknown

CSI 10 planning for cloud

I have two custom tables / IDOs. One is some base information tied to Item, the other is tied to lot with more information.

On creation of a new lot, I need to get all rows on table 1 for this item, and insert it into table 2 for the item and lot. 

Here is a bad example of what I am trying to accomplish.

Any help or tips would be welcome! 

unknown

For any others that happen on this or future me - here is the completed solution. 

Anyone that has tips for anything to improve on this or glaring mistakes I might have, please put me to shame! 

Forgive the code formatting, I cant figure our a way to format it on here yet. 

using Mongoose.IDO;
using Mongoose.IDO.Protocol;
using System;
using System.Diagnostics;

namespace ue_REC_ShelfLifeLotTest_IdoExtensionClass
{
[IDOExtensionClass("ue_REC_ShelfLifeLotTest")]
public class ue_REC_ShelfLifeLotTest : IDOExtensionClass
{
public override void SetContext(IIDOExtensionClassContext context)
{
base.SetContext(context);
context.IDO.PostLoadCollection += IDO_PostLoadCollection;
}

public void IDO_PostLoadCollection(object sender, IDOEventArgs args)
{
}

[IDOMethod(MethodFlags.None, "Infobar")]
public void GetItemTests(string item, string lot)
{
// Load lot tests - If not null, return, if null pull testing def from item to lot
string itemNum = null;
LoadCollectionResponseData loadLotTests = default(LoadCollectionResponseData);
loadLotTests = this.LoadCollection(
"Item, Lot, TestNumber, Test_ID, Tester, TestDate, Used",
"Item = '" + item + "' AND Lot = '" + lot + "'",
String.Empty,
0);
var lotTests = loadLotTests;

// if there are any items we dont want to add the tests - There should be a better way to test, does itemNum stay null? I dont like the catch
try
{
itemNum = loadLotTests[1, "Item"].Value;
}
catch (Exception ex)
{
itemNum = null;
}

// If there are no tests, get the test deffinitions and insert them into lot tests.
if (itemNum == null)
{
try
{
LoadCollectionResponseData loadTestDefResponse = new LoadCollectionResponseData();
loadTestDefResponse = this.Context.Commands.LoadCollection(
"ue_REC_ShelfLifeTestingDef",
"ID,Item,TestNumber,TestId,SpecReq",
"Item = '" + item + "'",
String.Empty, 0);

// load working
var testDef = loadTestDefResponse;
// foreach test definition add test to lot test
if (loadTestDefResponse != null && loadTestDefResponse.Items.Count > 0)
{
for (int index = 0; index <= loadTestDefResponse.Items.Count; index++)
{
// if not null
if (!loadTestDefResponse[index, "TestNumber"].IsNull)
{
// insert row into lot test
UpdateCollectionRequestData updateCollection = new UpdateCollectionRequestData();
UpdateCollectionResponseData updateResponse;
IDOUpdateItem testItem = new IDOUpdateItem();

string testId = loadTestDefResponse[index, "TestId"].Value;
string testNumber = loadTestDefResponse[index, "TestNumber"].Value;

//Get tester from tests - required for insert.
LoadCollectionResponseData loadTester = new LoadCollectionResponseData();
loadTester = this.Context.Commands.LoadCollection(
"ue_REC_ShelfLifeTest",
"Tester",
"TestID = '" + testId + "'",
string.Empty,
0
);
string tester = loadTester[0, "Tester"].Value;

updateCollection.IDOName = "ue_REC_ShelfLifeLotTest";
updateCollection.RefreshAfterUpdate = true;
testItem.Action = UpdateAction.Insert;
// example to not get lost
// testItem.Properties.Add("columnName", "value to insert); - need to insert Item, Lot, Test_ID, TestNumber
testItem.Properties.Add("ID", index.ToString());
testItem.Properties.Add("Item", item);
testItem.Properties.Add("Lot", lot);
testItem.Properties.Add("Test_ID", testId);
testItem.Properties.Add("TestNumber", testNumber);
testItem.Properties.Add("Tester", tester);
updateCollection.Items.Add(testItem);
updateResponse = this.Context.Commands.UpdateCollection(updateCollection);
}
}
}
}
catch (Exception ex)
{
Debug.WriteLine("Error: " + ex.Message);
}
}
}
}
}