/// <summary>
/// Reads a list of KeywordProducts
/// </summary>
/// <param name="dto"></param>
/// <returns></returns>
internal List <dynamic> Read(Keyword_Product_DTO dto)
{
var inputParams = new List <ADO_inputParams>();
if (dto.KprCode != default(int))
{
inputParams.Add(new ADO_inputParams {
name = "@KprCode", value = dto.KprCode
});
}
if (dto.PrcCode != null)
{
inputParams.Add(new ADO_inputParams {
name = "@PrcCode", value = dto.PrcCode
});
}
if (dto.SbjCode != default(int))
{
inputParams.Add(new ADO_inputParams {
name = "@SbjCode", value = dto.SbjCode
});
}
var reader = ado.ExecuteReaderProcedure("System_Navigation_Keyword_Product_Read", inputParams);
return(reader.data);
}
/// <summary>
/// Deletes a Keyword Product
/// </summary>
/// <param name="Ado"></param>
/// <param name="dto"></param>
/// <param name="mandatoryOnly"></param>
/// <returns></returns>
internal int Delete(ADO Ado, Product_DTO dto, bool?mandatoryOnly = null)
{
Keyword_Product_ADO kpAdo = new Keyword_Product_ADO(Ado);
Keyword_Product_DTO kpDto = new Keyword_Product_DTO();
kpDto.PrcCode = dto.PrcCode;
if (mandatoryOnly != null)
{
return(kpAdo.Delete(kpDto, mandatoryOnly));
}
else
{
return(kpAdo.Delete(kpDto));
}
}
/// <summary>
/// Creates a Keyword Product from a DTO
/// </summary>
/// <param name="dto"></param>
/// <returns></returns>
internal int Create(Keyword_Product_DTO dto)
{
if (dto.LngIsoCode != null)
{
Keyword_BSO_Extract bse = new Keyword_BSO_Extract(dto.LngIsoCode);
dto.KprValue = bse.Singularize(dto.KprValue);
}
var inputParams = new List <ADO_inputParams>()
{
new ADO_inputParams()
{
name = "@KprValue", value = dto.KprValue
},
new ADO_inputParams()
{
name = "@PrcCode", value = dto.PrcCode
},
new ADO_inputParams()
{
name = "@KprMandatoryFlag", value = dto.KprMandatoryFlag != null? dto.KprMandatoryFlag:false
},
new ADO_inputParams()
{
name = "@KprSingularisedFlag", value = dto.LngIsoCode != null
}
};
var returnParam = new ADO_returnParam()
{
name = "@ReturnVal", value = 0
};
ado.ExecuteNonQueryProcedure("System_Navigation_Keyword_Product_Create", inputParams, ref returnParam);
return((int)returnParam.value);
}
/// <summary>
/// Deletes a KeywordProduct
/// </summary>
/// <param name="dto"></param>
/// <param name="mandatoryOnly"></param>
/// <returns></returns>
internal int Delete(Keyword_Product_DTO dto, bool?mandatoryOnly = null)
{
var inputParams = new List <ADO_inputParams>();
if (dto.KprCode != default(int))
{
inputParams.Add(new ADO_inputParams()
{
name = "@KprCode", value = dto.KprCode
});
}
if (dto.PrcCode != null)
{
inputParams.Add(new ADO_inputParams()
{
name = "@PrcCode", value = dto.PrcCode
});
}
if (mandatoryOnly != null)
{
inputParams.Add(new ADO_inputParams()
{
name = "@KprMandatoryFlag", value = mandatoryOnly
});
}
var returnParam = new ADO_returnParam()
{
name = "@ReturnVal", value = 0
};
ado.ExecuteNonQueryProcedure("System_Navigation_Keyword_Product_Delete", inputParams, ref returnParam);
return((int)returnParam.value);
}