public NoticeOfComplianceMain GetNoticeOfComplianceMainById(int id, string lang = "") { NoticeOfComplianceMain route = databasePlaceholder.Get(id, lang); //if (route == null) //{ // throw new HttpResponseException(HttpStatusCode.NotFound); //} return(route); }
public NoticeOfComplianceMain GetNoticeOfComplianceMainById(int id) { var form = new NoticeOfComplianceMain(); //string commandText = "SELECT NOC_NUMBER, NOC_DATE, NOC_SUBMISSION_NUMBER, NOC_MANUFACTURER_NAME, NOC_STATUS_WITH_CONDITIONS, NOC_IS_SUPPLIMENT, NOC_IS_ADMIN, NOC_FILE_NUMBER, NOC_CRP_PRODUCT_NAME, NOC_CRP_COMPANY_NAME, NOC_ACTIVE_STATUS, NOC_SCANNED_PAGE, NOC_NOTES_ENTRY_DATE, NOC_LAST_UPDATE_DATE, NOC_ENTRY_DATE, "; string commandText = "SELECT NOC_NUMBER, NOC_DATE, NOC_MANUFACTURER_NAME, NOC_STATUS_WITH_CONDITIONS, NOC_IS_SUPPLIMENT, NOC_IS_ADMIN, NOC_CRP_PRODUCT_NAME, NOC_CRP_COMPANY_NAME, NOC_ACTIVE_STATUS, NOC_LAST_UPDATE_DATE, "; if (this.Lang != null && this.Lang.Equals("fr")) { commandText += "NOC_CRP_COUNTRY_FR_NAME AS NOC_CRP_COUNTRY_NAME, "; commandText += "NOC_QN_FRENCH_FNAME AS NOC_QN_FNAME, "; commandText += "NOC_DHCPL_FRENCH_FNAME AS NOC_DHCPL_FNAME, "; commandText += "NOC_FACTSHEET_FRENCH_FNAME AS NOC_FACTSHEET_FNAME, "; commandText += "NOC_FR_SUBMISSION_TYPE AS NOC_ON_SUBMISSION_TYPE, "; commandText += "NOC_FR_SUBMISSION_CLASS AS NOC_SUBMISSION_CLASS, "; commandText += "NOC_FR_PRODUCT_TYPE AS NOC_PRODUCT_TYPE, "; commandText += "NOC_FR_REASON_SUPPLEMENT AS NOC_REASON_SUPPLEMENT, "; commandText += "NOC_FR_REASON_SUBMISSION AS NOC_REASON_SUBMISSION, "; commandText += "NOC_FR_THERAPEUTIC_CLASS AS NOC_THERAPEUTIC_CLASS, "; commandText += "NOC_FR_NOTES AS NOC_NOTES, "; commandText += "NOC_SBD_FRENCH_FNAME AS NOC_SBD_FNAME, "; commandText += "NOC_ND_FRENCH_FNAME AS NOC_ND_FNAME,"; commandText += "NOC_CI_PART_III_FRENCH_FNAME AS NOC_CI_PART_III_FNAME, "; commandText += "NOC_PM_FRENCH_FNAME AS NOC_PM_FNAME"; //DEBUGGED CODE 20170123 Above and below. } else { commandText += "NOC_CRP_COUNTRY_ENG_NAME AS NOC_CRP_COUNTRY_NAME, "; commandText += "NOC_QN_ENGLISH_FNAME AS NOC_QN_FNAME, "; commandText += "NOC_DHCPL_ENGLISH_FNAME AS NOC_DHCPL_FNAME, "; commandText += "NOC_FACTSHEET_ENGLISH_FNAME AS NOC_FACTSHEET_FNAME, "; commandText += "NOC_ENG_SUBMISSION_TYPE AS NOC_ON_SUBMISSION_TYPE, "; commandText += "NOC_ENG_SUBMISSION_CLASS AS NOC_SUBMISSION_CLASS, "; commandText += "NOC_ENG_PRODUCT_TYPE AS NOC_PRODUCT_TYPE, "; commandText += "NOC_ENG_REASON_SUPPLEMENT AS NOC_REASON_SUPPLEMENT, "; commandText += "NOC_ENG_REASON_SUBMISSION AS NOC_REASON_SUBMISSION, "; commandText += "NOC_ENG_THERAPEUTIC_CLASS AS NOC_THERAPEUTIC_CLASS, "; commandText += "NOC_ENG_NOTES AS NOC_NOTES, "; commandText += "NOC_SBD_ENGLISH_FNAME AS NOC_SBD_FNAME, "; commandText += "NOC_ND_ENGLISH_FNAME AS NOC_ND_FNAME,"; commandText += "NOC_CI_PART_III_ENGLISH_FNAME AS NOC_CI_PART_III_FNAME, "; commandText += "NOC_PM_ENGLISH_FNAME AS NOC_PM_FNAME"; } commandText += " FROM NOC_ONLINE_OWNER.QRY_NOC_MAIN"; commandText += " WHERE NOC_NUMBER = :id "; using (OracleConnection con = new OracleConnection(DpdDBConnection)) { OracleCommand cmd = new OracleCommand(commandText, con); cmd.Parameters.Add(":id", id); try { con.Open(); using (OracleDataReader dr = cmd.ExecuteReader()) { if (dr.HasRows) { while (dr.Read()) { form.noc_number = dr["NOC_NUMBER"] == DBNull.Value ? 0 : Convert.ToInt32(dr["NOC_NUMBER"]); form.noc_date = dr["NOC_DATE"] == DBNull.Value ? (DateTime?)null : Convert.ToDateTime(dr["NOC_DATE"]); //form.noc_submission_number = dr["NOC_SUBMISSION_NUMBER"] == DBNull.Value ? string.Empty : dr["NOC_SUBMISSION_NUMBER"].ToString().Trim(); form.noc_manufacturer_name = dr["NOC_MANUFACTURER_NAME"] == DBNull.Value ? string.Empty : dr["NOC_MANUFACTURER_NAME"].ToString().Trim(); form.noc_status_with_conditions = dr["NOC_STATUS_WITH_CONDITIONS"] == DBNull.Value ? string.Empty : dr["NOC_STATUS_WITH_CONDITIONS"].ToString().Trim(); //form.noc_qn_fname = dr["NOC_QN_FNAME"] == DBNull.Value ? string.Empty : dr["NOC_QN_FNAME"].ToString().Trim(); form.noc_crp_country_name = dr["NOC_CRP_COUNTRY_NAME"] == DBNull.Value ? string.Empty : dr["NOC_CRP_COUNTRY_NAME"].ToString().Trim(); //form.noc_dhcpl_fname = dr["NOC_DHCPL_FNAME"] == DBNull.Value ? string.Empty : dr["NOC_DHCPL_FNAME"].ToString().Trim(); //form.noc_factsheet_fname = dr["NOC_FACTSHEET_FNAME"] == DBNull.Value ? string.Empty : dr["NOC_FACTSHEET_FNAME"].ToString().Trim(); form.noc_on_submission_type = dr["NOC_ON_SUBMISSION_TYPE"] == DBNull.Value ? string.Empty : dr["NOC_ON_SUBMISSION_TYPE"].ToString().Trim(); form.noc_is_suppliment = dr["NOC_IS_SUPPLIMENT"] == DBNull.Value ? string.Empty : dr["NOC_IS_SUPPLIMENT"].ToString().Trim(); form.noc_submission_class = dr["NOC_SUBMISSION_CLASS"] == DBNull.Value ? string.Empty : dr["NOC_SUBMISSION_CLASS"].ToString().Trim(); form.noc_is_admin = dr["NOC_IS_ADMIN"] == DBNull.Value ? string.Empty : dr["NOC_IS_ADMIN"].ToString().Trim(); form.noc_product_type = dr["NOC_PRODUCT_TYPE"] == DBNull.Value ? string.Empty : dr["NOC_PRODUCT_TYPE"].ToString().Trim(); //form.noc_file_number = dr["NOC_FILE_NUMBER"] == DBNull.Value ? string.Empty : dr["NOC_FILE_NUMBER"].ToString().Trim(); form.noc_crp_product_name = dr["NOC_CRP_PRODUCT_NAME"] == DBNull.Value ? string.Empty : dr["NOC_CRP_PRODUCT_NAME"].ToString().Trim(); form.noc_crp_company_name = dr["NOC_CRP_COMPANY_NAME"] == DBNull.Value ? string.Empty : dr["NOC_CRP_COMPANY_NAME"].ToString().Trim(); form.noc_active_status = dr["NOC_ACTIVE_STATUS"] == DBNull.Value ? string.Empty : dr["NOC_ACTIVE_STATUS"].ToString().Trim(); //form.noc_scanned_page = dr["NOC_SCANNED_PAGE"] == DBNull.Value ? string.Empty : dr["NOC_SCANNED_PAGE"].ToString().Trim(); form.noc_reason_supplement = dr["NOC_REASON_SUPPLEMENT"] == DBNull.Value ? string.Empty : dr["NOC_REASON_SUPPLEMENT"].ToString().Trim(); form.noc_reason_submission = dr["NOC_REASON_SUBMISSION"] == DBNull.Value ? string.Empty : dr["NOC_REASON_SUBMISSION"].ToString().Trim(); form.noc_therapeutic_class = dr["NOC_THERAPEUTIC_CLASS"] == DBNull.Value ? string.Empty : dr["NOC_THERAPEUTIC_CLASS"].ToString().Trim(); //form.noc_notes = dr["NOC_NOTES"] == DBNull.Value ? string.Empty : dr["NOC_NOTES"].ToString().Trim(); //form.noc_notes_entry_date = dr["NOC_NOTES_ENTRY_DATE"] == DBNull.Value ? (DateTime?)null : Convert.ToDateTime(dr["NOC_NOTES_ENTRY_DATE"]); form.noc_last_update_date = dr["NOC_LAST_UPDATE_DATE"] == DBNull.Value ? (DateTime?)null : Convert.ToDateTime(dr["NOC_LAST_UPDATE_DATE"]); //form.noc_entry_date = dr["NOC_ENTRY_DATE"] == DBNull.Value ? (DateTime?)null : Convert.ToDateTime(dr["NOC_ENTRY_DATE"]); //form.noc_sbd_fname = dr["NOC_SBD_FNAME"] == DBNull.Value ? string.Empty : dr["NOC_SBD_FNAME"].ToString().Trim(); //form.noc_nd_fname = dr["NOC_ND_FNAME"] == DBNull.Value ? string.Empty : dr["NOC_ND_FNAME"].ToString().Trim(); //form.noc_ci_part_iii_fname = dr["NOC_CI_PART_III_FNAME"] == DBNull.Value ? string.Empty : dr["NOC_CI_PART_III_FNAME"].ToString().Trim(); //form.noc_pm_fname = dr["NOC_PM_FNAME"] == DBNull.Value ? string.Empty : dr["NOC_PM_FNAME"].ToString().Trim(); } } } } catch (Exception ex) { string errorMessages = string.Format("DbConnection.cs - GetNoticeOfComplianceMainById()"); ExceptionHelper.LogException(ex, errorMessages); } finally { if (con.State == ConnectionState.Open) { con.Close(); } } } return(form); } // END of NoticeOfComplianceMain