public IList <ICodeValueVO> RetrieveCommonCodesByCodeSetAndRefCode(string codeSetCode, string referenceCode)
{
if (!String.IsNullOrEmpty(codeSetCode) && !String.IsNullOrEmpty(referenceCode))
{
string query = RETRIEVE_CODE_VALUE_BY_CODE_SET
+ " AND cv.code_value_parent_code = @ReferenceCode "
+ SORT_CODE_VALUE;
IDbParametersBuilder builder = CreateDbParametersBuilder();
builder.Create().Name("CodeSetCode").Type(DbType.String).Size(50).Value(codeSetCode);
builder.Create().Name("ReferenceCode").Type(DbType.String).Size(50).Value(referenceCode);
return((IList <ICodeValueVO>)
AdoTemplate.QueryWithRowMapperDelegate(
CommandType.Text,
query,
delegate(IDataReader dataReader, int rowNum)
{
ICodeValueVO codeValue = new CodeValueVO();
codeValue.Id = dataReader.GetSafeInt32("id");
codeValue.Code = dataReader.GetSafeString("code");
codeValue.Description = dataReader.GetSafeString("code_value");
return codeValue;
},
builder.GetParameters()
));
}
return(null);
}
public IList <ICodeValueVO> RetrieveCommonCodesByCodeSet(string codeSetCode)
{
if (!String.IsNullOrEmpty(codeSetCode))
{
string query = RETRIEVE_CODE_VALUE_BY_CODE_SET + SORT_CODE_VALUE;
return((IList <ICodeValueVO>)
AdoTemplate.QueryWithRowMapperDelegate(
CommandType.Text,
query,
delegate(IDataReader dataReader, int rowNum)
{
ICodeValueVO codeValue = new CodeValueVO();
codeValue.Id = dataReader.GetSafeInt32("id");
codeValue.Code = dataReader.GetSafeString("code");
codeValue.Description = dataReader.GetSafeString("code_value");
return codeValue;
},
"CodeSetCode",
DbType.String,
50,
codeSetCode
));
}
return(null);
}
