Me._adapter.UpdateCommand = New System.Data.SqlClient.SqlCommand
Me._adapter.UpdateCommand.Connection = Me.Connection
Me._adapter.UpdateCommand.CommandText = "UPDATE [Order] SET [OrderDate] = @OrderDate, [AccountRef] = @AccountRef, [Custome"& _
"r] = @Customer, [Address_1] = @Address_1, [Address_2] = @Address_2, [Address_3] "& _
"= @Address_3, [Address_4] = @Address_4, [Address_5] = @Address_5, [ContactName] "& _
"= @ContactName, [ContactTel] = @ContactTel, [Delivery] = @Delivery, [D_Customer]"& _
" = @D_Customer, [D_Address_1] = @D_Address_1, [D_Address_2] = @D_Address_2, [D_A"& _
"ddress_3] = @D_Address_3, [D_Address_4] = @D_Address_4, [D_Address_5] = @D_Addre"& _
"ss_5, [CustomerOrderNumber] = @CustomerOrderNumber, [Details] = @Details, [Suppl"& _
"ierInvoiceReceived] = @SupplierInvoiceReceived, [InvoiceNumber] = @InvoiceNumber"& _
", [InvoicePaid] = @InvoicePaid, [DeliveryNoteNumber] = @DeliveryNoteNumber, [Del"& _
"iveryDate] = @DeliveryDate, [Salesman] = @Salesman, [Lead] = @Lead, [LeadPaidDat"& _
"e] = @LeadPaidDate, [TotalCost] = @TotalCost, [TotalSell] = @TotalSell, [TotalPr"& _
"ofit] = @TotalProfit, [TotalTax] = @TotalTax, [TaxCode] = @TaxCode, [CreatedDate"& _
"] = @CreatedDate, [SAGECreatedDate] = @SAGECreatedDate, [UpdatedDate] = @Updated"& _
"Date, [SAGEUpdatedDate] = @SAGEUpdatedDate, [Equipment] = @Equipment, [DespatchS"& _
"tatusCode] = @DespatchStatusCode, [DespatchStatus] = @DespatchStatus, [Version] "& _
"= @Version WHERE (([PCNumber] = @Original_PCNumber) AND ((@IsNull_OrderDate = 1 "& _
"AND [OrderDate] IS NULL) OR ([OrderDate] = @Original_OrderDate)) AND ([AccountRe"& _
"f] = @Original_AccountRef) AND ((@IsNull_Customer = 1 AND [Customer] IS NULL) OR"& _
" ([Customer] = @Original_Customer)) AND ((@IsNull_Address_1 = 1 AND [Address_1] "& _
"IS NULL) OR ([Address_1] = @Original_Address_1)) AND ((@IsNull_Address_2 = 1 AND"& _
" [Address_2] IS NULL) OR ([Address_2] = @Original_Address_2)) AND ((@IsNull_Addr"& _
"ess_3 = 1 AND [Address_3] IS NULL) OR ([Address_3] = @Original_Address_3)) AND ("& _
"(@IsNull_Address_4 = 1 AND [Address_4] IS NULL) OR ([Address_4] = @Original_Addr"& _
"ess_4)) AND ((@IsNull_Address_5 = 1 AND [Address_5] IS NULL) OR ([Address_5] = @"& _
"Original_Address_5)) AND ((@IsNull_ContactName = 1 AND [ContactName] IS NULL) OR"& _
" ([ContactName] = @Original_ContactName)) AND ((@IsNull_ContactTel = 1 AND [Cont"& _
"actTel] IS NULL) OR ([ContactTel] = @Original_ContactTel)) AND ([Delivery] = @Or"& _
"iginal_Delivery) AND ((@IsNull_D_Customer = 1 AND [D_Customer] IS NULL) OR ([D_C"& _
"ustomer] = @Original_D_Customer)) AND ((@IsNull_D_Address_1 = 1 AND [D_Address_1"& _
"] IS NULL) OR ([D_Address_1] = @Original_D_Address_1)) AND ((@IsNull_D_Address_2"& _
" = 1 AND [D_Address_2] IS NULL) OR ([D_Address_2] = @Original_D_Address_2)) AND "& _
"((@IsNull_D_Address_3 = 1 AND [D_Address_3] IS NULL) OR ([D_Address_3] = @Origin"& _
"al_D_Address_3)) AND ((@IsNull_D_Address_4 = 1 AND [D_Address_4] IS NULL) OR ([D"& _
"_Address_4] = @Original_D_Address_4)) AND ((@IsNull_D_Address_5 = 1 AND [D_Addre"& _
"ss_5] IS NULL) OR ([D_Address_5] = @Original_D_Address_5)) AND ((@IsNull_Custome"& _
"rOrderNumber = 1 AND [CustomerOrderNumber] IS NULL) OR ([CustomerOrderNumber] = "& _
"@Original_CustomerOrderNumber)) AND ((@IsNull_Details = 1 AND [Details] IS NULL)"& _
" OR ([Details] = @Original_Details)) AND ((@IsNull_SupplierInvoiceReceived = 1 A"& _
"ND [SupplierInvoiceReceived] IS NULL) OR ([SupplierInvoiceReceived] = @Original_"& _
"SupplierInvoiceReceived)) AND ((@IsNull_InvoiceNumber = 1 AND [InvoiceNumber] IS"& _
" NULL) OR ([InvoiceNumber] = @Original_InvoiceNumber)) AND ((@IsNull_InvoicePaid"& _
" = 1 AND [InvoicePaid] IS NULL) OR ([InvoicePaid] = @Original_InvoicePaid)) AND "& _
"((@IsNull_DeliveryNoteNumber = 1 AND [DeliveryNoteNumber] IS NULL) OR ([Delivery"& _
"NoteNumber] = @Original_DeliveryNoteNumber)) AND ((@IsNull_DeliveryDate = 1 AND "& _
"[DeliveryDate] IS NULL) OR ([DeliveryDate] = @Original_DeliveryDate)) AND ((@IsN"& _
"ull_Salesman = 1 AND [Salesman] IS NULL) OR ([Salesman] = @Original_Salesman)) A"& _
"ND ((@IsNull_Lead = 1 AND [Lead] IS NULL) OR ([Lead] = @Original_Lead)) AND ((@I"& _
"sNull_LeadPaidDate = 1 AND [LeadPaidDate] IS NULL) OR ([LeadPaidDate] = @Origina"& _
"l_LeadPaidDate)) AND ((@IsNull_TotalCost = 1 AND [TotalCost] IS NULL) OR ([Total"& _
"Cost] = @Original_TotalCost)) AND ((@IsNull_TotalSell = 1 AND [TotalSell] IS NUL"& _
"L) OR ([TotalSell] = @Original_TotalSell)) AND ((@IsNull_TotalProfit = 1 AND [To"& _
"talProfit] IS NULL) OR ([TotalProfit] = @Original_TotalProfit)) AND ((@IsNull_To"& _
"talTax = 1 AND [TotalTax] IS NULL) OR ([TotalTax] = @Original_TotalTax)) AND ((@"& _
"IsNull_TaxCode = 1 AND [TaxCode] IS NULL) OR ([TaxCode] = @Original_TaxCode)) AN"& _
"D ((@IsNull_CreatedDate = 1 AND [CreatedDate] IS NULL) OR ([CreatedDate] = @Orig"& _
"inal_CreatedDate)) AND ((@IsNull_SAGECreatedDate = 1 AND [SAGECreatedDate] IS NU"& _
"LL) OR ([SAGECreatedDate] = @Original_SAGECreatedDate)) AND ((@IsNull_UpdatedDat"& _
"e = 1 AND [UpdatedDate] IS NULL) OR ([UpdatedDate] = @Original_UpdatedDate)) AND"& _
" ((@IsNull_SAGEUpdatedDate = 1 AND [SAGEUpdatedDate] IS NULL) OR ([SAGEUpdatedDa"& _
"te] = @Original_SAGEUpdatedDate)) AND ([Equipment] = @Original_Equipment) AND (["& _
"DespatchStatusCode] = @Original_DespatchStatusCode) AND ((@IsNull_DespatchStatus"& _
" = 1 AND [DespatchStatus] IS NULL) OR ([DespatchStatus] = @Original_DespatchStat"& _
"us)) AND ([Version] = @Original_Version));"&Global.Microsoft.VisualBasic.ChrW(13)&Global.Microsoft.VisualBasic.ChrW(10)&"SELECT PCNumber, OrderDate, AccountR"& _
"ef, Customer, Address_1, Address_2, Address_3, Address_4, Address_5, ContactName"& _
", ContactTel, Delivery, D_Customer, D_Address_1, D_Address_2, D_Address_3, D_Add"& _
"ress_4, D_Address_5, CustomerOrderNumber, Details, SupplierInvoiceReceived, Invo"& _
"iceNumber, InvoicePaid, DeliveryNoteNumber, DeliveryDate, Salesman, Lead, LeadPa"& _
"idDate, TotalCost, TotalSell, TotalProfit, TotalTax, TaxCode, CreatedDate, SAGEC"& _
"reatedDate, UpdatedDate, SAGEUpdatedDate, Equipment, DespatchStatusCode, Despatc"& _
"hStatus, Version FROM [Order] WHERE (PCNumber = @PCNumber)"
Me._adapter.UpdateCommand.CommandType = System.Data.CommandType.Text
Me._adapter.UpdateCommand.Parameters.Add(New System.Data.SqlClient.SqlParameter("@OrderDate", System.Data.SqlDbType.DateTime, 0, System.Data.ParameterDirection.Input, 0, 0, "OrderDate", System.Data.DataRowVersion.Current, false, Nothing, "", "", ""))
Me._adapter.UpdateCommand.Parameters.Add(New System.Data.SqlClient.SqlParameter("@AccountRef", System.Data.SqlDbType.NVarChar, 0, System.Data.ParameterDirection.Input, 0, 0, "AccountRef", System.Data.DataRowVersion.Current, false, Nothing, "", "", ""))
Me._adapter.UpdateCommand.Parameters.Add(New System.Data.SqlClient.SqlParameter("@Customer", System.Data.SqlDbType.NVarChar, 0, System.Data.ParameterDirection.Input, 0, 0, "Customer", System.Data.DataRowVersion.Current, false, Nothing, "", "", ""))
Me._adapter.UpdateCommand.Parameters.Add(New System.Data.SqlClient.SqlParameter("@Address_1", System.Data.SqlDbType.NVarChar, 0, System.Data.ParameterDirection.Input, 0, 0, "Address_1", System.Data.DataRowVersion.Current, false, Nothing, "", "", ""))
Me._adapter.UpdateCommand.Parameters.Add(New System.Data.SqlClient.SqlParameter("@Address_2", System.Data.SqlDbType.NVarChar, 0, System.Data.ParameterDirection.Input, 0, 0, "Address_2", System.Data.DataRowVersion.Current, false, Nothing, "", "", ""))
Me._adapter.UpdateCommand.Parameters.Add(New System.Data.SqlClient.SqlParameter("@Address_3", System.Data.SqlDbType.NVarChar, 0, System.Data.ParameterDirection.Input, 0, 0, "Address_3", System.Data.DataRowVersion.Current, false, Nothing, "", "", ""))
Me._adapter.UpdateCommand.Parameters.Add(New System.Data.SqlClient.SqlParameter("@Address_4", System.Data.SqlDbType.NVarChar, 0, System.Data.ParameterDirection.Input, 0, 0, "Address_4", System.Data.DataRowVersion.Current, false, Nothing, "", "", ""))
Me._adapter.UpdateCommand.Parameters.Add(New System.Data.SqlClient.SqlParameter("@Address_5", System.Data.SqlDbType.NVarChar, 0, System.Data.ParameterDirection.Input, 0, 0, "Address_5", System.Data.DataRowVersion.Current, false, Nothing, "", "", ""))
Me._adapter.UpdateCommand.Parameters.Add(New System.Data.SqlClient.SqlParameter("@ContactName", System.Data.SqlDbType.NVarChar, 0, System.Data.ParameterDirection.Input, 0, 0, "ContactName", System.Data.DataRowVersion.Current, false, Nothing, "", "", ""))
Me._adapter.UpdateCommand.Parameters.Add(New System.Data.SqlClient.SqlParameter("@ContactTel", System.Data.SqlDbType.NVarChar, 0, System.Data.ParameterDirection.Input, 0, 0, "ContactTel", System.Data.DataRowVersion.Current, false, Nothing, "", "", ""))
Me._adapter.UpdateCommand.Parameters.Add(New System.Data.SqlClient.SqlParameter("@Delivery", System.Data.SqlDbType.Bit, 0, System.Data.ParameterDirection.Input, 0, 0, "Delivery", System.Data.DataRowVersion.Current, false, Nothing, "", "", ""))
Me._adapter.UpdateCommand.Parameters.Add(New System.Data.SqlClient.SqlParameter("@D_Customer", System.Data.SqlDbType.NVarChar, 0, System.Data.ParameterDirection.Input, 0, 0, "D_Customer", System.Data.DataRowVersion.Current, false, Nothing, "", "", ""))
Me._adapter.UpdateCommand.Parameters.Add(New System.Data.SqlClient.SqlParameter("@D_Address_1", System.Data.SqlDbType.NVarChar, 0, System.Data.ParameterDirection.Input, 0, 0, "D_Address_1", System.Data.DataRowVersion.Current, false, Nothing, "", "", ""))
Me._adapter.UpdateCommand.Parameters.Add(New System.Data.SqlClient.SqlParameter("@D_Address_2", System.Data.SqlDbType.NVarChar, 0, System.Data.ParameterDirection.Input, 0, 0, "D_Address_2", System.Data.DataRowVersion.Current, false, Nothing, "", "", ""))
Me._adapter.UpdateCommand.Parameters.Add(New System.Data.SqlClient.SqlParameter("@D_Address_3", System.Data.SqlDbType.NVarChar, 0, System.Data.ParameterDirection.Input, 0, 0, "D_Address_3", System.Data.DataRowVersion.Current, false, Nothing, "", "", ""))
Me._adapter.UpdateCommand.Parameters.Add(New System.Data.SqlClient.SqlParameter("@D_Address_4", System.Data.SqlDbType.NVarChar, 0, System.Data.ParameterDirection.Input, 0, 0, "D_Address_4", System.Data.DataRowVersion.Current, false, Nothing, "", "", ""))
Me._adapter.UpdateCommand.Parameters.Add(New System.Data.SqlClient.SqlParameter("@D_Address_5", System.Data.SqlDbType.NVarChar, 0, System.Data.ParameterDirection.Input, 0, 0, "D_Address_5", System.Data.DataRowVersion.Current, false, Nothing, "", "", ""))
Me._adapter.UpdateCommand.Parameters.Add(New System.Data.SqlClient.SqlParameter("@CustomerOrderNumber", System.Data.SqlDbType.NVarChar, 0, System.Data.ParameterDirection.Input, 0, 0, "CustomerOrderNumber", System.Data.DataRowVersion.Current, false, Nothing, "", "", ""))
Me._adapter.UpdateCommand.Parameters.Add(New System.Data.SqlClient.SqlParameter("@Details", System.Data.SqlDbType.NVarChar, 0, System.Data.ParameterDirection.Input, 0, 0, "Details", System.Data.DataRowVersion.Current, false, Nothing, "", "", ""))
Me._adapter.UpdateCommand.Parameters.Add(New System.Data.SqlClient.SqlParameter("@SupplierInvoiceReceived", System.Data.SqlDbType.NVarChar, 0, System.Data.ParameterDirection.Input, 0, 0, "SupplierInvoiceReceived", System.Data.DataRowVersion.Current, false, Nothing, "", "", ""))
Me._adapter.UpdateCommand.Parameters.Add(New System.Data.SqlClient.SqlParameter("@InvoiceNumber", System.Data.SqlDbType.NVarChar, 0, System.Data.ParameterDirection.Input, 0, 0, "InvoiceNumber", System.Data.DataRowVersion.Current, false, Nothing, "", "", ""))
Me._adapter.UpdateCommand.Parameters.Add(New System.Data.SqlClient.SqlParameter("@InvoicePaid", System.Data.SqlDbType.DateTime, 0, System.Data.ParameterDirection.Input, 0, 0, "InvoicePaid", System.Data.DataRowVersion.Current, false, Nothing, "", "", ""))
Me._adapter.UpdateCommand.Parameters.Add(New System.Data.SqlClient.SqlParameter("@DeliveryNoteNumber", System.Data.SqlDbType.NVarChar, 0, System.Data.ParameterDirection.Input, 0, 0, "DeliveryNoteNumber", System.Data.DataRowVersion.Current, false, Nothing, "", "", ""))
Me._adapter.UpdateCommand.Parameters.Add(New System.Data.SqlClient.SqlParameter("@DeliveryDate", System.Data.SqlDbType.DateTime, 0, System.Data.ParameterDirection.Input, 0, 0, "DeliveryDate", System.Data.DataRowVersion.Current, false, Nothing, "", "", ""))
Me._adapter.UpdateCommand.Parameters.Add(New System.Data.SqlClient.SqlParameter("@Salesman", System.Data.SqlDbType.Int, 0, System.Data.ParameterDirection.Input, 0, 0, "Salesman", System.Data.DataRowVersion.Current, false, Nothing, "", "", ""))
Me._adapter.UpdateCommand.Parameters.Add(New System.Data.SqlClient.SqlParameter("@Lead", System.Data.SqlDbType.Int, 0, System.Data.ParameterDirection.Input, 0, 0, "Lead", System.Data.DataRowVersion.Current, false, Nothing, "", "", ""))
Me._adapter.UpdateCommand.Parameters.Add(New System.Data.SqlClient.SqlParameter("@LeadPaidDate", System.Data.SqlDbType.NVarChar, 0, System.Data.ParameterDirection.Input, 0, 0, "LeadPaidDate", System.Data.DataRowVersion.Current, false, Nothing, "", "", ""))
Me._adapter.UpdateCommand.Parameters.Add(New System.Data.SqlClient.SqlParameter("@TotalCost", System.Data.SqlDbType.Money, 0, System.Data.ParameterDirection.Input, 0, 0, "TotalCost", System.Data.DataRowVersion.Current, false, Nothing, "", "", ""))
Me._adapter.UpdateCommand.Parameters.Add(New System.Data.SqlClient.SqlParameter("@TotalSell", System.Data.SqlDbType.Money, 0, System.Data.ParameterDirection.Input, 0, 0, "TotalSell", System.Data.DataRowVersion.Current, false, Nothing, "", "", ""))
Me._adapter.UpdateCommand.Parameters.Add(New System.Data.SqlClient.SqlParameter("@TotalProfit", System.Data.SqlDbType.Money, 0, System.Data.ParameterDirection.Input, 0, 0, "TotalProfit", System.Data.DataRowVersion.Current, false, Nothing, "", "", ""))
Me._adapter.UpdateCommand.Parameters.Add(New System.Data.SqlClient.SqlParameter("@TotalTax", System.Data.SqlDbType.Money, 0, System.Data.ParameterDirection.Input, 0, 0, "TotalTax", System.Data.DataRowVersion.Current, false, Nothing, "", "", ""))
Me._adapter.UpdateCommand.Parameters.Add(New System.Data.SqlClient.SqlParameter("@TaxCode", System.Data.SqlDbType.NVarChar, 0, System.Data.ParameterDirection.Input, 0, 0, "TaxCode", System.Data.DataRowVersion.Current, false, Nothing, "", "", ""))
Me._adapter.UpdateCommand.Parameters.Add(New System.Data.SqlClient.SqlParameter("@CreatedDate", System.Data.SqlDbType.DateTime, 0, System.Data.ParameterDirection.Input, 0, 0, "CreatedDate", System.Data.DataRowVersion.Current, false, Nothing, "", "", ""))
Me._adapter.UpdateCommand.Parameters.Add(New System.Data.SqlClient.SqlParameter("@SAGECreatedDate", System.Data.SqlDbType.DateTime, 0, System.Data.ParameterDirection.Input, 0, 0, "SAGECreatedDate", System.Data.DataRowVersion.Current, false, Nothing, "", "", ""))
Me._adapter.UpdateCommand.Parameters.Add(New System.Data.SqlClient.SqlParameter("@UpdatedDate", System.Data.SqlDbType.DateTime, 0, System.Data.ParameterDirection.Input, 0, 0, "UpdatedDate", System.Data.DataRowVersion.Current, false, Nothing, "", "", ""))
Me._adapter.UpdateCommand.Parameters.Add(New System.Data.SqlClient.SqlParameter("@SAGEUpdatedDate", System.Data.SqlDbType.DateTime, 0, System.Data.ParameterDirection.Input, 0, 0, "SAGEUpdatedDate", System.Data.DataRowVersion.Current, false, Nothing, "", "", ""))
Me._adapter.UpdateCommand.Parameters.Add(New System.Data.SqlClient.SqlParameter("@Equipment", System.Data.SqlDbType.Bit, 0, System.Data.ParameterDirection.Input, 0, 0, "Equipment", System.Data.DataRowVersion.Current, false, Nothing, "", "", ""))
Me._adapter.UpdateCommand.Parameters.Add(New System.Data.SqlClient.SqlParameter("@DespatchStatusCode", System.Data.SqlDbType.Int, 0, System.Data.ParameterDirection.Input, 0, 0, "DespatchStatusCode", System.Data.DataRowVersion.Current, false, Nothing, "", "", ""))
Me._adapter.UpdateCommand.Parameters.Add(New System.Data.SqlClient.SqlParameter("@DespatchStatus", System.Data.SqlDbType.NVarChar, 0, System.Data.ParameterDirection.Input, 0, 0, "DespatchStatus", System.Data.DataRowVersion.Current, false, Nothing, "", "", ""))
Me._adapter.UpdateCommand.Parameters.Add(New System.Data.SqlClient.SqlParameter("@Version", System.Data.SqlDbType.Int, 0, System.Data.ParameterDirection.Input, 0, 0, "Version", System.Data.DataRowVersion.Current, false, Nothing, "", "", ""))
Me._adapter.UpdateCommand.Parameters.Add(New System.Data.SqlClient.SqlParameter("@Original_PCNumber", System.Data.SqlDbType.Int, 0, System.Data.ParameterDirection.Input, 0, 0, "PCNumber", System.Data.DataRowVersion.Original, false, Nothing, "", "", ""))
Me._adapter.UpdateCommand.Parameters.Add(New System.Data.SqlClient.SqlParameter("@IsNull_OrderDate", System.Data.SqlDbType.Int, 0, System.Data.ParameterDirection.Input, 0, 0, "OrderDate", System.Data.DataRowVersion.Original, true, Nothing, "", "", ""))
Me._adapter.UpdateCommand.Parameters.Add(New System.Data.SqlClient.SqlParameter("@Original_OrderDate", System.Data.SqlDbType.DateTime, 0, System.Data.ParameterDirection.Input, 0, 0, "OrderDate", System.Data.DataRowVersion.Original, false, Nothing, "", "", ""))
Me._adapter.UpdateCommand.Parameters.Add(New System.Data.SqlClient.SqlParameter("@Original_AccountRef", System.Data.SqlDbType.NVarChar, 0, System.Data.ParameterDirection.Input, 0, 0, "AccountRef", System.Data.DataRowVersion.Original, false, Nothing, "", "", ""))
Me._adapter.UpdateCommand.Parameters.Add(New System.Data.SqlClient.SqlParameter("@IsNull_Customer", System.Data.SqlDbType.Int, 0, System.Data.ParameterDirection.Input, 0, 0, "Customer", System.Data.DataRowVersion.Original, true, Nothing, "", "", ""))
Me._adapter.UpdateCommand.Parameters.Add(New System.Data.SqlClient.SqlParameter("@Original_Customer", System.Data.SqlDbType.NVarChar, 0, System.Data.ParameterDirection.Input, 0, 0, "Customer", System.Data.DataRowVersion.Original, false, Nothing, "", "", ""))
Me._adapter.UpdateCommand.Parameters.Add(New System.Data.SqlClient.SqlParameter("@IsNull_Address_1", System.Data.SqlDbType.Int, 0, System.Data.ParameterDirection.Input, 0, 0, "Address_1", System.Data.DataRowVersion.Original, true, Nothing, "", "", ""))
Me._adapter.UpdateCommand.Parameters.Add(New System.Data.SqlClient.SqlParameter("@Original_Address_1", System.Data.SqlDbType.NVarChar, 0, System.Data.ParameterDirection.Input, 0, 0, "Address_1", System.Data.DataRowVersion.Original, false, Nothing, "", "", ""))
Me._adapter.UpdateCommand.Parameters.Add(New System.Data.SqlClient.SqlParameter("@IsNull_Address_2", System.Data.SqlDbType.Int, 0, System.Data.ParameterDirection.Input, 0, 0, "Address_2", System.Data.DataRowVersion.Original, true, Nothing, "", "", ""))
Me._adapter.UpdateCommand.Parameters.Add(New System.Data.SqlClient.SqlParameter("@Original_Address_2", System.Data.SqlDbType.NVarChar, 0, System.Data.ParameterDirection.Input, 0, 0, "Address_2", System.Data.DataRowVersion.Original, false, Nothing, "", "", ""))
Me._adapter.UpdateCommand.Parameters.Add(New System.Data.SqlClient.SqlParameter("@IsNull_Address_3", System.Data.SqlDbType.Int, 0, System.Data.ParameterDirection.Input, 0, 0, "Address_3", System.Data.DataRowVersion.Original, true, Nothing, "", "", ""))
Me._adapter.UpdateCommand.Parameters.Add(New System.Data.SqlClient.SqlParameter("@Original_Address_3", System.Data.SqlDbType.NVarChar, 0, System.Data.ParameterDirection.Input, 0, 0, "Address_3", System.Data.DataRowVersion.Original, false, Nothing, "", "", ""))
Me._adapter.UpdateCommand.Parameters.Add(New System.Data.SqlClient.SqlParameter("@IsNull_Address_4", System.Data.SqlDbType.Int, 0, System.Data.ParameterDirection.Input, 0, 0, "Address_4", System.Data.DataRowVersion.Original, true, Nothing, "", "", ""))
Me._adapter.UpdateCommand.Parameters.Add(New System.Data.SqlClient.SqlParameter("@Original_Address_4", System.Data.SqlDbType.NVarChar, 0, System.Data.ParameterDirection.Input, 0, 0, "Address_4", System.Data.DataRowVersion.Original, false, Nothing, "", "", ""))
Me._adapter.UpdateCommand.Parameters.Add(New System.Data.SqlClient.SqlParameter("@IsNull_Address_5", System.Data.SqlDbType.Int, 0, System.Data.ParameterDirection.Input, 0, 0, "Address_5", System.Data.DataRowVersion.Original, true, Nothing, "", "", ""))
Me._adapter.UpdateCommand.Parameters.Add(New System.Data.SqlClient.SqlParameter("@Original_Address_5", System.Data.SqlDbType.NVarChar, 0, System.Data.ParameterDirection.Input, 0, 0, "Address_5", System.Data.DataRowVersion.Original, false, Nothing, "", "", ""))
Me._adapter.UpdateCommand.Parameters.Add(New System.Data.SqlClient.SqlParameter("@IsNull_ContactName", System.Data.SqlDbType.Int, 0, System.Data.ParameterDirection.Input, 0, 0, "ContactName", System.Data.DataRowVersion.Original, true, Nothing, "", "", ""))
Me._adapter.UpdateCommand.Parameters.Add(New System.Data.SqlClient.SqlParameter("@Original_ContactName", System.Data.SqlDbType.NVarChar, 0, System.Data.ParameterDirection.Input, 0, 0, "ContactName", System.Data.DataRowVersion.Original, false, Nothing, "", "", ""))
Me._adapter.UpdateCommand.Parameters.Add(New System.Data.SqlClient.SqlParameter("@IsNull_ContactTel", System.Data.SqlDbType.Int, 0, System.Data.ParameterDirection.Input, 0, 0, "ContactTel", System.Data.DataRowVersion.Original, true, Nothing, "", "", ""))
Me._adapter.UpdateCommand.Parameters.Add(New System.Data.SqlClient.SqlParameter("@Original_ContactTel", System.Data.SqlDbType.NVarChar, 0, System.Data.ParameterDirection.Input, 0, 0, "ContactTel", System.Data.DataRowVersion.Original, false, Nothing, "", "", ""))
Me._adapter.UpdateCommand.Parameters.Add(New System.Data.SqlClient.SqlParameter("@Original_Delivery", System.Data.SqlDbType.Bit, 0, System.Data.ParameterDirection.Input, 0, 0, "Delivery", System.Data.DataRowVersion.Original, false, Nothing, "", "", ""))
Me._adapter.UpdateCommand.Parameters.Add(New System.Data.SqlClient.SqlParameter("@IsNull_D_Customer", System.Data.SqlDbType.Int, 0, System.Data.ParameterDirection.Input, 0, 0, "D_Customer", System.Data.DataRowVersion.Original, true, Nothing, "", "", ""))
Me._adapter.UpdateCommand.Parameters.Add(New System.Data.SqlClient.SqlParameter("@Original_D_Customer", System.Data.SqlDbType.NVarChar, 0, System.Data.ParameterDirection.Input, 0, 0, "D_Customer", System.Data.DataRowVersion.Original, false, Nothing, "", "", ""))
Me._adapter.UpdateCommand.Parameters.Add(New System.Data.SqlClient.SqlParameter("@IsNull_D_Address_1", System.Data.SqlDbType.Int, 0, System.Data.ParameterDirection.Input, 0, 0, "D_Address_1", System.Data.DataRowVersion.Original, true, Nothing, "", "", ""))
Me._adapter.UpdateCommand.Parameters.Add(New System.Data.SqlClient.SqlParameter("@Original_D_Address_1", System.Data.SqlDbType.NVarChar, 0, System.Data.ParameterDirection.Input, 0, 0, "D_Address_1", System.Data.DataRowVersion.Original, false, Nothing, "", "", ""))
Me._adapter.UpdateCommand.Parameters.Add(New System.Data.SqlClient.SqlParameter("@IsNull_D_Address_2", System.Data.SqlDbType.Int, 0, System.Data.ParameterDirection.Input, 0, 0, "D_Address_2", System.Data.DataRowVersion.Original, true, Nothing, "", "", ""))
Me._adapter.UpdateCommand.Parameters.Add(New System.Data.SqlClient.SqlParameter("@Original_D_Address_2", System.Data.SqlDbType.NVarChar, 0, System.Data.ParameterDirection.Input, 0, 0, "D_Address_2", System.Data.DataRowVersion.Original, false, Nothing, "", "", ""))
Me._adapter.UpdateCommand.Parameters.Add(New System.Data.SqlClient.SqlParameter("@IsNull_D_Address_3", System.Data.SqlDbType.Int, 0, System.Data.ParameterDirection.Input, 0, 0, "D_Address_3", System.Data.DataRowVersion.Original, true, Nothing, "", "", ""))
Me._adapter.UpdateCommand.Parameters.Add(New System.Data.SqlClient.SqlParameter("@Original_D_Address_3", System.Data.SqlDbType.NVarChar, 0, System.Data.ParameterDirection.Input, 0, 0, "D_Address_3", System.Data.DataRowVersion.Original, false, Nothing, "", "", ""))
Me._adapter.UpdateCommand.Parameters.Add(New System.Data.SqlClient.SqlParameter("@IsNull_D_Address_4", System.Data.SqlDbType.Int, 0, System.Data.ParameterDirection.Input, 0, 0, "D_Address_4", System.Data.DataRowVersion.Original, true, Nothing, "", "", ""))
Me._adapter.UpdateCommand.Parameters.Add(New System.Data.SqlClient.SqlParameter("@Original_D_Address_4", System.Data.SqlDbType.NVarChar, 0, System.Data.ParameterDirection.Input, 0, 0, "D_Address_4", System.Data.DataRowVersion.Original, false, Nothing, "", "", ""))
Me._adapter.UpdateCommand.Parameters.Add(New System.Data.SqlClient.SqlParameter("@IsNull_D_Address_5", System.Data.SqlDbType.Int, 0, System.Data.ParameterDirection.Input, 0, 0, "D_Address_5", System.Data.DataRowVersion.Original, true, Nothing, "", "", ""))
Me._adapter.UpdateCommand.Parameters.Add(New System.Data.SqlClient.SqlParameter("@Original_D_Address_5", System.Data.SqlDbType.NVarChar, 0, System.Data.ParameterDirection.Input, 0, 0, "D_Address_5", System.Data.DataRowVersion.Original, false, Nothing, "", "", ""))
Me._adapter.UpdateCommand.Parameters.Add(New System.Data.SqlClient.SqlParameter("@IsNull_CustomerOrderNumber", System.Data.SqlDbType.Int, 0, System.Data.ParameterDirection.Input, 0, 0, "CustomerOrderNumber", System.Data.DataRowVersion.Original, true, Nothing, "", "", ""))
Me._adapter.UpdateCommand.Parameters.Add(New System.Data.SqlClient.SqlParameter("@Original_CustomerOrderNumber", System.Data.SqlDbType.NVarChar, 0, System.Data.ParameterDirection.Input, 0, 0, "CustomerOrderNumber", System.Data.DataRowVersion.Original, false, Nothing, "", "", ""))
Me._adapter.UpdateCommand.Parameters.Add(New System.Data.SqlClient.SqlParameter("@IsNull_Details", System.Data.SqlDbType.Int, 0, System.Data.ParameterDirection.Input, 0, 0, "Details", System.Data.DataRowVersion.Original, true, Nothing, "", "", ""))
Me._adapter.UpdateCommand.Parameters.Add(New System.Data.SqlClient.SqlParameter("@Original_Details", System.Data.SqlDbType.NVarChar, 0, System.Data.ParameterDirection.Input, 0, 0, "Details", System.Data.DataRowVersion.Original, false, Nothing, "", "", ""))
Me._adapter.UpdateCommand.Parameters.Add(New System.Data.SqlClient.SqlParameter("@IsNull_SupplierInvoiceReceived", System.Data.SqlDbType.Int, 0, System.Data.ParameterDirection.Input, 0, 0, "SupplierInvoiceReceived", System.Data.DataRowVersion.Original, true, Nothing, "", "", ""))
Me._adapter.UpdateCommand.Parameters.Add(New System.Data.SqlClient.SqlParameter("@Original_SupplierInvoiceReceived", System.Data.SqlDbType.NVarChar, 0, System.Data.ParameterDirection.Input, 0, 0, "SupplierInvoiceReceived", System.Data.DataRowVersion.Original, false, Nothing, "", "", ""))
Me._adapter.UpdateCommand.Parameters.Add(New System.Data.SqlClient.SqlParameter("@IsNull_InvoiceNumber", System.Data.SqlDbType.Int, 0, System.Data.ParameterDirection.Input, 0, 0, "InvoiceNumber", System.Data.DataRowVersion.Original, true, Nothing, "", "", ""))
Me._adapter.UpdateCommand.Parameters.Add(New System.Data.SqlClient.SqlParameter("@Original_InvoiceNumber", System.Data.SqlDbType.NVarChar, 0, System.Data.ParameterDirection.Input, 0, 0, "InvoiceNumber", System.Data.DataRowVersion.Original, false, Nothing, "", "", ""))
Me._adapter.UpdateCommand.Parameters.Add(New System.Data.SqlClient.SqlParameter("@IsNull_InvoicePaid", System.Data.SqlDbType.Int, 0, System.Data.ParameterDirection.Input, 0, 0, "InvoicePaid", System.Data.DataRowVersion.Original, true, Nothing, "", "", ""))
Me._adapter.UpdateCommand.Parameters.Add(New System.Data.SqlClient.SqlParameter("@Original_InvoicePaid", System.Data.SqlDbType.DateTime, 0, System.Data.ParameterDirection.Input, 0, 0, "InvoicePaid", System.Data.DataRowVersion.Original, false, Nothing, "", "", ""))
Me._adapter.UpdateCommand.Parameters.Add(New System.Data.SqlClient.SqlParameter("@IsNull_DeliveryNoteNumber", System.Data.SqlDbType.Int, 0, System.Data.ParameterDirection.Input, 0, 0, "DeliveryNoteNumber", System.Data.DataRowVersion.Original, true, Nothing, "", "", ""))
Me._adapter.UpdateCommand.Parameters.Add(New System.Data.SqlClient.SqlParameter("@Original_DeliveryNoteNumber", System.Data.SqlDbType.NVarChar, 0, System.Data.ParameterDirection.Input, 0, 0, "DeliveryNoteNumber", System.Data.DataRowVersion.Original, false, Nothing, "", "", ""))
Me._adapter.UpdateCommand.Parameters.Add(New System.Data.SqlClient.SqlParameter("@IsNull_DeliveryDate", System.Data.SqlDbType.Int, 0, System.Data.ParameterDirection.Input, 0, 0, "DeliveryDate", System.Data.DataRowVersion.Original, true, Nothing, "", "", ""))
Me._adapter.UpdateCommand.Parameters.Add(New System.Data.SqlClient.SqlParameter("@Original_DeliveryDate", System.Data.SqlDbType.DateTime, 0, System.Data.ParameterDirection.Input, 0, 0, "DeliveryDate", System.Data.DataRowVersion.Original, false, Nothing, "", "", ""))
Me._adapter.UpdateCommand.Parameters.Add(New System.Data.SqlClient.SqlParameter("@IsNull_Salesman", System.Data.SqlDbType.Int, 0, System.Data.ParameterDirection.Input, 0, 0, "Salesman", System.Data.DataRowVersion.Original, true, Nothing, "", "", ""))
Me._adapter.UpdateCommand.Parameters.Add(New System.Data.SqlClient.SqlParameter("@Original_Salesman", System.Data.SqlDbType.Int, 0, System.Data.ParameterDirection.Input, 0, 0, "Salesman", System.Data.DataRowVersion.Original, false, Nothing, "", "", ""))
Me._adapter.UpdateCommand.Parameters.Add(New System.Data.SqlClient.SqlParameter("@IsNull_Lead", System.Data.SqlDbType.Int, 0, System.Data.ParameterDirection.Input, 0, 0, "Lead", System.Data.DataRowVersion.Original, true, Nothing, "", "", ""))
Me._adapter.UpdateCommand.Parameters.Add(New System.Data.SqlClient.SqlParameter("@Original_Lead", System.Data.SqlDbType.Int, 0, System.Data.ParameterDirection.Input, 0, 0, "Lead", System.Data.DataRowVersion.Original, false, Nothing, "", "", ""))
Me._adapter.UpdateCommand.Parameters.Add(New System.Data.SqlClient.SqlParameter("@IsNull_LeadPaidDate", System.Data.SqlDbType.Int, 0, System.Data.ParameterDirection.Input, 0, 0, "LeadPaidDate", System.Data.DataRowVersion.Original, true, Nothing, "", "", ""))
Me._adapter.UpdateCommand.Parameters.Add(New System.Data.SqlClient.SqlParameter("@Original_LeadPaidDate", System.Data.SqlDbType.NVarChar, 0, System.Data.ParameterDirection.Input, 0, 0, "LeadPaidDate", System.Data.DataRowVersion.Original, false, Nothing, "", "", ""))
Me._adapter.UpdateCommand.Parameters.Add(New System.Data.SqlClient.SqlParameter("@IsNull_TotalCost", System.Data.SqlDbType.Int, 0, System.Data.ParameterDirection.Input, 0, 0, "TotalCost", System.Data.DataRowVersion.Original, true, Nothing, "", "", ""))
Me._adapter.UpdateCommand.Parameters.Add(New System.Data.SqlClient.SqlParameter("@Original_TotalCost", System.Data.SqlDbType.Money, 0, System.Data.ParameterDirection.Input, 0, 0, "TotalCost", System.Data.DataRowVersion.Original, false, Nothing, "", "", ""))
Me._adapter.UpdateCommand.Parameters.Add(New System.Data.SqlClient.SqlParameter("@IsNull_TotalSell", System.Data.SqlDbType.Int, 0, System.Data.ParameterDirection.Input, 0, 0, "TotalSell", System.Data.DataRowVersion.Original, true, Nothing, "", "", ""))
Me._adapter.UpdateCommand.Parameters.Add(New System.Data.SqlClient.SqlParameter("@Original_TotalSell", System.Data.SqlDbType.Money, 0, System.Data.ParameterDirection.Input, 0, 0, "TotalSell", System.Data.DataRowVersion.Original, false, Nothing, "", "", ""))
Me._adapter.UpdateCommand.Parameters.Add(New System.Data.SqlClient.SqlParameter("@IsNull_TotalProfit", System.Data.SqlDbType.Int, 0, System.Data.ParameterDirection.Input, 0, 0, "TotalProfit", System.Data.DataRowVersion.Original, true, Nothing, "", "", ""))
Me._adapter.UpdateCommand.Parameters.Add(New System.Data.SqlClient.SqlParameter("@Original_TotalProfit", System.Data.SqlDbType.Money, 0, System.Data.ParameterDirection.Input, 0, 0, "TotalProfit", System.Data.DataRowVersion.Original, false, Nothing, "", "", ""))
Me._adapter.UpdateCommand.Parameters.Add(New System.Data.SqlClient.SqlParameter("@IsNull_TotalTax", System.Data.SqlDbType.Int, 0, System.Data.ParameterDirection.Input, 0, 0, "TotalTax", System.Data.DataRowVersion.Original, true, Nothing, "", "", ""))
Me._adapter.UpdateCommand.Parameters.Add(New System.Data.SqlClient.SqlParameter("@Original_TotalTax", System.Data.SqlDbType.Money, 0, System.Data.ParameterDirection.Input, 0, 0, "TotalTax", System.Data.DataRowVersion.Original, false, Nothing, "", "", ""))
Me._adapter.UpdateCommand.Parameters.Add(New System.Data.SqlClient.SqlParameter("@IsNull_TaxCode", System.Data.SqlDbType.Int, 0, System.Data.ParameterDirection.Input, 0, 0, "TaxCode", System.Data.DataRowVersion.Original, true, Nothing, "", "", ""))
Me._adapter.UpdateCommand.Parameters.Add(New System.Data.SqlClient.SqlParameter("@Original_TaxCode", System.Data.SqlDbType.NVarChar, 0, System.Data.ParameterDirection.Input, 0, 0, "TaxCode", System.Data.DataRowVersion.Original, false, Nothing, "", "", ""))
Me._adapter.UpdateCommand.Parameters.Add(New System.Data.SqlClient.SqlParameter("@IsNull_CreatedDate", System.Data.SqlDbType.Int, 0, System.Data.ParameterDirection.Input, 0, 0, "CreatedDate", System.Data.DataRowVersion.Original, true, Nothing, "", "", ""))
Me._adapter.UpdateCommand.Parameters.Add(New System.Data.SqlClient.SqlParameter("@Original_CreatedDate", System.Data.SqlDbType.DateTime, 0, System.Data.ParameterDirection.Input, 0, 0, "CreatedDate", System.Data.DataRowVersion.Original, false, Nothing, "", "", ""))
Me._adapter.UpdateCommand.Parameters.Add(New System.Data.SqlClient.SqlParameter("@IsNull_SAGECreatedDate", System.Data.SqlDbType.Int, 0, System.Data.ParameterDirection.Input, 0, 0, "SAGECreatedDate", System.Data.DataRowVersion.Original, true, Nothing, "", "", ""))
Me._adapter.UpdateCommand.Parameters.Add(New System.Data.SqlClient.SqlParameter("@Original_SAGECreatedDate", System.Data.SqlDbType.DateTime, 0, System.Data.ParameterDirection.Input, 0, 0, "SAGECreatedDate", System.Data.DataRowVersion.Original, false, Nothing, "", "", ""))
Me._adapter.UpdateCommand.Parameters.Add(New System.Data.SqlClient.SqlParameter("@IsNull_UpdatedDate", System.Data.SqlDbType.Int, 0, System.Data.ParameterDirection.Input, 0, 0, "UpdatedDate", System.Data.DataRowVersion.Original, true, Nothing, "", "", ""))
Me._adapter.UpdateCommand.Parameters.Add(New System.Data.SqlClient.SqlParameter("@Original_UpdatedDate", System.Data.SqlDbType.DateTime, 0, System.Data.ParameterDirection.Input, 0, 0, "UpdatedDate", System.Data.DataRowVersion.Original, false, Nothing, "", "", ""))
Me._adapter.UpdateCommand.Parameters.Add(New System.Data.SqlClient.SqlParameter("@IsNull_SAGEUpdatedDate", System.Data.SqlDbType.Int, 0, System.Data.ParameterDirection.Input, 0, 0, "SAGEUpdatedDate", System.Data.DataRowVersion.Original, true, Nothing, "", "", ""))
Me._adapter.UpdateCommand.Parameters.Add(New System.Data.SqlClient.SqlParameter("@Original_SAGEUpdatedDate", System.Data.SqlDbType.DateTime, 0, System.Data.ParameterDirection.Input, 0, 0, "SAGEUpdatedDate", System.Data.DataRowVersion.Original, false, Nothing, "", "", ""))
Me._adapter.UpdateCommand.Parameters.Add(New System.Data.SqlClient.SqlParameter("@Original_Equipment", System.Data.SqlDbType.Bit, 0, System.Data.ParameterDirection.Input, 0, 0, "Equipment", System.Data.DataRowVersion.Original, false, Nothing, "", "", ""))
Me._adapter.UpdateCommand.Parameters.Add(New System.Data.SqlClient.SqlParameter("@Original_DespatchStatusCode", System.Data.SqlDbType.Int, 0, System.Data.ParameterDirection.Input, 0, 0, "DespatchStatusCode", System.Data.DataRowVersion.Original, false, Nothing, "", "", ""))
Me._adapter.UpdateCommand.Parameters.Add(New System.Data.SqlClient.SqlParameter("@IsNull_DespatchStatus", System.Data.SqlDbType.Int, 0, System.Data.ParameterDirection.Input, 0, 0, "DespatchStatus", System.Data.DataRowVersion.Original, true, Nothing, "", "", ""))
Me._adapter.UpdateCommand.Parameters.Add(New System.Data.SqlClient.SqlParameter("@Original_DespatchStatus", System.Data.SqlDbType.NVarChar, 0, System.Data.ParameterDirection.Input, 0, 0, "DespatchStatus", System.Data.DataRowVersion.Original, false, Nothing, "", "", ""))
Me._adapter.UpdateCommand.Parameters.Add(New System.Data.SqlClient.SqlParameter("@Original_Version", System.Data.SqlDbType.Int, 0, System.Data.ParameterDirection.Input, 0, 0, "Version", System.Data.DataRowVersion.Original, false, Nothing, "", "", ""))
Me._adapter.UpdateCommand.Parameters.Add(New System.Data.SqlClient.SqlParameter("@PCNumber", System.Data.SqlDbType.Int, 4, System.Data.ParameterDirection.Input, 0, 0, "PCNumber", System.Data.DataRowVersion.Current, false, Nothing, "", "", ""))