protected static FR_Guid Execute(DbConnection Connection, DbTransaction Transaction, P_L5AAS_SSPCI_0832 Parameter, CSV2Core.SessionSecurity.SessionSecurityTicket securityTicket = null) { #region UserCode var returnValue = new FR_Guid(); var item = new CL1_CMN_BPT.ORM_CMN_BPT_BusinessParticipant(); var associatedBusinessParticipant = new CL1_CMN_BPT.ORM_CMN_BPT_BusinessParticipant_AssociatedBusinessParticipant(); var personInfo = new CL1_CMN_PER.ORM_CMN_PER_PersonInfo(); var communicationContacts = new List <CL1_CMN_PER.ORM_CMN_PER_CommunicationContact>(); var address = new CL1_CMN.ORM_CMN_Address(); if (Parameter.CMN_BPT_BusinessParticipantID != Guid.Empty) { var result = item.Load(Connection, Transaction, Parameter.CMN_BPT_BusinessParticipantID); associatedBusinessParticipant = CL1_CMN_BPT.ORM_CMN_BPT_BusinessParticipant_AssociatedBusinessParticipant.Query.Search(Connection, Transaction, new CL1_CMN_BPT.ORM_CMN_BPT_BusinessParticipant_AssociatedBusinessParticipant.Query { IsDeleted = false, BusinessParticipant_RefID = item.CMN_BPT_BusinessParticipantID }).Single(); // Get person info personInfo.Load(Connection, Transaction, item.IfNaturalPerson_CMN_PER_PersonInfo_RefID); // Get communication contacts communicationContacts = CL1_CMN_PER.ORM_CMN_PER_CommunicationContact.Query.Search(Connection, Transaction, new CL1_CMN_PER.ORM_CMN_PER_CommunicationContact.Query { IsDeleted = false, PersonInfo_RefID = personInfo.CMN_PER_PersonInfoID }); // Get address if (Parameter.CMN_AddressID != Guid.Empty) { address.Load(Connection, Transaction, Parameter.CMN_AddressID); } } if (Parameter.IsDeleted == true) { associatedBusinessParticipant.IsDeleted = true; personInfo.IsDeleted = true; communicationContacts.ForEach(x => x.IsDeleted = true); communicationContacts.ForEach(x => x.Save(Connection, Transaction)); if (address.Status_IsAlreadySaved) { address.IsDeleted = true; address.Save(Connection, Transaction); } item.IsDeleted = true; return(new FR_Guid(item.Save(Connection, Transaction), item.CMN_BPT_BusinessParticipantID)); } //Creation specific parameters (Tenant, Account ... ) if (Parameter.CMN_BPT_BusinessParticipantID == Guid.Empty) { item.Tenant_RefID = securityTicket.TenantID; associatedBusinessParticipant.Tenant_RefID = securityTicket.TenantID; personInfo.Tenant_RefID = securityTicket.TenantID; communicationContacts.ForEach(x => x.Tenant_RefID = securityTicket.TenantID); address.Tenant_RefID = securityTicket.TenantID; } item.IsNaturalPerson = true; item.IfNaturalPerson_CMN_PER_PersonInfo_RefID = personInfo.CMN_PER_PersonInfoID; associatedBusinessParticipant.BusinessParticipant_RefID = item.CMN_BPT_BusinessParticipantID; associatedBusinessParticipant.AssociatedBusinessParticipant_RefID = Parameter.AssociatedBusinessParticipant_RefID; associatedBusinessParticipant.AssociatedParticipant_FunctionName = Parameter.AssociatedParticipant_FunctionName; personInfo.FirstName = Parameter.FirstName; personInfo.LastName = Parameter.LastName; personInfo.Address_RefID = address.CMN_AddressID; #region Save Address if (!Parameter.UseDefaultAddress) { address.City_Name = Parameter.City_Name; address.Street_Name = Parameter.Street_Name; address.Street_Number = Parameter.Street_Number; address.City_PostalCode = Parameter.City_PostalCode; address.Country_ISOCode = Parameter.Country_ISOCode; address.Save(Connection, Transaction); } else { if (address.Status_IsAlreadySaved) { address.IsDeleted = true; address.Save(Connection, Transaction); } personInfo.Address_RefID = Guid.Empty; } #endregion #region Save Connection Contact var tenantCompanyTypes = CL1_CMN_PER.ORM_CMN_PER_CommunicationContact_Type.Query.Search(Connection, Transaction, new CL1_CMN_PER.ORM_CMN_PER_CommunicationContact_Type.Query() { Tenant_RefID = item.Tenant_RefID, IsDeleted = false }); foreach (var ctype in tenantCompanyTypes) { // Create communication contact save parameter. CL2_Contact.Complex.Manipulation.P_L2CN_SCCfPI_1409 commContactParameter = new CL2_Contact.Complex.Manipulation.P_L2CN_SCCfPI_1409(); // Set person ref id. commContactParameter.PersonInfo_RefID = personInfo.CMN_PER_PersonInfoID; // Find CommunicationContactID in existig list and set parameter. commContactParameter.CMN_PER_CommunicationContactID = communicationContacts .Where(x => x.Contact_Type == ctype.CMN_PER_CommunicationContact_TypeID) .Select(x => x.CMN_PER_CommunicationContactID).SingleOrDefault(); // Set contact type parameter. commContactParameter.ContactType = ctype.Type; // Set contact value for specified content type. if (ctype.Type == DLCore_DBCommons.Utils.EnumUtils.GetEnumDescription(CL2_Contact.DomainManagement.EComunactionContactType.Phone)) { commContactParameter.ContactValue = Parameter.Phone; } else if (ctype.Type == DLCore_DBCommons.Utils.EnumUtils.GetEnumDescription(CL2_Contact.DomainManagement.EComunactionContactType.Email)) { commContactParameter.ContactValue = Parameter.Email; } else if (ctype.Type == DLCore_DBCommons.Utils.EnumUtils.GetEnumDescription(CL2_Contact.DomainManagement.EComunactionContactType.Fax)) { commContactParameter.ContactValue = Parameter.Fax; } else { continue; // not saving, because tenant don't have this contact type. } CL2_Contact.Complex.Manipulation.cls_Save_ComunicationContact_for_PersonInfoID.Invoke(Connection, Transaction, commContactParameter, securityTicket); } #endregion associatedBusinessParticipant.Save(Connection, Transaction); personInfo.Save(Connection, Transaction); return(new FR_Guid(item.Save(Connection, Transaction), item.CMN_BPT_BusinessParticipantID)); #endregion UserCode }
///<summary> /// Method Invocation of wrapper classes ///<summary> protected static FR_Guid Invoke(DbConnection Connection, DbTransaction Transaction, string ConnectionString, P_L5AAS_SSPCI_0832 Parameter, CSV2Core.SessionSecurity.SessionSecurityTicket securityTicket = null) { bool cleanupConnection = Connection == null; bool cleanupTransaction = Transaction == null; FR_Guid functionReturn = new FR_Guid(); try { if (cleanupConnection == true) { Connection = CSV2Core_MySQL.Support.DBSQLSupport.CreateConnection(ConnectionString); Connection.Open(); } if (cleanupTransaction == true) { Transaction = Connection.BeginTransaction(); } functionReturn = Execute(Connection, Transaction, Parameter, securityTicket); #region Cleanup Connection/Transaction //Commit the transaction if (cleanupTransaction == true) { Transaction.Commit(); } //Close the connection if (cleanupConnection == true) { Connection.Close(); } #endregion } catch (Exception ex) { try { if (cleanupTransaction == true && Transaction != null) { Transaction.Rollback(); } } catch { } try { if (cleanupConnection == true && Connection != null) { Connection.Close(); } } catch { } throw new Exception("Exception occured in method cls_Save_Supplier_Contact_Person_Info", ex); } return(functionReturn); }
///<summary> /// Opens the connection/transaction for the given connectionString, and closes them when complete ///<summary> public static FR_Guid Invoke(string ConnectionString, P_L5AAS_SSPCI_0832 Parameter, CSV2Core.SessionSecurity.SessionSecurityTicket securityTicket = null) { return(Invoke(null, null, ConnectionString, Parameter, securityTicket)); }
///<summary> /// Invokes the method for the given Connection, and Transaction, leaving them open/not commited if no exceptions occured ///<summary> public static FR_Guid Invoke(DbConnection Connection, DbTransaction Transaction, P_L5AAS_SSPCI_0832 Parameter, CSV2Core.SessionSecurity.SessionSecurityTicket securityTicket = null) { return(Invoke(Connection, Transaction, null, Parameter, securityTicket)); }
protected static FR_Guid Execute(DbConnection Connection, DbTransaction Transaction, P_L5AAS_SS_1355 Parameter, CSV2Core.SessionSecurity.SessionSecurityTicket securityTicket = null) { #region UserCode var returnValue = new FR_Guid(); var item = new CL1_CMN_BPT.ORM_CMN_BPT_Supplier(); var businessParticipant = new CL1_CMN_BPT.ORM_CMN_BPT_BusinessParticipant(); var companyInfo = new CL1_CMN_COM.ORM_CMN_COM_CompanyInfo(); var universalContact = new CL1_CMN.ORM_CMN_UniversalContactDetail(); var discountValue = new CL1_CMN_BPT.ORM_CMN_BPT_Supplier_DiscountValue(); var cashDiscountValue = new CL1_CMN_BPT.ORM_CMN_BPT_Supplier_DiscountValue(); var discountQuery = new CL1_ORD_PRC.ORM_ORD_PRC_DiscountType.Query(); discountQuery.Tenant_RefID = securityTicket.TenantID; discountQuery.GlobalPropertyMatchingID = EnumUtils.GetEnumDescription(EDiscountType.MainDiscount); var discount = CL1_ORD_PRC.ORM_ORD_PRC_DiscountType.Query.Search(Connection, Transaction, discountQuery).Single(); var scontoQuery = new CL1_ORD_PRC.ORM_ORD_PRC_DiscountType.Query(); scontoQuery.Tenant_RefID = securityTicket.TenantID; scontoQuery.GlobalPropertyMatchingID = EnumUtils.GetEnumDescription(EDiscountType.CashDiscount); var sconto = CL1_ORD_PRC.ORM_ORD_PRC_DiscountType.Query.Search(Connection, Transaction, scontoQuery).SingleOrDefault(); if (Parameter.CMN_BPT_SupplierID != Guid.Empty) { var result = item.Load(Connection, Transaction, Parameter.CMN_BPT_SupplierID); if (item.Ext_BusinessParticipant_RefID != Guid.Empty) { businessParticipant.Load(Connection, Transaction, item.Ext_BusinessParticipant_RefID); } if (businessParticipant.IfCompany_CMN_COM_CompanyInfo_RefID != Guid.Empty) { companyInfo.Load(Connection, Transaction, businessParticipant.IfCompany_CMN_COM_CompanyInfo_RefID); } if (companyInfo.Contact_UCD_RefID != Guid.Empty) { universalContact.Load(Connection, Transaction, companyInfo.Contact_UCD_RefID); } var discountValueQuery = new CL1_CMN_BPT.ORM_CMN_BPT_Supplier_DiscountValue.Query(); discountValueQuery.Supplier_RefID = Parameter.CMN_BPT_SupplierID; discountValueQuery.Tenant_RefID = securityTicket.TenantID; discountValueQuery.ORD_PRC_DiscountType_RefID = discount.ORD_PRC_DiscountTypeID; var foundDiscountValue = CL1_CMN_BPT.ORM_CMN_BPT_Supplier_DiscountValue.Query.Search(Connection, Transaction, discountValueQuery); if (foundDiscountValue.Count == 1) { discountValue = foundDiscountValue.Single(); } var scontoValueQuery = new CL1_CMN_BPT.ORM_CMN_BPT_Supplier_DiscountValue.Query(); scontoValueQuery.Supplier_RefID = Parameter.CMN_BPT_SupplierID; scontoValueQuery.Tenant_RefID = securityTicket.TenantID; scontoValueQuery.ORD_PRC_DiscountType_RefID = sconto.ORD_PRC_DiscountTypeID; var foundCashValue = CL1_CMN_BPT.ORM_CMN_BPT_Supplier_DiscountValue.Query.Search(Connection, Transaction, scontoValueQuery); if (foundCashValue.Count == 1) { cashDiscountValue = foundCashValue.Single(); } } if (Parameter.IsDeleted == true) { item.IsDeleted = true; businessParticipant.IsDeleted = true; companyInfo.IsDeleted = true; universalContact.IsDeleted = true; #region Delete company info address P_L5AAS_GAfCI_1526 addressParam = new P_L5AAS_GAfCI_1526(); addressParam.CompanyInfoID = companyInfo.CMN_COM_CompanyInfoID; var addresses = cls_Get_Addresses_for_CompanyInfoID.Invoke(Connection, Transaction, addressParam, securityTicket).Result; foreach (var a in addresses) { P_L5AAS_SSA_1528 addressSaveParameter = new P_L5AAS_SSA_1528(); addressSaveParameter.CMN_COM_CompanyInfo_AddressID = a.CMN_COM_CompanyInfo_AddressID; addressSaveParameter.CompanyInfo_RefID = a.CompanyInfo_RefID; addressSaveParameter.IsDeleted = true; cls_Save_Supplier_Address.Invoke(Connection, Transaction, addressSaveParameter, securityTicket); } #endregion #region Delete Contact Persons P_L5AAS_GCPIfBP_1607 contactPersonParam = new P_L5AAS_GCPIfBP_1607(); contactPersonParam.BusinessParticipantID = businessParticipant.CMN_BPT_BusinessParticipantID; var contactPersons = cls_Get_Contact_Person_Info_for_BusinessParticipantID.Invoke(Connection, Transaction, contactPersonParam, securityTicket).Result; foreach (var c in contactPersons) { P_L5AAS_SSPCI_0832 contactPersonSaveParam = new P_L5AAS_SSPCI_0832(); contactPersonSaveParam.AssociatedBusinessParticipant_RefID = c.AssociatedBusinessParticipant_RefID; contactPersonSaveParam.CMN_AddressID = c.CMN_AddressID; contactPersonSaveParam.CMN_BPT_BusinessParticipantID = c.CMN_BPT_BusinessParticipantID; cls_Save_Supplier_Contact_Person_Info.Invoke(Connection, Transaction, contactPersonSaveParam, securityTicket); } #endregion businessParticipant.Save(Connection, Transaction); companyInfo.Save(Connection, Transaction); universalContact.Save(Connection, Transaction); return(new FR_Guid(item.Save(Connection, Transaction), item.CMN_BPT_SupplierID)); } //Creation specific parameters (Tenant, Account ... ) if (Parameter.CMN_BPT_SupplierID == Guid.Empty) { item.Tenant_RefID = securityTicket.TenantID; businessParticipant.Tenant_RefID = securityTicket.TenantID; companyInfo.Tenant_RefID = securityTicket.TenantID; universalContact.Tenant_RefID = securityTicket.TenantID; } item.SupplierType_RefID = Parameter.CMN_BPT_Supplier_TypeID; item.Ext_BusinessParticipant_RefID = businessParticipant.CMN_BPT_BusinessParticipantID; item.ExternalSupplierProvidedIdentifier = Parameter.SupplierProvidedExternalIdentifier; businessParticipant.DisplayName = Parameter.DisplayName; businessParticipant.IsCompany = true; businessParticipant.DefaultCurrency_RefID = Parameter.DefaultCurrency_RefID; businessParticipant.DefaultLanguage_RefID = Parameter.DefaultLanguage_RefID; businessParticipant.IfCompany_CMN_COM_CompanyInfo_RefID = companyInfo.CMN_COM_CompanyInfoID; companyInfo.Contact_UCD_RefID = universalContact.CMN_UniversalContactDetailID; companyInfo.CompanyInfo_EstablishmentNumber = Parameter.CompanyInfo_EstablishmentNumber; companyInfo.AnnualRevenueAmountValue_RefID = Parameter.AnnualRevenueAmountValue_RefID; companyInfo.VATIdentificationNumber = Parameter.VATIdentificationNumber; universalContact.CompanyName_Line1 = Parameter.CompanyName_Line1; universalContact.Country_639_1_ISOCode = Parameter.Country_639_1_ISOCode; if (businessParticipant.CMN_BPT_BusinessParticipantID != Guid.Empty) { businessParticipant.Save(Connection, Transaction); } if (companyInfo.CMN_COM_CompanyInfoID != Guid.Empty) { companyInfo.Save(Connection, Transaction); } if (universalContact.CMN_UniversalContactDetailID != Guid.Empty) { universalContact.Save(Connection, Transaction); } Guid savedSupplier = new FR_Guid(item.Save(Connection, Transaction), item.CMN_BPT_SupplierID).Result; #region DiscountValue if (discountValue.Tenant_RefID == Guid.Empty) { discountValue.CMN_BPT_Supplier_DiscountValueID = Guid.NewGuid(); discountValue.Supplier_RefID = savedSupplier; discountValue.ORD_PRC_DiscountType_RefID = discount.ORD_PRC_DiscountTypeID; discountValue.Tenant_RefID = securityTicket.TenantID; } discountValue.DiscountValue_in_percent = Parameter.DiscountValue; discountValue.Save(Connection, Transaction); if (cashDiscountValue.Tenant_RefID == Guid.Empty) { cashDiscountValue.CMN_BPT_Supplier_DiscountValueID = Guid.NewGuid(); cashDiscountValue.Supplier_RefID = savedSupplier; cashDiscountValue.ORD_PRC_DiscountType_RefID = sconto.ORD_PRC_DiscountTypeID; cashDiscountValue.Tenant_RefID = securityTicket.TenantID; } cashDiscountValue.DiscountValue_in_percent = Parameter.CashDiscountValue; cashDiscountValue.Save(Connection, Transaction); #endregion returnValue.Result = savedSupplier; return(returnValue); #endregion UserCode }