protected static FR_Bool Execute(DbConnection Connection, DbTransaction Transaction, P_L5EM_CIEIM_1235 Parameter, CSV2Core.SessionSecurity.SessionSecurityTicket securityTicket = null) { #region UserCode var returnValue = new FR_Bool(); ORM_CMN_STR_Office_ResponsiblePerson.Query officeQuery = new ORM_CMN_STR_Office_ResponsiblePerson.Query(); officeQuery.CMN_BPT_EMP_Employee_RefID = Parameter.EmployeeID; officeQuery.IsDeleted = false; if (ORM_CMN_STR_Office_ResponsiblePerson.Query.Exists(Connection, Transaction, officeQuery)) { returnValue.Result = true; } ORM_CMN_STR_PPS_WorkArea_ResponsiblePerson.Query workAreaQuery = new ORM_CMN_STR_PPS_WorkArea_ResponsiblePerson.Query(); workAreaQuery.CMN_BPT_EMP_Employee_RefID = Parameter.EmployeeID; workAreaQuery.IsDeleted = false; if (ORM_CMN_STR_PPS_WorkArea_ResponsiblePerson.Query.Exists(Connection, Transaction, workAreaQuery)) { returnValue.Result = true; } ORM_CMN_STR_PPS_Workplace_ResponsiblePerson.Query workPlaceQuery = new ORM_CMN_STR_PPS_Workplace_ResponsiblePerson.Query(); workPlaceQuery.CMN_BPT_EMP_Employee_RefID = Parameter.EmployeeID; workPlaceQuery.IsDeleted = false; if (ORM_CMN_STR_PPS_Workplace_ResponsiblePerson.Query.Exists(Connection, Transaction, workPlaceQuery)) { returnValue.Result = true; } //Put your code here return(returnValue); #endregion UserCode }
protected static FR_L5OF_GOFT_1157_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_L5OF_GOFT_1157_Array(); ORM_CMN_STR_Office.Query officesQuery = new ORM_CMN_STR_Office.Query(); officesQuery.IsDeleted = false; officesQuery.Tenant_RefID = securityTicket.TenantID; List <ORM_CMN_STR_Office> officesResult = ORM_CMN_STR_Office.Query.Search(Connection, Transaction, officesQuery); List <L5OF_GOFT_1157> officesResultList = new List <L5OF_GOFT_1157>(); foreach (var office in officesResult) { L5OF_GOFT_1157 result = new L5OF_GOFT_1157(); var item = new ORM_CMN_STR_Office(); var resultOffice = item.Load(Connection, Transaction, office.CMN_STR_OfficeID); if (resultOffice.Status != FR_Status.Success || item.CMN_STR_OfficeID == Guid.Empty) { var error = new FR_Guid(); error.ErrorMessage = "No Such ID"; error.Status = FR_Status.Error_Internal; return(null); } result.CMN_CAL_CalendarInstance_RefID = item.CMN_CAL_CalendarInstance_RefID; result.CMN_STR_OfficeID = item.CMN_STR_OfficeID; result.Country_RefID = item.Country_RefID; result.Default_FaxNumber = item.Default_FaxNumber; result.Default_PhoneNumber = item.Default_PhoneNumber; result.Office_ShortName = item.Office_ShortName; result.OfficeDescription = item.Office_Description; result.OfficeName = item.Office_Name; result.Region_RefID = item.Region_RefID; result.BillingAddress_CMN_AddressID = item.Default_BillingAddress_RefID; var address = new ORM_CMN_Address(); var resultItem = address.Load(Connection, Transaction, item.Default_BillingAddress_RefID); if (resultItem.Status != FR_Status.Success || address.CMN_AddressID == Guid.Empty) { var error = new FR_Guid(); error.ErrorMessage = "No Such ID"; error.Status = FR_Status.Error_Internal; return(null); } result.BillingAddress_City_Name = address.City_Name; result.BillingAddress_City_AdministrativeDistrict = address.City_AdministrativeDistrict; result.BillingAddress_City_PostalCode = address.City_PostalCode; result.BillingAddress_City_Region = address.City_Region; result.BillingAddress_Country_Name = address.Country_Name; result.BillingAddress_Province_Name = address.Province_Name; result.BillingAddress_Street_Name = address.Street_Name; result.BillingAddress_Street_Number = address.Street_Number; result.BillingAddress_Country_ISOCode = address.Country_ISOCode; ORM_CMN_STR_Office_2_CostCenter.Query officeToCostcenterQuery = new ORM_CMN_STR_Office_2_CostCenter.Query(); officeToCostcenterQuery.Office_RefID = office.CMN_STR_OfficeID; officeToCostcenterQuery.Tenant_RefID = securityTicket.TenantID; officeToCostcenterQuery.IsDeleted = false; List <ORM_CMN_STR_Office_2_CostCenter> officeToCostcenterList = ORM_CMN_STR_Office_2_CostCenter.Query.Search(Connection, Transaction, officeToCostcenterQuery); if (officeToCostcenterList.Count != 0) { L5OF_GOFT_1157_Costcenter costCenter = new L5OF_GOFT_1157_Costcenter(); ORM_CMN_STR_CostCenter costCenterItem = new ORM_CMN_STR_CostCenter(); costCenterItem.Load(Connection, Transaction, officeToCostcenterList[0].CostCenter_RefID); if (!costCenterItem.IsDeleted) { costCenter.AssignmentID = officeToCostcenterList[0].AssignmentID; costCenter.CMN_STR_CostCenterID = officeToCostcenterList[0].CostCenter_RefID; costCenter.CostcenterName = costCenterItem.Name; costCenter.InternalID = costCenterItem.InternalID; result.Costcenter = costCenter; } } var responsiblePersonsQuery = new ORM_CMN_STR_Office_ResponsiblePerson.Query(); responsiblePersonsQuery.Tenant_RefID = securityTicket.TenantID; responsiblePersonsQuery.Office_RefID = item.CMN_STR_OfficeID; responsiblePersonsQuery.IsDeleted = false; var responsiblePersonsList = ORM_CMN_STR_Office_ResponsiblePerson.Query.Search(Connection, Transaction, responsiblePersonsQuery); List <L5OF_GOFT_1157_ResponsiblePersons> responsiblePresonsResultList = new List <L5OF_GOFT_1157_ResponsiblePersons>(); foreach (var responsiblePerson in responsiblePersonsList) { L5OF_GOFT_1157_ResponsiblePersons responsiblePersonResult = new L5OF_GOFT_1157_ResponsiblePersons(); responsiblePersonResult.CMN_BPT_EMP_EmployeeID = responsiblePerson.CMN_BPT_EMP_Employee_RefID; responsiblePersonResult.CMN_STR_Office_ResponsiblePersonID = responsiblePerson.CMN_STR_Office_ResponsiblePersonID; ORM_CMN_BPT_EMP_Employee employee = new ORM_CMN_BPT_EMP_Employee(); employee.Load(Connection, Transaction, responsiblePerson.CMN_BPT_EMP_Employee_RefID); ORM_CMN_BPT_BusinessParticipant bParticipant = new ORM_CMN_BPT_BusinessParticipant(); bParticipant.Load(Connection, Transaction, employee.BusinessParticipant_RefID); ORM_CMN_PER_PersonInfo person = new ORM_CMN_PER_PersonInfo(); person.Load(Connection, Transaction, bParticipant.IfNaturalPerson_CMN_PER_PersonInfo_RefID); responsiblePersonResult.CMN_BPT_BusinessParticipantID = bParticipant.CMN_BPT_BusinessParticipantID; responsiblePersonResult.FirstName = person.FirstName; responsiblePersonResult.LastName = person.LastName; responsiblePresonsResultList.Add(responsiblePersonResult); } result.Managers = responsiblePresonsResultList.ToArray(); officesResultList.Add(result); } returnValue.Result = officesResultList.ToArray(); //Put your code here return(returnValue); #endregion UserCode }
protected static FR_Guid Execute(DbConnection Connection, DbTransaction Transaction, P_L5OF_SO_1428 Parameter, CSV2Core.SessionSecurity.SessionSecurityTicket securityTicket = null) { #region UserCode var returnValue = new FR_Base(); var item = new ORM_CMN_STR_Office(); if (Parameter.CMN_STR_OfficeID != Guid.Empty) { var result = item.Load(Connection, Transaction, Parameter.CMN_STR_OfficeID); if (result.Status != FR_Status.Success || item.CMN_STR_OfficeID == Guid.Empty) { var error = new FR_Guid(); error.ErrorMessage = "No Such ID"; error.Status = FR_Status.Error_Internal; return(error); } } var address = new ORM_CMN_Address(); if (Parameter.CMN_AddressID != Guid.Empty) { var result = address.Load(Connection, Transaction, Parameter.CMN_AddressID); if (result.Status != FR_Status.Success || address.CMN_AddressID == Guid.Empty) { var error = new FR_Guid(); error.ErrorMessage = "No Such ID"; error.Status = FR_Status.Error_Internal; return(error); } } address.City_Name = Parameter.City_Name; address.City_AdministrativeDistrict = Parameter.City_AdministrativeDistrict; address.City_PostalCode = Parameter.City_PostalCode; address.City_Region = Parameter.City_Region; address.Country_Name = Parameter.Country_Name; address.Province_Name = Parameter.Province_Name; address.Street_Name = Parameter.Street_Name; address.Street_Number = Parameter.Street_Number; address.Tenant_RefID = securityTicket.TenantID; address.Save(Connection, Transaction); item.Default_BillingAddress_RefID = address.CMN_AddressID; item.Default_ShippingAddress_RefID = address.CMN_AddressID; item.Tenant_RefID = securityTicket.TenantID; item.Default_FaxNumber = Parameter.Default_FaxNumber; item.Default_PhoneNumber = Parameter.Default_PhoneNumber; item.Office_Name = Parameter.OfficeName; item.Office_Description = Parameter.OfficeDescription; item.Office_ShortName = Parameter.OfficeShortName; item.CMN_CAL_CalendarInstance_RefID = Parameter.CMN_CAL_CalendarInstance_RefID; item.Region_RefID = Parameter.Region_RefID; item.Country_RefID = Parameter.Country_RefID; ORM_CMN_CAL_CalendarInstance calendar = new ORM_CMN_CAL_CalendarInstance(); if (Parameter.CMN_CAL_CalendarInstance_RefID != Guid.Empty) { var result = calendar.Load(Connection, Transaction, Parameter.CMN_CAL_CalendarInstance_RefID); if (result.Status != FR_Status.Success || calendar.CMN_CAL_CalendarInstanceID == Guid.Empty) { var error = new FR_Guid(); error.ErrorMessage = "No Such ID"; error.Status = FR_Status.Error_Internal; return(error); } } calendar.WeekStartsOnDay = 1; calendar.Save(Connection, Transaction); item.CMN_CAL_CalendarInstance_RefID = calendar.CMN_CAL_CalendarInstanceID; item.Save(Connection, Transaction); ORM_CMN_STR_Office_2_CostCenter whereCC2OInstance = CSV2Core_MySQL.Support.SQLClassFilter.GetDefaultInstance <ORM_CMN_STR_Office_2_CostCenter>(); whereCC2OInstance.Office_RefID = Parameter.CMN_STR_OfficeID; CSV2Core_MySQL.Support.SQLClassFilter.Delete(Connection, Transaction, whereCC2OInstance); if (Parameter.Costcenter_RefID != Guid.Empty) { var cc2o = new ORM_CMN_STR_Office_2_CostCenter(); cc2o.CostCenter_RefID = Parameter.Costcenter_RefID; cc2o.IsDefault = true; cc2o.IsDeleted = false; cc2o.Tenant_RefID = securityTicket.TenantID; cc2o.Office_RefID = item.CMN_STR_OfficeID; cc2o.Save(Connection, Transaction); } var query1 = new ORM_CMN_STR_Office_ResponsiblePerson.Query(); query1.Tenant_RefID = securityTicket.TenantID; query1.Office_RefID = item.CMN_STR_OfficeID; var res = ORM_CMN_STR_Office_ResponsiblePerson.Query.SoftDelete(Connection, Transaction, query1); if (Parameter.ResponsiblePerson != null && Parameter.ResponsiblePerson.Length > 0) { foreach (P_L5OF_SO_1428_ResponsiblePerson obj in Parameter.ResponsiblePerson) { ORM_CMN_STR_Office_ResponsiblePerson person = new ORM_CMN_STR_Office_ResponsiblePerson(); if (obj.AssignmentID != Guid.Empty) { var result = calendar.Load(Connection, Transaction, obj.AssignmentID); if (result.Status != FR_Status.Success || person.CMN_STR_Office_ResponsiblePersonID == Guid.Empty) { var error = new FR_Guid(); error.ErrorMessage = "No Such ID"; error.Status = FR_Status.Error_Internal; return(error); } } if (obj.AssignmentID != Guid.Empty) { person.IsDeleted = true; } else { person.CMN_BPT_EMP_Employee_RefID = obj.ResponsibleEmployeeID; person.Office_RefID = item.CMN_STR_OfficeID; person.Tenant_RefID = securityTicket.TenantID; } person.Save(Connection, Transaction); } } return(new FR_Guid(item.CMN_STR_OfficeID)); #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 }