/// <summary> /// Required method for Designer support - do not modify /// the contents of this method with the code editor. /// </summary> private void InitializeComponent() { System.Configuration.AppSettingsReader configurationAppSettings = new System.Configuration.AppSettingsReader(); this.cnOrderTrackerDB = new System.Data.SqlClient.SqlConnection(); this.sqlInsertCommand1 = new System.Data.SqlClient.SqlCommand(); this.sqlUpdateCommand1 = new System.Data.SqlClient.SqlCommand(); this.sqlDeleteCommand1 = new System.Data.SqlClient.SqlCommand(); this.adSpeed = new System.Data.SqlClient.SqlDataAdapter(); this.sqlSelectCommand2 = new System.Data.SqlClient.SqlCommand(); this.sqlSelectCommand1 = new System.Data.SqlClient.SqlCommand(); this.dsSpeedData = new OrderTrackerv2.HOOemployees.SpeedData(); this.adTypes = new System.Data.SqlClient.SqlDataAdapter(); this.sqlSelectCommand3 = new System.Data.SqlClient.SqlCommand(); this.dsOrderTypes = new OrderTrackerv2.HOOemployees.OrderTypes(); this.adShirtData = new System.Data.SqlClient.SqlDataAdapter(); this.sqlDeleteCommand2 = new System.Data.SqlClient.SqlCommand(); this.sqlInsertCommand2 = new System.Data.SqlClient.SqlCommand(); this.sqlSelectCommand4 = new System.Data.SqlClient.SqlCommand(); this.sqlUpdateCommand2 = new System.Data.SqlClient.SqlCommand(); this.dsShirtData = new OrderTrackerv2.HOOemployees.ShirtData(); this.dsDummyOrder = new System.Data.SqlClient.SqlDataAdapter(); this.sqlSelectCommand5 = new System.Data.SqlClient.SqlCommand(); this.dummyOrderData1 = new OrderTrackerv2.HOOemployees.DummyOrderData(); ((System.ComponentModel.ISupportInitialize)(this.dsSpeedData)).BeginInit(); ((System.ComponentModel.ISupportInitialize)(this.dsOrderTypes)).BeginInit(); ((System.ComponentModel.ISupportInitialize)(this.dsShirtData)).BeginInit(); ((System.ComponentModel.ISupportInitialize)(this.dummyOrderData1)).BeginInit(); // // cnOrderTrackerDB // this.cnOrderTrackerDB.ConnectionString = ((string)(configurationAppSettings.GetValue("cnOrderTrackerDB.ConnectionString", typeof(string)))); // // adSpeed // this.adSpeed.SelectCommand = this.sqlSelectCommand2; this.adSpeed.TableMappings.AddRange(new System.Data.Common.DataTableMapping[] { new System.Data.Common.DataTableMapping("Table", "Speed", new System.Data.Common.DataColumnMapping[] { new System.Data.Common.DataColumnMapping("Speed", "Speed")})}); // // sqlSelectCommand2 // this.sqlSelectCommand2.CommandText = "SELECT Speed FROM dbo.Speed"; this.sqlSelectCommand2.Connection = this.cnOrderTrackerDB; // // dsSpeedData // this.dsSpeedData.DataSetName = "SpeedData"; this.dsSpeedData.Locale = new System.Globalization.CultureInfo("en-US"); // // adTypes // this.adTypes.SelectCommand = this.sqlSelectCommand3; this.adTypes.TableMappings.AddRange(new System.Data.Common.DataTableMapping[] { new System.Data.Common.DataTableMapping("Table", "orderTypes", new System.Data.Common.DataColumnMapping[] { new System.Data.Common.DataColumnMapping("Type", "Type")})}); // // sqlSelectCommand3 // this.sqlSelectCommand3.CommandText = "SELECT Type FROM dbo.orderTypes"; this.sqlSelectCommand3.Connection = this.cnOrderTrackerDB; // // dsOrderTypes // this.dsOrderTypes.DataSetName = "OrderTypes"; this.dsOrderTypes.Locale = new System.Globalization.CultureInfo("en-US"); // // adShirtData // this.adShirtData.DeleteCommand = this.sqlDeleteCommand2; this.adShirtData.InsertCommand = this.sqlInsertCommand2; this.adShirtData.SelectCommand = this.sqlSelectCommand4; this.adShirtData.TableMappings.AddRange(new System.Data.Common.DataTableMapping[] { new System.Data.Common.DataTableMapping("Table", "ShirtOrders", new System.Data.Common.DataColumnMapping[] { new System.Data.Common.DataColumnMapping("orderNumber", "orderNumber"), new System.Data.Common.DataColumnMapping("manufacturer", "manufacturer"), new System.Data.Common.DataColumnMapping("color", "color"), new System.Data.Common.DataColumnMapping("num_24", "num_24"), new System.Data.Common.DataColumnMapping("num_68", "num_68"), new System.Data.Common.DataColumnMapping("num_1012", "num_1012"), new System.Data.Common.DataColumnMapping("num_1416", "num_1416"), new System.Data.Common.DataColumnMapping("num_s", "num_s"), new System.Data.Common.DataColumnMapping("num_m", "num_m"), new System.Data.Common.DataColumnMapping("num_l", "num_l"), new System.Data.Common.DataColumnMapping("num_xl", "num_xl"), new System.Data.Common.DataColumnMapping("num_xxl", "num_xxl"), new System.Data.Common.DataColumnMapping("num_xxxl", "num_xxxl"), new System.Data.Common.DataColumnMapping("num_xxxxl", "num_xxxxl"), new System.Data.Common.DataColumnMapping("num_other", "num_other"), new System.Data.Common.DataColumnMapping("unitPrice", "unitPrice"), new System.Data.Common.DataColumnMapping("styleNum", "styleNum"), new System.Data.Common.DataColumnMapping("description", "description"), new System.Data.Common.DataColumnMapping("type", "type"), new System.Data.Common.DataColumnMapping("sleeveOrPocket", "sleeveOrPocket"), new System.Data.Common.DataColumnMapping("totalQty", "totalQty"), new System.Data.Common.DataColumnMapping("totalPrice", "totalPrice")})}); this.adShirtData.UpdateCommand = this.sqlUpdateCommand2; // // sqlDeleteCommand2 // this.sqlDeleteCommand2.CommandText = @"DELETE FROM dbo.ShirtOrders WHERE (color = @Original_color) AND (manufacturer = @Original_manufacturer) AND (orderNumber = @Original_orderNumber) AND (num_1012 = @Original_num_1012) AND (num_1416 = @Original_num_1416) AND (num_24 = @Original_num_24) AND (num_68 = @Original_num_68) AND (num_l = @Original_num_l) AND (num_m = @Original_num_m) AND (num_other = @Original_num_other) AND (num_s = @Original_num_s) AND (num_xl = @Original_num_xl) AND (num_xxl = @Original_num_xxl) AND (num_xxxl = @Original_num_xxxl) AND (num_xxxxl = @Original_num_xxxxl) AND (sleeveOrPocket = @Original_sleeveOrPocket) AND (styleNum = @Original_styleNum OR @Original_styleNum IS NULL AND styleNum IS NULL) AND (totalPrice = @Original_totalPrice OR @Original_totalPrice IS NULL AND totalPrice IS NULL) AND (totalQty = @Original_totalQty OR @Original_totalQty IS NULL AND totalQty IS NULL) AND (type = @Original_type) AND (unitPrice = @Original_unitPrice)"; this.sqlDeleteCommand2.Connection = this.cnOrderTrackerDB; this.sqlDeleteCommand2.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_color", System.Data.SqlDbType.NVarChar, 20, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "color", System.Data.DataRowVersion.Original, null)); this.sqlDeleteCommand2.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_manufacturer", System.Data.SqlDbType.NVarChar, 40, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "manufacturer", System.Data.DataRowVersion.Original, null)); this.sqlDeleteCommand2.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_orderNumber", System.Data.SqlDbType.Int, 4, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "orderNumber", System.Data.DataRowVersion.Original, null)); this.sqlDeleteCommand2.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_num_1012", System.Data.SqlDbType.Int, 4, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "num_1012", System.Data.DataRowVersion.Original, null)); this.sqlDeleteCommand2.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_num_1416", System.Data.SqlDbType.Int, 4, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "num_1416", System.Data.DataRowVersion.Original, null)); this.sqlDeleteCommand2.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_num_24", System.Data.SqlDbType.Int, 4, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "num_24", System.Data.DataRowVersion.Original, null)); this.sqlDeleteCommand2.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_num_68", System.Data.SqlDbType.Int, 4, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "num_68", System.Data.DataRowVersion.Original, null)); this.sqlDeleteCommand2.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_num_l", System.Data.SqlDbType.Int, 4, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "num_l", System.Data.DataRowVersion.Original, null)); this.sqlDeleteCommand2.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_num_m", System.Data.SqlDbType.Int, 4, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "num_m", System.Data.DataRowVersion.Original, null)); this.sqlDeleteCommand2.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_num_other", System.Data.SqlDbType.Int, 4, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "num_other", System.Data.DataRowVersion.Original, null)); this.sqlDeleteCommand2.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_num_s", System.Data.SqlDbType.Int, 4, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "num_s", System.Data.DataRowVersion.Original, null)); this.sqlDeleteCommand2.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_num_xl", System.Data.SqlDbType.Int, 4, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "num_xl", System.Data.DataRowVersion.Original, null)); this.sqlDeleteCommand2.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_num_xxl", System.Data.SqlDbType.Int, 4, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "num_xxl", System.Data.DataRowVersion.Original, null)); this.sqlDeleteCommand2.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_num_xxxl", System.Data.SqlDbType.Int, 4, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "num_xxxl", System.Data.DataRowVersion.Original, null)); this.sqlDeleteCommand2.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_num_xxxxl", System.Data.SqlDbType.Int, 4, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "num_xxxxl", System.Data.DataRowVersion.Original, null)); this.sqlDeleteCommand2.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_sleeveOrPocket", System.Data.SqlDbType.NVarChar, 2, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "sleeveOrPocket", System.Data.DataRowVersion.Original, null)); this.sqlDeleteCommand2.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_styleNum", System.Data.SqlDbType.NVarChar, 10, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "styleNum", System.Data.DataRowVersion.Original, null)); this.sqlDeleteCommand2.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_totalPrice", System.Data.SqlDbType.Money, 8, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "totalPrice", System.Data.DataRowVersion.Original, null)); this.sqlDeleteCommand2.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_totalQty", System.Data.SqlDbType.Int, 4, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "totalQty", System.Data.DataRowVersion.Original, null)); this.sqlDeleteCommand2.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_type", System.Data.SqlDbType.NVarChar, 20, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "type", System.Data.DataRowVersion.Original, null)); this.sqlDeleteCommand2.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_unitPrice", System.Data.SqlDbType.Money, 8, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "unitPrice", System.Data.DataRowVersion.Original, null)); // // sqlInsertCommand2 // this.sqlInsertCommand2.CommandText = @"INSERT INTO dbo.ShirtOrders(orderNumber, manufacturer, color, num_24, num_68, num_1012, num_1416, num_s, num_m, num_l, num_xl, num_xxl, num_xxxl, num_xxxxl, num_other, unitPrice, styleNum, description, type, sleeveOrPocket) VALUES (@orderNumber, @manufacturer, @color, @num_24, @num_68, @num_1012, @num_1416, @num_s, @num_m, @num_l, @num_xl, @num_xxl, @num_xxxl, @num_xxxxl, @num_other, @unitPrice, @styleNum, @description, @type, @sleeveOrPocket); SELECT orderNumber, manufacturer, color, num_24, num_68, num_1012, num_1416, num_s, num_m, num_l, num_xl, num_xxl, num_xxxl, num_xxxxl, num_other, unitPrice, styleNum, description, type, sleeveOrPocket, totalQty, totalPrice FROM dbo.ShirtOrders WHERE (color = @color) AND (manufacturer = @manufacturer) AND (orderNumber = @orderNumber)"; this.sqlInsertCommand2.Connection = this.cnOrderTrackerDB; this.sqlInsertCommand2.Parameters.Add(new System.Data.SqlClient.SqlParameter("@orderNumber", System.Data.SqlDbType.Int, 4, "orderNumber")); this.sqlInsertCommand2.Parameters.Add(new System.Data.SqlClient.SqlParameter("@manufacturer", System.Data.SqlDbType.NVarChar, 40, "manufacturer")); this.sqlInsertCommand2.Parameters.Add(new System.Data.SqlClient.SqlParameter("@color", System.Data.SqlDbType.NVarChar, 20, "color")); this.sqlInsertCommand2.Parameters.Add(new System.Data.SqlClient.SqlParameter("@num_24", System.Data.SqlDbType.Int, 4, "num_24")); this.sqlInsertCommand2.Parameters.Add(new System.Data.SqlClient.SqlParameter("@num_68", System.Data.SqlDbType.Int, 4, "num_68")); this.sqlInsertCommand2.Parameters.Add(new System.Data.SqlClient.SqlParameter("@num_1012", System.Data.SqlDbType.Int, 4, "num_1012")); this.sqlInsertCommand2.Parameters.Add(new System.Data.SqlClient.SqlParameter("@num_1416", System.Data.SqlDbType.Int, 4, "num_1416")); this.sqlInsertCommand2.Parameters.Add(new System.Data.SqlClient.SqlParameter("@num_s", System.Data.SqlDbType.Int, 4, "num_s")); this.sqlInsertCommand2.Parameters.Add(new System.Data.SqlClient.SqlParameter("@num_m", System.Data.SqlDbType.Int, 4, "num_m")); this.sqlInsertCommand2.Parameters.Add(new System.Data.SqlClient.SqlParameter("@num_l", System.Data.SqlDbType.Int, 4, "num_l")); this.sqlInsertCommand2.Parameters.Add(new System.Data.SqlClient.SqlParameter("@num_xl", System.Data.SqlDbType.Int, 4, "num_xl")); this.sqlInsertCommand2.Parameters.Add(new System.Data.SqlClient.SqlParameter("@num_xxl", System.Data.SqlDbType.Int, 4, "num_xxl")); this.sqlInsertCommand2.Parameters.Add(new System.Data.SqlClient.SqlParameter("@num_xxxl", System.Data.SqlDbType.Int, 4, "num_xxxl")); this.sqlInsertCommand2.Parameters.Add(new System.Data.SqlClient.SqlParameter("@num_xxxxl", System.Data.SqlDbType.Int, 4, "num_xxxxl")); this.sqlInsertCommand2.Parameters.Add(new System.Data.SqlClient.SqlParameter("@num_other", System.Data.SqlDbType.Int, 4, "num_other")); this.sqlInsertCommand2.Parameters.Add(new System.Data.SqlClient.SqlParameter("@unitPrice", System.Data.SqlDbType.Money, 8, "unitPrice")); this.sqlInsertCommand2.Parameters.Add(new System.Data.SqlClient.SqlParameter("@styleNum", System.Data.SqlDbType.NVarChar, 10, "styleNum")); this.sqlInsertCommand2.Parameters.Add(new System.Data.SqlClient.SqlParameter("@description", System.Data.SqlDbType.NVarChar, 1073741823, "description")); this.sqlInsertCommand2.Parameters.Add(new System.Data.SqlClient.SqlParameter("@type", System.Data.SqlDbType.NVarChar, 20, "type")); this.sqlInsertCommand2.Parameters.Add(new System.Data.SqlClient.SqlParameter("@sleeveOrPocket", System.Data.SqlDbType.NVarChar, 2, "sleeveOrPocket")); // // sqlSelectCommand4 // this.sqlSelectCommand4.CommandText = @"SELECT orderNumber, manufacturer, color, num_24, num_68, num_1012, num_1416, num_s, num_m, num_l, num_xl, num_xxl, num_xxxl, num_xxxxl, num_other, unitPrice, styleNum, description, type, sleeveOrPocket, totalQty, totalPrice FROM dbo.ShirtOrders WHERE (orderNumber = @onum)"; this.sqlSelectCommand4.Connection = this.cnOrderTrackerDB; this.sqlSelectCommand4.Parameters.Add(new System.Data.SqlClient.SqlParameter("@onum", System.Data.SqlDbType.Int, 4, "orderNumber")); // // sqlUpdateCommand2 // this.sqlUpdateCommand2.CommandText = "UPDATE dbo.ShirtOrders SET orderNumber = @orderNumber, manufacturer = @manufactur" + "er, color = @color, num_24 = @num_24, num_68 = @num_68, num_1012 = @num_1012, nu" + "m_1416 = @num_1416, num_s = @num_s, num_m = @num_m, num_l = @num_l, num_xl = @nu" + "m_xl, num_xxl = @num_xxl, num_xxxl = @num_xxxl, num_xxxxl = @num_xxxxl, num_othe" + "r = @num_other, unitPrice = @unitPrice, styleNum = @styleNum, description = @des" + "cription, type = @type, sleeveOrPocket = @sleeveOrPocket WHERE (color = @Origina" + "l_color) AND (manufacturer = @Original_manufacturer) AND (orderNumber = @Origina" + "l_orderNumber) AND (num_1012 = @Original_num_1012) AND (num_1416 = @Original_num" + "_1416) AND (num_24 = @Original_num_24) AND (num_68 = @Original_num_68) AND (num_" + "l = @Original_num_l) AND (num_m = @Original_num_m) AND (num_other = @Original_nu" + "m_other) AND (num_s = @Original_num_s) AND (num_xl = @Original_num_xl) AND (num_" + "xxl = @Original_num_xxl) AND (num_xxxl = @Original_num_xxxl) AND (num_xxxxl = @O" + "riginal_num_xxxxl) AND (sleeveOrPocket = @Original_sleeveOrPocket) AND (styleNum" + " = @Original_styleNum OR @Original_styleNum IS NULL AND styleNum IS NULL) AND (t" + "ype = @Original_type) AND (unitPrice = @Original_unitPrice); SELECT orderNumber," + " manufacturer, color, num_24, num_68, num_1012, num_1416, num_s, num_m, num_l, n" + "um_xl, num_xxl, num_xxxl, num_xxxxl, num_other, unitPrice, styleNum, description" + ", type, sleeveOrPocket, totalQty, totalPrice FROM dbo.ShirtOrders WHERE (color =" + " @color) AND (manufacturer = @manufacturer) AND (orderNumber = @orderNumber)"; this.sqlUpdateCommand2.Connection = this.cnOrderTrackerDB; this.sqlUpdateCommand2.Parameters.Add(new System.Data.SqlClient.SqlParameter("@orderNumber", System.Data.SqlDbType.Int, 4, "orderNumber")); this.sqlUpdateCommand2.Parameters.Add(new System.Data.SqlClient.SqlParameter("@manufacturer", System.Data.SqlDbType.NVarChar, 40, "manufacturer")); this.sqlUpdateCommand2.Parameters.Add(new System.Data.SqlClient.SqlParameter("@color", System.Data.SqlDbType.NVarChar, 20, "color")); this.sqlUpdateCommand2.Parameters.Add(new System.Data.SqlClient.SqlParameter("@num_24", System.Data.SqlDbType.Int, 4, "num_24")); this.sqlUpdateCommand2.Parameters.Add(new System.Data.SqlClient.SqlParameter("@num_68", System.Data.SqlDbType.Int, 4, "num_68")); this.sqlUpdateCommand2.Parameters.Add(new System.Data.SqlClient.SqlParameter("@num_1012", System.Data.SqlDbType.Int, 4, "num_1012")); this.sqlUpdateCommand2.Parameters.Add(new System.Data.SqlClient.SqlParameter("@num_1416", System.Data.SqlDbType.Int, 4, "num_1416")); this.sqlUpdateCommand2.Parameters.Add(new System.Data.SqlClient.SqlParameter("@num_s", System.Data.SqlDbType.Int, 4, "num_s")); this.sqlUpdateCommand2.Parameters.Add(new System.Data.SqlClient.SqlParameter("@num_m", System.Data.SqlDbType.Int, 4, "num_m")); this.sqlUpdateCommand2.Parameters.Add(new System.Data.SqlClient.SqlParameter("@num_l", System.Data.SqlDbType.Int, 4, "num_l")); this.sqlUpdateCommand2.Parameters.Add(new System.Data.SqlClient.SqlParameter("@num_xl", System.Data.SqlDbType.Int, 4, "num_xl")); this.sqlUpdateCommand2.Parameters.Add(new System.Data.SqlClient.SqlParameter("@num_xxl", System.Data.SqlDbType.Int, 4, "num_xxl")); this.sqlUpdateCommand2.Parameters.Add(new System.Data.SqlClient.SqlParameter("@num_xxxl", System.Data.SqlDbType.Int, 4, "num_xxxl")); this.sqlUpdateCommand2.Parameters.Add(new System.Data.SqlClient.SqlParameter("@num_xxxxl", System.Data.SqlDbType.Int, 4, "num_xxxxl")); this.sqlUpdateCommand2.Parameters.Add(new System.Data.SqlClient.SqlParameter("@num_other", System.Data.SqlDbType.Int, 4, "num_other")); this.sqlUpdateCommand2.Parameters.Add(new System.Data.SqlClient.SqlParameter("@unitPrice", System.Data.SqlDbType.Money, 8, "unitPrice")); this.sqlUpdateCommand2.Parameters.Add(new System.Data.SqlClient.SqlParameter("@styleNum", System.Data.SqlDbType.NVarChar, 10, "styleNum")); this.sqlUpdateCommand2.Parameters.Add(new System.Data.SqlClient.SqlParameter("@description", System.Data.SqlDbType.NVarChar, 1073741823, "description")); this.sqlUpdateCommand2.Parameters.Add(new System.Data.SqlClient.SqlParameter("@type", System.Data.SqlDbType.NVarChar, 20, "type")); this.sqlUpdateCommand2.Parameters.Add(new System.Data.SqlClient.SqlParameter("@sleeveOrPocket", System.Data.SqlDbType.NVarChar, 2, "sleeveOrPocket")); this.sqlUpdateCommand2.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_color", System.Data.SqlDbType.NVarChar, 20, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "color", System.Data.DataRowVersion.Original, null)); this.sqlUpdateCommand2.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_manufacturer", System.Data.SqlDbType.NVarChar, 40, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "manufacturer", System.Data.DataRowVersion.Original, null)); this.sqlUpdateCommand2.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_orderNumber", System.Data.SqlDbType.Int, 4, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "orderNumber", System.Data.DataRowVersion.Original, null)); this.sqlUpdateCommand2.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_num_1012", System.Data.SqlDbType.Int, 4, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "num_1012", System.Data.DataRowVersion.Original, null)); this.sqlUpdateCommand2.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_num_1416", System.Data.SqlDbType.Int, 4, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "num_1416", System.Data.DataRowVersion.Original, null)); this.sqlUpdateCommand2.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_num_24", System.Data.SqlDbType.Int, 4, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "num_24", System.Data.DataRowVersion.Original, null)); this.sqlUpdateCommand2.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_num_68", System.Data.SqlDbType.Int, 4, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "num_68", System.Data.DataRowVersion.Original, null)); this.sqlUpdateCommand2.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_num_l", System.Data.SqlDbType.Int, 4, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "num_l", System.Data.DataRowVersion.Original, null)); this.sqlUpdateCommand2.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_num_m", System.Data.SqlDbType.Int, 4, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "num_m", System.Data.DataRowVersion.Original, null)); this.sqlUpdateCommand2.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_num_other", System.Data.SqlDbType.Int, 4, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "num_other", System.Data.DataRowVersion.Original, null)); this.sqlUpdateCommand2.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_num_s", System.Data.SqlDbType.Int, 4, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "num_s", System.Data.DataRowVersion.Original, null)); this.sqlUpdateCommand2.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_num_xl", System.Data.SqlDbType.Int, 4, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "num_xl", System.Data.DataRowVersion.Original, null)); this.sqlUpdateCommand2.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_num_xxl", System.Data.SqlDbType.Int, 4, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "num_xxl", System.Data.DataRowVersion.Original, null)); this.sqlUpdateCommand2.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_num_xxxl", System.Data.SqlDbType.Int, 4, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "num_xxxl", System.Data.DataRowVersion.Original, null)); this.sqlUpdateCommand2.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_num_xxxxl", System.Data.SqlDbType.Int, 4, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "num_xxxxl", System.Data.DataRowVersion.Original, null)); this.sqlUpdateCommand2.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_sleeveOrPocket", System.Data.SqlDbType.NVarChar, 2, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "sleeveOrPocket", System.Data.DataRowVersion.Original, null)); this.sqlUpdateCommand2.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_styleNum", System.Data.SqlDbType.NVarChar, 10, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "styleNum", System.Data.DataRowVersion.Original, null)); this.sqlUpdateCommand2.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_type", System.Data.SqlDbType.NVarChar, 20, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "type", System.Data.DataRowVersion.Original, null)); this.sqlUpdateCommand2.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_unitPrice", System.Data.SqlDbType.Money, 8, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "unitPrice", System.Data.DataRowVersion.Original, null)); // // dsShirtData // this.dsShirtData.DataSetName = "ShirtData"; this.dsShirtData.Locale = new System.Globalization.CultureInfo("en-US"); // // dsDummyOrder // this.dsDummyOrder.SelectCommand = this.sqlSelectCommand5; this.dsDummyOrder.TableMappings.AddRange(new System.Data.Common.DataTableMapping[] { new System.Data.Common.DataTableMapping("Table", "Orders", new System.Data.Common.DataColumnMapping[] { new System.Data.Common.DataColumnMapping("orderNumber", "orderNumber"), new System.Data.Common.DataColumnMapping("orderDate", "orderDate"), new System.Data.Common.DataColumnMapping("dueDate", "dueDate"), new System.Data.Common.DataColumnMapping("recDate", "recDate"), new System.Data.Common.DataColumnMapping("reorderNumber", "reorderNumber"), new System.Data.Common.DataColumnMapping("shippingMethod", "shippingMethod"), new System.Data.Common.DataColumnMapping("artDueDate", "artDueDate"), new System.Data.Common.DataColumnMapping("rushReorderRegular", "rushReorderRegular"), new System.Data.Common.DataColumnMapping("orderType", "orderType"), new System.Data.Common.DataColumnMapping("xOrderNumber", "xOrderNumber"), new System.Data.Common.DataColumnMapping("customerNumber", "customerNumber"), new System.Data.Common.DataColumnMapping("contactPersonNumber", "contactPersonNumber"), new System.Data.Common.DataColumnMapping("insideRepNumber", "insideRepNumber"), new System.Data.Common.DataColumnMapping("outsideRepNumber", "outsideRepNumber"), new System.Data.Common.DataColumnMapping("numColorsFront", "numColorsFront"), new System.Data.Common.DataColumnMapping("numColorsBack", "numColorsBack"), new System.Data.Common.DataColumnMapping("numColorsSleeve", "numColorsSleeve"), new System.Data.Common.DataColumnMapping("PMScharge", "PMScharge"), new System.Data.Common.DataColumnMapping("setupCharge", "setupCharge"), new System.Data.Common.DataColumnMapping("artCharge", "artCharge"), new System.Data.Common.DataColumnMapping("rushCharge", "rushCharge"), new System.Data.Common.DataColumnMapping("deposit", "deposit"), new System.Data.Common.DataColumnMapping("subtotal", "subtotal"), new System.Data.Common.DataColumnMapping("salesTax", "salesTax"), new System.Data.Common.DataColumnMapping("shipping", "shipping"), new System.Data.Common.DataColumnMapping("totalDue", "totalDue"), new System.Data.Common.DataColumnMapping("balanceDue", "balanceDue")})}); // // sqlSelectCommand5 // this.sqlSelectCommand5.CommandText = @"SELECT orderNumber, orderDate, dueDate, recDate, reorderNumber, shippingMethod, artDueDate, rushReorderRegular, orderType, xOrderNumber, customerNumber, contactPersonNumber, insideRepNumber, outsideRepNumber, numColorsFront, numColorsBack, numColorsSleeve, PMScharge, setupCharge, artCharge, rushCharge, deposit, subtotal, salesTax, shipping, totalDue, balanceDue FROM dbo.Orders"; this.sqlSelectCommand5.Connection = this.cnOrderTrackerDB; // // dummyOrderData1 // this.dummyOrderData1.DataSetName = "DummyOrderData"; this.dummyOrderData1.EnforceConstraints = false; this.dummyOrderData1.Locale = new System.Globalization.CultureInfo("en-US"); this.Load += new System.EventHandler(this.Page_Load); ((System.ComponentModel.ISupportInitialize)(this.dsSpeedData)).EndInit(); ((System.ComponentModel.ISupportInitialize)(this.dsOrderTypes)).EndInit(); ((System.ComponentModel.ISupportInitialize)(this.dsShirtData)).EndInit(); ((System.ComponentModel.ISupportInitialize)(this.dummyOrderData1)).EndInit(); }
/// <summary> /// Required method for Designer support - do not modify /// the contents of this method with the code editor. /// </summary> private void InitializeComponent() { System.Configuration.AppSettingsReader configurationAppSettings = new System.Configuration.AppSettingsReader(); this.cnOrderTrackerDB = new System.Data.SqlClient.SqlConnection(); this.adShirtData = new System.Data.SqlClient.SqlDataAdapter(); this.sqlDeleteCommand1 = new System.Data.SqlClient.SqlCommand(); this.sqlInsertCommand1 = new System.Data.SqlClient.SqlCommand(); this.sqlSelectCommand1 = new System.Data.SqlClient.SqlCommand(); this.sqlUpdateCommand1 = new System.Data.SqlClient.SqlCommand(); this.dsShirtData = new OrderTrackerv2.HOOemployees.ShirtData(); this.sqlCommand1 = new System.Data.SqlClient.SqlCommand(); this.sqlCommand2 = new System.Data.SqlClient.SqlCommand(); this.adOrderInfo = new System.Data.SqlClient.SqlDataAdapter(); this.sqlDeleteCommand2 = new System.Data.SqlClient.SqlCommand(); this.sqlInsertCommand2 = new System.Data.SqlClient.SqlCommand(); this.sqlSelectCommand2 = new System.Data.SqlClient.SqlCommand(); this.sqlUpdateCommand2 = new System.Data.SqlClient.SqlCommand(); this.dsOrderData = new OrderTrackerv2.HOOemployees.OrderData(); this.sqlDataAdapter2 = new System.Data.SqlClient.SqlDataAdapter(); this.sqlInsertCommand3 = new System.Data.SqlClient.SqlCommand(); this.sqlSelectCommand3 = new System.Data.SqlClient.SqlCommand(); this.sqlDataAdapter3 = new System.Data.SqlClient.SqlDataAdapter(); this.sqlSelectCommand4 = new System.Data.SqlClient.SqlCommand(); this.dsSpeedData = new OrderTrackerv2.HOOemployees.SpeedData(); this.dsOrderTypes = new OrderTrackerv2.HOOemployees.OrderTypes(); ((System.ComponentModel.ISupportInitialize)(this.dsShirtData)).BeginInit(); ((System.ComponentModel.ISupportInitialize)(this.dsOrderData)).BeginInit(); ((System.ComponentModel.ISupportInitialize)(this.dsSpeedData)).BeginInit(); ((System.ComponentModel.ISupportInitialize)(this.dsOrderTypes)).BeginInit(); this.txtShipping.TextChanged += new System.EventHandler(this.txtShipping_TextChanged); this.searchForCustomer.Click += new System.EventHandler(this.searchForCustomer_Click); this.searchForContact.Click += new System.EventHandler(this.searchForContact_Click); this.LinkButton1.Click += new System.EventHandler(this.LinkButton1_Click); this.btnAddShirt.Click += new System.EventHandler(this.btnAddShirt_Click); // // cnOrderTrackerDB // this.cnOrderTrackerDB.ConnectionString = ((string)(configurationAppSettings.GetValue("cnOrderTrackerDB.ConnectionString", typeof(string)))); // // adShirtData // this.adShirtData.DeleteCommand = this.sqlDeleteCommand1; this.adShirtData.InsertCommand = this.sqlInsertCommand1; this.adShirtData.SelectCommand = this.sqlSelectCommand1; this.adShirtData.TableMappings.AddRange(new System.Data.Common.DataTableMapping[] { new System.Data.Common.DataTableMapping("Table", "ShirtOrders", new System.Data.Common.DataColumnMapping[] { new System.Data.Common.DataColumnMapping("orderNumber", "orderNumber"), new System.Data.Common.DataColumnMapping("manufacturer", "manufacturer"), new System.Data.Common.DataColumnMapping("color", "color"), new System.Data.Common.DataColumnMapping("num_24", "num_24"), new System.Data.Common.DataColumnMapping("num_68", "num_68"), new System.Data.Common.DataColumnMapping("num_1012", "num_1012"), new System.Data.Common.DataColumnMapping("num_1416", "num_1416"), new System.Data.Common.DataColumnMapping("num_s", "num_s"), new System.Data.Common.DataColumnMapping("num_m", "num_m"), new System.Data.Common.DataColumnMapping("num_l", "num_l"), new System.Data.Common.DataColumnMapping("num_xl", "num_xl"), new System.Data.Common.DataColumnMapping("num_xxl", "num_xxl"), new System.Data.Common.DataColumnMapping("num_xxxl", "num_xxxl"), new System.Data.Common.DataColumnMapping("num_xxxxl", "num_xxxxl"), new System.Data.Common.DataColumnMapping("num_other", "num_other"), new System.Data.Common.DataColumnMapping("unitPrice", "unitPrice"), new System.Data.Common.DataColumnMapping("styleNum", "styleNum"), new System.Data.Common.DataColumnMapping("description", "description"), new System.Data.Common.DataColumnMapping("type", "type"), new System.Data.Common.DataColumnMapping("sleeveOrPocket", "sleeveOrPocket"), new System.Data.Common.DataColumnMapping("totalQty", "totalQty"), new System.Data.Common.DataColumnMapping("totalPrice", "totalPrice")})}); this.adShirtData.UpdateCommand = this.sqlUpdateCommand1; // // sqlDeleteCommand1 // this.sqlDeleteCommand1.CommandText = @"DELETE FROM dbo.ShirtOrders WHERE (color = @Original_color) AND (manufacturer = @Original_manufacturer) AND (orderNumber = @Original_orderNumber) AND (num_1012 = @Original_num_1012) AND (num_1416 = @Original_num_1416) AND (num_24 = @Original_num_24) AND (num_68 = @Original_num_68) AND (num_l = @Original_num_l) AND (num_m = @Original_num_m) AND (num_other = @Original_num_other) AND (num_s = @Original_num_s) AND (num_xl = @Original_num_xl) AND (num_xxl = @Original_num_xxl) AND (num_xxxl = @Original_num_xxxl) AND (num_xxxxl = @Original_num_xxxxl) AND (sleeveOrPocket = @Original_sleeveOrPocket) AND (styleNum = @Original_styleNum OR @Original_styleNum IS NULL AND styleNum IS NULL) AND (totalPrice = @Original_totalPrice OR @Original_totalPrice IS NULL AND totalPrice IS NULL) AND (totalQty = @Original_totalQty OR @Original_totalQty IS NULL AND totalQty IS NULL) AND (type = @Original_type) AND (unitPrice = @Original_unitPrice)"; this.sqlDeleteCommand1.Connection = this.cnOrderTrackerDB; this.sqlDeleteCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_color", System.Data.SqlDbType.NVarChar, 20, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "color", System.Data.DataRowVersion.Original, null)); this.sqlDeleteCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_manufacturer", System.Data.SqlDbType.NVarChar, 40, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "manufacturer", System.Data.DataRowVersion.Original, null)); this.sqlDeleteCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_orderNumber", System.Data.SqlDbType.Int, 4, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "orderNumber", System.Data.DataRowVersion.Original, null)); this.sqlDeleteCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_num_1012", System.Data.SqlDbType.Int, 4, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "num_1012", System.Data.DataRowVersion.Original, null)); this.sqlDeleteCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_num_1416", System.Data.SqlDbType.Int, 4, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "num_1416", System.Data.DataRowVersion.Original, null)); this.sqlDeleteCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_num_24", System.Data.SqlDbType.Int, 4, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "num_24", System.Data.DataRowVersion.Original, null)); this.sqlDeleteCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_num_68", System.Data.SqlDbType.Int, 4, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "num_68", System.Data.DataRowVersion.Original, null)); this.sqlDeleteCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_num_l", System.Data.SqlDbType.Int, 4, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "num_l", System.Data.DataRowVersion.Original, null)); this.sqlDeleteCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_num_m", System.Data.SqlDbType.Int, 4, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "num_m", System.Data.DataRowVersion.Original, null)); this.sqlDeleteCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_num_other", System.Data.SqlDbType.Int, 4, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "num_other", System.Data.DataRowVersion.Original, null)); this.sqlDeleteCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_num_s", System.Data.SqlDbType.Int, 4, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "num_s", System.Data.DataRowVersion.Original, null)); this.sqlDeleteCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_num_xl", System.Data.SqlDbType.Int, 4, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "num_xl", System.Data.DataRowVersion.Original, null)); this.sqlDeleteCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_num_xxl", System.Data.SqlDbType.Int, 4, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "num_xxl", System.Data.DataRowVersion.Original, null)); this.sqlDeleteCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_num_xxxl", System.Data.SqlDbType.Int, 4, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "num_xxxl", System.Data.DataRowVersion.Original, null)); this.sqlDeleteCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_num_xxxxl", System.Data.SqlDbType.Int, 4, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "num_xxxxl", System.Data.DataRowVersion.Original, null)); this.sqlDeleteCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_sleeveOrPocket", System.Data.SqlDbType.NVarChar, 2, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "sleeveOrPocket", System.Data.DataRowVersion.Original, null)); this.sqlDeleteCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_styleNum", System.Data.SqlDbType.NVarChar, 10, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "styleNum", System.Data.DataRowVersion.Original, null)); this.sqlDeleteCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_totalPrice", System.Data.SqlDbType.Money, 8, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "totalPrice", System.Data.DataRowVersion.Original, null)); this.sqlDeleteCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_totalQty", System.Data.SqlDbType.Int, 4, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "totalQty", System.Data.DataRowVersion.Original, null)); this.sqlDeleteCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_type", System.Data.SqlDbType.NVarChar, 20, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "type", System.Data.DataRowVersion.Original, null)); this.sqlDeleteCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_unitPrice", System.Data.SqlDbType.Money, 8, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "unitPrice", System.Data.DataRowVersion.Original, null)); // // sqlInsertCommand1 // this.sqlInsertCommand1.CommandText = @"INSERT INTO dbo.ShirtOrders(orderNumber, manufacturer, color, num_24, num_68, num_1012, num_1416, num_s, num_m, num_l, num_xl, num_xxl, num_xxxl, num_xxxxl, num_other, unitPrice, styleNum, description, type, sleeveOrPocket) VALUES (@orderNumber, @manufacturer, @color, @num_24, @num_68, @num_1012, @num_1416, @num_s, @num_m, @num_l, @num_xl, @num_xxl, @num_xxxl, @num_xxxxl, @num_other, @unitPrice, @styleNum, @description, @type, @sleeveOrPocket); SELECT orderNumber, manufacturer, color, num_24, num_68, num_1012, num_1416, num_s, num_m, num_l, num_xl, num_xxl, num_xxxl, num_xxxxl, num_other, unitPrice, styleNum, description, type, sleeveOrPocket, totalQty, totalPrice FROM dbo.ShirtOrders WHERE (color = @color) AND (manufacturer = @manufacturer) AND (orderNumber = @orderNumber)"; this.sqlInsertCommand1.Connection = this.cnOrderTrackerDB; this.sqlInsertCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@orderNumber", System.Data.SqlDbType.Int, 4, "orderNumber")); this.sqlInsertCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@manufacturer", System.Data.SqlDbType.NVarChar, 40, "manufacturer")); this.sqlInsertCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@color", System.Data.SqlDbType.NVarChar, 20, "color")); this.sqlInsertCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@num_24", System.Data.SqlDbType.Int, 4, "num_24")); this.sqlInsertCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@num_68", System.Data.SqlDbType.Int, 4, "num_68")); this.sqlInsertCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@num_1012", System.Data.SqlDbType.Int, 4, "num_1012")); this.sqlInsertCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@num_1416", System.Data.SqlDbType.Int, 4, "num_1416")); this.sqlInsertCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@num_s", System.Data.SqlDbType.Int, 4, "num_s")); this.sqlInsertCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@num_m", System.Data.SqlDbType.Int, 4, "num_m")); this.sqlInsertCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@num_l", System.Data.SqlDbType.Int, 4, "num_l")); this.sqlInsertCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@num_xl", System.Data.SqlDbType.Int, 4, "num_xl")); this.sqlInsertCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@num_xxl", System.Data.SqlDbType.Int, 4, "num_xxl")); this.sqlInsertCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@num_xxxl", System.Data.SqlDbType.Int, 4, "num_xxxl")); this.sqlInsertCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@num_xxxxl", System.Data.SqlDbType.Int, 4, "num_xxxxl")); this.sqlInsertCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@num_other", System.Data.SqlDbType.Int, 4, "num_other")); this.sqlInsertCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@unitPrice", System.Data.SqlDbType.Money, 8, "unitPrice")); this.sqlInsertCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@styleNum", System.Data.SqlDbType.NVarChar, 10, "styleNum")); this.sqlInsertCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@description", System.Data.SqlDbType.NVarChar, 1073741823, "description")); this.sqlInsertCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@type", System.Data.SqlDbType.NVarChar, 20, "type")); this.sqlInsertCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@sleeveOrPocket", System.Data.SqlDbType.NVarChar, 2, "sleeveOrPocket")); // // sqlSelectCommand1 // this.sqlSelectCommand1.CommandText = @"SELECT orderNumber, manufacturer, color, num_24, num_68, num_1012, num_1416, num_s, num_m, num_l, num_xl, num_xxl, num_xxxl, num_xxxxl, num_other, unitPrice, styleNum, description, type, sleeveOrPocket, totalQty, totalPrice FROM dbo.ShirtOrders WHERE (orderNumber = @onum)"; this.sqlSelectCommand1.Connection = this.cnOrderTrackerDB; this.sqlSelectCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@onum", System.Data.SqlDbType.Int, 4, "orderNumber")); // // sqlUpdateCommand1 // this.sqlUpdateCommand1.CommandText = "UPDATE dbo.ShirtOrders SET orderNumber = @orderNumber, manufacturer = @manufactur" + "er, color = @color, num_24 = @num_24, num_68 = @num_68, num_1012 = @num_1012, nu" + "m_1416 = @num_1416, num_s = @num_s, num_m = @num_m, num_l = @num_l, num_xl = @nu" + "m_xl, num_xxl = @num_xxl, num_xxxl = @num_xxxl, num_xxxxl = @num_xxxxl, num_othe" + "r = @num_other, unitPrice = @unitPrice, styleNum = @styleNum, description = @des" + "cription, type = @type, sleeveOrPocket = @sleeveOrPocket WHERE (color = @Origina" + "l_color) AND (manufacturer = @Original_manufacturer) AND (orderNumber = @Origina" + "l_orderNumber) AND (num_1012 = @Original_num_1012) AND (num_1416 = @Original_num" + "_1416) AND (num_24 = @Original_num_24) AND (num_68 = @Original_num_68) AND (num_" + "l = @Original_num_l) AND (num_m = @Original_num_m) AND (num_other = @Original_nu" + "m_other) AND (num_s = @Original_num_s) AND (num_xl = @Original_num_xl) AND (num_" + "xxl = @Original_num_xxl) AND (num_xxxl = @Original_num_xxxl) AND (num_xxxxl = @O" + "riginal_num_xxxxl) AND (sleeveOrPocket = @Original_sleeveOrPocket) AND (styleNum" + " = @Original_styleNum OR @Original_styleNum IS NULL AND styleNum IS NULL) AND (t" + "ype = @Original_type) AND (unitPrice = @Original_unitPrice); SELECT orderNumber," + " manufacturer, color, num_24, num_68, num_1012, num_1416, num_s, num_m, num_l, n" + "um_xl, num_xxl, num_xxxl, num_xxxxl, num_other, unitPrice, styleNum, description" + ", type, sleeveOrPocket, totalQty, totalPrice FROM dbo.ShirtOrders WHERE (color =" + " @color) AND (manufacturer = @manufacturer) AND (orderNumber = @orderNumber)"; this.sqlUpdateCommand1.Connection = this.cnOrderTrackerDB; this.sqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@orderNumber", System.Data.SqlDbType.Int, 4, "orderNumber")); this.sqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@manufacturer", System.Data.SqlDbType.NVarChar, 40, "manufacturer")); this.sqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@color", System.Data.SqlDbType.NVarChar, 20, "color")); this.sqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@num_24", System.Data.SqlDbType.Int, 4, "num_24")); this.sqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@num_68", System.Data.SqlDbType.Int, 4, "num_68")); this.sqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@num_1012", System.Data.SqlDbType.Int, 4, "num_1012")); this.sqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@num_1416", System.Data.SqlDbType.Int, 4, "num_1416")); this.sqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@num_s", System.Data.SqlDbType.Int, 4, "num_s")); this.sqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@num_m", System.Data.SqlDbType.Int, 4, "num_m")); this.sqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@num_l", System.Data.SqlDbType.Int, 4, "num_l")); this.sqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@num_xl", System.Data.SqlDbType.Int, 4, "num_xl")); this.sqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@num_xxl", System.Data.SqlDbType.Int, 4, "num_xxl")); this.sqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@num_xxxl", System.Data.SqlDbType.Int, 4, "num_xxxl")); this.sqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@num_xxxxl", System.Data.SqlDbType.Int, 4, "num_xxxxl")); this.sqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@num_other", System.Data.SqlDbType.Int, 4, "num_other")); this.sqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@unitPrice", System.Data.SqlDbType.Money, 8, "unitPrice")); this.sqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@styleNum", System.Data.SqlDbType.NVarChar, 10, "styleNum")); this.sqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@description", System.Data.SqlDbType.NVarChar, 1073741823, "description")); this.sqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@type", System.Data.SqlDbType.NVarChar, 20, "type")); this.sqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@sleeveOrPocket", System.Data.SqlDbType.NVarChar, 2, "sleeveOrPocket")); this.sqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_color", System.Data.SqlDbType.NVarChar, 20, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "color", System.Data.DataRowVersion.Original, null)); this.sqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_manufacturer", System.Data.SqlDbType.NVarChar, 40, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "manufacturer", System.Data.DataRowVersion.Original, null)); this.sqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_orderNumber", System.Data.SqlDbType.Int, 4, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "orderNumber", System.Data.DataRowVersion.Original, null)); this.sqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_num_1012", System.Data.SqlDbType.Int, 4, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "num_1012", System.Data.DataRowVersion.Original, null)); this.sqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_num_1416", System.Data.SqlDbType.Int, 4, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "num_1416", System.Data.DataRowVersion.Original, null)); this.sqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_num_24", System.Data.SqlDbType.Int, 4, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "num_24", System.Data.DataRowVersion.Original, null)); this.sqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_num_68", System.Data.SqlDbType.Int, 4, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "num_68", System.Data.DataRowVersion.Original, null)); this.sqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_num_l", System.Data.SqlDbType.Int, 4, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "num_l", System.Data.DataRowVersion.Original, null)); this.sqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_num_m", System.Data.SqlDbType.Int, 4, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "num_m", System.Data.DataRowVersion.Original, null)); this.sqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_num_other", System.Data.SqlDbType.Int, 4, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "num_other", System.Data.DataRowVersion.Original, null)); this.sqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_num_s", System.Data.SqlDbType.Int, 4, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "num_s", System.Data.DataRowVersion.Original, null)); this.sqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_num_xl", System.Data.SqlDbType.Int, 4, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "num_xl", System.Data.DataRowVersion.Original, null)); this.sqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_num_xxl", System.Data.SqlDbType.Int, 4, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "num_xxl", System.Data.DataRowVersion.Original, null)); this.sqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_num_xxxl", System.Data.SqlDbType.Int, 4, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "num_xxxl", System.Data.DataRowVersion.Original, null)); this.sqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_num_xxxxl", System.Data.SqlDbType.Int, 4, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "num_xxxxl", System.Data.DataRowVersion.Original, null)); this.sqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_sleeveOrPocket", System.Data.SqlDbType.NVarChar, 2, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "sleeveOrPocket", System.Data.DataRowVersion.Original, null)); this.sqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_styleNum", System.Data.SqlDbType.NVarChar, 10, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "styleNum", System.Data.DataRowVersion.Original, null)); this.sqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_type", System.Data.SqlDbType.NVarChar, 20, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "type", System.Data.DataRowVersion.Original, null)); this.sqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_unitPrice", System.Data.SqlDbType.Money, 8, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "unitPrice", System.Data.DataRowVersion.Original, null)); // // dsShirtData // this.dsShirtData.DataSetName = "shirtData"; this.dsShirtData.Locale = new System.Globalization.CultureInfo("en-US"); // // sqlCommand1 // this.sqlCommand1.Connection = this.cnOrderTrackerDB; // // sqlCommand2 // this.sqlCommand2.CommandText = @"UPDATE dbo.Orders SET orderDate = @odate, dueDate = @dueDate, recDate = @recDate, reorderNumber = @reorderNumber, shippingMethod = @shippingMethod, artDueDate = @artDueDate, rushReorderRegular = @rushReorderRegular, orderType = @orderType, xOrderNumber = @xOrderNumber, customerNumber = @customerNumber, contactPersonNumber = @contactPersonNumber, insideRepNumber = @insideRepNumber, outsideRepNumber = @outsideRepNumber, numColorsFront = @numColorsFront, numColorsBack = @numColorsBack, numColorsSleeve = @numColorsSleeve, PMScharge = @PMScharge, setupCharge = @setupCharge, artCharge = @artCharge, rushCharge = @rushCharge, deposit = @deposit, subtotal = @subTotal, salesTax = @salesTax, shipping = @shipping, totalDue = @totalDue, balanceDue = @balanceDue WHERE (orderNumber = @onum)"; this.sqlCommand2.Connection = this.cnOrderTrackerDB; this.sqlCommand2.Parameters.Add(new System.Data.SqlClient.SqlParameter("@odate", System.Data.SqlDbType.DateTime, 8, "orderDate")); this.sqlCommand2.Parameters.Add(new System.Data.SqlClient.SqlParameter("@dueDate", System.Data.SqlDbType.DateTime, 8, "dueDate")); this.sqlCommand2.Parameters.Add(new System.Data.SqlClient.SqlParameter("@recDate", System.Data.SqlDbType.DateTime, 8, "recDate")); this.sqlCommand2.Parameters.Add(new System.Data.SqlClient.SqlParameter("@reorderNumber", System.Data.SqlDbType.Int, 4, "reorderNumber")); this.sqlCommand2.Parameters.Add(new System.Data.SqlClient.SqlParameter("@shippingMethod", System.Data.SqlDbType.NVarChar, 20, "shippingMethod")); this.sqlCommand2.Parameters.Add(new System.Data.SqlClient.SqlParameter("@artDueDate", System.Data.SqlDbType.DateTime, 8, "artDueDate")); this.sqlCommand2.Parameters.Add(new System.Data.SqlClient.SqlParameter("@rushReorderRegular", System.Data.SqlDbType.NVarChar, 1, "rushReorderRegular")); this.sqlCommand2.Parameters.Add(new System.Data.SqlClient.SqlParameter("@orderType", System.Data.SqlDbType.NVarChar, 20, "orderType")); this.sqlCommand2.Parameters.Add(new System.Data.SqlClient.SqlParameter("@xOrderNumber", System.Data.SqlDbType.Int, 4, "xOrderNumber")); this.sqlCommand2.Parameters.Add(new System.Data.SqlClient.SqlParameter("@customerNumber", System.Data.SqlDbType.VarChar, 36, "customerNumber")); this.sqlCommand2.Parameters.Add(new System.Data.SqlClient.SqlParameter("@contactPersonNumber", System.Data.SqlDbType.VarChar, 36, "contactPersonNumber")); this.sqlCommand2.Parameters.Add(new System.Data.SqlClient.SqlParameter("@insideRepNumber", System.Data.SqlDbType.VarChar, 36, "insideRepNumber")); this.sqlCommand2.Parameters.Add(new System.Data.SqlClient.SqlParameter("@outsideRepNumber", System.Data.SqlDbType.VarChar, 36, "outsideRepNumber")); this.sqlCommand2.Parameters.Add(new System.Data.SqlClient.SqlParameter("@numColorsFront", System.Data.SqlDbType.Int, 4, "numColorsFront")); this.sqlCommand2.Parameters.Add(new System.Data.SqlClient.SqlParameter("@numColorsBack", System.Data.SqlDbType.Int, 4, "numColorsBack")); this.sqlCommand2.Parameters.Add(new System.Data.SqlClient.SqlParameter("@numColorsSleeve", System.Data.SqlDbType.Int, 4, "numColorsSleeve")); this.sqlCommand2.Parameters.Add(new System.Data.SqlClient.SqlParameter("@PMScharge", System.Data.SqlDbType.Money, 8, "PMScharge")); this.sqlCommand2.Parameters.Add(new System.Data.SqlClient.SqlParameter("@setupCharge", System.Data.SqlDbType.Money, 8, "setupCharge")); this.sqlCommand2.Parameters.Add(new System.Data.SqlClient.SqlParameter("@artCharge", System.Data.SqlDbType.Money, 8, "artCharge")); this.sqlCommand2.Parameters.Add(new System.Data.SqlClient.SqlParameter("@rushCharge", System.Data.SqlDbType.Money, 8, "rushCharge")); this.sqlCommand2.Parameters.Add(new System.Data.SqlClient.SqlParameter("@deposit", System.Data.SqlDbType.Money, 8, "deposit")); this.sqlCommand2.Parameters.Add(new System.Data.SqlClient.SqlParameter("@subTotal", System.Data.SqlDbType.Money, 8, "subtotal")); this.sqlCommand2.Parameters.Add(new System.Data.SqlClient.SqlParameter("@salesTax", System.Data.SqlDbType.Money, 8, "salesTax")); this.sqlCommand2.Parameters.Add(new System.Data.SqlClient.SqlParameter("@shipping", System.Data.SqlDbType.Money, 8, "shipping")); this.sqlCommand2.Parameters.Add(new System.Data.SqlClient.SqlParameter("@totalDue", System.Data.SqlDbType.Money, 8, "totalDue")); this.sqlCommand2.Parameters.Add(new System.Data.SqlClient.SqlParameter("@balanceDue", System.Data.SqlDbType.Money, 8, "balanceDue")); this.sqlCommand2.Parameters.Add(new System.Data.SqlClient.SqlParameter("@onum", System.Data.SqlDbType.Int, 4, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "orderNumber", System.Data.DataRowVersion.Original, null)); // // adOrderInfo // this.adOrderInfo.DeleteCommand = this.sqlDeleteCommand2; this.adOrderInfo.InsertCommand = this.sqlInsertCommand2; this.adOrderInfo.SelectCommand = this.sqlSelectCommand2; this.adOrderInfo.TableMappings.AddRange(new System.Data.Common.DataTableMapping[] { new System.Data.Common.DataTableMapping("Table", "Orders", new System.Data.Common.DataColumnMapping[] { new System.Data.Common.DataColumnMapping("orderNumber", "orderNumber"), new System.Data.Common.DataColumnMapping("orderDate", "orderDate"), new System.Data.Common.DataColumnMapping("dueDate", "dueDate"), new System.Data.Common.DataColumnMapping("recDate", "recDate"), new System.Data.Common.DataColumnMapping("reorderNumber", "reorderNumber"), new System.Data.Common.DataColumnMapping("shippingMethod", "shippingMethod"), new System.Data.Common.DataColumnMapping("artDueDate", "artDueDate"), new System.Data.Common.DataColumnMapping("rushReorderRegular", "rushReorderRegular"), new System.Data.Common.DataColumnMapping("orderType", "orderType"), new System.Data.Common.DataColumnMapping("xOrderNumber", "xOrderNumber"), new System.Data.Common.DataColumnMapping("customerNumber", "customerNumber"), new System.Data.Common.DataColumnMapping("contactPersonNumber", "contactPersonNumber"), new System.Data.Common.DataColumnMapping("insideRepNumber", "insideRepNumber"), new System.Data.Common.DataColumnMapping("outsideRepNumber", "outsideRepNumber"), new System.Data.Common.DataColumnMapping("numColorsFront", "numColorsFront"), new System.Data.Common.DataColumnMapping("numColorsBack", "numColorsBack"), new System.Data.Common.DataColumnMapping("numColorsSleeve", "numColorsSleeve"), new System.Data.Common.DataColumnMapping("PMScharge", "PMScharge"), new System.Data.Common.DataColumnMapping("setupCharge", "setupCharge"), new System.Data.Common.DataColumnMapping("artCharge", "artCharge"), new System.Data.Common.DataColumnMapping("rushCharge", "rushCharge"), new System.Data.Common.DataColumnMapping("deposit", "deposit"), new System.Data.Common.DataColumnMapping("subtotal", "subtotal"), new System.Data.Common.DataColumnMapping("salesTax", "salesTax"), new System.Data.Common.DataColumnMapping("shipping", "shipping"), new System.Data.Common.DataColumnMapping("totalDue", "totalDue"), new System.Data.Common.DataColumnMapping("balanceDue", "balanceDue")})}); this.adOrderInfo.UpdateCommand = this.sqlUpdateCommand2; // // sqlDeleteCommand2 // this.sqlDeleteCommand2.CommandText = "DELETE FROM dbo.Orders WHERE (orderNumber = @Original_orderNumber) AND (PMScharge" + " = @Original_PMScharge OR @Original_PMScharge IS NULL AND PMScharge IS NULL) AND" + " (artCharge = @Original_artCharge OR @Original_artCharge IS NULL AND artCharge I" + "S NULL) AND (artDueDate = @Original_artDueDate OR @Original_artDueDate IS NULL A" + "ND artDueDate IS NULL) AND (balanceDue = @Original_balanceDue OR @Original_balan" + "ceDue IS NULL AND balanceDue IS NULL) AND (contactPersonNumber = @Original_conta" + "ctPersonNumber OR @Original_contactPersonNumber IS NULL AND contactPersonNumber " + "IS NULL) AND (customerNumber = @Original_customerNumber OR @Original_customerNum" + "ber IS NULL AND customerNumber IS NULL) AND (deposit = @Original_deposit OR @Ori" + "ginal_deposit IS NULL AND deposit IS NULL) AND (dueDate = @Original_dueDate OR @" + "Original_dueDate IS NULL AND dueDate IS NULL) AND (insideRepNumber = @Original_i" + "nsideRepNumber OR @Original_insideRepNumber IS NULL AND insideRepNumber IS NULL)" + " AND (numColorsBack = @Original_numColorsBack OR @Original_numColorsBack IS NULL" + " AND numColorsBack IS NULL) AND (numColorsFront = @Original_numColorsFront OR @O" + "riginal_numColorsFront IS NULL AND numColorsFront IS NULL) AND (numColorsSleeve " + "= @Original_numColorsSleeve OR @Original_numColorsSleeve IS NULL AND numColorsSl" + "eeve IS NULL) AND (orderDate = @Original_orderDate) AND (orderType = @Original_o" + "rderType) AND (outsideRepNumber = @Original_outsideRepNumber OR @Original_outsid" + "eRepNumber IS NULL AND outsideRepNumber IS NULL) AND (recDate = @Original_recDat" + "e OR @Original_recDate IS NULL AND recDate IS NULL) AND (reorderNumber = @Origin" + "al_reorderNumber OR @Original_reorderNumber IS NULL AND reorderNumber IS NULL) A" + "ND (rushCharge = @Original_rushCharge OR @Original_rushCharge IS NULL AND rushCh" + "arge IS NULL) AND (rushReorderRegular = @Original_rushReorderRegular) AND (sales" + "Tax = @Original_salesTax OR @Original_salesTax IS NULL AND salesTax IS NULL) AND" + " (setupCharge = @Original_setupCharge OR @Original_setupCharge IS NULL AND setup" + "Charge IS NULL) AND (shipping = @Original_shipping OR @Original_shipping IS NULL" + " AND shipping IS NULL) AND (shippingMethod = @Original_shippingMethod OR @Origin" + "al_shippingMethod IS NULL AND shippingMethod IS NULL) AND (subtotal = @Original_" + "subtotal OR @Original_subtotal IS NULL AND subtotal IS NULL) AND (totalDue = @Or" + "iginal_totalDue OR @Original_totalDue IS NULL AND totalDue IS NULL) AND (xOrderN" + "umber = @Original_xOrderNumber OR @Original_xOrderNumber IS NULL AND xOrderNumbe" + "r IS NULL)"; this.sqlDeleteCommand2.Connection = this.cnOrderTrackerDB; this.sqlDeleteCommand2.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_orderNumber", System.Data.SqlDbType.Int, 4, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "orderNumber", System.Data.DataRowVersion.Original, null)); this.sqlDeleteCommand2.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_PMScharge", System.Data.SqlDbType.Money, 8, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "PMScharge", System.Data.DataRowVersion.Original, null)); this.sqlDeleteCommand2.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_artCharge", System.Data.SqlDbType.Money, 8, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "artCharge", System.Data.DataRowVersion.Original, null)); this.sqlDeleteCommand2.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_artDueDate", System.Data.SqlDbType.DateTime, 8, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "artDueDate", System.Data.DataRowVersion.Original, null)); this.sqlDeleteCommand2.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_balanceDue", System.Data.SqlDbType.Money, 8, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "balanceDue", System.Data.DataRowVersion.Original, null)); this.sqlDeleteCommand2.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_contactPersonNumber", System.Data.SqlDbType.VarChar, 36, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "contactPersonNumber", System.Data.DataRowVersion.Original, null)); this.sqlDeleteCommand2.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_customerNumber", System.Data.SqlDbType.VarChar, 36, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "customerNumber", System.Data.DataRowVersion.Original, null)); this.sqlDeleteCommand2.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_deposit", System.Data.SqlDbType.Money, 8, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "deposit", System.Data.DataRowVersion.Original, null)); this.sqlDeleteCommand2.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_dueDate", System.Data.SqlDbType.DateTime, 8, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "dueDate", System.Data.DataRowVersion.Original, null)); this.sqlDeleteCommand2.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_insideRepNumber", System.Data.SqlDbType.VarChar, 36, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "insideRepNumber", System.Data.DataRowVersion.Original, null)); this.sqlDeleteCommand2.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_numColorsBack", System.Data.SqlDbType.Int, 4, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "numColorsBack", System.Data.DataRowVersion.Original, null)); this.sqlDeleteCommand2.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_numColorsFront", System.Data.SqlDbType.Int, 4, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "numColorsFront", System.Data.DataRowVersion.Original, null)); this.sqlDeleteCommand2.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_numColorsSleeve", System.Data.SqlDbType.Int, 4, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "numColorsSleeve", System.Data.DataRowVersion.Original, null)); this.sqlDeleteCommand2.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_orderDate", System.Data.SqlDbType.DateTime, 8, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "orderDate", System.Data.DataRowVersion.Original, null)); this.sqlDeleteCommand2.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_orderType", System.Data.SqlDbType.NVarChar, 20, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "orderType", System.Data.DataRowVersion.Original, null)); this.sqlDeleteCommand2.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_outsideRepNumber", System.Data.SqlDbType.VarChar, 36, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "outsideRepNumber", System.Data.DataRowVersion.Original, null)); this.sqlDeleteCommand2.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_recDate", System.Data.SqlDbType.DateTime, 8, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "recDate", System.Data.DataRowVersion.Original, null)); this.sqlDeleteCommand2.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_reorderNumber", System.Data.SqlDbType.Int, 4, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "reorderNumber", System.Data.DataRowVersion.Original, null)); this.sqlDeleteCommand2.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_rushCharge", System.Data.SqlDbType.Money, 8, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "rushCharge", System.Data.DataRowVersion.Original, null)); this.sqlDeleteCommand2.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_rushReorderRegular", System.Data.SqlDbType.NVarChar, 1, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "rushReorderRegular", System.Data.DataRowVersion.Original, null)); this.sqlDeleteCommand2.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_salesTax", System.Data.SqlDbType.Money, 8, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "salesTax", System.Data.DataRowVersion.Original, null)); this.sqlDeleteCommand2.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_setupCharge", System.Data.SqlDbType.Money, 8, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "setupCharge", System.Data.DataRowVersion.Original, null)); this.sqlDeleteCommand2.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_shipping", System.Data.SqlDbType.Money, 8, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "shipping", System.Data.DataRowVersion.Original, null)); this.sqlDeleteCommand2.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_shippingMethod", System.Data.SqlDbType.NVarChar, 20, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "shippingMethod", System.Data.DataRowVersion.Original, null)); this.sqlDeleteCommand2.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_subtotal", System.Data.SqlDbType.Money, 8, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "subtotal", System.Data.DataRowVersion.Original, null)); this.sqlDeleteCommand2.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_totalDue", System.Data.SqlDbType.Money, 8, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "totalDue", System.Data.DataRowVersion.Original, null)); this.sqlDeleteCommand2.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_xOrderNumber", System.Data.SqlDbType.Int, 4, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "xOrderNumber", System.Data.DataRowVersion.Original, null)); // // sqlInsertCommand2 // this.sqlInsertCommand2.CommandText = @"INSERT INTO dbo.Orders(orderNumber, orderDate, dueDate, recDate, reorderNumber, shippingMethod, artDueDate, rushReorderRegular, orderType, xOrderNumber, customerNumber, contactPersonNumber, insideRepNumber, outsideRepNumber, numColorsFront, numColorsBack, numColorsSleeve, PMScharge, setupCharge, artCharge, rushCharge, deposit, subtotal, salesTax, shipping, totalDue, balanceDue) VALUES (@orderNumber, @orderDate, @dueDate, @recDate, @reorderNumber, @shippingMethod, @artDueDate, @rushReorderRegular, @orderType, @xOrderNumber, @customerNumber, @contactPersonNumber, @insideRepNumber, @outsideRepNumber, @numColorsFront, @numColorsBack, @numColorsSleeve, @PMScharge, @setupCharge, @artCharge, @rushCharge, @deposit, @subtotal, @salesTax, @shipping, @totalDue, @balanceDue); SELECT orderNumber, orderDate, dueDate, recDate, reorderNumber, shippingMethod, artDueDate, rushReorderRegular, orderType, xOrderNumber, customerNumber, contactPersonNumber, insideRepNumber, outsideRepNumber, numColorsFront, numColorsBack, numColorsSleeve, PMScharge, setupCharge, artCharge, rushCharge, deposit, subtotal, salesTax, shipping, totalDue, balanceDue FROM dbo.Orders WHERE (orderNumber = @orderNumber)"; this.sqlInsertCommand2.Connection = this.cnOrderTrackerDB; this.sqlInsertCommand2.Parameters.Add(new System.Data.SqlClient.SqlParameter("@orderNumber", System.Data.SqlDbType.Int, 4, "orderNumber")); this.sqlInsertCommand2.Parameters.Add(new System.Data.SqlClient.SqlParameter("@orderDate", System.Data.SqlDbType.DateTime, 8, "orderDate")); this.sqlInsertCommand2.Parameters.Add(new System.Data.SqlClient.SqlParameter("@dueDate", System.Data.SqlDbType.DateTime, 8, "dueDate")); this.sqlInsertCommand2.Parameters.Add(new System.Data.SqlClient.SqlParameter("@recDate", System.Data.SqlDbType.DateTime, 8, "recDate")); this.sqlInsertCommand2.Parameters.Add(new System.Data.SqlClient.SqlParameter("@reorderNumber", System.Data.SqlDbType.Int, 4, "reorderNumber")); this.sqlInsertCommand2.Parameters.Add(new System.Data.SqlClient.SqlParameter("@shippingMethod", System.Data.SqlDbType.NVarChar, 20, "shippingMethod")); this.sqlInsertCommand2.Parameters.Add(new System.Data.SqlClient.SqlParameter("@artDueDate", System.Data.SqlDbType.DateTime, 8, "artDueDate")); this.sqlInsertCommand2.Parameters.Add(new System.Data.SqlClient.SqlParameter("@rushReorderRegular", System.Data.SqlDbType.NVarChar, 1, "rushReorderRegular")); this.sqlInsertCommand2.Parameters.Add(new System.Data.SqlClient.SqlParameter("@orderType", System.Data.SqlDbType.NVarChar, 20, "orderType")); this.sqlInsertCommand2.Parameters.Add(new System.Data.SqlClient.SqlParameter("@xOrderNumber", System.Data.SqlDbType.Int, 4, "xOrderNumber")); this.sqlInsertCommand2.Parameters.Add(new System.Data.SqlClient.SqlParameter("@customerNumber", System.Data.SqlDbType.VarChar, 36, "customerNumber")); this.sqlInsertCommand2.Parameters.Add(new System.Data.SqlClient.SqlParameter("@contactPersonNumber", System.Data.SqlDbType.VarChar, 36, "contactPersonNumber")); this.sqlInsertCommand2.Parameters.Add(new System.Data.SqlClient.SqlParameter("@insideRepNumber", System.Data.SqlDbType.VarChar, 36, "insideRepNumber")); this.sqlInsertCommand2.Parameters.Add(new System.Data.SqlClient.SqlParameter("@outsideRepNumber", System.Data.SqlDbType.VarChar, 36, "outsideRepNumber")); this.sqlInsertCommand2.Parameters.Add(new System.Data.SqlClient.SqlParameter("@numColorsFront", System.Data.SqlDbType.Int, 4, "numColorsFront")); this.sqlInsertCommand2.Parameters.Add(new System.Data.SqlClient.SqlParameter("@numColorsBack", System.Data.SqlDbType.Int, 4, "numColorsBack")); this.sqlInsertCommand2.Parameters.Add(new System.Data.SqlClient.SqlParameter("@numColorsSleeve", System.Data.SqlDbType.Int, 4, "numColorsSleeve")); this.sqlInsertCommand2.Parameters.Add(new System.Data.SqlClient.SqlParameter("@PMScharge", System.Data.SqlDbType.Money, 8, "PMScharge")); this.sqlInsertCommand2.Parameters.Add(new System.Data.SqlClient.SqlParameter("@setupCharge", System.Data.SqlDbType.Money, 8, "setupCharge")); this.sqlInsertCommand2.Parameters.Add(new System.Data.SqlClient.SqlParameter("@artCharge", System.Data.SqlDbType.Money, 8, "artCharge")); this.sqlInsertCommand2.Parameters.Add(new System.Data.SqlClient.SqlParameter("@rushCharge", System.Data.SqlDbType.Money, 8, "rushCharge")); this.sqlInsertCommand2.Parameters.Add(new System.Data.SqlClient.SqlParameter("@deposit", System.Data.SqlDbType.Money, 8, "deposit")); this.sqlInsertCommand2.Parameters.Add(new System.Data.SqlClient.SqlParameter("@subtotal", System.Data.SqlDbType.Money, 8, "subtotal")); this.sqlInsertCommand2.Parameters.Add(new System.Data.SqlClient.SqlParameter("@salesTax", System.Data.SqlDbType.Money, 8, "salesTax")); this.sqlInsertCommand2.Parameters.Add(new System.Data.SqlClient.SqlParameter("@shipping", System.Data.SqlDbType.Money, 8, "shipping")); this.sqlInsertCommand2.Parameters.Add(new System.Data.SqlClient.SqlParameter("@totalDue", System.Data.SqlDbType.Money, 8, "totalDue")); this.sqlInsertCommand2.Parameters.Add(new System.Data.SqlClient.SqlParameter("@balanceDue", System.Data.SqlDbType.Money, 8, "balanceDue")); // // sqlSelectCommand2 // this.sqlSelectCommand2.CommandText = @"SELECT orderNumber, orderDate, dueDate, recDate, reorderNumber, shippingMethod, artDueDate, rushReorderRegular, orderType, xOrderNumber, customerNumber, contactPersonNumber, insideRepNumber, outsideRepNumber, numColorsFront, numColorsBack, numColorsSleeve, PMScharge, setupCharge, artCharge, rushCharge, deposit, subtotal, salesTax, shipping, totalDue, balanceDue FROM dbo.Orders WHERE (orderNumber = @onum)"; this.sqlSelectCommand2.Connection = this.cnOrderTrackerDB; this.sqlSelectCommand2.Parameters.Add(new System.Data.SqlClient.SqlParameter("@onum", System.Data.SqlDbType.Int, 4, "orderNumber")); // // sqlUpdateCommand2 // this.sqlUpdateCommand2.CommandText = "UPDATE dbo.Orders SET orderNumber = @orderNumber, orderDate = @orderDate, dueDate" + " = @dueDate, recDate = @recDate, reorderNumber = @reorderNumber, shippingMethod " + "= @shippingMethod, artDueDate = @artDueDate, rushReorderRegular = @rushReorderRe" + "gular, orderType = @orderType, xOrderNumber = @xOrderNumber, customerNumber = @c" + "ustomerNumber, contactPersonNumber = @contactPersonNumber, insideRepNumber = @in" + "sideRepNumber, outsideRepNumber = @outsideRepNumber, numColorsFront = @numColors" + "Front, numColorsBack = @numColorsBack, numColorsSleeve = @numColorsSleeve, PMSch" + "arge = @PMScharge, setupCharge = @setupCharge, artCharge = @artCharge, rushCharg" + "e = @rushCharge, deposit = @deposit, subtotal = @subtotal, salesTax = @salesTax," + " shipping = @shipping, totalDue = @totalDue, balanceDue = @balanceDue WHERE (ord" + "erNumber = @Original_orderNumber) AND (PMScharge = @Original_PMScharge OR @Origi" + "nal_PMScharge IS NULL AND PMScharge IS NULL) AND (artCharge = @Original_artCharg" + "e OR @Original_artCharge IS NULL AND artCharge IS NULL) AND (artDueDate = @Origi" + "nal_artDueDate OR @Original_artDueDate IS NULL AND artDueDate IS NULL) AND (bala" + "nceDue = @Original_balanceDue OR @Original_balanceDue IS NULL AND balanceDue IS " + "NULL) AND (contactPersonNumber = @Original_contactPersonNumber OR @Original_cont" + "actPersonNumber IS NULL AND contactPersonNumber IS NULL) AND (customerNumber = @" + "Original_customerNumber OR @Original_customerNumber IS NULL AND customerNumber I" + "S NULL) AND (deposit = @Original_deposit OR @Original_deposit IS NULL AND deposi" + "t IS NULL) AND (dueDate = @Original_dueDate OR @Original_dueDate IS NULL AND due" + "Date IS NULL) AND (insideRepNumber = @Original_insideRepNumber OR @Original_insi" + "deRepNumber IS NULL AND insideRepNumber IS NULL) AND (numColorsBack = @Original_" + "numColorsBack OR @Original_numColorsBack IS NULL AND numColorsBack IS NULL) AND " + "(numColorsFront = @Original_numColorsFront OR @Original_numColorsFront IS NULL A" + "ND numColorsFront IS NULL) AND (numColorsSleeve = @Original_numColorsSleeve OR @" + "Original_numColorsSleeve IS NULL AND numColorsSleeve IS NULL) AND (orderDate = @" + "Original_orderDate) AND (orderType = @Original_orderType) AND (outsideRepNumber " + "= @Original_outsideRepNumber OR @Original_outsideRepNumber IS NULL AND outsideRe" + "pNumber IS NULL) AND (recDate = @Original_recDate OR @Original_recDate IS NULL A" + "ND recDate IS NULL) AND (reorderNumber = @Original_reorderNumber OR @Original_re" + "orderNumber IS NULL AND reorderNumber IS NULL) AND (rushCharge = @Original_rushC" + "harge OR @Original_rushCharge IS NULL AND rushCharge IS NULL) AND (rushReorderRe" + "gular = @Original_rushReorderRegular) AND (salesTax = @Original_salesTax OR @Ori" + "ginal_salesTax IS NULL AND salesTax IS NULL) AND (setupCharge = @Original_setupC" + "harge OR @Original_setupCharge IS NULL AND setupCharge IS NULL) AND (shipping = " + "@Original_shipping OR @Original_shipping IS NULL AND shipping IS NULL) AND (ship" + "pingMethod = @Original_shippingMethod OR @Original_shippingMethod IS NULL AND sh" + "ippingMethod IS NULL) AND (subtotal = @Original_subtotal OR @Original_subtotal I" + "S NULL AND subtotal IS NULL) AND (totalDue = @Original_totalDue OR @Original_tot" + "alDue IS NULL AND totalDue IS NULL) AND (xOrderNumber = @Original_xOrderNumber O" + "R @Original_xOrderNumber IS NULL AND xOrderNumber IS NULL); SELECT orderNumber, " + "orderDate, dueDate, recDate, reorderNumber, shippingMethod, artDueDate, rushReor" + "derRegular, orderType, xOrderNumber, customerNumber, contactPersonNumber, inside" + "RepNumber, outsideRepNumber, numColorsFront, numColorsBack, numColorsSleeve, PMS" + "charge, setupCharge, artCharge, rushCharge, deposit, subtotal, salesTax, shippin" + "g, totalDue, balanceDue FROM dbo.Orders WHERE (orderNumber = @orderNumber)"; this.sqlUpdateCommand2.Connection = this.cnOrderTrackerDB; this.sqlUpdateCommand2.Parameters.Add(new System.Data.SqlClient.SqlParameter("@orderNumber", System.Data.SqlDbType.Int, 4, "orderNumber")); this.sqlUpdateCommand2.Parameters.Add(new System.Data.SqlClient.SqlParameter("@orderDate", System.Data.SqlDbType.DateTime, 8, "orderDate")); this.sqlUpdateCommand2.Parameters.Add(new System.Data.SqlClient.SqlParameter("@dueDate", System.Data.SqlDbType.DateTime, 8, "dueDate")); this.sqlUpdateCommand2.Parameters.Add(new System.Data.SqlClient.SqlParameter("@recDate", System.Data.SqlDbType.DateTime, 8, "recDate")); this.sqlUpdateCommand2.Parameters.Add(new System.Data.SqlClient.SqlParameter("@reorderNumber", System.Data.SqlDbType.Int, 4, "reorderNumber")); this.sqlUpdateCommand2.Parameters.Add(new System.Data.SqlClient.SqlParameter("@shippingMethod", System.Data.SqlDbType.NVarChar, 20, "shippingMethod")); this.sqlUpdateCommand2.Parameters.Add(new System.Data.SqlClient.SqlParameter("@artDueDate", System.Data.SqlDbType.DateTime, 8, "artDueDate")); this.sqlUpdateCommand2.Parameters.Add(new System.Data.SqlClient.SqlParameter("@rushReorderRegular", System.Data.SqlDbType.NVarChar, 1, "rushReorderRegular")); this.sqlUpdateCommand2.Parameters.Add(new System.Data.SqlClient.SqlParameter("@orderType", System.Data.SqlDbType.NVarChar, 20, "orderType")); this.sqlUpdateCommand2.Parameters.Add(new System.Data.SqlClient.SqlParameter("@xOrderNumber", System.Data.SqlDbType.Int, 4, "xOrderNumber")); this.sqlUpdateCommand2.Parameters.Add(new System.Data.SqlClient.SqlParameter("@customerNumber", System.Data.SqlDbType.VarChar, 36, "customerNumber")); this.sqlUpdateCommand2.Parameters.Add(new System.Data.SqlClient.SqlParameter("@contactPersonNumber", System.Data.SqlDbType.VarChar, 36, "contactPersonNumber")); this.sqlUpdateCommand2.Parameters.Add(new System.Data.SqlClient.SqlParameter("@insideRepNumber", System.Data.SqlDbType.VarChar, 36, "insideRepNumber")); this.sqlUpdateCommand2.Parameters.Add(new System.Data.SqlClient.SqlParameter("@outsideRepNumber", System.Data.SqlDbType.VarChar, 36, "outsideRepNumber")); this.sqlUpdateCommand2.Parameters.Add(new System.Data.SqlClient.SqlParameter("@numColorsFront", System.Data.SqlDbType.Int, 4, "numColorsFront")); this.sqlUpdateCommand2.Parameters.Add(new System.Data.SqlClient.SqlParameter("@numColorsBack", System.Data.SqlDbType.Int, 4, "numColorsBack")); this.sqlUpdateCommand2.Parameters.Add(new System.Data.SqlClient.SqlParameter("@numColorsSleeve", System.Data.SqlDbType.Int, 4, "numColorsSleeve")); this.sqlUpdateCommand2.Parameters.Add(new System.Data.SqlClient.SqlParameter("@PMScharge", System.Data.SqlDbType.Money, 8, "PMScharge")); this.sqlUpdateCommand2.Parameters.Add(new System.Data.SqlClient.SqlParameter("@setupCharge", System.Data.SqlDbType.Money, 8, "setupCharge")); this.sqlUpdateCommand2.Parameters.Add(new System.Data.SqlClient.SqlParameter("@artCharge", System.Data.SqlDbType.Money, 8, "artCharge")); this.sqlUpdateCommand2.Parameters.Add(new System.Data.SqlClient.SqlParameter("@rushCharge", System.Data.SqlDbType.Money, 8, "rushCharge")); this.sqlUpdateCommand2.Parameters.Add(new System.Data.SqlClient.SqlParameter("@deposit", System.Data.SqlDbType.Money, 8, "deposit")); this.sqlUpdateCommand2.Parameters.Add(new System.Data.SqlClient.SqlParameter("@subtotal", System.Data.SqlDbType.Money, 8, "subtotal")); this.sqlUpdateCommand2.Parameters.Add(new System.Data.SqlClient.SqlParameter("@salesTax", System.Data.SqlDbType.Money, 8, "salesTax")); this.sqlUpdateCommand2.Parameters.Add(new System.Data.SqlClient.SqlParameter("@shipping", System.Data.SqlDbType.Money, 8, "shipping")); this.sqlUpdateCommand2.Parameters.Add(new System.Data.SqlClient.SqlParameter("@totalDue", System.Data.SqlDbType.Money, 8, "totalDue")); this.sqlUpdateCommand2.Parameters.Add(new System.Data.SqlClient.SqlParameter("@balanceDue", System.Data.SqlDbType.Money, 8, "balanceDue")); this.sqlUpdateCommand2.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_orderNumber", System.Data.SqlDbType.Int, 4, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "orderNumber", System.Data.DataRowVersion.Original, null)); this.sqlUpdateCommand2.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_PMScharge", System.Data.SqlDbType.Money, 8, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "PMScharge", System.Data.DataRowVersion.Original, null)); this.sqlUpdateCommand2.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_artCharge", System.Data.SqlDbType.Money, 8, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "artCharge", System.Data.DataRowVersion.Original, null)); this.sqlUpdateCommand2.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_artDueDate", System.Data.SqlDbType.DateTime, 8, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "artDueDate", System.Data.DataRowVersion.Original, null)); this.sqlUpdateCommand2.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_balanceDue", System.Data.SqlDbType.Money, 8, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "balanceDue", System.Data.DataRowVersion.Original, null)); this.sqlUpdateCommand2.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_contactPersonNumber", System.Data.SqlDbType.VarChar, 36, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "contactPersonNumber", System.Data.DataRowVersion.Original, null)); this.sqlUpdateCommand2.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_customerNumber", System.Data.SqlDbType.VarChar, 36, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "customerNumber", System.Data.DataRowVersion.Original, null)); this.sqlUpdateCommand2.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_deposit", System.Data.SqlDbType.Money, 8, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "deposit", System.Data.DataRowVersion.Original, null)); this.sqlUpdateCommand2.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_dueDate", System.Data.SqlDbType.DateTime, 8, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "dueDate", System.Data.DataRowVersion.Original, null)); this.sqlUpdateCommand2.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_insideRepNumber", System.Data.SqlDbType.VarChar, 36, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "insideRepNumber", System.Data.DataRowVersion.Original, null)); this.sqlUpdateCommand2.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_numColorsBack", System.Data.SqlDbType.Int, 4, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "numColorsBack", System.Data.DataRowVersion.Original, null)); this.sqlUpdateCommand2.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_numColorsFront", System.Data.SqlDbType.Int, 4, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "numColorsFront", System.Data.DataRowVersion.Original, null)); this.sqlUpdateCommand2.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_numColorsSleeve", System.Data.SqlDbType.Int, 4, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "numColorsSleeve", System.Data.DataRowVersion.Original, null)); this.sqlUpdateCommand2.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_orderDate", System.Data.SqlDbType.DateTime, 8, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "orderDate", System.Data.DataRowVersion.Original, null)); this.sqlUpdateCommand2.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_orderType", System.Data.SqlDbType.NVarChar, 20, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "orderType", System.Data.DataRowVersion.Original, null)); this.sqlUpdateCommand2.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_outsideRepNumber", System.Data.SqlDbType.VarChar, 36, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "outsideRepNumber", System.Data.DataRowVersion.Original, null)); this.sqlUpdateCommand2.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_recDate", System.Data.SqlDbType.DateTime, 8, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "recDate", System.Data.DataRowVersion.Original, null)); this.sqlUpdateCommand2.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_reorderNumber", System.Data.SqlDbType.Int, 4, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "reorderNumber", System.Data.DataRowVersion.Original, null)); this.sqlUpdateCommand2.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_rushCharge", System.Data.SqlDbType.Money, 8, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "rushCharge", System.Data.DataRowVersion.Original, null)); this.sqlUpdateCommand2.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_rushReorderRegular", System.Data.SqlDbType.NVarChar, 1, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "rushReorderRegular", System.Data.DataRowVersion.Original, null)); this.sqlUpdateCommand2.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_salesTax", System.Data.SqlDbType.Money, 8, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "salesTax", System.Data.DataRowVersion.Original, null)); this.sqlUpdateCommand2.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_setupCharge", System.Data.SqlDbType.Money, 8, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "setupCharge", System.Data.DataRowVersion.Original, null)); this.sqlUpdateCommand2.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_shipping", System.Data.SqlDbType.Money, 8, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "shipping", System.Data.DataRowVersion.Original, null)); this.sqlUpdateCommand2.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_shippingMethod", System.Data.SqlDbType.NVarChar, 20, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "shippingMethod", System.Data.DataRowVersion.Original, null)); this.sqlUpdateCommand2.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_subtotal", System.Data.SqlDbType.Money, 8, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "subtotal", System.Data.DataRowVersion.Original, null)); this.sqlUpdateCommand2.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_totalDue", System.Data.SqlDbType.Money, 8, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "totalDue", System.Data.DataRowVersion.Original, null)); this.sqlUpdateCommand2.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_xOrderNumber", System.Data.SqlDbType.Int, 4, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "xOrderNumber", System.Data.DataRowVersion.Original, null)); // // dsOrderData // this.dsOrderData.DataSetName = "OrderData"; this.dsOrderData.Locale = new System.Globalization.CultureInfo("en-US"); // // sqlDataAdapter2 // this.sqlDataAdapter2.InsertCommand = this.sqlInsertCommand3; this.sqlDataAdapter2.SelectCommand = this.sqlSelectCommand3; this.sqlDataAdapter2.TableMappings.AddRange(new System.Data.Common.DataTableMapping[] { new System.Data.Common.DataTableMapping("Table", "orderTypes", new System.Data.Common.DataColumnMapping[] { new System.Data.Common.DataColumnMapping("Type", "Type")})}); // // sqlInsertCommand3 // this.sqlInsertCommand3.CommandText = "INSERT INTO dbo.orderTypes(Type) VALUES (@Type); SELECT Type FROM dbo.orderTypes " + "WHERE (Type = @Type)"; this.sqlInsertCommand3.Connection = this.cnOrderTrackerDB; this.sqlInsertCommand3.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Type", System.Data.SqlDbType.VarChar, 50, "Type")); // // sqlSelectCommand3 // this.sqlSelectCommand3.CommandText = "SELECT Type FROM dbo.orderTypes"; this.sqlSelectCommand3.Connection = this.cnOrderTrackerDB; // // sqlDataAdapter3 // this.sqlDataAdapter3.SelectCommand = this.sqlSelectCommand4; this.sqlDataAdapter3.TableMappings.AddRange(new System.Data.Common.DataTableMapping[] { new System.Data.Common.DataTableMapping("Table", "Speed", new System.Data.Common.DataColumnMapping[] { new System.Data.Common.DataColumnMapping("Speed", "Speed")})}); // // sqlSelectCommand4 // this.sqlSelectCommand4.CommandText = "SELECT Speed FROM dbo.Speed"; this.sqlSelectCommand4.Connection = this.cnOrderTrackerDB; // // dsSpeedData // this.dsSpeedData.DataSetName = "SpeedData"; this.dsSpeedData.Locale = new System.Globalization.CultureInfo("en-US"); // // dsOrderTypes // this.dsOrderTypes.DataSetName = "OrderTypes"; this.dsOrderTypes.Locale = new System.Globalization.CultureInfo("en-US"); this.Load += new System.EventHandler(this.Page_Load); ((System.ComponentModel.ISupportInitialize)(this.dsShirtData)).EndInit(); ((System.ComponentModel.ISupportInitialize)(this.dsOrderData)).EndInit(); ((System.ComponentModel.ISupportInitialize)(this.dsSpeedData)).EndInit(); ((System.ComponentModel.ISupportInitialize)(this.dsOrderTypes)).EndInit(); }