public static BulkUploadToSql Load(Stream dataSource)
{
// create a new object to return
BulkUploadToSql o = new BulkUploadToSql();
// replace the code below
// with your custom logic
for (int cnt = 0; cnt < 20; cnt++)
{
MyRecord rec;
if (cnt % 2 == 1)
{
rec = new MyRecord("Test", "Test Job", $"ID{cnt}", $"Component{cnt}");
}
else
{
rec = new MyRecord("Test", "Test Job", $"ID{cnt}", $"Component{cnt}", $"ComponentId{cnt}");
}
o.internalStore.Add(rec);
}
return(o);
}
private void PopulateDataTable(MyRecord record)
{
DataRow row;
// populate the values
// using your custom logic
row = this.dataTable.NewRow();
row["Client"] = record.Client;
row["AssetId"] = record.AssetId;
row["Job"] = record.Job;
row["Component"] = record.Component;
row["ComponentId"] = record.ComponentId;
// add it to the base for final addition to the DB
this.dataTable.Rows.Add(row);
this.recordCount++;
}
