private static List <StopFileType> CreateList(DataTable dt, WordRecognizerCore.WordRecognizerType Recognizer, bool NormalizeAdres)
{
StopFileType.OnNeedNormalizeInformation += new EventHandler(OnNeedNormalizeInfo);
List <StopFileType> L = new List <StopFileType>();
//Console.Clear();
for (var i = 0; i <= dt.Rows.Count - 1; i++)
{
StopFileType o = new StopFileType();
for (var x = 0; x < dt.Columns.Count; x++)
{
foreach (var prop in o.GetType().GetProperties())
{
if (prop.Name == dt.Columns[x].ColumnName)
{
prop.SetValue(o, dt.Rows[i][x].ToString());
}
}
}
o.GenereteSTOPCode();
o.IsDelivered();
o.GetParcelGroup();
if (NormalizeAdres == true)
{
o.NormalizedAdress = o.NormalizeAdres(Recognizer);
}
L.Add(o);
}
return(L);
}
public static List <StopFileType> ImportSTOPFile(string XLSXFilename, WordRecognizerCore.WordRecognizerType Recognizer, bool NormalizeAdres)
{
DataTable dt = ExcelToDataTable(XLSXFilename);
List <StopFileType> L = CreateList(dt, Recognizer, NormalizeAdres);
return(L);
}
