protected static FR_Guid Execute(DbConnection Connection, DbTransaction Transaction, P_L5CA_SCP_1007 Parameter, CSV2Core.SessionSecurity.SessionSecurityTicket securityTicket = null)
{
#region UserCode
var returnValue = new FR_Guid();
//Put your code here
foreach (var productID in Parameter.Products)
{
ORM_CMN_PRO_Product_Variant.Query variantsQuery = new ORM_CMN_PRO_Product_Variant.Query()
{
CMN_PRO_Product_RefID = productID,
Tenant_RefID = securityTicket.TenantID,
IsDeleted = false
};
var variants = ORM_CMN_PRO_Product_Variant.Query.Search(Connection, Transaction, variantsQuery).ToList();
foreach (var variant in variants)
{
ORM_CMN_PRO_Catalog_Product.Query catVersionQuery = new ORM_CMN_PRO_Catalog_Product.Query()
{
CMN_PRO_Catalog_Revision_RefID = Parameter.CatalogRevisionID, CMN_PRO_Product_RefID = productID, CMN_PRO_Product_Variant_RefID = variant.CMN_PRO_Product_VariantID
};
var catVersionProduct = ORM_CMN_PRO_Catalog_Product.Query.Search(Connection, Transaction, catVersionQuery);
Guid catalogProdID = Guid.Empty;
if (catVersionProduct == null || catVersionProduct.Count == 0)
{
ORM_CMN_PRO_Catalog_Product catProduct = new ORM_CMN_PRO_Catalog_Product();
catProduct.CMN_PRO_Catalog_ProductID = Guid.NewGuid();
catProduct.CMN_PRO_Catalog_Revision_RefID = Parameter.CatalogRevisionID;
catProduct.CMN_PRO_Product_RefID = productID;
catProduct.CMN_PRO_Product_Variant_RefID = variant.CMN_PRO_Product_VariantID;
catProduct.Tenant_RefID = securityTicket.TenantID;
catProduct.Save(Connection, Transaction);
catalogProdID = catProduct.CMN_PRO_Catalog_ProductID;
}
else if (catVersionProduct.First().IsDeleted == true)
{
catVersionProduct.First().IsDeleted = false;
catVersionProduct.First().Save(Connection, Transaction);
}
ORM_CMN_PRO_Catalog_Product_2_ProductGroup cat2prod = new ORM_CMN_PRO_Catalog_Product_2_ProductGroup();
cat2prod.AssignmentID = Guid.NewGuid();
cat2prod.CMN_PRO_Catalog_Product_RefID = catalogProdID != Guid.Empty ? catalogProdID : catVersionProduct.First().CMN_PRO_Catalog_ProductID;
cat2prod.CMN_PRO_Catalog_ProductGroup_RefID = Parameter.CatalogGroupID;
cat2prod.Tenant_RefID = securityTicket.TenantID;
cat2prod.Save(Connection, Transaction);
}
}
return(returnValue);
#endregion UserCode
}
protected static FR_L5CA_PNCV_1520 Execute(DbConnection Connection, DbTransaction Transaction, P_L5CA_PNCV_1520 Parameter, CSV2Core.SessionSecurity.SessionSecurityTicket securityTicket = null)
{
//Leave UserCode region to enable user code saving
#region UserCode
var returnValue = new FR_L5CA_PNCV_1520();
returnValue.Result = new L5CA_PNCV_1520();
//Put your code here
var account = new ORM_USR_Account();
account.Load(Connection, Transaction, securityTicket.AccountID);
#region Update active catalog revision
ORM_CMN_PRO_Catalog_Revision rev = new ORM_CMN_PRO_Catalog_Revision();
rev.Load(Connection, Transaction, Parameter.CMN_PRO_Catalog_RevisionID);
rev.Valid_From = Parameter.Valid_From;
rev.Valid_Through = Parameter.Valid_Through;
rev.Default_PricelistRelease_RefID = Parameter.Default_PricelistRelease_RefID;
rev.PublishedBy_BusinessParticipant_RefID = account.BusinessParticipant_RefID;
rev.PublishedOn_Date = DateTime.Now;
rev.Save(Connection, Transaction);
#endregion
#region Update catalog public/private status
if (rev.RevisionNumber == 1)
{
ORM_CMN_PRO_Catalog catalog = new ORM_CMN_PRO_Catalog();
catalog.Load(Connection, Transaction, rev.CMN_PRO_Catalog_RefID);
catalog.IsPublicCatalog = Parameter.IsPublic;
catalog.Save(Connection, Transaction);
}
#endregion
#region Create new catalog revision
ORM_CMN_PRO_Catalog_Revision newRev = new ORM_CMN_PRO_Catalog_Revision();
newRev.CMN_PRO_Catalog_RevisionID = Guid.NewGuid();
newRev.CMN_PRO_Catalog_RefID = rev.CMN_PRO_Catalog_RefID;
newRev.Tenant_RefID = securityTicket.TenantID;
newRev.Creation_Timestamp = DateTime.Now;
newRev.CatalogRevision_Description = "Revision for Catalog";
newRev.CatalogRevision_Name = "New Catalog Revision";
newRev.IsDeleted = false;
newRev.RevisionNumber = rev.RevisionNumber + 1;
newRev.Save(Connection, Transaction);
#endregion
#region Products
var oldProducts = ORM_CMN_PRO_Catalog_Product.Query.Search(Connection, Transaction, new ORM_CMN_PRO_Catalog_Product.Query()
{
CMN_PRO_Catalog_Revision_RefID = rev.CMN_PRO_Catalog_RevisionID,
IsDeleted = false,
Tenant_RefID = securityTicket.TenantID
});
if (oldProducts.Count == 0)
{
returnValue.Result.Status_Code = -1; // -1 no products in revision
returnValue.Result.Status_Message = "no products in revision";
return(returnValue);
}
//oldProductID - newProductID
Dictionary <Guid, Guid> productsMapping = new Dictionary <Guid, Guid>();
var productsWithoutPrices = ProductWithoutPrices(Connection, Transaction, Parameter, securityTicket, oldProducts);
if (productsWithoutPrices.Count > 0)
{
returnValue.Result.Status_Code = -2; // -2 => pricelist does not have price for product
returnValue.Result.Status_Message = JsonConvert.SerializeObject(productsWithoutPrices);
return(returnValue);
}
foreach (var item in oldProducts)
{
var newProduct = new ORM_CMN_PRO_Catalog_Product()
{
CMN_PRO_Catalog_ProductID = Guid.NewGuid(),
CMN_PRO_Product_Variant_RefID = item.CMN_PRO_Product_Variant_RefID,
Creation_Timestamp = DateTime.Now,
Tenant_RefID = item.Tenant_RefID,
CMN_PRO_Catalog_Revision_RefID = newRev.CMN_PRO_Catalog_RevisionID,
CMN_PRO_Product_RefID = item.CMN_PRO_Product_RefID,
};
newProduct.Save(Connection, Transaction);
productsMapping.Add(item.CMN_PRO_Catalog_ProductID, newProduct.CMN_PRO_Catalog_ProductID);
}
#endregion
#region ProductGroups
var oldGroups = ORM_CMN_PRO_Catalog_ProductGroup.Query.Search(Connection, Transaction, new ORM_CMN_PRO_Catalog_ProductGroup.Query()
{
Catalog_Revision_RefID = rev.CMN_PRO_Catalog_RevisionID,
IsDeleted = false
});
//oldGroupID - newGroupID
Dictionary <Guid, Guid> groupsMapping = new Dictionary <Guid, Guid>();
groupsMapping.Add(Guid.Empty, Guid.Empty);
foreach (var item in oldGroups)
{
groupsMapping.Add(item.CMN_PRO_Catalog_ProductGroupID, Guid.NewGuid());
}
foreach (var item in oldGroups)
{
var newGroup = new ORM_CMN_PRO_Catalog_ProductGroup()
{
CMN_PRO_Catalog_ProductGroupID = groupsMapping[item.CMN_PRO_Catalog_ProductGroupID],
Catalog_Revision_RefID = newRev.CMN_PRO_Catalog_RevisionID,
CatalogProductGroup_Name = item.CatalogProductGroup_Name,
CatalogProductGroup_Parent_RefID = groupsMapping[item.CatalogProductGroup_Parent_RefID],
Creation_Timestamp = DateTime.Now,
Tenant_RefID = item.Tenant_RefID
};
newGroup.Save(Connection, Transaction);
var oldProductsInGroup = ORM_CMN_PRO_Catalog_Product_2_ProductGroup.Query.Search(Connection, Transaction, new ORM_CMN_PRO_Catalog_Product_2_ProductGroup.Query()
{
CMN_PRO_Catalog_ProductGroup_RefID = item.CMN_PRO_Catalog_ProductGroupID,
IsDeleted = false,
Tenant_RefID = securityTicket.TenantID
});
foreach (var product in oldProductsInGroup)
{
if (groupsMapping.ContainsKey(product.CMN_PRO_Catalog_ProductGroup_RefID) && productsMapping.ContainsKey(product.CMN_PRO_Catalog_Product_RefID))
{
var newProduct = new ORM_CMN_PRO_Catalog_Product_2_ProductGroup()
{
AssignmentID = Guid.NewGuid(),
CMN_PRO_Catalog_ProductGroup_RefID = groupsMapping[product.CMN_PRO_Catalog_ProductGroup_RefID],
CMN_PRO_Catalog_Product_RefID = productsMapping[product.CMN_PRO_Catalog_Product_RefID],
Creation_Timestamp = DateTime.Now,
Tenant_RefID = item.Tenant_RefID
};
newProduct.Save(Connection, Transaction);
}
}
}
#endregion
returnValue.Result.Status_Code = 1;
returnValue.Result.Status_Message = "Success";
returnValue.Result.ID = newRev.CMN_PRO_Catalog_RevisionID;
return(returnValue);
#endregion UserCode
}
protected static FR_L5CA_PNCV_1603 Execute(DbConnection Connection, DbTransaction Transaction, P_L5CA_PNCV_1603 Parameter, CSV2Core.SessionSecurity.SessionSecurityTicket securityTicket = null)
{
#region UserCode
var returnValue = new FR_L5CA_PNCV_1603();
returnValue.Result = new L5CA_PNCV_1603();
var account = new ORM_USR_Account();
account.Load(Connection, Transaction, securityTicket.AccountID);
#region Update active catalog revision
ORM_CMN_PRO_Catalog_Revision rev = new ORM_CMN_PRO_Catalog_Revision();
rev.Load(Connection, Transaction, Parameter.CMN_PRO_Catalog_RevisionID);
rev.Valid_From = Parameter.Valid_From;
rev.Valid_Through = Parameter.Valid_Through;
rev.Default_PricelistRelease_RefID = Parameter.Default_PricelistRelease_RefID;
rev.PublishedBy_BusinessParticipant_RefID = account.BusinessParticipant_RefID;
rev.PublishedOn_Date = DateTime.Now;
rev.Save(Connection, Transaction);
#endregion
#region Create new catalog revision
ORM_CMN_PRO_Catalog_Revision newRev = new ORM_CMN_PRO_Catalog_Revision();
newRev.CMN_PRO_Catalog_RevisionID = Guid.NewGuid();
newRev.CMN_PRO_Catalog_RefID = rev.CMN_PRO_Catalog_RefID;
newRev.Tenant_RefID = securityTicket.TenantID;
newRev.Creation_Timestamp = DateTime.Now;
newRev.CatalogRevision_Description = "Revision for Catalog";
newRev.CatalogRevision_Name = "New Catalog Revision";
newRev.IsDeleted = false;
newRev.RevisionNumber = rev.RevisionNumber + 1;
newRev.Save(Connection, Transaction);
#endregion
#region Products
var oldProducts = ORM_CMN_PRO_Catalog_Product.Query.Search(Connection, Transaction, new ORM_CMN_PRO_Catalog_Product.Query()
{
CMN_PRO_Catalog_Revision_RefID = rev.CMN_PRO_Catalog_RevisionID,
IsDeleted = false
});
if (oldProducts.Count == 0)
{
returnValue.Result.Status_Code = -1; // -1 no products in revision
returnValue.Result.Status_Message = "no products in revision";
return(returnValue);
}
//oldProductID - newProductID
Dictionary <Guid, Guid> productsMapping = new Dictionary <Guid, Guid>();
foreach (var item in oldProducts)
{
ORM_CMN_SLS_Pricelist_Release plr = new ORM_CMN_SLS_Pricelist_Release();
plr.Load(Connection, Transaction, Parameter.Default_PricelistRelease_RefID);
var pricelistPriceQry = new ORM_CMN_SLS_Price.Query()
{
CMN_PRO_Product_RefID = item.CMN_PRO_Product_RefID,
PricelistRelease_RefID = plr.CMN_SLS_Pricelist_ReleaseID,
IsDeleted = false,
Tenant_RefID = securityTicket.TenantID
};
var prices = ORM_CMN_SLS_Price.Query.Search(Connection, Transaction, pricelistPriceQry);
if (prices.Count == 0)
{
ORM_CMN_PRO_Product pr = new ORM_CMN_PRO_Product();
pr.Load(Connection, Transaction, item.CMN_PRO_Product_RefID);
returnValue.Result.Status_Code = -2; // -2 => pricelist does not have price for product
returnValue.Result.Status_Message = pr.Product_Number;
return(returnValue);
}
var newProduct = new ORM_CMN_PRO_Catalog_Product()
{
CMN_PRO_Catalog_ProductID = Guid.NewGuid(),
CMN_PRO_Product_Variant_RefID = item.CMN_PRO_Product_Variant_RefID,
Creation_Timestamp = DateTime.Now,
Tenant_RefID = item.Tenant_RefID,
CMN_PRO_Catalog_Revision_RefID = newRev.CMN_PRO_Catalog_RevisionID,
CMN_PRO_Product_RefID = item.CMN_PRO_Product_RefID,
};
newProduct.Save(Connection, Transaction);
productsMapping.Add(item.CMN_PRO_Catalog_ProductID, newProduct.CMN_PRO_Catalog_ProductID);
}
#endregion
#region ProductGroups
var oldGroups = ORM_CMN_PRO_Catalog_ProductGroup.Query.Search(Connection, Transaction, new ORM_CMN_PRO_Catalog_ProductGroup.Query()
{
Catalog_Revision_RefID = rev.CMN_PRO_Catalog_RevisionID,
IsDeleted = false
});
//oldGroupID - newGroupID
Dictionary <Guid, Guid> groupsMapping = new Dictionary <Guid, Guid>();
groupsMapping.Add(Guid.Empty, Guid.Empty);
foreach (var item in oldGroups)
{
groupsMapping.Add(item.CMN_PRO_Catalog_ProductGroupID, Guid.NewGuid());
}
foreach (var item in oldGroups)
{
var newGroup = new ORM_CMN_PRO_Catalog_ProductGroup()
{
CMN_PRO_Catalog_ProductGroupID = groupsMapping[item.CMN_PRO_Catalog_ProductGroupID],
Catalog_Revision_RefID = newRev.CMN_PRO_Catalog_RevisionID,
CatalogProductGroup_Name = item.CatalogProductGroup_Name,
CatalogProductGroup_Parent_RefID = groupsMapping[item.CatalogProductGroup_Parent_RefID],
Creation_Timestamp = DateTime.Now,
Tenant_RefID = item.Tenant_RefID
};
newGroup.Save(Connection, Transaction);
var oldProductsInGroup = ORM_CMN_PRO_Catalog_Product_2_ProductGroup.Query.Search(Connection, Transaction, new ORM_CMN_PRO_Catalog_Product_2_ProductGroup.Query()
{
CMN_PRO_Catalog_ProductGroup_RefID = item.CMN_PRO_Catalog_ProductGroupID,
IsDeleted = false
});
foreach (var product in oldProductsInGroup)
{
var newProduct = new ORM_CMN_PRO_Catalog_Product_2_ProductGroup()
{
AssignmentID = Guid.NewGuid(),
CMN_PRO_Catalog_ProductGroup_RefID = groupsMapping[product.CMN_PRO_Catalog_ProductGroup_RefID],
CMN_PRO_Catalog_Product_RefID = productsMapping[product.CMN_PRO_Catalog_Product_RefID],
Creation_Timestamp = DateTime.Now,
Tenant_RefID = item.Tenant_RefID
};
newProduct.Save(Connection, Transaction);
}
}
#endregion
returnValue.Result.Status_Code = 1;
returnValue.Result.Status_Message = "Success";
returnValue.Result.ID = newRev.CMN_PRO_Catalog_RevisionID;
return(returnValue);
#endregion UserCode
}
protected static FR_L5CA_APtPG_1137_Array Execute(DbConnection Connection, DbTransaction Transaction, P_L5CA_APtPG_1137 Parameter, CSV2Core.SessionSecurity.SessionSecurityTicket securityTicket = null)
{
#region UserCode
var returnValue = new FR_L5CA_APtPG_1137_Array();
//Put your code here
List <L5CA_APtPG_1137> returnList = new List <L5CA_APtPG_1137>();
foreach (var ProductITL in Parameter.Products)
{
ORM_CMN_PRO_Product.Query prodQuery = new ORM_CMN_PRO_Product.Query()
{
ProductITL = ProductITL,
IsDeleted = false,
Tenant_RefID = securityTicket.TenantID,
IsProductAvailableForOrdering = true
};
var prod = ORM_CMN_PRO_Product.Query.Search(Connection, Transaction, prodQuery).Single();
ORM_CMN_PRO_Catalog_Product.Query catalogProductQuery = new ORM_CMN_PRO_Catalog_Product.Query()
{
CMN_PRO_Product_RefID = prod.CMN_PRO_ProductID,
CMN_PRO_Catalog_Revision_RefID = Parameter.CatalogRevision_ID,
IsDeleted = false
};
if (ORM_CMN_PRO_Catalog_Product.Query.Exists(Connection, Transaction, catalogProductQuery))
{
String GroupName = "Catalogue root";
ORM_CMN_PRO_Catalog_ProductGroup catGroup = new ORM_CMN_PRO_Catalog_ProductGroup();
if (Parameter.Product_Group_ID != Guid.Empty)
{
catGroup.Load(Connection, Transaction, Parameter.Product_Group_ID);
GroupName = catGroup.CatalogProductGroup_Name;
}
L5CA_APtPG_1137 item = new L5CA_APtPG_1137()
{
CatalgueProductGroup = GroupName,
Product_Name = prod.Product_Name
};
returnList.Add(item);
continue; // catalog group for the product already exists in catalog revision
}
// Create catalog product
ORM_CMN_PRO_Catalog_Product newCp = new ORM_CMN_PRO_Catalog_Product();
newCp.CMN_PRO_Product_RefID = prod.CMN_PRO_ProductID;
newCp.CMN_PRO_Catalog_ProductID = Guid.NewGuid();
newCp.Tenant_RefID = securityTicket.TenantID;
newCp.CMN_PRO_Catalog_Revision_RefID = Parameter.CatalogRevision_ID;
// Create catalog product 2 product group (Product group already exists) if there is group id in Parameter else only add to catalog
if (Parameter.Product_Group_ID != Guid.Empty)
{
ORM_CMN_PRO_Catalog_Product_2_ProductGroup prodToGroup = new ORM_CMN_PRO_Catalog_Product_2_ProductGroup();
prodToGroup.CMN_PRO_Catalog_Product_RefID = newCp.CMN_PRO_Catalog_ProductID;
prodToGroup.CMN_PRO_Catalog_ProductGroup_RefID = Parameter.Product_Group_ID;
prodToGroup.Tenant_RefID = securityTicket.TenantID;
prodToGroup.Save(Connection, Transaction);
}
newCp.Save(Connection, Transaction);
}
returnValue.Result = returnList.ToArray();
return(returnValue);
#endregion UserCode
}
