public List<List<string>> ColValues(string _tblName) { ConnectToMySQL dbc = new ConnectToMySQL(user_id, user_hash); List<List<string>> gd = new List<List<string>>(); string query = "SELECT * FROM " + _tblName + ";"; string countq = "SELECT COUNT(*) FROM " + _tblName + ";"; int count = dbc.Count(countq); List<string> IDs = dbc.Select("SELECT id FROM " + _tblName + ";"); for (int i = 0; i < count; i++) { List<string> gd1 = dbc.Select("SELECT * FROM "+_tblName+" WHERE id = " + IDs[i].ToString() + ";"); gd.Add(gd1); } return gd; }
private void btn1_GD_insert_InsertGang_Click(object sender, EventArgs e) { ConnectToMySQL dbc = new ConnectToMySQL(user_id_lbl.Text, user_hash_lbl.Text); label_GD_insert_newGangSuccess.Visible = false; if (dbc.Count("SELECT COUNT(id) FROM graphics_vars_gang WHERE gang_number = '"+txtBox_gang_num.Text+"';") > 0) { MessageBox.Show("Please enter new gang number", "Error!", MessageBoxButtons.OK, MessageBoxIcon.Warning); return; } List<string> g_fldNames = new List<string>(); List<string> g_fldVals = new List<string>(); g_fldNames.Add("gang_number"); g_fldVals.Add(txtBox_gang_num.Text); dbc.Insert(g_fldNames, "graphics_vars_gang", g_fldVals, user_id_lbl.Text); //TODO: uncomment label_GD_insert_newGangSuccess.Visible = true; }
private void button_GD_insert_InsertJob_Click(object sender, EventArgs e) { ConnectToMySQL dbc = new ConnectToMySQL(user_id_lbl.Text, user_hash_lbl.Text); TableLayoutPanel tlp_gd_insert_job = (TableLayoutPanel)((Control)sender).Tag; List<string> j_fldNames = new List<string>(); List<string> j_fldVals = new List<string>(); string s_id = tlp_gd_insert_job.GetControlFromPosition(2, 14).Name; // checking duplicate entry of job --> string query = " SELECT cust_po_number, sales_vars.id "; query += " FROM sales_vars "; query += " WHERE cust_po_number = '" + dbc.SelectSingle("cust_po_number", "sales_vars", "id", s_id) + "'; "; DataSet ds = new DataSet(); int count = 0; ds = dbc.SelectMyDA(query); for (int i = 0; i < ds.Tables[0].Rows.Count; i++) { if (dbc.Count("SELECT COUNT(id) FROM graphics_vars_job WHERE sales_vars_id = '" + ds.Tables[0].Rows[i][1].ToString() + "';") > 0) count++; if (count == ds.Tables[0].Rows.Count) return; } // <-- j_fldNames.AddRange(new string[] { "sales_vars_id", "graphics_vars_gang_id", "job_number", "Retailer", "ProjectedDueDate", "ActualDueDate", "PinCover", "Personalization_job", "CardRatio", "Other_Barcode", "MinPrintQty", "MagStripe", "Encode", "user_id" }); j_fldVals.Add(s_id); j_fldVals.Add(((ComboBox)tlp_gd_insert_job.GetControlFromPosition(0, 11)).SelectedItem.ToString()); j_fldVals.Add(tlp_gd_insert_job.GetControlFromPosition(0, 1).Text); j_fldVals.Add(tlp_gd_insert_job.GetControlFromPosition(1, 3).Text); j_fldVals.Add(tlp_gd_insert_job.GetControlFromPosition(2, 7).Text); j_fldVals.Add(tlp_gd_insert_job.GetControlFromPosition(2, 9).Text); j_fldVals.Add(tlp_gd_insert_job.GetControlFromPosition(1, 11).Text); if (((CheckBox)tlp_gd_insert_job.GetControlFromPosition(2, 11)).CheckState == CheckState.Checked) j_fldVals.Add("Y"); else j_fldVals.Add("N"); j_fldVals.Add(tlp_gd_insert_job.GetControlFromPosition(0, 13).Text); j_fldVals.Add(tlp_gd_insert_job.GetControlFromPosition(1, 13).Text); j_fldVals.Add(tlp_gd_insert_job.GetControlFromPosition(2, 13).Text); if (((CheckBox)tlp_gd_insert_job.GetControlFromPosition(0, 15)).CheckState == CheckState.Checked) j_fldVals.Add("Y"); else j_fldVals.Add("N"); j_fldVals.Add(tlp_gd_insert_job.GetControlFromPosition(1, 15).Text); j_fldVals.Add(user_id_lbl.Text); dbc.Insert(j_fldNames, "graphics_vars_job", j_fldVals, user_id_lbl.Text); //TODO: uncomment tlp_gd_insert_job.GetControlFromPosition(2, 15).Tag = tlp_gd_insert_job.GetControlFromPosition(0, 1).Text; tlp_gd_insert_job.GetControlFromPosition(2, 15).Enabled = true; tlp_gd_insert_job.GetControlFromPosition(2, 15).Click += new EventHandler(t_gd_insert_buttonClick); }
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); //<-- }
private void btn2_GD_insert_InsertD_Click(object sender, EventArgs e) { ConnectToMySQL dbc = new ConnectToMySQL(user_id_lbl.Text, user_hash_lbl.Text); List<string> fldVals = new List<string>(); string query = ((Button)sender).Tag.ToString(); // TODO: can replace with "". Plugged in value for testing purposes string gang_number = "Initial"; if (comboBox_GD_insert_0x0.SelectedItem.ToString() == "New") { gang_number = textBox_GD_insert_0x1.Text; if (dbc.Count("SELECT COUNT(id) FROM graphics_vars_gang WHERE gang_number = '" + textBox_GD_insert_0x1.Text + "';") > 0) { MessageBox.Show("Please enter new gang number", "Error!", MessageBoxButtons.OK, MessageBoxIcon.Warning); return; } } else gang_number = comboBox_GD_insert_0x0.SelectedItem.ToString(); if (dbc.Count("SELECT COUNT(id) FROM graphics_vars_gang WHERE sales_vars_id = '" + label_GD_insert_0x3.Text + "' AND gang_number = '" + gang_number + "';") > 0) return; // adding field names --> fldNames.Clear(); fldNames.AddRange(new string[] {"user_id", "sales_vars_id", "gang_number", "sheet_size", "print_qty", "issue_qty", "PrintOnFaceFront", "PrintOnFaceBack", "SideGuideFront", "SideGuideBack", "UVCoatingBack", "up_size" }); // <-- // adding field values --> fldVals.Add(user_id_lbl.Text); fldVals.Add(label_GD_insert_0x3.Text); fldVals.Add(gang_number); fldVals.Add(textBox_GD_insert_1x5.Text); fldVals.Add(textBox_GD_insert_2x7.Text); fldVals.Add(textBox_GD_insert_2x9.Text); fldVals.Add(textBox_GD_insert_0x7.Text); fldVals.Add(textBox_GD_insert_1x7.Text); fldVals.Add(textBox_GD_insert_0x11.Text); fldVals.Add(textBox_GD_insert_1x11.Text); fldVals.Add(textBox_GD_insert_1x13.Text); fldVals.Add(label_GD_insert_2x3.Text); // --> dbc.Insert(fldNames, "graphics_vars_gang", fldVals, user_id_lbl.Text); // TODO: uncomment button_GD_insert_gang_PS.Enabled = true; button_GD_insert_gang_PS.Tag = gang_number; }