private void loadOrderDataSession()
{
dummyOrderData1 = (OrderTrackerv2.HOOemployees.DummyOrderData)Session["orderDS"];
foreach( DataRow row in dummyOrderData1.Orders.Rows )
{
if( row["insideRepNumber"].ToString() != Page.User.Identity.Name.ToString() &&
row["outsideRepNumber"].ToString() != Page.User.Identity.Name.ToString() )
return;
txtDate.Text = row["orderDate"].ToString().Split( new Char[] {' '} )[0];
if( row["dueDate"].ToString().Split( new Char[] {' '} )[0] != null )
txtDueDate.Text = row["dueDate"].ToString().Split( new Char[] {' '} )[0];
if( row["reorderNumber"].ToString() != string.Empty )
txtReorderNum.Text = row["reorderNumber"].ToString();
if( row["xOrderNumber"].ToString() != string.Empty )
txtXOrderNum.Text = row["xOrderNumber"].ToString();
if( row["shippingMethod"].ToString() != string.Empty )
txtShipping.Text = row["shippingMethod"].ToString();
//eventually change the type method to deal with the drop down
if( row["orderType"].ToString() != string.Empty )
{
if( cbType.Items.FindByValue( row["orderType"].ToString().Trim() ) != null )
cbType.SelectedValue = row["orderType"].ToString().Trim();
}
if( row["rushReorderRegular"].ToString() != string.Empty )
{
if( cbRushRegReorder.Items.FindByValue( row["rushReorderRegular"].ToString().Trim() ) != null )
cbRushRegReorder.SelectedValue = row["rushReorderRegular"].ToString().Trim();
}
if( row["artDueDate"].ToString() != string.Empty )
txtArtDueDate.Text = row["artDueDate"].ToString().Split( new Char[] {' '} )[0];
if( row["customerNumber"].ToString() != string.Empty )
{
customerNum = row["customerNumber"].ToString();
Session["SelectedCustomer"] = customerNum;
}
else
customerNum = null;
if( row["artCharge"].ToString() != string.Empty )
txtArtCharge.Text = row["artCharge"].ToString();
if( row["setupCharge"].ToString() != string.Empty )
txtSetUpCharge.Text = row["setupCharge"].ToString();
if( row["PMSCharge"].ToString() != string.Empty )
txtPMSCharge.Text = row["PMSCharge"].ToString();
if( row["rushCharge"].ToString() != string.Empty )
txtRushCharge.Text = row["rushCharge"].ToString();
if( row["contactPersonNumber"].ToString() != string.Empty )
{
contactNum = row["contactPersonNumber"].ToString();
Session["SelectedContact"] = contactNum;
}
else
{
contactNum = null;
Session["SelectedContact"] = "thereisnocontact";
}
if( row["deposit"].ToString() != string.Empty )
txtDeposit.Text = row["deposit"].ToString();
if( row["subtotal"].ToString() != string.Empty )
txtSubTotal.Text = row["subtotal"].ToString();
if( row["salesTax"].ToString() != string.Empty )
txtSalesTax.Text = row["salesTax"].ToString();
if( row["shipping"].ToString() != string.Empty )
txtShippingAmt.Text = row["shipping"].ToString();
if( row["totalDue"].ToString() != string.Empty )
txtTotalDue.Text = row["totalDue"].ToString();
if( row["balanceDue"].ToString() != string.Empty )
txtBalanceDue.Text = row["balanceDue"].ToString();
if( row["insideRepNumber"].ToString() != string.Empty )
txtInsideRep.Text = row["insideRepNumber"].ToString();
if( row["outsideRepNumber"].ToString() != string.Empty )
txtOutsideRep.Text = row["outsideRepNumber"].ToString();
if( row["numColorsFront"].ToString() != string.Empty )
txtColorsFront.Text = row["numColorsFront"].ToString();
if( row["numColorsBack"].ToString() != string.Empty )
txtColorsBack.Text = row["numColorsBack"].ToString();
if( row["numColorsSleeve"].ToString() != string.Empty )
txtColorsSleeve.Text = row["numColorsSleeve"].ToString();
if( row["artFinished"].ToString() == bool.TrueString )
artApproved.Checked = true;
if( row["productionFinished"].ToString() == bool.TrueString )
productionFinished.Checked = true;
if( row["orderFinished"].ToString() == bool.TrueString )
orderFinished.Checked = true;
}
}
/// <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();
}
