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_Guid Execute(DbConnection Connection, DbTransaction Transaction, P_L5SCBD_1454 Parameter, CSV2Core.SessionSecurity.SessionSecurityTicket securityTicket = null)
{
//Leave UserCode region to enable user code saving
#region UserCode
var returnValue = new FR_Guid();
//Put your code here
#region Save
ORM_CMN_PRO_Catalog catalog = new ORM_CMN_PRO_Catalog();
ORM_CMN_PRO_MasterCatalog mc = new ORM_CMN_PRO_MasterCatalog();
#region Delete
if (Parameter.isDeleted == true)
{
/*
* @Delete Catalog
* */
catalog.Load(Connection, Transaction, Parameter.CatalogID);
catalog.IsDeleted = true;
catalog.Save(Connection, Transaction);
/*
* @Delete Catalog's master catalog
* */
ORM_CMN_PRO_MasterCatalog masterCata = new ORM_CMN_PRO_MasterCatalog();
masterCata.Load(Connection, Transaction, catalog.CMN_PRO_MasterCatalog_RefID);
masterCata.IsDeleted = true;
masterCata.Save(Connection, Transaction);
/*
* @Delete CMN_PRO_Catalog_Revisions
* */
var catalogRevisionQuery = new ORM_CMN_PRO_Catalog_Revision.Query();
catalogRevisionQuery.Tenant_RefID = securityTicket.TenantID;
catalogRevisionQuery.CMN_PRO_Catalog_RefID = Parameter.CatalogID;
var catalogRevisionDel = ORM_CMN_PRO_Catalog_Revision.Query.Search(Connection, Transaction, catalogRevisionQuery);
if (catalogRevisionDel != null)
{
foreach (var item in catalogRevisionDel)
{
ORM_CMN_PRO_Catalog_ProductGroup.Query searchProductGroupQuery = new ORM_CMN_PRO_Catalog_ProductGroup.Query();
searchProductGroupQuery.Catalog_Revision_RefID = item.CMN_PRO_Catalog_RevisionID;
List <ORM_CMN_PRO_Catalog_ProductGroup> revisionGroups = ORM_CMN_PRO_Catalog_ProductGroup.Query.Search(Connection, Transaction, searchProductGroupQuery);
/*
* @Deep delete product groups
* */
P_L5CA_DCPG_1049 delParam = new P_L5CA_DCPG_1049();
foreach (var group in revisionGroups)
{
delParam.ProductGroupID = group.CMN_PRO_Catalog_ProductGroupID;
cls_Delete_Catalog_Product_Group.Invoke(Connection, Transaction, delParam);
}
/*
* @Delete products that are in root of catalog revision (not in group)
* */
ORM_CMN_PRO_Catalog_Product.Query revisionProductsQuery = new ORM_CMN_PRO_Catalog_Product.Query();
revisionProductsQuery.CMN_PRO_Catalog_Revision_RefID = item.CMN_PRO_Catalog_RevisionID;
List <ORM_CMN_PRO_Catalog_Product> revisionProducts = ORM_CMN_PRO_Catalog_Product.Query.Search(Connection, Transaction, revisionProductsQuery);
foreach (var product in revisionProducts)
{
product.IsDeleted = true;
product.Save(Connection, Transaction);
}
/*
* @Delete catalog revision
* */
item.IsDeleted = true;
item.Save(Connection, Transaction);
}
}
returnValue.Result = Parameter.CatalogID;
return(returnValue);
}
#endregion
/*
* @save CMN_PRO_Catalogs
* */
if (Parameter.CatalogID == Guid.Empty)
{
mc.CMN_PRO_MasterCatalogID = Guid.NewGuid();
mc.Catalog_Description = new Dict();
mc.Catalog_Name = Parameter.CatalogName_Dict;
mc.CatalogPublishing_DefaultCurrency_RefID = Parameter.Catalog_Currency_RefID;
mc.CatalogPublishing_DefaultLanguage_RefID = Parameter.Catalog_Language_RefID;
mc.Creation_Timestamp = DateTime.Now;
mc.Save(Connection, Transaction);
catalog.CMN_PRO_CatalogID = Guid.NewGuid();
catalog.CMN_PRO_MasterCatalog_RefID = mc.CMN_PRO_MasterCatalogID;
catalog.Tenant_RefID = securityTicket.TenantID;
catalog.IsPublicCatalog = Parameter.isPublic;
catalog.CatalogCodeITL = RandomString.Generate(8);
catalog.Creation_Timestamp = DateTime.Now;
catalog.IsDeleted = false;
if (Parameter.Catalog_Currency_RefID != Guid.Empty)
{
catalog.Catalog_Currency_RefID = Parameter.Catalog_Currency_RefID;
}
if (Parameter.Catalog_Language_RefID != Guid.Empty)
{
catalog.Catalog_Language_RefID = Parameter.Catalog_Language_RefID;
}
catalog.Save(Connection, Transaction);
/*
* @save Revision
* */
ORM_CMN_PRO_Catalog_Revision rev = new ORM_CMN_PRO_Catalog_Revision();
rev.CMN_PRO_Catalog_RevisionID = Guid.NewGuid();
rev.CMN_PRO_Catalog_RefID = catalog.CMN_PRO_CatalogID;
rev.Tenant_RefID = securityTicket.TenantID;
rev.Creation_Timestamp = DateTime.Now;
rev.CatalogRevision_Description = "Initial revision for catalog ";
rev.CatalogRevision_Name = "Initial catalog revision";
rev.IsDeleted = false;
rev.RevisionNumber = 1;
rev.Save(Connection, Transaction);
/*
* @save Default Catalog ProductGroup
* */
ORM_CMN_PRO_Catalog_ProductGroup defaultProductGroup = new ORM_CMN_PRO_Catalog_ProductGroup();
defaultProductGroup.Catalog_Revision_RefID = rev.CMN_PRO_Catalog_RevisionID;
defaultProductGroup.CMN_PRO_Catalog_ProductGroupID = Guid.NewGuid();
defaultProductGroup.CatalogProductGroup_Name = Parameter.CatalogName_Dict.Contents.First().Content;
defaultProductGroup.CatalogProductGroup_Parent_RefID = Guid.Empty;
defaultProductGroup.Tenant_RefID = securityTicket.TenantID;
defaultProductGroup.Save(Connection, Transaction);
}
else
{
/*
* @edit Catalog
* */
catalog.Load(Connection, Transaction, Parameter.CatalogID);
catalog.Tenant_RefID = securityTicket.TenantID;
catalog.IsPublicCatalog = Parameter.isPublic;
catalog.IsDeleted = false;
if (Parameter.Catalog_Currency_RefID != Guid.Empty)
{
catalog.Catalog_Currency_RefID = Parameter.Catalog_Currency_RefID;
}
if (Parameter.Catalog_Language_RefID != Guid.Empty)
{
catalog.Catalog_Language_RefID = Parameter.Catalog_Language_RefID;
}
catalog.Save(Connection, Transaction);
mc.Load(Connection, Transaction, catalog.CMN_PRO_MasterCatalog_RefID);
mc.Catalog_Name = Parameter.CatalogName_Dict;
mc.CatalogPublishing_DefaultCurrency_RefID = Parameter.Catalog_Currency_RefID;
mc.CatalogPublishing_DefaultLanguage_RefID = Parameter.Catalog_Language_RefID;
mc.Save(Connection, Transaction);
}
#endregion
returnValue.Result = Parameter.CatalogID;
return(returnValue);
#endregion UserCode
}
