protected static FR_Guid Execute(DbConnection Connection, DbTransaction Transaction, P_L5OF_DOD_1520 Parameter, CSV2Core.SessionSecurity.SessionSecurityTicket securityTicket = null) { //Leave UserCode region to enable user code saving #region UserCode var returnValue = new FR_Guid(); //Put your code here var queryOfficeToDelete = new ORM_CMN_STR_Office.Query(); queryOfficeToDelete.CMN_STR_OfficeID = Parameter.OfficeID; queryOfficeToDelete.Tenant_RefID = securityTicket.TenantID; queryOfficeToDelete.IsDeleted = false; var OfficeToDelete = ORM_CMN_STR_Office.Query.Search(Connection, Transaction, queryOfficeToDelete).SingleOrDefault(); if (OfficeToDelete != null) { var param = new P_L2O_SO_1529(); param.CMN_STR_OfficeID = Parameter.OfficeID; param.IsDeleted = true; var queryOfficeAddresses = new ORM_CMN_STR_Office_Address.Query(); queryOfficeAddresses.Office_RefID = Parameter.OfficeID; queryOfficeAddresses.Tenant_RefID = securityTicket.TenantID; queryOfficeAddresses.IsDeleted = false; //Locate all office addresses using connection table var OfficeAddresses = ORM_CMN_STR_Office_Address.Query.Search(Connection, Transaction, queryOfficeAddresses); foreach (var officeAddress in OfficeAddresses) { var deleteAddressParam = new P_L2AD_SA_1755(); deleteAddressParam.CMN_AddressID = officeAddress.CMN_Address_RefID; deleteAddressParam.IsDeleted = true; cls_Save_Address.Invoke(Connection, Transaction, deleteAddressParam); } cls_Save_Office.Invoke(Connection, Transaction, param); } var queryChildrenOfficesToDelete = new ORM_CMN_STR_Office.Query(); queryChildrenOfficesToDelete.Parent_RefID = Parameter.OfficeID; queryChildrenOfficesToDelete.Tenant_RefID = securityTicket.TenantID; queryChildrenOfficesToDelete.IsDeleted = false; var ChildrenOfficesToDelete = ORM_CMN_STR_Office.Query.Search(Connection, Transaction, queryChildrenOfficesToDelete); if (ChildrenOfficesToDelete.Count > 0) { foreach (var childrenOffice in ChildrenOfficesToDelete) { var deleteChildrenOfficeParam = new P_L5OF_DOD_1520(); deleteChildrenOfficeParam.OfficeID = childrenOffice.CMN_STR_OfficeID; cls_Delete_Office_Deep.Invoke(Connection, Transaction, deleteChildrenOfficeParam, securityTicket); } } return(returnValue); #endregion UserCode }
protected static FR_Guid Execute(DbConnection Connection, DbTransaction Transaction, P_L2OF_SOA_1410 Parameter, CSV2Core.SessionSecurity.SessionSecurityTicket securityTicket = null) { //Leave UserCode region to enable user code saving #region UserCode var returnValue = new FR_Guid(); //Put your code here if (Parameter.IsDefaultAddress) { //set previous flags as non default ORM_CMN_STR_Office_Address.Query.Update(Connection, Transaction, new ORM_CMN_STR_Office_Address.Query() { Office_RefID = Parameter.OfficeID, IsDefault = true, IsShippingAddress = Parameter.IsShippingAddress, IsBillingAddress = Parameter.IsBillingAddress }, new ORM_CMN_STR_Office_Address.Query() { IsDefault = false } ); } var addressID = Guid.Empty; if (Parameter.AddressID == Guid.Empty) { //Create var saveAddressParam = new P_L2AD_SA_1755(); saveAddressParam.CMN_AddressID = Parameter.Address_Save.CMN_AddressID; saveAddressParam.CareOf = Parameter.Address_Save.CareOf; saveAddressParam.Street_Name = Parameter.Address_Save.Street_Name; saveAddressParam.Street_Number = Parameter.Address_Save.Street_Number; saveAddressParam.City_PostalCode = Parameter.Address_Save.City_PostalCode; saveAddressParam.City_Name = Parameter.Address_Save.City_Name; saveAddressParam.Country_Name = Parameter.Address_Save.Country_Name; saveAddressParam.Country_ISOCode = Parameter.Address_Save.Country_ISOCode; addressID = cls_Save_Address.Invoke(Connection, Transaction, saveAddressParam, securityTicket).Result; var OfficeAddress = new ORM_CMN_STR_Office_Address(); OfficeAddress.CMN_Address_RefID = addressID; OfficeAddress.Office_RefID = Parameter.OfficeID; OfficeAddress.IsBillingAddress = Parameter.IsBillingAddress; OfficeAddress.IsShippingAddress = Parameter.IsShippingAddress; OfficeAddress.IsSpecialAddress = Parameter.IsSpecialAddress; OfficeAddress.IfSpecialAddress_Name = Parameter.IsSpecialAddress_Name; OfficeAddress.IsDefault = Parameter.IsDefaultAddress; OfficeAddress.Tenant_RefID = securityTicket.TenantID; OfficeAddress.Save(Connection, Transaction); } else { //Update addressID = Parameter.AddressID; var address = new ORM_CMN_Address(); address.Load(Connection, Transaction, Parameter.AddressID); address.CareOf = Parameter.Address_Save.CareOf; address.Street_Name = Parameter.Address_Save.Street_Name; address.Street_Number = Parameter.Address_Save.Street_Number; address.City_PostalCode = Parameter.Address_Save.City_PostalCode; address.City_Name = Parameter.Address_Save.City_Name; address.Country_Name = Parameter.Address_Save.Country_Name; address.Country_ISOCode = Parameter.Address_Save.Country_ISOCode; address.Save(Connection, Transaction); var queryOfficeAddress = new ORM_CMN_STR_Office_Address.Query(); queryOfficeAddress.CMN_Address_RefID = Parameter.AddressID; queryOfficeAddress.Office_RefID = Parameter.OfficeID; queryOfficeAddress.IsDeleted = false; var officeAddress = ORM_CMN_STR_Office_Address.Query.Search(Connection, Transaction, queryOfficeAddress).FirstOrDefault(); officeAddress.IsDefault = Parameter.IsDefaultAddress; officeAddress.IsBillingAddress = Parameter.IsBillingAddress; officeAddress.IsShippingAddress = Parameter.IsShippingAddress; officeAddress.IsSpecialAddress = Parameter.IsSpecialAddress; officeAddress.IfSpecialAddress_Name = Parameter.IsSpecialAddress_Name; officeAddress.Save(Connection, Transaction); } #region Update DefaultAdresses var defaultShippingAddressQuery = new ORM_CMN_STR_Office_Address.Query(); defaultShippingAddressQuery.Office_RefID = Parameter.OfficeID; defaultShippingAddressQuery.IsDeleted = false; defaultShippingAddressQuery.IsDefault = true; defaultShippingAddressQuery.IsShippingAddress = true; var defaultShippingAddress = ORM_CMN_STR_Office_Address.Query.Search(Connection, Transaction, defaultShippingAddressQuery).SingleOrDefault(); var defaultBillingAddressQuery = new ORM_CMN_STR_Office_Address.Query(); defaultBillingAddressQuery.Office_RefID = Parameter.OfficeID; defaultBillingAddressQuery.IsDeleted = false; defaultBillingAddressQuery.IsDefault = true; defaultBillingAddressQuery.IsBillingAddress = true; var defaultBillingAddress = ORM_CMN_STR_Office_Address.Query.Search(Connection, Transaction, defaultBillingAddressQuery).SingleOrDefault(); var office = new ORM_CMN_STR_Office(); office.Load(Connection, Transaction, Parameter.OfficeID); office.Default_BillingAddress_RefID = (defaultBillingAddress != null) ? defaultBillingAddress.CMN_Address_RefID : Guid.Empty; office.Default_ShippingAddress_RefID = (defaultShippingAddress != null) ? defaultShippingAddress.CMN_Address_RefID : Guid.Empty; office.Save(Connection, Transaction); #endregion return(returnValue); #endregion UserCode }