protected static FR_Guid Execute(DbConnection Connection, DbTransaction Transaction, P_L6PA_SBBVAAP_0842 Parameter, CSV2Core.SessionSecurity.SessionSecurityTicket securityTicket = null) { //Leave UserCode region to enable user code saving #region UserCode var returnValue = new FR_Guid(); ORM_CMN_Address 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); } else { ORM_CMN_PER_PersonInfo_2_Address.Query query = new ORM_CMN_PER_PersonInfo_2_Address.Query(); query.CMN_Address_RefID = address.CMN_AddressID; query.Tenant_RefID = securityTicket.TenantID; query.IsDeleted = false; var queryRes = ORM_CMN_PER_PersonInfo_2_Address.Query.Search(Connection, Transaction, query); if (queryRes.Count == 1) { queryRes[0].IsPrimary = true; queryRes[0].Save(Connection, Transaction); ORM_CMN_PER_PersonInfo_2_Address.Query queryOther = new ORM_CMN_PER_PersonInfo_2_Address.Query(); queryOther.CMN_PER_PersonInfo_RefID = queryRes[0].CMN_PER_PersonInfo_RefID; queryOther.Tenant_RefID = securityTicket.TenantID; queryOther.IsDeleted = false; var queryOtherRes = ORM_CMN_PER_PersonInfo_2_Address.Query.Search(Connection, Transaction, queryOther); if (queryOtherRes.Count > 0) { foreach (ORM_CMN_PER_PersonInfo_2_Address item in queryOtherRes) { if (item.AssignmentID != queryRes[0].AssignmentID) { item.IsPrimary = false; item.Save(Connection, Transaction); } } } } else { var error = new FR_Guid(); error.ErrorMessage = "No Such ID"; error.Status = FR_Status.Error_Internal; return(error); } } } return(returnValue); #endregion UserCode }
protected static FR_Guid Execute(DbConnection Connection, DbTransaction Transaction, P_L6PA_DBBVAFP_1703 Parameter, CSV2Core.SessionSecurity.SessionSecurityTicket securityTicket = null) { //Leave UserCode region to enable user code saving #region UserCode var returnValue = new FR_Guid(); ORM_CMN_Address 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); } else { address.IsDeleted = true; address.Save(Connection, Transaction); ORM_CMN_PER_PersonInfo_2_Address.Query query = new ORM_CMN_PER_PersonInfo_2_Address.Query(); query.CMN_Address_RefID = address.CMN_AddressID; query.Tenant_RefID = securityTicket.TenantID; query.IsDeleted = false; var queryRes = ORM_CMN_PER_PersonInfo_2_Address.Query.SoftDelete(Connection, Transaction, query); } } return(returnValue); #endregion UserCode }
protected static FR_Guid Execute(DbConnection Connection, DbTransaction Transaction, P_L5CU_CACDA_1644 Parameter, CSV2Core.SessionSecurity.SessionSecurityTicket securityTicket = null) { #region UserCode var returnValue = new FR_Guid(); //Put your code here if (Parameter.IsCompany) { ORM_CMN_COM_CompanyInfo_Address.Query queryComAdressIsDefault = new ORM_CMN_COM_CompanyInfo_Address.Query(); queryComAdressIsDefault.IsDefault = true; queryComAdressIsDefault.CompanyInfo_RefID = Parameter.CompanyInfoID; queryComAdressIsDefault.IsBilling = Parameter.IsBilling; queryComAdressIsDefault.IsShipping = !Parameter.IsBilling; List <ORM_CMN_COM_CompanyInfo_Address> companyAdresses = ORM_CMN_COM_CompanyInfo_Address.Query.Search(Connection, Transaction, queryComAdressIsDefault); if (companyAdresses.Count != 0 || companyAdresses != null) { foreach (ORM_CMN_COM_CompanyInfo_Address item1 in companyAdresses) { item1.IsDefault = false; item1.Save(Connection, Transaction); } } } else { ORM_CMN_PER_PersonInfo_2_Address.Query queryPerAdressIsDefault = new ORM_CMN_PER_PersonInfo_2_Address.Query(); queryPerAdressIsDefault.IsPrimary = true; queryPerAdressIsDefault.CMN_PER_PersonInfo_RefID = Parameter.PersonInfoID; queryPerAdressIsDefault.IsAddress_Billing = Parameter.IsBilling; queryPerAdressIsDefault.IsAddress_Shipping = !Parameter.IsBilling; List <ORM_CMN_PER_PersonInfo_2_Address> personAdresses = ORM_CMN_PER_PersonInfo_2_Address.Query.Search(Connection, Transaction, queryPerAdressIsDefault); if (personAdresses.Count != 0 || personAdresses != null) { foreach (ORM_CMN_PER_PersonInfo_2_Address item1 in personAdresses) { item1.IsPrimary = false; item1.Save(Connection, Transaction); } } } return(returnValue); #endregion UserCode }
protected static FR_Guid Execute(DbConnection Connection, DbTransaction Transaction, P_L6PA_SMSAFP_1547 Parameter, CSV2Core.SessionSecurity.SessionSecurityTicket securityTicket = null) { //Leave UserCode region to enable user code saving #region UserCode var returnValue = new FR_Guid(); P_L6PA_GMSPfID_1538 getPatientParam = new P_L6PA_GMSPfID_1538(); getPatientParam.HEC_PatientID = Parameter.HEC_PatientID; L6PA_GMSPfID_1538 patient = cls_Get_MS_Patients_For_ID.Invoke(Connection, Transaction, getPatientParam, securityTicket).Result; if (patient == null) { var error = new FR_Guid(); error.ErrorMessage = "No Such ID"; error.Status = FR_Status.Error_Internal; return(error); } ORM_CMN_PER_PersonInfo_2_Address.Query query = new ORM_CMN_PER_PersonInfo_2_Address.Query(); query.CMN_PER_PersonInfo_RefID = patient.CMN_PER_PersonInfoID; query.Tenant_RefID = securityTicket.TenantID; query.IsDeleted = false; var queryRes = ORM_CMN_PER_PersonInfo_2_Address.Query.Search(Connection, Transaction, query); ORM_CMN_Address 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.Street_Name = Parameter.Street_Name; address.Street_Number = Parameter.Street_Number; address.City_Name = Parameter.City_Name; address.City_PostalCode = Parameter.City_PostalCode; address.Province_Name = Parameter.Province_Name; address.Tenant_RefID = securityTicket.TenantID; address.Save(Connection, Transaction); ORM_CMN_PER_PersonInfo_2_Address assignment = queryRes.FirstOrDefault(a => a.CMN_Address_RefID == Parameter.CMN_AddressID); if (assignment == null) { assignment = new ORM_CMN_PER_PersonInfo_2_Address(); assignment.CMN_Address_RefID = address.CMN_AddressID; assignment.CMN_PER_PersonInfo_RefID = patient.CMN_PER_PersonInfoID; assignment.Tenant_RefID = securityTicket.TenantID; if (queryRes.Count == 0) { assignment.IsPrimary = true; } assignment.SequenceNumber = queryRes.Count + 1; } assignment.Save(Connection, Transaction); returnValue.Result = address.CMN_AddressID; return(returnValue); #endregion UserCode }