public decimal Update(Inventor_Info pInfo) { try { OracleParameter paramReturn = new OracleParameter("p_return", OracleDbType.Decimal, ParameterDirection.Output); OracleHelper.ExecuteNonQuery(Configuration.connectionString, CommandType.StoredProcedure, "pkg_inventors.proc_update", new OracleParameter("p_id", OracleDbType.Decimal, pInfo.Id, ParameterDirection.Input), new OracleParameter("p_case_code", OracleDbType.Decimal, pInfo.Case_Code, ParameterDirection.Input), new OracleParameter("p_inventor_type", OracleDbType.Decimal, pInfo.Inventor_Type, ParameterDirection.Input), new OracleParameter("p_inventor_name", OracleDbType.Varchar2, pInfo.Inventor_Name, ParameterDirection.Input), new OracleParameter("p_inventor_address", OracleDbType.Varchar2, pInfo.Inventor_Address, ParameterDirection.Input), new OracleParameter("p_inventor_phone", OracleDbType.Varchar2, pInfo.Inventor_Phone, ParameterDirection.Input), new OracleParameter("p_inventor_fax", OracleDbType.Varchar2, pInfo.Inventor_Fax, ParameterDirection.Input), new OracleParameter("p_inventor_email", OracleDbType.Varchar2, pInfo.Inventor_Email, ParameterDirection.Input), new OracleParameter("p_country_nationality", OracleDbType.Decimal, pInfo.Country_Nationality, ParameterDirection.Input), new OracleParameter("p_country_residence", OracleDbType.Decimal, pInfo.Country_Residence, ParameterDirection.Input), new OracleParameter("p_country_incorporation", OracleDbType.Decimal, pInfo.Country_Incorporation, ParameterDirection.Input), paramReturn); var result = Convert.ToDecimal(paramReturn.Value.ToString()); return(result); } catch (Exception ex) { Logger.LogException(ex); return(ErrorCode.Error); } }
public decimal Update(Inventor_Info pInfo) { try { Inventor_DA _obj_da = new Inventor_DA(); return(_obj_da.Update(pInfo)); } catch (Exception ex) { Logger.LogException(ex); return(ErrorCode.Error); } }