List <TableDefinitionDataEntity> ToTableDefinitionDataEntityList(IList <IList <object> > sheetValues)
{
List <TableDefinitionDataEntity> result = new List <TableDefinitionDataEntity>();
for (int i = 7; i < sheetValues.Count; i++)
{
IList <object> row = sheetValues[i];
string logicalName = row.ElementAtOrDefault(1)?.ToString();
string physicalName = row.ElementAtOrDefault(2)?.ToString();
string dataType = row.ElementAtOrDefault(3)?.ToString();
string defaultValue = row.ElementAtOrDefault(7)?.ToString();
string relation = row.ElementAtOrDefault(8)?.ToString();
// undefined dataType is threw
if (string.IsNullOrEmpty(dataType))
{
continue;
}
TableDefinitionDataEntity entity = new TableDefinitionDataEntity(logicalName, physicalName, dataType, defaultValue, relation);
result.Add(entity);
}
return(result);
}
List <TableDefinitionDataEntity> ToEnumDataEntityList(IList <IList <object> > sheetValues)
{
List <TableDefinitionDataEntity> result = new List <TableDefinitionDataEntity>();
for (int i = 7; i < sheetValues.Count; i++)
{
IList <object> row = sheetValues[i];
string logicalName = row.ElementAtOrDefault(1)?.ToString();
string physicalName = row.ElementAtOrDefault(2)?.ToString();
int value = int.Parse(row.ElementAtOrDefault(3)?.ToString());
string remarks = row.ElementAtOrDefault(4)?.ToString();
TableDefinitionDataEntity entity = new TableDefinitionDataEntity(logicalName, physicalName, value, remarks);
result.Add(entity);
}
return(result);
}