private List <SpanEquipmentForConversion> LoadSpanEquipmentsFromConversionDatabase(string tableName) { List <SpanEquipmentForConversion> conduitForConversions = new List <SpanEquipmentForConversion>(); using var dbConn = GetConnection(); using var dbCmd = dbConn.CreateCommand(); dbCmd.CommandText = "SELECT external_id, span_equipment_id, span_equipment_spec_name, segment_ids, parent_span_equipment_ids, status FROM " + tableName + " WHERE status is null ORDER BY external_id"; using var dbReader = dbCmd.ExecuteReader(); while (dbReader.Read()) { var externalId = dbReader.GetString(0).Trim(); var spanSegmentId = Guid.Parse(dbReader.GetString(1)); var externalSpec = dbReader.GetString(2).Trim().ToLower(); var routeSegmentsIds = dbReader.GetString(3); var parentConduits = dbReader.GetString(4); var conduit = new SpanEquipmentForConversion(spanSegmentId, externalId, externalSpec, routeSegmentsIds, parentConduits); conduitForConversions.Add(conduit); } dbConn.Close(); return(conduitForConversions); }
private List <SpanEquipmentForConversion> LoadSpanEquipmentsFromConversionDatabase(string tableName) { List <SpanEquipmentForConversion> conduitForConversions = new List <SpanEquipmentForConversion>(); using var dbConn = GetConnection(); using var dbCmd = dbConn.CreateCommand(); dbCmd.CommandText = "SELECT * FROM " + tableName + " WHERE status is null ORDER BY external_id"; using var dbReader = dbCmd.ExecuteReader(); while (dbReader.Read()) { var externalId = dbReader.GetString(1).Trim(); var externalSpec = dbReader.GetString(2).Trim().ToLower(); var spanSegmentId = Guid.Parse(dbReader.GetString(3)); var routeSegmentsIds = dbReader.GetString(4); Guid?accessAddressId = dbReader.IsDBNull(5) || dbReader.GetString(5).Trim() == "" ? null : Guid.Parse(dbReader.GetString(5)); Guid?unitAddressId = dbReader.IsDBNull(6) || dbReader.GetString(6).Trim() == "" ? null : Guid.Parse(dbReader.GetString(6)); var addressInfo = dbReader.IsDBNull(7) || dbReader.GetString(7).Trim() == "" ? null : dbReader.GetString(7).Trim(); var conduit = new SpanEquipmentForConversion(spanSegmentId, externalId, externalSpec, routeSegmentsIds, accessAddressId, unitAddressId, addressInfo); conduitForConversions.Add(conduit); } dbConn.Close(); return(conduitForConversions); }