- Timestamp:
- 01/22/09 15:17:57 (15 years ago)
- File:
-
- 1 edited
Legend:
- Unmodified
- Added
- Removed
-
trunk/sources/HeuristicLab.Hive.Server.ADODataAccess/dsHiveServer.Designer.cs
r1166 r1169 2448 2448 private global::System.Data.DataColumn columnSerializedJob; 2449 2449 2450 private global::System.Data.DataColumn columnDateCreated; 2451 2452 private global::System.Data.DataColumn columnDateCalculated; 2453 2454 private global::System.Data.DataColumn columnPriority; 2455 2450 2456 [global::System.Diagnostics.DebuggerNonUserCodeAttribute()] 2451 2457 public JobDataTable() { … … 2528 2534 2529 2535 [global::System.Diagnostics.DebuggerNonUserCodeAttribute()] 2536 public global::System.Data.DataColumn DateCreatedColumn { 2537 get { 2538 return this.columnDateCreated; 2539 } 2540 } 2541 2542 [global::System.Diagnostics.DebuggerNonUserCodeAttribute()] 2543 public global::System.Data.DataColumn DateCalculatedColumn { 2544 get { 2545 return this.columnDateCalculated; 2546 } 2547 } 2548 2549 [global::System.Diagnostics.DebuggerNonUserCodeAttribute()] 2550 public global::System.Data.DataColumn PriorityColumn { 2551 get { 2552 return this.columnPriority; 2553 } 2554 } 2555 2556 [global::System.Diagnostics.DebuggerNonUserCodeAttribute()] 2530 2557 [global::System.ComponentModel.Browsable(false)] 2531 2558 public int Count { … … 2556 2583 2557 2584 [global::System.Diagnostics.DebuggerNonUserCodeAttribute()] 2558 public JobRow AddJobRow(long ParentJobId, HiveUserRow parentHiveUserRowByR_35, ClientRow parentClientRowByR_21, string JobState, double Percentage, byte[] SerializedJob ) {2585 public JobRow AddJobRow(long ParentJobId, HiveUserRow parentHiveUserRowByR_35, ClientRow parentClientRowByR_21, string JobState, double Percentage, byte[] SerializedJob, System.DateTime DateCreated, System.DateTime DateCalculated, int Priority) { 2559 2586 JobRow rowJobRow = ((JobRow)(this.NewRow())); 2560 2587 object[] columnValuesArray = new object[] { … … 2565 2592 JobState, 2566 2593 Percentage, 2567 SerializedJob}; 2594 SerializedJob, 2595 DateCreated, 2596 DateCalculated, 2597 Priority}; 2568 2598 if ((parentHiveUserRowByR_35 != null)) { 2569 2599 columnValuesArray[2] = parentHiveUserRowByR_35[0]; … … 2604 2634 this.columnPercentage = base.Columns["Percentage"]; 2605 2635 this.columnSerializedJob = base.Columns["SerializedJob"]; 2636 this.columnDateCreated = base.Columns["DateCreated"]; 2637 this.columnDateCalculated = base.Columns["DateCalculated"]; 2638 this.columnPriority = base.Columns["Priority"]; 2606 2639 } 2607 2640 … … 2622 2655 this.columnSerializedJob = new global::System.Data.DataColumn("SerializedJob", typeof(byte[]), null, global::System.Data.MappingType.Element); 2623 2656 base.Columns.Add(this.columnSerializedJob); 2657 this.columnDateCreated = new global::System.Data.DataColumn("DateCreated", typeof(global::System.DateTime), null, global::System.Data.MappingType.Element); 2658 base.Columns.Add(this.columnDateCreated); 2659 this.columnDateCalculated = new global::System.Data.DataColumn("DateCalculated", typeof(global::System.DateTime), null, global::System.Data.MappingType.Element); 2660 base.Columns.Add(this.columnDateCalculated); 2661 this.columnPriority = new global::System.Data.DataColumn("Priority", typeof(int), null, global::System.Data.MappingType.Element); 2662 base.Columns.Add(this.columnPriority); 2624 2663 this.Constraints.Add(new global::System.Data.UniqueConstraint("Constraint1", new global::System.Data.DataColumn[] { 2625 2664 this.columnJobId}, true)); … … 3020 3059 private global::System.Data.DataColumn columnMessage; 3021 3060 3061 private global::System.Data.DataColumn columnPercentage; 3062 3063 private global::System.Data.DataColumn columnDateFinished; 3064 3022 3065 [global::System.Diagnostics.DebuggerNonUserCodeAttribute()] 3023 3066 public JobResultDataTable() { … … 3086 3129 3087 3130 [global::System.Diagnostics.DebuggerNonUserCodeAttribute()] 3131 public global::System.Data.DataColumn PercentageColumn { 3132 get { 3133 return this.columnPercentage; 3134 } 3135 } 3136 3137 [global::System.Diagnostics.DebuggerNonUserCodeAttribute()] 3138 public global::System.Data.DataColumn DateFinishedColumn { 3139 get { 3140 return this.columnDateFinished; 3141 } 3142 } 3143 3144 [global::System.Diagnostics.DebuggerNonUserCodeAttribute()] 3088 3145 [global::System.ComponentModel.Browsable(false)] 3089 3146 public int Count { … … 3114 3171 3115 3172 [global::System.Diagnostics.DebuggerNonUserCodeAttribute()] 3116 public JobResultRow AddJobResultRow(JobRow parentJobRowByR_14, byte[] JobResult, long ResourceId, string Message ) {3173 public JobResultRow AddJobResultRow(JobRow parentJobRowByR_14, byte[] JobResult, long ResourceId, string Message, double Percentage, System.DateTime DateFinished) { 3117 3174 JobResultRow rowJobResultRow = ((JobResultRow)(this.NewRow())); 3118 3175 object[] columnValuesArray = new object[] { … … 3121 3178 JobResult, 3122 3179 ResourceId, 3123 Message}; 3180 Message, 3181 Percentage, 3182 DateFinished}; 3124 3183 if ((parentJobRowByR_14 != null)) { 3125 3184 columnValuesArray[1] = parentJobRowByR_14[0]; … … 3155 3214 this.columnResourceId = base.Columns["ResourceId"]; 3156 3215 this.columnMessage = base.Columns["Message"]; 3216 this.columnPercentage = base.Columns["Percentage"]; 3217 this.columnDateFinished = base.Columns["DateFinished"]; 3157 3218 } 3158 3219 … … 3169 3230 this.columnMessage = new global::System.Data.DataColumn("Message", typeof(string), null, global::System.Data.MappingType.Element); 3170 3231 base.Columns.Add(this.columnMessage); 3232 this.columnPercentage = new global::System.Data.DataColumn("Percentage", typeof(double), null, global::System.Data.MappingType.Element); 3233 base.Columns.Add(this.columnPercentage); 3234 this.columnDateFinished = new global::System.Data.DataColumn("DateFinished", typeof(global::System.DateTime), null, global::System.Data.MappingType.Element); 3235 base.Columns.Add(this.columnDateFinished); 3171 3236 this.Constraints.Add(new global::System.Data.UniqueConstraint("Constraint1", new global::System.Data.DataColumn[] { 3172 3237 this.columnJobResultId}, true)); … … 4005 4070 4006 4071 [global::System.Diagnostics.DebuggerNonUserCodeAttribute()] 4072 public System.DateTime DateCreated { 4073 get { 4074 try { 4075 return ((global::System.DateTime)(this[this.tableJob.DateCreatedColumn])); 4076 } 4077 catch (global::System.InvalidCastException e) { 4078 throw new global::System.Data.StrongTypingException("The value for column \'DateCreated\' in table \'Job\' is DBNull.", e); 4079 } 4080 } 4081 set { 4082 this[this.tableJob.DateCreatedColumn] = value; 4083 } 4084 } 4085 4086 [global::System.Diagnostics.DebuggerNonUserCodeAttribute()] 4087 public System.DateTime DateCalculated { 4088 get { 4089 try { 4090 return ((global::System.DateTime)(this[this.tableJob.DateCalculatedColumn])); 4091 } 4092 catch (global::System.InvalidCastException e) { 4093 throw new global::System.Data.StrongTypingException("The value for column \'DateCalculated\' in table \'Job\' is DBNull.", e); 4094 } 4095 } 4096 set { 4097 this[this.tableJob.DateCalculatedColumn] = value; 4098 } 4099 } 4100 4101 [global::System.Diagnostics.DebuggerNonUserCodeAttribute()] 4102 public int Priority { 4103 get { 4104 try { 4105 return ((int)(this[this.tableJob.PriorityColumn])); 4106 } 4107 catch (global::System.InvalidCastException e) { 4108 throw new global::System.Data.StrongTypingException("The value for column \'Priority\' in table \'Job\' is DBNull.", e); 4109 } 4110 } 4111 set { 4112 this[this.tableJob.PriorityColumn] = value; 4113 } 4114 } 4115 4116 [global::System.Diagnostics.DebuggerNonUserCodeAttribute()] 4007 4117 public ClientRow ClientRow { 4008 4118 get { … … 4082 4192 public void SetSerializedJobNull() { 4083 4193 this[this.tableJob.SerializedJobColumn] = global::System.Convert.DBNull; 4194 } 4195 4196 [global::System.Diagnostics.DebuggerNonUserCodeAttribute()] 4197 public bool IsDateCreatedNull() { 4198 return this.IsNull(this.tableJob.DateCreatedColumn); 4199 } 4200 4201 [global::System.Diagnostics.DebuggerNonUserCodeAttribute()] 4202 public void SetDateCreatedNull() { 4203 this[this.tableJob.DateCreatedColumn] = global::System.Convert.DBNull; 4204 } 4205 4206 [global::System.Diagnostics.DebuggerNonUserCodeAttribute()] 4207 public bool IsDateCalculatedNull() { 4208 return this.IsNull(this.tableJob.DateCalculatedColumn); 4209 } 4210 4211 [global::System.Diagnostics.DebuggerNonUserCodeAttribute()] 4212 public void SetDateCalculatedNull() { 4213 this[this.tableJob.DateCalculatedColumn] = global::System.Convert.DBNull; 4214 } 4215 4216 [global::System.Diagnostics.DebuggerNonUserCodeAttribute()] 4217 public bool IsPriorityNull() { 4218 return this.IsNull(this.tableJob.PriorityColumn); 4219 } 4220 4221 [global::System.Diagnostics.DebuggerNonUserCodeAttribute()] 4222 public void SetPriorityNull() { 4223 this[this.tableJob.PriorityColumn] = global::System.Convert.DBNull; 4084 4224 } 4085 4225 … … 4235 4375 4236 4376 [global::System.Diagnostics.DebuggerNonUserCodeAttribute()] 4377 public double Percentage { 4378 get { 4379 try { 4380 return ((double)(this[this.tableJobResult.PercentageColumn])); 4381 } 4382 catch (global::System.InvalidCastException e) { 4383 throw new global::System.Data.StrongTypingException("The value for column \'Percentage\' in table \'JobResult\' is DBNull.", e); 4384 } 4385 } 4386 set { 4387 this[this.tableJobResult.PercentageColumn] = value; 4388 } 4389 } 4390 4391 [global::System.Diagnostics.DebuggerNonUserCodeAttribute()] 4392 public System.DateTime DateFinished { 4393 get { 4394 try { 4395 return ((global::System.DateTime)(this[this.tableJobResult.DateFinishedColumn])); 4396 } 4397 catch (global::System.InvalidCastException e) { 4398 throw new global::System.Data.StrongTypingException("The value for column \'DateFinished\' in table \'JobResult\' is DBNull.", e); 4399 } 4400 } 4401 set { 4402 this[this.tableJobResult.DateFinishedColumn] = value; 4403 } 4404 } 4405 4406 [global::System.Diagnostics.DebuggerNonUserCodeAttribute()] 4237 4407 public JobRow JobRow { 4238 4408 get { … … 4282 4452 public void SetMessageNull() { 4283 4453 this[this.tableJobResult.MessageColumn] = global::System.Convert.DBNull; 4454 } 4455 4456 [global::System.Diagnostics.DebuggerNonUserCodeAttribute()] 4457 public bool IsPercentageNull() { 4458 return this.IsNull(this.tableJobResult.PercentageColumn); 4459 } 4460 4461 [global::System.Diagnostics.DebuggerNonUserCodeAttribute()] 4462 public void SetPercentageNull() { 4463 this[this.tableJobResult.PercentageColumn] = global::System.Convert.DBNull; 4464 } 4465 4466 [global::System.Diagnostics.DebuggerNonUserCodeAttribute()] 4467 public bool IsDateFinishedNull() { 4468 return this.IsNull(this.tableJobResult.DateFinishedColumn); 4469 } 4470 4471 [global::System.Diagnostics.DebuggerNonUserCodeAttribute()] 4472 public void SetDateFinishedNull() { 4473 this[this.tableJobResult.DateFinishedColumn] = global::System.Convert.DBNull; 4284 4474 } 4285 4475 } … … 7519 7709 tableMapping.ColumnMappings.Add("Percentage", "Percentage"); 7520 7710 tableMapping.ColumnMappings.Add("SerializedJob", "SerializedJob"); 7711 tableMapping.ColumnMappings.Add("DateCreated", "DateCreated"); 7712 tableMapping.ColumnMappings.Add("DateCalculated", "DateCalculated"); 7713 tableMapping.ColumnMappings.Add("Priority", "Priority"); 7521 7714 this._adapter.TableMappings.Add(tableMapping); 7522 7715 this._adapter.DeleteCommand = new global::System.Data.SqlClient.SqlCommand(); 7523 7716 this._adapter.DeleteCommand.Connection = this.Connection; 7524 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)) AND ((@IsNull_Percentage = 1 AND [Percentage] IS NULL) OR ([Percentage] = @Original_Percentage)) )";7717 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)) AND ((@IsNull_Percentage = 1 AND [Percentage] IS NULL) OR ([Percentage] = @Original_Percentage)) AND ((@IsNull_DateCreated = 1 AND [DateCreated] IS NULL) OR ([DateCreated] = @Original_DateCreated)) AND ((@IsNull_DateCalculated = 1 AND [DateCalculated] IS NULL) OR ([DateCalculated] = @Original_DateCalculated)) AND ((@IsNull_Priority = 1 AND [Priority] IS NULL) OR ([Priority] = @Original_Priority)))"; 7525 7718 this._adapter.DeleteCommand.CommandType = global::System.Data.CommandType.Text; 7526 7719 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, "", "", "")); … … 7535 7728 this._adapter.DeleteCommand.Parameters.Add(new global::System.Data.SqlClient.SqlParameter("@IsNull_Percentage", global::System.Data.SqlDbType.Int, 0, global::System.Data.ParameterDirection.Input, 0, 0, "Percentage", global::System.Data.DataRowVersion.Original, true, null, "", "", "")); 7536 7729 this._adapter.DeleteCommand.Parameters.Add(new global::System.Data.SqlClient.SqlParameter("@Original_Percentage", global::System.Data.SqlDbType.Float, 0, global::System.Data.ParameterDirection.Input, 0, 0, "Percentage", global::System.Data.DataRowVersion.Original, false, null, "", "", "")); 7730 this._adapter.DeleteCommand.Parameters.Add(new global::System.Data.SqlClient.SqlParameter("@IsNull_DateCreated", global::System.Data.SqlDbType.Int, 0, global::System.Data.ParameterDirection.Input, 0, 0, "DateCreated", global::System.Data.DataRowVersion.Original, true, null, "", "", "")); 7731 this._adapter.DeleteCommand.Parameters.Add(new global::System.Data.SqlClient.SqlParameter("@Original_DateCreated", global::System.Data.SqlDbType.DateTime, 0, global::System.Data.ParameterDirection.Input, 0, 0, "DateCreated", global::System.Data.DataRowVersion.Original, false, null, "", "", "")); 7732 this._adapter.DeleteCommand.Parameters.Add(new global::System.Data.SqlClient.SqlParameter("@IsNull_DateCalculated", global::System.Data.SqlDbType.Int, 0, global::System.Data.ParameterDirection.Input, 0, 0, "DateCalculated", global::System.Data.DataRowVersion.Original, true, null, "", "", "")); 7733 this._adapter.DeleteCommand.Parameters.Add(new global::System.Data.SqlClient.SqlParameter("@Original_DateCalculated", global::System.Data.SqlDbType.DateTime, 0, global::System.Data.ParameterDirection.Input, 0, 0, "DateCalculated", global::System.Data.DataRowVersion.Original, false, null, "", "", "")); 7734 this._adapter.DeleteCommand.Parameters.Add(new global::System.Data.SqlClient.SqlParameter("@IsNull_Priority", global::System.Data.SqlDbType.Int, 0, global::System.Data.ParameterDirection.Input, 0, 0, "Priority", global::System.Data.DataRowVersion.Original, true, null, "", "", "")); 7735 this._adapter.DeleteCommand.Parameters.Add(new global::System.Data.SqlClient.SqlParameter("@Original_Priority", global::System.Data.SqlDbType.Int, 0, global::System.Data.ParameterDirection.Input, 0, 0, "Priority", global::System.Data.DataRowVersion.Original, false, null, "", "", "")); 7537 7736 this._adapter.InsertCommand = new global::System.Data.SqlClient.SqlCommand(); 7538 7737 this._adapter.InsertCommand.Connection = this.Connection; 7539 this._adapter.InsertCommand.CommandText = @"INSERT INTO [Job] ([ParentJobId], [JobState], [PermissionOwnerId], [ResourceId], [SerializedJob], [Percentage] ) VALUES (@ParentJobId, @JobState, @PermissionOwnerId, @ResourceId, @SerializedJob, @Percentage);7540 SELECT JobId, ParentJobId, JobState, PermissionOwnerId, ResourceId, SerializedJob, Percentage FROM Job WHERE (JobId = SCOPE_IDENTITY())";7738 this._adapter.InsertCommand.CommandText = @"INSERT INTO [Job] ([ParentJobId], [JobState], [PermissionOwnerId], [ResourceId], [SerializedJob], [Percentage], [DateCreated], [DateCalculated], [Priority]) VALUES (@ParentJobId, @JobState, @PermissionOwnerId, @ResourceId, @SerializedJob, @Percentage, @DateCreated, @DateCalculated, @Priority); 7739 SELECT JobId, ParentJobId, JobState, PermissionOwnerId, ResourceId, SerializedJob, Percentage, DateCreated, DateCalculated, Priority FROM Job WHERE (JobId = SCOPE_IDENTITY())"; 7541 7740 this._adapter.InsertCommand.CommandType = global::System.Data.CommandType.Text; 7542 7741 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, "", "", "")); … … 7546 7745 this._adapter.InsertCommand.Parameters.Add(new global::System.Data.SqlClient.SqlParameter("@SerializedJob", global::System.Data.SqlDbType.VarBinary, 0, global::System.Data.ParameterDirection.Input, 0, 0, "SerializedJob", global::System.Data.DataRowVersion.Current, false, null, "", "", "")); 7547 7746 this._adapter.InsertCommand.Parameters.Add(new global::System.Data.SqlClient.SqlParameter("@Percentage", global::System.Data.SqlDbType.Float, 0, global::System.Data.ParameterDirection.Input, 0, 0, "Percentage", global::System.Data.DataRowVersion.Current, false, null, "", "", "")); 7747 this._adapter.InsertCommand.Parameters.Add(new global::System.Data.SqlClient.SqlParameter("@DateCreated", global::System.Data.SqlDbType.DateTime, 0, global::System.Data.ParameterDirection.Input, 0, 0, "DateCreated", global::System.Data.DataRowVersion.Current, false, null, "", "", "")); 7748 this._adapter.InsertCommand.Parameters.Add(new global::System.Data.SqlClient.SqlParameter("@DateCalculated", global::System.Data.SqlDbType.DateTime, 0, global::System.Data.ParameterDirection.Input, 0, 0, "DateCalculated", global::System.Data.DataRowVersion.Current, false, null, "", "", "")); 7749 this._adapter.InsertCommand.Parameters.Add(new global::System.Data.SqlClient.SqlParameter("@Priority", global::System.Data.SqlDbType.Int, 0, global::System.Data.ParameterDirection.Input, 0, 0, "Priority", global::System.Data.DataRowVersion.Current, false, null, "", "", "")); 7548 7750 this._adapter.UpdateCommand = new global::System.Data.SqlClient.SqlCommand(); 7549 7751 this._adapter.UpdateCommand.Connection = this.Connection; 7550 this._adapter.UpdateCommand.CommandText = @"UPDATE [Job] SET [ParentJobId] = @ParentJobId, [JobState] = @JobState, [PermissionOwnerId] = @PermissionOwnerId, [ResourceId] = @ResourceId, [SerializedJob] = @SerializedJob, [Percentage] = @Percentage 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)) AND ((@IsNull_Percentage = 1 AND [Percentage] IS NULL) OR ([Percentage] = @Original_Percentage)));7551 SELECT JobId, ParentJobId, JobState, PermissionOwnerId, ResourceId, SerializedJob, Percentage FROM Job WHERE (JobId = @JobId)";7752 this._adapter.UpdateCommand.CommandText = @"UPDATE [Job] SET [ParentJobId] = @ParentJobId, [JobState] = @JobState, [PermissionOwnerId] = @PermissionOwnerId, [ResourceId] = @ResourceId, [SerializedJob] = @SerializedJob, [Percentage] = @Percentage, [DateCreated] = @DateCreated, [DateCalculated] = @DateCalculated, [Priority] = @Priority 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)) AND ((@IsNull_Percentage = 1 AND [Percentage] IS NULL) OR ([Percentage] = @Original_Percentage)) AND ((@IsNull_DateCreated = 1 AND [DateCreated] IS NULL) OR ([DateCreated] = @Original_DateCreated)) AND ((@IsNull_DateCalculated = 1 AND [DateCalculated] IS NULL) OR ([DateCalculated] = @Original_DateCalculated)) AND ((@IsNull_Priority = 1 AND [Priority] IS NULL) OR ([Priority] = @Original_Priority))); 7753 SELECT JobId, ParentJobId, JobState, PermissionOwnerId, ResourceId, SerializedJob, Percentage, DateCreated, DateCalculated, Priority FROM Job WHERE (JobId = @JobId)"; 7552 7754 this._adapter.UpdateCommand.CommandType = global::System.Data.CommandType.Text; 7553 7755 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, "", "", "")); … … 7557 7759 this._adapter.UpdateCommand.Parameters.Add(new global::System.Data.SqlClient.SqlParameter("@SerializedJob", global::System.Data.SqlDbType.VarBinary, 0, global::System.Data.ParameterDirection.Input, 0, 0, "SerializedJob", global::System.Data.DataRowVersion.Current, false, null, "", "", "")); 7558 7760 this._adapter.UpdateCommand.Parameters.Add(new global::System.Data.SqlClient.SqlParameter("@Percentage", global::System.Data.SqlDbType.Float, 0, global::System.Data.ParameterDirection.Input, 0, 0, "Percentage", global::System.Data.DataRowVersion.Current, false, null, "", "", "")); 7761 this._adapter.UpdateCommand.Parameters.Add(new global::System.Data.SqlClient.SqlParameter("@DateCreated", global::System.Data.SqlDbType.DateTime, 0, global::System.Data.ParameterDirection.Input, 0, 0, "DateCreated", global::System.Data.DataRowVersion.Current, false, null, "", "", "")); 7762 this._adapter.UpdateCommand.Parameters.Add(new global::System.Data.SqlClient.SqlParameter("@DateCalculated", global::System.Data.SqlDbType.DateTime, 0, global::System.Data.ParameterDirection.Input, 0, 0, "DateCalculated", global::System.Data.DataRowVersion.Current, false, null, "", "", "")); 7763 this._adapter.UpdateCommand.Parameters.Add(new global::System.Data.SqlClient.SqlParameter("@Priority", global::System.Data.SqlDbType.Int, 0, global::System.Data.ParameterDirection.Input, 0, 0, "Priority", global::System.Data.DataRowVersion.Current, false, null, "", "", "")); 7559 7764 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, "", "", "")); 7560 7765 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, "", "", "")); … … 7568 7773 this._adapter.UpdateCommand.Parameters.Add(new global::System.Data.SqlClient.SqlParameter("@IsNull_Percentage", global::System.Data.SqlDbType.Int, 0, global::System.Data.ParameterDirection.Input, 0, 0, "Percentage", global::System.Data.DataRowVersion.Original, true, null, "", "", "")); 7569 7774 this._adapter.UpdateCommand.Parameters.Add(new global::System.Data.SqlClient.SqlParameter("@Original_Percentage", global::System.Data.SqlDbType.Float, 0, global::System.Data.ParameterDirection.Input, 0, 0, "Percentage", global::System.Data.DataRowVersion.Original, false, null, "", "", "")); 7775 this._adapter.UpdateCommand.Parameters.Add(new global::System.Data.SqlClient.SqlParameter("@IsNull_DateCreated", global::System.Data.SqlDbType.Int, 0, global::System.Data.ParameterDirection.Input, 0, 0, "DateCreated", global::System.Data.DataRowVersion.Original, true, null, "", "", "")); 7776 this._adapter.UpdateCommand.Parameters.Add(new global::System.Data.SqlClient.SqlParameter("@Original_DateCreated", global::System.Data.SqlDbType.DateTime, 0, global::System.Data.ParameterDirection.Input, 0, 0, "DateCreated", global::System.Data.DataRowVersion.Original, false, null, "", "", "")); 7777 this._adapter.UpdateCommand.Parameters.Add(new global::System.Data.SqlClient.SqlParameter("@IsNull_DateCalculated", global::System.Data.SqlDbType.Int, 0, global::System.Data.ParameterDirection.Input, 0, 0, "DateCalculated", global::System.Data.DataRowVersion.Original, true, null, "", "", "")); 7778 this._adapter.UpdateCommand.Parameters.Add(new global::System.Data.SqlClient.SqlParameter("@Original_DateCalculated", global::System.Data.SqlDbType.DateTime, 0, global::System.Data.ParameterDirection.Input, 0, 0, "DateCalculated", global::System.Data.DataRowVersion.Original, false, null, "", "", "")); 7779 this._adapter.UpdateCommand.Parameters.Add(new global::System.Data.SqlClient.SqlParameter("@IsNull_Priority", global::System.Data.SqlDbType.Int, 0, global::System.Data.ParameterDirection.Input, 0, 0, "Priority", global::System.Data.DataRowVersion.Original, true, null, "", "", "")); 7780 this._adapter.UpdateCommand.Parameters.Add(new global::System.Data.SqlClient.SqlParameter("@Original_Priority", global::System.Data.SqlDbType.Int, 0, global::System.Data.ParameterDirection.Input, 0, 0, "Priority", global::System.Data.DataRowVersion.Original, false, null, "", "", "")); 7570 7781 this._adapter.UpdateCommand.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, "", "", "")); 7571 7782 } … … 7582 7793 this._commandCollection[0] = new global::System.Data.SqlClient.SqlCommand(); 7583 7794 this._commandCollection[0].Connection = this.Connection; 7584 this._commandCollection[0].CommandText = "SELECT JobId, ParentJobId, JobState, PermissionOwnerId, ResourceId, SerializedJob" +7585 " , Percentage FROMJob";7795 this._commandCollection[0].CommandText = "SELECT JobId, ParentJobId, JobState, PermissionOwnerId, ResourceId, Serialize" + 7796 "dJob, Percentage, DateCreated, DateCalculated, Priority\r\nFROM Job"; 7586 7797 this._commandCollection[0].CommandType = global::System.Data.CommandType.Text; 7587 7798 this._commandCollection[1] = new global::System.Data.SqlClient.SqlCommand(); 7588 7799 this._commandCollection[1].Connection = this.Connection; 7589 this._commandCollection[1].CommandText = "SELECT JobId, JobState, ParentJobId, PermissionOwnerId, ResourceId, Serialize" +7590 " dJob, Percentage\r\nFROM Job\r\nWHERE (JobState = \'calculating\') OR\r\n" +7591 " 7800 this._commandCollection[1].CommandText = "SELECT DateCalculated, DateCreated, JobId, JobState, ParentJobId, Percentage, Per" + 7801 "missionOwnerId, Priority, ResourceId, SerializedJob FROM Job WHERE (JobState = \'" + 7802 "calculating\') OR (JobState = \'idle\')"; 7592 7803 this._commandCollection[1].CommandType = global::System.Data.CommandType.Text; 7593 7804 this._commandCollection[2] = new global::System.Data.SqlClient.SqlCommand(); 7594 7805 this._commandCollection[2].Connection = this.Connection; 7595 7806 this._commandCollection[2].CommandText = "SELECT JobId, JobState, ParentJobId, PermissionOwnerId, ResourceId, Serialize" + 7596 "dJob, Percentage \r\nFROM Job\r\nWHERE (JobState = \'calculating\') AND (Re" +7597 " sourceId = @ResourceId)";7807 "dJob, Percentage, DateCreated, DateCalculated, Priority\r\nFROM Job\r\nWHERE" + 7808 " (JobState = \'calculating\') AND (ResourceId = @ResourceId)"; 7598 7809 this._commandCollection[2].CommandType = global::System.Data.CommandType.Text; 7599 7810 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, "", "", "")); 7600 7811 this._commandCollection[3] = new global::System.Data.SqlClient.SqlCommand(); 7601 7812 this._commandCollection[3].Connection = this.Connection; 7602 this._commandCollection[3].CommandText = "SELECT JobId, JobState, ParentJobId, PermissionOwnerId, ResourceId, Serialize" + 7603 "dJob, Percentage\r\nFROM Job\r\nWHERE (ResourceId = @ResourceId)"; 7813 this._commandCollection[3].CommandText = "SELECT DateCalculated, DateCreated, JobId, JobState, ParentJobId, Percentage, Per" + 7814 "missionOwnerId, Priority, ResourceId, SerializedJob FROM Job WHERE (ResourceId =" + 7815 " @ResourceId)"; 7604 7816 this._commandCollection[3].CommandType = global::System.Data.CommandType.Text; 7605 7817 this._commandCollection[3].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, "", "", "")); 7606 7818 this._commandCollection[4] = new global::System.Data.SqlClient.SqlCommand(); 7607 7819 this._commandCollection[4].Connection = this.Connection; 7608 this._commandCollection[4].CommandText = "SELECT JobId, JobState, ParentJobId, PermissionOwnerId, ResourceId, Serialize" + 7609 "dJob, Percentage\r\nFROM Job\r\nWHERE (JobId = @Id)"; 7820 this._commandCollection[4].CommandText = "SELECT DateCalculated, DateCreated, JobId, JobState, ParentJobId, Percentage," + 7821 " PermissionOwnerId, Priority, ResourceId, SerializedJob\r\nFROM Job\r\nWHERE" + 7822 " (JobId = @Id)"; 7610 7823 this._commandCollection[4].CommandType = global::System.Data.CommandType.Text; 7611 7824 this._commandCollection[4].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, "", "", "")); 7612 7825 this._commandCollection[5] = new global::System.Data.SqlClient.SqlCommand(); 7613 7826 this._commandCollection[5].Connection = this.Connection; 7614 this._commandCollection[5].CommandText = "SELECT JobId, JobState, ParentJobId, PermissionOwnerId, ResourceId, Serialize" + 7615 "dJob, Percentage\r\nFROM Job\r\nWHERE (JobState = @State)"; 7827 this._commandCollection[5].CommandText = "SELECT DateCalculated, DateCreated, JobId, JobState, ParentJobId, Percentage, Per" + 7828 "missionOwnerId, Priority, ResourceId, SerializedJob FROM Job WHERE (JobState = @" + 7829 "State)"; 7616 7830 this._commandCollection[5].CommandType = global::System.Data.CommandType.Text; 7617 7831 this._commandCollection[5].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, "", "", "")); 7618 7832 this._commandCollection[6] = new global::System.Data.SqlClient.SqlCommand(); 7619 7833 this._commandCollection[6].Connection = this.Connection; 7620 this._commandCollection[6].CommandText = "SELECT JobId, JobState, ParentJobId, PermissionOwnerId, ResourceId, Serialize" + 7621 "dJob, Percentage\r\nFROM Job\r\nWHERE (ParentJobId = @Id)"; 7834 this._commandCollection[6].CommandText = "SELECT DateCalculated, DateCreated, JobId, JobState, ParentJobId, Percentage, Per" + 7835 "missionOwnerId, Priority, ResourceId, SerializedJob FROM Job WHERE (ParentJobId " + 7836 "= @Id)"; 7622 7837 this._commandCollection[6].CommandType = global::System.Data.CommandType.Text; 7623 7838 this._commandCollection[6].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, "", "", "")); 7624 7839 this._commandCollection[7] = new global::System.Data.SqlClient.SqlCommand(); 7625 7840 this._commandCollection[7].Connection = this.Connection; 7626 this._commandCollection[7].CommandText = "SELECT JobId, JobState, ParentJobId, PermissionOwnerId, ResourceId, Serialize" +7627 " dJob, Percentage\r\nFROM Job\r\nWHERE (PermissionOwnerId = @PermissionOw" +7628 "nerId )";7841 this._commandCollection[7].CommandText = "SELECT DateCalculated, DateCreated, JobId, JobState, ParentJobId, Percentage, Per" + 7842 "missionOwnerId, Priority, ResourceId, SerializedJob FROM Job WHERE (PermissionOw" + 7843 "nerId = @PermissionOwnerId)"; 7629 7844 this._commandCollection[7].CommandType = global::System.Data.CommandType.Text; 7630 7845 this._commandCollection[7].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, "", "", "")); … … 7897 8112 [global::System.ComponentModel.Design.HelpKeywordAttribute("vs.data.TableAdapter")] 7898 8113 [global::System.ComponentModel.DataObjectMethodAttribute(global::System.ComponentModel.DataObjectMethodType.Delete, true)] 7899 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, global::System.Nullable<double> Original_Percentage ) {8114 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, global::System.Nullable<double> Original_Percentage, global::System.Nullable<global::System.DateTime> Original_DateCreated, global::System.Nullable<global::System.DateTime> Original_DateCalculated, global::System.Nullable<int> Original_Priority) { 7900 8115 this.Adapter.DeleteCommand.Parameters[0].Value = ((long)(Original_JobId)); 7901 8116 if ((Original_ParentJobId.HasValue == true)) { … … 7939 8154 this.Adapter.DeleteCommand.Parameters[10].Value = global::System.DBNull.Value; 7940 8155 } 8156 if ((Original_DateCreated.HasValue == true)) { 8157 this.Adapter.DeleteCommand.Parameters[11].Value = ((object)(0)); 8158 this.Adapter.DeleteCommand.Parameters[12].Value = ((System.DateTime)(Original_DateCreated.Value)); 8159 } 8160 else { 8161 this.Adapter.DeleteCommand.Parameters[11].Value = ((object)(1)); 8162 this.Adapter.DeleteCommand.Parameters[12].Value = global::System.DBNull.Value; 8163 } 8164 if ((Original_DateCalculated.HasValue == true)) { 8165 this.Adapter.DeleteCommand.Parameters[13].Value = ((object)(0)); 8166 this.Adapter.DeleteCommand.Parameters[14].Value = ((System.DateTime)(Original_DateCalculated.Value)); 8167 } 8168 else { 8169 this.Adapter.DeleteCommand.Parameters[13].Value = ((object)(1)); 8170 this.Adapter.DeleteCommand.Parameters[14].Value = global::System.DBNull.Value; 8171 } 8172 if ((Original_Priority.HasValue == true)) { 8173 this.Adapter.DeleteCommand.Parameters[15].Value = ((object)(0)); 8174 this.Adapter.DeleteCommand.Parameters[16].Value = ((int)(Original_Priority.Value)); 8175 } 8176 else { 8177 this.Adapter.DeleteCommand.Parameters[15].Value = ((object)(1)); 8178 this.Adapter.DeleteCommand.Parameters[16].Value = global::System.DBNull.Value; 8179 } 7941 8180 global::System.Data.ConnectionState previousConnectionState = this.Adapter.DeleteCommand.Connection.State; 7942 8181 if (((this.Adapter.DeleteCommand.Connection.State & global::System.Data.ConnectionState.Open) … … 7958 8197 [global::System.ComponentModel.Design.HelpKeywordAttribute("vs.data.TableAdapter")] 7959 8198 [global::System.ComponentModel.DataObjectMethodAttribute(global::System.ComponentModel.DataObjectMethodType.Insert, true)] 7960 public virtual int Insert(global::System.Nullable<long> ParentJobId, string JobState, global::System.Nullable<long> PermissionOwnerId, global::System.Nullable<long> ResourceId, byte[] SerializedJob, global::System.Nullable<double> Percentage ) {8199 public virtual int Insert(global::System.Nullable<long> ParentJobId, string JobState, global::System.Nullable<long> PermissionOwnerId, global::System.Nullable<long> ResourceId, byte[] SerializedJob, global::System.Nullable<double> Percentage, global::System.Nullable<global::System.DateTime> DateCreated, global::System.Nullable<global::System.DateTime> DateCalculated, global::System.Nullable<int> Priority) { 7961 8200 if ((ParentJobId.HasValue == true)) { 7962 8201 this.Adapter.InsertCommand.Parameters[0].Value = ((long)(ParentJobId.Value)); … … 7994 8233 else { 7995 8234 this.Adapter.InsertCommand.Parameters[5].Value = global::System.DBNull.Value; 8235 } 8236 if ((DateCreated.HasValue == true)) { 8237 this.Adapter.InsertCommand.Parameters[6].Value = ((System.DateTime)(DateCreated.Value)); 8238 } 8239 else { 8240 this.Adapter.InsertCommand.Parameters[6].Value = global::System.DBNull.Value; 8241 } 8242 if ((DateCalculated.HasValue == true)) { 8243 this.Adapter.InsertCommand.Parameters[7].Value = ((System.DateTime)(DateCalculated.Value)); 8244 } 8245 else { 8246 this.Adapter.InsertCommand.Parameters[7].Value = global::System.DBNull.Value; 8247 } 8248 if ((Priority.HasValue == true)) { 8249 this.Adapter.InsertCommand.Parameters[8].Value = ((int)(Priority.Value)); 8250 } 8251 else { 8252 this.Adapter.InsertCommand.Parameters[8].Value = global::System.DBNull.Value; 7996 8253 } 7997 8254 global::System.Data.ConnectionState previousConnectionState = this.Adapter.InsertCommand.Connection.State; … … 8014 8271 [global::System.ComponentModel.Design.HelpKeywordAttribute("vs.data.TableAdapter")] 8015 8272 [global::System.ComponentModel.DataObjectMethodAttribute(global::System.ComponentModel.DataObjectMethodType.Update, true)] 8016 public virtual int Update(global::System.Nullable<long> ParentJobId, string JobState, global::System.Nullable<long> PermissionOwnerId, global::System.Nullable<long> ResourceId, byte[] SerializedJob, global::System.Nullable<double> Percentage, long Original_JobId, global::System.Nullable<long> Original_ParentJobId, string Original_JobState, global::System.Nullable<long> Original_PermissionOwnerId, global::System.Nullable<long> Original_ResourceId, global::System.Nullable<double> Original_Percentage, long JobId) { 8273 public virtual int Update( 8274 global::System.Nullable<long> ParentJobId, 8275 string JobState, 8276 global::System.Nullable<long> PermissionOwnerId, 8277 global::System.Nullable<long> ResourceId, 8278 byte[] SerializedJob, 8279 global::System.Nullable<double> Percentage, 8280 global::System.Nullable<global::System.DateTime> DateCreated, 8281 global::System.Nullable<global::System.DateTime> DateCalculated, 8282 global::System.Nullable<int> Priority, 8283 long Original_JobId, 8284 global::System.Nullable<long> Original_ParentJobId, 8285 string Original_JobState, 8286 global::System.Nullable<long> Original_PermissionOwnerId, 8287 global::System.Nullable<long> Original_ResourceId, 8288 global::System.Nullable<double> Original_Percentage, 8289 global::System.Nullable<global::System.DateTime> Original_DateCreated, 8290 global::System.Nullable<global::System.DateTime> Original_DateCalculated, 8291 global::System.Nullable<int> Original_Priority, 8292 long JobId) { 8017 8293 if ((ParentJobId.HasValue == true)) { 8018 8294 this.Adapter.UpdateCommand.Parameters[0].Value = ((long)(ParentJobId.Value)); … … 8051 8327 this.Adapter.UpdateCommand.Parameters[5].Value = global::System.DBNull.Value; 8052 8328 } 8053 this.Adapter.UpdateCommand.Parameters[6].Value = ((long)(Original_JobId)); 8329 if ((DateCreated.HasValue == true)) { 8330 this.Adapter.UpdateCommand.Parameters[6].Value = ((System.DateTime)(DateCreated.Value)); 8331 } 8332 else { 8333 this.Adapter.UpdateCommand.Parameters[6].Value = global::System.DBNull.Value; 8334 } 8335 if ((DateCalculated.HasValue == true)) { 8336 this.Adapter.UpdateCommand.Parameters[7].Value = ((System.DateTime)(DateCalculated.Value)); 8337 } 8338 else { 8339 this.Adapter.UpdateCommand.Parameters[7].Value = global::System.DBNull.Value; 8340 } 8341 if ((Priority.HasValue == true)) { 8342 this.Adapter.UpdateCommand.Parameters[8].Value = ((int)(Priority.Value)); 8343 } 8344 else { 8345 this.Adapter.UpdateCommand.Parameters[8].Value = global::System.DBNull.Value; 8346 } 8347 this.Adapter.UpdateCommand.Parameters[9].Value = ((long)(Original_JobId)); 8054 8348 if ((Original_ParentJobId.HasValue == true)) { 8055 this.Adapter.UpdateCommand.Parameters[ 7].Value = ((object)(0));8056 this.Adapter.UpdateCommand.Parameters[ 8].Value = ((long)(Original_ParentJobId.Value));8057 } 8058 else { 8059 this.Adapter.UpdateCommand.Parameters[ 7].Value = ((object)(1));8060 this.Adapter.UpdateCommand.Parameters[ 8].Value = global::System.DBNull.Value;8349 this.Adapter.UpdateCommand.Parameters[10].Value = ((object)(0)); 8350 this.Adapter.UpdateCommand.Parameters[11].Value = ((long)(Original_ParentJobId.Value)); 8351 } 8352 else { 8353 this.Adapter.UpdateCommand.Parameters[10].Value = ((object)(1)); 8354 this.Adapter.UpdateCommand.Parameters[11].Value = global::System.DBNull.Value; 8061 8355 } 8062 8356 if ((Original_JobState == null)) { 8063 this.Adapter.UpdateCommand.Parameters[ 9].Value = ((object)(1));8064 this.Adapter.UpdateCommand.Parameters[1 0].Value = global::System.DBNull.Value;8065 } 8066 else { 8067 this.Adapter.UpdateCommand.Parameters[ 9].Value = ((object)(0));8068 this.Adapter.UpdateCommand.Parameters[1 0].Value = ((string)(Original_JobState));8357 this.Adapter.UpdateCommand.Parameters[12].Value = ((object)(1)); 8358 this.Adapter.UpdateCommand.Parameters[13].Value = global::System.DBNull.Value; 8359 } 8360 else { 8361 this.Adapter.UpdateCommand.Parameters[12].Value = ((object)(0)); 8362 this.Adapter.UpdateCommand.Parameters[13].Value = ((string)(Original_JobState)); 8069 8363 } 8070 8364 if ((Original_PermissionOwnerId.HasValue == true)) { 8071 this.Adapter.UpdateCommand.Parameters[1 1].Value = ((object)(0));8072 this.Adapter.UpdateCommand.Parameters[1 2].Value = ((long)(Original_PermissionOwnerId.Value));8073 } 8074 else { 8075 this.Adapter.UpdateCommand.Parameters[1 1].Value = ((object)(1));8076 this.Adapter.UpdateCommand.Parameters[1 2].Value = global::System.DBNull.Value;8365 this.Adapter.UpdateCommand.Parameters[14].Value = ((object)(0)); 8366 this.Adapter.UpdateCommand.Parameters[15].Value = ((long)(Original_PermissionOwnerId.Value)); 8367 } 8368 else { 8369 this.Adapter.UpdateCommand.Parameters[14].Value = ((object)(1)); 8370 this.Adapter.UpdateCommand.Parameters[15].Value = global::System.DBNull.Value; 8077 8371 } 8078 8372 if ((Original_ResourceId.HasValue == true)) { 8079 this.Adapter.UpdateCommand.Parameters[1 3].Value = ((object)(0));8080 this.Adapter.UpdateCommand.Parameters[1 4].Value = ((long)(Original_ResourceId.Value));8081 } 8082 else { 8083 this.Adapter.UpdateCommand.Parameters[1 3].Value = ((object)(1));8084 this.Adapter.UpdateCommand.Parameters[1 4].Value = global::System.DBNull.Value;8373 this.Adapter.UpdateCommand.Parameters[16].Value = ((object)(0)); 8374 this.Adapter.UpdateCommand.Parameters[17].Value = ((long)(Original_ResourceId.Value)); 8375 } 8376 else { 8377 this.Adapter.UpdateCommand.Parameters[16].Value = ((object)(1)); 8378 this.Adapter.UpdateCommand.Parameters[17].Value = global::System.DBNull.Value; 8085 8379 } 8086 8380 if ((Original_Percentage.HasValue == true)) { 8087 this.Adapter.UpdateCommand.Parameters[15].Value = ((object)(0)); 8088 this.Adapter.UpdateCommand.Parameters[16].Value = ((double)(Original_Percentage.Value)); 8089 } 8090 else { 8091 this.Adapter.UpdateCommand.Parameters[15].Value = ((object)(1)); 8092 this.Adapter.UpdateCommand.Parameters[16].Value = global::System.DBNull.Value; 8093 } 8094 this.Adapter.UpdateCommand.Parameters[17].Value = ((long)(JobId)); 8381 this.Adapter.UpdateCommand.Parameters[18].Value = ((object)(0)); 8382 this.Adapter.UpdateCommand.Parameters[19].Value = ((double)(Original_Percentage.Value)); 8383 } 8384 else { 8385 this.Adapter.UpdateCommand.Parameters[18].Value = ((object)(1)); 8386 this.Adapter.UpdateCommand.Parameters[19].Value = global::System.DBNull.Value; 8387 } 8388 if ((Original_DateCreated.HasValue == true)) { 8389 this.Adapter.UpdateCommand.Parameters[20].Value = ((object)(0)); 8390 this.Adapter.UpdateCommand.Parameters[21].Value = ((System.DateTime)(Original_DateCreated.Value)); 8391 } 8392 else { 8393 this.Adapter.UpdateCommand.Parameters[20].Value = ((object)(1)); 8394 this.Adapter.UpdateCommand.Parameters[21].Value = global::System.DBNull.Value; 8395 } 8396 if ((Original_DateCalculated.HasValue == true)) { 8397 this.Adapter.UpdateCommand.Parameters[22].Value = ((object)(0)); 8398 this.Adapter.UpdateCommand.Parameters[23].Value = ((System.DateTime)(Original_DateCalculated.Value)); 8399 } 8400 else { 8401 this.Adapter.UpdateCommand.Parameters[22].Value = ((object)(1)); 8402 this.Adapter.UpdateCommand.Parameters[23].Value = global::System.DBNull.Value; 8403 } 8404 if ((Original_Priority.HasValue == true)) { 8405 this.Adapter.UpdateCommand.Parameters[24].Value = ((object)(0)); 8406 this.Adapter.UpdateCommand.Parameters[25].Value = ((int)(Original_Priority.Value)); 8407 } 8408 else { 8409 this.Adapter.UpdateCommand.Parameters[24].Value = ((object)(1)); 8410 this.Adapter.UpdateCommand.Parameters[25].Value = global::System.DBNull.Value; 8411 } 8412 this.Adapter.UpdateCommand.Parameters[26].Value = ((long)(JobId)); 8095 8413 global::System.Data.ConnectionState previousConnectionState = this.Adapter.UpdateCommand.Connection.State; 8096 8414 if (((this.Adapter.UpdateCommand.Connection.State & global::System.Data.ConnectionState.Open) … … 8112 8430 [global::System.ComponentModel.Design.HelpKeywordAttribute("vs.data.TableAdapter")] 8113 8431 [global::System.ComponentModel.DataObjectMethodAttribute(global::System.ComponentModel.DataObjectMethodType.Update, true)] 8114 public virtual int Update(global::System.Nullable<long> ParentJobId, string JobState, global::System.Nullable<long> PermissionOwnerId, global::System.Nullable<long> ResourceId, byte[] SerializedJob, global::System.Nullable<double> Percentage, long Original_JobId, global::System.Nullable<long> Original_ParentJobId, string Original_JobState, global::System.Nullable<long> Original_PermissionOwnerId, global::System.Nullable<long> Original_ResourceId, global::System.Nullable<double> Original_Percentage) { 8115 return this.Update(ParentJobId, JobState, PermissionOwnerId, ResourceId, SerializedJob, Percentage, Original_JobId, Original_ParentJobId, Original_JobState, Original_PermissionOwnerId, Original_ResourceId, Original_Percentage, Original_JobId); 8432 public virtual int Update( 8433 global::System.Nullable<long> ParentJobId, 8434 string JobState, 8435 global::System.Nullable<long> PermissionOwnerId, 8436 global::System.Nullable<long> ResourceId, 8437 byte[] SerializedJob, 8438 global::System.Nullable<double> Percentage, 8439 global::System.Nullable<global::System.DateTime> DateCreated, 8440 global::System.Nullable<global::System.DateTime> DateCalculated, 8441 global::System.Nullable<int> Priority, 8442 long Original_JobId, 8443 global::System.Nullable<long> Original_ParentJobId, 8444 string Original_JobState, 8445 global::System.Nullable<long> Original_PermissionOwnerId, 8446 global::System.Nullable<long> Original_ResourceId, 8447 global::System.Nullable<double> Original_Percentage, 8448 global::System.Nullable<global::System.DateTime> Original_DateCreated, 8449 global::System.Nullable<global::System.DateTime> Original_DateCalculated, 8450 global::System.Nullable<int> Original_Priority) { 8451 return this.Update(ParentJobId, JobState, PermissionOwnerId, ResourceId, SerializedJob, Percentage, DateCreated, DateCalculated, Priority, Original_JobId, Original_ParentJobId, Original_JobState, Original_PermissionOwnerId, Original_ResourceId, Original_Percentage, Original_DateCreated, Original_DateCalculated, Original_Priority, Original_JobId); 8116 8452 } 8117 8453 } … … 8610 8946 tableMapping.ColumnMappings.Add("ResourceId", "ResourceId"); 8611 8947 tableMapping.ColumnMappings.Add("Message", "Message"); 8948 tableMapping.ColumnMappings.Add("Percentage", "Percentage"); 8949 tableMapping.ColumnMappings.Add("DateFinished", "DateFinished"); 8612 8950 this._adapter.TableMappings.Add(tableMapping); 8613 8951 this._adapter.DeleteCommand = new global::System.Data.SqlClient.SqlCommand(); 8614 8952 this._adapter.DeleteCommand.Connection = this.Connection; 8615 this._adapter.DeleteCommand.CommandText = "DELETE FROM [JobResult] WHERE (([JobResultId] = @Original_JobResultId) AND ((@IsN" + 8616 "ull_JobId = 1 AND [JobId] IS NULL) OR ([JobId] = @Original_JobId)) AND ((@IsNull" + 8617 "_ResourceId = 1 AND [ResourceId] IS NULL) OR ([ResourceId] = @Original_ResourceI" + 8618 "d)))"; 8953 this._adapter.DeleteCommand.CommandText = @"DELETE FROM [JobResult] 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)) AND ((@IsNull_Percentage = 1 AND [Percentage] IS NULL) OR ([Percentage] = @Original_Percentage)) AND ((@IsNull_DateFinished = 1 AND [DateFinished] IS NULL) OR ([DateFinished] = @Original_DateFinished)))"; 8619 8954 this._adapter.DeleteCommand.CommandType = global::System.Data.CommandType.Text; 8620 8955 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, "", "", "")); … … 8623 8958 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, "", "", "")); 8624 8959 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, "", "", "")); 8960 this._adapter.DeleteCommand.Parameters.Add(new global::System.Data.SqlClient.SqlParameter("@IsNull_Percentage", global::System.Data.SqlDbType.Int, 0, global::System.Data.ParameterDirection.Input, 0, 0, "Percentage", global::System.Data.DataRowVersion.Original, true, null, "", "", "")); 8961 this._adapter.DeleteCommand.Parameters.Add(new global::System.Data.SqlClient.SqlParameter("@Original_Percentage", global::System.Data.SqlDbType.Float, 0, global::System.Data.ParameterDirection.Input, 0, 0, "Percentage", global::System.Data.DataRowVersion.Original, false, null, "", "", "")); 8962 this._adapter.DeleteCommand.Parameters.Add(new global::System.Data.SqlClient.SqlParameter("@IsNull_DateFinished", global::System.Data.SqlDbType.Int, 0, global::System.Data.ParameterDirection.Input, 0, 0, "DateFinished", global::System.Data.DataRowVersion.Original, true, null, "", "", "")); 8963 this._adapter.DeleteCommand.Parameters.Add(new global::System.Data.SqlClient.SqlParameter("@Original_DateFinished", global::System.Data.SqlDbType.DateTime, 0, global::System.Data.ParameterDirection.Input, 0, 0, "DateFinished", global::System.Data.DataRowVersion.Original, false, null, "", "", "")); 8625 8964 this._adapter.InsertCommand = new global::System.Data.SqlClient.SqlCommand(); 8626 8965 this._adapter.InsertCommand.Connection = this.Connection; 8627 this._adapter.InsertCommand.CommandText = "INSERT INTO [JobResult] ([JobId], [JobResult], [ResourceId], [Message]) VALUES (@" + 8628 "JobId, @JobResult, @ResourceId, @Message);\r\nSELECT JobResultId, JobId, JobResult" + 8629 ", ResourceId, Message FROM JobResult WHERE (JobResultId = SCOPE_IDENTITY())"; 8966 this._adapter.InsertCommand.CommandText = @"INSERT INTO [JobResult] ([JobId], [JobResult], [ResourceId], [Message], [Percentage], [DateFinished]) VALUES (@JobId, @JobResult, @ResourceId, @Message, @Percentage, @DateFinished); 8967 SELECT JobResultId, JobId, JobResult, ResourceId, Message, Percentage, DateFinished FROM JobResult WHERE (JobResultId = SCOPE_IDENTITY())"; 8630 8968 this._adapter.InsertCommand.CommandType = global::System.Data.CommandType.Text; 8631 8969 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, "", "", "")); … … 8633 8971 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, "", "", "")); 8634 8972 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, "", "", "")); 8973 this._adapter.InsertCommand.Parameters.Add(new global::System.Data.SqlClient.SqlParameter("@Percentage", global::System.Data.SqlDbType.Float, 0, global::System.Data.ParameterDirection.Input, 0, 0, "Percentage", global::System.Data.DataRowVersion.Current, false, null, "", "", "")); 8974 this._adapter.InsertCommand.Parameters.Add(new global::System.Data.SqlClient.SqlParameter("@DateFinished", global::System.Data.SqlDbType.DateTime, 0, global::System.Data.ParameterDirection.Input, 0, 0, "DateFinished", global::System.Data.DataRowVersion.Current, false, null, "", "", "")); 8635 8975 this._adapter.UpdateCommand = new global::System.Data.SqlClient.SqlCommand(); 8636 8976 this._adapter.UpdateCommand.Connection = this.Connection; 8637 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)));8638 SELECT JobResultId, JobId, JobResult, ResourceId, Message FROM JobResult WHERE (JobResultId = @JobResultId)";8977 this._adapter.UpdateCommand.CommandText = @"UPDATE [JobResult] SET [JobId] = @JobId, [JobResult] = @JobResult, [ResourceId] = @ResourceId, [Message] = @Message, [Percentage] = @Percentage, [DateFinished] = @DateFinished 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)) AND ((@IsNull_Percentage = 1 AND [Percentage] IS NULL) OR ([Percentage] = @Original_Percentage)) AND ((@IsNull_DateFinished = 1 AND [DateFinished] IS NULL) OR ([DateFinished] = @Original_DateFinished))); 8978 SELECT JobResultId, JobId, JobResult, ResourceId, Message, Percentage, DateFinished FROM JobResult WHERE (JobResultId = @JobResultId)"; 8639 8979 this._adapter.UpdateCommand.CommandType = global::System.Data.CommandType.Text; 8640 8980 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, "", "", "")); … … 8642 8982 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, "", "", "")); 8643 8983 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, "", "", "")); 8984 this._adapter.UpdateCommand.Parameters.Add(new global::System.Data.SqlClient.SqlParameter("@Percentage", global::System.Data.SqlDbType.Float, 0, global::System.Data.ParameterDirection.Input, 0, 0, "Percentage", global::System.Data.DataRowVersion.Current, false, null, "", "", "")); 8985 this._adapter.UpdateCommand.Parameters.Add(new global::System.Data.SqlClient.SqlParameter("@DateFinished", global::System.Data.SqlDbType.DateTime, 0, global::System.Data.ParameterDirection.Input, 0, 0, "DateFinished", global::System.Data.DataRowVersion.Current, false, null, "", "", "")); 8644 8986 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, "", "", "")); 8645 8987 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, "", "", "")); … … 8647 8989 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, "", "", "")); 8648 8990 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, "", "", "")); 8991 this._adapter.UpdateCommand.Parameters.Add(new global::System.Data.SqlClient.SqlParameter("@IsNull_Percentage", global::System.Data.SqlDbType.Int, 0, global::System.Data.ParameterDirection.Input, 0, 0, "Percentage", global::System.Data.DataRowVersion.Original, true, null, "", "", "")); 8992 this._adapter.UpdateCommand.Parameters.Add(new global::System.Data.SqlClient.SqlParameter("@Original_Percentage", global::System.Data.SqlDbType.Float, 0, global::System.Data.ParameterDirection.Input, 0, 0, "Percentage", global::System.Data.DataRowVersion.Original, false, null, "", "", "")); 8993 this._adapter.UpdateCommand.Parameters.Add(new global::System.Data.SqlClient.SqlParameter("@IsNull_DateFinished", global::System.Data.SqlDbType.Int, 0, global::System.Data.ParameterDirection.Input, 0, 0, "DateFinished", global::System.Data.DataRowVersion.Original, true, null, "", "", "")); 8994 this._adapter.UpdateCommand.Parameters.Add(new global::System.Data.SqlClient.SqlParameter("@Original_DateFinished", global::System.Data.SqlDbType.DateTime, 0, global::System.Data.ParameterDirection.Input, 0, 0, "DateFinished", global::System.Data.DataRowVersion.Original, false, null, "", "", "")); 8649 8995 this._adapter.UpdateCommand.Parameters.Add(new global::System.Data.SqlClient.SqlParameter("@JobResultId", global::System.Data.SqlDbType.BigInt, 8, global::System.Data.ParameterDirection.Input, 0, 0, "JobResultId", global::System.Data.DataRowVersion.Current, false, null, "", "", "")); 8650 8996 } … … 8661 9007 this._commandCollection[0] = new global::System.Data.SqlClient.SqlCommand(); 8662 9008 this._commandCollection[0].Connection = this.Connection; 8663 this._commandCollection[0].CommandText = "SELECT JobResultId, JobId, JobResult, ResourceId, Message \r\nFROM JobRe" +8664 " sult";9009 this._commandCollection[0].CommandText = "SELECT JobResultId, JobId, JobResult, ResourceId, Message, Percentage, DateFi" + 9010 "nished\r\nFROM JobResult"; 8665 9011 this._commandCollection[0].CommandType = global::System.Data.CommandType.Text; 8666 9012 this._commandCollection[1] = new global::System.Data.SqlClient.SqlCommand(); 8667 9013 this._commandCollection[1].Connection = this.Connection; 8668 this._commandCollection[1].CommandText = "SELECT JobId, JobResult, JobResultId, Message, ResourceId FROM JobResult WHERE (J" +8669 " obResultId = @Id)";9014 this._commandCollection[1].CommandText = "SELECT JobId, JobResult, JobResultId, Message, ResourceId, Percentage, DateFi" + 9015 "nished\r\nFROM JobResult\r\nWHERE (JobResultId = @Id)"; 8670 9016 this._commandCollection[1].CommandType = global::System.Data.CommandType.Text; 8671 9017 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, "", "", "")); 8672 9018 this._commandCollection[2] = new global::System.Data.SqlClient.SqlCommand(); 8673 9019 this._commandCollection[2].Connection = this.Connection; 8674 this._commandCollection[2].CommandText = "SELECT JobId, JobResult, JobResultId, Message, ResourceId FROM JobResult WHERE (J" +8675 " obId = @JobId)";9020 this._commandCollection[2].CommandText = "SELECT JobId, JobResult, JobResultId, Message, ResourceId, Percentage, DateFi" + 9021 "nished\r\nFROM JobResult\r\nWHERE (JobId = @JobId)"; 8676 9022 this._commandCollection[2].CommandType = global::System.Data.CommandType.Text; 8677 9023 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, "", "", "")); … … 8786 9132 [global::System.ComponentModel.Design.HelpKeywordAttribute("vs.data.TableAdapter")] 8787 9133 [global::System.ComponentModel.DataObjectMethodAttribute(global::System.ComponentModel.DataObjectMethodType.Delete, true)] 8788 public virtual int Delete(long Original_JobResultId, global::System.Nullable<long> Original_JobId, global::System.Nullable<long> Original_ResourceId ) {9134 public virtual int Delete(long Original_JobResultId, global::System.Nullable<long> Original_JobId, global::System.Nullable<long> Original_ResourceId, global::System.Nullable<double> Original_Percentage, global::System.Nullable<global::System.DateTime> Original_DateFinished) { 8789 9135 this.Adapter.DeleteCommand.Parameters[0].Value = ((long)(Original_JobResultId)); 8790 9136 if ((Original_JobId.HasValue == true)) { … … 8804 9150 this.Adapter.DeleteCommand.Parameters[4].Value = global::System.DBNull.Value; 8805 9151 } 9152 if ((Original_Percentage.HasValue == true)) { 9153 this.Adapter.DeleteCommand.Parameters[5].Value = ((object)(0)); 9154 this.Adapter.DeleteCommand.Parameters[6].Value = ((double)(Original_Percentage.Value)); 9155 } 9156 else { 9157 this.Adapter.DeleteCommand.Parameters[5].Value = ((object)(1)); 9158 this.Adapter.DeleteCommand.Parameters[6].Value = global::System.DBNull.Value; 9159 } 9160 if ((Original_DateFinished.HasValue == true)) { 9161 this.Adapter.DeleteCommand.Parameters[7].Value = ((object)(0)); 9162 this.Adapter.DeleteCommand.Parameters[8].Value = ((System.DateTime)(Original_DateFinished.Value)); 9163 } 9164 else { 9165 this.Adapter.DeleteCommand.Parameters[7].Value = ((object)(1)); 9166 this.Adapter.DeleteCommand.Parameters[8].Value = global::System.DBNull.Value; 9167 } 8806 9168 global::System.Data.ConnectionState previousConnectionState = this.Adapter.DeleteCommand.Connection.State; 8807 9169 if (((this.Adapter.DeleteCommand.Connection.State & global::System.Data.ConnectionState.Open) … … 8823 9185 [global::System.ComponentModel.Design.HelpKeywordAttribute("vs.data.TableAdapter")] 8824 9186 [global::System.ComponentModel.DataObjectMethodAttribute(global::System.ComponentModel.DataObjectMethodType.Insert, true)] 8825 public virtual int Insert(global::System.Nullable<long> JobId, byte[] JobResult, global::System.Nullable<long> ResourceId, string Message ) {9187 public virtual int Insert(global::System.Nullable<long> JobId, byte[] JobResult, global::System.Nullable<long> ResourceId, string Message, global::System.Nullable<double> Percentage, global::System.Nullable<global::System.DateTime> DateFinished) { 8826 9188 if ((JobId.HasValue == true)) { 8827 9189 this.Adapter.InsertCommand.Parameters[0].Value = ((long)(JobId.Value)); … … 8847 9209 else { 8848 9210 this.Adapter.InsertCommand.Parameters[3].Value = ((string)(Message)); 9211 } 9212 if ((Percentage.HasValue == true)) { 9213 this.Adapter.InsertCommand.Parameters[4].Value = ((double)(Percentage.Value)); 9214 } 9215 else { 9216 this.Adapter.InsertCommand.Parameters[4].Value = global::System.DBNull.Value; 9217 } 9218 if ((DateFinished.HasValue == true)) { 9219 this.Adapter.InsertCommand.Parameters[5].Value = ((System.DateTime)(DateFinished.Value)); 9220 } 9221 else { 9222 this.Adapter.InsertCommand.Parameters[5].Value = global::System.DBNull.Value; 8849 9223 } 8850 9224 global::System.Data.ConnectionState previousConnectionState = this.Adapter.InsertCommand.Connection.State; … … 8867 9241 [global::System.ComponentModel.Design.HelpKeywordAttribute("vs.data.TableAdapter")] 8868 9242 [global::System.ComponentModel.DataObjectMethodAttribute(global::System.ComponentModel.DataObjectMethodType.Update, true)] 8869 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) {9243 public virtual int Update(global::System.Nullable<long> JobId, byte[] JobResult, global::System.Nullable<long> ResourceId, string Message, global::System.Nullable<double> Percentage, global::System.Nullable<global::System.DateTime> DateFinished, long Original_JobResultId, global::System.Nullable<long> Original_JobId, global::System.Nullable<long> Original_ResourceId, global::System.Nullable<double> Original_Percentage, global::System.Nullable<global::System.DateTime> Original_DateFinished, long JobResultId) { 8870 9244 if ((JobId.HasValue == true)) { 8871 9245 this.Adapter.UpdateCommand.Parameters[0].Value = ((long)(JobId.Value)); … … 8892 9266 this.Adapter.UpdateCommand.Parameters[3].Value = ((string)(Message)); 8893 9267 } 8894 this.Adapter.UpdateCommand.Parameters[4].Value = ((long)(Original_JobResultId)); 9268 if ((Percentage.HasValue == true)) { 9269 this.Adapter.UpdateCommand.Parameters[4].Value = ((double)(Percentage.Value)); 9270 } 9271 else { 9272 this.Adapter.UpdateCommand.Parameters[4].Value = global::System.DBNull.Value; 9273 } 9274 if ((DateFinished.HasValue == true)) { 9275 this.Adapter.UpdateCommand.Parameters[5].Value = ((System.DateTime)(DateFinished.Value)); 9276 } 9277 else { 9278 this.Adapter.UpdateCommand.Parameters[5].Value = global::System.DBNull.Value; 9279 } 9280 this.Adapter.UpdateCommand.Parameters[6].Value = ((long)(Original_JobResultId)); 8895 9281 if ((Original_JobId.HasValue == true)) { 8896 this.Adapter.UpdateCommand.Parameters[5].Value = ((object)(0));8897 this.Adapter.UpdateCommand.Parameters[6].Value = ((long)(Original_JobId.Value));8898 }8899 else {8900 this.Adapter.UpdateCommand.Parameters[5].Value = ((object)(1));8901 this.Adapter.UpdateCommand.Parameters[6].Value = global::System.DBNull.Value;8902 }8903 if ((Original_ResourceId.HasValue == true)) {8904 9282 this.Adapter.UpdateCommand.Parameters[7].Value = ((object)(0)); 8905 this.Adapter.UpdateCommand.Parameters[8].Value = ((long)(Original_ ResourceId.Value));9283 this.Adapter.UpdateCommand.Parameters[8].Value = ((long)(Original_JobId.Value)); 8906 9284 } 8907 9285 else { … … 8909 9287 this.Adapter.UpdateCommand.Parameters[8].Value = global::System.DBNull.Value; 8910 9288 } 8911 this.Adapter.UpdateCommand.Parameters[9].Value = ((long)(JobResultId)); 9289 if ((Original_ResourceId.HasValue == true)) { 9290 this.Adapter.UpdateCommand.Parameters[9].Value = ((object)(0)); 9291 this.Adapter.UpdateCommand.Parameters[10].Value = ((long)(Original_ResourceId.Value)); 9292 } 9293 else { 9294 this.Adapter.UpdateCommand.Parameters[9].Value = ((object)(1)); 9295 this.Adapter.UpdateCommand.Parameters[10].Value = global::System.DBNull.Value; 9296 } 9297 if ((Original_Percentage.HasValue == true)) { 9298 this.Adapter.UpdateCommand.Parameters[11].Value = ((object)(0)); 9299 this.Adapter.UpdateCommand.Parameters[12].Value = ((double)(Original_Percentage.Value)); 9300 } 9301 else { 9302 this.Adapter.UpdateCommand.Parameters[11].Value = ((object)(1)); 9303 this.Adapter.UpdateCommand.Parameters[12].Value = global::System.DBNull.Value; 9304 } 9305 if ((Original_DateFinished.HasValue == true)) { 9306 this.Adapter.UpdateCommand.Parameters[13].Value = ((object)(0)); 9307 this.Adapter.UpdateCommand.Parameters[14].Value = ((System.DateTime)(Original_DateFinished.Value)); 9308 } 9309 else { 9310 this.Adapter.UpdateCommand.Parameters[13].Value = ((object)(1)); 9311 this.Adapter.UpdateCommand.Parameters[14].Value = global::System.DBNull.Value; 9312 } 9313 this.Adapter.UpdateCommand.Parameters[15].Value = ((long)(JobResultId)); 8912 9314 global::System.Data.ConnectionState previousConnectionState = this.Adapter.UpdateCommand.Connection.State; 8913 9315 if (((this.Adapter.UpdateCommand.Connection.State & global::System.Data.ConnectionState.Open) … … 8929 9331 [global::System.ComponentModel.Design.HelpKeywordAttribute("vs.data.TableAdapter")] 8930 9332 [global::System.ComponentModel.DataObjectMethodAttribute(global::System.ComponentModel.DataObjectMethodType.Update, true)] 8931 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) {8932 return this.Update(JobId, JobResult, ResourceId, Message, Original_JobResultId, Original_JobId, Original_ResourceId, Original_JobResultId);9333 public virtual int Update(global::System.Nullable<long> JobId, byte[] JobResult, global::System.Nullable<long> ResourceId, string Message, global::System.Nullable<double> Percentage, global::System.Nullable<global::System.DateTime> DateFinished, long Original_JobResultId, global::System.Nullable<long> Original_JobId, global::System.Nullable<long> Original_ResourceId, global::System.Nullable<double> Original_Percentage, global::System.Nullable<global::System.DateTime> Original_DateFinished) { 9334 return this.Update(JobId, JobResult, ResourceId, Message, Percentage, DateFinished, Original_JobResultId, Original_JobId, Original_ResourceId, Original_Percentage, Original_DateFinished, Original_JobResultId); 8933 9335 } 8934 9336 }
Note: See TracChangeset
for help on using the changeset viewer.
