Devart Forums

Code: Select all

private void hhrcv_update_dc_grs_carton()
        {
            OracleCommand cmd = new OracleCommand();
            cmd.Connection = conn;
            conn.Open();
            OracleTransaction trans = conn.BeginTransaction();
            cmd.CommandTimeout = 0;
            cmd.CommandText = "dc.hhrcv_update_dc_grs_carton";
            cmd.CommandType = CommandType.StoredProcedure;
            cmd.Parameters.Add("pn_dc_grs_no", OracleDbType.Number).Value =  txtDcGRSNo.Text;
            cmd.Parameters.Add("pn_pallet_id_no", OracleDbType.Number).Value = txtPalletId.Text;
            cmd.Parameters.Add("pn_carton_code", OracleDbType.VarChar).Value = txtCartonCode.Text;
            cmd.Parameters.Add("pn_company_id_no", OracleDbType.Number).Value = Companyid;
            cmd.Parameters.Add("pn_order_no", OracleDbType.Number).Value = txtOrderno.Text;
            cmd.Parameters.Add("pn_emp_id_no", OracleDbType.Number).Value = empid;
            cmd.Parameters.Add(new OracleParameter("pv_error", OracleDbType.VarChar));
            cmd.Parameters["pv_error"].Direction = ParameterDirection.Output;
            string pv_error;
            cmd.ExecuteNonQuery();
            pv_error = cmd.Parameters["pv_error"].Value.ToString();

            if (pv_error.ToString() == "")
            {
                trans.Commit();
                
            }
            else
            {
                trans.Rollback();
                MessageBox.Show("" + pv_error, "Error");
                frmReturns r = new frmReturns();
                r.Show();
                this.Hide();
            }
        }

Code: Select all

private void hhrcv_update_dc_grs_carton()
        {
            conn.Open();
            OracleCommand cmd = new OracleCommand();
            OracleTransaction trans;
            trans = conn.BeginTransaction(System.Data.IsolationLevel.ReadCommitted);
            cmd.Transaction = trans;
            cmd.Connection = conn;
            //conn.AutoCommit = false;
            cmd.CommandTimeout = 0;
            cmd.CommandText = "dc.FAILhhrcv_update_dc_grs_carton";
            cmd.CommandType = CommandType.StoredProcedure;
            cmd.Parameters.Add("pn_dc_grs_no", OracleDbType.Number).Value = txtDcGRSNo.Text;
            cmd.Parameters.Add("pn_pallet_id_no", OracleDbType.Number).Value = txtPalletId.Text;
            cmd.Parameters.Add("pn_carton_code", OracleDbType.VarChar).Value = txtCartonCode.Text;
            cmd.Parameters.Add("pn_company_id_no", OracleDbType.Number).Value = Companyid;
            cmd.Parameters.Add("pn_order_no", OracleDbType.Number).Value = txtOrderno.Text;
            cmd.Parameters.Add("pn_emp_id_no", OracleDbType.Number).Value = empid;
            cmd.Parameters.Add(new OracleParameter("pv_error", OracleDbType.VarChar));
            cmd.Parameters["pv_error"].Direction = ParameterDirection.Output;
            string pv_error;
            cmd.ExecuteNonQuery();
            pv_error = cmd.Parameters["pv_error"].Value.ToString();

            if (pv_error.ToString() == "")
            {
                trans.Commit();
            }
            else
            {
                trans.Rollback();
                MessageBox.Show("" + pv_error, "Error");
                frmReturns r = new frmReturns();
                r.Show();
                this.Hide();
            }
        }