private AcukwikDataSet.AcukwikSubdivisionStatesDataTable ConvertTable(DataSheetCollection supportedSheetCollection, DataTable uploadedSheetTable) { AcukwikDataSet.AcukwikSubdivisionStatesDataTable 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.AcukwikSubdivisionStatesDataTable convertedTable = ConvertTable(supportedSheetCollection, uploadedSheetTable); if (convertedTable == null) { return(false); } UploadDatabaseRecords(convertedTable); if (convertedTable.Rows.Count == 0) { return(false); } return(true); }
private AcukwikDataSet.AcukwikSubdivisionStatesDataTable AttemptToConvertFormat(DataSheet supportedDataSheet, DataTable uploadedSheetTable) { AcukwikDataSet.AcukwikSubdivisionStatesDataTable result = new AcukwikDataSet.AcukwikSubdivisionStatesDataTable(); try { if (!supportedDataSheet.PopulateRowsFromData(result, uploadedSheetTable)) { return(null); } } catch (Exception exception) { throw new Exception(exception.ToString()); } return(result); }