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); }