/// <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.adOrdersPending = new System.Data.SqlClient.SqlDataAdapter();
this.sqlSelectCommand1 = new System.Data.SqlClient.SqlCommand();
this.dsOrdersPending = new OrderTrackerv2.HOOemployees.OrdersPendingData();
((System.ComponentModel.ISupportInitialize)(this.dsOrdersPending)).BeginInit();
//
// cnOrderTrackerDB
//
this.cnOrderTrackerDB.ConnectionString = ((string)(configurationAppSettings.GetValue("cnOrderTrackerDB.ConnectionString", typeof(string))));
//
// adOrdersPending
//
this.adOrdersPending.SelectCommand = this.sqlSelectCommand1;
this.adOrdersPending.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("dueDate", "dueDate"),
new System.Data.Common.DataColumnMapping("orderDate", "orderDate"),
new System.Data.Common.DataColumnMapping("name", "name"),
new System.Data.Common.DataColumnMapping("orderType", "orderType"),
new System.Data.Common.DataColumnMapping("rushReorderRegular", "rushReorderRegular"),
new System.Data.Common.DataColumnMapping("artFinished", "artFinished"),
new System.Data.Common.DataColumnMapping("productionFinished", "productionFinished"),
new System.Data.Common.DataColumnMapping("orderFinished", "orderFinished")})});
//
// sqlSelectCommand1
//
this.sqlSelectCommand1.CommandText = @"SELECT dbo.Orders.orderNumber, dbo.Orders.dueDate, dbo.Orders.orderDate, dbo.Customers.name, dbo.Orders.orderType, dbo.Orders.rushReorderRegular, dbo.Orders.artFinished, dbo.Orders.productionFinished, dbo.Orders.orderFinished FROM dbo.Orders INNER JOIN dbo.Customers ON dbo.Orders.customerNumber = dbo.Customers.SID WHERE (dbo.Orders.insideRepNumber = @uid) OR (dbo.Orders.outsideRepNumber = @uid)";
this.sqlSelectCommand1.Connection = this.cnOrderTrackerDB;
this.sqlSelectCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@uid", System.Data.SqlDbType.VarChar, 36, "insideRepNumber"));
//
// dsOrdersPending
//
this.dsOrdersPending.DataSetName = "OrdersPendingData";
this.dsOrdersPending.Locale = new System.Globalization.CultureInfo("en-US");
this.Load += new System.EventHandler(this.Page_Load);
((System.ComponentModel.ISupportInitialize)(this.dsOrdersPending)).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.adOrdersPending = new System.Data.SqlClient.SqlDataAdapter();
this.sqlSelectCommand1 = new System.Data.SqlClient.SqlCommand();
this.dsOrdersPending = new OrderTrackerv2.HOOemployees.OrdersPendingData();
this.adProductionPending = new System.Data.SqlClient.SqlDataAdapter();
this.sqlSelectCommand2 = new System.Data.SqlClient.SqlCommand();
this.dsProductionPending = new OrderTrackerv2.HOOemployees.ProdData();
this.adArtPending = new System.Data.SqlClient.SqlDataAdapter();
this.sqlSelectCommand3 = new System.Data.SqlClient.SqlCommand();
this.dsArtPending = new OrderTrackerv2.HOOemployees.ArtPendingData();
this.adManagementPending = new System.Data.SqlClient.SqlDataAdapter();
this.sqlSelectCommand4 = new System.Data.SqlClient.SqlCommand();
this.dsManagementPending = new OrderTrackerv2.HOOemployees.ManagementPendingData();
((System.ComponentModel.ISupportInitialize)(this.dsOrdersPending)).BeginInit();
((System.ComponentModel.ISupportInitialize)(this.dsProductionPending)).BeginInit();
((System.ComponentModel.ISupportInitialize)(this.dsArtPending)).BeginInit();
((System.ComponentModel.ISupportInitialize)(this.dsManagementPending)).BeginInit();
//
// cnOrderTrackerDB
//
this.cnOrderTrackerDB.ConnectionString = ((string)(configurationAppSettings.GetValue("cnOrderTrackerDB.ConnectionString", typeof(string))));
//
// adOrdersPending
//
this.adOrdersPending.SelectCommand = this.sqlSelectCommand1;
this.adOrdersPending.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("dueDate", "dueDate"),
new System.Data.Common.DataColumnMapping("orderDate", "orderDate"),
new System.Data.Common.DataColumnMapping("name", "name"),
new System.Data.Common.DataColumnMapping("orderType", "orderType"),
new System.Data.Common.DataColumnMapping("rushReorderRegular", "rushReorderRegular"),
new System.Data.Common.DataColumnMapping("artFinished", "artFinished"),
new System.Data.Common.DataColumnMapping("productionFinished", "productionFinished"),
new System.Data.Common.DataColumnMapping("orderFinished", "orderFinished")})});
//
// sqlSelectCommand1
//
this.sqlSelectCommand1.CommandText = @"SELECT dbo.Orders.orderNumber, dbo.Orders.dueDate, dbo.Orders.orderDate, dbo.Customers.name, dbo.Orders.orderType, dbo.Orders.rushReorderRegular, dbo.Orders.artFinished, dbo.Orders.productionFinished, dbo.Orders.orderFinished FROM dbo.Orders INNER JOIN dbo.Customers ON dbo.Orders.customerNumber = dbo.Customers.SID WHERE (dbo.Orders.insideRepNumber = @uid) OR (dbo.Orders.outsideRepNumber = @uid)";
this.sqlSelectCommand1.Connection = this.cnOrderTrackerDB;
this.sqlSelectCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@uid", System.Data.SqlDbType.VarChar, 36, "insideRepNumber"));
//
// dsOrdersPending
//
this.dsOrdersPending.DataSetName = "OrdersPendingData";
this.dsOrdersPending.Locale = new System.Globalization.CultureInfo("en-US");
//
// adProductionPending
//
this.adProductionPending.SelectCommand = this.sqlSelectCommand2;
this.adProductionPending.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("dueDate", "dueDate"),
new System.Data.Common.DataColumnMapping("orderDate", "orderDate"),
new System.Data.Common.DataColumnMapping("artDueDate", "artDueDate"),
new System.Data.Common.DataColumnMapping("rushReorderRegular", "rushReorderRegular"),
new System.Data.Common.DataColumnMapping("customerNumber", "customerNumber"),
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("artFinished", "artFinished"),
new System.Data.Common.DataColumnMapping("productionFinished", "productionFinished"),
new System.Data.Common.DataColumnMapping("orderFinished", "orderFinished")})});
//
// sqlSelectCommand2
//
this.sqlSelectCommand2.CommandText = "SELECT orderNumber, dueDate, orderDate, artDueDate, rushReorderRegular, customerN" +
"umber, numColorsFront, numColorsBack, numColorsSleeve, artFinished, productionFi" +
"nished, orderFinished FROM dbo.Orders WHERE (productionFinished = 0)";
this.sqlSelectCommand2.Connection = this.cnOrderTrackerDB;
//
// dsProductionPending
//
this.dsProductionPending.DataSetName = "ProdData";
this.dsProductionPending.Locale = new System.Globalization.CultureInfo("en-US");
//
// adArtPending
//
this.adArtPending.SelectCommand = this.sqlSelectCommand3;
this.adArtPending.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("dueDate", "dueDate"),
new System.Data.Common.DataColumnMapping("reorderNumber", "reorderNumber"),
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("customerNumber", "customerNumber"),
new System.Data.Common.DataColumnMapping("artFinished", "artFinished"),
new System.Data.Common.DataColumnMapping("productionFinished", "productionFinished"),
new System.Data.Common.DataColumnMapping("orderFinished", "orderFinished")})});
//
// sqlSelectCommand3
//
this.sqlSelectCommand3.CommandText = "SELECT orderNumber, dueDate, reorderNumber, artDueDate, rushReorderRegular, order" +
"Type, customerNumber, artFinished, productionFinished, orderFinished FROM dbo.Or" +
"ders WHERE (artFinished = 0)";
this.sqlSelectCommand3.Connection = this.cnOrderTrackerDB;
//
// dsArtPending
//
this.dsArtPending.DataSetName = "ArtPendingData";
this.dsArtPending.Locale = new System.Globalization.CultureInfo("en-US");
//
// adManagementPending
//
this.adManagementPending.SelectCommand = this.sqlSelectCommand4;
this.adManagementPending.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("rushReorderRegular", "rushReorderRegular"),
new System.Data.Common.DataColumnMapping("orderType", "orderType"),
new System.Data.Common.DataColumnMapping("customerNumber", "customerNumber"),
new System.Data.Common.DataColumnMapping("totalDue", "totalDue"),
new System.Data.Common.DataColumnMapping("balanceDue", "balanceDue"),
new System.Data.Common.DataColumnMapping("artFinished", "artFinished"),
new System.Data.Common.DataColumnMapping("productionFinished", "productionFinished"),
new System.Data.Common.DataColumnMapping("orderFinished", "orderFinished")})});
//
// sqlSelectCommand4
//
this.sqlSelectCommand4.CommandText = "SELECT orderNumber, orderDate, dueDate, recDate, rushReorderRegular, orderType, c" +
"ustomerNumber, totalDue, balanceDue, artFinished, productionFinished, orderFinis" +
"hed FROM dbo.Orders WHERE (balanceDue < totalDue)";
this.sqlSelectCommand4.Connection = this.cnOrderTrackerDB;
//
// dsManagementPending
//
this.dsManagementPending.DataSetName = "ManagementPendingData";
this.dsManagementPending.Locale = new System.Globalization.CultureInfo("en-US");
this.Load += new System.EventHandler(this.Page_Load);
((System.ComponentModel.ISupportInitialize)(this.dsOrdersPending)).EndInit();
((System.ComponentModel.ISupportInitialize)(this.dsProductionPending)).EndInit();
((System.ComponentModel.ISupportInitialize)(this.dsArtPending)).EndInit();
((System.ComponentModel.ISupportInitialize)(this.dsManagementPending)).EndInit();
}
