public decimal Update(Other_MasterInfo pInfo) { try { OracleParameter paramReturn = new OracleParameter("p_return", OracleDbType.Decimal, ParameterDirection.Output); OracleHelper.ExecuteNonQuery(Configuration.connectionString, CommandType.StoredProcedure, "pkg_other_master.proc_other_master_update", new OracleParameter("p_id", OracleDbType.Decimal, pInfo.Id, ParameterDirection.Input), new OracleParameter("p_app_header_id", OracleDbType.Decimal, pInfo.App_Header_Id, ParameterDirection.Input), new OracleParameter("p_case_code", OracleDbType.Varchar2, pInfo.Case_Code, ParameterDirection.Input), new OracleParameter("p_master_name", OracleDbType.Varchar2, pInfo.Master_Name, ParameterDirection.Input), new OracleParameter("p_master_address", OracleDbType.Varchar2, pInfo.Master_Address, ParameterDirection.Input), new OracleParameter("p_master_phone", OracleDbType.Varchar2, pInfo.PhoBan, ParameterDirection.Input), new OracleParameter("p_master_fax", OracleDbType.Varchar2, pInfo.Master_Fax, ParameterDirection.Input), new OracleParameter("p_master_email", OracleDbType.Varchar2, pInfo.Master_Email, ParameterDirection.Input), new OracleParameter("p_tacgiadongthoi", OracleDbType.Varchar2, pInfo.TacGiaDongThoi, ParameterDirection.Input), new OracleParameter("p_phoban", OracleDbType.Varchar2, pInfo.PhoBan, 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(Other_MasterInfo pInfo) { try { Other_Master_DA _obj_da = new Other_Master_DA(); return(_obj_da.Update(pInfo)); } catch (Exception ex) { Logger.LogException(ex); return(ErrorCode.Error); } }