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