Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- public bool InsertProcessToAS400(iDB2Connection cn, Order order)
- {
- bool result = false;
- try
- {
- var code = GetCodeOfDdtConnected(cn, processCode, order.Code);
- iDB2Command cmd = cn.CreateCommand();
- cmd.CommandText =$"INSERT INTO PCM00F " +
- $"(Code)" +
- $"VALUES(@P1)";
- var p = new iDB2Parameter("@P1", iDB2DbType.iDB2VarChar);
- p.Value = code; cmd.Parameters.Add(p);
- cmd.ExecuteNonQuery(); // <- This close the service
- result = true;
- }
- catch (Exception ex)
- {
- log.Error("An error occurred while Synchronizer (INSERT): ", ex);
- result = false;
- }
- finally
- {
- cmd.Dispose(); cmd = null;
- }
- return result;
- }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement