public void CreateGeoTypesTest()
{
var xclImport = new ImportFromExcel();
var geoTypeImportList = xclImport.ExportToList <GeoTypeImp>("G:/WorkFiles/ModelManagement/res/geo/geo.xlsx", "GEO_ASSOC_TYPE");
var geoTypeArgs = geoTypeImportList.Select(gtyMap => new GeoTypeArg {
GeoTypeId = gtyMap.GEO_TYPE_ID, Description = gtyMap.DESCRIPTION, GeoTypePurposeId = "GEO_ASSOC"
}).ToList();
var createGeoTypesCommand = new CreateGeoTypesCommand
{
GeoTypeArgs = geoTypeArgs
};
var result = _service.InvokeCommand(createGeoTypesCommand);
}
public void CreateGeoAssocCommandTest()
{
var xclImport = new ImportFromExcel();
var geoAssocImportList = xclImport.ExportToList <GeoAssocImport>("G:/WorkFiles/ModelManagement/res/geo/geo.xlsx", "GEO_ASSOC");
var geoAssocArg = new List <GeoAssocArg>();
geoAssocImportList.ForEach(t => geoAssocArg.Add(new
GeoAssocArg
{
GeoId = t.GEO_ID,
GeoIdTo = t.GEO_ID_TO,
GeoAssocTypeId = t.GEO_ASSOC_TYPE_ID
}));
var result = _service.InvokeCommand(new CreateGeoAssocesCommand {
GeoAssocArgs = geoAssocArg
});
}
public void CreateGeosCommandTest()
{
var xclImport = new ImportFromExcel();
var geoImportList = xclImport.ExportToList <GeoImport>("G:/WorkFiles/ModelManagement/res/geo/geo_dial.xlsx", "Sheet1");
var geoArgs = (from geoImp in geoImportList
where !string.IsNullOrEmpty(geoImp.GEO_CODE)
select new GeoArg
{
//GeoId = geoImp.GEO_ID,
//GeoTypeId = geoImp.GEO_TYPE_ID,
//GeoName = geoImp.GEO_NAME,
GeoCode = geoImp.GEO_CODE,
DialingCode = geoImp.DIALING_CODE
}).ToList();
;
var createGeoCommand = new CreateGeosCommand
{
GeoArgs = geoArgs
};
var result = _service.InvokeCommand(createGeoCommand);
}