public int GetId(string criteriaCode, string criteriaValueCode) { List <CriteriaValueDbModel> criteriaValues = GetAllValues(criteriaCode); CriteriaValueDbModel criteriaValue = criteriaValues.FirstOrDefault(x => x.CodeCriteriaValue == criteriaValueCode); return(criteriaValue != null ? criteriaValue.Id : 0); }
public List <CriteriaValueDbModel> GetAllValues(string criteriaCode) { var criteriaValues = new List <CriteriaValueDbModel>(); int idCriteria = _criteriaRepository.GetId(criteriaCode); var sqlCommand = new SqlCommand(); string sqlQuery = @" SELECT * FROM CriteriaValue WHERE RefCriteria = @IdCriteria " ; sqlCommand.CommandText = sqlQuery; sqlCommand.Parameters.AddWithValue("@IdCriteria", idCriteria); IEnumerable <CustomDataRow> dataRowCollection = _sqlServerDatabase.GetCustomDataRowCollection(sqlCommand); foreach (var dataRow in dataRowCollection) { var criteriaValue = new CriteriaValueDbModel(); criteriaValue.Id = ConversionHelper.ToInt(dataRow["IdCriteriaValue"]); criteriaValue.CodeCriteriaValue = ConversionHelper.ToString(dataRow["CodeCriteriaValue"]); criteriaValue.IsActive = ConversionHelper.ToBoolean(dataRow["IsActive"]); criteriaValue.SequenceOrder = ConversionHelper.ToInt(dataRow["SequenceOrder"]); criteriaValue.RefCriteria = ConversionHelper.ToInt(dataRow["RefCriteria"]); criteriaValue.RefLabelCriteriaValueName = ConversionHelper.ToInt(dataRow["RefLabelCriteriaValueName"]); criteriaValue.DateTimeCreatedOn = ConversionHelper.ToDateTime(dataRow["DateTimeCreatedOn"]); criteriaValues.Add(criteriaValue); } return(criteriaValues); }