private void CopyEmployeeTerritories(IOdb odb)
{
//Processing EmployeeTerritories
LogMessage("Reading EmployeeTerritories...", false);
var adapter1 = new EmployeeTerritoriesTableAdapter();
var table1 = adapter1.GetData();
LogMessage("processing " + table1.Count.ToString() + " rows", true);
foreach (var row in table1)
{
LogMessage("EmployeeTerritories: " + row.EmployeeID.ToString() + "/" + row.TerritoryID + " ...", false);
var et = new EmployeeTerritory();
LogMessage("linking members...", false);
et.Employee = NDbUtil.GetByNumericalID <Employee>(odb, Employee.PK, row.EmployeeID);
et.Territory = NDbUtil.GetByStringID <Territory>(odb, Territory.PK, row.TerritoryID);
odb.Store(et);
LogMessage("saved (" + et.Employee.EmployeeID.ToString() + "/" + et.Territory.TerritoryID + ")",
true);
}
odb.Commit();
long objectCount = NDbUtil.GetAllInstances <EmployeeTerritory>(odb).Count;
if (table1.Count == objectCount)
{
LogMessage(table1.Count + " objects saved", true);
}
else
{
LogMessage("Error: " + table1.Count + " rows retrieved but " + objectCount + " objects were saved", true);
}
LogMessage("Done with EmployeeTerritories" + Environment.NewLine, true);
}
public void CopyEmployeeTerritories()
{
//Processing EmployeeTerritories
LogMessage("Reading EmployeeTerritories...", false);
EmployeeTerritoriesTableAdapter adapter1 = new EmployeeTerritoriesTableAdapter();
NorthwindDb4o.NorthwindDataSet.EmployeeTerritoriesDataTable table1 = adapter1.GetData();
LogMessage("processing " + table1.Count.ToString() + " rows", true);
foreach (NorthwindDb4o.NorthwindDataSet.EmployeeTerritoriesRow row in table1)
{
LogMessage("EmployeeTerritories: " + row.EmployeeID.ToString() + "/" + row.TerritoryID.ToString() + " ...", false);
EmployeeTerritory et = new EmployeeTerritory();
LogMessage("linking members...", false);
et.EmployeeID = (Employee)Db4oUtil.GetByNumericalID(container, typeof(Employee), "employeeID", row.EmployeeID);
et.TerritoryID = (Territory)Db4oUtil.GetByStringID(container, typeof(Territory), "territoryID", row.TerritoryID);
container.Store(et);
LogMessage("saved (" + et.EmployeeID.EmployeeID.ToString() + "/" + et.TerritoryID.TerritoryID.ToString() + ")", true);
}
container.Commit();
long objectCount = Db4oUtil.GetAllInstances(container, typeof(EmployeeTerritory)).Count;
if (table1.Count == objectCount)
LogMessage(table1.Count + " objects saved", true);
else
LogMessage("Error: " + table1.Count + " rows retrieved but " + objectCount + " objects were saved", true);
LogMessage("Done with EmployeeTerritories" + Environment.NewLine, true);
}
private void CopyEmployeeTerritories(IOdb odb)
{
//Processing EmployeeTerritories
LogMessage("Reading EmployeeTerritories...", false);
var adapter1 = new EmployeeTerritoriesTableAdapter();
var table1 = adapter1.GetData();
LogMessage("processing " + table1.Count.ToString() + " rows", true);
foreach (var row in table1)
{
LogMessage("EmployeeTerritories: " + row.EmployeeID.ToString() + "/" + row.TerritoryID + " ...", false);
var et = new EmployeeTerritory();
LogMessage("linking members...", false);
et.Employee = NDbUtil.GetByNumericalID<Employee>(odb, Employee.PK, row.EmployeeID);
et.Territory = NDbUtil.GetByStringID<Territory>(odb, Territory.PK, row.TerritoryID);
odb.Store(et);
LogMessage("saved (" + et.Employee.EmployeeID.ToString() + "/" + et.Territory.TerritoryID + ")",
true);
}
odb.Commit();
long objectCount = NDbUtil.GetAllInstances<EmployeeTerritory>(odb).Count;
if (table1.Count == objectCount)
LogMessage(table1.Count + " objects saved", true);
else
LogMessage("Error: " + table1.Count + " rows retrieved but " + objectCount + " objects were saved", true);
LogMessage("Done with EmployeeTerritories" + Environment.NewLine, true);
}
