Ejemplo n.º 1
0
        public void InsertWFInstance(SortedDictionary <int, ValkWFStep> ToInsert)
        {
            SQLTransactionData TransData = SQLConnHandler.StartTransaction("InsertWFInstance");

            foreach (KeyValuePair <int, ValkWFStep> Step in ToInsert)
            {
                SQLConnHandler.ExecuteNonQuerySPTrans(TransData,
                                                      new SQLParameter()
                {
                    ParamName = "@InstanceKey", ParamValue = Step.Value.InstanceKey
                },
                                                      new SQLParameter()
                {
                    ParamName = "@WFTemplateID", ParamValue = Step.Value.WFTemplateID
                },
                                                      new SQLParameter()
                {
                    ParamName = "@Status", ParamValue = "inactive"
                },
                                                      new SQLParameter()
                {
                    ParamName = "@WFTemplateStepID", ParamValue = Step.Value.WFTemplateStepID
                },
                                                      new SQLParameter()
                {
                    ParamName = "@UserID", ParamValue = 1
                },
                                                      new SQLParameter()
                {
                    ParamName = "@StartTime", ParamValue = SqlDateTime.MinValue
                },
                                                      new SQLParameter()
                {
                    ParamName = "@SyncCount", ParamValue = Step.Value.SyncCount
                },
                                                      new SQLParameter()
                {
                    ParamName = "@ExceptionID", ParamValue = -1
                }
                                                      );
            }

            SQLConnHandler.EndTransaction(TransData);
        }
Ejemplo n.º 2
0
        public void UpdateSteps(List <ValkQueueWFMessage> Updates)
        {
            //insert all the pending updates
            SQLTransactionData TransData = SQLConnHandler.StartTransaction("InsertUpdates");

            foreach (ValkQueueWFMessage Step in Updates)
            {
                SQLConnHandler.ExecuteNonQuerySPTrans(TransData,
                                                      new SQLParameter()
                {
                    ParamName = "@InstanceKey", ParamValue = Step.InstanceKey
                },
                                                      new SQLParameter()
                {
                    ParamName = "@WFTemplateID", ParamValue = Step.Step.WFTemplateID
                },
                                                      new SQLParameter()
                {
                    ParamName = "@NewStatus", ParamValue = Step.Step.Status
                },
                                                      new SQLParameter()
                {
                    ParamName = "@WFTemplateStepID", ParamValue = Step.Step.WFTemplateStepID
                }
                                                      );
            }

            //temporarily replace command so we can run a different one
            //run updates in SQL
            SqlCommand command = new SqlCommand("RunUpdates", TransData.SQLConn);

            command.Transaction = TransData.Transaction;
            TransData.Command   = command;
            SQLConnHandler.ExecuteNonQuerySPTrans(TransData);

            SQLConnHandler.EndTransaction(TransData);
        }