protected static FR_Guid Execute(DbConnection Connection, DbTransaction Transaction, P_L5BL_DBH_1332 Parameter, CSV2Core.SessionSecurity.SessionSecurityTicket securityTicket = null)
{
//Leave UserCode region to enable user code saving
#region UserCode
var returnValue = new FR_Guid();
#region Retreve Bill Header
var billHeader = new ORM_BIL_BillHeader();
billHeader.Load(Connection, Transaction, Parameter.BillHeaderID);
#endregion
returnValue.Result = billHeader.BIL_BillHeaderID;
#region Delete Bill Positions for Bill Header
// Retrieve bill positions for bill header.
var billPositions = ORM_BIL_BillPosition.Query.Search(Connection, Transaction,
new ORM_BIL_BillPosition.Query
{
BIL_BilHeader_RefID = billHeader.BIL_BillHeaderID,
Tenant_RefID = securityTicket.TenantID,
IsDeleted = false
});
foreach (var billPosition in billPositions)
{
// Delete relationship between BillPositions and CustomerOrderPositions in Assignment table.
var billPos2CusPoss = ORM_BIL_BillPosition_2_ShipmentPosition.Query.SoftDelete(Connection, Transaction,
new ORM_BIL_BillPosition_2_ShipmentPosition.Query
{
BIL_BillPosition_RefID = billPosition.BIL_BillPositionID,
Tenant_RefID = securityTicket.TenantID,
IsDeleted = false
});
CL1_BIL.ORM_BIL_BillPosition_2_CustomerOrderReturnPosition.Query.SoftDelete(Connection, Transaction,
new CL1_BIL.ORM_BIL_BillPosition_2_CustomerOrderReturnPosition.Query
{
BIL_BillPosition_RefID = billPosition.BIL_BillPositionID,
Tenant_RefID = securityTicket.TenantID,
IsDeleted = false
});
billPosition.IsDeleted = true;
billPosition.Save(Connection, Transaction);
}
#endregion
#region Delete Bill Header's statuses
// Delete all statuses for Bill header
var billHeader2Statuses = ORM_BIL_BillHeader_2_BillStatus.Query.SoftDelete(Connection, Transaction,
new ORM_BIL_BillHeader_2_BillStatus.Query
{
BIL_BillHeader_RefID = billHeader.BIL_BillHeaderID,
Tenant_RefID = securityTicket.TenantID,
IsDeleted = false
});
#endregion
#region Delete Bill Header
billHeader.IsDeleted = true;
billHeader.Save(Connection, Transaction);
#endregion
return(returnValue);
#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
}
protected static FR_Guids Execute(DbConnection Connection, DbTransaction Transaction, P_L5BD_SCDP_1347 Parameter, CSV2Core.SessionSecurity.SessionSecurityTicket securityTicket = null)
{
#region UserCode
var returnValue = new FR_Guids();
//Put your code here
var savedProcesses = new List <Guid>();
foreach (var billHeaderID in Parameter.BIL_BillHeaderIDs.ToList())
{
#region Prerequisites
var billHeader = new ORM_BIL_BillHeader();
billHeader.Load(Connection, Transaction, billHeaderID);
//assigned payments
var assignedPaymentsQuery = new ORM_BIL_BillHeader_AssignedPayment.Query();
assignedPaymentsQuery.BIL_BillHeader_RefID = billHeader.BIL_BillHeaderID;
assignedPaymentsQuery.Tenant_RefID = securityTicket.TenantID;
var foundAssignmentPayments = ORM_BIL_BillHeader_AssignedPayment.Query.Search(Connection, Transaction, assignedPaymentsQuery);
//calculated sum of payments to the present day
var paymentsSummForCurrentDate = foundAssignmentPayments.Where(fap => fap.Creation_Timestamp <= DateTime.Now).Sum(x => x.AssignedValue);
//customer
var customerQuery = new ORM_CMN_BPT_CTM_Customer.Query();
customerQuery.Tenant_RefID = securityTicket.TenantID;
customerQuery.Ext_BusinessParticipant_RefID = billHeader.BillRecipient_BuisnessParticipant_RefID;
var foundCustomer = ORM_CMN_BPT_CTM_Customer.Query.Search(Connection, Transaction, customerQuery).Single();
//Model
ORM_ACC_DUN_Dunning_Model.Query defaultDunningModelQuery = new ORM_ACC_DUN_Dunning_Model.Query();
defaultDunningModelQuery.Tenant_RefID = securityTicket.TenantID;
defaultDunningModelQuery.IsDefaultCustomerModel = true;
var foundDunningModel = ORM_ACC_DUN_Dunning_Model.Query.Search(Connection, Transaction, defaultDunningModelQuery).SingleOrDefault();
//Assignment to levels
var modelToLevelsAssignmentQuery = new ORM_ACC_DUN_DunningLevel_ModelAssignment.Query();
modelToLevelsAssignmentQuery.Dunning_Model_RefID = foundDunningModel.ACC_DUN_Dunning_ModelID;
modelToLevelsAssignmentQuery.Tenant_RefID = securityTicket.TenantID;
var foundModelToLevelsAssignments = ORM_ACC_DUN_DunningLevel_ModelAssignment.Query.Search(Connection, Transaction, modelToLevelsAssignmentQuery);
var minimalLevelInSequence = foundModelToLevelsAssignments.OrderBy(la => la.OrderSequence).First();
//Levels
var dunningLevels = new ORM_ACC_DUN_Dunning_Level();
//dunningLevels.Load(Connection, Transaction, foundModelToLevelsAssignment.Dunning_Level_RefID);
#endregion
//model to customer assignment
var modelToCustomerAssignment = new ORM_ACC_DUN_Dunning_Model_2_Customer();
modelToCustomerAssignment.Tenant_RefID = securityTicket.TenantID;
modelToCustomerAssignment.ACC_DUN_DunningModel_RefID = foundDunningModel.ACC_DUN_Dunning_ModelID;
modelToCustomerAssignment.CMN_BPT_CTM_Customer_RefID = foundCustomer.CMN_BPT_CTM_CustomerID;
var savedModelToCustomerAssignmentID = new FR_Guid(modelToCustomerAssignment.Save(Connection, Transaction), modelToCustomerAssignment.AssignmentID);
//dunning process
P_L2BD_SADDP_1412 saveDunningProcessParameter = new P_L2BD_SADDP_1412();
saveDunningProcessParameter.DunnedCustomer_RefID = foundCustomer.CMN_BPT_CTM_CustomerID;
saveDunningProcessParameter.DunningModel_RefID = foundDunningModel.ACC_DUN_Dunning_ModelID;
saveDunningProcessParameter.Current_DunningLevel_RefID = minimalLevelInSequence.Dunning_Level_RefID;
saveDunningProcessParameter.DunnedAmount_Total = billHeader.TotalValue_BeforeTax - paymentsSummForCurrentDate;
saveDunningProcessParameter.Currency_RefID = billHeader.Currency_RefID;
saveDunningProcessParameter.ReachesNextDunningLevelAtDate = DateTime.Now.AddDays(minimalLevelInSequence.WaitPeriodToNextDunningLevel_In_Days);
var savedDunningProcessID = cls_Save_ACC_DUN_DunningProcess.Invoke(Connection, Transaction, saveDunningProcessParameter, securityTicket).Result;
//dunning process member bills
P_L2BD_SADDPMB_1359 saveMemberBillsParameter = new P_L2BD_SADDPMB_1359();
saveMemberBillsParameter.BIL_BillHeader_RefID = billHeaderID;
saveMemberBillsParameter.ACC_DUN_DunningProcess_RefID = savedDunningProcessID;
saveMemberBillsParameter.ApplicableProcessDunningFees = 0;
saveMemberBillsParameter.CurrentUnpaidBillFraction = 0;
var savedMemberBillID = cls_Save_ACC_DUN_DunningProcess_MemberBill.Invoke(Connection, Transaction, saveMemberBillsParameter, securityTicket).Result;
savedProcesses.Add(savedMemberBillID);
//dunning process history
var dunningProcessHistory = new ORM_ACC_DUN_DunningProcess_History();
dunningProcessHistory.ACC_DUN_Dunning_Level_RefID = minimalLevelInSequence.Dunning_Level_RefID;
dunningProcessHistory.ACC_DUN_DunningProcess_RefID = savedDunningProcessID;
dunningProcessHistory.Creation_Timestamp = DateTime.Now;
dunningProcessHistory.DunningProcessFee_IncludingThisDunningLevel = 0;
dunningProcessHistory.IsCurrentStep = true;
dunningProcessHistory.Tenant_RefID = securityTicket.TenantID;
var savedDunningProcessHistoryID = new FR_Guid(dunningProcessHistory.Save(Connection, Transaction), dunningProcessHistory.ACC_DUN_DunningProcess_HistoryID);
}
returnValue.Result = savedProcesses.ToArray();
return(returnValue);
#endregion UserCode
}
protected static FR_L5BC_GBPwCDfBH_1607 Execute(DbConnection Connection, DbTransaction Transaction, P_L5BC_GBPwCDfBH_1607 Parameter, CSV2Core.SessionSecurity.SessionSecurityTicket securityTicket = null)
{
#region UserCode
var returnValue = new FR_L5BC_GBPwCDfBH_1607();
var result = new L5BC_GBPwCDfBH_1607();
#region Get Bill Header
var billHeader = new ORM_BIL_BillHeader();
if (billHeader.Load(Connection, Transaction, Parameter.BillHeaderId).Status != FR_Status.Success)
{
returnValue.Status = FR_Status.Error_Internal;
returnValue.Result = null;
return(returnValue);
}
#endregion
#region Get Bill Recipiant BusinessParticipant
var billRecipiant = new ORM_CMN_BPT_BusinessParticipant();
if (billRecipiant.Load(Connection, Transaction, billHeader.BillRecipient_BuisnessParticipant_RefID).Status != FR_Status.Success)
{
returnValue.Result = null;
returnValue.Status = FR_Status.Error_Internal;
return(returnValue);
}
#endregion
#region Get Bill Positions
var resultBillPositions = cls_Get_BillPositions_with_Articles_for_BillHeader.Invoke(
Connection,
Transaction,
new P_L5BL_GBPwAfBH_1848()
{
BillHeaderID = Parameter.BillHeaderId
},
securityTicket);
if (resultBillPositions.Status != FR_Status.Success || resultBillPositions.Result == null || resultBillPositions.Result.Count() <= 0)
{
returnValue.Status = FR_Status.Error_Internal;
returnValue.Result = null;
return(returnValue);
}
#endregion
#region Get Order Header (Shipment and CustomerOrderReturn)
var resultOrderHeader = cls_Get_Shipment_and_CustomerOrderReturn_Header_for_BillPositionIDs.Invoke(
Connection,
Transaction,
new P_L5BC_GSaCORHfCP_1109()
{
BillPositionIDs = resultBillPositions.Result.Select(bp => bp.BillPosition.BIL_BillPositionID).ToArray()
},
securityTicket);
if (resultOrderHeader.Status != FR_Status.Success || resultOrderHeader.Result == null)
{
returnValue.Result = null;
returnValue.Status = FR_Status.Error_Internal;
return(returnValue);
}
#endregion
#region Get Bill Credit data
var resultBillCredits = cls_Get_BillReimbursement_and_GrantedCreditNotes_for_BillPositionIDs.Invoke(
Connection,
Transaction,
new P_L5BC_GBRaGCNfBP_1331()
{
BillPositionIDs = resultBillPositions.Result.Select(bp => bp.BillPosition.BIL_BillPositionID).ToArray()
},
securityTicket);
if (resultBillCredits.Status != FR_Status.Success)
{
returnValue.Result = null;
returnValue.Status = FR_Status.Error_Internal;
return(returnValue);
}
#endregion
#region Set result
var creditingBills = new List <L5BC_GBPwCDfBH_1607a>();
foreach (var billPosition in resultBillPositions.Result)
{
var orderHeader = resultOrderHeader.Result
.Where(coh => coh.BIL_BillPositionID == billPosition.BillPosition.BIL_BillPositionID).FirstOrDefault();
if (orderHeader == null)
{
returnValue.Result = null;
returnValue.Status = FR_Status.Error_Internal;
return(returnValue);
}
var billCredits = resultBillCredits.Result
.Where(bc => bc.BIL_BillPosition_RefID == billPosition.BillPosition.BIL_BillPositionID).FirstOrDefault();
var creditingBill = new L5BC_GBPwCDfBH_1607a()
{
BillPosition = billPosition.BillPosition,
Article = billPosition.Article,
BillCredits = billCredits ?? new L5BC_GBRaGCNfBP_1331(),
CustomerOrderHeaderNumber
= orderHeader.LOG_SHP_Shipment_HeaderID == Guid.Empty || orderHeader.LOG_SHP_Shipment_HeaderID == null || string.IsNullOrEmpty(orderHeader.ShipmentHeader_Number)
? orderHeader.CustomerOrderReturnNumber
: orderHeader.ShipmentHeader_Number
};
creditingBills.Add(creditingBill);
}
result.CreditingBills = creditingBills.ToArray();
result.BillHeaderNumber = billHeader.BillNumber;
result.BillHeaderBillRecipiantName = billRecipiant.DisplayName;
result.BillHeaderDateOnBill = billHeader.DateOnBill;
result.BillHeaderCurencyID = billHeader.Currency_RefID;
returnValue.Status = FR_Status.Success;
returnValue.Result = result;
#endregion
return(returnValue);
#endregion UserCode
}
