public ReportLink Get(int id, string lang) { _reportLink = dbConnection.GetReportLinkById(id, lang); return _reportLink; }
public ReportLink GetReportLinkById(int id, string lang) { var reportLinks = new ReportLink(); string commandText = "SELECT DISTINCT REPORT_LINK_ID, REPORT_ID, REPORT_LINK,"; if (lang.Equals("fr")) { commandText += " RECORD_TYPE_FR as RECORD_TYPE"; } else { commandText += " RECORD_TYPE_ENG as RECORD_TYPE"; } commandText += " FROM CVPONL_OWNER.REPORT_LINKS WHERE REPORT_LINK_ID = " + 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 ReportLink(); item.report_link_id = dr["REPORT_LINK_ID"] == DBNull.Value ? 0 : Convert.ToInt32(dr["REPORT_LINK_ID"]); item.report_id = dr["REPORT_ID"] == DBNull.Value ? 0 : Convert.ToInt32(dr["REPORT_ID"]); item.record_type = dr["RECORD_TYPE"] == DBNull.Value ? string.Empty : dr["RECORD_TYPE"].ToString().Trim(); item.report_link_no = dr["REPORT_LINK"] == DBNull.Value ? string.Empty : dr["REPORT_LINK"].ToString().Trim(); reportLinks = item; } } } } catch (Exception ex) { string errorMessages = string.Format("DbConnection.cs - GetReportLinksLxById()"); ExceptionHelper.LogException(ex, errorMessages); Console.WriteLine(errorMessages); } finally { if (con.State == ConnectionState.Open) con.Close(); } } return reportLinks; }