public Packaging Get(int id) { packaging = dbConnection.GetPackagingByDrugCode(id); return(packaging); }
public Packaging Get(int id, string lang) { _packaging = dbConnection.GetPackagingByDrugCode(id, lang); return _packaging; }
public Packaging GetPackagingByDrugCode(int id, string lang) { var packaging = new Packaging(); string commandText = "SELECT * FROM DPD_ONLINE_OWNER.WQRY_PACKAGING WHERE WQRY_PACKAGING_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 Packaging(); item.packaging_id = dr["WQRY_PACKAGING_ID"] == DBNull.Value ? 0 : Convert.ToInt32(dr["WQRY_PACKAGING_ID"]); item.drug_code = dr["DRUG_CODE"] == DBNull.Value ? 0 : Convert.ToInt32(dr["DRUG_CODE"]); item.upc = dr["UPC"] == DBNull.Value ? string.Empty : dr["UPC"].ToString().Trim(); item.package_size_unit = dr["PACKAGE_SIZE_UNIT"] == DBNull.Value ? string.Empty : dr["PACKAGE_SIZE_UNIT"].ToString().Trim(); item.package_type = dr["PACKAGE_TYPE"] == DBNull.Value ? string.Empty : dr["PACKAGE_TYPE"].ToString().Trim(); item.package_size = dr["PACKAGE_SIZE"] == DBNull.Value ? string.Empty : dr["PACKAGE_SIZE"].ToString().Trim(); item.product_information = dr["PRODUCT_INFORMATION"] == DBNull.Value ? string.Empty : dr["PRODUCT_INFORMATION"].ToString().Trim(); packaging = item; } } } } catch (Exception ex) { string errorMessages = string.Format("DbConnection.cs - GetPackagingByDrugCode()"); ExceptionHelper.LogException(ex, errorMessages); } finally { if (con.State == ConnectionState.Open) con.Close(); } } return packaging; }