示例#1
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)
     {
     }
 }
示例#2
0
        //delete supplier button
        private void Button9_Click(object sender, EventArgs e)
        {
            //if a something is selected
            if (dataGridView3.SelectedCells.Count > 0)
            {
                if (ConfimationBox("Are you sure you wish to delete?"))
                {
                    string   q1   = "DELETE FROM Suppliers WHERE SUP_Code = " + dataGridView3.SelectedRows[0].Cells[0].Value;
                    SQLClass net1 = new SQLClass(q1, true);
#if DEBUG
                    outputFile.WriteLine(DateTime.Now + "" + "Deleted Supplier where PK was " + dataGridView3.SelectedRows[0].Cells[4].Value);
#endif
                    StoreIndices();
                    RefreshTables();
                    dataGridView1.Rows[_indices[SelectionItemTypes.Product]].Selected = true;
                    dataGridView2.Rows[_indices[SelectionItemTypes.Barcode]].Selected = true;
                    editing = false;
                }
            }
        }
示例#3
0
        //Delete product Button
        private void Button2_Click(object sender, EventArgs e)
        {
            //if a something is selected
            if (dataGridView1.SelectedCells.Count > 0)
            {
                if (ConfimationBox("Are you sure you wish to delete?"))
                {
                    SQLClass net = new SQLClass("DELETE FROM Products WHERE PRO_PK = " +
                                                dataGridView1.SelectedRows[0].Cells[_PKCOLUMN].Value, true);
#if DEBUG
                    outputFile.WriteLine(DateTime.Now + "" + "Deleted Product where PK was " + dataGridView1.SelectedRows[0].Cells[_PKCOLUMN].Value);
#endif

                    RefreshTables();


                    editing = false;
                }
            }
        }
示例#4
0
        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);
        }
示例#5
0
        //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);
        }
示例#6
0
        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";
                }
            }
        }