protected static FR_Guid Execute(DbConnection Connection, DbTransaction Transaction, P_L6DO_SDaR_1536 Parameter, CSV2Core.SessionSecurity.SessionSecurityTicket securityTicket = null) { //Leave UserCode region to enable user code saving #region UserCode var returnValue = new FR_Guid(); #region Save Document P_L3DO_SD_1409 paramDoc = new P_L3DO_SD_1409(); paramDoc.Alias = Parameter.File_Name; Guid documentID = cls_Save_DOC_Document.Invoke(Connection, Transaction, paramDoc, securityTicket).Result; #endregion #region cls_Save_DOC_Document_2_Structure P_L3DO_SD2S_1407 paramDocument2Structure = new P_L3DO_SD2S_1407(); paramDocument2Structure.Document_RefID = documentID; paramDocument2Structure.Structure_RefID = Parameter.Structure_RefID; paramDocument2Structure.StructureHeader_RefID = Parameter.Structure_Header_RefID; Guid assigmentID = cls_Save_DOC_Document_2_Structure.Invoke(Connection, Transaction, paramDocument2Structure, securityTicket).Result; #endregion #region cls_Save_DOC_DocumentRevision P_L3DO_SDR_1401 paramDocumentRevision = new P_L3DO_SDR_1401(); paramDocumentRevision.Document_RefID = documentID; paramDocumentRevision.Revision = 1; paramDocumentRevision.IsLocked = false; paramDocumentRevision.IsLastRevision = true; paramDocumentRevision.UploadedByAccount = securityTicket.AccountID; paramDocumentRevision.File_Name = Parameter.File_Name; paramDocumentRevision.File_SourceLocation = ""; paramDocumentRevision.File_ServerLocation = Parameter.File_ServerLocation; paramDocumentRevision.File_MIMEType = Parameter.File_MIMEType; paramDocumentRevision.File_Extension = Parameter.File_Extension; paramDocumentRevision.File_Size_Bytes = Parameter.File_Size_Bytes; cls_Save_DOC_DocumentRevision.Invoke(Connection, Transaction, paramDocumentRevision, securityTicket); #endregion return(returnValue); #endregion UserCode }
protected static FR_Guid Execute(DbConnection Connection, DbTransaction Transaction, P_L2WTT_SWTT_1313 Parameter, CSV2Core.SessionSecurity.SessionSecurityTicket securityTicket = null) { #region UserCode var returnValue = new FR_Guid(); var item = new CL1_TMS.ORM_TMS_QuickTask_Type(); if (Parameter.TMS_WorkingTaskTypeID != Guid.Empty) { var result = item.Load(Connection, Transaction, Parameter.TMS_WorkingTaskTypeID); if (result.Status != FR_Status.Success || item.TMS_QuickTask_TypeID == Guid.Empty) { var error = new FR_Guid(); error.ErrorMessage = "No Such ID"; error.Status = FR_Status.Error_Internal; return(error); } } if (Parameter.IsDeleted == true || Parameter.IfDeleteReplaceWith != Guid.Empty) { CL1_TMS.ORM_TMS_QuickTask.Query searchQuery = new CL1_TMS.ORM_TMS_QuickTask.Query(); searchQuery.QuickTask_Type_RefID = Parameter.TMS_WorkingTaskTypeID; CL1_TMS.ORM_TMS_QuickTask.Query updateQuery = new CL1_TMS.ORM_TMS_QuickTask.Query(); updateQuery.QuickTask_Type_RefID = Parameter.IfDeleteReplaceWith; CL1_TMS.ORM_TMS_QuickTask.Query.Update(Connection, Transaction, searchQuery, updateQuery); item.IsDeleted = true; item.Save(Connection, Transaction); return(new FR_Guid(item.TMS_QuickTask_TypeID)); } //Creation specific parameters (Tenant, Account ... ) if (Parameter.TMS_WorkingTaskTypeID == Guid.Empty) { item.Tenant_RefID = securityTicket.TenantID; item.IsPersistent = true; } item.QuickTaskType_Name = Parameter.QuickTaskType_Name; item.IsDeleted = Parameter.IsDeleted; return(new FR_Guid(item.Save(Connection, Transaction), item.TMS_QuickTask_TypeID)); #endregion UserCode }
protected static FR_Guid Execute(DbConnection Connection, DbTransaction Transaction, P_L5EM_SEWP_1532 Parameter, CSV2Core.SessionSecurity.SessionSecurityTicket securityTicket = null) { #region UserCode var returnValue = new FR_Guid(); ORM_CMN_BPT_EMP_WorkplaceAssignments_WorkPattern.Query workPatternQuery = new ORM_CMN_BPT_EMP_WorkplaceAssignments_WorkPattern.Query(); workPatternQuery.BoundTo_WorkplaceAssignment_RefID = Parameter.BoundTo_WorkplaceAssignment_RefID; workPatternQuery.IsDeleted = false; workPatternQuery.Tenant_RefID = securityTicket.TenantID; ORM_CMN_BPT_EMP_WorkplaceAssignments_WorkPattern.Query.SoftDelete(Connection, Transaction, workPatternQuery); foreach (var pWorkpattern in Parameter.WorkPatterns) { ORM_CMN_BPT_EMP_WorkplaceAssignments_WorkPattern workpattern = new ORM_CMN_BPT_EMP_WorkplaceAssignments_WorkPattern(); if (pWorkpattern.CMN_BPT_EMP_WorkplaceAssignments_WorkPatternID != Guid.Empty) { var result = workpattern.Load(Connection, Transaction, pWorkpattern.CMN_BPT_EMP_WorkplaceAssignments_WorkPatternID); if (result.Status != FR_Status.Success || pWorkpattern.CMN_BPT_EMP_WorkplaceAssignments_WorkPatternID == Guid.Empty) { var error = new FR_Guid(); error.ErrorMessage = "No Such ID"; error.Status = FR_Status.Error_Internal; return(error); } } workpattern.BoundTo_WorkplaceAssignment_RefID = Parameter.BoundTo_WorkplaceAssignment_RefID; workpattern.CMN_BPT_STA_AbsenceReason_RefID = pWorkpattern.CMN_BPT_STA_AbsenceReason_RefID; workpattern.CMN_PPS_ShiftTemplate_RefID = pWorkpattern.CMN_PPS_ShiftTemplate_RefID; workpattern.IsFriday = pWorkpattern.IsFriday; workpattern.IsMonday = pWorkpattern.IsMonday; workpattern.IsSaturday = pWorkpattern.IsSaturday; workpattern.IsSunday = pWorkpattern.IsSunday; workpattern.IsThursday = pWorkpattern.IsThursday; workpattern.IsTuesday = pWorkpattern.IsTuesday; workpattern.IsWednesday = pWorkpattern.IsWednesday; workpattern.IsWeek_Even = pWorkpattern.IsWeek_Even; workpattern.IsWeek_Odd = pWorkpattern.IsWeek_Odd; workpattern.Tenant_RefID = securityTicket.TenantID; workpattern.Save(Connection, Transaction); } //Put your code here return(returnValue); #endregion UserCode }
protected static FR_Guid Execute(DbConnection Connection, DbTransaction Transaction, P_MD_SCP_1754 Parameter, CSV2Core.SessionSecurity.SessionSecurityTicket securityTicket = null) { #region UserCode var returnValue = new FR_Guid(); //Put your code here var contract_parameter = ORM_CMN_CTR_Contract_Parameter.Query.Search(Connection, Transaction, new ORM_CMN_CTR_Contract_Parameter.Query() { Contract_RefID = Parameter.ContractID, ParameterName = Parameter.Name, Tenant_RefID = securityTicket.TenantID, IsDeleted = false }).SingleOrDefault(); if (contract_parameter == null) { contract_parameter = new ORM_CMN_CTR_Contract_Parameter(); contract_parameter.Tenant_RefID = securityTicket.TenantID; contract_parameter.ParameterName = Parameter.Name; contract_parameter.Contract_RefID = Parameter.ContractID; } if (Parameter.BooleanValue.HasValue) { contract_parameter.IsBooleanValue = true; contract_parameter.IfBooleanValue_Value = Parameter.BooleanValue.Value; } else if (Parameter.NumericValue.HasValue) { contract_parameter.IsNumericValue = true; contract_parameter.IfNumericValue_Value = Parameter.NumericValue.Value; } else { contract_parameter.IsStringValue = true; contract_parameter.IfStringValue_Value = Parameter.StringValue; } contract_parameter.Modification_Timestamp = DateTime.Now; contract_parameter.Save(Connection, Transaction); returnValue.Result = contract_parameter.CMN_CTR_Contract_ParameterID; return(returnValue); #endregion UserCode }
protected static FR_Guid Execute(DbConnection Connection, DbTransaction Transaction, P_L5AR_SAiAG_1623 Parameter, CSV2Core.SessionSecurity.SessionSecurityTicket securityTicket = null) { #region UserCode var returnValue = new FR_Guid(); var item = new ORM_CMN_PRO_Product_2_ProductGroup(); if (Parameter.AssignmentID != Guid.Empty) { var result = item.Load(Connection, Transaction, Parameter.AssignmentID); if (result.Status != FR_Status.Success || item.AssignmentID == Guid.Empty) { var error = new FR_Guid(); error.ErrorMessage = "No Such ID"; error.Status = FR_Status.Error_Internal; return(error); } } if (Parameter.IsDeleted == true) { //var query = new ORM_CMN_PRO_Product_2_ProductGroup.Query(); //query.CMN_PRO_Product_RefID = Parameter.CMN_PRO_ProductID; //query.CMN_PRO_ProductGroup_RefID = Parameter.CMN_PRO_ProductGroupID; //ORM_CMN_PRO_Product_2_ProductGroup deletedItem = ORM_CMN_PRO_Product_2_ProductGroup.Query.Search(Connection,Transaction,query).First(); item.IsDeleted = true; return(new FR_Guid(item.Save(Connection, Transaction), item.AssignmentID)); } //Creation specific parameters (Tenant, Account ... ) if (Parameter.AssignmentID == Guid.Empty) { item.Tenant_RefID = securityTicket.TenantID; } item.CMN_PRO_Product_RefID = Parameter.CMN_PRO_ProductID; item.CMN_PRO_ProductGroup_RefID = Parameter.CMN_PRO_ProductGroupID; return(new FR_Guid(item.Save(Connection, Transaction), item.AssignmentID)); //return returnValue; #endregion UserCode }
protected static FR_Guid Execute(DbConnection Connection, DbTransaction Transaction, P_L3EV_SET_1106 Parameter, CSV2Core.SessionSecurity.SessionSecurityTicket securityTicket = null) { var returnValue = new FR_Guid(); var item = new ORM_CMN_STR_SCE_StructureCalendarEvent_Type(); if (Parameter.CMN_STR_SCE_StructureCalendarEvent_TypeID != Guid.Empty) { var result = item.Load(Connection, Transaction, Parameter.CMN_STR_SCE_StructureCalendarEvent_TypeID); if (result.Status != FR_Status.Success || item.CMN_STR_SCE_StructureCalendarEvent_TypeID == Guid.Empty) { var error = new FR_Guid(); error.ErrorMessage = "No Such ID"; error.Status = FR_Status.Error_Internal; return(error); } } if (Parameter.IsDeleted == true) { item.IsDeleted = true; return(new FR_Guid(item.Save(Connection, Transaction), item.CMN_STR_SCE_StructureCalendarEvent_TypeID)); } //Creation specific parameters (Tenant, Account ... ) if (Parameter.CMN_STR_SCE_StructureCalendarEvent_TypeID == Guid.Empty) { item.Tenant_RefID = securityTicket.TenantID; } item.CalendaEventName = Parameter.CalendaEventName; item.EventIcon_RefID = Parameter.EventIcon_RefID; item.PriorityOrdinal = Parameter.PriorityOrdinal; item.ColorCode_Foreground = Parameter.ColorCode_Foreground; item.ColorCode_Background = Parameter.ColorCode_Background; item.ColorCode_Alpha = Parameter.ColorCode_Alpha; item.IsShowingNotification = Parameter.IsShowingNotification; item.IsWorkingDay = Parameter.IsWorkingDay; item.IsHalfWorkingDay = Parameter.IsHalfWorkingDay; item.IsNonWorkingDay = Parameter.IsNonWorkingDay; item.IsEventType_Imported = Parameter.IsEventType_Imported; item.InternalEventTypeID = Parameter.InternalEventTypeID; return(new FR_Guid(item.Save(Connection, Transaction), item.CMN_STR_SCE_StructureCalendarEvent_TypeID)); }
protected static FR_Guid Execute(DbConnection Connection, DbTransaction Transaction, P_L5EM_SEARTFS_1356 Parameter, CSV2Core.SessionSecurity.SessionSecurityTicket securityTicket = null) { var returnValue = new FR_Guid(); var item = new ORM_CMN_BPT_EMP_Employee_AbsenceReason_TimeframeStatistic(); if (Parameter.CMN_BPT_EMP_Employee_AbsenceReason_TimeframeStatisticsID != Guid.Empty) { var result = item.Load(Connection, Transaction, Parameter.CMN_BPT_EMP_Employee_AbsenceReason_TimeframeStatisticsID); if (result.Status != FR_Status.Success || item.CMN_BPT_EMP_Employee_AbsenceReason_TimeframeStatisticsID == Guid.Empty) { var error = new FR_Guid(); error.ErrorMessage = "No Such ID"; error.Status = FR_Status.Error_Internal; return(error); } } if (Parameter.IsDeleted == true) { item.IsDeleted = true; return(new FR_Guid(item.Save(Connection, Transaction), item.CMN_BPT_EMP_Employee_AbsenceReason_TimeframeStatisticsID)); } //Creation specific parameters (Tenant, Account ... ) if (Parameter.CMN_BPT_EMP_Employee_AbsenceReason_TimeframeStatisticsID == Guid.Empty) { item.Tenant_RefID = securityTicket.TenantID; } item.CalculationTimeframe_RefID = Parameter.CalculationTimeframe_RefID; item.AbsenceReason_RefID = Parameter.AbsenceReason_RefID; item.Employee_RefID = Parameter.Employee_RefID; item.R_AbsenceCarryOver_InHours = Parameter.R_AbsenceCarryOver_InHours; item.R_AbsenceCarryOver_InDays = Parameter.R_AbsenceCarryOver_InDays; item.R_AbsenceTimeUsed_InHours = Parameter.R_AbsenceTimeUsed_InHours; item.R_AbsenceTimeUsed_InDays = Parameter.R_AbsenceTimeUsed_InDays; item.R_RequestReservedAbsence_InHours = Parameter.R_RequestReservedAbsence_InHours; item.R_RequestReservedAbsence_InDays = Parameter.R_RequestReservedAbsence_InDays; item.R_TotalAllowedAbsenceTime_InHours = Parameter.R_TotalAllowedAbsenceTime_InHours; item.R_TotalAllowedAbsenceTime_InDays = Parameter.R_TotalAllowedAbsenceTime_InDays; return(new FR_Guid(item.Save(Connection, Transaction), item.CMN_BPT_EMP_Employee_AbsenceReason_TimeframeStatisticsID)); }
protected static FR_Base Execute(DbConnection Connection, DbTransaction Transaction, P_L3TX_DTO_1148 Parameter, CSV2Core.SessionSecurity.SessionSecurityTicket securityTicket = null) { //Leave UserCode region to enable user code saving #region UserCode var returnValue = new FR_Base(); ORM_ACC_TAX_TaxOffice taxOffice = new ORM_ACC_TAX_TaxOffice(); if (Parameter.ACC_TAX_TaxOfficeID != Guid.Empty) { var result = taxOffice.Load(Connection, Transaction, Parameter.ACC_TAX_TaxOfficeID); if (result.Status != FR_Status.Success || taxOffice.ACC_TAX_TaxOfficeID == Guid.Empty) { var error = new FR_Guid(); error.ErrorMessage = "No Such ID."; error.Status = FR_Status.Error_Internal; return(error); } } taxOffice.IsDeleted = true; taxOffice.Save(Connection, Transaction); ORM_CMN_BPT_BusinessParticipant.Query bptQuery = new ORM_CMN_BPT_BusinessParticipant.Query(); bptQuery.CMN_BPT_BusinessParticipantID = taxOffice.CMN_BPT_BusinessParticipant_RefID; bptQuery.IsDeleted = false; bptQuery.Tenant_RefID = securityTicket.TenantID; ORM_CMN_BPT_BusinessParticipant bparticipant = ORM_CMN_BPT_BusinessParticipant.Query.Search(Connection, Transaction, bptQuery).FirstOrDefault(); bparticipant.IsDeleted = true; bparticipant.Save(Connection, Transaction); ORM_CMN_COM_CompanyInfo.Query cmpInfoQuery = new ORM_CMN_COM_CompanyInfo.Query(); cmpInfoQuery.CMN_COM_CompanyInfoID = bparticipant.IfCompany_CMN_COM_CompanyInfo_RefID; cmpInfoQuery.IsDeleted = false; cmpInfoQuery.Tenant_RefID = securityTicket.TenantID; ORM_CMN_COM_CompanyInfo companyInfo = ORM_CMN_COM_CompanyInfo.Query.Search(Connection, Transaction, cmpInfoQuery).FirstOrDefault(); companyInfo.IsDeleted = true; companyInfo.Save(Connection, Transaction); return(returnValue); #endregion UserCode }
protected static FR_Guid Execute(DbConnection Connection, DbTransaction Transaction, P_L5SR_PTSfSR Parameter, CSV2Core.SessionSecurity.SessionSecurityTicket securityTicket = null) { #region UserCode var returnValue = new FR_Guid(); var paramQCI = new P_L5SR_GQCIfRHId_1359() { HeaderID = Parameter.ReceiptHeaderID }; var qualityControlItems = cls_Get_QualityControlItems_for_ReceiptHeaderID.Invoke(Connection, Transaction, paramQCI, securityTicket).Result; Guid[] articleIDs = qualityControlItems.Select(x => x.ProductID).Distinct().ToArray(); var paramArticleStorage = new P_L3WH_GASfA_1924 { ArticleID_List = articleIDs }; var storages = CL3_Warehouse.Atomic.Retrieval.cls_Get_ArticleStorages_for_ArticleIDList.Invoke(Connection, Transaction, paramArticleStorage, securityTicket).Result. Where(x => x.QLShelfID != Guid.Empty && x.IsPointOfSalesArea == true); foreach (var item in qualityControlItems) { var shelf = storages.FirstOrDefault(x => x.ArticleID == item.ProductID); if (shelf == null || shelf.ShelfID == Guid.Empty) { continue; } var query = new CL1_LOG_RCP.ORM_LOG_RCP_Receipt_Position_QualityControlItem.Query { LOG_RCP_Receipt_Position_QualityControlItem = item.LOG_RCP_Receipt_Position_QualityControlItem, IsDeleted = false, Tenant_RefID = securityTicket.TenantID }; var values = new CL1_LOG_RCP.ORM_LOG_RCP_Receipt_Position_QualityControlItem.Query { Target_WRH_Shelf_RefID = shelf.ShelfID }; CL1_LOG_RCP.ORM_LOG_RCP_Receipt_Position_QualityControlItem.Query.Update(Connection, Transaction, query, values); } return(returnValue); #endregion UserCode }
protected static FR_Guid Execute(DbConnection Connection, DbTransaction Transaction, P_L6USR_SASL_1035 Parameter, CSV2Core.SessionSecurity.SessionSecurityTicket securityTicket = null) { #region UserCode var returnValue = new FR_Guid(); //Put your code here foreach (var appSettingToSave in Parameter.ListOfAppSettingsToSave) { P_L2USR_SAS_1039 param = new P_L2USR_SAS_1039(); param.USR_Account_ApplicationSettingID = appSettingToSave.ApplicationSettingID; param.ApplicationSetting_Definition_RefID = appSettingToSave.ApplicationSetting_Definition_RefID; param.ItemValue = appSettingToSave.ItemValue; param.Account_RefID = securityTicket.AccountID; cls_Save_USR_Account_ApplicationSetting.Invoke(Connection, Transaction, param, securityTicket); } return(returnValue); #endregion UserCode }
protected static FR_Guid Execute(DbConnection Connection, DbTransaction Transaction, P_L5AR_CDAtA_1238 Parameter, CSV2Core.SessionSecurity.SessionSecurityTicket securityTicket = null) { #region UserCode var returnValue = new FR_Guid(); //Put your code here var article = new ORM_CMN_PRO_Product(); article.Load(Connection, Transaction, Parameter.CMN_PRO_ProductID); var dummyArticle = new ORM_CMN_PRO_Product(); dummyArticle.Load(Connection, Transaction, Parameter.Dummy_ProductID); dummyArticle.ProductSuccessor_RefID = article.CMN_PRO_ProductID; dummyArticle.Save(Connection, Transaction); return(new FR_Guid(article.Save(Connection, Transaction), article.CMN_PRO_ProductID)); #endregion UserCode }
protected static FR_Guid Execute(DbConnection Connection, DbTransaction Transaction, P_L3BA_CATwBL_1315 Parameter, CSV2Core.SessionSecurity.SessionSecurityTicket securityTicket = null) { #region UserCode var returnValue = new FR_Guid(); #region Create new Accounting Transaction var accountingTransaction = new CL1_ACC_BOK.ORM_ACC_BOK_Accounting_Transaction { ACC_BOK_Accounting_TransactionID = Guid.NewGuid(), TransactionType_RefID = Parameter.AccountingTransactionTypeID, Comment = null, Creation_Timestamp = DateTime.Now, Tenant_RefID = securityTicket.TenantID }; accountingTransaction.Save(Connection, Transaction); #endregion #region Create booking lines foreach (var line in Parameter.BookingLines) { var bookingLine = new CL1_ACC_BOK.ORM_ACC_BOK_Accounting_BookingLine { ACC_BOK_Accounting_BookingLineID = Guid.NewGuid(), PartOfAccountingTransaction_RefID = accountingTransaction.ACC_BOK_Accounting_TransactionID, BookingAccount_RefID = line.BookingAccountID, TransactionValue = line.TransactionValue, DateOfTransaction = Parameter.DateOfTransaction, Currency_RefID = Parameter.CurrencyID, Creation_Timestamp = DateTime.Now, Tenant_RefID = securityTicket.TenantID }; bookingLine.Save(Connection, Transaction); } #endregion returnValue.Result = accountingTransaction.ACC_BOK_Accounting_TransactionID; return(returnValue); #endregion UserCode }
protected static FR_Guid Execute(DbConnection Connection, DbTransaction Transaction, P_L3DE_SD_1044 Parameter, CSV2Core.SessionSecurity.SessionSecurityTicket securityTicket = null) { //Leave UserCode region to enable user code saving #region UserCode var returnValue = new FR_Guid(); if (!Parameter.IsDelete) { ORM_PPS_DEV_Device device; if (Parameter.PPS_DEV_DeviceID == Guid.Empty) { device = new ORM_PPS_DEV_Device(); device.PPS_DEV_DeviceID = Guid.NewGuid(); device.Tenant_RefID = securityTicket.TenantID; } else { device = ORM_PPS_DEV_Device.Query.Search(Connection, Transaction, new ORM_PPS_DEV_Device.Query() { IsDeleted = false, Tenant_RefID = securityTicket.TenantID, PPS_DEV_DeviceID = Parameter.PPS_DEV_DeviceID }).Single(); } device.DeviceDisplayName = Parameter.DeviceDisplayName; device.Save(Connection, Transaction); returnValue.Result = device.PPS_DEV_DeviceID; } else { ORM_PPS_DEV_Device.Query.SoftDelete(Connection, Transaction, new ORM_PPS_DEV_Device.Query() { IsDeleted = false, Tenant_RefID = securityTicket.TenantID, PPS_DEV_DeviceID = Parameter.PPS_DEV_DeviceID }); } return(returnValue); #endregion UserCode }
protected static FR_Guid Execute(DbConnection Connection, DbTransaction Transaction, P_L5BK_SB_1320 Parameter, CSV2Core.SessionSecurity.SessionSecurityTicket securityTicket = null) { #region UserCode var returnValue = new FR_Guid(); var item = new ORM_ACC_BNK_Bank(); if (Parameter.ACC_BNK_BankID != Guid.Empty) { var result = item.Load(Connection, Transaction, Parameter.ACC_BNK_BankID); if (result.Status != FR_Status.Success || item.ACC_BNK_BankID == Guid.Empty) { var error = new FR_Guid(); error.ErrorMessage = "No Such ID"; error.Status = FR_Status.Error_Internal; return(error); } } item.BankName = Parameter.BankName; item.BankNumber = Parameter.BankNubmer; item.BICCode = Parameter.BICCode; item.RoutingNumber = Parameter.RoutingNumber; item.Tenant_RefID = securityTicket.TenantID; item.BankLocationComment = Parameter.BankLocationComment; ORM_CMN_Country.Query countryQuery = new ORM_CMN_Country.Query(); countryQuery.Country_ISOCode_Alpha2 = Parameter.Country_ISOCode_Alpha2; countryQuery.IsDeleted = false; countryQuery.Tenant_RefID = securityTicket.TenantID; List <ORM_CMN_Country> countries = ORM_CMN_Country.Query.Search(Connection, Transaction, countryQuery); if (countries.Count != 0) { item.Country_RefID = countries[0].CMN_CountryID; } item.Save(Connection, Transaction); returnValue.Result = item.ACC_BNK_BankID; //Put your code here return(returnValue); #endregion UserCode }
protected static FR_Guid Execute(DbConnection Connection, DbTransaction Transaction, P_L2_ST_1149 Parameter, CSV2Core.SessionSecurity.SessionSecurityTicket securityTicket = null) { var returnValue = new FR_Guid(); var item = new CL1_CMN.ORM_CMN_Tenant(); if (Parameter.CMN_TenantID != Guid.Empty) { var result = item.Load(Connection, Transaction, Parameter.CMN_TenantID); if (result.Status != FR_Status.Success || item.CMN_TenantID == Guid.Empty) { var error = new FR_Guid(); error.ErrorMessage = "No Such ID"; error.Status = FR_Status.Error_Internal; return(error); } } if (Parameter.IsDeleted == true) { item.IsDeleted = true; return(new FR_Guid(item.Save(Connection, Transaction), item.CMN_TenantID)); } //Creation specific parameters (Tenant, Account ... ) if (Parameter.CMN_TenantID == Guid.Empty) { item.Tenant_RefID = securityTicket.TenantID; } item.TenantITL = Parameter.TenantITL; item.UniversalContactDetail_RefID = Parameter.UniversalContactDetail_RefID; item.CMN_CAL_CalendarInstance_RefID = Parameter.CMN_CAL_CalendarInstance_RefID; item.IsUsing_Offices = Parameter.IsUsing_Offices; item.IsUsing_WorkAreas = Parameter.IsUsing_WorkAreas; item.IsUsing_Workplaces = Parameter.IsUsing_Workplaces; item.IsUsing_CostCenters = Parameter.IsUsing_CostCenters; item.CMN_BPT_STA_SettingProfile_RefID = Parameter.CMN_BPT_STA_SettingProfile_RefID; item.DocumentServerRootURL = Parameter.DocumentServerRootURL; item.Customers_DefaultPricelist_RefID = Parameter.Customers_DefaultPricelist_RefID; return(new FR_Guid(item.Save(Connection, Transaction), item.CMN_TenantID)); }
protected static FR_Guid Execute(DbConnection Connection, DbTransaction Transaction, P_L5PL_SPWD_1432 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 savePricelistParam = new P_L2PL_SP_1407(); savePricelistParam = Parameter.Save_CMN_SLS_Pricelist_Param; var savedPricelist = cls_Save_CMN_SLS_Pricelist.Invoke(Connection, Transaction, savePricelistParam, securityTicket).Result; var tenantQuery = new ORM_CMN_Tenant.Query(); tenantQuery.Tenant_RefID = securityTicket.TenantID; tenantQuery.CMN_TenantID = securityTicket.TenantID; var foundTenant = ORM_CMN_Tenant.Query.Search(Connection, Transaction, tenantQuery).Single(); if (foundTenant != null) { if (Parameter.IsDefault) { if (savePricelistParam.CMN_SLS_PricelistID != Guid.Empty) { foundTenant.Customers_DefaultPricelist_RefID = savePricelistParam.CMN_SLS_PricelistID; } else { foundTenant.Customers_DefaultPricelist_RefID = savedPricelist; } } else { foundTenant.Customers_DefaultPricelist_RefID = Guid.Empty; } foundTenant.Save(Connection, Transaction); } returnValue.Result = savedPricelist; return(returnValue); #endregion UserCode }
protected static FR_Guid Execute(DbConnection Connection, DbTransaction Transaction, P_L2B_SBA_0944 Parameter, CSV2Core.SessionSecurity.SessionSecurityTicket securityTicket = null) { var returnValue = new FR_Guid(); var item = new CL1_ACC_BNK.ORM_ACC_BNK_BankAccount(); if (Parameter.ACC_BNK_BankAccountID != Guid.Empty) { var result = item.Load(Connection, Transaction, Parameter.ACC_BNK_BankAccountID); if (result.Status != FR_Status.Success || item.ACC_BNK_BankAccountID == Guid.Empty) { var error = new FR_Guid(); error.ErrorMessage = "No Such ID"; error.Status = FR_Status.Error_Internal; return(error); } } if (Parameter.IsDeleted == true) { item.IsDeleted = true; return(new FR_Guid(item.Save(Connection, Transaction), item.ACC_BNK_BankAccountID)); } //Creation specific parameters (Tenant, Account ... ) if (Parameter.ACC_BNK_BankAccountID == Guid.Empty) { item.Tenant_RefID = securityTicket.TenantID; } item.Bank_RefID = Parameter.Bank_RefID; item.Currency_RefID = Parameter.Currency_RefID; item.IBAN = Parameter.IBAN; item.AccountNumber = Parameter.AccountNumber; item.BankAccountType_RefID = Parameter.BankAccountType_RefID; item.OwnerText = Parameter.OwnerText; item.AccountOpenedAtDate = Parameter.AccountOpenedAtDate; item.AccountClosedAtDate = Parameter.AccountClosedAtDate; item.IsValid = Parameter.IsValid; item.R_AccountBalance = Parameter.R_AccountBalance; return(new FR_Guid(item.Save(Connection, Transaction), item.ACC_BNK_BankAccountID)); }
protected static FR_Guid Execute(DbConnection Connection, DbTransaction Transaction, P_L2OC_SOC_1528 Parameter, CSV2Core.SessionSecurity.SessionSecurityTicket securityTicket = null) { var returnValue = new FR_Guid(); var item = new ORM_OCL_OrderCollective(); if (Parameter.OCL_OrderCollectiveID != Guid.Empty) { var result = item.Load(Connection, Transaction, Parameter.OCL_OrderCollectiveID); if (result.Status != FR_Status.Success || item.OCL_OrderCollectiveID == Guid.Empty) { var error = new FR_Guid(); error.ErrorMessage = "No Such ID"; error.Status = FR_Status.Error_Internal; return(error); } } if (Parameter.IsDeleted == true) { item.IsDeleted = true; return(new FR_Guid(item.Save(Connection, Transaction), item.OCL_OrderCollectiveID)); } if (Parameter.OCL_OrderCollectiveID == Guid.Empty) { item.Tenant_RefID = securityTicket.TenantID; } item.OrderCollectiveITL = Parameter.OrderCollectiveITL; item.OrderCollective_Name = new Dict(ORM_OCL_OrderCollective.TableName); var languages = ORM_CMN_Language.Query.Search(Connection, Transaction, new ORM_CMN_Language.Query { IsDeleted = false, Tenant_RefID = securityTicket.TenantID }); foreach (var lang in languages) { item.OrderCollective_Name.AddEntry(lang.CMN_LanguageID, Parameter.OrderCollective_Name); } return(new FR_Guid(item.Save(Connection, Transaction), item.OCL_OrderCollectiveID)); }
protected static FR_Base Execute(DbConnection Connection, DbTransaction Transaction, P_L5EW_DEWCS_0956 Parameter, CSV2Core.SessionSecurity.SessionSecurityTicket securityTicket = null) { #region UserCode var returnValue = new FR_Base(); ORM_CMN_BPT_EMP_ExtraWorkCalculation_Surcharge extraWorkCalculation = new ORM_CMN_BPT_EMP_ExtraWorkCalculation_Surcharge(); if (Parameter.CMN_BPT_EMP_ExtraWorkCalculation_SurchargeID != Guid.Empty) { var result = extraWorkCalculation.Load(Connection, Transaction, Parameter.CMN_BPT_EMP_ExtraWorkCalculation_SurchargeID); if (result.Status != FR_Status.Success || extraWorkCalculation.CMN_BPT_EMP_ExtraWorkCalculation_SurchargeID == Guid.Empty) { var error = new FR_Guid(); error.ErrorMessage = "No Such ID"; error.Status = FR_Status.Error_Internal; return(error); } } extraWorkCalculation.IsDeleted = true; extraWorkCalculation.Save(Connection, Transaction); ORM_CMN_BPT_EMP_ExtraWorkCalculation_Surcharge_StructureBinding.Query structureBindingQuery = new ORM_CMN_BPT_EMP_ExtraWorkCalculation_Surcharge_StructureBinding.Query(); structureBindingQuery.ExtraWorkCalculation_Surcharge_RefID = extraWorkCalculation.CMN_BPT_EMP_ExtraWorkCalculation_SurchargeID; structureBindingQuery.IsDeleted = false; structureBindingQuery.Tenant_RefID = securityTicket.TenantID; var structureBindings = ORM_CMN_BPT_EMP_ExtraWorkCalculation_Surcharge_StructureBinding.Query.Search(Connection, Transaction, structureBindingQuery); if (structureBindings.Count != 0) { var structureBinding = structureBindings.FirstOrDefault(); structureBinding.IsDeleted = true; structureBinding.Save(Connection, Transaction); } returnValue.Status = FR_Status.Success; return(returnValue); #endregion UserCode }
protected static FR_Guid Execute(DbConnection Connection, DbTransaction Transaction, P_L2CA_SCPER_1105 Parameter, CSV2Core.SessionSecurity.SessionSecurityTicket securityTicket = null) { var returnValue = new FR_Guid(); var item = new ORM_CMN_BPT_CTM_CatalogProductExtensionRequests(); if (Parameter.CMN_BPT_CTM_CatalogProductExtensionRequestID != Guid.Empty) { var result = item.Load(Connection, Transaction, Parameter.CMN_BPT_CTM_CatalogProductExtensionRequestID); if (result.Status != FR_Status.Success || item.CMN_BPT_CTM_CatalogProductExtensionRequestID == Guid.Empty) { var error = new FR_Guid(); error.ErrorMessage = "No Such ID"; error.Status = FR_Status.Error_Internal; return(error); } } if (Parameter.IsDeleted == true) { item.IsDeleted = true; return(new FR_Guid(item.Save(Connection, Transaction), item.CMN_BPT_CTM_CatalogProductExtensionRequestID)); } //Creation specific parameters (Tenant, Account ... ) if (Parameter.CMN_BPT_CTM_CatalogProductExtensionRequestID == Guid.Empty) { item.Tenant_RefID = securityTicket.TenantID; } item.CatalogProductExtensionRequestITL = Parameter.CatalogProductExtensionRequestITL; item.RequestedBy_Customer_BusinessParticipant_RefID = Parameter.RequestedBy_Customer_BusinessParticipant_RefID; item.RequestedBy_Person_BusinessParticipant_RefID = Parameter.RequestedBy_Person_BusinessParticipant_RefID; item.RequestedFor_Catalog_RefID = Parameter.RequestedFor_Catalog_RefID; item.Request_Question = Parameter.Request_Question; item.Request_Answer = Parameter.Request_Answer; item.IsAnswerSent = Parameter.IsAnswerSent; item.IfAnswerSent_By_BusinessParticipant_RefID = Parameter.IfAnswerSent_By_BusinessParticipant_RefID; item.IfAnswerSent_Date = Parameter.IfAnswerSent_Date; return(new FR_Guid(item.Save(Connection, Transaction), item.CMN_BPT_CTM_CatalogProductExtensionRequestID)); }
protected static FR_Guid Execute(DbConnection Connection, DbTransaction Transaction, P_L2BN_SBNfBH_1630 Parameter, CSV2Core.SessionSecurity.SessionSecurityTicket securityTicket = null) { #region UserCode var returnValue = new FR_Guid(); //Put your code here var account = new ORM_USR_Account(); account.Load(Connection, Transaction, securityTicket.AccountID); var note = new CL1_BIL.ORM_BIL_Note(); if (Parameter.NoteID != Guid.Empty) { var result = note.Load(Connection, Transaction, Parameter.NoteID); } else { note.Tenant_RefID = securityTicket.TenantID; note.BIL_Note = Guid.NewGuid(); note.Creation_Timestamp = DateTime.Now; note.CreatedBy_BusinessParticipant_RefID = account.BusinessParticipant_RefID; } if (Parameter.IsDeleted == true) { note.IsDeleted = true; return(new FR_Guid(note.Save(Connection, Transaction), note.BIL_Note)); } if (Parameter.BillHeaderID != Guid.Empty) { note.BillHeader_RefID = Parameter.BillHeaderID; } note.NoteText = Parameter.NoteText == null ? String.Empty : Parameter.NoteText; note.Title = Parameter.NoteTitle == null ? String.Empty : Parameter.NoteTitle; note.SequenceOrderNumber = Parameter.SequenceOrderNumber; note.Save(Connection, Transaction); returnValue.Result = note.BIL_Note; return(returnValue); #endregion UserCode }
protected static FR_Guid Execute(DbConnection Connection, DbTransaction Transaction, P_L5BD_SBI_1360 Parameter, CSV2Core.SessionSecurity.SessionSecurityTicket securityTicket = null) { #region UserCode var returnValue = new FR_Guid(); //Put your code here ORM_DOC_Structure structure = new ORM_DOC_Structure(); structure.Structure_Header_RefID = Parameter.DOC_StructureHeaderRefID; structure.CreatedBy_Account_RefID = securityTicket.AccountID; structure.Tenant_RefID = securityTicket.TenantID; structure.Save(Connection, Transaction); ORM_DOC_Document document = new ORM_DOC_Document(); document.Tenant_RefID = securityTicket.TenantID; document.Save(Connection, Transaction); ORM_DOC_Document_2_Structure documentStructure = new ORM_DOC_Document_2_Structure(); documentStructure.Document_RefID = document.DOC_DocumentID; documentStructure.Structure_RefID = structure.DOC_StructureID; documentStructure.StructureHeader_RefID = Parameter.DOC_StructureHeaderRefID; documentStructure.Tenant_RefID = securityTicket.TenantID; documentStructure.Save(Connection, Transaction); ORM_DOC_DocumentRevision documentRevision = new ORM_DOC_DocumentRevision(); documentRevision.DOC_DocumentRevisionID = Parameter.DocumentID; documentRevision.Document_RefID = document.DOC_DocumentID; documentRevision.File_Name = Parameter.File_Name; documentRevision.File_Description = Parameter.File_Description; documentRevision.File_SourceLocation = Parameter.File_SourceLocation; documentRevision.File_ServerLocation = Parameter.File_ServerLocation; documentRevision.File_MIMEType = Parameter.File_MIMEType; documentRevision.File_Extension = Parameter.File_Extension; documentRevision.File_Size_Bytes = Parameter.File_Size_Bytes; documentRevision.UploadedByAccount = securityTicket.AccountID; documentRevision.Tenant_RefID = securityTicket.TenantID; documentRevision.Save(Connection, Transaction); returnValue.Result = documentRevision.DOC_DocumentRevisionID; return(returnValue); #endregion UserCode }
protected static FR_Guid Execute(DbConnection Connection, DbTransaction Transaction, P_L3AC_SACUH_1003 Parameter, CSV2Core.SessionSecurity.SessionSecurityTicket securityTicket = null) { //Leave UserCode region to enable user code saving #region UserCode var returnValue = new FR_Guid(); ORM_USR_Device_AccountCode_UsageHistory item = new ORM_USR_Device_AccountCode_UsageHistory(); item.Creation_Timestamp = DateTime.Now; item.IsDeleted = false; item.Device_AccountCode_RefID = Parameter.Device_AccountCodeID; item.Tenant_RefID = Parameter.TenantID; item.UsedBy_BrowserAgent = Parameter.UsedBy_BrowserAgent; item.UsedBy_ExternalAddress = Parameter.UsedBy_ExternalAddress; item.Save(Connection, Transaction); returnValue.Result = item.USR_Device_AccountCode_UsageHistoryID; return(returnValue); #endregion UserCode }
protected static FR_Guid Execute(DbConnection Connection, DbTransaction Transaction, P_L5MC_AGR_1140 Parameter, CSV2Core.SessionSecurity.SessionSecurityTicket securityTicket = null) { #region UserCode var returnValue = new FR_Guid(); var query = new ORM_HEC_CMT_OfferedRole.Query(); query.GlobalPropertyMatchingID = Parameter.GlobalPropertyMatchingID; query.IsDeleted = false; query.Tenant_RefID = securityTicket.TenantID; var role = ORM_HEC_CMT_OfferedRole.Query.Search(Connection, Transaction, query).Single(); var m2g = ORM_HEC_CMT_GroupSubscription.Query.Search(Connection, Transaction, new ORM_HEC_CMT_GroupSubscription.Query() { Tenant_RefID = securityTicket.TenantID, Membership_RefID = Parameter.HEC_CMT_MembershipID, CommunityGroup_RefID = Parameter.HEC_CMT_CommunityGroupID, IsDeleted = false }).Single(); var r2gs = ORM_HEC_CMT_OfferedRoles_2_GroupSubscription.Query.Search(Connection, Transaction, new ORM_HEC_CMT_OfferedRoles_2_GroupSubscription.Query() { Tenant_RefID = securityTicket.TenantID, HEC_CMT_GroupSubscription_RefID = m2g.HEC_CMT_GroupSubscriptionID, HEC_CMT_OfferedRole_RefID = role.HEC_CMT_OfferedRoleID, IsDeleted = false }).SingleOrDefault(); if (r2gs == null) { r2gs = new ORM_HEC_CMT_OfferedRoles_2_GroupSubscription() { Tenant_RefID = securityTicket.TenantID, AssignmentID = Guid.NewGuid(), HEC_CMT_GroupSubscription_RefID = m2g.HEC_CMT_GroupSubscriptionID, HEC_CMT_OfferedRole_RefID = role.HEC_CMT_OfferedRoleID }; r2gs.Save(Connection, Transaction); } return(returnValue); #endregion UserCode }
protected static FR_Guid Execute(DbConnection Connection, DbTransaction Transaction, P_L2BH_SOPSSBH_1515 Parameter, CSV2Core.SessionSecurity.SessionSecurityTicket securityTicket = null) { var returnValue = new FR_Guid(); var item = new ORM_ORD_PRC_SPB_SupplierBill_Header(); if (Parameter.ORD_PRC_SPB_SupplierBill_HeaderID != Guid.Empty) { var result = item.Load(Connection, Transaction, Parameter.ORD_PRC_SPB_SupplierBill_HeaderID); if (result.Status != FR_Status.Success || item.ORD_PRC_SPB_SupplierBill_HeaderID == Guid.Empty) { var error = new FR_Guid(); error.ErrorMessage = "No Such ID"; error.Status = FR_Status.Error_Internal; return(error); } } if (Parameter.IsDeleted == true) { item.IsDeleted = true; return(new FR_Guid(item.Save(Connection, Transaction), item.ORD_PRC_SPB_SupplierBill_HeaderID)); } //Creation specific parameters (Tenant, Account ... ) if (Parameter.ORD_PRC_SPB_SupplierBill_HeaderID == Guid.Empty) { item.Tenant_RefID = securityTicket.TenantID; } item.Supplier_RefID = Parameter.Supplier_RefID; item.Currency_RefID = Parameter.Currency_RefID; item.SupplierBillNumber = Parameter.SupplierBillNumber; item.DateOnBill = Parameter.DateOnBill; item.TotalValue_BeforeTax = Parameter.TotalValue_BeforeTax; item.TotalValue_IncludingTax = Parameter.TotalValue_IncludingTax; item.BillComment = Parameter.BillComment; item.PaymentTargetDate = Parameter.PaymentTargetDate; item.CashDiscountInPercent = Parameter.CashDiscountInPercent; return(new FR_Guid(item.Save(Connection, Transaction), item.ORD_PRC_SPB_SupplierBill_HeaderID)); }
protected static FR_Guid Execute(DbConnection Connection, DbTransaction Transaction, P_L2BD_SADDP_1412 Parameter, CSV2Core.SessionSecurity.SessionSecurityTicket securityTicket = null) { var returnValue = new FR_Guid(); var item = new CL1_ACC_DUN.ORM_ACC_DUN_DunningProcess(); if (Parameter.ACC_DUN_DunningProcessID != Guid.Empty) { var result = item.Load(Connection, Transaction, Parameter.ACC_DUN_DunningProcessID); if (result.Status != FR_Status.Success || item.ACC_DUN_DunningProcessID == Guid.Empty) { var error = new FR_Guid(); error.ErrorMessage = "No Such ID"; error.Status = FR_Status.Error_Internal; return(error); } } if (Parameter.IsDeleted == true) { item.IsDeleted = true; return(new FR_Guid(item.Save(Connection, Transaction), item.ACC_DUN_DunningProcessID)); } //Creation specific parameters (Tenant, Account ... ) if (Parameter.ACC_DUN_DunningProcessID == Guid.Empty) { item.Tenant_RefID = securityTicket.TenantID; } item.DunnedCustomer_RefID = Parameter.DunnedCustomer_RefID; item.DunningModel_RefID = Parameter.DunningModel_RefID; item.Currency_RefID = Parameter.Currency_RefID; item.Current_DunningLevel_RefID = Parameter.Current_DunningLevel_RefID; item.DunnedAmount_Total = Parameter.DunnedAmount_Total; item.ReachesNextDunningLevelAtDate = Parameter.ReachesNextDunningLevelAtDate; item.IsDunningProcessClosed = Parameter.IsDunningProcessClosed; item.DunningProcessClosedAt_Date = Parameter.DunningProcessClosedAt_Date; item.DunningProcessClosedBy_BusinessParticipnant_RefID = Parameter.DunningProcessClosedBy_BusinessParticipnant_RefID; return(new FR_Guid(item.Save(Connection, Transaction), item.ACC_DUN_DunningProcessID)); }
protected static FR_Guid Execute(DbConnection Connection, DbTransaction Transaction, P_L5PR_DPR_1501 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 ORM_TMS_PRO_Project item = new ORM_TMS_PRO_Project(); if (Parameter.TMS_PRO_ProjectID != Guid.Empty) { var result = item.Load(Connection, Transaction, Parameter.TMS_PRO_ProjectID); if (result.Status != FR_Status.Success || item.TMS_PRO_ProjectID == Guid.Empty) { var error = new FR_Guid(); error.ErrorMessage = "No Such ID"; error.Status = FR_Status.Error_Internal; return(error); } } ORM_TMS_PRO_Project_2_ProjectGroup.Query project2ProjectGroupQuery = new ORM_TMS_PRO_Project_2_ProjectGroup.Query(); project2ProjectGroupQuery.TMS_PRO_Project_RefID = item.TMS_PRO_ProjectID; project2ProjectGroupQuery.Tenant_RefID = securityTicket.TenantID; project2ProjectGroupQuery.IsDeleted = false; ORM_TMS_PRO_Project_2_ProjectGroup project2ProjectGroup = new ORM_TMS_PRO_Project_2_ProjectGroup(); var queryRes = ORM_TMS_PRO_Project_2_ProjectGroup.Query.Search(Connection, Transaction, project2ProjectGroupQuery); if (queryRes != null) { project2ProjectGroup = queryRes.FirstOrDefault(); project2ProjectGroup.IsDeleted = true; project2ProjectGroup.Save(Connection, Transaction); } item.IsDeleted = true; item.Save(Connection, Transaction); return(returnValue); #endregion UserCode }
protected static FR_Guid Execute(DbConnection Connection, DbTransaction Transaction, P_L5CA_UfC_1352 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 ORM_CMN_PRO_SubscribedCatalog catalog = new ORM_CMN_PRO_SubscribedCatalog(); catalog.Load(Connection, Transaction, Parameter.SubscribedCatalogID); catalog.IsDeleted = true; catalog.Save(Connection, Transaction); ORM_CMN_PRO_Product.Query productsQuery = new ORM_CMN_PRO_Product.Query() { IsDeleted = false, IsImportedFromExternalCatalog = true, IfImportedFromExternalCatalog_CatalogSubscription_RefID = Parameter.SubscribedCatalogID, Tenant_RefID = securityTicket.TenantID }; var products = ORM_CMN_PRO_Product.Query.Search(Connection, Transaction, productsQuery); if (products != null && products.Count > 0) { foreach (var product in products) { product.IsProductAvailableForOrdering = false; product.Save(Connection, Transaction); ORM_CMN_PRO_Product_Variant.Query variantsQuery = new ORM_CMN_PRO_Product_Variant.Query() { CMN_PRO_Product_RefID = product.CMN_PRO_ProductID, Tenant_RefID = securityTicket.TenantID }; var variants = ORM_CMN_PRO_Product_Variant.Query.Search(Connection, Transaction, variantsQuery).ToList(); foreach (var variant in variants) { variant.IsProductAvailableForOrdering = false; variant.Save(Connection, Transaction); } } } return(returnValue); #endregion UserCode }
protected static FR_Guid Execute(DbConnection Connection, DbTransaction Transaction, P_L5HI_SHIS_1500 Parameter, CSV2Core.SessionSecurity.SessionSecurityTicket securityTicket = null) { #region UserCode var returnValue = new FR_Guid(); ORM_HEC_Patient_HealthInsurance_State item; if (Parameter.HEC_Patient_HealthInsurance_StateID != Guid.Empty) { if (Parameter.IsDeleted) { ORM_HEC_Patient_HealthInsurance_State.Query.SoftDelete(Connection, Transaction, new ORM_HEC_Patient_HealthInsurance_State.Query() { Tenant_RefID = securityTicket.TenantID, IsDeleted = false, HEC_Patient_HealthInsurance_StateID = Parameter.HEC_Patient_HealthInsurance_StateID }); return(returnValue); } item = ORM_HEC_Patient_HealthInsurance_State.Query.Search(Connection, Transaction, new ORM_HEC_Patient_HealthInsurance_State.Query() { Tenant_RefID = securityTicket.TenantID, IsDeleted = false, HEC_Patient_HealthInsurance_StateID = Parameter.HEC_Patient_HealthInsurance_StateID }).Single(); } else { item = new ORM_HEC_Patient_HealthInsurance_State(); item.HEC_Patient_HealthInsurance_StateID = Guid.NewGuid(); item.Tenant_RefID = securityTicket.TenantID; } item.HealthInsuranceState_Abbreviation = Parameter.HealthInsuranceState_Abbreviation; item.HealthInsuranceState_Name = Parameter.HealthInsuranceState_Name; item.Save(Connection, Transaction); returnValue.Result = item.HEC_Patient_HealthInsurance_StateID; return(returnValue); #endregion UserCode }
protected static FR_Guid Execute(DbConnection Connection, DbTransaction Transaction, P_L6PA_CNBBVPfP_1059 Parameter, CSV2Core.SessionSecurity.SessionSecurityTicket securityTicket = null) { #region UserCode var returnValue = new FR_Guid(); if (Parameter == null || Parameter.Documents == null) { return(null); } P_L6PA_SBBVP_1223 savePatientParam = new P_L6PA_SBBVP_1223(); var patientID = cls_Save_BBV_Patient.Invoke(Connection, Transaction, savePatientParam, securityTicket).Result; if (patientID == Guid.Empty) { return(null); } else { P_L6PA_SBBVPP_1434 savePolicyParam = new P_L6PA_SBBVPP_1434(); savePolicyParam.HEC_PatientID = patientID; var docList = new List <P_L6PA_SBBVPP_1434_Document>(); foreach (var item in Parameter.Documents) { P_L6PA_SBBVPP_1434_Document P_L6PA_SBBVPP_1434_Document = new P_L6PA_SBBVPP_1434_Document(); P_L6PA_SBBVPP_1434_Document.File_Extension = item.File_Extension; P_L6PA_SBBVPP_1434_Document.File_Name = item.File_Name; P_L6PA_SBBVPP_1434_Document.File_ServerLocation = item.File_ServerLocation; P_L6PA_SBBVPP_1434_Document.File_Size_Bytes = item.File_Size_Bytes; P_L6PA_SBBVPP_1434_Document.DocSlot_GlobalPropertyMatching = item.DocSlot_GlobalPropertyMatching; docList.Add(P_L6PA_SBBVPP_1434_Document); } savePolicyParam.Documents = docList.ToArray(); var savePolicyRes = cls_Save_BBV_PatientPolicy.Invoke(Connection, Transaction, savePolicyParam, securityTicket).Result; returnValue.Result = patientID; } return(returnValue); #endregion UserCode }