///////////////////////////////////////////////////////////////// ///////////////// On form action functions ////////////////////// ///////////////////////////////////////////////////////////////// //when form loaded private void Form1_Load(object sender, EventArgs e) { productsTableAdapter.Fill(birthdaySystemDataSet3.Products); barcodesTableAdapter.Fill(birthdaySystemDataSet2.Barcodes); suppliersTableAdapter.Fill(birthdaySystemDataSet1.Suppliers); string query1 = @"SELECT DEP_Description FROM Departments WHERE DEP_Name = '" + departmentsCombo.Text + @"'"; SQLClass net1 = new SQLClass(query1, false); List <string> read1 = net1.Read(); //label10.Text = read1[0]; }
private void ComboBox1_TextChanged(object sender, EventArgs e) { try { string query = @"SELECT DEP_Description FROM Departments WHERE DEP_Name = '" + departmentsCombo.Text + @"'"; SQLClass net = new SQLClass(query, false); List <string> read = net.Read(); label10.Text = read[0]; } catch (Exception ex) { } }
bool IsSupplierFree(string s, TextBox t) { SQLClass net = new SQLClass((@"SELECT SUP_Code FROM Suppliers WHERE SUP_Code = '" + s + @"'"), false); List <string> read = net.Read(); if (read.Count == 0) { return(true); } else { if (dataGridView3.SelectedRows[0].Cells[0].Value.ToString() == s && editing == true) { return(true); } } InvalidInput(t, "Supplier code already in use"); return(false); }
//checks DB for other products with the same product ID bool IsProductNumberFree(string s, TextBox t) { SQLClass net = new SQLClass((@"SELECT PRO_Code FROM Products WHERE PRO_Code = '" + s + @"'"), false); List <string> read = net.Read(); if (read.Count == 0) { return(true); } else { if (dataGridView1.SelectedRows[0].Cells[0].Value.ToString() == s && editing == true) { return(true); } } InvalidInput(t, "Product ID already in use"); return(false); }
void SetupForm() { //add to arrays { _userEntryHeaders.Add(label2); _userEntryHeaders.Add(label3); _userEntryHeaders.Add(label4); _userEntryHeaders.Add(label5); _userEntryHeaders.Add(label6); _userEntryHeaders.Add(label7); _userEntryHeaders.Add(label8); _userEntryHeaders.Add(label12); _userEntryHeaders.Add(label13); _userEntryHeaders.Add(label14); _userEntryHeaders.Add(label15); _userEntryHeaders.Add(label16); _userEntryProducts.Add(textBox1); _userEntryProducts.Add(textBox2); _userEntryProducts.Add(textBox3); _userEntryProducts.Add(textBox4); _userEntryProducts.Add(textBox5); _userEntryProducts.Add(textBox6); _userEntryBarcodes.Add(textBox7); _userEntryBarcodes.Add(textBox8); _userEntrySuppliers.Add(textBox9); _userEntrySuppliers.Add(textBox10); _userEntrySuppliers.Add(textBox11); } //set text, disable { for (int i = 0; i < _userEntryHeaders.Count; i++) { _userEntryHeaders[i].Text = _names[i]; } for (int i = 0; i < _userEntryProducts.Count; i++) { _userEntryProducts[i].Enabled = false; } for (int i = 0; i < _userEntryBarcodes.Count; i++) { _userEntryBarcodes[i].Enabled = false; } for (int i = 0; i < _userEntrySuppliers.Count; i++) { _userEntrySuppliers[i].Enabled = false; } departmentsCombo.Enabled = false; } //combobox1 populate { SQLClass net = new SQLClass("SELECT DEP_Name FROM Departments", false); List <string> read = net.Read(); for (int i = 0; i < read.Count; i++) { Label temp1 = new Label { Name = "lb" + i.ToString(), Text = read[i] }; departmentsCombo.Items.Add(temp1); departmentsCombo.DisplayMember = "Text"; } } }