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
}
