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