public Reaction Get(Int64 id, string lang) { _reaction = dbConnection.GetReactionById(id, lang); return(_reaction); }
//used by detail page public List<Reaction> GetReactionByReportId(string reportId, string lang) { var reaction = new List<Reaction>(); string commandText = "SELECT DISTINCT REACTION_ID, REPORT_ID, DURATION, MEDDRA_VERSION, "; if (lang.Equals("fr")) { commandText += " DURATION_UNIT_FR as DURATION_UNIT, PT_NAME_FR as PT_NAME, SOC_NAME_FR as SOC_NAME"; } else { commandText += " DURATION_UNIT_ENG as DURATION_UNIT, PT_NAME_ENG as PT_NAME, SOC_NAME_ENG as SOC_NAME"; } commandText += " FROM CVPONL_OWNER.REACTIONS WHERE REPORT_ID = :reportId "; commandText += " ORDER BY UPPER(PT_NAME) "; using ( OracleConnection con = new OracleConnection(DpdDBConnection)) { OracleCommand cmd = new OracleCommand(commandText, con); cmd.Parameters.Add(":reportId", reportId); try { con.Open(); using (OracleDataReader dr = cmd.ExecuteReader()) { if (dr.HasRows) { while (dr.Read()) { var item = new Reaction(); item.reaction_id = dr["REACTION_ID"] == DBNull.Value ? 0 : Convert.ToInt64(dr["REACTION_ID"]); item.report_id = dr["REPORT_ID"] == DBNull.Value ? 0 : Convert.ToInt32(dr["REPORT_ID"]); item.duration = dr["DURATION"] == DBNull.Value ? 0 : Convert.ToInt32(dr["DURATION"]); item.duration_unit = dr["DURATION_UNIT"] == DBNull.Value ? string.Empty : dr["DURATION_UNIT"].ToString().Trim(); item.pt_name = dr["PT_NAME"] == DBNull.Value ? string.Empty : dr["PT_NAME"].ToString().Trim(); item.soc_name = dr["SOC_NAME"] == DBNull.Value ? string.Empty : dr["SOC_NAME"].ToString().Trim(); item.meddra_version = dr["MEDDRA_VERSION"] == DBNull.Value ? string.Empty : dr["MEDDRA_VERSION"].ToString().Trim(); reaction.Add(item); } } } } catch (Exception ex) { string errorMessages = string.Format("DbConnection.cs - GetReactionByReportId(reportId, lang)"); ExceptionHelper.LogException(ex, errorMessages); Console.WriteLine(errorMessages); } finally { if (con.State == ConnectionState.Open) con.Close(); } } return reaction; }
public Reaction Get(int id, string lang) { _reaction = dbConnection.GetReactionById(id, lang); return _reaction; }