/// <summary>
/// Execute
/// </summary>
/// <returns></returns>
protected override bool Execute()
{
//Validation of parameters and user have been successful. We may now proceed to read from the database
var adoProduct = new Product_ADO(Ado);
//You can only create a product in the default Language
DTO.LngIsoCode = Configuration_BSO.GetCustomConfig("language.iso.code");
//Duplicate product names aren't allowed, so we check first
if (adoProduct.Exists(DTO.PrcValue, DTO.SbjCode) || adoProduct.ExistsCode(DTO.PrcCode))
{
Response.error = Label.Get("error.duplicate");
return(false);
}
//Create the Product - and retrieve the newly created Id
int newId = adoProduct.Create(DTO, SamAccountName);
if (newId == 0)
{
Response.error = Label.Get("error.create");
return(false);
}
//We must create the search keywords for this new product
Keyword_Product_BSO_Mandatory keyBso = new Keyword_Product_BSO_Mandatory();
keyBso.Create(Ado, DTO, newId);
Response.data = JSONRPC.success;
return(true);
}
/// <summary>
/// Execute
/// </summary>
/// <returns></returns>
protected override bool Execute()
{
var adoProduct = new Product_ADO(Ado);
int nUpdatedProductID = 0;
//Check if the product exists
if (!adoProduct.ExistsCode(DTO.PrcCode))
{
Response.error = Label.Get("error.update");
return(false);
}
//Duplicate product names aren't allowed, so we check first
if (adoProduct.Exists(DTO.PrcValue, DTO.SbjCode) || (adoProduct.ExistsCode(DTO.PrcCodeNew) && DTO.PrcCode != DTO.PrcCodeNew))
{
Response.error = Label.Get("error.duplicate");
return(false);
}
//We must delete all of the mandatory product keywords for the product
Keyword_Product_BSO_Mandatory kpBso = new Keyword_Product_BSO_Mandatory();
int nchanged = kpBso.Delete(Ado, DTO, true);
if (nchanged == 0)
{
Log.Instance.Debug("Delete of keywords failed");
}
//Update and retrieve the number of updated rows
if (DTO.LngIsoCode != Configuration_BSO.GetCustomConfig("language.iso.code"))
{
ProductLangauge_BSO productLanguageBso = new ProductLangauge_BSO();
nUpdatedProductID = productLanguageBso.CreateOrUpdate(DTO, Ado);
if (nUpdatedProductID == 0)
{
Log.Instance.Debug("Update of ProductLanguage failed");
Response.error = Label.Get("error.update");
return(false);
}
}
if (DTO.PrcCodeNew == null)
{
DTO.PrcCodeNew = DTO.PrcCode;
}
bool IsDefault = DTO.LngIsoCode == Configuration_BSO.GetCustomConfig("language.iso.code");
nUpdatedProductID = adoProduct.Update(DTO, IsDefault, SamAccountName);
if (nUpdatedProductID == 0)
{
Log.Instance.Debug("Update of Product failed");
Response.error = Label.Get("error.update");
return(false);
}
//Finally we must recreate the mandatory keywords in line with the updated product
kpBso.Create(Ado, DTO, nUpdatedProductID);
Response.data = JSONRPC.success;
return(true);
}
/// <summary>
/// Execute
/// </summary>
/// <returns></returns>
protected override bool Execute()
{
var adoProduct = new Product_ADO(Ado);
int nUpdatedProductID = 0;
//Check if the product exists
if (!adoProduct.ExistsCode(DTO.PrcCode))
{
Response.error = Label.Get("error.update");
return(false);
}
//Duplicate product names aren't allowed, so we check first
if (adoProduct.Exists(DTO.PrcValue, DTO.SbjCode)) //|| )
{
Response.error = Label.Get("error.duplicate");
return(false);
}
if (DTO.PrcCodeNew != null)
{
if (adoProduct.ExistsCode(DTO.PrcCodeNew) && DTO.PrcCode != DTO.PrcCodeNew)
{
Response.error = Label.Get("error.duplicate");
return(false);
}
}
//We must delete all of the mandatory product keywords for the product
Keyword_Product_BSO_Mandatory kpBso = new Keyword_Product_BSO_Mandatory();
int nchanged = kpBso.Delete(Ado, DTO, true);
if (nchanged == 0)
{
Log.Instance.Debug("Delete of keywords failed");
}
//Update and retrieve the number of updated rows
if (DTO.LngIsoCode != Configuration_BSO.GetCustomConfig(ConfigType.global, "language.iso.code"))
{
ProductLangauge_BSO productLanguageBso = new ProductLangauge_BSO();
nUpdatedProductID = productLanguageBso.CreateOrUpdate(DTO, Ado);
if (nUpdatedProductID == 0)
{
Log.Instance.Debug("Update of ProductLanguage failed");
Response.error = Label.Get("error.update");
return(false);
}
}
if (DTO.PrcCodeNew == null)
{
DTO.PrcCodeNew = DTO.PrcCode;
}
bool IsDefault = DTO.LngIsoCode == Configuration_BSO.GetCustomConfig(ConfigType.global, "language.iso.code");
nUpdatedProductID = adoProduct.Update(DTO, IsDefault, SamAccountName);
if (nUpdatedProductID == 0)
{
Log.Instance.Debug("Update of Product failed");
Response.error = Label.Get("error.update");
return(false);
}
//Finally we must recreate the mandatory keywords in line with the updated product
kpBso.Create(Ado, DTO, nUpdatedProductID);
//Flush the cache for search - it's now out of date
MemCacheD.CasRepositoryFlush(Resources.Constants.C_CAS_NAVIGATION_SEARCH);
MemCacheD.CasRepositoryFlush(Resources.Constants.C_CAS_NAVIGATION_READ);
//Flush caches for each MtrCode affected by this change
var mtrResult = adoProduct.GetMtrCodeListForProduct(DTO);
if (mtrResult.hasData)
{
foreach (var mtrCode in mtrResult.data)
{
MemCacheD.CasRepositoryFlush(Resources.Constants.C_CAS_DATA_CUBE_READ_DATASET + mtrCode.MtrCode);
MemCacheD.CasRepositoryFlush(Resources.Constants.C_CAS_DATA_CUBE_READ_METADATA + mtrCode.MtrCode);
}
}
//Flush caches for each RlsCode affected by this change
var rlsResult = adoProduct.GetRlsCodeListForProduct(DTO);
if (rlsResult.hasData)
{
foreach (var rlsCode in rlsResult.data)
{
MemCacheD.CasRepositoryFlush(Resources.Constants.C_CAS_DATA_CUBE_READ_PRE_DATASET + rlsCode.RlsCode);
MemCacheD.CasRepositoryFlush(Resources.Constants.C_CAS_DATA_CUBE_READ_PRE_METADATA + rlsCode.RlsCode);
}
}
Response.data = JSONRPC.success;
return(true);
}