public ImporterDataPresenter(IImporterDataView dataView, IImporter importer) : base(dataView)
{
_importer = importer;
_sheetsForViewing = new Cache <string, DataTable>();
ImportedSheets = new DataSheetCollection();
_currentSheetName = string.Empty;
}
public IDataSourceFile SetDataSource(string dataSourceFileName)
{
if (string.IsNullOrEmpty(dataSourceFileName))
{
return(null);
}
ImportedSheets = new DataSheetCollection();
_dataSourceFile = _importer.LoadFile(_columnInfos, dataSourceFileName, _metaDataCategories);
if (_dataSourceFile == null)
{
return(null);
}
setDefaultMetaData();
setMetaDataWithManualInput();
createSheetsForViewing();
View.SetGridSource();
SetDataFormat(_dataSourceFile.Format, _dataSourceFile.AvailableFormats);
View.ClearTabs();
View.AddTabs(GetSheetNames());
View.ResetImportButtons();
View.SelectTab(_dataSourceFile.FormatCalculatedFrom);
return(_dataSourceFile);
}
public void throw_on_empty_dataset()
{
var sheets = new DataSheetCollection();
var sheet = new DataSheet()
{
SheetName = "sheet1"
};
sheets.AddSheet(sheet);
sut.AddSheets(sheets, _columnInfos, "").Any().ShouldBeTrue();
}
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);
}
public bool Process(string fileName, string acukwikName)
{
_FileName = fileName;
_AcukwikName = acukwikName;
_SuppoortedSheetCollection = AcukwikTemplateLoader.GetAcukwikDataSheetCollection(_AcukwikName);
LoadFileIntoDataTable();
if (ConvertAcukwikTable(_AcukwikName))
{
return(true);
}
else
{
return(false);
}
}
public DataSheetCollection GetDataSheetCollection(string acukwikName)
{
XmlDocument document = GetTemplateDocument(acukwikName);
DataSheetCollection collection = new DataSheetCollection();
if (document == null)
{
return(collection);
}
foreach (XmlNode node in document.SelectNodes("//AcukwikSheets/AcukwikSheet"))
{
DataSheet sheet = new DataSheet();
sheet.LoadFromNode(node);
collection.Add(sheet);
}
return(collection);
}
public DataSheetCollection GetDataSheetCollection(string clientName, string supplierName)
{
XmlDocument document = GetTemplateDocument(clientName, supplierName);
DataSheetCollection collection = new DataSheetCollection();
if (document == null)
{
return(collection);
}
foreach (XmlNode node in document.SelectNodes("//FuelSheets/FuelSheet"))
{
DataSheet sheet = new DataSheet();
sheet.LoadFromNode(node);
collection.Add(sheet);
}
return(collection);
}
public DataSheetCollection GetDataSheetCollection(int schedulingId)
{
XmlDocument document = GetTemplateDocument(schedulingId);
DataSheetCollection collection = new DataSheetCollection();
if (document == null)
{
return(collection);
}
foreach (XmlNode node in document.SelectNodes("//SchedulingSheets/SchedulingSheet"))
{
DataSheet sheet = new DataSheet();
sheet.LoadFromNode(node);
collection.Add(sheet);
}
return(collection);
}
public void ImportDataForConfirmation(string sheetName)
{
var sheets = new DataSheetCollection();
if (!ImportedSheets.Contains(sheetName))
{
ImportedSheets.AddSheet(getSingleSheet(sheetName));
sheets.AddSheet(getSingleSheet(sheetName));
}
if (!sheets.Any())
{
return;
}
OnImportSheets.Invoke(this,
new ImportSheetsEventArgs {
DataSourceFile = _dataSourceFile, SheetNames = sheets.GetDataSheetNames(), Filter = GetActiveFilterCriteria()
});
}
public bool Process(string fileName, Users user, Suppliers supplier)
{
_FileName = fileName;
_SupplierId = supplier.Id;
_AdminClientId = user.Client.Id;
_SuppoortedSheetCollection = TemplateLoader.GetSupplierDataSheetCollection(user.Client.Name, supplier.SupplierName);
LoadFileIntoDataTable();
FuelManagementPrices.SupplierFuelsPricesDataTable convertedTable = ConvertUploadedDataTable();
if (convertedTable == null)
{
return(false);
}
PrepareConvertedTableForDatabaseUpdate(convertedTable);
UploadDatabaseRecords(convertedTable);
if (convertedTable.Rows.Count == 0)
{
return(false);
}
return(true);
}
public bool Process(string fileName, int adminClientId, int schedulingId, int custClientId)
{
_FileName = fileName;
_SchedulingId = schedulingId;
_AdminClientId = adminClientId;
_CustClientId = custClientId;
_SupportedSheetCollection = SchedulingTemplateLoader.GetSchedulingDataSheetCollection(_SchedulingId);
LoadFileIntoDataTable();
SchedulingDataSet.SchedulingImportsDataTable convertedTable = ConvertUploadedDataTable();
if (convertedTable == null)
{
return(false);
}
PrepareConvertedTableForDatabaseUpdate(convertedTable);
UploadDatabaseRecords(convertedTable);
if (convertedTable.Rows.Count == 0)
{
return(false);
}
return(true);
}
public override void GlobalContext()
{
base.GlobalContext();
_dataSourceFile = A.Fake <IDataSourceFile>();
_importer = A.Fake <IImporter>();
_view = A.Fake <IImporterDataView>();
_dataSheet = new DataSheet {
SheetName = "sheet1"
};
_dataSheet.AddColumn("test_column", 0);
_dataSheet.AddRow(new List <string>()
{
"1"
});
_dataSheet2 = new DataSheet {
SheetName = "sheet2"
};
_dataSheet2.AddColumn("test_column", 0);
_dataSheet2.AddRow(new List <string>()
{
"1"
});
_dataSheet3 = new DataSheet {
SheetName = "sheet3"
};
_dataSheet3.AddColumn("test_column", 0);
_dataSheet3.AddRow(new List <string>()
{
"1"
});
_sheetsCollection = new DataSheetCollection();
_sheetsCollection.AddSheet(_dataSheet);
_sheetsCollection.AddSheet(_dataSheet2);
_sheetsCollection.AddSheet(_dataSheet3);
A.CallTo(() => _importer.LoadFile(A <ColumnInfoCache> ._, A <string> ._, A <IReadOnlyList <MetaDataCategory> > ._)).Returns(_dataSourceFile);
A.CallTo(() => _view.GetActiveFilterCriteria()).Returns("active_filter_criteria");
A.CallTo(() => _dataSourceFile.DataSheets).Returns(_sheetsCollection);
}
