protected static FR_Guid Execute(DbConnection Connection, DbTransaction Transaction, P_L5OD_ADRP_1502 Parameter, CSV2Core.SessionSecurity.SessionSecurityTicket securityTicket = null) { //Leave UserCode region to enable user code saving #region UserCode var returnValue = new FR_Guid(); foreach (var CMN_PRO_ProductID in Parameter.CMN_PRO_ProductID_List) { var query = new ORM_HEC_Doctor_RequiredProduct.Query(); query.CMN_PRO_Product_RefID = CMN_PRO_ProductID; query.HEC_Doctor_RefID = Parameter.HEC_Doctor_RefID; var assignment = ORM_HEC_Doctor_RequiredProduct.Query.Search(Connection, Transaction, query); if (assignment != null && assignment.Count() != 0) { ORM_HEC_Doctor_RequiredProduct.Query.SoftRecover(Connection, Transaction, query); } else { var newAssignment = new ORM_HEC_Doctor_RequiredProduct(); newAssignment.HEC_Doctor_RequiredProductID = Guid.NewGuid(); newAssignment.CMN_PRO_Product_RefID = CMN_PRO_ProductID; newAssignment.HEC_Doctor_RefID = Parameter.HEC_Doctor_RefID; newAssignment.Tenant_RefID = securityTicket.TenantID; newAssignment.Creation_Timestamp = DateTime.Now; newAssignment.Save(Connection, Transaction); } } return(returnValue); #endregion UserCode }
protected static FR_Guid Execute(DbConnection Connection, DbTransaction Transaction, P_L5OD_DDRP_1242 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_HEC_Doctor_RequiredProduct(); var result = item.Load(Connection, Transaction, Parameter.HEC_Doctor_RequiredProductID); if (result.Status != FR_Status.Success || item.HEC_Doctor_RequiredProductID == Guid.Empty) { var error = new FR_Guid(); error.ErrorMessage = "No Such ID"; error.Status = FR_Status.Error_Internal; return(error); } item.IsDeleted = true; item.Save(Connection, Transaction); return(returnValue); #endregion UserCode }