protected static FR_Guid Execute(DbConnection Connection, DbTransaction Transaction, P_L2AP_SPT_1110 Parameter, CSV2Core.SessionSecurity.SessionSecurityTicket securityTicket = null) { #region UserCode var returnValue = new FR_Guid(); var item = new ORM_ACC_PAY_Type(); if (Parameter.ACC_PAY_TypeID != Guid.Empty) { var result = item.Load(Connection, Transaction, Parameter.ACC_PAY_TypeID); if (result.Status != FR_Status.Success || item.ACC_PAY_TypeID == Guid.Empty) { var error = new FR_Guid(); error.ErrorMessage = "No Such ID"; error.Status = FR_Status.Error_Internal; return(error); } } if (Parameter.IsDeleted == true) { item.IsDeleted = true; return(new FR_Guid(item.Save(Connection, Transaction), item.ACC_PAY_TypeID)); } //Creation specific parameters (Tenant, Account ... ) if (Parameter.ACC_PAY_TypeID == Guid.Empty) { item.Tenant_RefID = securityTicket.TenantID; } item.GlobalPropertyMatchingID = Parameter.GlobalPropertyMatchingID; item.PaymentType_Name = Parameter.PaymentType_Name; item.IsCashPaymentType = Parameter.IsCashPaymentType; return(new FR_Guid(item.Save(Connection, Transaction), item.ACC_PAY_TypeID)); #endregion UserCode }
protected static FR_L6BL_GADfBSBR_1010 Execute(DbConnection Connection, DbTransaction Transaction, P_L6BL_GADfBSBR_1010 Parameter, CSV2Core.SessionSecurity.SessionSecurityTicket securityTicket = null) { #region UserCode var returnValue = new FR_L6BL_GADfBSBR_1010(); //Put your code here #region Retrieving bill header. ORM_BIL_BillHeader billHeader = new ORM_BIL_BillHeader(); FR_Base billHeaderLoad = billHeader.Load(Connection, Transaction, Parameter.BillHeaderID); if (billHeaderLoad.Status != FR_Status.Success) { Exception ex = new Exception(billHeaderLoad.ErrorMessage); return(new FR_L6BL_GADfBSBR_1010(ex)); } #endregion #region Retrieving universal contact details. ORM_CMN_UniversalContactDetail universalContactDetails = new ORM_CMN_UniversalContactDetail(); FR_Base universalContactDetailsLoad = universalContactDetails.Load(Connection, Transaction, billHeader.BillingAddress_UCD_RefID); if (universalContactDetailsLoad.Status != FR_Status.Success) { Exception ex = new Exception(universalContactDetailsLoad.ErrorMessage); return(new FR_L6BL_GADfBSBR_1010(ex)); } #endregion #region Retrieving business participants details. ORM_CMN_BPT_BusinessParticipant businessParticipant = new ORM_CMN_BPT_BusinessParticipant(); FR_Base businessParticipantLoad = businessParticipant.Load(Connection, Transaction, billHeader.BillRecipient_BuisnessParticipant_RefID); if (businessParticipantLoad.Status != FR_Status.Success) { Exception ex = new Exception(businessParticipantLoad.ErrorMessage); return(new FR_L6BL_GADfBSBR_1010(ex)); } #endregion #region Retrieving customer details. ORM_CMN_BPT_CTM_Customer customer = ORM_CMN_BPT_CTM_Customer.Query.Search(Connection, Transaction, new ORM_CMN_BPT_CTM_Customer.Query { Ext_BusinessParticipant_RefID = businessParticipant.CMN_BPT_BusinessParticipantID }).FirstOrDefault(); if (customer == null) { Exception ex = new Exception("Retrieving ORM_CMN_BPT_CTM_Customer details failed."); return(new FR_L6BL_GADfBSBR_1010(ex)); } #endregion #region Retriving method of payments (taking first one) ORM_BIL_BillHeader_MethodOfPayment methodOfPayment = ORM_BIL_BillHeader_MethodOfPayment.Query.Search(Connection, Transaction, new ORM_BIL_BillHeader_MethodOfPayment.Query { BIL_BillHeader_RefID = billHeader.BIL_BillHeaderID }).FirstOrDefault(); #endregion #region Retrieving payment type ORM_ACC_PAY_Type type = null; if (methodOfPayment != null) { type = ORM_ACC_PAY_Type.Query.Search(Connection, Transaction, new ORM_ACC_PAY_Type.Query { ACC_PAY_TypeID = methodOfPayment.ACC_PAY_Type_RefID }).Single(); } #endregion #region Retrieving payment condition ORM_ACC_PAY_Condition condition = ORM_ACC_PAY_Condition.Query.Search(Connection, Transaction, new ORM_ACC_PAY_Condition.Query { ACC_PAY_ConditionID = billHeader.BillHeader_PaymentCondition_RefID }).FirstOrDefault(); #endregion #region Retrieving bill positions var allBillPositions = cls_Get_AllPositions_with_Articles_for_BillHeader.Invoke(Connection, Transaction, new P_L5BL_GAPwAfBH_1118 { BillHeaderID = billHeader.BIL_BillHeaderID }, securityTicket).Result; #endregion returnValue.Result = new L6BL_GADfBSBR_1010(); returnValue.Result.BillShipmentBasedReportHeaderDetails = new L6BL_GADfBSBR_1010a(); returnValue.Result.BillShipmentBasedReportHeaderDetails.BillHeaderComment = billHeader.BillComment; returnValue.Result.BillShipmentBasedReportHeaderDetails.BillHeaderDate = billHeader.DateOnBill; returnValue.Result.BillShipmentBasedReportHeaderDetails.BillHeaderNumber = billHeader.BillNumber; returnValue.Result.BillShipmentBasedReportHeaderDetails.BillHeaderTotalValue_BeforeTax = billHeader.TotalValue_BeforeTax; returnValue.Result.BillShipmentBasedReportHeaderDetails.BillHeaderTotalValue_IncludingTax = billHeader.TotalValue_IncludingTax; if (condition != null) { returnValue.Result.BillShipmentBasedReportHeaderDetails.BillHeaderPaymentDeadline = billHeader.DateOnBill.AddDays(condition.MaximumPaymentTreshold_InDays); } if (type != null) { returnValue.Result.BillShipmentBasedReportHeaderDetails.BillHeaderPaymentType = type.PaymentType_Name; } if (businessParticipant != null) { returnValue.Result.BillShipmentBasedReportHeaderDetails.RecepientBusinessParticipantDisplayName = businessParticipant.DisplayName; } if (customer != null) { returnValue.Result.BillShipmentBasedReportHeaderDetails.RecepientBusinessParticipantNumber = customer.InternalCustomerNumber; } if (universalContactDetails != null) { returnValue.Result.BillShipmentBasedReportHeaderDetails.RecepientBusinessParticipantStreetName = universalContactDetails.Street_Name; returnValue.Result.BillShipmentBasedReportHeaderDetails.RecepientBusinessParticipantStreetNumber = universalContactDetails.Street_Number; returnValue.Result.BillShipmentBasedReportHeaderDetails.RecepientBusinessParticipantCity = universalContactDetails.Town; returnValue.Result.BillShipmentBasedReportHeaderDetails.RecepientBusinessParticipantZipCode = universalContactDetails.ZIP; } #region bill positions returnValue.Result.BillPositions = null; List <L6BL_GADfBSBR_1010bp> unsortedBillPositionsTemp = new List <L6BL_GADfBSBR_1010bp>(); if (allBillPositions.ShipmentBillPositions != null) { var unsortedBillPositions = allBillPositions.ShipmentBillPositions.Where(x => x.BillPosition.CMN_BPT_CTM_OrganizationalUnitID == Guid.Empty).ToList(); foreach (L5BL_GBPwAfBH_1848 unsortedBillPosition in unsortedBillPositions) { L6BL_GADfBSBR_1010bp tempBillPosition = new L6BL_GADfBSBR_1010bp(); tempBillPosition.BIL_BillPositionID = unsortedBillPosition.BillPosition.BIL_BillPositionID; tempBillPosition.BillPosition_ValuePerUnit_BeforeTax = (double)unsortedBillPosition.BillPosition.PositionPricePerUnitValue_BeforeTax; tempBillPosition.BillPosition_ValuePerUnit_AfterTax = (double)unsortedBillPosition.BillPosition.PositionPricePerUnitValue_IncludingTax; tempBillPosition.ACC_TAX_TaxeID = unsortedBillPosition.Article.Taxes.First().ACC_TAX_TaxeID; tempBillPosition.TaxRate = unsortedBillPosition.Article.Taxes.First().TaxRate; tempBillPosition.TaxName_DictID = unsortedBillPosition.Article.Taxes.First().TaxName_DictID; tempBillPosition.HeaderID = unsortedBillPosition.BillPosition.LOG_SHP_Shipment_HeaderID; tempBillPosition.Header_Number = unsortedBillPosition.BillPosition.ShipmentHeader_Number; tempBillPosition.Creation_Timestamp = unsortedBillPosition.BillPosition.LOG_SHP_ShipmentHeader_Creation_Timestamp; tempBillPosition.IsShipmentPosition = true; tempBillPosition.Quantity = unsortedBillPosition.BillPosition.Quantity; unsortedBillPositionsTemp.Add(tempBillPosition); } } // now for customer orders return if (allBillPositions.OrderReturnBillPosition != null) { var unsortedCustomerOrderReturnPositions = allBillPositions.OrderReturnBillPosition.Where(x => x.OrderReturnBillPosition.CMN_BPT_CTM_OrganizationalUnitID == Guid.Empty).OrderBy(x => x.OrderReturnBillPosition.DateOfCustomerReturn).ToList(); foreach (L5OR_GCORPwAfBH_1051 unsortedBillPosition in unsortedCustomerOrderReturnPositions) { L6BL_GADfBSBR_1010bp tempBillPosition = new L6BL_GADfBSBR_1010bp(); tempBillPosition.BIL_BillPositionID = unsortedBillPosition.OrderReturnBillPosition.BIL_BillPositionID; tempBillPosition.BillPosition_ValuePerUnit_BeforeTax = (double)unsortedBillPosition.OrderReturnBillPosition.PositionPricePerUnitValue_BeforeTax; tempBillPosition.BillPosition_ValuePerUnit_AfterTax = (double)unsortedBillPosition.OrderReturnBillPosition.PositionPricePerUnitValue_IncludingTax; tempBillPosition.ACC_TAX_TaxeID = unsortedBillPosition.Article.Taxes.First().ACC_TAX_TaxeID; tempBillPosition.TaxRate = unsortedBillPosition.Article.Taxes.First().TaxRate; tempBillPosition.TaxName_DictID = unsortedBillPosition.Article.Taxes.First().TaxName_DictID; tempBillPosition.HeaderID = unsortedBillPosition.OrderReturnBillPosition.ORD_CUO_CustomerOrderReturn_HeaderID; tempBillPosition.Header_Number = unsortedBillPosition.OrderReturnBillPosition.CustomerOrderReturnNumber; tempBillPosition.Creation_Timestamp = unsortedBillPosition.OrderReturnBillPosition.Creation_Timestamp; tempBillPosition.IsShipmentPosition = false; tempBillPosition.Quantity = unsortedBillPosition.OrderReturnBillPosition.Quantity; unsortedBillPositionsTemp.Add(tempBillPosition); } } returnValue.Result.BillPositions = unsortedBillPositionsTemp.ToArray(); #region bill position organisation unit returnValue.Result.OrganizationalUnits = null; List <L6BL_GADfBSBR_1010bo> organizationalUnitsTemp = new List <L6BL_GADfBSBR_1010bo>(); if (allBillPositions.ShipmentBillPositions != null) { List <L5BL_GBPwAfBH_1848> sortedBillPositions = allBillPositions.ShipmentBillPositions.Where(x => x.BillPosition.CMN_BPT_CTM_OrganizationalUnitID != Guid.Empty).ToList(); foreach (L5BL_GBPwAfBH_1848 sortedBillPosition in sortedBillPositions) { L6BL_GADfBSBR_1010bo tempOrganizationalUnit = organizationalUnitsTemp.FirstOrDefault(organizationalUnitTemp => organizationalUnitTemp.CMN_BPT_CTM_OrganizationalUnitID == sortedBillPosition.BillPosition.CMN_BPT_CTM_OrganizationalUnitID); if (tempOrganizationalUnit == null) { tempOrganizationalUnit = new L6BL_GADfBSBR_1010bo(); tempOrganizationalUnit.BillPositions = new L6BL_GADfBSBR_1010bp[0]; tempOrganizationalUnit.CMN_BPT_CTM_OrganizationalUnitID = sortedBillPosition.BillPosition.CMN_BPT_CTM_OrganizationalUnitID; tempOrganizationalUnit.OrganizationalUnit_SimpleName = sortedBillPosition.BillPosition.OrganizationalUnit_SimpleName; tempOrganizationalUnit.OrganizationalUnit_Name = sortedBillPosition.BillPosition.OrganizationalUnit_Name_DictID; tempOrganizationalUnit.OrganizationalUnit_Description = sortedBillPosition.BillPosition.OrganizationalUnit_Name_DictID; tempOrganizationalUnit.InternalOrganizationalUnitNumber = sortedBillPosition.BillPosition.InternalOrganizationalUnitNumber; tempOrganizationalUnit.InternalOrganizationalUnitSimpleName = sortedBillPosition.BillPosition.InternalOrganizationalUnitSimpleName; tempOrganizationalUnit.ExternalOrganizationalUnitNumber = sortedBillPosition.BillPosition.ExternalOrganizationalUnitNumber; organizationalUnitsTemp.Add(tempOrganizationalUnit); } L6BL_GADfBSBR_1010bp tempBillPosition = new L6BL_GADfBSBR_1010bp(); tempBillPosition.BIL_BillPositionID = sortedBillPosition.BillPosition.BIL_BillPositionID; tempBillPosition.BillPosition_ValuePerUnit_BeforeTax = (double)sortedBillPosition.BillPosition.PositionPricePerUnitValue_BeforeTax; tempBillPosition.BillPosition_ValuePerUnit_AfterTax = (double)sortedBillPosition.BillPosition.PositionPricePerUnitValue_IncludingTax; tempBillPosition.ACC_TAX_TaxeID = sortedBillPosition.Article.Taxes.First().ACC_TAX_TaxeID; tempBillPosition.TaxRate = sortedBillPosition.Article.Taxes.First().TaxRate; tempBillPosition.TaxName_DictID = sortedBillPosition.Article.Taxes.First().TaxName_DictID; tempBillPosition.HeaderID = sortedBillPosition.BillPosition.LOG_SHP_Shipment_HeaderID; tempBillPosition.Header_Number = sortedBillPosition.BillPosition.ShipmentHeader_Number; tempBillPosition.Creation_Timestamp = sortedBillPosition.BillPosition.LOG_SHP_ShipmentHeader_Creation_Timestamp; tempBillPosition.IsShipmentPosition = true; tempBillPosition.Quantity = sortedBillPosition.BillPosition.Quantity; //hate this List <L6BL_GADfBSBR_1010bp> currentBillPositions = tempOrganizationalUnit.BillPositions.ToList(); currentBillPositions.Add(tempBillPosition); tempOrganizationalUnit.BillPositions = currentBillPositions.ToArray(); } } // now for organization unit in customer order return if (allBillPositions.OrderReturnBillPosition != null) { List <L5OR_GCORPwAfBH_1051> sortedBillPositionsforCustomerOrderReturn = allBillPositions.OrderReturnBillPosition.Where(x => x.OrderReturnBillPosition.CMN_BPT_CTM_OrganizationalUnitID != Guid.Empty).OrderBy(x => x.OrderReturnBillPosition.DateOfCustomerReturn).ToList(); foreach (L5OR_GCORPwAfBH_1051 sortedBillPosition in sortedBillPositionsforCustomerOrderReturn) { L6BL_GADfBSBR_1010bo tempOrganizationalUnit = organizationalUnitsTemp.FirstOrDefault(organizationalUnitTemp => organizationalUnitTemp.CMN_BPT_CTM_OrganizationalUnitID == sortedBillPosition.OrderReturnBillPosition.CMN_BPT_CTM_OrganizationalUnitID); if (tempOrganizationalUnit == null) { tempOrganizationalUnit = new L6BL_GADfBSBR_1010bo(); tempOrganizationalUnit.BillPositions = new L6BL_GADfBSBR_1010bp[0]; tempOrganizationalUnit.CMN_BPT_CTM_OrganizationalUnitID = sortedBillPosition.OrderReturnBillPosition.CMN_BPT_CTM_OrganizationalUnitID; tempOrganizationalUnit.OrganizationalUnit_SimpleName = sortedBillPosition.OrderReturnBillPosition.OrganizationalUnit_SimpleName; tempOrganizationalUnit.OrganizationalUnit_Name = sortedBillPosition.OrderReturnBillPosition.OrganizationalUnit_Name_DictID; tempOrganizationalUnit.OrganizationalUnit_Description = sortedBillPosition.OrderReturnBillPosition.OrganizationalUnit_Name_DictID; tempOrganizationalUnit.InternalOrganizationalUnitNumber = sortedBillPosition.OrderReturnBillPosition.InternalOrganizationalUnitNumber; tempOrganizationalUnit.InternalOrganizationalUnitSimpleName = sortedBillPosition.OrderReturnBillPosition.InternalOrganizationalUnitSimpleName; tempOrganizationalUnit.ExternalOrganizationalUnitNumber = sortedBillPosition.OrderReturnBillPosition.ExternalOrganizationalUnitNumber; organizationalUnitsTemp.Add(tempOrganizationalUnit); } L6BL_GADfBSBR_1010bp tempBillPosition = new L6BL_GADfBSBR_1010bp(); tempBillPosition.BIL_BillPositionID = sortedBillPosition.OrderReturnBillPosition.BIL_BillPositionID; tempBillPosition.BillPosition_ValuePerUnit_BeforeTax = (double)sortedBillPosition.OrderReturnBillPosition.PositionPricePerUnitValue_BeforeTax; tempBillPosition.BillPosition_ValuePerUnit_AfterTax = (double)sortedBillPosition.OrderReturnBillPosition.PositionPricePerUnitValue_IncludingTax; tempBillPosition.ACC_TAX_TaxeID = sortedBillPosition.Article.Taxes.First().ACC_TAX_TaxeID; tempBillPosition.TaxRate = sortedBillPosition.Article.Taxes.First().TaxRate; tempBillPosition.TaxName_DictID = sortedBillPosition.Article.Taxes.First().TaxName_DictID; tempBillPosition.HeaderID = sortedBillPosition.OrderReturnBillPosition.ORD_CUO_CustomerOrderReturn_HeaderID; tempBillPosition.Header_Number = sortedBillPosition.OrderReturnBillPosition.CustomerOrderReturnNumber; tempBillPosition.Creation_Timestamp = sortedBillPosition.OrderReturnBillPosition.Creation_Timestamp; tempBillPosition.IsShipmentPosition = false; tempBillPosition.Quantity = sortedBillPosition.OrderReturnBillPosition.Quantity; //hate this List <L6BL_GADfBSBR_1010bp> currentBillPositions = tempOrganizationalUnit.BillPositions.ToList(); currentBillPositions.Add(tempBillPosition); tempOrganizationalUnit.BillPositions = currentBillPositions.ToArray(); } } returnValue.Result.OrganizationalUnits = organizationalUnitsTemp.ToArray(); #endregion #endregion return(returnValue); #endregion UserCode }