/// <summary>
/// Factory method. Loads a <see cref="F04_SubContinent"/> object from the given SafeDataReader.
/// </summary>
/// <param name="dr">The SafeDataReader to use.</param>
/// <returns>A reference to the fetched <see cref="F04_SubContinent"/> object.</returns>
internal static F04_SubContinent GetF04_SubContinent(SafeDataReader dr)
{
F04_SubContinent obj = new F04_SubContinent();
// show the framework that this is a child object
obj.MarkAsChild();
obj.Fetch(dr);
obj.LoadProperty(F05_CountryObjectsProperty, F05_CountryColl.NewF05_CountryColl());
obj.MarkOld();
return(obj);
}
/// <summary>
/// Loads <see cref="F08_Region"/> items on the F07_RegionObjects collection.
/// </summary>
/// <param name="collection">The grand parent <see cref="F05_CountryColl"/> collection.</param>
internal void LoadItems(F05_CountryColl collection)
{
foreach (var item in this)
{
var obj = collection.FindF06_CountryByParentProperties(item.parent_Country_ID);
var rlce = obj.F07_RegionObjects.RaiseListChangedEvents;
obj.F07_RegionObjects.RaiseListChangedEvents = false;
obj.F07_RegionObjects.Add(item);
obj.F07_RegionObjects.RaiseListChangedEvents = rlce;
}
}
/// <summary>
/// Loads child objects from the given DAL provider.
/// </summary>
/// <param name="dal">The DAL provider to use.</param>
internal void FetchChildren(IF01_ContinentCollDal dal)
{
foreach (var item in dal.F03_Continent_Child)
{
var child = F03_Continent_Child.GetF03_Continent_Child(item);
var obj = ((F01_ContinentColl)Parent).FindF02_ContinentByParentProperties(child.continent_ID1);
obj.LoadProperty(F03_Continent_SingleObjectProperty, child);
}
foreach (var item in dal.F03_Continent_ReChild)
{
var child = F03_Continent_ReChild.GetF03_Continent_ReChild(item);
var obj = ((F01_ContinentColl)Parent).FindF02_ContinentByParentProperties(child.continent_ID2);
obj.LoadProperty(F03_Continent_ASingleObjectProperty, child);
}
var f03_SubContinentColl = F03_SubContinentColl.GetF03_SubContinentColl(dal.F03_SubContinentColl);
f03_SubContinentColl.LoadItems((F01_ContinentColl)Parent);
foreach (var item in dal.F05_SubContinent_Child)
{
var child = F05_SubContinent_Child.GetF05_SubContinent_Child(item);
var obj = f03_SubContinentColl.FindF04_SubContinentByParentProperties(child.subContinent_ID1);
obj.LoadChild(child);
}
foreach (var item in dal.F05_SubContinent_ReChild)
{
var child = F05_SubContinent_ReChild.GetF05_SubContinent_ReChild(item);
var obj = f03_SubContinentColl.FindF04_SubContinentByParentProperties(child.subContinent_ID2);
obj.LoadChild(child);
}
var f05_CountryColl = F05_CountryColl.GetF05_CountryColl(dal.F05_CountryColl);
f05_CountryColl.LoadItems(f03_SubContinentColl);
foreach (var item in dal.F07_Country_Child)
{
var child = F07_Country_Child.GetF07_Country_Child(item);
var obj = f05_CountryColl.FindF06_CountryByParentProperties(child.country_ID1);
obj.LoadChild(child);
}
foreach (var item in dal.F07_Country_ReChild)
{
var child = F07_Country_ReChild.GetF07_Country_ReChild(item);
var obj = f05_CountryColl.FindF06_CountryByParentProperties(child.country_ID2);
obj.LoadChild(child);
}
var f07_RegionColl = F07_RegionColl.GetF07_RegionColl(dal.F07_RegionColl);
f07_RegionColl.LoadItems(f05_CountryColl);
foreach (var item in dal.F09_Region_Child)
{
var child = F09_Region_Child.GetF09_Region_Child(item);
var obj = f07_RegionColl.FindF08_RegionByParentProperties(child.region_ID1);
obj.LoadChild(child);
}
foreach (var item in dal.F09_Region_ReChild)
{
var child = F09_Region_ReChild.GetF09_Region_ReChild(item);
var obj = f07_RegionColl.FindF08_RegionByParentProperties(child.region_ID2);
obj.LoadChild(child);
}
var f09_CityColl = F09_CityColl.GetF09_CityColl(dal.F09_CityColl);
f09_CityColl.LoadItems(f07_RegionColl);
foreach (var item in dal.F11_City_Child)
{
var child = F11_City_Child.GetF11_City_Child(item);
var obj = f09_CityColl.FindF10_CityByParentProperties(child.city_ID1);
obj.LoadChild(child);
}
foreach (var item in dal.F11_City_ReChild)
{
var child = F11_City_ReChild.GetF11_City_ReChild(item);
var obj = f09_CityColl.FindF10_CityByParentProperties(child.city_ID2);
obj.LoadChild(child);
}
var f11_CityRoadColl = F11_CityRoadColl.GetF11_CityRoadColl(dal.F11_CityRoadColl);
f11_CityRoadColl.LoadItems(f09_CityColl);
}
/// <summary>
/// Loads child objects from the given SafeDataReader.
/// </summary>
/// <param name="dr">The SafeDataReader to use.</param>
internal void FetchChildren(SafeDataReader dr)
{
dr.NextResult();
while (dr.Read())
{
var child = F03_Continent_Child.GetF03_Continent_Child(dr);
var obj = ((F01_ContinentColl)Parent).FindF02_ContinentByParentProperties(child.continent_ID1);
obj.LoadProperty(F03_Continent_SingleObjectProperty, child);
}
dr.NextResult();
while (dr.Read())
{
var child = F03_Continent_ReChild.GetF03_Continent_ReChild(dr);
var obj = ((F01_ContinentColl)Parent).FindF02_ContinentByParentProperties(child.continent_ID2);
obj.LoadProperty(F03_Continent_ASingleObjectProperty, child);
}
dr.NextResult();
var f03_SubContinentColl = F03_SubContinentColl.GetF03_SubContinentColl(dr);
f03_SubContinentColl.LoadItems((F01_ContinentColl)Parent);
dr.NextResult();
while (dr.Read())
{
var child = F05_SubContinent_Child.GetF05_SubContinent_Child(dr);
var obj = f03_SubContinentColl.FindF04_SubContinentByParentProperties(child.subContinent_ID1);
obj.LoadChild(child);
}
dr.NextResult();
while (dr.Read())
{
var child = F05_SubContinent_ReChild.GetF05_SubContinent_ReChild(dr);
var obj = f03_SubContinentColl.FindF04_SubContinentByParentProperties(child.subContinent_ID2);
obj.LoadChild(child);
}
dr.NextResult();
var f05_CountryColl = F05_CountryColl.GetF05_CountryColl(dr);
f05_CountryColl.LoadItems(f03_SubContinentColl);
dr.NextResult();
while (dr.Read())
{
var child = F07_Country_Child.GetF07_Country_Child(dr);
var obj = f05_CountryColl.FindF06_CountryByParentProperties(child.country_ID1);
obj.LoadChild(child);
}
dr.NextResult();
while (dr.Read())
{
var child = F07_Country_ReChild.GetF07_Country_ReChild(dr);
var obj = f05_CountryColl.FindF06_CountryByParentProperties(child.country_ID2);
obj.LoadChild(child);
}
dr.NextResult();
var f07_RegionColl = F07_RegionColl.GetF07_RegionColl(dr);
f07_RegionColl.LoadItems(f05_CountryColl);
dr.NextResult();
while (dr.Read())
{
var child = F09_Region_Child.GetF09_Region_Child(dr);
var obj = f07_RegionColl.FindF08_RegionByParentProperties(child.region_ID1);
obj.LoadChild(child);
}
dr.NextResult();
while (dr.Read())
{
var child = F09_Region_ReChild.GetF09_Region_ReChild(dr);
var obj = f07_RegionColl.FindF08_RegionByParentProperties(child.region_ID2);
obj.LoadChild(child);
}
dr.NextResult();
var f09_CityColl = F09_CityColl.GetF09_CityColl(dr);
f09_CityColl.LoadItems(f07_RegionColl);
dr.NextResult();
while (dr.Read())
{
var child = F11_City_Child.GetF11_City_Child(dr);
var obj = f09_CityColl.FindF10_CityByParentProperties(child.city_ID1);
obj.LoadChild(child);
}
dr.NextResult();
while (dr.Read())
{
var child = F11_City_ReChild.GetF11_City_ReChild(dr);
var obj = f09_CityColl.FindF10_CityByParentProperties(child.city_ID2);
obj.LoadChild(child);
}
dr.NextResult();
var f11_CityRoadColl = F11_CityRoadColl.GetF11_CityRoadColl(dr);
f11_CityRoadColl.LoadItems(f09_CityColl);
}