public static IEnumerable <ImportSubaddressPositionFromCrab> Map(IEnumerable <tblAdrespositie_hist> huisnummerPositiesHist)
{
return
(huisnummerPositiesHist
.Select(
s =>
{
MapLogging.Log(".");
var modification = CrabEnumMapper.Map(s.Bewerking);
return new ImportSubaddressPositionFromCrab(
new CrabAddressPositionId(s.adrespositieid.Value),
new CrabSubaddressId(s.adresid.Value),
new WkbGeometry(s.Geometrie.WKB),
new CrabAddressNature(s.aardAdres),
CrabEnumMapper.Map(s.HerkomstAdrespositie),
new CrabLifetime(s.beginDatum?.ToCrabLocalDateTime(), s.einddatum?.ToCrabLocalDateTime()),
new CrabTimestamp(s.CrabTimestamp.ToCrabInstant())
.CorrectWhenTimeTravelingDelete(modification, s.begintijd.Value),
new CrabOperator(s.Operator),
modification,
CrabEnumMapper.Map(s.Organisatie));
}));
}
public static ImportHouseNumberFromCrab Map(tblHuisNummer huisnummer)
{
MapLogging.Log(".");
return(new ImportHouseNumberFromCrab(
new CrabHouseNumberId(huisnummer.huisNummerId),
new CrabStreetNameId(huisnummer.straatNaamId),
new HouseNumber(huisnummer.huisNummer),
new GrbNotation(huisnummer.GRBnotatie),
new CrabLifetime(huisnummer.beginDatum.ToCrabLocalDateTime(), huisnummer.eindDatum?.ToCrabLocalDateTime()),
new CrabTimestamp(huisnummer.CrabTimestamp.ToCrabInstant()),
new CrabOperator(huisnummer.Operator), CrabEnumMapper.Map(huisnummer.Bewerking), CrabEnumMapper.Map(huisnummer.Organisatie)));
}
public static ImportSubaddressFromCrab Map(tblSubAdres subaddress)
{
MapLogging.Log(".");
return(new ImportSubaddressFromCrab(
new CrabSubaddressId(subaddress.subAdresId),
new CrabHouseNumberId(subaddress.huisNummerId),
new BoxNumber(subaddress.subAdres),
new CrabBoxNumberType(subaddress.aardSubAdresCode),
new CrabLifetime(subaddress.beginDatum.ToCrabLocalDateTime(), subaddress.eindDatum?.ToCrabLocalDateTime()),
new CrabTimestamp(subaddress.CrabTimestamp.ToCrabInstant()),
new CrabOperator(subaddress.Operator),
CrabEnumMapper.Map(subaddress.Bewerking),
CrabEnumMapper.Map(subaddress.Organisatie)));
}
public static IEnumerable <ImportHouseNumberFromCrab> Map(IEnumerable <tblHuisNummer_hist> huisnummersHist)
{
return(huisnummersHist
.Select(huisnummerHist =>
{
MapLogging.Log(".");
return new ImportHouseNumberFromCrab(
new CrabHouseNumberId(huisnummerHist.huisNummerId.Value),
new CrabStreetNameId(huisnummerHist.straatNaamId.Value),
new HouseNumber(huisnummerHist.huisNummer),
new GrbNotation(huisnummerHist.GRBnotatie),
new CrabLifetime(huisnummerHist.beginDatum?.ToCrabLocalDateTime(), huisnummerHist.eindDatum?.ToCrabLocalDateTime()),
new CrabTimestamp(huisnummerHist.CrabTimestamp.ToCrabInstant()),
new CrabOperator(huisnummerHist.Operator), CrabEnumMapper.Map(huisnummerHist.Bewerking), CrabEnumMapper.Map(huisnummerHist.Organisatie));
}));
}
public static IEnumerable <ImportSubaddressStatusFromCrab> Map(IEnumerable <tblSubadresstatus> subadresStatuses)
{
return(subadresStatuses
.Select(
subadresstatus =>
{
MapLogging.Log(".");
return new ImportSubaddressStatusFromCrab(
new CrabSubaddressStatusId(subadresstatus.subadresstatusid),
new CrabSubaddressId(subadresstatus.subadresid),
ParseSubaddressStatus(subadresstatus.Status),
new CrabLifetime(subadresstatus.begindatum.ToCrabLocalDateTime(), subadresstatus.einddatum?.ToCrabLocalDateTime()),
new CrabTimestamp(subadresstatus.CrabTimestamp.ToCrabInstant()),
new CrabOperator(subadresstatus.Operator),
CrabEnumMapper.Map(subadresstatus.Bewerking),
CrabEnumMapper.Map(subadresstatus.Organisatie));
}));
}
public static IEnumerable <ImportHouseNumberStatusFromCrab> Map(IEnumerable <tblHuisnummerstatus> huisnummerstatusses)
{
return
(huisnummerstatusses
.Select(huisnummerstatus =>
{
MapLogging.Log(".");
return new ImportHouseNumberStatusFromCrab(
new CrabHouseNumberStatusId(huisnummerstatus.huisnummerstatusid),
new CrabHouseNumberId(huisnummerstatus.huisnummerid),
CrabEnumMapper.Map(huisnummerstatus.Status),
new CrabLifetime(huisnummerstatus.begindatum.ToCrabLocalDateTime(), huisnummerstatus.einddatum?.ToCrabLocalDateTime()),
new CrabTimestamp(huisnummerstatus.CrabTimestamp.ToCrabInstant()),
new CrabOperator(huisnummerstatus.Operator),
CrabEnumMapper.Map(huisnummerstatus.Bewerking),
CrabEnumMapper.Map(huisnummerstatus.Organisatie)
);
}));
}
public static IEnumerable <ImportSubaddressMailCantonFromCrab> GetCommandsFor(
IEnumerable <tblHuisNummer_postKanton_hist> huisnummerPostKantonsHist,
int subadresid)
{
return(huisnummerPostKantonsHist
.Select(huisNummerPostKanton =>
{
MapLogging.Log(".");
return new ImportSubaddressMailCantonFromCrab(
new CrabHouseNumberMailCantonId(huisNummerPostKanton.huisNummer_postKanton_Id.Value),
new CrabHouseNumberId(huisNummerPostKanton.huisNummerId.Value),
new CrabSubaddressId(subadresid),
new CrabMailCantonId(huisNummerPostKanton.postKantonId.Value),
new CrabMailCantonCode(huisNummerPostKanton.PostkantonCode),
new CrabLifetime(huisNummerPostKanton.beginDatum?.ToCrabLocalDateTime(), huisNummerPostKanton.eindDatum?.ToCrabLocalDateTime()),
new CrabTimestamp(huisNummerPostKanton.CrabTimestamp.ToCrabInstant()),
new CrabOperator(huisNummerPostKanton.Operator),
CrabEnumMapper.Map(huisNummerPostKanton.Bewerking),
CrabEnumMapper.Map(huisNummerPostKanton.Organisatie));
}));
}
public static IEnumerable <ImportSubaddressStatusFromCrab> Map(IEnumerable <tblSubadresstatus_hist> subadresStatussesHist)
{
return(subadresStatussesHist
.Select(
subadresstatusHist =>
{
MapLogging.Log(".");
var modification = CrabEnumMapper.Map(subadresstatusHist.Bewerking);
return new ImportSubaddressStatusFromCrab(
new CrabSubaddressStatusId(subadresstatusHist.subadresstatusid.Value),
new CrabSubaddressId(subadresstatusHist.subadresid.Value),
ParseSubaddressStatus(subadresstatusHist.Status),
new CrabLifetime(subadresstatusHist.begindatum?.ToCrabLocalDateTime(), subadresstatusHist.einddatum?.ToCrabLocalDateTime()),
new CrabTimestamp(subadresstatusHist.CrabTimestamp.ToCrabInstant())
.CorrectWhenTimeTravelingDelete(modification, subadresstatusHist.begintijd.Value),
new CrabOperator(subadresstatusHist.Operator),
modification,
CrabEnumMapper.Map(subadresstatusHist.Organisatie));
}));
}
public static IEnumerable <ImportSubaddressPositionFromCrab> Map(IEnumerable <tblAdrespositie> huisnummerPosities)
{
return
(huisnummerPosities
.Select(
adrespositie =>
{
MapLogging.Log(".");
return new ImportSubaddressPositionFromCrab(
new CrabAddressPositionId(adrespositie.adrespositieid),
new CrabSubaddressId(adrespositie.adresid),
new WkbGeometry(adrespositie.Geometrie.WKB),
new CrabAddressNature(adrespositie.aardAdres),
CrabEnumMapper.Map(adrespositie.HerkomstAdrespositie),
new CrabLifetime(adrespositie.beginDatum.ToCrabLocalDateTime(), adrespositie.einddatum?.ToCrabLocalDateTime()),
new CrabTimestamp(adrespositie.CrabTimestamp.ToCrabInstant()),
new CrabOperator(adrespositie.Operator),
CrabEnumMapper.Map(adrespositie.Bewerking),
CrabEnumMapper.Map(adrespositie.Organisatie));
}));
}
public static IEnumerable <ImportSubaddressFromCrab> Map(IEnumerable <tblSubAdres_hist> subadresHist)
{
return(subadresHist
.Select(
subaddress =>
{
MapLogging.Log(".");
var crabModification = CrabEnumMapper.Map(subaddress.Bewerking);
return new ImportSubaddressFromCrab(
new CrabSubaddressId(subaddress.subAdresId.Value),
new CrabHouseNumberId(subaddress.huisNummerId.Value),
new BoxNumber(subaddress.subAdres),
new CrabBoxNumberType(subaddress.aardSubAdresCode),
new CrabLifetime(subaddress.beginDatum?.ToCrabLocalDateTime(), subaddress.eindDatum?.ToCrabLocalDateTime()),
new CrabTimestamp(subaddress.CrabTimestamp.ToCrabInstant())
.CorrectWhenTimeTravelingDelete(crabModification, subaddress.beginTijd.Value),
new CrabOperator(subaddress.Operator),
crabModification,
CrabEnumMapper.Map(subaddress.Organisatie));
}));
}