public TherapeuticClass GetTherapeuticClassByDrugCode(int id, string lang) { var therapeuticClass = new TherapeuticClass(); string commandText = "SELECT * FROM DPD_ONLINE_OWNER.WQRY_THERAPEUTIC_CLASS WHERE DRUG_CODE = " + id; using ( OracleConnection con = new OracleConnection(DpdDBConnection)) { OracleCommand cmd = new OracleCommand(commandText, con); try { con.Open(); using (OracleDataReader dr = cmd.ExecuteReader()) { if (dr.HasRows) { while (dr.Read()) { var item = new TherapeuticClass(); item.tc_atc_code = dr["TC_ATC_CODE"] == DBNull.Value ? 0 : Convert.ToInt32(dr["TC_ATC_CODE"]); item.tc_atc_number = dr["TC_ATC_NUMBER"] == DBNull.Value ? string.Empty : dr["TC_ATC_NUMBER"].ToString().Trim(); if (lang.Equals("fr")) { item.tc_atc_desc_name = dr["TC_ATC_DESC_F"] == DBNull.Value ? string.Empty : dr["TC_ATC_DESC_F"].ToString().Trim(); } else { item.tc_atc_desc_name = dr["TC_ATC_DESC"] == DBNull.Value ? string.Empty : dr["TC_ATC_DESC"].ToString().Trim(); } therapeuticClass = item; } } } } catch (Exception ex) { string errorMessages = string.Format("DbConnection.cs - GetTherapeuticClassByDrugCode()"); ExceptionHelper.LogException(ex, errorMessages); } finally { if (con.State == ConnectionState.Open) con.Close(); } } return therapeuticClass; }
public TherapeuticClass Get(int id, string lang) { _therapeuticClass = dbConnection.GetTherapeuticClassByDrugCode(id, lang); return _therapeuticClass; }
public List<TherapeuticClass> GetAllTherapeuticClass(string lang) { var items = new List<TherapeuticClass>(); string commandText = "SELECT * FROM DPD_ONLINE_OWNER.WQRY_TC_FOR_ATC"; using (OracleConnection con = new OracleConnection(DpdDBConnection)) { OracleCommand cmd = new OracleCommand(commandText, con); OracleCommand test = new OracleCommand("SELECT table_name FROM all_tables WHERE owner='DPD_ONLINE_OWNER'", con); try { con.Open(); using (OracleDataReader dr = cmd.ExecuteReader()) { if (dr.HasRows) { while (dr.Read()) { var item = new TherapeuticClass(); item.tc_atc_code = dr["TC_ATC_CODE"] == DBNull.Value ? 0 : Convert.ToInt32(dr["TC_ATC_CODE"]); item.tc_atc_number = dr["TC_ATC_NUMBER"] == DBNull.Value ? string.Empty : dr["TC_ATC_NUMBER"].ToString().Trim(); if (lang.Equals("fr")) { item.tc_atc_desc_name = dr["TC_ATC_DESC_F"] == DBNull.Value ? string.Empty : dr["TC_ATC_DESC_F"].ToString().Trim(); } else { item.tc_atc_desc_name = dr["TC_ATC_DESC"] == DBNull.Value ? string.Empty : dr["TC_ATC_DESC"].ToString().Trim(); } items.Add(item); } } } } catch (Exception ex) { string errorMessages = string.Format("DbConnection.cs - GetAllTherapeuticClass()"); ExceptionHelper.LogException(ex, errorMessages); } finally { if (con.State == ConnectionState.Open) con.Close(); } } return items; }