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 }
protected static FR_Guid Execute(DbConnection Connection, DbTransaction Transaction, P_L5OU_DOUGD_1221 Parameter, CSV2Core.SessionSecurity.SessionSecurityTicket securityTicket = null) { #region UserCode var returnValue = new FR_Guid(); foreach (var OrgUnitID in Parameter.OrgUnitID) { //delete office var officeQuery = new ORM_CMN_STR_Office.Query(); officeQuery.Tenant_RefID = securityTicket.TenantID; officeQuery.IsDeleted = false; officeQuery.CMN_STR_OfficeID = OrgUnitID; var office = ORM_CMN_STR_Office.Query.Search(Connection, Transaction, officeQuery).Single(); //delete Medical practice type ORM_HEC_MedicalPractice_2_PracticeType.Query.SoftDelete(Connection, Transaction, new ORM_HEC_MedicalPractice_2_PracticeType.Query { Tenant_RefID = securityTicket.TenantID, IsDeleted = false, HEC_MedicalPractice_RefID = office.IfMedicalPractise_HEC_MedicalPractice_RefID }); office.IsDeleted = true; office.Save(Connection, Transaction); //delete Addresses var addressQuery = new ORM_CMN_STR_Office_Address.Query(); addressQuery.IsDeleted = false; addressQuery.Tenant_RefID = securityTicket.TenantID; addressQuery.Office_RefID = OrgUnitID; var addressList = ORM_CMN_STR_Office_Address.Query.Search(Connection, Transaction, addressQuery).ToList(); foreach (var address in addressList) { address.IsDeleted = true; address.Save(Connection, Transaction); var addressDataQuery = new ORM_CMN_Address.Query(); addressDataQuery.IsDeleted = false; addressDataQuery.CMN_AddressID = address.CMN_Address_RefID; var addressData = ORM_CMN_Address.Query.Search(Connection, Transaction, addressDataQuery).Single(); addressData.IsDeleted = true; addressData.Save(Connection, Transaction); } //delete Unit Speciality //var office_2_officeTypeQuery = new ORM_CMN_STR_Office_2_OfficeType.Query(); //office_2_officeTypeQuery.IsDeleted = false; //office_2_officeTypeQuery.Office_RefID = OrgUnitID; //var office_2_officeType = ORM_CMN_STR_Office_2_OfficeType.Query.Search(Connection, Transaction, office_2_officeTypeQuery).First(); //office_2_officeType.IsDeleted = true; //office_2_officeType.Save(Connection, Transaction); //delete contact person data var responsiblePersonQuery = new ORM_CMN_STR_Office_ResponsiblePerson.Query(); responsiblePersonQuery.Office_RefID = OrgUnitID; responsiblePersonQuery.IsDeleted = false; var responsiblePerson = ORM_CMN_STR_Office_ResponsiblePerson.Query.Search(Connection, Transaction, responsiblePersonQuery).First(); responsiblePerson.IsDeleted = true; responsiblePerson.Save(Connection, Transaction); var employeeQuery = new ORM_CMN_BPT_EMP_Employee.Query(); employeeQuery.IsDeleted = false; employeeQuery.CMN_BPT_EMP_EmployeeID = responsiblePerson.CMN_BPT_EMP_Employee_RefID; var employee = ORM_CMN_BPT_EMP_Employee.Query.Search(Connection, Transaction, employeeQuery).Single(); employee.IsDeleted = true; employee.Save(Connection, Transaction); var businessParticpantQuery = new ORM_CMN_BPT_BusinessParticipant.Query(); businessParticpantQuery.CMN_BPT_BusinessParticipantID = employee.BusinessParticipant_RefID; businessParticpantQuery.IsDeleted = false; var businessParticpant = ORM_CMN_BPT_BusinessParticipant.Query.Search(Connection, Transaction, businessParticpantQuery).Single(); businessParticpant.IsDeleted = true; businessParticpant.Save(Connection, Transaction); var personInfoQuery = new ORM_CMN_PER_PersonInfo.Query(); personInfoQuery.CMN_PER_PersonInfoID = businessParticpant.IfNaturalPerson_CMN_PER_PersonInfo_RefID; personInfoQuery.IsDeleted = false; var personInfo = ORM_CMN_PER_PersonInfo.Query.Search(Connection, Transaction, personInfoQuery).Single(); personInfo.IsDeleted = true; personInfo.Save(Connection, Transaction); //delete all children var officeQueryChildren = new ORM_CMN_STR_Office.Query(); officeQueryChildren.Tenant_RefID = securityTicket.TenantID; officeQueryChildren.IsDeleted = false; officeQueryChildren.Parent_RefID = OrgUnitID; //delete connection to appointmetn types var orgUnitToAppointmentTypeQuery = new ORM_PPS_TSK_Task_Template_OrganizationalUnitAvailability.Query(); orgUnitToAppointmentTypeQuery.CMN_STR_Office_RefID = OrgUnitID; orgUnitToAppointmentTypeQuery.Tenant_RefID = securityTicket.TenantID; orgUnitToAppointmentTypeQuery.IsDeleted = false; var orgUnitToAppointmentTypeList = ORM_PPS_TSK_Task_Template_OrganizationalUnitAvailability.Query.Search(Connection, Transaction, orgUnitToAppointmentTypeQuery).ToList(); foreach (var item in orgUnitToAppointmentTypeList) { item.IsDeleted = true; item.Save(Connection, Transaction); } var officeChildrenList = ORM_CMN_STR_Office.Query.Search(Connection, Transaction, officeQueryChildren).ToList(); if (officeChildrenList.Count > 0) { List <Guid> guidList = new List <Guid>(); foreach (var officeChildren in officeChildrenList) { guidList.Add(officeChildren.CMN_STR_OfficeID); } cls_Delete_OrgsUnitsGeneralData.Invoke(Connection, Transaction, new P_L5OU_DOUGD_1221 { OrgUnitID = guidList.ToArray() }, securityTicket); } } return(returnValue); #endregion UserCode }