コード例 #1
0
        public ExceptionTypes UpdateXMLMessage(MQMessagesRecieved objMQMessagesRecieved, out string errorMessage)
        {
            try
            {
                DAHelper dah           = new DAHelper();
                long     lErrocode     = 0;
                long     lErrorNumber  = 0;
                long     lRowsEffected = 0;
                DataSet  dsTable       = new DataSet();
                errorMessage = string.Empty;

                List <SqlParameter> parameters = new List <SqlParameter>();
                SqlParameter        sqlParam;

                sqlParam = new SqlParameter();
                sqlParam.ParameterName = "@MQMessagesRecievedId";
                sqlParam.SqlDbType     = SqlDbType.BigInt;
                sqlParam.Value         = objMQMessagesRecieved.MQMessagesRecievedId;
                parameters.Add(sqlParam);
                sqlParam = new SqlParameter();

                sqlParam = new SqlParameter();
                sqlParam.ParameterName = "@IsProcessed";
                sqlParam.SqlDbType     = SqlDbType.Bit;
                sqlParam.Value         = objMQMessagesRecieved.IsProcessed;
                parameters.Add(sqlParam);
                sqlParam = new SqlParameter();

                sqlParam = new SqlParameter();
                sqlParam.ParameterName = "@ProcessedResult";
                sqlParam.SqlDbType     = SqlDbType.VarChar;
                sqlParam.Value         = objMQMessagesRecieved.ProcessedResult;
                parameters.Add(sqlParam);
                sqlParam = new SqlParameter();

                sqlParam = new SqlParameter();
                sqlParam.ParameterName = "@SystemId";
                sqlParam.SqlDbType     = SqlDbType.BigInt;
                sqlParam.Value         = objMQMessagesRecieved.SystemId;
                parameters.Add(sqlParam);
                sqlParam = new SqlParameter();

                sqlParam = new SqlParameter();
                sqlParam.ParameterName = "@MQTRRWorkQueueItemRef";
                sqlParam.SqlDbType     = SqlDbType.BigInt;
                sqlParam.Value         = objMQMessagesRecieved.MQTRRWorkQueueItemRef;
                parameters.Add(sqlParam);
                sqlParam = new SqlParameter();

                sqlParam = new SqlParameter();
                sqlParam.ParameterName = "@ProcessingFailReason";
                sqlParam.SqlDbType     = SqlDbType.VarChar;
                sqlParam.Value         = objMQMessagesRecieved.ProcessingFailReason;
                parameters.Add(sqlParam);
                sqlParam = new SqlParameter();


                sqlParam = new SqlParameter();
                sqlParam.ParameterName = "@ErrorMessage";
                sqlParam.SqlDbType     = SqlDbType.VarChar;
                sqlParam.Value         = string.Empty;
                sqlParam.Direction     = ParameterDirection.Output;
                sqlParam.Size          = 2000;
                parameters.Add(sqlParam);

                long executionResult = 0;
                executionResult = executionResult = dah.ExecuteDMLSP(ConstantTexts.SP_USP_BGP_UPD_MQMessagesRecieved, parameters.ToArray(), out lErrocode, out lErrorNumber, out lRowsEffected, out errorMessage);
                sqlParam        = parameters.FirstOrDefault(x => x.ParameterName == "@ErrorMessage");
                if (sqlParam != null && sqlParam.Value != null)
                {
                    errorMessage += sqlParam.Value.ToString();
                }
                if (executionResult == (long)ExceptionTypes.Success && string.IsNullOrEmpty(errorMessage))
                {
                    return(ExceptionTypes.Success);
                }
                else
                {
                    return(ExceptionTypes.UnknownError);
                }
            }
            catch (Exception ex)
            {
                Console.WriteLine("Error : " + ex.Message);
                errorMessage = ex.Message;
                return(ExceptionTypes.UnknownError);
            }
        }
コード例 #2
0
 public ExceptionTypes UpdateXMLMessage(MQMessagesRecieved objMQMessagesRecieved, out string errorMessage)
 {
     return(_retValue = _objDALMQ.UpdateXMLMessage(objMQMessagesRecieved, out errorMessage));
 }