protected static FR_Guid Execute(DbConnection Connection, DbTransaction Transaction, P_L3PG_SCBITCL_0321 Parameter, CSV2Core.SessionSecurity.SessionSecurityTicket securityTicket = null) { //Leave UserCode region to enable user code saving #region UserCode var returnValue = new FR_Guid(); var item = new ORM_CMN_BPT_InvestedWorkTime_ChargingLevel(); if (Parameter.CMN_BPT_InvestedWorkTime_ChargingLevelID != Guid.Empty) { var result = item.Load(Connection, Transaction, Parameter.CMN_BPT_InvestedWorkTime_ChargingLevelID); if (result.Status != FR_Status.Success || item.CMN_BPT_InvestedWorkTime_ChargingLevelID == Guid.Empty) { var error = new FR_Guid(); error.ErrorMessage = "No Such ID"; error.Status = FR_Status.Error_Internal; return(error); } } if (Parameter.IsDeleted == true) { //TODO: } else { item.CMN_BPT_InvestedWorkTime_ChargingLevelID = Parameter.CMN_BPT_InvestedWorkTime_ChargingLevelID; item.CMN_PRO_Product_Release_RefID = Parameter.CMN_PRO_Product_Release_RefID; item.CMN_PRO_Product_Variant_RefID = Parameter.CMN_PRO_Product_Variant_RefID; item.ChangingLevel_Name = Parameter.ChangingLevel_Name; item.CMN_PRO_Product_RefID = Parameter.CMN_PRO_Product_RefID; item.Creation_Timestamp = DateTime.Now; item.IsDeleted = false; item.Tenant_RefID = securityTicket.TenantID; } return(new FR_Guid(item.Save(Connection, Transaction), item.CMN_BPT_InvestedWorkTime_ChargingLevelID)); #endregion UserCode }
protected static FR_Guid Execute(DbConnection Connection, DbTransaction Transaction, P_L6DTPG_SCL_1016 Parameter, CSV2Core.SessionSecurity.SessionSecurityTicket securityTicket = null) { #region UserCode var returnValue = new FR_Guid(); var item = new ORM_CMN_BPT_InvestedWorkTime_ChargingLevel(); #region Unnecessary if (Parameter.CMN_BPT_InvestedWorkTime_ChargingLevelID != Guid.Empty) { var result = item.Load(Connection, Transaction, Parameter.CMN_BPT_InvestedWorkTime_ChargingLevelID); if (result.Status != FR_Status.Success || item.CMN_BPT_InvestedWorkTime_ChargingLevelID == Guid.Empty) { var error = new FR_Guid(); error.ErrorMessage = "No Such ID"; error.Status = FR_Status.Error_Internal; return(error); } if (Parameter.ChargingLevelName != null) { item.ChangingLevel_Name = Parameter.ChargingLevelName; } item.Save(Connection, Transaction); ORM_CMN_SLS_Price.Query priceQuery = new ORM_CMN_SLS_Price.Query(); priceQuery.Tenant_RefID = securityTicket.TenantID; priceQuery.IsDeleted = false; priceQuery.CMN_PRO_Product_RefID = item.CMN_PRO_Product_RefID; List <ORM_CMN_SLS_Price> prices = ORM_CMN_SLS_Price.Query.Search(Connection, Transaction, priceQuery); if (prices != null && prices.Count == 1) { ORM_CMN_SLS_Price price = prices[0]; price.PriceAmount = Parameter.PricePerMinute; price.CMN_Currency_RefID = Parameter.CurrencyID; price.Save(Connection, Transaction); } } else { var structureHeader = new ORM_DOC_Structure_Header(); structureHeader.Label = "document_header_for_product"; structureHeader.Tenant_RefID = securityTicket.TenantID; var structureStatusSave = structureHeader.Save(Connection, Transaction); ORM_CMN_PRO_Product product = new ORM_CMN_PRO_Product(); product.Product_Name = Parameter.ChargingLevelName; product.Product_DocumentationStructure_RefID = structureHeader.DOC_Structure_HeaderID; product.Product_Number = "product_number"; product.Tenant_RefID = securityTicket.TenantID; product.Save(Connection, Transaction); ORM_CMN_BPT_InvestedWorkTime_ChargingLevel charginglevel = new ORM_CMN_BPT_InvestedWorkTime_ChargingLevel(); charginglevel.ChangingLevel_Name = Parameter.ChargingLevelName; charginglevel.CMN_PRO_Product_RefID = product.CMN_PRO_ProductID; charginglevel.Tenant_RefID = securityTicket.TenantID; charginglevel.Save(Connection, Transaction); ORM_CMN_SLS_Price price = new ORM_CMN_SLS_Price(); price.CMN_Currency_RefID = Parameter.CurrencyID; price.CMN_PRO_Product_RefID = product.CMN_PRO_ProductID; price.PriceAmount = Parameter.PricePerMinute; price.Tenant_RefID = securityTicket.TenantID; price.Save(Connection, Transaction); } #endregion return(returnValue); #endregion UserCode }