/// <summary>
/// Update a Keyword Release
/// </summary>
/// <param name="ado"></param>
/// <param name="dto"></param>
/// <returns></returns>
internal int Update(ADO ado, Keyword_Release_DTO dto)
{
var inputParams = new List <ADO_inputParams>()
{
new ADO_inputParams()
{
name = "@KrlValue", value = dto.KrlValue
},
new ADO_inputParams()
{
name = "@KrlCode", value = dto.KrlCode
},
new ADO_inputParams()
{
name = "@KrlSingularisedFlag", value = dto.LngIsoCode != null
}
};
var returnParam = new ADO_returnParam()
{
name = "@ReturnVal", value = 0
};
ado.ExecuteNonQueryProcedure("System_Navigation_Keyword_Release_Update", inputParams, ref returnParam);
return((int)returnParam.value);
}
/// <summary>
/// Reads a Keyword Release. Optional parameters are KrlCode and RlsCode
/// </summary>
/// <param name="ado"></param>
/// <param name="dto"></param>
/// <returns></returns>
internal ADO_readerOutput Read(ADO ado, Keyword_Release_DTO dto)
{
ADO_readerOutput output = new ADO_readerOutput();
var inputParams = new List <ADO_inputParams>();
if (dto.KrlCode != default(int))
{
inputParams.Add(new ADO_inputParams()
{
name = "@KrlCode", value = dto.KrlCode
});
}
if (dto.RlsCode != default(int))
{
inputParams.Add(new ADO_inputParams()
{
name = "@RlsCode", value = dto.RlsCode
});
}
output = ado.ExecuteReaderProcedure("System_Navigation_Keyword_Release_Read", inputParams);
return(output);
}
