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