public static ImportRawDataModel ToImportRawDataModel(this IExcelDataReader reader) { var result = new ImportRawDataModel(); result.DataRowId = Decimal.Parse(reader.GetAsString(0)); result.ChannelBundleName = reader.GetAsString(1); result.SwitchOperatorName = reader.GetAsString(2); result.ATES = reader.GetAsString(3); result.ChannelBundleOperatorName = reader.GetAsString(4); result.Direction = reader.GetAsString(5); result.DirectionType = reader.GetAsString(6); result.AlarmType = reader.GetAsString(7); result.DateOpen = reader.GetAsLocaleDateString(8); result.DateClose = reader.GetAsLocaleDateString(9); result.PairedSwitchOperatorFullName = reader.GetAsString(10); result.PairedSwitchOperatorCoverage = reader.GetAsString(11); result.OperatorsNetworkConnectionLevel = reader.GetAsString(12); result.RTNetworkConnectionLevel = reader.GetAsString(13); result.BranchOffice = reader.GetAsString(14); return(result); }