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
}
