protected static FR_L5AWSSC_CUPfSCBO_1414 Execute(DbConnection Connection, DbTransaction Transaction, P_L5AWSSC_CUPfSCBO_1414 Parameter, CSV2Core.SessionSecurity.SessionSecurityTicket securityTicket = null)
{
#region UserCode
var returnValue = new FR_L5AWSSC_CUPfSCBO_1414();
returnValue.Result = new L5AWSSC_CUPfSCBO_1414();
// Get shopping cart
var shoppingCart = new CL1_ORD_PRC.ORM_ORD_PRC_ShoppingCart();
shoppingCart.Load(Connection, Transaction, Parameter.ORD_PRC_ShoppingCartID);
// Check does current user has a privilege to order ABDA articles
var flrParam = new CL2_FunctionLevelRight.Complex.Retrieval.P_L2FLR_GFLRfABoIoG_1554();
flrParam.AccountFunctionLevelRightGroup = new string[1] {
DLCore_DBCommons.Utils.EnumUtils.GetEnumDescription(EAccountFunctionLevelRightGroup.APOWebShop)
};
var levels = CL2_FunctionLevelRight.Complex.Retrieval.cls_Get_FunctionalLevelRight_for_Account_Based_on_Individuals_or_Groups.Invoke(Connection, Transaction, flrParam, securityTicket);
EAccountFunctionLevelRight maxLevel = EAccountFunctionLevelRight.APOWebShopLevel1;
foreach (var str in levels.Result)
{
EAccountFunctionLevelRight l = (EAccountFunctionLevelRight)DLCore_DBCommons.Utils.EnumUtils.GetEnumValueByDescription(str.RightLevel, typeof(EAccountFunctionLevelRight));
if ((int)l > (int)maxLevel)
{
maxLevel = l;
}
}
switch (maxLevel)
{
case EAccountFunctionLevelRight.APOWebShopLevel1:
returnValue.Result.HasPrivileges = false;
returnValue.Result.CreateApprovalShoppingCart = true;
break;
case EAccountFunctionLevelRight.APOWebShopLevel2:
returnValue.Result.HasPrivileges = true;
returnValue.Result.CreateApprovalShoppingCart = true;
break;
case EAccountFunctionLevelRight.APOWebShopLevel3:
returnValue.Result.HasPrivileges = true;
break;
}
return(returnValue);
#endregion UserCode
}
protected static FR_Guid Execute(DbConnection Connection, DbTransaction Transaction, P_L5AWSSC_ASC_1414 Parameter, CSV2Core.SessionSecurity.SessionSecurityTicket securityTicket = null)
{
#region UserCode
var returnValue = new FR_Guid();
#region Shopping cart
// Get shopping cart
var shoppingCart = new CL1_ORD_PRC.ORM_ORD_PRC_ShoppingCart();
shoppingCart.Load(Connection, Transaction, Parameter.ORD_PRC_ShoppingCartID);
// Get shopping cart status
var status = CL1_ORD_PRC.ORM_ORD_PRC_ShoppingCart_Status.Query.Search(Connection, Transaction,
new CL1_ORD_PRC.ORM_ORD_PRC_ShoppingCart_Status.Query()
{
GlobalPropertyMatchingID = DLCore_DBCommons.Utils.EnumUtils.GetEnumDescription(DLCore_DBCommons.APODemand.EShoppingCartStatus.Approved),
Tenant_RefID = securityTicket.TenantID,
IsDeleted = false
}).Single();
// Create and save new shopping cart history
var shoppingHistory = new CL1_ORD_PRC.ORM_ORD_PRC_ShoppingCartStatus_History();
shoppingHistory.ORD_PRC_ShoppingCart_RefID = shoppingCart.ORD_PRC_ShoppingCartID;
shoppingHistory.ORD_PRC_ShoppingCart_Status_RefID = status.ORD_PRC_ShoppingCart_StatusID;
shoppingHistory.PerformedBy_Account_RefID = securityTicket.AccountID;
shoppingHistory.Tenant_RefID = securityTicket.TenantID;
shoppingHistory.Save(Connection, Transaction);
// Save shopping cart
shoppingCart.IsProcurementOrderCreated = false;
shoppingCart.ShoppingCart_CurrentStatus_RefID = status.ORD_PRC_ShoppingCart_StatusID;
shoppingCart.Save(Connection, Transaction);
#endregion
return(returnValue);
#endregion UserCode
}
protected static FR_Bool Execute(DbConnection Connection, DbTransaction Transaction, CSV2Core.SessionSecurity.SessionSecurityTicket securityTicket = null)
{
#region UserCode
var returnValue = new FR_Bool();
// Get shopping cart status - Ordered
var statusOrdered = CL1_ORD_PRC.ORM_ORD_PRC_ShoppingCart_Status.Query.Search(Connection, Transaction,
new CL1_ORD_PRC.ORM_ORD_PRC_ShoppingCart_Status.Query()
{
GlobalPropertyMatchingID = DLCore_DBCommons.Utils.EnumUtils.GetEnumDescription(DLCore_DBCommons.APODemand.EShoppingCartStatus.Ordered),
Tenant_RefID = securityTicket.TenantID,
IsDeleted = false
}).Single();
var tenant = securityTicket.TenantID;
#region Find All Shopping Carts in Approved state for TenantID
//var approvedShoppingCarts =
var scParam = new CL5_APOWebShop_ShoppingCart.Atomic.Retrieval.P_L5AWSSC_GASC_1413()
{
Status_GlobalPropertyMatchingID_List = new string[] { DLCore_DBCommons.Utils.EnumUtils.GetEnumDescription(DLCore_DBCommons.APODemand.EShoppingCartStatus.Approved) }
};
var approvedShoppingCarts = CL5_APOWebShop_ShoppingCart.Atomic.Retrieval.cls_Get_All_ShoppingCarts.Invoke(Connection, Transaction, scParam, securityTicket).Result;
if (approvedShoppingCarts == null || approvedShoppingCarts.Count() == 0)
{
returnValue.Result = false;
return(returnValue);
}
#endregion
#region Procurement Order
// Get procurement order status
var procurementOrderStatus = CL1_ORD_PRC.ORM_ORD_PRC_ProcurementOrder_Status.Query.Search(Connection, Transaction,
new CL1_ORD_PRC.ORM_ORD_PRC_ProcurementOrder_Status.Query()
{
GlobalPropertyMatchingID = DLCore_DBCommons.Utils.EnumUtils.GetEnumDescription(DLCore_DBCommons.APODemand.EProcurementStatus.Active),
Tenant_RefID = securityTicket.TenantID,
IsDeleted = false
}).Single();
var account = new CL1_USR.ORM_USR_Account();
account.Load(Connection, Transaction, securityTicket.AccountID);
// Find last added procurement order header
var lastProcurementOrderHeader = CL1_ORD_PRC.ORM_ORD_PRC_ProcurementOrder_Header.Query.Search(Connection, Transaction,
new CL1_ORD_PRC.ORM_ORD_PRC_ProcurementOrder_Header.Query
{
Tenant_RefID = securityTicket.TenantID
}).OrderByDescending(x => Convert.ToInt64(x.ProcurementOrder_Number)).FirstOrDefault();
// Find last procurement order number
long procurementOrderNumber = 0;
if (lastProcurementOrderHeader != null)
{
procurementOrderNumber = Convert.ToInt64(lastProcurementOrderHeader.ProcurementOrder_Number);
}
// Create procurement order header
var procurementOrderHeader = new CL1_ORD_PRC.ORM_ORD_PRC_ProcurementOrder_Header();
procurementOrderHeader.Tenant_RefID = securityTicket.TenantID;
procurementOrderHeader.CreatedBy_BusinessParticipant_RefID = account.BusinessParticipant_RefID;
procurementOrderHeader.Current_ProcurementOrderStatus_RefID = procurementOrderStatus.ORD_PRC_ProcurementOrder_StatusID;
procurementOrderHeader.ProcurementOrder_Supplier_RefID = Guid.Empty;
procurementOrderHeader.ProcurementOrder_Date = DateTime.Now;
//procurementOrderHeader.TotalValue_BeforeTax = 0;
procurementOrderHeader.ProcurementOrder_Number = (++procurementOrderNumber).ToString();
procurementOrderHeader.Save(Connection, Transaction);
// Create procurement order status history
var procurementOrderStatusHistory = new CL1_ORD_PRC.ORM_ORD_PRC_ProcurementOrder_StatusHistory();
procurementOrderStatusHistory.Tenant_RefID = securityTicket.TenantID;
procurementOrderStatusHistory.ProcurementOrder_Header_RefID = procurementOrderHeader.ORD_PRC_ProcurementOrder_HeaderID;
procurementOrderStatusHistory.ProcurementOrder_Status_RefID = procurementOrderStatus.ORD_PRC_ProcurementOrder_StatusID;
procurementOrderStatusHistory.Save(Connection, Transaction);
#endregion
foreach (var item in approvedShoppingCarts)
{
var shoppingProducts = CL1_ORD_PRC.ORM_ORD_PRC_ShoppingCart_Product.Query.Search(Connection, Transaction,
new CL1_ORD_PRC.ORM_ORD_PRC_ShoppingCart_Product.Query
{
IsCanceled = false,
ORD_PRC_ShoppingCart_RefID = item.ORD_PRC_ShoppingCartID,
IsDeleted = false
});
#region Procurement Order Shopping Products
// Create and save procurement order for shopping products
foreach (var shoppingProduct in shoppingProducts)
{
var procurementOrderPosition = new CL1_ORD_PRC.ORM_ORD_PRC_ProcurementOrder_Position();
procurementOrderPosition.Tenant_RefID = securityTicket.TenantID;
procurementOrderPosition.ProcurementOrder_Header_RefID = procurementOrderHeader.ORD_PRC_ProcurementOrder_HeaderID;
procurementOrderPosition.Position_Quantity = shoppingProduct.Quantity;
procurementOrderPosition.CMN_PRO_Product_RefID = shoppingProduct.CMN_PRO_Product_RefID;
procurementOrderPosition.CMN_PRO_Product_Release_RefID = shoppingProduct.CMN_PRO_Product_Release_RefID;
procurementOrderPosition.CMN_PRO_Product_Variant_RefID = shoppingProduct.CMN_PRO_Product_Variant_RefID;
procurementOrderPosition.Save(Connection, Transaction);
var shoppingCart2ProcurementOrder = new CL1_ORD_PRC.ORM_ORD_PRC_ShoppingCart_2_ProcurementOrderPosition();
shoppingCart2ProcurementOrder.Tenant_RefID = securityTicket.TenantID;
shoppingCart2ProcurementOrder.ORD_PRC_ShoppingCart_Product_RefID = shoppingProduct.ORD_PRC_ShoppingCart_ProductID;
shoppingCart2ProcurementOrder.ORD_PRC_ProcurementOrder_Position_RefID = procurementOrderPosition.ORD_PRC_ProcurementOrder_PositionID;
shoppingCart2ProcurementOrder.Save(Connection, Transaction);
}
#endregion
#region Shopping Cart
var shoppingCart = new CL1_ORD_PRC.ORM_ORD_PRC_ShoppingCart();
shoppingCart.Load(Connection, Transaction, item.ORD_PRC_ShoppingCartID);
shoppingCart.IsProcurementOrderCreated = true;
//returnValue = new FR_Guid(shoppingCart.Save(Connection, Transaction), procurementOrderHeader.ORD_PRC_ProcurementOrder_HeaderID);
shoppingCart.Save(Connection, Transaction);
// Create and save new shopping cart history
var shoppingHistory = new CL1_ORD_PRC.ORM_ORD_PRC_ShoppingCartStatus_History();
shoppingHistory.ORD_PRC_ShoppingCart_RefID = shoppingCart.ORD_PRC_ShoppingCartID;
shoppingHistory.ORD_PRC_ShoppingCart_Status_RefID = statusOrdered.ORD_PRC_ShoppingCart_StatusID;
shoppingHistory.PerformedBy_Account_RefID = securityTicket.AccountID;
shoppingHistory.Tenant_RefID = securityTicket.TenantID;
shoppingHistory.Save(Connection, Transaction);
#endregion
}
return(returnValue);
#endregion UserCode
}
protected static FR_Guid Execute(DbConnection Connection, DbTransaction Transaction, P_L5WS_DOfSC_1525 Parameter, CSV2Core.SessionSecurity.SessionSecurityTicket securityTicket = null)
{
#region UserCode
var returnValue = new FR_Guid();
//Put your code here
#region Shopping cart
// Get shopping cart
var shoppingCart = new CL1_ORD_PRC.ORM_ORD_PRC_ShoppingCart();
shoppingCart.Load(Connection, Transaction, Parameter.ORD_PRC_ShoppingCartID);
// Get shopping cart status
var statusOrdered = CL1_ORD_PRC.ORM_ORD_PRC_ShoppingCart_Status.Query.Search(Connection, Transaction,
new CL1_ORD_PRC.ORM_ORD_PRC_ShoppingCart_Status.Query()
{
GlobalPropertyMatchingID = DLCore_DBCommons.Utils.EnumUtils.GetEnumDescription(DLCore_DBCommons.APODemand.EShoppingCartStatus.Ordered),
Tenant_RefID = securityTicket.TenantID,
IsDeleted = false
}).Single();
// Create and save new shopping cart history
var shoppingHistory = new CL1_ORD_PRC.ORM_ORD_PRC_ShoppingCartStatus_History();
shoppingHistory.ORD_PRC_ShoppingCart_RefID = shoppingCart.ORD_PRC_ShoppingCartID;
shoppingHistory.ORD_PRC_ShoppingCart_Status_RefID = statusOrdered.ORD_PRC_ShoppingCart_StatusID;
shoppingHistory.PerformedBy_Account_RefID = securityTicket.AccountID;
shoppingHistory.Tenant_RefID = securityTicket.TenantID;
shoppingHistory.Save(Connection, Transaction);
var shoppingProducts = CL1_ORD_PRC.ORM_ORD_PRC_ShoppingCart_Product.Query.Search(Connection, Transaction,
new CL1_ORD_PRC.ORM_ORD_PRC_ShoppingCart_Product.Query
{
ORD_PRC_ShoppingCart_RefID = Parameter.ORD_PRC_ShoppingCartID,
IsDeleted = false
});
// Save shopping cart
shoppingCart.IsProcurementOrderCreated = true;
shoppingCart.ShoppingCart_CurrentStatus_RefID = statusOrdered.ORD_PRC_ShoppingCart_StatusID;
#endregion
#region Procurement Order
// Get procurement order status
var procurementOrderStatus = CL1_ORD_PRC.ORM_ORD_PRC_ProcurementOrder_Status.Query.Search(Connection, Transaction,
new CL1_ORD_PRC.ORM_ORD_PRC_ProcurementOrder_Status.Query()
{
GlobalPropertyMatchingID = DLCore_DBCommons.Utils.EnumUtils.GetEnumDescription(DLCore_DBCommons.APODemand.EProcurementStatus.Active),
Tenant_RefID = securityTicket.TenantID,
IsDeleted = false
}).Single();
var account = new CL1_USR.ORM_USR_Account();
account.Load(Connection, Transaction, securityTicket.AccountID);
// Find last added procurement order header
var lastProcurementOrderHeader = CL1_ORD_PRC.ORM_ORD_PRC_ProcurementOrder_Header.Query.Search(Connection, Transaction,
new CL1_ORD_PRC.ORM_ORD_PRC_ProcurementOrder_Header.Query
{
Tenant_RefID = securityTicket.TenantID
}).OrderByDescending(x => Convert.ToInt64(x.ProcurementOrder_Number)).FirstOrDefault();
// Find last procurement order number
long procurementOrderNumber = 0;
if (lastProcurementOrderHeader != null)
{
procurementOrderNumber = Convert.ToInt64(lastProcurementOrderHeader.ProcurementOrder_Number);
}
// Create procurement order header
var procurementOrderHeader = new CL1_ORD_PRC.ORM_ORD_PRC_ProcurementOrder_Header();
procurementOrderHeader.Tenant_RefID = securityTicket.TenantID;
procurementOrderHeader.CreatedBy_BusinessParticipant_RefID = account.BusinessParticipant_RefID;
procurementOrderHeader.Current_ProcurementOrderStatus_RefID = procurementOrderStatus.ORD_PRC_ProcurementOrder_StatusID;
procurementOrderHeader.ProcurementOrder_Supplier_RefID = Guid.Empty;
procurementOrderHeader.ProcurementOrder_Date = DateTime.Now;
//procurementOrderHeader.TotalValue_BeforeTax = 0;
procurementOrderHeader.ProcurementOrder_Number = (++procurementOrderNumber).ToString();
procurementOrderHeader.Save(Connection, Transaction);
// Create procurement order status history
var procurementOrderStatusHistory = new CL1_ORD_PRC.ORM_ORD_PRC_ProcurementOrder_StatusHistory();
procurementOrderStatusHistory.Tenant_RefID = securityTicket.TenantID;
procurementOrderStatusHistory.ProcurementOrder_Header_RefID = procurementOrderHeader.ORD_PRC_ProcurementOrder_HeaderID;
procurementOrderStatusHistory.ProcurementOrder_Status_RefID = procurementOrderStatus.ORD_PRC_ProcurementOrder_StatusID;
procurementOrderStatusHistory.Save(Connection, Transaction);
returnValue = new FR_Guid(shoppingCart.Save(Connection, Transaction), procurementOrderHeader.ORD_PRC_ProcurementOrder_HeaderID);
#endregion
#region Procurement Order Shopping Products
// Create and save procurement order for shopping products
foreach (var shoppingProduct in shoppingProducts)
{
var procurementOrderPosition = new CL1_ORD_PRC.ORM_ORD_PRC_ProcurementOrder_Position();
procurementOrderPosition.Tenant_RefID = securityTicket.TenantID;
procurementOrderPosition.ProcurementOrder_Header_RefID = procurementOrderHeader.ORD_PRC_ProcurementOrder_HeaderID;
procurementOrderPosition.Position_Quantity = shoppingProduct.Quantity;
procurementOrderPosition.CMN_PRO_Product_RefID = shoppingProduct.CMN_PRO_Product_RefID;
procurementOrderPosition.CMN_PRO_Product_Release_RefID = shoppingProduct.CMN_PRO_Product_Release_RefID;
procurementOrderPosition.CMN_PRO_Product_Variant_RefID = shoppingProduct.CMN_PRO_Product_Variant_RefID;
procurementOrderPosition.Save(Connection, Transaction);
var shoppingCart2ProcurementOrder = new CL1_ORD_PRC.ORM_ORD_PRC_ShoppingCart_2_ProcurementOrderPosition();
shoppingCart2ProcurementOrder.Tenant_RefID = securityTicket.TenantID;
shoppingCart2ProcurementOrder.ORD_PRC_ShoppingCart_Product_RefID = shoppingProduct.ORD_PRC_ShoppingCart_ProductID;
shoppingCart2ProcurementOrder.ORD_PRC_ProcurementOrder_Position_RefID = procurementOrderPosition.ORD_PRC_ProcurementOrder_PositionID;
shoppingCart2ProcurementOrder.Save(Connection, Transaction);
}
#endregion
return(returnValue);
#endregion UserCode
}
protected static FR_Guid Execute(DbConnection Connection, DbTransaction Transaction, P_L5WS_CSCfP_1431 Parameter, CSV2Core.SessionSecurity.SessionSecurityTicket securityTicket = null)
{
#region UserCode
var returnValue = new FR_Guid();
var item = new CL1_ORD_PRC.ORM_ORD_PRC_ShoppingCart();
item.ORD_PRC_ShoppingCartID = Guid.NewGuid();
// Get status
var statusActive = CL1_ORD_PRC.ORM_ORD_PRC_ShoppingCart_Status.Query.Search(Connection, Transaction,
new CL1_ORD_PRC.ORM_ORD_PRC_ShoppingCart_Status.Query()
{
GlobalPropertyMatchingID = DLCore_DBCommons.Utils.EnumUtils.GetEnumDescription
(DLCore_DBCommons.APODemand.EShoppingCartStatus.Active),
Tenant_RefID = securityTicket.TenantID,
IsDeleted = false
}).Single();
ORM_CMN_STR_Office office;
var offices = ORM_CMN_STR_Office.Query.Search(Connection, Transaction,
new ORM_CMN_STR_Office.Query()
{
Office_InternalName = Parameter.PracticeBPID,
Tenant_RefID = securityTicket.TenantID,
IsDeleted = false
}).ToArray();
if (offices.Count() == 0)
{
office = new ORM_CMN_STR_Office();
office.CMN_STR_OfficeID = Guid.NewGuid();
office.Tenant_RefID = securityTicket.TenantID;
office.Office_InternalName = Parameter.PracticeBPID;
office.Save(Connection, Transaction);
}
else
{
office = offices[0];
}
double internalIdentifier = 0;
var lastShoppingCartOfficeAssignment = CL1_ORD_PRC.ORM_ORD_PRC_Office_ShoppingCart.Query.Search(Connection, Transaction,
new CL1_ORD_PRC.ORM_ORD_PRC_Office_ShoppingCart.Query {
Tenant_RefID = securityTicket.TenantID, CMN_STR_Office_RefID = office.CMN_STR_OfficeID
}
).OrderByDescending(x => x.Creation_Timestamp).FirstOrDefault();
if (lastShoppingCartOfficeAssignment != null)
{
var lastShoppingCart = CL1_ORD_PRC.ORM_ORD_PRC_ShoppingCart.Query.Search(Connection, Transaction,
new CL1_ORD_PRC.ORM_ORD_PRC_ShoppingCart.Query {
Tenant_RefID = securityTicket.TenantID, ORD_PRC_ShoppingCartID = lastShoppingCartOfficeAssignment.ORD_PRC_ShoppingCart_RefID
}
).FirstOrDefault();
double.TryParse(lastShoppingCart.InternalIdentifier, out internalIdentifier);
}
var shoppingCartOffice = new CL1_ORD_PRC.ORM_ORD_PRC_Office_ShoppingCart();
shoppingCartOffice.ORD_PRC_ShoppingCart_RefID = item.ORD_PRC_ShoppingCartID;
shoppingCartOffice.CMN_STR_Office_RefID = office.CMN_STR_OfficeID;
shoppingCartOffice.Tenant_RefID = securityTicket.TenantID;
shoppingCartOffice.Save(Connection, Transaction);
// Create shoppping cart
item.ShoppingCart_CurrentStatus_RefID = statusActive.ORD_PRC_ShoppingCart_StatusID;
item.InternalIdentifier = (++internalIdentifier).ToString();
item.Tenant_RefID = securityTicket.TenantID;
item.CreatedBy_Account_RefID = securityTicket.AccountID;
item.IsProcurementOrderCreated = false;
// Create and save new shopping cart history
var shoppingHistory = new CL1_ORD_PRC.ORM_ORD_PRC_ShoppingCartStatus_History();
shoppingHistory.ORD_PRC_ShoppingCart_RefID = item.ORD_PRC_ShoppingCartID;
shoppingHistory.ORD_PRC_ShoppingCart_Status_RefID = statusActive.ORD_PRC_ShoppingCart_StatusID;
shoppingHistory.PerformedBy_Account_RefID = securityTicket.AccountID;
shoppingHistory.Tenant_RefID = securityTicket.TenantID;
shoppingHistory.Save(Connection, Transaction);
return(new FR_Guid(item.Save(Connection, Transaction), item.ORD_PRC_ShoppingCartID));
#endregion UserCode
}
protected static FR_Guid Execute(DbConnection Connection, DbTransaction Transaction, P_L5AWSAR_CSC_1809 Parameter, CSV2Core.SessionSecurity.SessionSecurityTicket securityTicket = null)
{
#region UserCode
var returnValue = new FR_Guid();
var item = new CL1_ORD_PRC.ORM_ORD_PRC_ShoppingCart();
CL1_ORD_PRC.ORM_ORD_PRC_ShoppingCart_Status statusShoppingCart;
if (Parameter.IsWaitingForApproval)
{
// Get status
statusShoppingCart = CL1_ORD_PRC.ORM_ORD_PRC_ShoppingCart_Status.Query.Search(Connection, Transaction,
new CL1_ORD_PRC.ORM_ORD_PRC_ShoppingCart_Status.Query()
{
GlobalPropertyMatchingID = DLCore_DBCommons.Utils.EnumUtils.GetEnumDescription
(DLCore_DBCommons.APODemand.EShoppingCartStatus.WaitingForApproval),
Tenant_RefID = securityTicket.TenantID,
IsDeleted = false
}).Single();
}
else
{
// Get status
statusShoppingCart = CL1_ORD_PRC.ORM_ORD_PRC_ShoppingCart_Status.Query.Search(Connection, Transaction,
new CL1_ORD_PRC.ORM_ORD_PRC_ShoppingCart_Status.Query()
{
GlobalPropertyMatchingID = DLCore_DBCommons.Utils.EnumUtils.GetEnumDescription
(DLCore_DBCommons.APODemand.EShoppingCartStatus.Active),
Tenant_RefID = securityTicket.TenantID,
IsDeleted = false
}).Single();
}
// Check does already exist available shopping cart for current office.
var shoppingCartOffice = new CL1_ORD_PRC.ORM_ORD_PRC_Office_ShoppingCart();
item.Tenant_RefID = securityTicket.TenantID;
var lastShoppingCart = CL1_ORD_PRC.ORM_ORD_PRC_ShoppingCart.Query.Search(Connection, Transaction,
new CL1_ORD_PRC.ORM_ORD_PRC_ShoppingCart.Query
{
Tenant_RefID = securityTicket.TenantID
}
).OrderByDescending(x => x.Creation_Timestamp).FirstOrDefault();
// Set shopping cart number
double internalIdentifier = 0;
if (lastShoppingCart != null)
{
double.TryParse(lastShoppingCart.InternalIdentifier, out internalIdentifier);
}
// Create shopping cart office
shoppingCartOffice.ORD_PRC_ShoppingCart_RefID = item.ORD_PRC_ShoppingCartID;
shoppingCartOffice.CMN_STR_Office_RefID = Parameter.OfficeID;
shoppingCartOffice.Tenant_RefID = securityTicket.TenantID;
shoppingCartOffice.Save(Connection, Transaction);
// Create shoppping cart
item.ShoppingCart_CurrentStatus_RefID = statusShoppingCart.ORD_PRC_ShoppingCart_StatusID;
item.InternalIdentifier = (++internalIdentifier).ToString();
item.CreatedBy_Account_RefID = securityTicket.AccountID;
item.IsProcurementOrderCreated = false;
// Create and save new shopping cart history
var shoppingHistory = new CL1_ORD_PRC.ORM_ORD_PRC_ShoppingCartStatus_History();
shoppingHistory.ORD_PRC_ShoppingCart_RefID = item.ORD_PRC_ShoppingCartID;
shoppingHistory.ORD_PRC_ShoppingCart_Status_RefID = statusShoppingCart.ORD_PRC_ShoppingCart_StatusID;
shoppingHistory.PerformedBy_Account_RefID = securityTicket.AccountID;
shoppingHistory.Tenant_RefID = securityTicket.TenantID;
shoppingHistory.Save(Connection, Transaction);
return(new FR_Guid(item.Save(Connection, Transaction), item.ORD_PRC_ShoppingCartID));
#endregion UserCode
}
