public static void Import(string[] ofdFilenames)
{
int count = 0;
using (SqlConnection connection =
new SqlConnection(new SmartDB().Connection.ConnectionString))
{
connection.Open();
foreach (var filename in ofdFilenames)
{
DataTable newMeter = MakeTable.Meter(filename);
//bool flag = getMeterList.Code == ErrorEnum.NoError;
DataTable fetchMeter = FetchTable.GetMeter();
var fMeter = new HashSet <string>(fetchMeter.AsEnumerable()
.Select(x => x.Field <string>("SerialNumber")));
DataTable dtUniqueGateway = newMeter.AsEnumerable()
.Where(x => !fMeter.Contains(x.Field <string>("SerialNumber")))
.CopyToDataTable();
InsertMeterBulkCopy(connection, dtUniqueGateway);
}
}
}
