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; }