public decimal Update(UTienInfo pInfo) { try { UuTien_DA _obj_da = new UuTien_DA(); return(_obj_da.Update(pInfo)); } catch (Exception ex) { Logger.LogException(ex); return(ErrorCode.Error); } }
public decimal Update(UTienInfo pInfo) { try { OracleParameter paramReturn = new OracleParameter("p_return", OracleDbType.Decimal, ParameterDirection.Output); OracleHelper.ExecuteNonQuery(Configuration.connectionString, CommandType.StoredProcedure, "pkg_app_don_uu_tien.proc_app_don_uu_tien_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_ut_sodon", OracleDbType.Varchar2, pInfo.UT_SoDon, ParameterDirection.Input), new OracleParameter("p_ut_ngaynopdon", OracleDbType.Date, pInfo.UT_NgayNopDon, ParameterDirection.Input), new OracleParameter("p_ut_quocgia", OracleDbType.Decimal, pInfo.UT_QuocGia, ParameterDirection.Input), new OracleParameter("p_ut_type", OracleDbType.Varchar2, pInfo.UT_Type, ParameterDirection.Input), new OracleParameter("p_ut_thoathuankhac", OracleDbType.Varchar2, pInfo.UT_ThoaThuanKhac, ParameterDirection.Input), paramReturn); var result = Convert.ToDecimal(paramReturn.Value.ToString()); return(result); } catch (Exception ex) { Logger.LogException(ex); return(ErrorCode.Error); } }