private AcukwikDataSet.AcukwikAirportsDataTable ConvertTable(DataSheetCollection supportedSheetCollection, DataTable uploadedSheetTable) { AcukwikDataSet.AcukwikAirportsDataTable result = null; foreach (DataSheet supportedDataSheet in supportedSheetCollection) { result = AttemptToConvertFormat(supportedDataSheet, uploadedSheetTable); if (result != null && result.Rows.Count > 0) { return(result); } } return(null); }
public bool IsConvertSuccessful(DataSheetCollection supportedSheetCollection, DataTable uploadedSheetTable) { AcukwikDataSet.AcukwikAirportsDataTable convertedTable = ConvertTable(supportedSheetCollection, uploadedSheetTable); if (convertedTable == null) { return(false); } UploadDatabaseRecords(convertedTable); if (convertedTable.Rows.Count == 0) { return(false); } return(true); }
private AcukwikDataSet.AcukwikAirportsDataTable AttemptToConvertFormat(DataSheet supportedDataSheet, DataTable uploadedSheetTable) { AcukwikDataSet.AcukwikAirportsDataTable result = new AcukwikDataSet.AcukwikAirportsDataTable(); try { if (!supportedDataSheet.PopulateRowsFromData(result, uploadedSheetTable)) { return(null); } } catch (Exception exception) { throw new Exception(exception.ToString()); } return(result); }