/// <summary> /// Creates the cities. /// </summary> /// <param name="EDC">The EDC.</param> public static void CreateCities(EntitiesDataContext EDC) { for (int i = 0; i < 10; i++) { CityType _cmm = new CityType() { Title = String.Format("City {0}", i) }; EDC.City.InsertOnSubmit(_cmm); EDC.SubmitChanges(); } }
private CityType GetOrAddCity(string _city, string _country, string _area) { CountryType _countryClass = GetOrAdd(m_EDC.Country, m_CountryClass, _country, false); if (_countryClass.CountryGroup.IsNullOrEmpty() && !_area.IsNullOrEmpty()) { _countryClass.CountryGroup = _area; } if (m_CityType.ContainsKey(_city)) { return(m_CityType[_city]); } CityType _prtnr = Create <CityType>(m_EDC.City, m_CityType, _city, false); _prtnr.CountryTitle = _countryClass; return(_prtnr); }
internal void AddMarket(PreliminaryDataRouteMarket _market) { try { Market _mrkt = GetOrAdd <Market>(m_EDC.Market, m_MarketMarket, _market.Market, false); CityType _CityType = GetOrAddCity(_market.DestinationCity, _market.DestinationCountry, _market.Area); string _dstName = String.Format("{0} in {1}", _CityType.Title, _mrkt.Title); DestinationMarket _DestinationMarket = new DestinationMarket() { //Tytuł = _dstName, DestinationMarket2CityTitle = _CityType, MarketTitle = _mrkt }; m_EDC.DestinationMarket.InsertOnSubmit(_DestinationMarket); m_EDC.SubmitChanges(); } catch (Exception ex) { string _format = "Cannot add market data DestinationCity={0} Market={1} because of import Error= {2}"; throw new ApplicationException(String.Format(_format, _market.DestinationCity, _market.Market, ex.Message)); } }
internal void AddRoute(PreliminaryDataRouteRoute _route, bool _testData) { try { ServiceType _service = GetService(_route); Partner _prtnr = GetOrAddJTIPartner(_service, _route.Vendor.Trim(), _testData); FreightPayer _freightPayer = GetOrAdd <FreightPayer>(m_EDC.FreightPayer, m_FreightPayer, _route.Freight_Payer__I_C__MainLeg, _testData); CityType _CityType = GetOrAddCity(_route.Dest_City, _route.Dest_Country, null); Currency _Currency = GetOrAdd <Currency>(m_EDC.Currency, m_Currency, _route.Currency, false); ShipmentType _ShipmentType = GetOrAdd <ShipmentType>(m_EDC.ShipmentType, m_ShipmentType, _route.ShipmentType, false); CarrierType _CarrierCarrierType = GetOrAdd <CarrierType>(m_EDC.Carrier, m_CarrierCarrierType, _route.Carrier, false); TranspotUnit _TranspotUnit = GetOrAdd <TranspotUnit>(m_EDC.TransportUnitType, m_TranspotUnit, _route.Equipment_Type__UoM, false); SAPDestinationPlant _SAPDestinationPlant = GetOrAdd <SAPDestinationPlant>(m_EDC.SAPDestinationPlant, m_SAPDestinationPlant, _route.SAP_Dest_Plant, false); BusienssDescription _busnessDscrptn = GetOrAdd <BusienssDescription>(m_EDC.BusinessDescription, m_BusinessDescription, _route.Business_description, false); Commodity _cmdty = GetOrAdd <Commodity>(m_EDC.Commodity, m_CommodityCommodity, _route.Commodity, false); string _sku = _route.Material_Master__Reference; string _title = String.Format("To: {0}, by: {1}, of: {2}", _CityType.Title, _prtnr.Title, _route.Commodity); switch (_service) { case ServiceType.Forwarder: Route _rt = new Route() { Route2BusinessDescriptionTitle = _busnessDscrptn, CarrierTitle = _CarrierCarrierType, Route2CityTitle = _CityType, DepartureCity = _route.Dept_City, CurrencyTitle = _Currency, FreightPayerTitle = _freightPayer, GoodsHandlingPO = _route.PO_NUMBER, MaterialMaster = _sku, DeparturePort = _route.Port_of_Dept, RemarkMM = _route.Remarks, SAPDestinationPlantTitle = _SAPDestinationPlant, ShipmentTypeTitle = _ShipmentType, Title = _title, TransportCosts = _testData ? 4567.8 : _route.Total_Cost_per_UoM.String2Double(), TransportUnitTypeTitle = _TranspotUnit, PartnerTitle = _prtnr, Route2Commodity = _cmdty, Incoterm = _route.Selling_Incoterm }; m_EDC.Route.InsertOnSubmit(_rt); break; case ServiceType.SecurityEscortProvider: SecurityEscortCatalog _sec = new SecurityEscortCatalog() { SecurityEscortCatalog2BusinessDescriptionTitle = _busnessDscrptn, CurrencyTitle = _Currency, EscortDestination = _route.Dest_City, FreightPayerTitle = _freightPayer, MaterialMaster = _sku, RemarkMM = _route.Remarks, SecurityCost = _testData ? 345.6 : _route.Total_Cost_per_UoM.String2Double(), SecurityEscrotPO = _route.PO_NUMBER, Title = _title, PartnerTitle = _prtnr }; m_EDC.SecurityEscortRoute.InsertOnSubmit(_sec); break; case ServiceType.VendorAndForwarder: case ServiceType.None: case ServiceType.Invalid: case ServiceType.Vendor: default: break; } m_EDC.SubmitChanges(); } catch (Exception ex) { string _format = "Cannot add route data SKU={0} Description={1} because of import Error= {2}"; throw new ApplicationException(String.Format(_format, _route.Material_Master_Short_Text, _route.Business_description, ex.Message)); } }