public void Import(StreamReader csvData)
{
List <Device> parsedDevices = new List <Device>();
Dictionary <string, string> detectedNamesBySerial = new Dictionary <string, string>();
Dictionary <string, string> detectedFacilitiesBySerial = new Dictionary <string, string>();
using (CsvReader csv = new CsvReader(csvData, CultureInfo.InvariantCulture))
{
var fileFormatDefinition = new
{
serialNumber = string.Empty,
model = string.Empty,
annotatedLocation = string.Empty,
annotatedAssetId = string.Empty,
ethernetMacAddress = string.Empty,
macAddress = string.Empty
};
var records = csv.GetRecords(fileFormatDefinition);
foreach (var o in records)
{
if (!string.IsNullOrEmpty(o.serialNumber))
{
// Extract the device records
parsedDevices.Add(new Device()
{
SerialNumber = o.serialNumber,
Model = o.model
});
// Extract device names
if (!detectedNamesBySerial.ContainsKey(o.annotatedAssetId))
{
detectedNamesBySerial.Add(o.serialNumber, o.annotatedAssetId);
}
// Extract the facility records
if (!detectedFacilitiesBySerial.ContainsKey(o.annotatedLocation))
{
detectedFacilitiesBySerial.Add(o.serialNumber, o.annotatedLocation);
}
// Extract the MAC addresses
}
}
}
ImportHandler importHandler = new ImportHandler(_connstring);
importHandler.Import(
parsedDevices,
detectedNamesBySerial,
detectedFacilitiesBySerial
);
}
public void Import(StreamReader csvData, string FacilityName)
{
List <Device> parsedDevices = new List <Device>();
Dictionary <string, string> detectedNamesBySerial = new Dictionary <string, string>();
Dictionary <string, string> detectedFacilitiesBySerial = new Dictionary <string, string>();
using (CsvReader csv = new CsvReader(csvData, CultureInfo.InvariantCulture))
{
var fileFormatDefinition = new
{
Name = string.Empty,
Model = string.Empty,
Serial = string.Empty
};
var records = csv.GetRecords(fileFormatDefinition);
foreach (var o in records)
{
if (!string.IsNullOrEmpty(o.Serial))
{
// Extract the device records
parsedDevices.Add(new Device()
{
SerialNumber = o.Serial,
Model = o.Model
});
// Extract device names
if (!detectedNamesBySerial.ContainsKey(o.Serial))
{
detectedNamesBySerial.Add(o.Serial, o.Name);
}
// Extract the facility records
if (!detectedFacilitiesBySerial.ContainsKey(o.Serial))
{
detectedFacilitiesBySerial.Add(o.Serial, FacilityName);
}
}
}
}
ImportHandler importHandler = new ImportHandler(_connstring);
importHandler.Import(
parsedDevices,
detectedNamesBySerial,
detectedFacilitiesBySerial
);
}