private void button_MID_view_updateLS_Click(object sender, EventArgs e)
{
ConnectToMySQL dbc = new ConnectToMySQL(user_id_lbl.Text, user_hash_lbl.Text);
FormFunctions fFunc = new FormFunctions(user_id_lbl.Text, user_hash_lbl.Text);
List<string> machines = new List<string>();
machines.AddRange(fFunc.getComboItems("deptID", "3", "machine_name", "machines", _order_by: "machine_name"));
//machines.AddRange(fFunc.getComboItems("deptID", "4", "machine_name", "machines", _order_by: "machine_name"));
machines.AddRange(fFunc.getComboItems("deptID", "5", "machine_name", "machines", _order_by: "machine_name"));
tLP_MID_view.Controls.Clear();
tLP_MID_view.ColumnCount = 2 * (machines.Count);
tLP_MID_view.AutoSizeMode = System.Windows.Forms.AutoSizeMode.GrowAndShrink;
for (int i = 0; i < tLP_MID_view.ColumnCount; i++)
tLP_MID_view.ColumnStyles.Add(new System.Windows.Forms.ColumnStyle());
for (int i = 0; i < machines.Count; i++)
{
Label t_label = new Label();
DateTimePicker tp = new DateTimePicker();
DateTimePicker dp = new DateTimePicker();
tp.Format = DateTimePickerFormat.Time;
tp.ShowUpDown = true;
tp.Value = new DateTime(DateTime.Now.Year, DateTime.Now.Month, DateTime.Now.Day, 8, 0, 0);
t_label.Text = machines[i];
tLP_MID_view.Controls.Add(t_label, i, 0);
tLP_MID_view.SetColumnSpan(t_label, 2);
tLP_MID_view.Controls.Add(dp, (i * 2), 1);
tLP_MID_view.Controls.Add(tp, ((i * 2) + 1), 1);
}
string query = " SELECT gang_number, MagneticTapeType, DieCutType ";
query += " FROM graphics_vars_gang ";
query += " JOIN sales_vars ON sales_vars.cust_po_number = sales_vars_id ";
query += " WHERE (MagneticTape = 'Y' OR DieCut = 'Y') ";
query += " AND ArtApproved = 'Y'";
query += " GROUP BY gang_number ";
DataSet ds = new DataSet();
ds = dbc.SelectMyDA(query);
for (int i = 0; i < ds.Tables[0].Rows.Count; i++)
{
List<Label> row = new List<Label>();
for (int j = 0; j < tLP_MID_view.ColumnCount; j++)
{
Label t_label2 = new Label();
Label t_label3 = new Label();
if (ds.Tables[0].Rows[i][1].ToString() == tLP_MID_view.GetControlFromPosition(j, 0).Text)
{
t_label2.Text = ds.Tables[0].Rows[i][0].ToString();
t_label3.Text = "";
row.Add(t_label2);
row.Add(t_label3);
}
else if (ds.Tables[0].Rows[i][2].ToString() == tLP_MID_view.GetControlFromPosition(j, 0).Text)
{
t_label2.Text = ds.Tables[0].Rows[i][0].ToString();
t_label3.Text = "";
row.Add(t_label2);
row.Add(t_label3);
}
else
{
t_label2.Text = "";
t_label3.Text = "";
row.Add(t_label2);
row.Add(t_label3);
}
j++;
}
tLP_MID_view.Controls.AddRange(row.ToArray());
}
}
void t_chkBox_CheckStateChanged(object sender, EventArgs e)
{
FormFunctions fFunc = new FormFunctions(user_id_lbl.Text, user_hash_lbl.Text);
string[] mc_combo = new string[] { };
if (((CheckBox)sender).CheckState == CheckState.Checked)
{
((ComboBox)((CheckBox)sender).Tag).Enabled = true;
((ComboBox)((CheckBox)sender).Tag).Items.Clear();
switch (((ComboBox)((CheckBox)sender).Tag).Tag.ToString())
{
case "Printing":
mc_combo = fFunc.getComboItems("deptID", "1", "machine_name", "machines", _order_by: "machine_name");
((ComboBox)((CheckBox)sender).Tag).Items.AddRange(mc_combo);
break;
case "MagneticTape":
mc_combo = fFunc.getComboItems("deptID", "3", "machine_name", "machines", _order_by: "machine_name");
((ComboBox)((CheckBox)sender).Tag).Items.AddRange(mc_combo);
break;
case "DieCut":
mc_combo = fFunc.getComboItems("deptID", "5", "machine_name", "machines", _order_by: "machine_name");
((ComboBox)((CheckBox)sender).Tag).Items.AddRange(mc_combo);
break;
}
}
else
{
((ComboBox)((CheckBox)sender).Tag).Enabled = false;
((ComboBox)((CheckBox)sender).Tag).Items.Clear();
}
}
private void button_GD_edit_loadPoD_Click(object sender, EventArgs e)
{
// --> Get po details data based on customer po number
if (listView_GD_edit_searchResult.SelectedItems.Count == 0)
{
MessageBox.Show("Please select the PO entry first.", "Error!", MessageBoxButtons.OK, MessageBoxIcon.Warning);
return;
}
label_GD_edit_update_status.Visible = false;
string po_entry_id = "";
ConnectToMySQL dbc = new ConnectToMySQL(user_id_lbl.Text, user_hash_lbl.Text);
// adding field names of po_details table -->
fldNames.Clear();
fldNames.Add("cust_name"); //i 0
fldNames.Add("cust_po_number"); //i 1
fldNames.Add("order_qty"); //i 2
fldNames.Add("card_material"); //i 3
fldNames.Add("num_colors"); //i 4
fldNames.Add("lamination"); //i 5
fldNames.Add("card_name"); //i 6
fldNames.Add("gang_number.gang_number_id"); //i 7
fldNames.Add("po_details.id"); //i 8
fldNames.Add("po_details.user_id"); //i 9
fldNames.Add("po_entry_id"); //i 10
fldNames.Add("po_details.gang_number_id"); //i 11
fldNames.Add("sheet_size"); //i 12
fldNames.Add("PrintOnFaceFront"); //i 13
fldNames.Add("PrintOnFaceBack"); //i 14
fldNames.Add("SideGuideFront"); //i 15
fldNames.Add("SideGuideBack"); //i 16
fldNames.Add("UVCoatingBack"); //i 17
fldNames.Add("print_qty"); //i 18
fldNames.Add("issue_qty"); //i 19
//<--
po_entry_id = listView_GD_edit_searchResult.SelectedItems[0].Tag.ToString();
DataSet ds = new DataSet();
FormFunctions fFunc = new FormFunctions(user_id_lbl.Text, user_hash_lbl.Text);
string[] cbox_items = fFunc.getComboItems("", "", "gang_number_id", "gang_number", _order_by: "id", _whrClause: " WHERE id != 1 AND id != 2 ");
string query = "SELECT " + string.Join(", ", fldNames.ToArray());
query += " FROM po_details ";
query += " JOIN po_entry ON po_entry.id = po_details.po_entry_id ";
query += " JOIN gang_number ON po_details.gang_number_id = gang_number.id ";
query += " WHERE po_entry_id = '" + po_entry_id + "';";
//query += " GROUP BY cust_po_number; ";
ds = dbc.SelectMyDA(query);
int order_qty = 0;
int job_lines = ds.Tables[0].Rows.Count;
for (int j = 0; j < ds.Tables[0].Rows.Count; j++)
order_qty += Int32.Parse(ds.Tables[0].Rows[j][2].ToString());
label_GD_edit_PoD1x1.Text = ds.Tables[0].Rows[0][0].ToString();
label_GD_edit_PoD0x3.Text = ds.Tables[0].Rows[0][1].ToString();
label_GD_edit_PoD1x3.Text = order_qty.ToString();
label_GD_edit_PoD0x5.Text = ds.Tables[0].Rows[0][3].ToString();
label_GD_edit_PoD0x9.Text = ds.Tables[0].Rows[0][4].ToString();
label_GD_edit_PoD0x13.Text = ds.Tables[0].Rows[0][5].ToString();
comboBox_GD_edit_PoD0x1.DropDownStyle = ComboBoxStyle.DropDownList;
comboBox_GD_edit_PoD0x1.FlatStyle = FlatStyle.Popup;
comboBox_GD_edit_PoD0x1.Items.Clear();
comboBox_GD_edit_PoD0x1.Items.AddRange(cbox_items);
comboBox_GD_edit_PoD0x1.SelectedItem = dbc.SelectSingle("gang_number_id", "gang_number", "id", ds.Tables[0].Rows[0][11].ToString());
textBox_GD_edit_PoD1x5.Text = ds.Tables[0].Rows[0][12].ToString();
textBox_GD_edit_PoD0x7.Text = ds.Tables[0].Rows[0][13].ToString();
textBox_GD_edit_PoD1x7.Text = ds.Tables[0].Rows[0][14].ToString();
textBox_GD_edit_PoD0x11.Text = ds.Tables[0].Rows[0][15].ToString();
textBox_GD_edit_PoD1x11.Text = ds.Tables[0].Rows[0][16].ToString();
textBox_GD_edit_PoD1x13.Text = ds.Tables[0].Rows[0][17].ToString();
textBox_GD_edit_PoD2x7.Text = ds.Tables[0].Rows[0][18].ToString();
textBox_GD_edit_PoD2x9.Text = ds.Tables[0].Rows[0][19].ToString();
checkedListBox_GD_edit_PoD2x0.Items.Clear();
checkedListBox_GD_edit_PoD2x0.Items.Add("Initial");
checkedListBox_GD_edit_PoD2x0.Items.AddRange(fFunc.getComboItems("", "", "gang_number_id", "gang_number", _order_by: "id", _whrClause: " WHERE id != 1 AND id != 2 "));
for (int j = 0; j < ds.Tables[0].Rows.Count; j++)
checkedListBox_GD_edit_PoD2x0.SetItemChecked(checkedListBox_GD_edit_PoD2x0.Items.IndexOf(ds.Tables[0].Rows[j][7].ToString()), true);
DataSet ds2 = new DataSet();
string query2 = "SELECT card_name, up_size, po_details.id, job_number, gang_number.gang_number_id ";
query2 += " FROM po_details ";
query2 += " JOIN gang_number on gang_number.id = po_details.gang_number_id ";
query2 += " WHERE po_entry_id = '" + po_entry_id + "' ORDER BY job_number; ";
ds2 = dbc.SelectMyDA(query2);
int up_size = 0;
Label t_label1 = new Label();
Label t_label2 = new Label();
Label t_label3 = new Label();
Label t_label4 = new Label();
tableLayoutPanel_GD_edit_JobD.Controls.Clear();
t_label1.Text = "Job Number";
tableLayoutPanel_GD_edit_JobD.Controls.Add(t_label1, 0, 0);
t_label2.Text = "Gang Number";
tableLayoutPanel_GD_edit_JobD.Controls.Add(t_label2, 1, 0);
t_label3.Text = "Job Name";
tableLayoutPanel_GD_edit_JobD.Controls.Add(t_label3, 2, 0);
t_label4.Text = "Job UP Size";
t_label4.Tag = ds2.Tables[0].Rows.Count;
tableLayoutPanel_GD_edit_JobD.Controls.Add(t_label4, 3, 0);
for (int i = 0; i < ds2.Tables[0].Rows.Count; i++)
{
TextBox t_textBox = new TextBox();
TextBox t_textBox2 = new TextBox();
Label t_label = new Label();
ComboBox t_cbox = new ComboBox();
t_textBox.Text = ds2.Tables[0].Rows[i][3].ToString();
t_textBox.Tag = ds2.Tables[0].Rows[i][2].ToString();
t_cbox.Items.Add("Initial");
t_cbox.Items.AddRange(cbox_items);
t_cbox.SelectedItem = "Initial";
t_cbox.SelectedItem = txtBox_gang_num.Text;
t_cbox.SelectedItem = ds2.Tables[0].Rows[i][4].ToString();
t_label.AutoSize = true;
t_label.Text = ds2.Tables[0].Rows[i][0].ToString();
t_textBox2.Text = ds2.Tables[0].Rows[i][1].ToString();
t_textBox2.Tag = ds2.Tables[0].Rows[i][1].ToString();
tableLayoutPanel_GD_edit_JobD.SuspendLayout();
tableLayoutPanel_GD_edit_JobD.Controls.Add(t_textBox, 0, i + 1);
tableLayoutPanel_GD_edit_JobD.Controls.Add(t_cbox, 1, i + 1);
tableLayoutPanel_GD_edit_JobD.Controls.Add(t_label, 2, i + 1);
tableLayoutPanel_GD_edit_JobD.Controls.Add(t_textBox2, 3, i + 1);
tableLayoutPanel_GD_edit_JobD.ResumeLayout();
up_size += Int32.Parse(ds2.Tables[0].Rows[i][1].ToString());
t_textBox2.TextChanged += t_textBoxEdit_TextChanged;
}
label_GD_edit_PoD2x3.Text = up_size.ToString();
label_GD_edit_PoD2x5.Text = (Int32.Parse(label_GD_edit_PoD1x3.Text) / up_size).ToString();
}
private void btn_GD_insert_loadPO_Click(object sender, EventArgs e)
{
// --> Get po details data based on customer po number
if (listView_GD_insert_newPOs.SelectedItems.Count == 0)
{
MessageBox.Show("Please select the PO entry first.", "Error!", MessageBoxButtons.OK, MessageBoxIcon.Warning);
return;
}
//label_GD_insert_update_status.Visible = false;
//tableLayoutPanel_GD_insert_job.Controls.Clear();
string po_entry_id = "";
ConnectToMySQL dbc = new ConnectToMySQL(user_id_lbl.Text, user_hash_lbl.Text);
List<string> fldNames2 = new List<string>();
// --> Job Tabpage(s)
// adding field names of po_details table -->
fldNames.Clear();
fldNames.Add("cust_name"); //i 0
fldNames.Add("req_date");
fldNames.Add("card_denom");
fldNames.Add("card_material");
fldNames.Add("order_qty");
fldNames.Add("lamination");
fldNames.Add("card_name");
fldNames.Add("id");
fldNames.Add("id"); //i 8
fldNames.Add("user_id");
fldNames.Add("card_size"); //i 10
fldNames.Add("timestamp");
//<--
po_entry_id = listView_GD_insert_newPOs.SelectedItems[0].Tag.ToString();
DataSet ds = new DataSet();
//DataSet ds2 = new DataSet();
FormFunctions fFunc = new FormFunctions(user_id_lbl.Text, user_hash_lbl.Text);
string[] cbox_items = fFunc.getComboItems("", "", "DISTINCT(gang_number)", "graphics_vars_gang", _order_by: "id");
string query = "SELECT " + string.Join(", ", fldNames.ToArray());
query += " FROM sales_vars ";
query += " WHERE cust_po_number = '" + po_entry_id + "'";
string query2 = " GROUP BY cust_po_number; ";
//ds2 = dbc.SelectMyDA(query+query2);
ds = dbc.SelectMyDA(query);
this.tabControl_GD_insert.TabPages.Clear();
for (int j = 0; j < dbc.Count("SELECT count(id) from sales_vars where cust_po_number = '" + po_entry_id + "';"); j++)
{
TabPage tabPage_job = new TabPage("Job " + (j + 1).ToString());
TableLayoutPanel tlp_GD_insert_job = new TableLayoutPanel();
//tlp_GD_insert_job = tableLayoutPanel_GD_insert_job;
//tlp_GD_insert_job.Controls.Clear();
tlp_GD_insert_job.Name = "tlp_GD_insert_job" + (j + 1).ToString();
tlp_GD_insert_job.ColumnCount = 3;
tlp_GD_insert_job.ColumnStyles.Add(new System.Windows.Forms.ColumnStyle(System.Windows.Forms.SizeType.Percent, 33.33333F));
tlp_GD_insert_job.ColumnStyles.Add(new System.Windows.Forms.ColumnStyle(System.Windows.Forms.SizeType.Percent, 33.33333F));
tlp_GD_insert_job.ColumnStyles.Add(new System.Windows.Forms.ColumnStyle(System.Windows.Forms.SizeType.Percent, 33.33333F));
tlp_GD_insert_job.Dock = System.Windows.Forms.DockStyle.Fill;
tlp_GD_insert_job.Location = new System.Drawing.Point(3, 3);
tlp_GD_insert_job.RowCount = 16;
tlp_GD_insert_job.RowStyles.Add(new System.Windows.Forms.RowStyle(System.Windows.Forms.SizeType.Percent, 6.25F));
tlp_GD_insert_job.RowStyles.Add(new System.Windows.Forms.RowStyle(System.Windows.Forms.SizeType.Percent, 6.25F));
tlp_GD_insert_job.RowStyles.Add(new System.Windows.Forms.RowStyle(System.Windows.Forms.SizeType.Percent, 6.25F));
tlp_GD_insert_job.RowStyles.Add(new System.Windows.Forms.RowStyle(System.Windows.Forms.SizeType.Percent, 6.25F));
tlp_GD_insert_job.RowStyles.Add(new System.Windows.Forms.RowStyle(System.Windows.Forms.SizeType.Percent, 6.25F));
tlp_GD_insert_job.RowStyles.Add(new System.Windows.Forms.RowStyle(System.Windows.Forms.SizeType.Percent, 6.25F));
tlp_GD_insert_job.RowStyles.Add(new System.Windows.Forms.RowStyle(System.Windows.Forms.SizeType.Percent, 6.25F));
tlp_GD_insert_job.RowStyles.Add(new System.Windows.Forms.RowStyle(System.Windows.Forms.SizeType.Percent, 6.25F));
tlp_GD_insert_job.RowStyles.Add(new System.Windows.Forms.RowStyle(System.Windows.Forms.SizeType.Percent, 6.25F));
tlp_GD_insert_job.RowStyles.Add(new System.Windows.Forms.RowStyle(System.Windows.Forms.SizeType.Percent, 6.25F));
tlp_GD_insert_job.RowStyles.Add(new System.Windows.Forms.RowStyle(System.Windows.Forms.SizeType.Percent, 6.25F));
tlp_GD_insert_job.RowStyles.Add(new System.Windows.Forms.RowStyle(System.Windows.Forms.SizeType.Percent, 6.25F));
tlp_GD_insert_job.RowStyles.Add(new System.Windows.Forms.RowStyle(System.Windows.Forms.SizeType.Percent, 6.25F));
tlp_GD_insert_job.RowStyles.Add(new System.Windows.Forms.RowStyle(System.Windows.Forms.SizeType.Percent, 6.25F));
tlp_GD_insert_job.RowStyles.Add(new System.Windows.Forms.RowStyle(System.Windows.Forms.SizeType.Percent, 6.25F));
tlp_GD_insert_job.RowStyles.Add(new System.Windows.Forms.RowStyle(System.Windows.Forms.SizeType.Percent, 6.25F));
tlp_GD_insert_job.Size = new System.Drawing.Size(809, 539);
tlp_GD_insert_job.TabIndex = 0;
tabPage_job.Controls.Add(tlp_GD_insert_job);
//tabPage_job.Location = new System.Drawing.Point(4, 22);
//tabPage_job.Name = "tabPage3";
//tabPage_job.Padding = new System.Windows.Forms.Padding(3);
//tabPage_job.Size = new System.Drawing.Size(815, 545);
tabPage_job.TabIndex = j+1;
//tabPage_job.Text = "Jobs";
tabPage_job.UseVisualStyleBackColor = true;
this.tabControl_GD_insert.TabPages.Add(tabPage_job);
//--> adding label names to table
List<string> lblNames = new List<string>();
lblNames.AddRange(new string[] { "JobID", "CustomerName", "PODate", "CardName", "Retailer", "Denomination", "Order Qty", "CoreMaterial", "CustomerDueDate", "PO", "TypeOfCard", "ProjectedDueDate", "Sales", "Lamination", "ActualDueDate", "GangID", "PinCover", "Personalization Job", "CardRatio", "Other", "Minimum Print Qty:", "Mag Stripe", "Encode" });
for (int i = 0; i < lblNames.Count; i++)
{
Label t_gd_insert_label1 = new Label();
Label t_gd_insert_label2 = new Label();
Label t_gd_insert_label3 = new Label();
Button t_gd_insert_button1 = new Button();
int temp1;
if (i < 21)
{
t_gd_insert_label1.Text = lblNames[i].ToString();
t_gd_insert_label2.Text = lblNames[i + 1].ToString();
t_gd_insert_label3.Text = lblNames[i + 2].ToString();
}
else
{
t_gd_insert_label1.Text = lblNames[i].ToString();
t_gd_insert_label2.Text = lblNames[i + 1].ToString();
}
temp1 = Int32.Parse(Math.Floor(double.Parse(i.ToString()) / 3).ToString());
i++; i++;
temp1 = temp1 * 2;
tlp_GD_insert_job.Controls.Add(t_gd_insert_label1, 0, temp1);
tlp_GD_insert_job.Controls.Add(t_gd_insert_label2, 1, temp1);
if (i < 23)
tlp_GD_insert_job.Controls.Add(t_gd_insert_label3, 2, temp1);
else
{
t_gd_insert_button1.Text = "Save Info";
t_gd_insert_button1.Name = ds.Tables[0].Rows[j][8].ToString();
t_gd_insert_button1.Tag = tlp_GD_insert_job;
tlp_GD_insert_job.Controls.Add(t_gd_insert_button1, 2, temp1);
}
t_gd_insert_button1.Click += new EventHandler(button_GD_insert_InsertJob_Click);
}
for (int i = 0; i < lblNames.Count; i++)
{
Label t_gd_insert_label = new Label(); t_gd_insert_label.Dock = DockStyle.Fill;
TextBox t_gd_insert_textbox = new TextBox();
CheckBox t_gd_insert_chkbox = new CheckBox();
Button t_gd_insert_button = new Button();
ComboBox t_gd_insert_combobox = new ComboBox();
switch (i)
{
case 0:
tlp_GD_insert_job.Controls.Add(t_gd_insert_textbox, 0, 1);
break;
case 1:
t_gd_insert_label.Text = ds.Tables[0].Rows[j].ItemArray[0].ToString();
tlp_GD_insert_job.Controls.Add(t_gd_insert_label, 1, 1);
break;
case 2:
t_gd_insert_label.Text = ds.Tables[0].Rows[j].ItemArray[11].ToString();
tlp_GD_insert_job.Controls.Add(t_gd_insert_label, 2, 1);
break;
case 3:
t_gd_insert_label.Text = ds.Tables[0].Rows[j].ItemArray[6].ToString();
tlp_GD_insert_job.Controls.Add(t_gd_insert_label, 0, 3);
break;
case 4:
tlp_GD_insert_job.Controls.Add(t_gd_insert_textbox, 1, 3);
break;
case 5:
t_gd_insert_label.Text = ds.Tables[0].Rows[j].ItemArray[2].ToString();
tlp_GD_insert_job.Controls.Add(t_gd_insert_label, 2, 3);
break;
case 6:
t_gd_insert_label.Text = ds.Tables[0].Rows[j].ItemArray[4].ToString();
tlp_GD_insert_job.Controls.Add(t_gd_insert_label, 0, 5);
break;
case 7:
t_gd_insert_label.Text = ds.Tables[0].Rows[j].ItemArray[3].ToString();
tlp_GD_insert_job.Controls.Add(t_gd_insert_label, 1, 5);
break;
case 8:
t_gd_insert_label.Text = ds.Tables[0].Rows[j].ItemArray[1].ToString();
tlp_GD_insert_job.Controls.Add(t_gd_insert_label, 2, 5);
break;
case 9:
t_gd_insert_label.Text = po_entry_id;
tlp_GD_insert_job.Controls.Add(t_gd_insert_label, 0, 7);
break;
case 10:
t_gd_insert_label.Text = ds.Tables[0].Rows[j].ItemArray[10].ToString();
tlp_GD_insert_job.Controls.Add(t_gd_insert_label, 1, 7);
break;
case 11:
t_gd_insert_textbox.Enabled = false;
tlp_GD_insert_job.Controls.Add(t_gd_insert_textbox, 2, 7);
break;
case 12:
t_gd_insert_label.Text = ds.Tables[0].Rows[j].ItemArray[9].ToString();
tlp_GD_insert_job.Controls.Add(t_gd_insert_label, 0, 9);
break;
case 13:
t_gd_insert_label.Text = ds.Tables[0].Rows[j].ItemArray[5].ToString();
tlp_GD_insert_job.Controls.Add(t_gd_insert_label, 1, 9);
break;
case 14:
t_gd_insert_textbox.Enabled = false;
tlp_GD_insert_job.Controls.Add(t_gd_insert_textbox, 2, 9);
break;
case 15:
t_gd_insert_combobox.DropDownStyle = ComboBoxStyle.DropDownList;
t_gd_insert_combobox.FlatStyle = FlatStyle.Popup;
t_gd_insert_combobox.Items.Clear();
t_gd_insert_combobox.Items.Add("Initial");
t_gd_insert_combobox.Items.AddRange(cbox_items);
t_gd_insert_combobox.SelectedItem = "Initial";
//t_gd_insert_label.Text = "0000";
tlp_GD_insert_job.Controls.Add(t_gd_insert_combobox, 0, 11);
break;
case 16:
tlp_GD_insert_job.Controls.Add(t_gd_insert_textbox, 1, 11);
break;
case 17:
tlp_GD_insert_job.Controls.Add(t_gd_insert_chkbox, 2, 11);
break;
case 18:
tlp_GD_insert_job.Controls.Add(t_gd_insert_textbox, 0, 13);
break;
case 19:
tlp_GD_insert_job.Controls.Add(t_gd_insert_textbox, 1, 13);
break;
case 20:
tlp_GD_insert_job.Controls.Add(t_gd_insert_textbox, 2, 13);
break;
case 21:
tlp_GD_insert_job.Controls.Add(t_gd_insert_chkbox, 0, 15);
break;
case 22:
tlp_GD_insert_job.Controls.Add(t_gd_insert_textbox, 1, 15);
t_gd_insert_button.Text = "Print Sheet";
t_gd_insert_button.Enabled = false;
tlp_GD_insert_job.Controls.Add(t_gd_insert_button, 2, 15);
break;
}
}
}
// <--
//--> Gang tabpage
TabPage tabPage_gang = new TabPage("Gang");
TableLayoutPanel tlp_GD_insert_gang = new TableLayoutPanel();
// adding field names of po_details table -->
fldNames.Clear();
fldNames.Add("cust_name"); //i 0
fldNames.Add("cust_po_number");
fldNames.Add("SUM(order_qty)");
fldNames.Add("card_material");
fldNames.Add("num_colors");
fldNames.Add("lamination");
fldNames.Add("card_name");
fldNames.Add("COUNT(id)");
fldNames.Add("id"); //i 8
fldNames.Add("user_id");
fldNames.Add("id"); //i 10
query = "SELECT " + string.Join(", ", fldNames.ToArray());
query += " FROM sales_vars ";
query += " WHERE cust_po_number = '" + po_entry_id + "'";
query += " GROUP BY cust_po_number; ";
ds.Clear();
ds = dbc.SelectMyDA(query);
label_GD_insert_1x1.Text = ds.Tables[0].Rows[0][0].ToString();
label_GD_insert_0x3.Text = ds.Tables[0].Rows[0][1].ToString();
label_GD_insert_1x3.Text = ds.Tables[0].Rows[0][2].ToString();
label_GD_insert_0x5.Text = ds.Tables[0].Rows[0][3].ToString();
label_GD_insert_0x9.Text = ds.Tables[0].Rows[0][4].ToString();
label_GD_insert_0x13.Text = ds.Tables[0].Rows[0][5].ToString();
comboBox_GD_insert_0x0.DropDownStyle = ComboBoxStyle.DropDownList;
comboBox_GD_insert_0x0.FlatStyle = FlatStyle.Popup;
comboBox_GD_insert_0x0.Items.Clear();
comboBox_GD_insert_0x0.Items.Add("New");
comboBox_GD_insert_0x0.Items.AddRange(cbox_items);
button_gd_insert_gangsave.Tag = ds.Tables[0].Rows[0][8].ToString();
int up_size = 0;
//TableLayoutPanel tlp_GD_insert_gang_job = new TableLayoutPanel(); //TODO: make generic table layout panel by copying properties
//tlp_GD_insert_gang_job = tableLayoutPanel_GD_insert_JobD; //TODO: make generic table layout panel by copying properties
DataSet ds2 = new DataSet();
string query3 = "SELECT card_name, up_size, graphics_vars_job.id, job_number ";
//query3 += ", gang_number.gang_number_id ";
query3 += " FROM sales_vars ";
query3 += " JOIN graphics_vars_job on sales_vars_id = sales_vars.id ";
query3 += " WHERE cust_po_number = '" + po_entry_id + "' AND graphics_vars_gang_id = '0'";
query3 += " ORDER BY job_number; ";
ds2 = dbc.SelectMyDA(query3);
Label t_label0x1 = new Label();
Button t_button0x1 = new Button();
Label t_label1 = new Label();
Label t_label2 = new Label();
Label t_label3 = new Label();
Label t_label4 = new Label();
tableLayoutPanel_GD_insert_JobD.Controls.Clear();
t_label0x1.Text = "Job Information";
tableLayoutPanel_GD_insert_JobD.Controls.Add(t_label0x1, 0, 0);
t_button0x1.Text = "Update";
tableLayoutPanel_GD_insert_JobD.Controls.Add(t_button0x1, 1, 0);
t_button0x1.Click += new EventHandler(t_button0x1Click);
t_label1.Text = "Job Number";
tableLayoutPanel_GD_insert_JobD.Controls.Add(t_label1, 0, 1);
t_label2.Text = "Job Name";
tableLayoutPanel_GD_insert_JobD.Controls.Add(t_label2, 1, 1);
t_label3.Text = "Job Up Size";
tableLayoutPanel_GD_insert_JobD.Controls.Add(t_label3, 2, 1);
t_label4.Text = "Action";
t_label4.Tag = ds2.Tables[0].Rows.Count;
tableLayoutPanel_GD_insert_JobD.Controls.Add(t_label4, 3, 1);
for (int i = 0; i < ds2.Tables[0].Rows.Count; i++)
{
TextBox t_gangjob_textBox = new TextBox();
Label t_gangjob_label1 = new Label();
Label t_gangjob_label2 = new Label();
Button t_gangjob_button = new Button();
t_gangjob_label1.AutoSize = true;
t_gangjob_label1.Text = ds2.Tables[0].Rows[i][3].ToString();
t_gangjob_label2.AutoSize = true;
t_gangjob_label2.Text = ds2.Tables[0].Rows[i][0].ToString();
t_gangjob_textBox.Text = ds2.Tables[0].Rows[i][1].ToString();
t_gangjob_textBox.Tag = ds2.Tables[0].Rows[i][1].ToString();
t_gangjob_button.Text = "Insert Up-size";
t_gangjob_button.Tag = ds2.Tables[0].Rows[i][2].ToString();
tableLayoutPanel_GD_insert_JobD.SuspendLayout();
tableLayoutPanel_GD_insert_JobD.Controls.Add(t_gangjob_label1, 0, i + 2);
tableLayoutPanel_GD_insert_JobD.Controls.Add(t_gangjob_label2, 1, i + 2);
tableLayoutPanel_GD_insert_JobD.Controls.Add(t_gangjob_textBox, 2, i + 2);
tableLayoutPanel_GD_insert_JobD.Controls.Add(t_gangjob_button, 3, i + 2);
tableLayoutPanel_GD_insert_JobD.ResumeLayout();
up_size += Int32.Parse(ds2.Tables[0].Rows[i][1].ToString());
t_gangjob_textBox.TextChanged += t_textBoxInsert_TextChanged;
t_gangjob_button.Click += new EventHandler(t_gangjob_button_Click);
}
label_GD_insert_2x3.Text = up_size.ToString();
int temp_up_size = 1;
if (up_size != 0)
temp_up_size = up_size;
label_GD_insert_2x5.Text = (Int32.Parse(label_GD_insert_1x3.Text) / temp_up_size).ToString();
tlp_GD_insert_gang = tableLayoutPanel_GD_insert_PoD;
tabPage_gang.Controls.Add(tlp_GD_insert_gang);
tabPage_gang.TabIndex = 0;
tabPage_gang.UseVisualStyleBackColor = true;
this.tabControl_GD_insert.TabPages.Add(tabPage_gang);
// <--
//--> Mid tabpage
TabPage tabPage_mid = new TabPage("Mid");
TableLayoutPanel tlp_gd_insert_mid = new TableLayoutPanel();
Label t_lbl3 = new Label();
ComboBox t_combo4 = new ComboBox();
Button t_btn1 = new Button();
Button t_btn2 = new Button();
tlp_gd_insert_mid.ColumnCount = 2;
tlp_gd_insert_mid.ColumnStyles.Add(new System.Windows.Forms.ColumnStyle());
tlp_gd_insert_mid.ColumnStyles.Add(new System.Windows.Forms.ColumnStyle());
tlp_gd_insert_mid.Dock = System.Windows.Forms.DockStyle.Fill;
tlp_gd_insert_mid.AutoScroll = true;
t_lbl3.Text = "GangID";
t_combo4.Items.AddRange(cbox_items);
t_btn1.Text = "Save";
t_btn1.Click += new EventHandler(t_btn1_Click);
t_btn2.Text = "Print";
t_btn2.Click += new EventHandler(t_btn2_Click);
t_btn2.Enabled = false;
tlp_gd_insert_mid.Controls.Add(t_lbl3, 0, 0);
tlp_gd_insert_mid.Controls.Add(t_btn1, 1, 0);
tlp_gd_insert_mid.Controls.Add(t_combo4, 0, 1);
tlp_gd_insert_mid.Controls.Add(t_btn2, 0, 1);
DataSet ds3 = new DataSet();
string query4 = "SHOW COLUMNS FROM graphics_vars_gang;";
ds3 = dbc.SelectMyDA(query4);
for (int row = 0; row < 7; row++)
{
for (int col = 0; col < 1; col++)
{
Label t_lbl1 = new Label(); t_lbl1.Dock = DockStyle.Fill;
Label t_lbl2 = new Label(); t_lbl2.Dock = DockStyle.Fill;
CheckBox t_chkBox = new CheckBox(); t_chkBox.Dock = DockStyle.Fill;
ComboBox t_comboBox = new ComboBox(); t_comboBox.Dock = DockStyle.Fill; t_comboBox.Enabled = false;
t_lbl1.Text = ds3.Tables[0].Rows[(row * 2) + 17][0].ToString();
t_lbl2.Text = ds3.Tables[0].Rows[(row * 2) + 18][0].ToString();
t_chkBox.Tag = t_comboBox;
t_comboBox.Tag = t_lbl1.Text;
tlp_gd_insert_mid.Controls.Add(t_lbl1, col, ((row * 2) + 2));
tlp_gd_insert_mid.Controls.Add(t_lbl2, col + 1, ((row * 2) + 2));
tlp_gd_insert_mid.Controls.Add(t_chkBox, col, ((row * 2) + 3));
tlp_gd_insert_mid.Controls.Add(t_comboBox, col + 1, ((row * 2) + 3));
t_chkBox.CheckStateChanged += new EventHandler(t_chkBox_CheckStateChanged);
}
}
tabPage_mid.Controls.Add(tlp_gd_insert_mid);
tabPage_mid.TabIndex = this.tabControl_GD_insert.TabPages.Count;
tabPage_mid.UseVisualStyleBackColor = true;
this.tabControl_GD_insert.TabPages.Add(tabPage_mid);
//<--
}
// Get po details data based upon customer po number entered into textbox
private void PoD_IBtn3_Click(object sender, EventArgs e)
{
ConnectToMySQL dbc = new ConnectToMySQL(user_id_lbl.Text, user_hash_lbl.Text);
// --> Get po details data based on customer po number
string po_entry_id = dbc.SelectSingle("id", "sales_vars", "cust_po_number", textBox_Cust_PO_Num_copy.Text);
if (po_entry_id == "")
{
MessageBox.Show("Couldn't find Customer PO Number. Please recheck the PO number and search again.", "Error!", MessageBoxButtons.OK, MessageBoxIcon.Warning);
PoD_IBtn2.Enabled = false;
PoD_IBtn1.Enabled = false;
return;
}
PoD_IBtn2.Enabled = true;
PoD_IBtn1.Enabled = true;
label_SA_insertPoDSuccess.Visible = false;
PO_Entry_IBtn1.Enabled = false;
tableLayoutPanel1_SA_insert_addDetails.Controls.Clear();
// adding field names of po_details table -->
fldNames.Clear();
fldNames.Add("order_qty");
fldNames.Add("card_name");
fldNames.Add("card_denom");
fldNames.Add("cvv");
fldNames.Add("card_size");
fldNames.Add("card_thickness");
fldNames.Add("card_material");
fldNames.Add("num_colors");
fldNames.Add("lamination");
fldNames.Add("magnetic");
fldNames.Add("pin");
fldNames.Add("barcode");
fldNames.Add("sol");
fldNames.Add("hot_stamp");
fldNames.Add("signature_panel");
fldNames.Add("silk_screen");
fldNames.Add("hole_punch");
fldNames.Add("single_pack");
fldNames.Add("bundle_pack");
fldNames.Add("inner_box");
fldNames.Add("outer_box"); // 21 == i20
fldNames.Add("id");
//<--
DataSet ds = new DataSet();
string query = "SELECT " + string.Join(", ", fldNames.ToArray());
query += " FROM sales_vars WHERE cust_po_number = '" + textBox_Cust_PO_Num_copy.Text + "'; ";
ds = dbc.SelectMyDA(query);
// <--
// Adding Column Headers for table layout panel 1 -->
Label t_lbl2 = new Label();
t_lbl2.Text = "PO Detail Fields";
tableLayoutPanel1_SA_insert_addDetails.Controls.Add(t_lbl2, 0, 0);
//<--
// adding field names to table layout panel 1 -->
for (int i = 0; i < 21; i++)
{
Label t_lbl = new Label();
t_lbl.Text = fldNames[i];
tableLayoutPanel1_SA_insert_addDetails.Controls.Add(t_lbl, 0, i + 1);
}
//<--
// adding gang number and job number to table layout panel 1 -->
Label t_lbl4 = new Label();
Label t_lbl5 = new Label();
t_lbl4.Text = "Gang Number:";
t_lbl5.Text = "Job Number:";
tableLayoutPanel1_SA_insert_addDetails.Controls.Add(t_lbl4, 0, 22);
tableLayoutPanel1_SA_insert_addDetails.Controls.Add(t_lbl5, 0, 23);
// <--
// adding data columns with field values from database for selected PO number
int colCount = 1;
FormFunctions fFunc = new FormFunctions(user_id_lbl.Text, user_hash_lbl.Text);
tableLayoutPanel1_SA_insert_addDetails.ColumnCount = colCount;
this.tableLayoutPanel1_SA_insert_addDetails.ColumnStyles.Add(new System.Windows.Forms.ColumnStyle());
tableLayoutPanel1_SA_insert_addDetails.GetControlFromPosition(0, 0).Tag = ds.Tables[0].Rows.Count; // add col count to 0,0 position tag.
for (int i = 0; i < ds.Tables[0].Rows.Count; i++)
{
colCount++;
this.tableLayoutPanel1_SA_insert_addDetails.ColumnCount = colCount;
this.tableLayoutPanel1_SA_insert_addDetails.ColumnStyles.Add(new System.Windows.Forms.ColumnStyle());
Label t_lbl3 = new Label();
t_lbl3.Text = "PO Detail Values " + (i + 1).ToString();
tableLayoutPanel1_SA_insert_addDetails.Controls.Add(t_lbl3, i + 1, 0);
for (int j = 0; j < 21; j++)
{
Panel t_panel = new Panel();
ComboBox t_combo = new ComboBox();
TextBox t_textBox = new TextBox();
t_textBox.Location = new Point(3, 30);
t_combo.Items.Add("Other");
t_combo.SelectedItem = "Other";
t_combo.Location = new System.Drawing.Point(4, 6);
t_combo.Size = new System.Drawing.Size(121, 13);
//t_combo.Tag = new TableLayoutPanelCellPosition(i, j);
t_combo.DropDownStyle = ComboBoxStyle.DropDownList;
t_combo.FlatStyle = FlatStyle.Popup;
t_panel.AutoSize = true;
t_panel.AutoSizeMode = System.Windows.Forms.AutoSizeMode.GrowAndShrink;
t_panel.BorderStyle = BorderStyle.FixedSingle;
t_panel.SuspendLayout();
if (j >= 4 & j < 21)
{
t_combo.Items.AddRange(fFunc.getComboItems("group_id", (j - 2).ToString(), "member_description", "po_specs"));
t_panel.Controls.Add(t_combo);
t_combo.SelectedItem = ds.Tables[0].Rows[i][j].ToString();
t_combo.Tag = ds.Tables[0].Rows[i][j].ToString();
if ((string)t_combo.SelectedItem == "Other")
{
t_textBox.Text = ds.Tables[0].Rows[i][j].ToString();
t_panel.Controls.Add(t_textBox);
}
}
else
{
t_textBox.Text = ds.Tables[0].Rows[i][j].ToString();
t_textBox.Location = new System.Drawing.Point(4, 6);
t_panel.Controls.Add(t_textBox);
}
t_panel.ResumeLayout();
tableLayoutPanel1_SA_insert_addDetails.SuspendLayout();
tableLayoutPanel1_SA_insert_addDetails.Controls.Add(t_panel, i + 1, j + 1);
tableLayoutPanel1_SA_insert_addDetails.ResumeLayout();
t_panel.Enabled = false;
}
// adding gang number and job number, fetched with po_details.id -->
string str1 = dbc.SelectSingle("gang_number", "graphics_vars_gang", "id", dbc.SelectSingle("graphics_vars_gang_id", "graphics_vars_job", "sales_vars_id", ds.Tables[0].Rows[i][21].ToString()));
string str2 = dbc.SelectSingle("job_number", "graphics_vars_job", "sales_vars_id", ds.Tables[0].Rows[i][21].ToString());
Label t_lbl6 = new Label();
Label t_lbl7 = new Label();
t_lbl6.Text = str1;
tableLayoutPanel1_SA_insert_addDetails.Controls.Add(t_lbl6, i+1, 22);
t_lbl7.Text = str2;
tableLayoutPanel1_SA_insert_addDetails.Controls.Add(t_lbl7, i+1, 23);
// <--
}
// To display total order quantity -->
int totalOrderQty = 0;
for (int j = 1; j < colCount; j++)
{
if (tableLayoutPanel1_SA_insert_addDetails.GetControlFromPosition(j, 1).GetChildAtPoint(new Point(4, 6)).Text != "")
totalOrderQty += Int32.Parse(tableLayoutPanel1_SA_insert_addDetails.GetControlFromPosition(j, 1).GetChildAtPoint(new Point(4, 6)).Text);
}
Label_SA_insert_OrderQty2.Text = totalOrderQty.ToString();
// <--
}
// Add more columns to table page layout 1 (PO Details table form)
private void PoD_IBtn2_Click(object sender, EventArgs e)
{
// adding additional text boxes to table layout panel 1 -->
ConnectToMySQL dbc = new ConnectToMySQL(user_id_lbl.Text, user_hash_lbl.Text);
//-1-> common code
int colCount = this.tableLayoutPanel1_SA_insert_addDetails.ColumnCount;
if (colCount == 0)
colCount++;
colCount++;
this.tableLayoutPanel1_SA_insert_addDetails.ColumnCount = colCount;
this.tableLayoutPanel1_SA_insert_addDetails.ColumnStyles.Add(new System.Windows.Forms.ColumnStyle());
Label t_lbl = new Label();
t_lbl.Text = "PO Detail Values " + (colCount - 1).ToString();
tableLayoutPanel1_SA_insert_addDetails.Controls.Add(t_lbl, colCount - 1, 0);
FormFunctions fFunc = new FormFunctions(user_id_lbl.Text, user_hash_lbl.Text);
for (int i = 0; i < fldNames.Count; i++)
{
Panel t_panel = new Panel();
ComboBox t_combo = new ComboBox();
TextBox t_textBox = new TextBox();
t_textBox.Location = new Point(3, 30);
t_combo.Items.Add("Other");
t_combo.SelectedItem = "Other";
t_combo.Location = new System.Drawing.Point(4, 6);
t_combo.Size = new System.Drawing.Size(121, 13);
//t_combo.Tag = new TableLayoutPanelCellPosition(i, j);
t_combo.DropDownStyle = ComboBoxStyle.DropDownList;
t_combo.FlatStyle = FlatStyle.Popup;
t_panel.AutoSize = true;
t_panel.AutoSizeMode = System.Windows.Forms.AutoSizeMode.GrowAndShrink;
t_panel.BorderStyle = BorderStyle.FixedSingle;
t_panel.SuspendLayout();
if (i >= 4 & i < 21)
{
t_combo.Items.AddRange(fFunc.getComboItems("group_id", (i - 2).ToString(), "member_description", "po_specs"));
t_panel.Controls.Add(t_combo);
t_combo.SelectedIndex = 1;
t_combo.Tag = "";
if ((string)t_combo.SelectedItem == "Other")
{
t_textBox.Text = "";
t_panel.Controls.Add(t_textBox);
}
}
else if (i < 4)
{
t_textBox.Text = "";
if (i == 2)
t_textBox.Text = "$";
t_textBox.Location = new System.Drawing.Point(4, 6);
t_panel.Controls.Add(t_textBox);
}
t_panel.ResumeLayout();
if (i <= 20)
{
tableLayoutPanel1_SA_insert_addDetails.SuspendLayout();
tableLayoutPanel1_SA_insert_addDetails.Controls.Add(t_panel, colCount - 1, i + 1);
//t_panel.Tag = ds.Tables[0].Rows[i][j].ToString(); // TODO: Remove
tableLayoutPanel1_SA_insert_addDetails.ResumeLayout();
}
t_combo.SelectedIndexChanged += t_combo_SelectedIndexChanged;
}
tableLayoutPanel1_SA_insert_addDetails.SuspendLayout();
tableLayoutPanel1_SA_insert_addDetails.GetControlFromPosition((colCount - 1), 20).Tag = textBox_Cust_PO_Num_copy.Text; // Adding tag to store po num.
tableLayoutPanel1_SA_insert_addDetails.GetControlFromPosition((colCount - 1), 21).Tag = "0"; // Adding tag to indicate new row.
tableLayoutPanel1_SA_insert_addDetails.ResumeLayout();
//<--
// adding gang number and job number, fetched with po_details.id -->
string str1 = "Initial";
string str2 = "-no val-";
Label t_lbl6 = new Label();
Label t_lbl7 = new Label();
t_lbl6.Text = str1;
tableLayoutPanel1_SA_insert_addDetails.Controls.Add(t_lbl6, colCount - 1, 22);
t_lbl7.Text = str2;
tableLayoutPanel1_SA_insert_addDetails.Controls.Add(t_lbl7, colCount - 1, 23);
// <--
// To display total order quantity -->
int totalOrderQty = 0;
for (int j = 1; j < colCount; j++)
{
totalOrderQty += Int32.Parse((tableLayoutPanel1_SA_insert_addDetails.GetControlFromPosition(j, 1).GetChildAtPoint(new Point(4, 6)).Text == "" ? "0" : tableLayoutPanel1_SA_insert_addDetails.GetControlFromPosition(j, 1).GetChildAtPoint(new Point(4, 6)).Text));
}
Label_SA_insert_OrderQty2.Text = totalOrderQty.ToString();
// <--
//<-1- end of common code
}
private void button_SA_edit_getData_Click(object sender, EventArgs e)
{
// --> Get po details data based on customer po number
if (listView1_SA_edit_search.SelectedItems.Count == 0)
{
MessageBox.Show("Please select the PO entry first.", "Error!", MessageBoxButtons.OK, MessageBoxIcon.Warning);
return;
}
button_SA_edit_PoD.Visible = true;
button_SA_edit_PoD.Enabled = true;
label_SA_updateSuccess.Visible = false;
string po_entry_id = "";
ConnectToMySQL dbc = new ConnectToMySQL(user_id_lbl.Text, user_hash_lbl.Text);
tableLayoutPanel1_SA_edit_addDetails.Controls.Clear();
// adding field names of po_details table -->
fldNames.Clear();
fldNames.Add("order_qty");
fldNames.Add("card_name");
fldNames.Add("card_denom");
fldNames.Add("cvv");
fldNames.Add("card_size");
fldNames.Add("card_thickness");
fldNames.Add("card_material");
fldNames.Add("num_colors");
fldNames.Add("lamination");
fldNames.Add("magnetic");
fldNames.Add("pin");
fldNames.Add("barcode");
fldNames.Add("sol");
fldNames.Add("hot_stamp");
fldNames.Add("signature_panel");
fldNames.Add("silk_screen");
fldNames.Add("hole_punch");
fldNames.Add("single_pack");
fldNames.Add("bundle_pack");
fldNames.Add("inner_box");
fldNames.Add("outer_box"); //21 == i20
fldNames.Add("id");
//<--
po_entry_id = listView1_SA_edit_search.SelectedItems[0].Tag.ToString();
DataSet ds = new DataSet();
FormFunctions fFunc = new FormFunctions(user_id_lbl.Text, user_hash_lbl.Text);
string query = "SELECT " + string.Join(", ", fldNames.ToArray());
query += " FROM sales_vars WHERE cust_po_number = '" + listView1_SA_edit_search.SelectedItems[0].SubItems[1].Text + "'; ";
ds = dbc.SelectMyDA(query);
// <--
label11.Text = "Customer Name: "+ dbc.SelectSingle("cust_name", "sales_vars", "cust_po_number", po_entry_id);
label12.Text = "Customer PO#: "+ po_entry_id;
label11.Visible = true;
label12.Visible = true;
// Adding Column Headers for table layout panel 1 -->
Label t_lbl2 = new Label(); t_lbl2.Text = "PO Detail Fields";
tableLayoutPanel1_SA_edit_addDetails.Controls.Add(t_lbl2, 0, 0);
//<--
// adding field names to table layout panel 1 -->
for (int i = 0; i < 21; i++)
{
Label t_lbl = new Label();
t_lbl.Text = fldNames[i];
tableLayoutPanel1_SA_edit_addDetails.Controls.Add(t_lbl, 0, i + 1);
}
//<--
// adding gang number and job number to table layout panel 1 -->
Label t_lbl4 = new Label();
Label t_lbl5 = new Label();
Label t_lbl8 = new Label();
Label t_lbl9 = new Label();
t_lbl4.Text = "Gang Number:";
t_lbl5.Text = "Job Number:";
t_lbl8.Text = "Data Approval:";
t_lbl9.Text = "Art Approval:";
tableLayoutPanel1_SA_edit_addDetails.Controls.Add(t_lbl4, 0, 22);
tableLayoutPanel1_SA_edit_addDetails.Controls.Add(t_lbl5, 0, 23);
tableLayoutPanel1_SA_edit_addDetails.Controls.Add(t_lbl8, 0, 24);
tableLayoutPanel1_SA_edit_addDetails.Controls.Add(t_lbl9, 0, 25);
// <--
// adding data columns with field values from database for selected PO number -->
int colCount = 1;
tableLayoutPanel1_SA_edit_addDetails.ColumnCount = colCount;
this.tableLayoutPanel1_SA_edit_addDetails.ColumnStyles.Add(new System.Windows.Forms.ColumnStyle());
for (int i = 0; i < ds.Tables[0].Rows.Count; i++)
{
colCount++;
this.tableLayoutPanel1_SA_edit_addDetails.ColumnCount = colCount;
this.tableLayoutPanel1_SA_edit_addDetails.ColumnStyles.Add(new System.Windows.Forms.ColumnStyle());
Label t_lbl3 = new Label(); t_lbl3.Text = "PO Detail Values " + (i + 1).ToString();
tableLayoutPanel1_SA_edit_addDetails.Controls.Add(t_lbl3, i + 1, 0);
for (int j = 0; j < 21; j++)
{
Panel t_panel = new Panel();
ComboBox t_combo = new ComboBox();
TextBox t_textBox = new TextBox();
t_textBox.Location = new Point(3, 30);
t_combo.Items.Add("Other");
t_combo.SelectedItem = "Other";
t_combo.Location = new System.Drawing.Point(4, 6);
t_combo.Size = new System.Drawing.Size(121, 13);
//t_combo.Tag = new TableLayoutPanelCellPosition(i, j);
t_combo.DropDownStyle = ComboBoxStyle.DropDownList;
t_combo.FlatStyle = FlatStyle.Popup;
t_panel.AutoSize = true;
t_panel.AutoSizeMode = System.Windows.Forms.AutoSizeMode.GrowAndShrink;
t_panel.BorderStyle = BorderStyle.FixedSingle;
t_panel.SuspendLayout();
if (j >= 4 & j < 21)
{
t_combo.Items.AddRange(fFunc.getComboItems("group_id", (j-2).ToString(), "member_description", "po_specs"));
t_panel.Controls.Add(t_combo);
t_combo.SelectedItem = ds.Tables[0].Rows[i][j].ToString();
t_combo.Tag = ds.Tables[0].Rows[i][j].ToString();
if ((string)t_combo.SelectedItem == "Other")
{
t_textBox.Text = ds.Tables[0].Rows[i][j].ToString();
t_panel.Controls.Add(t_textBox);
}
}
else
{
t_textBox.Text = ds.Tables[0].Rows[i][j].ToString();
t_textBox.Location = new System.Drawing.Point(4, 6);
t_panel.Controls.Add(t_textBox);
}
t_panel.ResumeLayout();
tableLayoutPanel1_SA_edit_addDetails.SuspendLayout();
tableLayoutPanel1_SA_edit_addDetails.Controls.Add(t_panel, i + 1, j + 1);
tableLayoutPanel1_SA_edit_addDetails.ResumeLayout();
t_combo.SelectedIndexChanged += t_combo_SelectedIndexChanged;
}
tableLayoutPanel1_SA_edit_addDetails.GetControlFromPosition((colCount - 1), 21).Tag = ds.Tables[0].Rows[i][21]; // Adding tag to indicate row id
// adding gang number and job number, fetched with po_details.id -->
string str1 = dbc.SelectSingle("graphics_vars_gang_id", "graphics_vars_job", "sales_vars_id", ds.Tables[0].Rows[i][21].ToString());
string str2 = dbc.SelectSingle("job_number", "graphics_vars_job", "sales_vars_id", ds.Tables[0].Rows[i][21].ToString());
string str3 = dbc.SelectSingle("DataApproved", "sales_vars", "id", ds.Tables[0].Rows[i][21].ToString());
string str4 = dbc.SelectSingle("ArtApproved", "sales_vars", "id", ds.Tables[0].Rows[i][21].ToString());
Label t_lbl6 = new Label();
Label t_lbl7 = new Label();
CheckBox t_chkBox1 = new CheckBox();
CheckBox t_chkBox2 = new CheckBox();
t_lbl6.Text = str1;
tableLayoutPanel1_SA_edit_addDetails.Controls.Add(t_lbl6, i + 1, 22);
t_lbl7.Text = str2;
tableLayoutPanel1_SA_edit_addDetails.Controls.Add(t_lbl7, i + 1, 23);
// <--
// adding checkboxes for data and art appoval -->
if (str1 == "" || str2 == "")
{
t_chkBox1.Enabled = false;
t_chkBox2.Enabled = false;
}
if (str3 == "Y")
t_chkBox1.Checked = true;
if (str4 == "Y")
t_chkBox2.Checked = true;
tableLayoutPanel1_SA_edit_addDetails.Controls.Add(t_chkBox1, i + 1, 24);
tableLayoutPanel1_SA_edit_addDetails.Controls.Add(t_chkBox2, i + 1, 25);
// <--
}
// <--
// To display total order quantity -->
int totalOrderQty = 0;
for (int j = 1; j < colCount; j++)
{
totalOrderQty += Int32.Parse((tableLayoutPanel1_SA_edit_addDetails.GetControlFromPosition(j, 1).GetChildAtPoint(new Point(4, 6)).Text == "" ? "0" : tableLayoutPanel1_SA_edit_addDetails.GetControlFromPosition(j, 1).GetChildAtPoint(new Point(4, 6)).Text));
}
Label_SA_edit_OrderQty2.Text = totalOrderQty.ToString();
// <--
}
private void Button_PT_view_updateLS_Click(object sender, EventArgs e)
{
ConnectToMySQL dbc = new ConnectToMySQL(user_id_lbl.Text, user_hash_lbl.Text);
FormFunctions fFunc = new FormFunctions(user_id_lbl.Text, user_hash_lbl.Text);
string[] machines = fFunc.getComboItems("deptID", "1", "machine_name", "machines", _order_by: "machine_name");
tLP_PT_view.Controls.Clear();
tLP_PT_view.ColumnCount = 2*(machines.Length);
tLP_PT_view.AutoSizeMode = System.Windows.Forms.AutoSizeMode.GrowAndShrink;
for(int i = 0; i < tLP_PT_view.ColumnCount; i++)
tLP_PT_view.ColumnStyles.Add(new System.Windows.Forms.ColumnStyle(SizeType.AutoSize));
for (int i = 0; i < machines.Length; i++ )
{
Label t_label = new Label();
DateTimePicker tp = new DateTimePicker();
DateTimePicker dp = new DateTimePicker();
tp.Format = DateTimePickerFormat.Time;
tp.ShowUpDown = true;
tp.Value = new DateTime(DateTime.Now.Year, DateTime.Now.Month, DateTime.Now.Day, 8, 0, 0);
t_label.Text = machines[i];
tLP_PT_view.Controls.Add(t_label, i, 0);
tLP_PT_view.SetColumnSpan(t_label, 2);
tLP_PT_view.Controls.Add(dp, (i*2), 1);
tLP_PT_view.Controls.Add(tp, ((i*2)+1), 1);
}
string query = " SELECT gang_number, PrintingType ";
query += " FROM graphics_vars_gang ";
query += " JOIN sales_vars ON sales_vars.cust_po_number = sales_vars_id ";
query += " WHERE Printing = 'Y'";
query += " AND ArtApproved = 'Y'";
query += " GROUP BY gang_number ";
DataSet ds = new DataSet();
ds = dbc.SelectMyDA(query);
for (int i = 0; i < ds.Tables[0].Rows.Count; i++)
{
List<Label> row = new List<Label>();
for (int j = 0; j < tLP_PT_view.ColumnCount; j++)
{
Label t_label2 = new Label(); t_label2.AutoSize = true;
Label t_label3 = new Label(); t_label2.AutoSize = true;
if (ds.Tables[0].Rows[i][1].ToString() == tLP_PT_view.GetControlFromPosition(j, 0).Text)
{
t_label2.Text = ds.Tables[0].Rows[i][0].ToString();
t_label3.Text = "";
row.Add(t_label2);
row.Add(t_label3);
}
else
{
t_label2.Text = "";
t_label3.Text = "";
row.Add(t_label2);
row.Add(t_label3);
}
j++;
}
tLP_PT_view.Controls.AddRange(row.ToArray());
for (int j = 0; j < tLP_PT_view.ColumnCount; j++)
{
Control ctrl = tLP_PT_view.GetControlFromPosition(j, i + 1);
string issueQty = "1";
Double timeReqd = 1;
if (ctrl.GetType() == typeof(Label))
{
if (row[j].Text != "")
{
string str = tLP_PT_view.GetControlFromPosition(j+1, i + 1).Text;
DateTime dt = (DateTime)tLP_PT_view.GetControlFromPosition(j+1, i + 1).Tag;
row[j + 1].Text = "S: " + dt.ToString();
issueQty = dbc.SelectSingle("issue_qty", "graphics_vars_gang", "gang_number", row[j].Text);
timeReqd = fFunc.getJobRuntime(tLP_PT_view.GetControlFromPosition(j, 0).Text, issueQty);
//row[j + 1].Text += " F: " + tLP_PT_view.GetControlFromPosition(j, i + 1).Tag.ToString() + " " + ((DateTimePicker)tLP_PT_view.GetControlFromPosition(j + 1, i + 1)).Value.AddHours(timeReqd).ToShortTimeString();
dt = dt.AddHours(timeReqd);
//row[j + 1].Tag = ((DateTimePicker)tLP_PT_view.GetControlFromPosition(j + 1, i + 1)).Value.AddHours(timeReqd).ToShortTimeString();
row[j + 1].Text += " F: "+ dt.ToString();
row[j + 1].Tag = dt;
}
}
else
{
if (row[j].Text != "")
{
DateTime dt = new DateTime(((DateTimePicker)ctrl).Value.Year, ((DateTimePicker)ctrl).Value.Month, ((DateTimePicker)ctrl).Value.Day, ((DateTimePicker)tLP_PT_view.GetControlFromPosition(j + 1, i + 1)).Value.Hour, ((DateTimePicker)tLP_PT_view.GetControlFromPosition(j + 1, i + 1)).Value.Minute, ((DateTimePicker)tLP_PT_view.GetControlFromPosition(j + 1, i + 1)).Value.Second);
string str = "S: " + dt.ToString() + "+" ;
issueQty = dbc.SelectSingle("issue_qty", "graphics_vars_gang", "gang_number", row[j].Text);
timeReqd = fFunc.getJobRuntime(tLP_PT_view.GetControlFromPosition(j,0).Text, issueQty);
//row[j + 1].Text += " F: " + ((DateTimePicker)ctrl).Value.ToShortDateString() + " " + ((DateTimePicker)tLP_PT_view.GetControlFromPosition(j + 1, i + 1)).Value.AddHours(timeReqd).ToShortTimeString();
dt = dt.AddHours(timeReqd);
str += " F: " + dt.ToString();
row[j + 1].Text = str;
row[j + 1].Tag = dt;
}
}
j++;
}
}
}
