public Lpi(DtfLine line)
{
SetActionAndVersion(line);
Uprn = line.GetLong(Index++);
Lpi_Key = line.GetString(Index++);
Language = line.GetString(Index++);
Logical_Status = line.GetLong(Index++);
Start_Date = line.GetDateTime(Index++);
End_Date = line.GetDateTime(Index++);
Entry_Date = line.GetDateTime(Index++);
Last_Update_Date = line.GetDateTime(Index++);
Sao_Start_Number = line.GetLong(Index++);
Sao_Start_Suffix = line.GetString(Index++);
Sao_End_Number = line.GetLong(Index++);
Sao_End_Suffix = line.GetString(Index++);
Sao_Text = line.GetString(Index++);
Pao_Start_Number = line.GetLong(Index++);
Pao_Start_Suffix = line.GetString(Index++);
Pao_End_Number = line.GetLong(Index++);
Pao_End_Suffix = line.GetString(Index++);
Pao_Text = line.GetString(Index++);
Usrn = line.GetLong(Index++);
Level = line.GetString(Index++);
Postal_Address = line.GetString(Index++);
Postcode = line.GetString(Index++);
Post_Town = line.GetString(Index++);
Official_Flag = line.GetString(Index++);
Custodian_One = line.GetLong(Index++);
Custodian_Two = line.GetLong(Index++);
Can_Key = line.GetString(Index++);
}
public Blpu(DtfLine line)
{
SetActionAndVersion(line);
Uprn = line.GetLong(Index++);
Logical_Status = line.GetLong(Index++);
Blpu_State = line.GetLong(Index++);
Blpu_State_Date = line.GetDateTime(Index++);
Blpu_Class = line.GetString(Index++);
Parent_Uprn = line.GetLong(Index++);
X_Coordinate = line.GetDecimal(Index++);
Y_Coordinate = line.GetDecimal(Index++);
Rpc = line.GetLong(Index++);
Local_Custodian_Code = line.GetLong(Index++);
Start_Date = line.GetDateTime(Index++);
End_Date = line.GetDateTime(Index++);
Last_Update_Date = line.GetDateTime(Index++);
Entry_Date = line.GetDateTime(Index++);
Organisation = line.GetString(Index++);
Ward_Code = line.GetString(Index++);
Parish_Code = line.GetString(Index++);
Custodian_One = line.GetLong(Index++);
Custodian_Two = line.GetLong(Index++);
Can_Key = line.GetString(Index++);
}
public const int FULLTEXTFIELDINDEX = 3; //position of the full text string in the dtfline table in the database
/// <summary>
/// creates object and gets the first field which is the record identifier
/// we need this on creation of the object so we know what to do with it
/// </summary>
/// <param name="textLine"></param>
/// <param name="versionId"></param>
/// <returns></returns>
public static DtfLine Create(string textLine, int versionId)
{
var line = new DtfLine();
line.VersionId = versionId;
line.TextLine = textLine;
line.ParseFirstField();
line.ParseFields();
return(line);
}
public StreetDescriptor(DtfLine line)
{
SetActionAndVersion(line);
Usrn = line.GetLong(Index++);
Street_Descriptor = line.GetString(Index++);
Locality_Name = line.GetString(Index++);
Town_Name = line.GetString(Index++);
Adminstrative_Area = line.GetString(Index++);
Language = line.GetString(Index++);
}
public StreetRecord(DtfLine line)
{
SetActionAndVersion(line);
Usrn = line.GetLong(Index++);
Record_Type = line.GetLong(Index++);
Swa_Org_Ref_Naming = line.GetLong(Index++);
State = line.GetLong(Index++);
State_Date = line.GetDateTime(Index++);
Street_Surface = line.GetLong(Index++);
Street_Classification = line.GetLong(Index++);
Version = line.GetLong(Index++);
Record_Entry_Date = line.GetDateTime(Index++);
Last_Update_Date = line.GetDateTime(Index++);
Street_Start_Date = line.GetDateTime(Index++);
Street_End_Date = line.GetDateTime(Index++);
Street_Start_X = line.GetDecimal(Index++);
Street_Start_Y = line.GetDecimal(Index++);
Street_End_X = line.GetDecimal(Index++);
Street_End_Y = line.GetDecimal(Index++);
Street_Tolerance = line.GetLong(Index++);
}
/// <summary>
/// if we support this record identifier then add it to the graph
/// </summary>
/// <param name="line"></param>
public void Add(DtfLine line)
{
if (line.RecordIdentifier == Config.StreetRecordIndex)
{
Add(new StreetRecord(line), line.ChangeType);
}
if (line.RecordIdentifier == Config.StreetDescriptorIndex)
{
Add(new StreetDescriptor(line), line.ChangeType);
}
if (line.RecordIdentifier == Config.BlpuIndex)
{
Add(new Blpu(line), line.ChangeType);
}
if (line.RecordIdentifier == Config.LpiIndex)
{
Add(new Lpi(line), line.ChangeType);
}
//ignore all other record identifiers for now, we can add them later if we need
}
protected int Index = 3;//we skip the first 3 fields record identifier, change type, and pro order as these don't need to be stored
/// <summary>
/// the database change type which is either insert,update or delete - I,U,D
/// </summary>
public void SetActionAndVersion(DtfLine line)
{
VersionId = line.VersionId;
}
