/// <summary> /// Creates a new IODPDataTable object /// </summary> public IODPDataTable(DataTable dataTable) { DataTable = dataTable; List <string> columnNames = GetColumnNames(dataTable); string match = string.Empty; CinnamonList lookupList = new CinnamonList("Expedition"); match = lookupList.FindInList(columnNames); ExpeditionColumn = string.IsNullOrEmpty(match)? ExpeditionColumn : match; lookupList = new CinnamonList("Site"); match = lookupList.FindInList(columnNames); SiteColumn = string.IsNullOrEmpty(match) ? SiteColumn : match; lookupList = new CinnamonList("Hole"); match = lookupList.FindInList(columnNames); HoleColumn = string.IsNullOrEmpty(match) ? HoleColumn : match; lookupList = new CinnamonList("Core"); match = lookupList.FindInList(columnNames); CoreColumn = string.IsNullOrEmpty(match) ? CoreColumn : match; lookupList = new CinnamonList("Type"); match = lookupList.FindInList(columnNames); TypeColumn = string.IsNullOrEmpty(match) ? TypeColumn : match; lookupList = new CinnamonList("Section"); match = lookupList.FindInList(columnNames); SectionColumn = string.IsNullOrEmpty(match) ? SectionColumn : match; lookupList = new CinnamonList("Offset"); match = lookupList.FindInList(columnNames); OffsetColumn = string.IsNullOrEmpty(match) ? OffsetColumn : match; lookupList = new CinnamonList("TopOffset"); match = lookupList.FindInList(columnNames); TopOffsetColumn = string.IsNullOrEmpty(match) ? TopOffsetColumn : match; lookupList = new CinnamonList("BottomOffset"); match = lookupList.FindInList(columnNames); BottomOffsetColumn = string.IsNullOrEmpty(match) ? BottomOffsetColumn : match; lookupList = new CinnamonList("SampleID"); match = lookupList.FindInList(columnNames); SampleIDColumn = string.IsNullOrEmpty(match) ? SampleIDColumn : match; }
public static bool DataRowContainsDescription(DataRow dataTableRow, IODPDataTable dataTable) { CinnamonList noDataEntriesList = new CinnamonList("NoSampleEntries"); return(!noDataEntriesList.FindInList(dataTableRow[dataTable.SampleIDColumn].ToString().ToLower()) ? true : false); }