protected static FR_L3TX_GTOFTO_1006 Execute(DbConnection Connection, DbTransaction Transaction, P_L3TX_GTOFTO_1006 Parameter, CSV2Core.SessionSecurity.SessionSecurityTicket securityTicket = null)
{
#region UserCode
var returnValue = new FR_L3TX_GTOFTO_1006();
returnValue.Result = new L3TX_GTOFTO_1006();
var item = new ORM_ACC_TAX_TaxOffice();
returnValue.Result.TaxOffice = new L3TX_GTOFT_0914();
var result = item.Load(Connection, Transaction, Parameter.ACC_TAX_TaxOfficeID);
ORM_CMN_BPT_BusinessParticipant bparticipant = new ORM_CMN_BPT_BusinessParticipant();
bparticipant.Load(Connection, Transaction, item.CMN_BPT_BusinessParticipant_RefID);
returnValue.Result.TaxOffice.DisplayName = bparticipant.DisplayName;
ORM_CMN_COM_CompanyInfo companyInfo = new ORM_CMN_COM_CompanyInfo();
companyInfo.Load(Connection, Transaction, bparticipant.IfCompany_CMN_COM_CompanyInfo_RefID);
ORM_CMN_UniversalContactDetail ucd = new ORM_CMN_UniversalContactDetail();
ucd.Load(Connection, Transaction, companyInfo.Contact_UCD_RefID);
returnValue.Result.TaxOffice.VATIdentificationNumber = companyInfo.VATIdentificationNumber;
returnValue.Result.TaxOffice.ACC_TAX_TaxOfficeID = item.ACC_TAX_TaxOfficeID;
returnValue.Result.TaxOffice.Country_639_1_ISOCode = ucd.Country_639_1_ISOCode;
//Put your code here
return(returnValue);
#endregion UserCode
}
protected static FR_L5HI_GHIFHIID_1329 Execute(DbConnection Connection, DbTransaction Transaction, P_L5HI_GHIFHIID_1329 Parameter, CSV2Core.SessionSecurity.SessionSecurityTicket securityTicket = null)
{
#region UserCode
var returnValue = new FR_L5HI_GHIFHIID_1329();
//Put your code here
returnValue.Result = new L5HI_GHIFHIID_1329();
ORM_HEC_HIS_HealthInsurance_Company.Query healthInsurenceQuery = new ORM_HEC_HIS_HealthInsurance_Company.Query();
healthInsurenceQuery.HEC_HealthInsurance_CompanyID = Parameter.HEC_HealthInsurance_CompanyID;
healthInsurenceQuery.Tenant_RefID = securityTicket.TenantID;
healthInsurenceQuery.IsDeleted = false;
List <ORM_HEC_HIS_HealthInsurance_Company> healthInsurances = ORM_HEC_HIS_HealthInsurance_Company.Query.Search(Connection, Transaction, healthInsurenceQuery);
if (healthInsurances.Count == 0)
{
return(null);
}
else
{
ORM_CMN_BPT_BusinessParticipant bpart = ORM_CMN_BPT_BusinessParticipant.Query.Search(Connection, Transaction, new ORM_CMN_BPT_BusinessParticipant.Query
{
CMN_BPT_BusinessParticipantID = healthInsurances[0].CMN_BPT_BusinessParticipant_RefID,
Tenant_RefID = securityTicket.TenantID,
IsDeleted = false
}).FirstOrDefault();
ORM_CMN_COM_CompanyInfo companyInfo = new ORM_CMN_COM_CompanyInfo();
companyInfo.Load(Connection, Transaction, bpart.IfCompany_CMN_COM_CompanyInfo_RefID);
ORM_CMN_UniversalContactDetail ucd = new ORM_CMN_UniversalContactDetail();
ucd.Load(Connection, Transaction, companyInfo.Contact_UCD_RefID);
L5HI_GHIFT_1138 healthInsurance = new L5HI_GHIFT_1138();
healthInsurance.HEC_HealthInsurance_CompanyID = healthInsurances[0].HEC_HealthInsurance_CompanyID;
healthInsurance.DisplayName = bpart.DisplayName;
healthInsurance.HealthInsurance_IKNumber = healthInsurances[0].HealthInsurance_IKNumber;
healthInsurance.Country_ISO = ucd.Country_639_1_ISOCode;
healthInsurance.Town = ucd.Town;
returnValue.Result.HealthInsurance = healthInsurance;
}
return(returnValue);
#endregion UserCode
}
protected static FR_L5HI_GHIFT_1138_Array Execute(DbConnection Connection, DbTransaction Transaction, CSV2Core.SessionSecurity.SessionSecurityTicket securityTicket = null)
{
//Leave UserCode region to enable user code saving
#region UserCode
var returnValue = new FR_L5HI_GHIFT_1138_Array();
List <L5HI_GHIFT_1138> healthInsuranceResult = new List <L5HI_GHIFT_1138>();
ORM_HEC_HIS_HealthInsurance_Company.Query healthInsurenceQuery = new ORM_HEC_HIS_HealthInsurance_Company.Query();
healthInsurenceQuery.Tenant_RefID = securityTicket.TenantID;
healthInsurenceQuery.IsDeleted = false;
List <ORM_HEC_HIS_HealthInsurance_Company> healthInsurances = ORM_HEC_HIS_HealthInsurance_Company.Query.Search(Connection, Transaction, healthInsurenceQuery);
foreach (var healthInsurance in healthInsurances)
{
if (healthInsurance.CMN_BPT_BusinessParticipant_RefID == Guid.Empty)
{
continue;
}
L5HI_GHIFT_1138 item = new L5HI_GHIFT_1138();
ORM_CMN_BPT_BusinessParticipant bpart = ORM_CMN_BPT_BusinessParticipant.Query.Search(Connection, Transaction, new ORM_CMN_BPT_BusinessParticipant.Query
{
CMN_BPT_BusinessParticipantID = healthInsurance.CMN_BPT_BusinessParticipant_RefID,
Tenant_RefID = securityTicket.TenantID,
IsDeleted = false
}).FirstOrDefault();
ORM_CMN_COM_CompanyInfo companyInfo = new ORM_CMN_COM_CompanyInfo();
companyInfo.Load(Connection, Transaction, bpart.IfCompany_CMN_COM_CompanyInfo_RefID);
ORM_CMN_UniversalContactDetail ucd = new ORM_CMN_UniversalContactDetail();
ucd.Load(Connection, Transaction, companyInfo.Contact_UCD_RefID);
item.HEC_HealthInsurance_CompanyID = healthInsurance.HEC_HealthInsurance_CompanyID;
item.DisplayName = bpart.DisplayName;
item.HealthInsurance_IKNumber = healthInsurance.HealthInsurance_IKNumber;
item.Country_ISO = ucd.Country_639_1_ISOCode;
item.Town = ucd.Town;
healthInsuranceResult.Add(item);
}
returnValue.Result = healthInsuranceResult.ToArray();
//Put your code here
return(returnValue);
#endregion UserCode
}
protected static FR_Guid Execute(DbConnection Connection, DbTransaction Transaction, P_L5ACAAD_SOUA_1239 Parameter, CSV2Core.SessionSecurity.SessionSecurityTicket securityTicket = null)
{
#region UserCode
var returnValue = new FR_Guid();
//Put your code here
var address = new ORM_CMN_BPT_CTM_OrganizationalUnit_Address();
var universalcontactdetails = new ORM_CMN_UniversalContactDetail();
if (Parameter.IsDelete)
{
var resultAddress = address.Load(Connection, Transaction, Parameter.CMN_AddressID);
if (address.CMN_BPT_CTM_OrganizationalUnit_AddressID != Guid.Empty)
{
address.IsDeleted = true;
address.Save(Connection, Transaction);
}
var resultOrgUnit = universalcontactdetails.Load(Connection, Transaction, Parameter.UniversalContactDetailsID);
if (universalcontactdetails.CMN_UniversalContactDetailID != Guid.Empty)
{
universalcontactdetails.IsDeleted = true;
universalcontactdetails.Save(Connection, Transaction);
}
}
else
{
if (Parameter.CMN_AddressID != Guid.Empty && Parameter.UniversalContactDetailsID != Guid.Empty)
{
var resultAddress = address.Load(Connection, Transaction, Parameter.CMN_AddressID);
var resultOrgUnit = universalcontactdetails.Load(Connection, Transaction, Parameter.UniversalContactDetailsID);
}
else
{
universalcontactdetails.CMN_UniversalContactDetailID = Guid.NewGuid();
universalcontactdetails.Tenant_RefID = securityTicket.TenantID;
universalcontactdetails.Creation_Timestamp = DateTime.Now;
universalcontactdetails.IsDeleted = false;
address.CMN_BPT_CTM_OrganizationalUnit_AddressID = Guid.NewGuid();
address.OrganizationalUnit_RefID = Parameter.OrganizationalUnitID;
address.UniversalContactDetail_Address_RefID = universalcontactdetails.CMN_UniversalContactDetailID;
address.Tenant_RefID = securityTicket.TenantID;
address.Creation_Timestamp = DateTime.Now;
address.IsDeleted = false;
}
universalcontactdetails.Country_639_1_ISOCode = Parameter.Country_ISOCode;
universalcontactdetails.Country_Name = Parameter.Country_Name;
universalcontactdetails.Street_Name = Parameter.StreetName;
universalcontactdetails.Street_Number = Parameter.StreetNumber;
universalcontactdetails.Town = Parameter.Town;
universalcontactdetails.ZIP = Parameter.City_PostalCode;
universalcontactdetails.IsReadOnly = Parameter.IsReadOnly;
universalcontactdetails.Save(Connection, Transaction);
address.AddressType = Parameter.IsBilling ? 2 : 1;
address.IsPrimary = Parameter.IsPrimary;
address.Save(Connection, Transaction);
}
returnValue = new FR_Guid(address.CMN_BPT_CTM_OrganizationalUnit_AddressID);
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_Guid Execute(DbConnection Connection, DbTransaction Transaction, P_L5HI_SHI_1158 Parameter, CSV2Core.SessionSecurity.SessionSecurityTicket securityTicket = null)
{
#region UserCode
var returnValue = new FR_Guid();
FR_Base result = new FR_Base();
//Put your code here
var item = new ORM_HEC_HIS_HealthInsurance_Company();
if (Parameter.HEC_HealthInsurance_CompanyID != Guid.Empty)
{
result = item.Load(Connection, Transaction, Parameter.HEC_HealthInsurance_CompanyID);
if (result.Status != FR_Status.Success || item.HEC_HealthInsurance_CompanyID == Guid.Empty)
{
var error = new FR_Guid();
error.ErrorMessage = "No Such ID";
error.Status = FR_Status.Error_Internal;
return(error);
}
}
item.HealthInsurance_IKNumber = Parameter.HealthInsurance_IKNumber;
item.Tenant_RefID = securityTicket.TenantID;
ORM_CMN_BPT_BusinessParticipant bpart = ORM_CMN_BPT_BusinessParticipant.Query.Search(Connection, Transaction, new ORM_CMN_BPT_BusinessParticipant.Query
{
CMN_BPT_BusinessParticipantID = item.CMN_BPT_BusinessParticipant_RefID,
Tenant_RefID = securityTicket.TenantID,
IsDeleted = false
}).FirstOrDefault();
if (bpart == null || bpart.CMN_BPT_BusinessParticipantID == Guid.Empty)
{
bpart = new ORM_CMN_BPT_BusinessParticipant();
}
bpart.DisplayName = Parameter.CompanyName;
bpart.Tenant_RefID = securityTicket.TenantID;
item.CMN_BPT_BusinessParticipant_RefID = bpart.CMN_BPT_BusinessParticipantID;
ORM_CMN_COM_CompanyInfo companyInfo = new ORM_CMN_COM_CompanyInfo();
result = companyInfo.Load(Connection, Transaction, bpart.IfCompany_CMN_COM_CompanyInfo_RefID);
if (result.Status != FR_Status.Success || companyInfo.CMN_COM_CompanyInfoID == Guid.Empty)
{
companyInfo = new ORM_CMN_COM_CompanyInfo();
}
bpart.IfCompany_CMN_COM_CompanyInfo_RefID = companyInfo.CMN_COM_CompanyInfoID;
bpart.Save(Connection, Transaction);
ORM_CMN_UniversalContactDetail ucd = new ORM_CMN_UniversalContactDetail();
result = ucd.Load(Connection, Transaction, companyInfo.Contact_UCD_RefID);
if (result.Status != FR_Status.Success || ucd.CMN_UniversalContactDetailID == Guid.Empty)
{
ucd = new ORM_CMN_UniversalContactDetail();
}
companyInfo.Tenant_RefID = securityTicket.TenantID;
companyInfo.Contact_UCD_RefID = ucd.CMN_UniversalContactDetailID;
companyInfo.Save(Connection, Transaction);
returnValue.Result = item.HEC_HealthInsurance_CompanyID;
if (Parameter.Country_ISO != "")
{
ucd.Country_639_1_ISOCode = Parameter.Country_ISO;
ucd.Town = Parameter.Town;
ucd.Tenant_RefID = securityTicket.TenantID;
}
ucd.Save(Connection, Transaction);
item.Save(Connection, Transaction);
return(returnValue);
#endregion UserCode
}
protected static FR_Guid Execute(DbConnection Connection, DbTransaction Transaction, P_L5CA_SCS_1333 Parameter, CSV2Core.SessionSecurity.SessionSecurityTicket securityTicket = null)
{
#region UserCode
var returnValue = new FR_Guid();
//Put your code here
var adress = new ORM_CMN_UniversalContactDetail();
var company2Adress = new ORM_CMN_COM_CompanyInfo_Address();
if (Parameter.CMN_AddressID != Guid.Empty)
{
var result = adress.Load(Connection, Transaction, Parameter.CMN_AddressID);
if (result.Status != FR_Status.Success || adress.CMN_UniversalContactDetailID == Guid.Empty)
{
var error = new FR_Guid();
error.ErrorMessage = "No Such ID";
error.Status = FR_Status.Error_Internal;
return(error);
}
company2Adress.Address_UCD_RefID = Parameter.CMN_AddressID;
}
if (Parameter.CMN_COM_CompanyInfo_AddressID != Guid.Empty)
{
var result = company2Adress.Load(Connection, Transaction, Parameter.CMN_COM_CompanyInfo_AddressID);
if (result.Status != FR_Status.Success || company2Adress.CMN_COM_CompanyInfo_AddressID == Guid.Empty)
{
var error = new FR_Guid();
error.ErrorMessage = "No Such ID";
error.Status = FR_Status.Error_Internal;
return(error);
}
}
if (Parameter.IsDeleted == true)
{
adress.IsDeleted = true;
company2Adress.IsDeleted = true;
company2Adress.Save(Connection, Transaction);
return(new FR_Guid(adress.Save(Connection, Transaction), adress.CMN_UniversalContactDetailID));
}
//Creation specific parameters (Tenant, Account ... )
if (Parameter.CMN_AddressID == Guid.Empty)
{
company2Adress.Address_UCD_RefID = adress.CMN_UniversalContactDetailID;
company2Adress.Tenant_RefID = securityTicket.TenantID;
adress.Tenant_RefID = securityTicket.TenantID;
}
adress.Street_Name = Parameter.Street_Name;
adress.Street_Number = Parameter.Street_Number;
adress.Town = Parameter.City_Name;
adress.ZIP = Parameter.City_PostalCode;
adress.Country_Name = Parameter.Country_Name;
adress.Region_Code = Parameter.Country_ISOCode;
company2Adress.IsDefault = Parameter.IsDefault;
company2Adress.Address_Description = Parameter.AddressName;
company2Adress.CompanyInfo_RefID = Parameter.CompanyInfo_RefID;
company2Adress.IsBilling = Parameter.IsAddress_Billing;
company2Adress.IsShipping = Parameter.IsAddress_Shipping;
company2Adress.Save(Connection, Transaction);
return(new FR_Guid(adress.Save(Connection, Transaction), adress.CMN_UniversalContactDetailID));
#endregion UserCode
}
protected static FR_Guid Execute(DbConnection Connection, DbTransaction Transaction, P_L3MP_DPBID_1026 Parameter, CSV2Core.SessionSecurity.SessionSecurityTicket securityTicket = null)
{
//Leave UserCode region to enable user code saving
#region UserCode
var returnValue = new FR_Guid();
P_L3MP_GPfID_1222 param = new P_L3MP_GPfID_1222();
param.HEC_MedicalPractiseID = Parameter.HEC_MedicalPractiseID;
var practice = cls_Get_Practice_For_ID.Invoke(Connection, Transaction, param, securityTicket).Result;
if (practice != null)
{
ORM_CMN_UniversalContactDetail contactDetails = new ORM_CMN_UniversalContactDetail();
if (practice.BaseInfo.CMN_UniversalContactDetailID != Guid.Empty)
{
var result = contactDetails.Load(Connection, Transaction, practice.BaseInfo.CMN_UniversalContactDetailID);
if (result.Status != FR_Status.Success || contactDetails.CMN_UniversalContactDetailID == Guid.Empty)
{
var error = new FR_Guid();
error.ErrorMessage = "No Such ID";
error.Status = FR_Status.Error_Internal;
return(error);
}
contactDetails.IsDeleted = true;
contactDetails.Save(Connection, Transaction);
}
ORM_CMN_COM_CompanyInfo info = new ORM_CMN_COM_CompanyInfo();
if (practice.BaseInfo.CMN_COM_CompanyInfoID != Guid.Empty)
{
var result = info.Load(Connection, Transaction, practice.BaseInfo.CMN_COM_CompanyInfoID);
if (result.Status != FR_Status.Success || info.CMN_COM_CompanyInfoID == Guid.Empty)
{
var error = new FR_Guid();
error.ErrorMessage = "No Such ID";
error.Status = FR_Status.Error_Internal;
return(error);
}
info.IsDeleted = true;
info.Save(Connection, Transaction);
}
ORM_CMN_BPT_BusinessParticipant bParticipant = new ORM_CMN_BPT_BusinessParticipant();
if (practice.BaseInfo.CMN_BPT_BusinessParticipantID != Guid.Empty)
{
var result = bParticipant.Load(Connection, Transaction, practice.BaseInfo.CMN_BPT_BusinessParticipantID);
if (result.Status != FR_Status.Success || bParticipant.CMN_BPT_BusinessParticipantID == Guid.Empty)
{
var error = new FR_Guid();
error.ErrorMessage = "No Such ID";
error.Status = FR_Status.Error_Internal;
return(error);
}
bParticipant.IsDeleted = true;
bParticipant.Save(Connection, Transaction);
}
ORM_HEC_MedicalPractis practis = new ORM_HEC_MedicalPractis();
if (practice.BaseInfo.HEC_MedicalPractiseID != Guid.Empty)
{
var result = practis.Load(Connection, Transaction, practice.BaseInfo.HEC_MedicalPractiseID);
if (result.Status != FR_Status.Success || practis.HEC_MedicalPractiseID == Guid.Empty)
{
var error = new FR_Guid();
error.ErrorMessage = "No Such ID";
error.Status = FR_Status.Error_Internal;
return(error);
}
practis.IsDeleted = true;
practis.Save(Connection, Transaction);
}
if (practice.BaseInfo.WeeklyOfficeHours_Template_RefID != Guid.Empty)
{
ORM_CMN_CAL_WeeklyOfficeHours_Template consultationHours = new ORM_CMN_CAL_WeeklyOfficeHours_Template();
if (practice.BaseInfo.WeeklyOfficeHours_Template_RefID != Guid.Empty)
{
var result = consultationHours.Load(Connection, Transaction, practice.BaseInfo.WeeklyOfficeHours_Template_RefID);
if (result.Status != FR_Status.Success || consultationHours.CMN_CAL_WeeklyOfficeHours_TemplateID == Guid.Empty)
{
var error = new FR_Guid();
error.ErrorMessage = "No Such ID";
error.Status = FR_Status.Error_Internal;
return(error);
}
consultationHours.IsDeleted = true;
consultationHours.Save(Connection, Transaction);
}
}
if (practice.BaseInfo.WeeklySurgeryHours_Template_RefID != Guid.Empty)
{
ORM_CMN_CAL_WeeklyOfficeHours_Template consultationHours = new ORM_CMN_CAL_WeeklyOfficeHours_Template();
if (practice.BaseInfo.WeeklyOfficeHours_Template_RefID != Guid.Empty)
{
var result = consultationHours.Load(Connection, Transaction, practice.BaseInfo.WeeklySurgeryHours_Template_RefID);
if (result.Status != FR_Status.Success || consultationHours.CMN_CAL_WeeklyOfficeHours_TemplateID == Guid.Empty)
{
var error = new FR_Guid();
error.ErrorMessage = "No Such ID";
error.Status = FR_Status.Error_Internal;
return(error);
}
consultationHours.IsDeleted = true;
consultationHours.Save(Connection, Transaction);
}
}
if (practice.ShippingAddress != null)
{
ORM_CMN_UniversalContactDetail shippingDetails = new ORM_CMN_UniversalContactDetail();
if (practice.ShippingAddress.CMN_UniversalContactDetailID != Guid.Empty)
{
var result = shippingDetails.Load(Connection, Transaction, practice.ShippingAddress.CMN_UniversalContactDetailID);
if (result.Status != FR_Status.Success || contactDetails.CMN_UniversalContactDetailID == Guid.Empty)
{
var error = new FR_Guid();
error.ErrorMessage = "No Such ID";
error.Status = FR_Status.Error_Internal;
return(error);
}
shippingDetails.IsDeleted = true;
shippingDetails.Save(Connection, Transaction);
}
ORM_CMN_COM_CompanyInfo_Address shippingAddress = new ORM_CMN_COM_CompanyInfo_Address();
if (practice.ShippingAddress.CMN_COM_CompanyInfo_AddressID != Guid.Empty)
{
var result = shippingAddress.Load(Connection, Transaction, practice.ShippingAddress.CMN_COM_CompanyInfo_AddressID);
if (result.Status != FR_Status.Success || shippingAddress.CMN_COM_CompanyInfo_AddressID == Guid.Empty)
{
var error = new FR_Guid();
error.ErrorMessage = "No Such ID";
error.Status = FR_Status.Error_Internal;
return(error);
}
shippingAddress.IsDeleted = true;
shippingAddress.Save(Connection, Transaction);
}
}
var associatedBussinessParticipantsQuery = new ORM_CMN_BPT_BusinessParticipant_AssociatedBusinessParticipant.Query();
associatedBussinessParticipantsQuery.AssociatedBusinessParticipant_RefID = bParticipant.CMN_BPT_BusinessParticipantID;
associatedBussinessParticipantsQuery.IsDeleted = false;
var associatedBussinessParticipants = ORM_CMN_BPT_BusinessParticipant_AssociatedBusinessParticipant.Query.Search(Connection, Transaction, associatedBussinessParticipantsQuery);
if (associatedBussinessParticipants.Count != 0)
{
foreach (var assBussiness in associatedBussinessParticipants)
{
assBussiness.IsDeleted = true;
assBussiness.Save(Connection, Transaction);
//brisanje doktora ako je imao jednu praksu
//var d2pAssignmentQuery = new ORM_CMN_BPT_BusinessParticipant_AssociatedBusinessParticipant.Query();
//d2pAssignmentQuery.IsDeleted = false;
//d2pAssignmentQuery.BusinessParticipant_RefID = assBussiness.BusinessParticipant_RefID;
//var d2pAssignmentRes = ORM_CMN_BPT_BusinessParticipant_AssociatedBusinessParticipant.Query.Search(Connection, Transaction, d2pAssignmentQuery).ToArray();
//if (d2pAssignmentRes.Length == 0)
//{
// var docQuery = new ORM_HEC_Doctor.Query();
// docQuery.BusinessParticipant_RefID = assBussiness.BusinessParticipant_RefID;
// var doctor = ORM_HEC_Doctor.Query.Search(Connection, Transaction, docQuery).First();
// P_L3MD_DDbID_1031 delDoc = new P_L3MD_DDbID_1031();
// delDoc.DoctorID = doctor.HEC_DoctorID;
// var delRes = cls_Delete_Doctor_byID.Invoke(Connection, Transaction, delDoc, securityTicket).Result;
//}
}
}
if (practice.OtherOphthal_PracticeData != null)
{
ORM_HEC_PublicHealthcare_PhysitianAssociation association = new ORM_HEC_PublicHealthcare_PhysitianAssociation();
if (practice.OtherOphthal_PracticeData.HEC_PublicHealthcare_PhysitianAssociationID != Guid.Empty)
{
var result = association.Load(Connection, Transaction, practice.OtherOphthal_PracticeData.HEC_PublicHealthcare_PhysitianAssociationID);
if (result.Status != FR_Status.Success || association.HEC_PublicHealthcare_PhysitianAssociationID == Guid.Empty)
{
var item = STLD_MedicalAssociation.associationItems.FirstOrDefault(a => a.Value == practice.OtherOphthal_PracticeData.HEC_PublicHealthcare_PhysitianAssociationID);
if (item != null)
{
association.IsDeleted = true;
association.HealthAssociation_Name = item.Text;
association.Save(Connection, Transaction);
}
}
}
var customerQuery = new ORM_CMN_BPT_CTM_Customer.Query();
customerQuery.Ext_BusinessParticipant_RefID = practice.BaseInfo.CMN_BPT_BusinessParticipantID;
var customer = ORM_CMN_BPT_CTM_Customer.Query.Search(Connection, Transaction, customerQuery).FirstOrDefault();
if (customer != null)
{
customer.IsDeleted = true;
customer.Save(Connection, Transaction);
}
var companyTypeQuery = new ORM_CMN_COM_CompanyInfo_Type.Query();
companyTypeQuery.IsDeleted = false;
companyTypeQuery.CMN_COM_CompanyInfo_TypeID = practice.OtherOphthal_PracticeData.CMN_COM_CompanyInfo_TypeID;
var companyType = ORM_CMN_COM_CompanyInfo_Type.Query.Search(Connection, Transaction, companyTypeQuery).First();
var pHealthcareQuery = new ORM_HEC_PublicHealthcare_PhysitianAssociation.Query();
pHealthcareQuery.HEC_PublicHealthcare_PhysitianAssociationID = practice.OtherOphthal_PracticeData.HEC_PublicHealthcare_PhysitianAssociationID;
var pHealthcare = ORM_HEC_PublicHealthcare_PhysitianAssociation.Query.Search(Connection, Transaction, pHealthcareQuery).First();
pHealthcare.IsDeleted = true;
pHealthcare.Save(Connection, Transaction);
if (customer != null)
{
var affinityStatusQuery = new ORM_CMN_BPT_CTM_AffinityStatus.Query();
affinityStatusQuery.CMN_BPT_CTM_AffinityStatusID = customer.CustomerAffinityStatus_RefID;
var affinityStatus = ORM_CMN_BPT_CTM_AffinityStatus.Query.Search(Connection, Transaction, affinityStatusQuery).First();
if (affinityStatus != null)
{
affinityStatus.IsDeleted = true;
affinityStatus.Save(Connection, Transaction);
}
}
}
}
return(returnValue);
#endregion UserCode
}
