protected static FR_Bool Execute(DbConnection Connection, DbTransaction Transaction, P_L5ZW_SDfNC_1707 Parameter, CSV2Core.SessionSecurity.SessionSecurityTicket securityTicket = null)
{
#region UserCode
var returnValue = new FR_Bool();
returnValue.Result = false;
//Put your code here
#region get securityTicket and businessParticipantID by Paramter.AccountID and set defaultLanguageID
Guid tenantID;
Guid businessParticipantID;
if (Parameter.AccountID == Guid.Empty)
{
return(returnValue);
}
ORM_USR_Account orm_account = new ORM_USR_Account();
var result = orm_account.Load(Connection, Transaction, Parameter.AccountID);
if (result.Status != FR_Status.Success || orm_account.USR_AccountID == Guid.Empty)
{
return(returnValue);
}
tenantID = orm_account.Tenant_RefID;
securityTicket = new CSV2Core.SessionSecurity.SessionSecurityTicket()
{
TenantID = tenantID
};
ORM_CMN_BPT_BusinessParticipant.Query businessParticipantQuery = new ORM_CMN_BPT_BusinessParticipant.Query();
businessParticipantQuery.IfTenant_Tenant_RefID = tenantID;
businessParticipantQuery.IsDeleted = false;
ORM_CMN_BPT_BusinessParticipant businessParticipant = ORM_CMN_BPT_BusinessParticipant.Query.Search(Connection, Transaction, businessParticipantQuery).FirstOrDefault();
if (businessParticipant == null)
{
return(returnValue);
}
businessParticipantID = businessParticipant.CMN_BPT_BusinessParticipantID;
#endregion
#region get languages for tenant and set parameter dict values
P_L2LN_GALFTID_1530 languageParam = new P_L2LN_GALFTID_1530()
{
Tenant_RefID = tenantID
};
L2LN_GALFTID_1530[] languages = cls_Get_All_Languages_ForTenantID.Invoke(Connection, Transaction, languageParam, securityTicket).Result;
SetParameterDictValues(Parameter, languages);
List <ISOLanguage> languagesISOs = new List <ISOLanguage>();
languagesISOs.AddRange(languages.Select(l => new ISOLanguage()
{
ISO = l.ISO_639_1,
LanguageID = l.CMN_LanguageID
}).ToList());
#endregion
#region save defaultLanguage
// We are setting language for bp and acc
var defaultLanguage = languages.FirstOrDefault(i => i.ISO_639_1.ToLower().Contains(Parameter.DefaultLanguageCode.ToLower()));
if (defaultLanguage != null)
{
businessParticipant.DefaultLanguage_RefID = defaultLanguage.CMN_LanguageID;
businessParticipant.Save(Connection, Transaction);
orm_account.DefaultLanguage_RefID = defaultLanguage.CMN_LanguageID;
orm_account.Save(Connection, Transaction);
}
#endregion
#region save default country
if (Parameter.DefaultCountry != null)
{
ORM_CMN_Country country = new ORM_CMN_Country();
country.CMN_CountryID = Guid.NewGuid();
country.Country_ISOCode_Alpha3 = Parameter.DefaultCountry.Code;
country.Country_Name = new Dict()
{
DictionaryID = Guid.NewGuid()
};
country.Creation_Timestamp = DateTime.Now;
country.Default_Currency_RefID = Guid.Empty;
country.Default_Language_RefID = Guid.Empty;
country.Tenant_RefID = tenantID;
country.IsDeleted = false;
country.IsDefault = true;
foreach (var languageItem in languages)
{
country.Country_Name.UpdateEntry(languageItem.CMN_LanguageID, Parameter.DefaultCountry.Name);
}
country.Save(Connection, Transaction);
}
#endregion
#region save default currency
//asign currency
if (Parameter.DefaultCurrency != null)
{
ORM_CMN_Currency currency = new ORM_CMN_Currency();
currency.CMN_CurrencyID = Guid.NewGuid();
currency.Creation_Timestamp = DateTime.Now;
currency.IsDeleted = false;
currency.ISO4127 = Parameter.DefaultCurrency.Code;
currency.Name = new Dict()
{
DictionaryID = Guid.NewGuid()
};
currency.Tenant_RefID = tenantID;
foreach (var language in languages)
{
currency.Name.UpdateEntry(language.CMN_LanguageID, Parameter.DefaultCurrency.Name);
}
currency.Save(Connection, Transaction);
//set default currency
ORM_CMN_BPT_BusinessParticipant businessPart = new ORM_CMN_BPT_BusinessParticipant();
businessPart.Load(Connection, Transaction, businessParticipantID);
businessPart.DefaultCurrency_RefID = currency.CMN_CurrencyID;
businessPart.Save(Connection, Transaction);
}
#endregion
#region save organisational units
if (Parameter.OrganisationalUnitParameters.Length > 0)
{
foreach (var item in Parameter.OrganisationalUnitParameters)
{
cls_Save_Office.Invoke(Connection, Transaction, item, securityTicket);
}
}
#endregion
#region save cost centers
if (Parameter.CostCenterParameters.Length > 0)
{
foreach (var item in Parameter.CostCenterParameters)
{
cls_Save_CostCenter.Invoke(Connection, Transaction, item, securityTicket);
}
}
#endregion
#region save warehouses
if (Parameter.WarehousesParameters.Length > 0)
{
#region save warehouse group
P_L2WH_SWHG_1327 warehouseGroupParam = new P_L2WH_SWHG_1327();
warehouseGroupParam.Parent_RefID = Guid.Empty;
warehouseGroupParam.WarehouseGroup_Name = "Waregouse group";
warehouseGroupParam.WarehouseGroup_Description = new Dict()
{
DictionaryID = Guid.NewGuid()
};
foreach (var language in languages)
{
warehouseGroupParam.WarehouseGroup_Description.UpdateEntry(language.CMN_LanguageID, String.Empty);
}
var warehouseGroupID = cls_Save_Warehouse_Group.Invoke(Connection, Transaction, warehouseGroupParam, securityTicket).Result;
#endregion
foreach (var item in Parameter.WarehousesParameters)
{
item.LOG_WRH_WarehouseGroupID = warehouseGroupID;
cls_Save_Warehouse.Invoke(Connection, Transaction, item, securityTicket);
}
}
#endregion
#region create dimension templates
string jsonTemplates = ReadFromFile.LoadContentFromFile(@"Dimensions.json");
List <Dimension> dimensionTemplates = JsonConvert.DeserializeObject <List <Dimension> >(jsonTemplates);
int orderSequence = 1;
ORM_CMN_PRO_Dimension orm_dimension;
ORM_CMN_PRO_Dimension_Value orm_dimensionValue;
foreach (var template in dimensionTemplates)
{
orderSequence = 1;
#region save dimension
orm_dimension = new ORM_CMN_PRO_Dimension();
orm_dimension.Product_RefID = Guid.Empty;
orm_dimension.DimensionName = new Dict()
{
DictionaryID = Guid.NewGuid()
};
orm_dimension.IsDimensionTemplate = true;
orm_dimension.Tenant_RefID = tenantID;
foreach (var language in languages)
{
orm_dimension.DimensionName.UpdateEntry(language.CMN_LanguageID, template.Name);
}
orm_dimension.Save(Connection, Transaction);
#endregion
#region save dimension values
foreach (var templateValue in template.DimansionValues)
{
orm_dimensionValue = new ORM_CMN_PRO_Dimension_Value();
orm_dimensionValue.Dimensions_RefID = orm_dimension.CMN_PRO_DimensionID;
orm_dimensionValue.DimensionValue_Text = new Dict()
{
DictionaryID = Guid.NewGuid()
};
orm_dimensionValue.Tenant_RefID = tenantID;
orm_dimensionValue.OrderSequence = orderSequence;
foreach (var language in languages)
{
orm_dimensionValue.DimensionValue_Text.UpdateEntry(language.CMN_LanguageID, templateValue);
}
orm_dimensionValue.Save(Connection, Transaction);
orderSequence++;
}
#endregion
}
#endregion
#region create shipment types
string shipmentTypesJson = ReadFromFile.LoadContentFromFile(@"ShipmentTypes.json");
List <ShipmentTypes> shipmentTypes = JsonConvert.DeserializeObject <List <ShipmentTypes> >(shipmentTypesJson);
ORM_LOG_SHP_Shipment_Type orm_shipmentType;
foreach (var type in shipmentTypes)
{
#region save LOG_SHP_Shipment_Type
orm_shipmentType = new ORM_LOG_SHP_Shipment_Type();
orm_shipmentType.ShipmentType_Name = new Dict()
{
DictionaryID = Guid.NewGuid()
};
orm_shipmentType.ShipmentType_Description = new Dict()
{
DictionaryID = Guid.NewGuid()
};
orm_shipmentType.Tenant_RefID = tenantID;
foreach (var language in languages)
{
orm_shipmentType.ShipmentType_Name.UpdateEntry(language.CMN_LanguageID, type.Name);
orm_shipmentType.ShipmentType_Description.UpdateEntry(language.CMN_LanguageID, string.Empty);
}
orm_shipmentType.Save(Connection, Transaction);
#endregion
}
#endregion
#region create number ranges
string numberRangesJson = ReadFromFile.LoadContentFromFile(@"NumberRanges.json");
NumberRange numberRanges = JsonConvert.DeserializeObject <NumberRange>(numberRangesJson);
ORM_CMN_NumberRange_UsageArea numberRangeUsageArea;
ORM_CMN_NumberRange orm_numberRanges;
foreach (var item in numberRanges.NumberRanges)
{
if (Parameter.IsCustomerRegistration && item.Name == "Customer orders")
{
continue;
}
if (!Parameter.IsCustomerRegistration && item.Name == "Distribution orders")
{
continue;
}
if (!Parameter.IsCustomerRegistration && item.Name == "Procurement orders")
{
continue;
}
numberRangeUsageArea = new ORM_CMN_NumberRange_UsageArea();
numberRangeUsageArea.UsageArea_Name = new Dict()
{
DictionaryID = Guid.NewGuid()
};
numberRangeUsageArea.UsageArea_Description = new Dict()
{
DictionaryID = Guid.NewGuid()
};
foreach (var language in languages)
{
numberRangeUsageArea.UsageArea_Name.UpdateEntry(language.CMN_LanguageID, item.Name);
numberRangeUsageArea.UsageArea_Description.UpdateEntry(language.CMN_LanguageID, string.Empty);
}
numberRangeUsageArea.Tenant_RefID = tenantID;
numberRangeUsageArea.GlobalStaticMatchingID = item.GlobalStaticMatchingID;
numberRangeUsageArea.Save(Connection, Transaction);
orm_numberRanges = new ORM_CMN_NumberRange();
orm_numberRanges.NumberRange_Name = item.Name;
orm_numberRanges.Tenant_RefID = tenantID;
orm_numberRanges.NumberRange_UsageArea_RefID = numberRangeUsageArea.CMN_NumberRange_UsageAreaID;
orm_numberRanges.FixedPrefix = item.FixedPrefix;
orm_numberRanges.Formatting_LeadingFillCharacter = item.FillCharacter;
orm_numberRanges.Formatting_NumberLength = item.Length;
orm_numberRanges.Value_Current = item.CurrentValue;
orm_numberRanges.Value_Start = item.StartValue;
orm_numberRanges.Value_End = item.EndValue;
orm_numberRanges.Save(Connection, Transaction);
}
#endregion
#region create inventory change reasons
string inventoryChangeReasonsJson = ReadFromFile.LoadContentFromFile(@"InventoryChangeReasons.json");
List <InventoryChangeReasons> inventoryChangeReasons = JsonConvert.DeserializeObject <List <InventoryChangeReasons> >(inventoryChangeReasonsJson);
ORM_LOG_WRH_InventoryChangeReason orm_inventoryChangeReason;
foreach (var reason in inventoryChangeReasons)
{
#region save inventory change reason
orm_inventoryChangeReason = new ORM_LOG_WRH_InventoryChangeReason();
orm_inventoryChangeReason.GlobalPropertyMatchingID = InventoryChangeReasons.InventoryChangeReasonGlobalPropertyMatchingID + "-" + reason.Name;
orm_inventoryChangeReason.InventoryChange_Name = new Dict()
{
DictionaryID = Guid.NewGuid()
};
orm_inventoryChangeReason.InventoryChange_Description = new Dict()
{
DictionaryID = Guid.NewGuid()
};
orm_inventoryChangeReason.Tenant_RefID = tenantID;
foreach (var language in languages)
{
orm_inventoryChangeReason.InventoryChange_Name.UpdateEntry(language.CMN_LanguageID, reason.Name);
orm_inventoryChangeReason.InventoryChange_Description.UpdateEntry(language.CMN_LanguageID, string.Empty);
}
orm_inventoryChangeReason.Save(Connection, Transaction);
#endregion
}
#endregion
#region create shipment statuses
var shipmentStatuses = Enum.GetValues(typeof(EShipmentStatus));
var shipmentStatusDicts = EnumUtils.GetDictObjectsForStaticListData <EShipmentStatus>(
ResourceFilePath.ShipmentStatus, ORM_LOG_SHP_Shipment_Status.TableName, languagesISOs);
var statusCodeCount = 1;
ORM_LOG_SHP_Shipment_Status shipmentStatus;
foreach (EShipmentStatus status in shipmentStatuses)
{
shipmentStatus = new ORM_LOG_SHP_Shipment_Status();
shipmentStatus.GlobalPropertyMatchingID = EnumUtils.GetEnumDescription((EShipmentStatus)status);
shipmentStatus.Status_Code = statusCodeCount++;
shipmentStatus.Status_Name = shipmentStatusDicts[EnumUtils.GetEnumDescription((EShipmentStatus)status)];
shipmentStatus.Tenant_RefID = tenantID;
shipmentStatus.Save(Connection, Transaction);
}
#endregion
if (Parameter.IsCustomerRegistration)
{
#region create procurement order statuses
var procurementStatuses = Enum.GetValues(typeof(EProcurementStatus));
ORM_ORD_PRC_ProcurementOrder_Status procurementOrderStatus;
foreach (EProcurementStatus status in procurementStatuses)
{
procurementOrderStatus = new ORM_ORD_PRC_ProcurementOrder_Status();
procurementOrderStatus.GlobalPropertyMatchingID = EnumUtils.GetEnumDescription(status);
procurementOrderStatus.Tenant_RefID = tenantID;
procurementOrderStatus.Save(Connection, Transaction);
}
#endregion
}
else
{
#region create customer order statuses
var customerOrderStatuses = Enum.GetValues(typeof(ECustomerOrderStatus));
var customerOrderStatusesDicts = EnumUtils.GetDictObjectsForStaticListData <ECustomerOrderStatus>(
ResourceFilePath.CustomerOrderStatus, ORM_ORD_CUO_CustomerOrder_Status.TableName, languagesISOs);
var count = 1;
ORM_ORD_CUO_CustomerOrder_Status customerOrderStatus;
foreach (var status in customerOrderStatuses)
{
customerOrderStatus = new ORM_ORD_CUO_CustomerOrder_Status();
customerOrderStatus.GlobalPropertyMatchingID = EnumUtils.GetEnumDescription((ECustomerOrderStatus)status);
customerOrderStatus.Status_Code = count++;
customerOrderStatus.Status_Name = customerOrderStatusesDicts[EnumUtils.GetEnumDescription((ECustomerOrderStatus)status)];
customerOrderStatus.Tenant_RefID = tenantID;
customerOrderStatus.Save(Connection, Transaction);
}
#endregion
}
returnValue.Result = true;
return(returnValue);
#endregion UserCode
}
protected static FR_L5CO_ACOaCS_2108_Array Execute(DbConnection Connection, DbTransaction Transaction, P_L5CO_ACOaCS_2108[] Parameter, CSV2Core.SessionSecurity.SessionSecurityTicket securityTicket = null)
{
#region UserCode
var returnValue = new FR_L5CO_ACOaCS_2108_Array();
List <L5CO_ACOaCS_2108> confirmedProcurementOrders = new List <L5CO_ACOaCS_2108>();
foreach (var param in Parameter)
{
L5CO_ACOaCS_2108 procurementOrderITL = new L5CO_ACOaCS_2108();
var confirmedStatus = ORM_ORD_CUO_CustomerOrder_Status.Query.Search(Connection, Transaction,
new ORM_ORD_CUO_CustomerOrder_Status.Query
{
GlobalPropertyMatchingID = EnumUtils.GetEnumDescription(ECustomerOrderStatus.Confirmed),
Tenant_RefID = securityTicket.TenantID,
IsDeleted = false
}).Single().ORD_CUO_CustomerOrder_StatusID;
var customerOrder = new ORM_ORD_CUO_CustomerOrder_Header();
customerOrder.Load(Connection, Transaction, param.CustomerOrderHeaderID);
customerOrder.Current_CustomerOrderStatus_RefID = confirmedStatus;
customerOrder.IsCustomerOrderFinalized = true;
customerOrder.Save(Connection, Transaction);
ORM_USR_Account account = new ORM_USR_Account();
account.Load(Connection, Transaction, securityTicket.AccountID);
ORM_ORD_CUO_CustomerOrder_StatusHistory newStatusInHistory = new ORM_ORD_CUO_CustomerOrder_StatusHistory();
newStatusInHistory.CustomerOrder_Header_RefID = customerOrder.ORD_CUO_CustomerOrder_HeaderID;
newStatusInHistory.StatusHistoryComment = param.Message;
newStatusInHistory.Tenant_RefID = securityTicket.TenantID;
newStatusInHistory.CustomerOrder_Status_RefID = confirmedStatus;
newStatusInHistory.PerformedBy_BusinessParticipant_RefID = account.BusinessParticipant_RefID;
newStatusInHistory.Save(Connection, Transaction);
procurementOrderITL.ProcurementOrderITL = customerOrder.ProcurementOrderITL;
procurementOrderITL.ProcuringTenatID = customerOrder.OrderingCustomer_BusinessParticipant_RefID.ToString();
ORM_CMN_NumberRange_UsageArea numberRangeUsageArea = ORM_CMN_NumberRange_UsageArea.Query.Search(Connection, Transaction, new ORM_CMN_NumberRange_UsageArea.Query()
{
IsDeleted = false,
Tenant_RefID = securityTicket.TenantID,
GlobalStaticMatchingID = NumberRangeGlobalPropertyMatchingID
}).FirstOrDefault();
if (numberRangeUsageArea == null)
{
throw new Exception(String.Format("Number range usage area with GPMID = {0} was not found.", NumberRangeGlobalPropertyMatchingID));
}
ORM_CMN_NumberRange numberRange = ORM_CMN_NumberRange.Query.Search(Connection, Transaction, new ORM_CMN_NumberRange.Query()
{
IsDeleted = false,
Tenant_RefID = securityTicket.TenantID,
NumberRange_UsageArea_RefID = numberRangeUsageArea.CMN_NumberRange_UsageAreaID
}).FirstOrDefault();
if (numberRange == null)
{
throw new Exception(String.Format("Number range for area with GPMID = {0} was not found.", NumberRangeGlobalPropertyMatchingID));
}
numberRange.Value_Current++;
numberRange.Save(Connection, Transaction);
string shipmentNumber = numberRange.FixedPrefix + numberRange.Value_Current.ToString().PadLeft(numberRange.Formatting_NumberLength, numberRange.Formatting_LeadingFillCharacter[0]);
ORM_LOG_SHP_Shipment_Header shipmentHeader = new ORM_LOG_SHP_Shipment_Header();
shipmentHeader.LOG_SHP_Shipment_HeaderID = Guid.NewGuid();
shipmentHeader.RecipientBusinessParticipant_RefID = customerOrder.OrderingCustomer_BusinessParticipant_RefID;
shipmentHeader.ShipmentHeaderITL = shipmentHeader.LOG_SHP_Shipment_HeaderID.ToString();
shipmentHeader.ShipmentHeader_Number = shipmentNumber;
shipmentHeader.Shippipng_AddressUCD_RefID = customerOrder.ShippingAddressUCD_RefID;
shipmentHeader.ShipmentPriority = 0;
shipmentHeader.ShipmentHeader_ValueWithoutTax = customerOrder.TotalValue_BeforeTax;
shipmentHeader.ShipmentHeader_Currency_RefID = customerOrder.CustomerOrder_Currency_RefID;
shipmentHeader.Tenant_RefID = securityTicket.TenantID;
shipmentHeader.IsDeleted = false;
shipmentHeader.Save(Connection, Transaction);
var customerOrderPositions = ORM_ORD_CUO_CustomerOrder_Position.Query.Search(Connection, Transaction, new ORM_ORD_CUO_CustomerOrder_Position.Query()
{
CustomerOrder_Header_RefID = customerOrder.ORD_CUO_CustomerOrder_HeaderID,
IsDeleted = false,
Tenant_RefID = securityTicket.TenantID
});
if (customerOrderPositions != null)
{
foreach (var customerOrderPosition in customerOrderPositions)
{
ORM_LOG_SHP_Shipment_Position shipmentPosition = new ORM_LOG_SHP_Shipment_Position();
shipmentPosition.LOG_SHP_Shipment_PositionID = Guid.NewGuid();
shipmentPosition.ShipmentPositionITL = shipmentPosition.LOG_SHP_Shipment_PositionID.ToString();
shipmentPosition.LOG_SHP_Shipment_Header_RefID = shipmentHeader.LOG_SHP_Shipment_HeaderID;
shipmentPosition.CMN_PRO_Product_RefID = customerOrderPosition.CMN_PRO_Product_RefID;
shipmentPosition.CMN_PRO_ProductVariant_RefID = customerOrderPosition.CMN_PRO_Product_Variant_RefID;
shipmentPosition.CMN_PRO_ProductRelease_RefID = customerOrderPosition.CMN_PRO_Product_Release_RefID;
shipmentPosition.QuantityToShip = customerOrderPosition.Position_Quantity;
shipmentPosition.ShipmentPosition_PricePerUnitValueWithoutTax = customerOrderPosition.Position_ValuePerUnit;
shipmentPosition.ShipmentPosition_ValueWithoutTax = customerOrderPosition.Position_ValueTotal;
shipmentPosition.IsCancelled = false;
shipmentPosition.Tenant_RefID = securityTicket.TenantID;
shipmentPosition.IsDeleted = false;
shipmentPosition.Save(Connection, Transaction);
ORM_ORD_CUO_CustomerOrder_Position_2_ShipmentPosition customerOrderPositionToShipmentPosition = new ORM_ORD_CUO_CustomerOrder_Position_2_ShipmentPosition();
customerOrderPositionToShipmentPosition.AssignmentID = Guid.NewGuid();
customerOrderPositionToShipmentPosition.LOG_SHP_Shipment_Position_RefID = shipmentPosition.LOG_SHP_Shipment_PositionID;
customerOrderPositionToShipmentPosition.ORD_CUO_CustomerOrder_Position_RefID = customerOrderPosition.ORD_CUO_CustomerOrder_PositionID;
customerOrderPositionToShipmentPosition.Tenant_RefID = securityTicket.TenantID;
customerOrderPositionToShipmentPosition.IsDeleted = false;
customerOrderPositionToShipmentPosition.Save(Connection, Transaction);
}
}
//TO DO: UNCOMMENT AFTER JANKO ADD STATUSES
//var shipmentStatusHistoryStatusID = ORM_LOG_SHP_Shipment_Status.Query.Search(Connection, Transaction, new ORM_LOG_SHP_Shipment_Status.Query()
//{
// GlobalPropertyMatchingID = EnumUtils.GetEnumDescription(EShipmentStatus.Created),
// Tenant_RefID = securityTicket.TenantID,
// IsDeleted = false
//}).Single().LOG_SHP_Shipment_StatusID;
//ORM_LOG_SHP_Shipment_StatusHistory shipmentStatusHistory = new ORM_LOG_SHP_Shipment_StatusHistory();
//shipmentStatusHistory.LOG_SHP_Shipment_StatusHistoryID = Guid.NewGuid();
//shipmentStatusHistory.LOG_SHP_Shipment_Header_RefID = shipmentHeader.LOG_SHP_Shipment_HeaderID;
//shipmentStatusHistory.LOG_SHP_Shipment_Status_RefID = shipmentStatusHistoryStatusID;
//shipmentStatusHistory.PerformedBy_BusinessParticipant_RefID = securityTicket.TenantID;
//shipmentStatusHistory.Tenant_RefID = securityTicket.TenantID;
//shipmentStatusHistory.IsDeleted = false;
//shipmentStatusHistory.Save(Connection, Transaction);
ORM_LOG_SHP_ShipmentHeader_2_CustomerOrderHeader shipmentToCustomerOrderHeader = new ORM_LOG_SHP_ShipmentHeader_2_CustomerOrderHeader();
shipmentToCustomerOrderHeader.AssignmentID = Guid.NewGuid();
shipmentToCustomerOrderHeader.LOG_SHP_Shipment_Header_RefID = shipmentHeader.LOG_SHP_Shipment_HeaderID;
shipmentToCustomerOrderHeader.ORD_CUO_CustomerOrder_Header_RefID = customerOrder.ORD_CUO_CustomerOrder_HeaderID;
shipmentToCustomerOrderHeader.Tenant_RefID = securityTicket.TenantID;
shipmentToCustomerOrderHeader.IsDeleted = false;
shipmentToCustomerOrderHeader.Save(Connection, Transaction);
confirmedProcurementOrders.Add(procurementOrderITL);
}
returnValue.Result = confirmedProcurementOrders.ToArray();
return(returnValue);
#endregion UserCode
}
protected static FR_L3DO_SDO_1801 Execute(DbConnection Connection, DbTransaction Transaction, P_L3DO_SDO_1801 Parameter, CSV2Core.SessionSecurity.SessionSecurityTicket securityTicket = null)
{
#region UserCode
var returnValue = new FR_L3DO_SDO_1801();
returnValue.Result = new L3DO_SDO_1801();
ORM_CMN_UniversalContactDetail universalContactDetails = new ORM_CMN_UniversalContactDetail();
universalContactDetails.CMN_UniversalContactDetailID = Guid.NewGuid();
universalContactDetails.Contact_Email = Parameter.UniversalContactDetails.Email;
universalContactDetails.Contact_Telephone = Parameter.UniversalContactDetails.Phone;
universalContactDetails.Country_Name = Parameter.UniversalContactDetails.Country;
universalContactDetails.Country_639_1_ISOCode = Parameter.UniversalContactDetails.CountryIso;
universalContactDetails.Creation_Timestamp = DateTime.Now;
universalContactDetails.First_Name = Parameter.UniversalContactDetails.FirstName;
universalContactDetails.Last_Name = Parameter.UniversalContactDetails.LastName;
universalContactDetails.Street_Name = Parameter.UniversalContactDetails.StreetName;
universalContactDetails.Street_Number = Parameter.UniversalContactDetails.StreetNumber;
universalContactDetails.ZIP = Parameter.UniversalContactDetails.Zip;
universalContactDetails.Town = Parameter.UniversalContactDetails.Town;
universalContactDetails.Tenant_RefID = securityTicket.TenantID;
universalContactDetails.POBox = Parameter.UniversalContactDetails.POBox;
universalContactDetails.Save(Connection, Transaction);
ORM_CMN_NumberRange_UsageArea numberRangeUsageArea = ORM_CMN_NumberRange_UsageArea.Query.Search(Connection, Transaction, new ORM_CMN_NumberRange_UsageArea.Query()
{
IsDeleted = false,
Tenant_RefID = securityTicket.TenantID,
GlobalStaticMatchingID = NumberRangeGlobalPropertyMatchingID
}).FirstOrDefault();
if (numberRangeUsageArea == null)
{
throw new Exception(String.Format("Number range usage area with GPMID = {0} was not found.", NumberRangeGlobalPropertyMatchingID));
}
ORM_CMN_NumberRange numberRange = ORM_CMN_NumberRange.Query.Search(Connection, Transaction, new ORM_CMN_NumberRange.Query()
{
IsDeleted = false,
Tenant_RefID = securityTicket.TenantID,
NumberRange_UsageArea_RefID = numberRangeUsageArea.CMN_NumberRange_UsageAreaID
}).FirstOrDefault();
if (numberRange == null)
{
throw new Exception(String.Format("Number range for area with GPMID = {0} was not found.", NumberRangeGlobalPropertyMatchingID));
}
numberRange.Value_Current++;
numberRange.Save(Connection, Transaction);
string distributionOrderNumber = numberRange.FixedPrefix + numberRange.Value_Current.ToString().PadLeft(numberRange.Formatting_NumberLength, numberRange.Formatting_LeadingFillCharacter[0]);
ORM_ORD_DIS_DistributionOrder_Header header = new ORM_ORD_DIS_DistributionOrder_Header();
header.Charged_CostCenter_RefID = Parameter.IsCostCenterOrderRefID;
header.Creation_Timestamp = DateTime.Now;
header.DistributeTo_UCDAddress_RefID = universalContactDetails.CMN_UniversalContactDetailID;
header.DistributionOrderDate = DateTime.Now;
header.DistributionOrderNumber = distributionOrderNumber;
header.IfForDelivery_LogisticsProvider_RefID = Parameter.IsForDeliveryLogisticProviderRefID.ToString();
header.IfForDelivery_ShipmentType_RefID = Parameter.IsForDeliveryShipmentTypeRefID;
header.IfForPickup_PointOfSale_RefID = Parameter.IsForPickupPointOfSaleRefID;
header.IsCostCenterOrder = Parameter.IsCostCenterOrder;
header.IsDeleted = false;
header.IsForDelivery = Parameter.IsForDelivery;
header.ORD_DIS_DistributionOrder_HeaderID = Guid.NewGuid();
header.Tenant_RefID = securityTicket.TenantID;
header.InternallyCharged_Currency_RefID = Parameter.CurrencyID;
header.InternallyCharged_TotalNetPriceValue = 0;
header.IsForPickup = Parameter.IsForPickup;
foreach (var item in Parameter.DistributionOrderPositions)
{
if (item.Quantity == 0)
{
continue;
}
ORM_CMN_PRO_ASS_AssortmentVariant assortmentVariant = ORM_CMN_PRO_ASS_AssortmentVariant.Query.Search(Connection, Transaction, new ORM_CMN_PRO_ASS_AssortmentVariant.Query()
{
IsDeleted = false,
Tenant_RefID = securityTicket.TenantID,
Ext_CMN_PRO_Product_Variant_RefID = item.ProductVariantID
}).FirstOrDefault();
ORM_ORD_DIS_DistributionOrder_Position position = null;
if (assortmentVariant == null)
{
//This means that this product might be local one
position = new ORM_ORD_DIS_DistributionOrder_Position();
position.Product_RefID = item.ProductID;
position.Product_Variant_RefID = item.ProductVariantID;
}
else
{
//This means that product is from assortment and we are supposed to take orginal product.
List <ORM_CMN_PRO_ASS_AssortmentVariant_VendorVariant> assortmentVendorVariats = ORM_CMN_PRO_ASS_AssortmentVariant_VendorVariant.Query.Search(Connection, Transaction, new ORM_CMN_PRO_ASS_AssortmentVariant_VendorVariant.Query()
{
IsDeleted = false,
Tenant_RefID = securityTicket.TenantID,
CMN_PRO_ASS_AssortmentVariant_RefID = assortmentVariant.CMN_PRO_ASS_AssortmentVariantID
});
ORM_CMN_PRO_ASS_AssortmentVariant_VendorVariant defaultVendorVariant = assortmentVendorVariats.FirstOrDefault(x => x.IsDefaultVendorVariant == true);
if (defaultVendorVariant == null)
{
defaultVendorVariant = assortmentVendorVariats.First();
}
if (defaultVendorVariant != null)
{
ORM_CMN_PRO_Product_Variant productVariant = ORM_CMN_PRO_Product_Variant.Query.Search(Connection, Transaction, new ORM_CMN_PRO_Product_Variant.Query()
{
IsDeleted = false,
Tenant_RefID = securityTicket.TenantID,
CMN_PRO_Product_VariantID = defaultVendorVariant.CMN_PRO_Product_Variant_RefID
}).FirstOrDefault();
if (productVariant != null)
{
position = new ORM_ORD_DIS_DistributionOrder_Position();
position.Product_RefID = productVariant.CMN_PRO_Product_RefID;
position.Product_Variant_RefID = productVariant.CMN_PRO_Product_VariantID;
}
}
}
if (position != null)
{
position.Creation_Timestamp = DateTime.Now;
position.DistributionOrder_Header_RefID = header.ORD_DIS_DistributionOrder_HeaderID;
position.ORD_DIS_DistributionOrder_PositionID = Guid.NewGuid();
position.Quantity = item.Quantity;
position.Tenant_RefID = securityTicket.TenantID;
position.InternallyCharged_TotalNetPriceValue = item.PriceValueTotal;
position.Save(Connection, Transaction);
if (item.DistributionOrderPositionCustomizations != null && item.DistributionOrderPositionCustomizations.Where(x => x.CustomizationVariantID != Guid.Empty).Count() > 0)
{
foreach (var itemCustomization in item.DistributionOrderPositionCustomizations)
{
if (itemCustomization.CustomizationVariantID != Guid.Empty)
{
ORM_ORD_DIS_DistributionOrder_Position_Customization customization = new ORM_ORD_DIS_DistributionOrder_Position_Customization();
customization.ORD_DIS_DistributionOrder_Position_CustomizationID = itemCustomization.DistributionOrderPositionCustomizationID;
customization.Tenant_RefID = securityTicket.TenantID;
customization.DistributionOrder_Position_RefID = position.ORD_DIS_DistributionOrder_PositionID;
customization.CustomizationVariant_Name = itemCustomization.CustomizationVariantName;
customization.Customization_Variant_RefID = itemCustomization.CustomizationVariantID;
customization.Customization_Name = itemCustomization.CustomizationName;
customization.Save(Connection, Transaction);
}
}
}
}
header.InternallyCharged_TotalNetPriceValue += position.InternallyCharged_TotalNetPriceValue;
}
header.Save(Connection, Transaction);
foreach (var item in Parameter.Documents)
{
ORM_DOC_Document document = new ORM_DOC_Document();
document.Alias = item.Alias;
document.PrimaryType = item.PrimaryType;
document.DOC_DocumentID = item.DocumentID;
document.Creation_Timestamp = DateTime.Now;
document.Tenant_RefID = securityTicket.TenantID;
document.Save(Connection, Transaction);
ORM_ORD_DIS_DistributionOrder_Header_Document orderDocument = new ORM_ORD_DIS_DistributionOrder_Header_Document();
orderDocument.Creation_Timestamp = DateTime.Now;
orderDocument.DistributionOrder_Header_RefID = header.ORD_DIS_DistributionOrder_HeaderID;
orderDocument.Document_RefID = document.DOC_DocumentID;
orderDocument.ORD_DIS_DistributionOrder_Header_DocumentID = Guid.NewGuid();
orderDocument.Tenant_RefID = securityTicket.TenantID;
orderDocument.Save(Connection, Transaction);
}
ORM_USR_Account account = ORM_USR_Account.Query.Search(Connection, Transaction, new ORM_USR_Account.Query()
{
Tenant_RefID = securityTicket.TenantID,
USR_AccountID = securityTicket.AccountID,
IsDeleted = false
}).FirstOrDefault();
ORM_ORD_DIS_DistributionOrder_Header_History history = new ORM_ORD_DIS_DistributionOrder_Header_History();
history.Comment = Parameter.UniversalContactDetails.Comment;
history.Creation_Timestamp = DateTime.Now;
history.DistributionOrder_Header_RefID = header.ORD_DIS_DistributionOrder_HeaderID;
history.IsCreated = true;
history.ORD_DIS_DistributionOrder_Header_HistoryID = Guid.NewGuid();
history.Tenant_RefID = securityTicket.TenantID;
history.TriggeredBy_BusinessParticipant_RefID = account != null ? account.BusinessParticipant_RefID : Guid.Empty;
history.Save(Connection, Transaction);
returnValue.Result.DistributionOrderHeaderID = header.ORD_DIS_DistributionOrder_HeaderID;
returnValue.Result.DistributionOrderNumber = header.DistributionOrderNumber;
return(returnValue);
#endregion UserCode
}
