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); }