private MedicinalIngredient executeOne(string query) { MedicinalIngredient item = null; using (OracleConnection con = new OracleConnection(LnhpdDBConnection)) { try { con.Open(); OracleCommand cmd = new OracleCommand(query, con); using (OracleDataReader dr = cmd.ExecuteReader()) { if (dr.HasRows) { dr.Read(); item = MedicinalIngredientFactory(dr); } } } catch (Exception ex) { Console.WriteLine(ex.Message); } finally { if (con.State == ConnectionState.Open) { con.Close(); } } } return(item); }
private MedicinalIngredient MedicinalIngredientFactory(OracleDataReader reader) { var item = new MedicinalIngredient(); item.lnhpd_id = reader["SUBMISSION_ID"] == DBNull.Value ? 0 : idLnhpd(Convert.ToInt32(reader["SUBMISSION_ID"])); item.ingredient_name = reader["INGREDIENT_NAME"] == DBNull.Value ? string.Empty : reader["INGREDIENT_NAME"].ToString().Trim(); //item.matrix_id = reader["MATRIX_ID"] == DBNull.Value ? 0 : Convert.ToInt32(reader["MATRIX_ID"]); //item.matrix_type_code = reader["MATRIX_TYPE_CODE"] == DBNull.Value ? 0 : Convert.ToInt32(reader["MATRIX_TYPE_CODE"]); //item.quantity_list = GetAllIngredientQuantityByMatrixId(item.matrix_id, lang); item.potency_amount = reader["potency_amount"] == DBNull.Value ? 0 : Convert.ToDouble(reader["potency_amount"].ToString()); item.potency_constituent = reader["potency_constituent"] == DBNull.Value ? string.Empty : reader["potency_constituent"].ToString().Trim(); item.potency_unit_of_measure = reader["potency_unit_of_measure"] == DBNull.Value ? string.Empty : reader["potency_unit_of_measure"].ToString().Trim(); item.quantity = reader["quantity"] == DBNull.Value ? 0 : Convert.ToDouble(reader["quantity"].ToString()); item.quantity_minimum = reader["quantity_minimum"] == DBNull.Value ? 0 : Convert.ToDouble(reader["quantity_minimum"].ToString()); item.quantity_maximum = reader["quantity_maximum"] == DBNull.Value ? 0 : Convert.ToDouble(reader["quantity_maximum"].ToString()); item.quantity_unit_of_measure = reader["quantity_unit_of_measure"] == DBNull.Value ? string.Empty : reader["quantity_unit_of_measure"].ToString().Trim(); item.ratio_numerator = reader["ratio_numerator"] == DBNull.Value ? string.Empty : reader["ratio_numerator"].ToString().Trim(); item.ratio_denominator = reader["ratio_denominator"] == DBNull.Value ? string.Empty : reader["ratio_denominator"].ToString().Trim(); item.dried_herb_equivalent = reader["dried_herb_equivalent"] == DBNull.Value ? string.Empty : reader["dried_herb_equivalent"].ToString().Trim(); item.dhe_unit_of_measure = reader["dhe_unit_of_measure"] == DBNull.Value ? string.Empty : reader["dhe_unit_of_measure"].ToString().Trim(); item.extract_type_desc = reader["extract_type_desc"] == DBNull.Value ? string.Empty : reader["extract_type_desc"].ToString().Trim(); item.source_material = reader["source_material"] == DBNull.Value ? string.Empty : reader["source_material"].ToString().Trim(); return(item); }