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);
}
}
