Free cookie consent management tool by TermsFeed Policy Generator

Ignore:
Timestamp:
01/08/09 14:33:22 (15 years ago)
Author:
svonolfe
Message:

Added a state to jobs and a message to job results in the db. (#372)

File:
1 edited

Legend:

Unmodified
Added
Removed

  • trunk/sources/HeuristicLab.Hive.Server.ADODataAccess/dsHiveServer.Designer.cs

    r1005 r1092  
    24382438            private global::System.Data.DataColumn columnParentJobId;
    24392439           
    2440             private global::System.Data.DataColumn columnStatus;
    2441            
    24422440            private global::System.Data.DataColumn columnPermissionOwnerId;
    24432441           
    24442442            private global::System.Data.DataColumn columnResourceId;
     2443           
     2444            private global::System.Data.DataColumn columnJobState;
     2445           
     2446            private global::System.Data.DataColumn columnPercentage;
    24452447           
    24462448            [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
    … …  
    24892491           
    24902492            [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
    2491             public global::System.Data.DataColumn StatusColumn {
    2492                 get {
    2493                     return this.columnStatus;
    2494                 }
    2495             }
    2496            
    2497             [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
    24982493            public global::System.Data.DataColumn PermissionOwnerIdColumn {
    24992494                get {
    … …  
    25062501                get {
    25072502                    return this.columnResourceId;
     2503                }
     2504            }
     2505           
     2506            [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
     2507            public global::System.Data.DataColumn JobStateColumn {
     2508                get {
     2509                    return this.columnJobState;
     2510                }
     2511            }
     2512           
     2513            [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
     2514            public global::System.Data.DataColumn PercentageColumn {
     2515                get {
     2516                    return this.columnPercentage;
    25082517                }
    25092518            }
    … …  
    25382547           
    25392548            [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
    2540             public JobRow AddJobRow(long ParentJobId, string Status, HiveUserRow parentHiveUserRowByR_35, ClientRow parentClientRowByR_21) {
     2549            public JobRow AddJobRow(long ParentJobId, HiveUserRow parentHiveUserRowByR_35, ClientRow parentClientRowByR_21, string JobState, double Percentage) {
    25412550                JobRow rowJobRow = ((JobRow)(this.NewRow()));
    25422551                object[] columnValuesArray = new object[] {
    25432552                        null,
    25442553                        ParentJobId,
    2545                         Status,
    25462554                        null,
    2547                         null};
     2555                        null,
     2556                        JobState,
     2557                        Percentage};
    25482558                if ((parentHiveUserRowByR_35 != null)) {
    2549                     columnValuesArray[3] = parentHiveUserRowByR_35[0];
     2559                    columnValuesArray[2] = parentHiveUserRowByR_35[0];
    25502560                }
    25512561                if ((parentClientRowByR_21 != null)) {
    2552                     columnValuesArray[4] = parentClientRowByR_21[0];
     2562                    columnValuesArray[3] = parentClientRowByR_21[0];
    25532563                }
    25542564                rowJobRow.ItemArray = columnValuesArray;
    … …  
    25792589                this.columnJobId = base.Columns["JobId"];
    25802590                this.columnParentJobId = base.Columns["ParentJobId"];
    2581                 this.columnStatus = base.Columns["Status"];
    25822591                this.columnPermissionOwnerId = base.Columns["PermissionOwnerId"];
    25832592                this.columnResourceId = base.Columns["ResourceId"];
     2593                this.columnJobState = base.Columns["JobState"];
     2594                this.columnPercentage = base.Columns["Percentage"];
    25842595            }
    25852596           
    … …  
    25902601                this.columnParentJobId = new global::System.Data.DataColumn("ParentJobId", typeof(long), null, global::System.Data.MappingType.Element);
    25912602                base.Columns.Add(this.columnParentJobId);
    2592                 this.columnStatus = new global::System.Data.DataColumn("Status", typeof(string), null, global::System.Data.MappingType.Element);
    2593                 base.Columns.Add(this.columnStatus);
    25942603                this.columnPermissionOwnerId = new global::System.Data.DataColumn("PermissionOwnerId", typeof(long), null, global::System.Data.MappingType.Element);
    25952604                base.Columns.Add(this.columnPermissionOwnerId);
    25962605                this.columnResourceId = new global::System.Data.DataColumn("ResourceId", typeof(long), null, global::System.Data.MappingType.Element);
    25972606                base.Columns.Add(this.columnResourceId);
     2607                this.columnJobState = new global::System.Data.DataColumn("JobState", typeof(string), null, global::System.Data.MappingType.Element);
     2608                base.Columns.Add(this.columnJobState);
     2609                this.columnPercentage = new global::System.Data.DataColumn("Percentage", typeof(double), null, global::System.Data.MappingType.Element);
     2610                base.Columns.Add(this.columnPercentage);
    25982611                this.Constraints.Add(new global::System.Data.UniqueConstraint("Constraint1", new global::System.Data.DataColumn[] {
    25992612                                this.columnJobId}, true));
    … …  
    26042617                this.columnJobId.ReadOnly = true;
    26052618                this.columnJobId.Unique = true;
    2606                 this.columnStatus.MaxLength = 18;
     2619                this.columnJobState.MaxLength = 18;
    26072620            }
    26082621           
    … …  
    29923005            private global::System.Data.DataColumn columnResourceId;
    29933006           
     3007            private global::System.Data.DataColumn columnMessage;
     3008           
    29943009            [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
    29953010            public JobResultDataTable() {
    … …  
    30513066           
    30523067            [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
     3068            public global::System.Data.DataColumn MessageColumn {
     3069                get {
     3070                    return this.columnMessage;
     3071                }
     3072            }
     3073           
     3074            [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
    30533075            [global::System.ComponentModel.Browsable(false)]
    30543076            public int Count {
    … …  
    30793101           
    30803102            [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
    3081             public JobResultRow AddJobResultRow(JobRow parentJobRowByR_14, byte[] JobResult, long ResourceId) {
     3103            public JobResultRow AddJobResultRow(JobRow parentJobRowByR_14, byte[] JobResult, long ResourceId, string Message) {
    30823104                JobResultRow rowJobResultRow = ((JobResultRow)(this.NewRow()));
    30833105                object[] columnValuesArray = new object[] {
    … …  
    30853107                        null,
    30863108                        JobResult,
    3087                         ResourceId};
     3109                        ResourceId,
     3110                        Message};
    30883111                if ((parentJobRowByR_14 != null)) {
    30893112                    columnValuesArray[1] = parentJobRowByR_14[0];
    … …  
    31183141                this.columnJobResult = base.Columns["JobResult"];
    31193142                this.columnResourceId = base.Columns["ResourceId"];
     3143                this.columnMessage = base.Columns["Message"];
    31203144            }
    31213145           
    … …  
    31303154                this.columnResourceId = new global::System.Data.DataColumn("ResourceId", typeof(long), null, global::System.Data.MappingType.Element);
    31313155                base.Columns.Add(this.columnResourceId);
     3156                this.columnMessage = new global::System.Data.DataColumn("Message", typeof(string), null, global::System.Data.MappingType.Element);
     3157                base.Columns.Add(this.columnMessage);
    31323158                this.Constraints.Add(new global::System.Data.UniqueConstraint("Constraint1", new global::System.Data.DataColumn[] {
    31333159                                this.columnJobResultId}, true));
    … …  
    31383164                this.columnJobResultId.ReadOnly = true;
    31393165                this.columnJobResultId.Unique = true;
     3166                this.columnMessage.MaxLength = 2147483647;
    31403167            }
    31413168           
    … …  
    38903917           
    38913918            [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
    3892             public string Status {
    3893                 get {
    3894                     try {
    3895                         return ((string)(this[this.tableJob.StatusColumn]));
    3896                     }
    3897                     catch (global::System.InvalidCastException e) {
    3898                         throw new global::System.Data.StrongTypingException("The value for column \'Status\' in table \'Job\' is DBNull.", e);
    3899                     }
    3900                 }
    3901                 set {
    3902                     this[this.tableJob.StatusColumn] = value;
    3903                 }
    3904             }
    3905            
    3906             [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
    39073919            public long PermissionOwnerId {
    39083920                get {
    … …  
    39353947           
    39363948            [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
     3949            public string JobState {
     3950                get {
     3951                    try {
     3952                        return ((string)(this[this.tableJob.JobStateColumn]));
     3953                    }
     3954                    catch (global::System.InvalidCastException e) {
     3955                        throw new global::System.Data.StrongTypingException("The value for column \'JobState\' in table \'Job\' is DBNull.", e);
     3956                    }
     3957                }
     3958                set {
     3959                    this[this.tableJob.JobStateColumn] = value;
     3960                }
     3961            }
     3962           
     3963            [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
     3964            public double Percentage {
     3965                get {
     3966                    try {
     3967                        return ((double)(this[this.tableJob.PercentageColumn]));
     3968                    }
     3969                    catch (global::System.InvalidCastException e) {
     3970                        throw new global::System.Data.StrongTypingException("The value for column \'Percentage\' in table \'Job\' is DBNull.", e);
     3971                    }
     3972                }
     3973                set {
     3974                    this[this.tableJob.PercentageColumn] = value;
     3975                }
     3976            }
     3977           
     3978            [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
    39373979            public ClientRow ClientRow {
    39383980                get {
    … …  
    39654007           
    39664008            [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
    3967             public bool IsStatusNull() {
    3968                 return this.IsNull(this.tableJob.StatusColumn);
    3969             }
    3970            
    3971             [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
    3972             public void SetStatusNull() {
    3973                 this[this.tableJob.StatusColumn] = global::System.Convert.DBNull;
    3974             }
    3975            
    3976             [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
    39774009            public bool IsPermissionOwnerIdNull() {
    39784010                return this.IsNull(this.tableJob.PermissionOwnerIdColumn);
    … …  
    39924024            public void SetResourceIdNull() {
    39934025                this[this.tableJob.ResourceIdColumn] = global::System.Convert.DBNull;
     4026            }
     4027           
     4028            [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
     4029            public bool IsJobStateNull() {
     4030                return this.IsNull(this.tableJob.JobStateColumn);
     4031            }
     4032           
     4033            [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
     4034            public void SetJobStateNull() {
     4035                this[this.tableJob.JobStateColumn] = global::System.Convert.DBNull;
     4036            }
     4037           
     4038            [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
     4039            public bool IsPercentageNull() {
     4040                return this.IsNull(this.tableJob.PercentageColumn);
     4041            }
     4042           
     4043            [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
     4044            public void SetPercentageNull() {
     4045                this[this.tableJob.PercentageColumn] = global::System.Convert.DBNull;
    39944046            }
    39954047           
    … …  
    41304182           
    41314183            [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
     4184            public string Message {
     4185                get {
     4186                    try {
     4187                        return ((string)(this[this.tableJobResult.MessageColumn]));
     4188                    }
     4189                    catch (global::System.InvalidCastException e) {
     4190                        throw new global::System.Data.StrongTypingException("The value for column \'Message\' in table \'JobResult\' is DBNull.", e);
     4191                    }
     4192                }
     4193                set {
     4194                    this[this.tableJobResult.MessageColumn] = value;
     4195                }
     4196            }
     4197           
     4198            [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
    41324199            public JobRow JobRow {
    41334200                get {
    … …  
    41674234            public void SetResourceIdNull() {
    41684235                this[this.tableJobResult.ResourceIdColumn] = global::System.Convert.DBNull;
     4236            }
     4237           
     4238            [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
     4239            public bool IsMessageNull() {
     4240                return this.IsNull(this.tableJobResult.MessageColumn);
     4241            }
     4242           
     4243            [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
     4244            public void SetMessageNull() {
     4245                this[this.tableJobResult.MessageColumn] = global::System.Convert.DBNull;
    41694246            }
    41704247        }
    … …  
    73997476            tableMapping.ColumnMappings.Add("JobId", "JobId");
    74007477            tableMapping.ColumnMappings.Add("ParentJobId", "ParentJobId");
    7401             tableMapping.ColumnMappings.Add("Status", "Status");
    74027478            tableMapping.ColumnMappings.Add("PermissionOwnerId", "PermissionOwnerId");
    74037479            tableMapping.ColumnMappings.Add("ResourceId", "ResourceId");
     7480            tableMapping.ColumnMappings.Add("JobState", "JobState");
     7481            tableMapping.ColumnMappings.Add("Percentage", "Percentage");
    74047482            this._adapter.TableMappings.Add(tableMapping);
    74057483            this._adapter.DeleteCommand = new global::System.Data.SqlClient.SqlCommand();
    74067484            this._adapter.DeleteCommand.Connection = this.Connection;
    7407             this._adapter.DeleteCommand.CommandText = @"DELETE FROM [dbo].[Job] WHERE (([JobId] = @Original_JobId) AND ((@IsNull_ParentJobId = 1 AND [ParentJobId] IS NULL) OR ([ParentJobId] = @Original_ParentJobId)) AND ((@IsNull_Status = 1 AND [Status] IS NULL) OR ([Status] = @Original_Status)) AND ((@IsNull_PermissionOwnerId = 1 AND [PermissionOwnerId] IS NULL) OR ([PermissionOwnerId] = @Original_PermissionOwnerId)) AND ((@IsNull_ResourceId = 1 AND [ResourceId] IS NULL) OR ([ResourceId] = @Original_ResourceId)))";
     7485            this._adapter.DeleteCommand.CommandText = @"DELETE FROM [Job] WHERE (([JobId] = @Original_JobId) AND ((@IsNull_ParentJobId = 1 AND [ParentJobId] IS NULL) OR ([ParentJobId] = @Original_ParentJobId)) AND ((@IsNull_JobState = 1 AND [JobState] IS NULL) OR ([JobState] = @Original_JobState)) AND ((@IsNull_PermissionOwnerId = 1 AND [PermissionOwnerId] IS NULL) OR ([PermissionOwnerId] = @Original_PermissionOwnerId)) AND ((@IsNull_ResourceId = 1 AND [ResourceId] IS NULL) OR ([ResourceId] = @Original_ResourceId)))";
    74087486            this._adapter.DeleteCommand.CommandType = global::System.Data.CommandType.Text;
    74097487            this._adapter.DeleteCommand.Parameters.Add(new global::System.Data.SqlClient.SqlParameter("@Original_JobId", global::System.Data.SqlDbType.BigInt, 0, global::System.Data.ParameterDirection.Input, 0, 0, "JobId", global::System.Data.DataRowVersion.Original, false, null, "", "", ""));
    74107488            this._adapter.DeleteCommand.Parameters.Add(new global::System.Data.SqlClient.SqlParameter("@IsNull_ParentJobId", global::System.Data.SqlDbType.Int, 0, global::System.Data.ParameterDirection.Input, 0, 0, "ParentJobId", global::System.Data.DataRowVersion.Original, true, null, "", "", ""));
    74117489            this._adapter.DeleteCommand.Parameters.Add(new global::System.Data.SqlClient.SqlParameter("@Original_ParentJobId", global::System.Data.SqlDbType.BigInt, 0, global::System.Data.ParameterDirection.Input, 0, 0, "ParentJobId", global::System.Data.DataRowVersion.Original, false, null, "", "", ""));
    7412             this._adapter.DeleteCommand.Parameters.Add(new global::System.Data.SqlClient.SqlParameter("@IsNull_Status", global::System.Data.SqlDbType.Int, 0, global::System.Data.ParameterDirection.Input, 0, 0, "Status", global::System.Data.DataRowVersion.Original, true, null, "", "", ""));
    7413             this._adapter.DeleteCommand.Parameters.Add(new global::System.Data.SqlClient.SqlParameter("@Original_Status", global::System.Data.SqlDbType.VarChar, 0, global::System.Data.ParameterDirection.Input, 0, 0, "Status", global::System.Data.DataRowVersion.Original, false, null, "", "", ""));
     7490            this._adapter.DeleteCommand.Parameters.Add(new global::System.Data.SqlClient.SqlParameter("@IsNull_JobState", global::System.Data.SqlDbType.Int, 0, global::System.Data.ParameterDirection.Input, 0, 0, "JobState", global::System.Data.DataRowVersion.Original, true, null, "", "", ""));
     7491            this._adapter.DeleteCommand.Parameters.Add(new global::System.Data.SqlClient.SqlParameter("@Original_JobState", global::System.Data.SqlDbType.VarChar, 0, global::System.Data.ParameterDirection.Input, 0, 0, "JobState", global::System.Data.DataRowVersion.Original, false, null, "", "", ""));
    74147492            this._adapter.DeleteCommand.Parameters.Add(new global::System.Data.SqlClient.SqlParameter("@IsNull_PermissionOwnerId", global::System.Data.SqlDbType.Int, 0, global::System.Data.ParameterDirection.Input, 0, 0, "PermissionOwnerId", global::System.Data.DataRowVersion.Original, true, null, "", "", ""));
    74157493            this._adapter.DeleteCommand.Parameters.Add(new global::System.Data.SqlClient.SqlParameter("@Original_PermissionOwnerId", global::System.Data.SqlDbType.BigInt, 0, global::System.Data.ParameterDirection.Input, 0, 0, "PermissionOwnerId", global::System.Data.DataRowVersion.Original, false, null, "", "", ""));
    … …  
    74187496            this._adapter.InsertCommand = new global::System.Data.SqlClient.SqlCommand();
    74197497            this._adapter.InsertCommand.Connection = this.Connection;
    7420             this._adapter.InsertCommand.CommandText = @"INSERT INTO [dbo].[Job] ([ParentJobId], [Status], [PermissionOwnerId], [ResourceId]) VALUES (@ParentJobId, @Status, @PermissionOwnerId, @ResourceId);
    7421 SELECT JobId, ParentJobId, Status, PermissionOwnerId, ResourceId FROM Job WHERE (JobId = SCOPE_IDENTITY())";
     7498            this._adapter.InsertCommand.CommandText = @"INSERT INTO [Job] ([ParentJobId], [JobState], [PermissionOwnerId], [ResourceId]) VALUES (@ParentJobId, @JobState, @PermissionOwnerId, @ResourceId);
     7499SELECT JobId, ParentJobId, JobState, PermissionOwnerId, ResourceId FROM Job WHERE (JobId = SCOPE_IDENTITY())";
    74227500            this._adapter.InsertCommand.CommandType = global::System.Data.CommandType.Text;
    74237501            this._adapter.InsertCommand.Parameters.Add(new global::System.Data.SqlClient.SqlParameter("@ParentJobId", global::System.Data.SqlDbType.BigInt, 0, global::System.Data.ParameterDirection.Input, 0, 0, "ParentJobId", global::System.Data.DataRowVersion.Current, false, null, "", "", ""));
    7424             this._adapter.InsertCommand.Parameters.Add(new global::System.Data.SqlClient.SqlParameter("@Status", global::System.Data.SqlDbType.VarChar, 0, global::System.Data.ParameterDirection.Input, 0, 0, "Status", global::System.Data.DataRowVersion.Current, false, null, "", "", ""));
     7502            this._adapter.InsertCommand.Parameters.Add(new global::System.Data.SqlClient.SqlParameter("@JobState", global::System.Data.SqlDbType.VarChar, 0, global::System.Data.ParameterDirection.Input, 0, 0, "JobState", global::System.Data.DataRowVersion.Current, false, null, "", "", ""));
    74257503            this._adapter.InsertCommand.Parameters.Add(new global::System.Data.SqlClient.SqlParameter("@PermissionOwnerId", global::System.Data.SqlDbType.BigInt, 0, global::System.Data.ParameterDirection.Input, 0, 0, "PermissionOwnerId", global::System.Data.DataRowVersion.Current, false, null, "", "", ""));
    74267504            this._adapter.InsertCommand.Parameters.Add(new global::System.Data.SqlClient.SqlParameter("@ResourceId", global::System.Data.SqlDbType.BigInt, 0, global::System.Data.ParameterDirection.Input, 0, 0, "ResourceId", global::System.Data.DataRowVersion.Current, false, null, "", "", ""));
    74277505            this._adapter.UpdateCommand = new global::System.Data.SqlClient.SqlCommand();
    74287506            this._adapter.UpdateCommand.Connection = this.Connection;
    7429             this._adapter.UpdateCommand.CommandText = @"UPDATE [dbo].[Job] SET [ParentJobId] = @ParentJobId, [Status] = @Status, [PermissionOwnerId] = @PermissionOwnerId, [ResourceId] = @ResourceId WHERE (([JobId] = @Original_JobId) AND ((@IsNull_ParentJobId = 1 AND [ParentJobId] IS NULL) OR ([ParentJobId] = @Original_ParentJobId)) AND ((@IsNull_Status = 1 AND [Status] IS NULL) OR ([Status] = @Original_Status)) AND ((@IsNull_PermissionOwnerId = 1 AND [PermissionOwnerId] IS NULL) OR ([PermissionOwnerId] = @Original_PermissionOwnerId)) AND ((@IsNull_ResourceId = 1 AND [ResourceId] IS NULL) OR ([ResourceId] = @Original_ResourceId)));
    7430 SELECT JobId, ParentJobId, Status, PermissionOwnerId, ResourceId FROM Job WHERE (JobId = @JobId)";
     7507            this._adapter.UpdateCommand.CommandText = @"UPDATE [Job] SET [ParentJobId] = @ParentJobId, [JobState] = @JobState, [PermissionOwnerId] = @PermissionOwnerId, [ResourceId] = @ResourceId WHERE (([JobId] = @Original_JobId) AND ((@IsNull_ParentJobId = 1 AND [ParentJobId] IS NULL) OR ([ParentJobId] = @Original_ParentJobId)) AND ((@IsNull_JobState = 1 AND [JobState] IS NULL) OR ([JobState] = @Original_JobState)) AND ((@IsNull_PermissionOwnerId = 1 AND [PermissionOwnerId] IS NULL) OR ([PermissionOwnerId] = @Original_PermissionOwnerId)) AND ((@IsNull_ResourceId = 1 AND [ResourceId] IS NULL) OR ([ResourceId] = @Original_ResourceId)));
     7508SELECT JobId, ParentJobId, JobState, PermissionOwnerId, ResourceId FROM Job WHERE (JobId = @JobId)";
    74317509            this._adapter.UpdateCommand.CommandType = global::System.Data.CommandType.Text;
    74327510            this._adapter.UpdateCommand.Parameters.Add(new global::System.Data.SqlClient.SqlParameter("@ParentJobId", global::System.Data.SqlDbType.BigInt, 0, global::System.Data.ParameterDirection.Input, 0, 0, "ParentJobId", global::System.Data.DataRowVersion.Current, false, null, "", "", ""));
    7433             this._adapter.UpdateCommand.Parameters.Add(new global::System.Data.SqlClient.SqlParameter("@Status", global::System.Data.SqlDbType.VarChar, 0, global::System.Data.ParameterDirection.Input, 0, 0, "Status", global::System.Data.DataRowVersion.Current, false, null, "", "", ""));
     7511            this._adapter.UpdateCommand.Parameters.Add(new global::System.Data.SqlClient.SqlParameter("@JobState", global::System.Data.SqlDbType.VarChar, 0, global::System.Data.ParameterDirection.Input, 0, 0, "JobState", global::System.Data.DataRowVersion.Current, false, null, "", "", ""));
    74347512            this._adapter.UpdateCommand.Parameters.Add(new global::System.Data.SqlClient.SqlParameter("@PermissionOwnerId", global::System.Data.SqlDbType.BigInt, 0, global::System.Data.ParameterDirection.Input, 0, 0, "PermissionOwnerId", global::System.Data.DataRowVersion.Current, false, null, "", "", ""));
    74357513            this._adapter.UpdateCommand.Parameters.Add(new global::System.Data.SqlClient.SqlParameter("@ResourceId", global::System.Data.SqlDbType.BigInt, 0, global::System.Data.ParameterDirection.Input, 0, 0, "ResourceId", global::System.Data.DataRowVersion.Current, false, null, "", "", ""));
    … …  
    74377515            this._adapter.UpdateCommand.Parameters.Add(new global::System.Data.SqlClient.SqlParameter("@IsNull_ParentJobId", global::System.Data.SqlDbType.Int, 0, global::System.Data.ParameterDirection.Input, 0, 0, "ParentJobId", global::System.Data.DataRowVersion.Original, true, null, "", "", ""));
    74387516            this._adapter.UpdateCommand.Parameters.Add(new global::System.Data.SqlClient.SqlParameter("@Original_ParentJobId", global::System.Data.SqlDbType.BigInt, 0, global::System.Data.ParameterDirection.Input, 0, 0, "ParentJobId", global::System.Data.DataRowVersion.Original, false, null, "", "", ""));
    7439             this._adapter.UpdateCommand.Parameters.Add(new global::System.Data.SqlClient.SqlParameter("@IsNull_Status", global::System.Data.SqlDbType.Int, 0, global::System.Data.ParameterDirection.Input, 0, 0, "Status", global::System.Data.DataRowVersion.Original, true, null, "", "", ""));
    7440             this._adapter.UpdateCommand.Parameters.Add(new global::System.Data.SqlClient.SqlParameter("@Original_Status", global::System.Data.SqlDbType.VarChar, 0, global::System.Data.ParameterDirection.Input, 0, 0, "Status", global::System.Data.DataRowVersion.Original, false, null, "", "", ""));
     7517            this._adapter.UpdateCommand.Parameters.Add(new global::System.Data.SqlClient.SqlParameter("@IsNull_JobState", global::System.Data.SqlDbType.Int, 0, global::System.Data.ParameterDirection.Input, 0, 0, "JobState", global::System.Data.DataRowVersion.Original, true, null, "", "", ""));
     7518            this._adapter.UpdateCommand.Parameters.Add(new global::System.Data.SqlClient.SqlParameter("@Original_JobState", global::System.Data.SqlDbType.VarChar, 0, global::System.Data.ParameterDirection.Input, 0, 0, "JobState", global::System.Data.DataRowVersion.Original, false, null, "", "", ""));
    74417519            this._adapter.UpdateCommand.Parameters.Add(new global::System.Data.SqlClient.SqlParameter("@IsNull_PermissionOwnerId", global::System.Data.SqlDbType.Int, 0, global::System.Data.ParameterDirection.Input, 0, 0, "PermissionOwnerId", global::System.Data.DataRowVersion.Original, true, null, "", "", ""));
    74427520            this._adapter.UpdateCommand.Parameters.Add(new global::System.Data.SqlClient.SqlParameter("@Original_PermissionOwnerId", global::System.Data.SqlDbType.BigInt, 0, global::System.Data.ParameterDirection.Input, 0, 0, "PermissionOwnerId", global::System.Data.DataRowVersion.Original, false, null, "", "", ""));
    … …  
    74577535            this._commandCollection[0] = new global::System.Data.SqlClient.SqlCommand();
    74587536            this._commandCollection[0].Connection = this.Connection;
    7459             this._commandCollection[0].CommandText = "SELECT JobId, ParentJobId, Status, PermissionOwnerId, ResourceId FROM dbo.Job";
     7537            this._commandCollection[0].CommandText = "SELECT JobId, ParentJobId, JobState, PermissionOwnerId, ResourceId FROM Job";
    74607538            this._commandCollection[0].CommandType = global::System.Data.CommandType.Text;
    74617539            this._commandCollection[1] = new global::System.Data.SqlClient.SqlCommand();
    74627540            this._commandCollection[1].Connection = this.Connection;
    7463             this._commandCollection[1].CommandText = "SELECT * FROM dbo.Job WHERE Status <> \'offline\'";
     7541            this._commandCollection[1].CommandText = "SELECT JobId, JobState, ParentJobId, PermissionOwnerId, ResourceId FROM Job WHERE" +
     7542                " (JobState <> \'offline\')";
    74647543            this._commandCollection[1].CommandType = global::System.Data.CommandType.Text;
    74657544            this._commandCollection[2] = new global::System.Data.SqlClient.SqlCommand();
    74667545            this._commandCollection[2].Connection = this.Connection;
    7467             this._commandCollection[2].CommandText = "SELECT * FROM dbo.Job WHERE ResourceId = @ResourceId";
     7546            this._commandCollection[2].CommandText = "SELECT JobId, JobState, ParentJobId, PermissionOwnerId, ResourceId FROM Job WHERE" +
     7547                " (ResourceId = @ResourceId)";
    74687548            this._commandCollection[2].CommandType = global::System.Data.CommandType.Text;
    74697549            this._commandCollection[2].Parameters.Add(new global::System.Data.SqlClient.SqlParameter("@ResourceId", global::System.Data.SqlDbType.BigInt, 8, global::System.Data.ParameterDirection.Input, 0, 0, "ResourceId", global::System.Data.DataRowVersion.Current, false, null, "", "", ""));
    74707550            this._commandCollection[3] = new global::System.Data.SqlClient.SqlCommand();
    74717551            this._commandCollection[3].Connection = this.Connection;
    7472             this._commandCollection[3].CommandText = "SELECT * FROM dbo.Job WHERE JobId = @Id";
     7552            this._commandCollection[3].CommandText = "SELECT JobId, JobState, ParentJobId, PermissionOwnerId, ResourceId FROM Job WHERE" +
     7553                " (JobId = @Id)";
    74737554            this._commandCollection[3].CommandType = global::System.Data.CommandType.Text;
    74747555            this._commandCollection[3].Parameters.Add(new global::System.Data.SqlClient.SqlParameter("@Id", global::System.Data.SqlDbType.BigInt, 8, global::System.Data.ParameterDirection.Input, 0, 0, "JobId", global::System.Data.DataRowVersion.Current, false, null, "", "", ""));
    74757556            this._commandCollection[4] = new global::System.Data.SqlClient.SqlCommand();
    74767557            this._commandCollection[4].Connection = this.Connection;
    7477             this._commandCollection[4].CommandText = "SELECT * FROM dbo.Job WHERE Status = @State";
     7558            this._commandCollection[4].CommandText = "SELECT JobId, JobState, ParentJobId, PermissionOwnerId, ResourceId FROM Job WHERE" +
     7559                " (JobState = @State)";
    74787560            this._commandCollection[4].CommandType = global::System.Data.CommandType.Text;
    7479             this._commandCollection[4].Parameters.Add(new global::System.Data.SqlClient.SqlParameter("@State", global::System.Data.SqlDbType.VarChar, 18, global::System.Data.ParameterDirection.Input, 0, 0, "Status", global::System.Data.DataRowVersion.Current, false, null, "", "", ""));
     7561            this._commandCollection[4].Parameters.Add(new global::System.Data.SqlClient.SqlParameter("@State", global::System.Data.SqlDbType.VarChar, 18, global::System.Data.ParameterDirection.Input, 0, 0, "JobState", global::System.Data.DataRowVersion.Current, false, null, "", "", ""));
    74807562            this._commandCollection[5] = new global::System.Data.SqlClient.SqlCommand();
    74817563            this._commandCollection[5].Connection = this.Connection;
    7482             this._commandCollection[5].CommandText = "SELECT * FROM dbo.Job WHERE ParentJobId = @Id";
     7564            this._commandCollection[5].CommandText = "SELECT JobId, JobState, ParentJobId, PermissionOwnerId, ResourceId FROM Job WHERE" +
     7565                " (ParentJobId = @Id)";
    74837566            this._commandCollection[5].CommandType = global::System.Data.CommandType.Text;
    74847567            this._commandCollection[5].Parameters.Add(new global::System.Data.SqlClient.SqlParameter("@Id", global::System.Data.SqlDbType.BigInt, 8, global::System.Data.ParameterDirection.Input, 0, 0, "ParentJobId", global::System.Data.DataRowVersion.Current, false, null, "", "", ""));
    74857568            this._commandCollection[6] = new global::System.Data.SqlClient.SqlCommand();
    74867569            this._commandCollection[6].Connection = this.Connection;
    7487             this._commandCollection[6].CommandText = "SELECT * FROM dbo.Job WHERE PermissionOwnerId = @PermissionOwnerId ";
     7570            this._commandCollection[6].CommandText = "SELECT JobId, JobState, ParentJobId, PermissionOwnerId, ResourceId FROM Job WHERE" +
     7571                " (PermissionOwnerId = @PermissionOwnerId)";
    74887572            this._commandCollection[6].CommandType = global::System.Data.CommandType.Text;
    74897573            this._commandCollection[6].Parameters.Add(new global::System.Data.SqlClient.SqlParameter("@PermissionOwnerId", global::System.Data.SqlDbType.BigInt, 8, global::System.Data.ParameterDirection.Input, 0, 0, "PermissionOwnerId", global::System.Data.DataRowVersion.Current, false, null, "", "", ""));
    … …  
    77227806        [global::System.ComponentModel.Design.HelpKeywordAttribute("vs.data.TableAdapter")]
    77237807        [global::System.ComponentModel.DataObjectMethodAttribute(global::System.ComponentModel.DataObjectMethodType.Delete, true)]
    7724         public virtual int Delete(long Original_JobId, global::System.Nullable<long> Original_ParentJobId, string Original_Status, global::System.Nullable<long> Original_PermissionOwnerId, global::System.Nullable<long> Original_ResourceId) {
     7808        public virtual int Delete(long Original_JobId, global::System.Nullable<long> Original_ParentJobId, string Original_JobState, global::System.Nullable<long> Original_PermissionOwnerId, global::System.Nullable<long> Original_ResourceId) {
    77257809            this.Adapter.DeleteCommand.Parameters[0].Value = ((long)(Original_JobId));
    77267810            if ((Original_ParentJobId.HasValue == true)) {
    … …  
    77327816                this.Adapter.DeleteCommand.Parameters[2].Value = global::System.DBNull.Value;
    77337817            }
    7734             if ((Original_Status == null)) {
     7818            if ((Original_JobState == null)) {
    77357819                this.Adapter.DeleteCommand.Parameters[3].Value = ((object)(1));
    77367820                this.Adapter.DeleteCommand.Parameters[4].Value = global::System.DBNull.Value;
    … …  
    77387822            else {
    77397823                this.Adapter.DeleteCommand.Parameters[3].Value = ((object)(0));
    7740                 this.Adapter.DeleteCommand.Parameters[4].Value = ((string)(Original_Status));
     7824                this.Adapter.DeleteCommand.Parameters[4].Value = ((string)(Original_JobState));
    77417825            }
    77427826            if ((Original_PermissionOwnerId.HasValue == true)) {
    … …  
    77757859        [global::System.ComponentModel.Design.HelpKeywordAttribute("vs.data.TableAdapter")]
    77767860        [global::System.ComponentModel.DataObjectMethodAttribute(global::System.ComponentModel.DataObjectMethodType.Insert, true)]
    7777         public virtual int Insert(global::System.Nullable<long> ParentJobId, string Status, global::System.Nullable<long> PermissionOwnerId, global::System.Nullable<long> ResourceId) {
     7861        public virtual int Insert(global::System.Nullable<long> ParentJobId, string JobState, global::System.Nullable<long> PermissionOwnerId, global::System.Nullable<long> ResourceId) {
    77787862            if ((ParentJobId.HasValue == true)) {
    77797863                this.Adapter.InsertCommand.Parameters[0].Value = ((long)(ParentJobId.Value));
    … …  
    77827866                this.Adapter.InsertCommand.Parameters[0].Value = global::System.DBNull.Value;
    77837867            }
    7784             if ((Status == null)) {
     7868            if ((JobState == null)) {
    77857869                this.Adapter.InsertCommand.Parameters[1].Value = global::System.DBNull.Value;
    77867870            }
    77877871            else {
    7788                 this.Adapter.InsertCommand.Parameters[1].Value = ((string)(Status));
     7872                this.Adapter.InsertCommand.Parameters[1].Value = ((string)(JobState));
    77897873            }
    77907874            if ((PermissionOwnerId.HasValue == true)) {
    … …  
    78197903        [global::System.ComponentModel.Design.HelpKeywordAttribute("vs.data.TableAdapter")]
    78207904        [global::System.ComponentModel.DataObjectMethodAttribute(global::System.ComponentModel.DataObjectMethodType.Update, true)]
    7821         public virtual int Update(global::System.Nullable<long> ParentJobId, string Status, global::System.Nullable<long> PermissionOwnerId, global::System.Nullable<long> ResourceId, long Original_JobId, global::System.Nullable<long> Original_ParentJobId, string Original_Status, global::System.Nullable<long> Original_PermissionOwnerId, global::System.Nullable<long> Original_ResourceId, long JobId) {
     7905        public virtual int Update(global::System.Nullable<long> ParentJobId, string JobState, global::System.Nullable<long> PermissionOwnerId, global::System.Nullable<long> ResourceId, long Original_JobId, global::System.Nullable<long> Original_ParentJobId, string Original_JobState, global::System.Nullable<long> Original_PermissionOwnerId, global::System.Nullable<long> Original_ResourceId, long JobId) {
    78227906            if ((ParentJobId.HasValue == true)) {
    78237907                this.Adapter.UpdateCommand.Parameters[0].Value = ((long)(ParentJobId.Value));
    … …  
    78267910                this.Adapter.UpdateCommand.Parameters[0].Value = global::System.DBNull.Value;
    78277911            }
    7828             if ((Status == null)) {
     7912            if ((JobState == null)) {
    78297913                this.Adapter.UpdateCommand.Parameters[1].Value = global::System.DBNull.Value;
    78307914            }
    78317915            else {
    7832                 this.Adapter.UpdateCommand.Parameters[1].Value = ((string)(Status));
     7916                this.Adapter.UpdateCommand.Parameters[1].Value = ((string)(JobState));
    78337917            }
    78347918            if ((PermissionOwnerId.HasValue == true)) {
    … …  
    78537937                this.Adapter.UpdateCommand.Parameters[6].Value = global::System.DBNull.Value;
    78547938            }
    7855             if ((Original_Status == null)) {
     7939            if ((Original_JobState == null)) {
    78567940                this.Adapter.UpdateCommand.Parameters[7].Value = ((object)(1));
    78577941                this.Adapter.UpdateCommand.Parameters[8].Value = global::System.DBNull.Value;
    … …  
    78597943            else {
    78607944                this.Adapter.UpdateCommand.Parameters[7].Value = ((object)(0));
    7861                 this.Adapter.UpdateCommand.Parameters[8].Value = ((string)(Original_Status));
     7945                this.Adapter.UpdateCommand.Parameters[8].Value = ((string)(Original_JobState));
    78627946            }
    78637947            if ((Original_PermissionOwnerId.HasValue == true)) {
    … …  
    78977981        [global::System.ComponentModel.Design.HelpKeywordAttribute("vs.data.TableAdapter")]
    78987982        [global::System.ComponentModel.DataObjectMethodAttribute(global::System.ComponentModel.DataObjectMethodType.Update, true)]
    7899         public virtual int Update(global::System.Nullable<long> ParentJobId, string Status, global::System.Nullable<long> PermissionOwnerId, global::System.Nullable<long> ResourceId, long Original_JobId, global::System.Nullable<long> Original_ParentJobId, string Original_Status, global::System.Nullable<long> Original_PermissionOwnerId, global::System.Nullable<long> Original_ResourceId) {
    7900             return this.Update(ParentJobId, Status, PermissionOwnerId, ResourceId, Original_JobId, Original_ParentJobId, Original_Status, Original_PermissionOwnerId, Original_ResourceId, Original_JobId);
     7983        public virtual int Update(global::System.Nullable<long> ParentJobId, string JobState, global::System.Nullable<long> PermissionOwnerId, global::System.Nullable<long> ResourceId, long Original_JobId, global::System.Nullable<long> Original_ParentJobId, string Original_JobState, global::System.Nullable<long> Original_PermissionOwnerId, global::System.Nullable<long> Original_ResourceId) {
     7984            return this.Update(ParentJobId, JobState, PermissionOwnerId, ResourceId, Original_JobId, Original_ParentJobId, Original_JobState, Original_PermissionOwnerId, Original_ResourceId, Original_JobId);
    79017985        }
    79027986    }
    … …  
    83948478            tableMapping.ColumnMappings.Add("JobResult", "JobResult");
    83958479            tableMapping.ColumnMappings.Add("ResourceId", "ResourceId");
     8480            tableMapping.ColumnMappings.Add("Message", "Message");
    83968481            this._adapter.TableMappings.Add(tableMapping);
    83978482            this._adapter.DeleteCommand = new global::System.Data.SqlClient.SqlCommand();
    83988483            this._adapter.DeleteCommand.Connection = this.Connection;
    8399             this._adapter.DeleteCommand.CommandText = @"DELETE FROM [dbo].[JobResult] WHERE (([JobResultId] = @Original_JobResultId) AND ((@IsNull_JobId = 1 AND [JobId] IS NULL) OR ([JobId] = @Original_JobId)) AND ((@IsNull_JobResult = 1 AND [JobResult] IS NULL) OR ([JobResult] = @Original_JobResult)) AND ((@IsNull_ResourceId = 1 AND [ResourceId] IS NULL) OR ([ResourceId] = @Original_ResourceId)))";
     8484            this._adapter.DeleteCommand.CommandText = "DELETE FROM [JobResult] WHERE (([JobResultId] = @Original_JobResultId) AND ((@IsN" +
     8485                "ull_JobId = 1 AND [JobId] IS NULL) OR ([JobId] = @Original_JobId)) AND ((@IsNull" +
     8486                "_ResourceId = 1 AND [ResourceId] IS NULL) OR ([ResourceId] = @Original_ResourceI" +
     8487                "d)))";
    84008488            this._adapter.DeleteCommand.CommandType = global::System.Data.CommandType.Text;
    84018489            this._adapter.DeleteCommand.Parameters.Add(new global::System.Data.SqlClient.SqlParameter("@Original_JobResultId", global::System.Data.SqlDbType.BigInt, 0, global::System.Data.ParameterDirection.Input, 0, 0, "JobResultId", global::System.Data.DataRowVersion.Original, false, null, "", "", ""));
    84028490            this._adapter.DeleteCommand.Parameters.Add(new global::System.Data.SqlClient.SqlParameter("@IsNull_JobId", global::System.Data.SqlDbType.Int, 0, global::System.Data.ParameterDirection.Input, 0, 0, "JobId", global::System.Data.DataRowVersion.Original, true, null, "", "", ""));
    84038491            this._adapter.DeleteCommand.Parameters.Add(new global::System.Data.SqlClient.SqlParameter("@Original_JobId", global::System.Data.SqlDbType.BigInt, 0, global::System.Data.ParameterDirection.Input, 0, 0, "JobId", global::System.Data.DataRowVersion.Original, false, null, "", "", ""));
    8404             this._adapter.DeleteCommand.Parameters.Add(new global::System.Data.SqlClient.SqlParameter("@IsNull_JobResult", global::System.Data.SqlDbType.Int, 0, global::System.Data.ParameterDirection.Input, 0, 0, "JobResult", global::System.Data.DataRowVersion.Original, true, null, "", "", ""));
    8405             this._adapter.DeleteCommand.Parameters.Add(new global::System.Data.SqlClient.SqlParameter("@Original_JobResult", global::System.Data.SqlDbType.VarBinary, 0, global::System.Data.ParameterDirection.Input, 0, 0, "JobResult", global::System.Data.DataRowVersion.Original, false, null, "", "", ""));
    84068492            this._adapter.DeleteCommand.Parameters.Add(new global::System.Data.SqlClient.SqlParameter("@IsNull_ResourceId", global::System.Data.SqlDbType.Int, 0, global::System.Data.ParameterDirection.Input, 0, 0, "ResourceId", global::System.Data.DataRowVersion.Original, true, null, "", "", ""));
    84078493            this._adapter.DeleteCommand.Parameters.Add(new global::System.Data.SqlClient.SqlParameter("@Original_ResourceId", global::System.Data.SqlDbType.BigInt, 0, global::System.Data.ParameterDirection.Input, 0, 0, "ResourceId", global::System.Data.DataRowVersion.Original, false, null, "", "", ""));
    84088494            this._adapter.InsertCommand = new global::System.Data.SqlClient.SqlCommand();
    84098495            this._adapter.InsertCommand.Connection = this.Connection;
    8410             this._adapter.InsertCommand.CommandText = "INSERT INTO [dbo].[JobResult] ([JobId], [JobResult], [ResourceId]) VALUES (@JobId" +
    8411                 ", @JobResult, @ResourceId);\r\nSELECT JobResultId, JobId, JobResult, ResourceId FR" +
    8412                 "OM JobResult WHERE (JobResultId = SCOPE_IDENTITY())";
     8496            this._adapter.InsertCommand.CommandText = "INSERT INTO [JobResult] ([JobId], [JobResult], [ResourceId], [Message]) VALUES (@" +
     8497                "JobId, @JobResult, @ResourceId, @Message);\r\nSELECT JobResultId, JobId, JobResult" +
     8498                ", ResourceId, Message FROM JobResult WHERE (JobResultId = SCOPE_IDENTITY())";
    84138499            this._adapter.InsertCommand.CommandType = global::System.Data.CommandType.Text;
    84148500            this._adapter.InsertCommand.Parameters.Add(new global::System.Data.SqlClient.SqlParameter("@JobId", global::System.Data.SqlDbType.BigInt, 0, global::System.Data.ParameterDirection.Input, 0, 0, "JobId", global::System.Data.DataRowVersion.Current, false, null, "", "", ""));
    84158501            this._adapter.InsertCommand.Parameters.Add(new global::System.Data.SqlClient.SqlParameter("@JobResult", global::System.Data.SqlDbType.VarBinary, 0, global::System.Data.ParameterDirection.Input, 0, 0, "JobResult", global::System.Data.DataRowVersion.Current, false, null, "", "", ""));
    84168502            this._adapter.InsertCommand.Parameters.Add(new global::System.Data.SqlClient.SqlParameter("@ResourceId", global::System.Data.SqlDbType.BigInt, 0, global::System.Data.ParameterDirection.Input, 0, 0, "ResourceId", global::System.Data.DataRowVersion.Current, false, null, "", "", ""));
     8503            this._adapter.InsertCommand.Parameters.Add(new global::System.Data.SqlClient.SqlParameter("@Message", global::System.Data.SqlDbType.VarChar, 0, global::System.Data.ParameterDirection.Input, 0, 0, "Message", global::System.Data.DataRowVersion.Current, false, null, "", "", ""));
    84178504            this._adapter.UpdateCommand = new global::System.Data.SqlClient.SqlCommand();
    84188505            this._adapter.UpdateCommand.Connection = this.Connection;
    8419             this._adapter.UpdateCommand.CommandText = @"UPDATE [dbo].[JobResult] SET [JobId] = @JobId, [JobResult] = @JobResult, [ResourceId] = @ResourceId WHERE (([JobResultId] = @Original_JobResultId) AND ((@IsNull_JobId = 1 AND [JobId] IS NULL) OR ([JobId] = @Original_JobId)) AND ((@IsNull_JobResult = 1 AND [JobResult] IS NULL) OR ([JobResult] = @Original_JobResult)) AND ((@IsNull_ResourceId = 1 AND [ResourceId] IS NULL) OR ([ResourceId] = @Original_ResourceId)));
    8420 SELECT JobResultId, JobId, JobResult, ResourceId FROM JobResult WHERE (JobResultId = @JobResultId)";
     8506            this._adapter.UpdateCommand.CommandText = @"UPDATE [JobResult] SET [JobId] = @JobId, [JobResult] = @JobResult, [ResourceId] = @ResourceId, [Message] = @Message WHERE (([JobResultId] = @Original_JobResultId) AND ((@IsNull_JobId = 1 AND [JobId] IS NULL) OR ([JobId] = @Original_JobId)) AND ((@IsNull_ResourceId = 1 AND [ResourceId] IS NULL) OR ([ResourceId] = @Original_ResourceId)));
     8507SELECT JobResultId, JobId, JobResult, ResourceId, Message FROM JobResult WHERE (JobResultId = @JobResultId)";
    84218508            this._adapter.UpdateCommand.CommandType = global::System.Data.CommandType.Text;
    84228509            this._adapter.UpdateCommand.Parameters.Add(new global::System.Data.SqlClient.SqlParameter("@JobId", global::System.Data.SqlDbType.BigInt, 0, global::System.Data.ParameterDirection.Input, 0, 0, "JobId", global::System.Data.DataRowVersion.Current, false, null, "", "", ""));
    84238510            this._adapter.UpdateCommand.Parameters.Add(new global::System.Data.SqlClient.SqlParameter("@JobResult", global::System.Data.SqlDbType.VarBinary, 0, global::System.Data.ParameterDirection.Input, 0, 0, "JobResult", global::System.Data.DataRowVersion.Current, false, null, "", "", ""));
    84248511            this._adapter.UpdateCommand.Parameters.Add(new global::System.Data.SqlClient.SqlParameter("@ResourceId", global::System.Data.SqlDbType.BigInt, 0, global::System.Data.ParameterDirection.Input, 0, 0, "ResourceId", global::System.Data.DataRowVersion.Current, false, null, "", "", ""));
     8512            this._adapter.UpdateCommand.Parameters.Add(new global::System.Data.SqlClient.SqlParameter("@Message", global::System.Data.SqlDbType.VarChar, 0, global::System.Data.ParameterDirection.Input, 0, 0, "Message", global::System.Data.DataRowVersion.Current, false, null, "", "", ""));
    84258513            this._adapter.UpdateCommand.Parameters.Add(new global::System.Data.SqlClient.SqlParameter("@Original_JobResultId", global::System.Data.SqlDbType.BigInt, 0, global::System.Data.ParameterDirection.Input, 0, 0, "JobResultId", global::System.Data.DataRowVersion.Original, false, null, "", "", ""));
    84268514            this._adapter.UpdateCommand.Parameters.Add(new global::System.Data.SqlClient.SqlParameter("@IsNull_JobId", global::System.Data.SqlDbType.Int, 0, global::System.Data.ParameterDirection.Input, 0, 0, "JobId", global::System.Data.DataRowVersion.Original, true, null, "", "", ""));
    84278515            this._adapter.UpdateCommand.Parameters.Add(new global::System.Data.SqlClient.SqlParameter("@Original_JobId", global::System.Data.SqlDbType.BigInt, 0, global::System.Data.ParameterDirection.Input, 0, 0, "JobId", global::System.Data.DataRowVersion.Original, false, null, "", "", ""));
    8428             this._adapter.UpdateCommand.Parameters.Add(new global::System.Data.SqlClient.SqlParameter("@IsNull_JobResult", global::System.Data.SqlDbType.Int, 0, global::System.Data.ParameterDirection.Input, 0, 0, "JobResult", global::System.Data.DataRowVersion.Original, true, null, "", "", ""));
    8429             this._adapter.UpdateCommand.Parameters.Add(new global::System.Data.SqlClient.SqlParameter("@Original_JobResult", global::System.Data.SqlDbType.VarBinary, 0, global::System.Data.ParameterDirection.Input, 0, 0, "JobResult", global::System.Data.DataRowVersion.Original, false, null, "", "", ""));
    84308516            this._adapter.UpdateCommand.Parameters.Add(new global::System.Data.SqlClient.SqlParameter("@IsNull_ResourceId", global::System.Data.SqlDbType.Int, 0, global::System.Data.ParameterDirection.Input, 0, 0, "ResourceId", global::System.Data.DataRowVersion.Original, true, null, "", "", ""));
    84318517            this._adapter.UpdateCommand.Parameters.Add(new global::System.Data.SqlClient.SqlParameter("@Original_ResourceId", global::System.Data.SqlDbType.BigInt, 0, global::System.Data.ParameterDirection.Input, 0, 0, "ResourceId", global::System.Data.DataRowVersion.Original, false, null, "", "", ""));
    … …  
    84448530            this._commandCollection[0] = new global::System.Data.SqlClient.SqlCommand();
    84458531            this._commandCollection[0].Connection = this.Connection;
    8446             this._commandCollection[0].CommandText = "SELECT JobResultId, JobId, JobResult, ResourceId FROM dbo.JobResult";
     8532            this._commandCollection[0].CommandText = "SELECT     JobResultId, JobId, JobResult, ResourceId, Message\r\nFROM         JobRe" +
     8533                "sult";
    84478534            this._commandCollection[0].CommandType = global::System.Data.CommandType.Text;
    84488535            this._commandCollection[1] = new global::System.Data.SqlClient.SqlCommand();
    84498536            this._commandCollection[1].Connection = this.Connection;
    8450             this._commandCollection[1].CommandText = "SELECT * FROM dbo.JobResult WHERE JobResultId = @Id";
     8537            this._commandCollection[1].CommandText = "SELECT JobId, JobResult, JobResultId, Message, ResourceId FROM JobResult WHERE (J" +
     8538                "obResultId = @Id)";
    84518539            this._commandCollection[1].CommandType = global::System.Data.CommandType.Text;
    84528540            this._commandCollection[1].Parameters.Add(new global::System.Data.SqlClient.SqlParameter("@Id", global::System.Data.SqlDbType.BigInt, 8, global::System.Data.ParameterDirection.Input, 0, 0, "JobResultId", global::System.Data.DataRowVersion.Current, false, null, "", "", ""));
    84538541            this._commandCollection[2] = new global::System.Data.SqlClient.SqlCommand();
    84548542            this._commandCollection[2].Connection = this.Connection;
    8455             this._commandCollection[2].CommandText = "SELECT * FROM dbo.JobResult WHERE JobId = @JobId";
     8543            this._commandCollection[2].CommandText = "SELECT JobId, JobResult, JobResultId, Message, ResourceId FROM JobResult WHERE (J" +
     8544                "obId = @JobId)";
    84568545            this._commandCollection[2].CommandType = global::System.Data.CommandType.Text;
    84578546            this._commandCollection[2].Parameters.Add(new global::System.Data.SqlClient.SqlParameter("@JobId", global::System.Data.SqlDbType.BigInt, 8, global::System.Data.ParameterDirection.Input, 0, 0, "JobId", global::System.Data.DataRowVersion.Current, false, null, "", "", ""));
    … …  
    85668655        [global::System.ComponentModel.Design.HelpKeywordAttribute("vs.data.TableAdapter")]
    85678656        [global::System.ComponentModel.DataObjectMethodAttribute(global::System.ComponentModel.DataObjectMethodType.Delete, true)]
    8568         public virtual int Delete(long Original_JobResultId, global::System.Nullable<long> Original_JobId, byte[] Original_JobResult, global::System.Nullable<long> Original_ResourceId) {
     8657        public virtual int Delete(long Original_JobResultId, global::System.Nullable<long> Original_JobId, global::System.Nullable<long> Original_ResourceId) {
    85698658            this.Adapter.DeleteCommand.Parameters[0].Value = ((long)(Original_JobResultId));
    85708659            if ((Original_JobId.HasValue == true)) {
    … …  
    85768665                this.Adapter.DeleteCommand.Parameters[2].Value = global::System.DBNull.Value;
    85778666            }
    8578             if ((Original_JobResult == null)) {
     8667            if ((Original_ResourceId.HasValue == true)) {
     8668                this.Adapter.DeleteCommand.Parameters[3].Value = ((object)(0));
     8669                this.Adapter.DeleteCommand.Parameters[4].Value = ((long)(Original_ResourceId.Value));
     8670            }
     8671            else {
    85798672                this.Adapter.DeleteCommand.Parameters[3].Value = ((object)(1));
    85808673                this.Adapter.DeleteCommand.Parameters[4].Value = global::System.DBNull.Value;
    8581             }
    8582             else {
    8583                 this.Adapter.DeleteCommand.Parameters[3].Value = ((object)(0));
    8584                 this.Adapter.DeleteCommand.Parameters[4].Value = ((byte[])(Original_JobResult));
    8585             }
    8586             if ((Original_ResourceId.HasValue == true)) {
    8587                 this.Adapter.DeleteCommand.Parameters[5].Value = ((object)(0));
    8588                 this.Adapter.DeleteCommand.Parameters[6].Value = ((long)(Original_ResourceId.Value));
    8589             }
    8590             else {
    8591                 this.Adapter.DeleteCommand.Parameters[5].Value = ((object)(1));
    8592                 this.Adapter.DeleteCommand.Parameters[6].Value = global::System.DBNull.Value;
    85938674            }
    85948675            global::System.Data.ConnectionState previousConnectionState = this.Adapter.DeleteCommand.Connection.State;
    … …  
    86118692        [global::System.ComponentModel.Design.HelpKeywordAttribute("vs.data.TableAdapter")]
    86128693        [global::System.ComponentModel.DataObjectMethodAttribute(global::System.ComponentModel.DataObjectMethodType.Insert, true)]
    8613         public virtual int Insert(global::System.Nullable<long> JobId, byte[] JobResult, global::System.Nullable<long> ResourceId) {
     8694        public virtual int Insert(global::System.Nullable<long> JobId, byte[] JobResult, global::System.Nullable<long> ResourceId, string Message) {
    86148695            if ((JobId.HasValue == true)) {
    86158696                this.Adapter.InsertCommand.Parameters[0].Value = ((long)(JobId.Value));
    … …  
    86298710            else {
    86308711                this.Adapter.InsertCommand.Parameters[2].Value = global::System.DBNull.Value;
     8712            }
     8713            if ((Message == null)) {
     8714                this.Adapter.InsertCommand.Parameters[3].Value = global::System.DBNull.Value;
     8715            }
     8716            else {
     8717                this.Adapter.InsertCommand.Parameters[3].Value = ((string)(Message));
    86318718            }
    86328719            global::System.Data.ConnectionState previousConnectionState = this.Adapter.InsertCommand.Connection.State;
    … …  
    86498736        [global::System.ComponentModel.Design.HelpKeywordAttribute("vs.data.TableAdapter")]
    86508737        [global::System.ComponentModel.DataObjectMethodAttribute(global::System.ComponentModel.DataObjectMethodType.Update, true)]
    8651         public virtual int Update(global::System.Nullable<long> JobId, byte[] JobResult, global::System.Nullable<long> ResourceId, long Original_JobResultId, global::System.Nullable<long> Original_JobId, byte[] Original_JobResult, global::System.Nullable<long> Original_ResourceId, long JobResultId) {
     8738        public virtual int Update(global::System.Nullable<long> JobId, byte[] JobResult, global::System.Nullable<long> ResourceId, string Message, long Original_JobResultId, global::System.Nullable<long> Original_JobId, global::System.Nullable<long> Original_ResourceId, long JobResultId) {
    86528739            if ((JobId.HasValue == true)) {
    86538740                this.Adapter.UpdateCommand.Parameters[0].Value = ((long)(JobId.Value));
    … …  
    86688755                this.Adapter.UpdateCommand.Parameters[2].Value = global::System.DBNull.Value;
    86698756            }
    8670             this.Adapter.UpdateCommand.Parameters[3].Value = ((long)(Original_JobResultId));
     8757            if ((Message == null)) {
     8758                this.Adapter.UpdateCommand.Parameters[3].Value = global::System.DBNull.Value;
     8759            }
     8760            else {
     8761                this.Adapter.UpdateCommand.Parameters[3].Value = ((string)(Message));
     8762            }
     8763            this.Adapter.UpdateCommand.Parameters[4].Value = ((long)(Original_JobResultId));
    86718764            if ((Original_JobId.HasValue == true)) {
    8672                 this.Adapter.UpdateCommand.Parameters[4].Value = ((object)(0));
    8673                 this.Adapter.UpdateCommand.Parameters[5].Value = ((long)(Original_JobId.Value));
     8765                this.Adapter.UpdateCommand.Parameters[5].Value = ((object)(0));
     8766                this.Adapter.UpdateCommand.Parameters[6].Value = ((long)(Original_JobId.Value));
    86748767            }
    86758768            else {
    8676                 this.Adapter.UpdateCommand.Parameters[4].Value = ((object)(1));
    8677                 this.Adapter.UpdateCommand.Parameters[5].Value = global::System.DBNull.Value;
    8678             }
    8679             if ((Original_JobResult == null)) {
    8680                 this.Adapter.UpdateCommand.Parameters[6].Value = ((object)(1));
    8681                 this.Adapter.UpdateCommand.Parameters[7].Value = global::System.DBNull.Value;
     8769                this.Adapter.UpdateCommand.Parameters[5].Value = ((object)(1));
     8770                this.Adapter.UpdateCommand.Parameters[6].Value = global::System.DBNull.Value;
     8771            }
     8772            if ((Original_ResourceId.HasValue == true)) {
     8773                this.Adapter.UpdateCommand.Parameters[7].Value = ((object)(0));
     8774                this.Adapter.UpdateCommand.Parameters[8].Value = ((long)(Original_ResourceId.Value));
    86828775            }
    86838776            else {
    8684                 this.Adapter.UpdateCommand.Parameters[6].Value = ((object)(0));
    8685                 this.Adapter.UpdateCommand.Parameters[7].Value = ((byte[])(Original_JobResult));
    8686             }
    8687             if ((Original_ResourceId.HasValue == true)) {
    8688                 this.Adapter.UpdateCommand.Parameters[8].Value = ((object)(0));
    8689                 this.Adapter.UpdateCommand.Parameters[9].Value = ((long)(Original_ResourceId.Value));
    8690             }
    8691             else {
    8692                 this.Adapter.UpdateCommand.Parameters[8].Value = ((object)(1));
    8693                 this.Adapter.UpdateCommand.Parameters[9].Value = global::System.DBNull.Value;
    8694             }
    8695             this.Adapter.UpdateCommand.Parameters[10].Value = ((long)(JobResultId));
     8777                this.Adapter.UpdateCommand.Parameters[7].Value = ((object)(1));
     8778                this.Adapter.UpdateCommand.Parameters[8].Value = global::System.DBNull.Value;
     8779            }
     8780            this.Adapter.UpdateCommand.Parameters[9].Value = ((long)(JobResultId));
    86968781            global::System.Data.ConnectionState previousConnectionState = this.Adapter.UpdateCommand.Connection.State;
    86978782            if (((this.Adapter.UpdateCommand.Connection.State & global::System.Data.ConnectionState.Open)
    … …  
    87138798        [global::System.ComponentModel.Design.HelpKeywordAttribute("vs.data.TableAdapter")]
    87148799        [global::System.ComponentModel.DataObjectMethodAttribute(global::System.ComponentModel.DataObjectMethodType.Update, true)]
    8715         public virtual int Update(global::System.Nullable<long> JobId, byte[] JobResult, global::System.Nullable<long> ResourceId, long Original_JobResultId, global::System.Nullable<long> Original_JobId, byte[] Original_JobResult, global::System.Nullable<long> Original_ResourceId) {
    8716             return this.Update(JobId, JobResult, ResourceId, Original_JobResultId, Original_JobId, Original_JobResult, Original_ResourceId, Original_JobResultId);
     8800        public virtual int Update(global::System.Nullable<long> JobId, byte[] JobResult, global::System.Nullable<long> ResourceId, string Message, long Original_JobResultId, global::System.Nullable<long> Original_JobId, global::System.Nullable<long> Original_ResourceId) {
     8801            return this.Update(JobId, JobResult, ResourceId, Message, Original_JobResultId, Original_JobId, Original_ResourceId, Original_JobResultId);
    87178802        }
    87188803    }
Note: See TracChangeset for help on using the changeset viewer.