Ejemplo n.º 1
0
        private void btnAddAccount_Click(object sender, EventArgs e)
        {
            DatabaseColumn dataset    = new DatabaseColumn();
            Connector      connection = new MYSQLDatabaseConnection();



            dataset.counter_id   = connection.SearchCounterList(counterList, cmbCounterName.Text.ToString()).counter_id;
            dataset.type         = cmbType.SelectedIndex.ToString();
            dataset.user_name    = txtUserName.Text.ToString();
            dataset.user_id      = txtUserId.Text.ToString();
            dataset.password     = txtPassword.Text.ToString();
            dataset.counter_name = cmbCounterName.Text.ToString();

            connection.SetData(dataset);
            connection.establish();

            if (connection.InsertUser())
            {
                MessageBox.Show("Complete");
                txtPassword.Clear();
                txtUserId.Clear();
                txtUserName.Clear();
                txtVerifyPassowrd.Clear();
            }
            else
            {
                MessageBox.Show("Error");
            }
        }
Ejemplo n.º 2
0
        private void btnAdd_Click(object sender, EventArgs e)
        {
            Connector      databaseConnect = new MYSQLDatabaseConnection();
            DatabaseColumn databaseColumn  = new DatabaseColumn();

            databaseColumn.category_name = txtCategoryName.Text.ToString();
            databaseColumn.category_id   = txtCategoryId.Text.ToString();

            databaseConnect.SetData(databaseColumn);



            if (databaseConnect.establish() == true && databaseConnect.InsertCategoryDetails() == true)
            {
                var list = new List <DatabaseColumn>()
                {
                    new DatabaseColumn {
                        category_name = txtCategoryName.Text.ToString(), category_id = txtCategoryId.Text.ToString()
                    }
                };
                CombineDataGridView combineDataGridView = new CombineDataGridView();
                combineDataGridView.SetDataGridViewList(list, mDgv);//connect main window datagridview

                txtCategoryId.Clear();
                txtCategoryName.Clear();
            }
            else
            {
                MessageBox.Show("operation error");
            }
        }
Ejemplo n.º 3
0
        private void cmbCompanyName_SelectedIndexChanged(object sender, EventArgs e)
        {
            var t = new Task(() => { });

            t.Start();
            t.ContinueWith(task => {
                Connector databaseConnectCategory = new MYSQLDatabaseConnection();

                companyId = databaseConnectCategory.SearchCompanyList(tempCompanyList, cmbCompanyName.SelectedItem.ToString());

                if (databaseConnectCategory.establish() == true)
                {
                    databaseConnectCategory.SetData(companyId);
                    List <DatabaseColumn> CategoryList = databaseConnectCategory.GetCategoryNameForEachCompany();

                    foreach (DatabaseColumn databseColumn in CategoryList)
                    {
                        cmbCategoryName.Items.Add(databseColumn.category_name);//add category name into combo box

                        tempCategoryList.Add(new DatabaseColumn()
                        {
                            category_name = databseColumn.category_name,
                            category_id   = databseColumn.category_id,
                        }
                                             );
                    }
                }
                else
                {
                    MessageBox.Show("connection error");
                }
            }, System.Threading.CancellationToken.None, TaskContinuationOptions.None, TaskScheduler.FromCurrentSynchronizationContext());
        }
Ejemplo n.º 4
0
        private void btnChange_Click(object sender, EventArgs e)
        {
            DialogResult dialogResult = MessageBox.Show("Are you Sure update company details?", "Veryfy", MessageBoxButtons.YesNo);

            if (dialogResult == DialogResult.Yes)
            {
                /*catch update details into databaseColumn*/
                DatabaseColumn updateDatabaseColumn = new DatabaseColumn();
                updateDatabaseColumn.company_id       = txtCompanyId.Text.ToString();
                updateDatabaseColumn.company_name     = txtCompanyName.Text.ToString();
                updateDatabaseColumn.company_address  = txtCompanyAddress.Text.ToString();
                updateDatabaseColumn.company_phone_no = txtCompanyPhoneNumber.Text.ToString();



                Connector connector = new MYSQLDatabaseConnection();
                connector.establish();
                connector.SetData(updateDatabaseColumn);

                if (connector.ChangeCompany() == true)
                {
                    MessageBox.Show("Update compliete");

                    /*refresh main data grid view and show update company deteils*/
                    redioBtnCompanyId.Checked = true;
                    txtSearch.Text            = txtCompanyId.Text;
                    btnSearch.PerformClick();
                }
                else
                {
                    MessageBox.Show("Try again");
                }
            }
        }
Ejemplo n.º 5
0
        private void btnChange_Click(object sender, EventArgs e)
        {
            if (cmbCompanyName.SelectedItem != null && cmbCategoryName.SelectedItem != null && cmbProductName.SelectedItem != null)
            {
                Connector connection = new MYSQLDatabaseConnection();

                DatabaseColumn dataset = new DatabaseColumn();
                dataset.product_id     = connection.SearchProductList(tempProductList, cmbProductName.SelectedIndex.ToString()).product_id;
                dataset.stock_date     = txtStockDate.Text.ToString();
                dataset.invoice_number = txtInvoiceNumber.Text.ToString();
                dataset.start_quantity = txtQuantity.Text.ToString();
                dataset.exp_date       = txtExpDate.Text.ToString();
                dataset.get_price      = txtGetPrice.Text.ToString();
                dataset.barcode        = barcode;
                connection.SetData(dataset);

                connection.establish();
                if (connection.ChangeStockDetails())
                {
                    List <DatabaseColumn> dgvList = new List <DatabaseColumn>();
                    dgvList.Add(dataset);
                    CombineDataGridView combindDataGrid = new CombineDataGridView();
                    combindDataGrid.SetDataGridViewList(dgvList, dgv);
                    MessageBox.Show("changed");
                }
                else
                {
                    MessageBox.Show("can't changed");
                }
            }
            else
            {
                MessageBox.Show("fill all requred data");
            }
        }
Ejemplo n.º 6
0
        private void AddStock_Shown(object sender, EventArgs e)
        {
            var t = new Task(() => { });

            t.Start();
            t.ContinueWith(task => {
                Connector databaseConnectCompany = new MYSQLDatabaseConnection();

                if (databaseConnectCompany.establish() == true)
                {
                    List <DatabaseColumn> CompanyList = databaseConnectCompany.GetAllCompanyNameWithId();

                    foreach (DatabaseColumn databseColumn in CompanyList)
                    {
                        cmbCompanyName.Items.Add(databseColumn.company_name);//add company name into combo box

                        tempCompanyList.Add(new DatabaseColumn()
                        {
                            company_name = databseColumn.company_name,
                            company_id   = databseColumn.company_id,
                        }
                                            );
                    }
                }
                else
                {
                    MessageBox.Show("connection error");
                }
            }, System.Threading.CancellationToken.None, TaskContinuationOptions.None, TaskScheduler.FromCurrentSynchronizationContext());
        }
Ejemplo n.º 7
0
        private void btnRemove_Click(object sender, EventArgs e)
        {
            DialogResult dialogResult = MessageBox.Show("Are you Sure delete category?", "Veryfy", MessageBoxButtons.YesNo);

            if (dialogResult == DialogResult.Yes)
            {
                /*catch update details into databaseColumn*/
                DatabaseColumn deleteDatabaseColumn = new DatabaseColumn();
                deleteDatabaseColumn.category_id   = txtCategoryId.Text.ToString();
                deleteDatabaseColumn.category_name = txtCategoryName.Text.ToString();

                Connector connector = new MYSQLDatabaseConnection();
                connector.establish();
                connector.SetData(deleteDatabaseColumn);

                if (connector.RemoveCategory() == true)
                {
                    MessageBox.Show("Delete compliete");

                    /*refresh main data grid view*/
                    redioBtnCategoryId.Checked = true;
                    txtSearch.Text             = txtCategoryId.Text;
                    btnSearch.PerformClick();
                    txtSearch.Clear();
                }
                else
                {
                    MessageBox.Show("Try again");
                }
            }
        }
Ejemplo n.º 8
0
        private void SetCategoryListIntoCategoryComboBox()
        {
            var t = new Task(() => { });

            t.Start();
            t.ContinueWith(task => {
                Connector databaseConnectCategory = new MYSQLDatabaseConnection();

                if (databaseConnectCategory.establish() == true)
                {
                    DatabaseColumn databaseColumn = new DatabaseColumn();
                    databaseColumn.company_id     = databaseConnectCategory.SearchCompanyList(TempCompanyList, cmbSearchCompanyName.SelectedItem.ToString()).company_id;
                    databaseConnectCategory.SetData(databaseColumn);
                    List <DatabaseColumn> CategoryList = databaseConnectCategory.GetCategoryNameForEachCompany();


                    cmbSearchCategoryName.Items.Clear();
                    cmbSearchCategoryName.Text = "";
                    foreach (DatabaseColumn databseColumn in CategoryList)
                    {
                        cmbSearchCategoryName.Items.Add(databseColumn.category_name);//add category name into combo box
                    }
                }
                else
                {
                    MessageBox.Show("connection error");
                }
            }, System.Threading.CancellationToken.None, TaskContinuationOptions.None, TaskScheduler.FromCurrentSynchronizationContext());
        }
Ejemplo n.º 9
0
        private void btnRemove_Click(object sender, EventArgs e)
        {
            DialogResult dialogResult = MessageBox.Show("Are you Sure delete stock?", "Veryfy", MessageBoxButtons.YesNo);

            if (dialogResult == DialogResult.Yes)
            {
                Connector      connection = new MYSQLDatabaseConnection();
                DatabaseColumn dataset    = new DatabaseColumn();
                dataset.barcode = barcode;
                connection.SetData(dataset);
                connection.establish();
                if (connection.RemoveStockDetails())
                {
                    MessageBox.Show("Deleted");
                }
                txtExpDate.Clear();
                txtGetPrice.Clear();
                txtInvoiceNumber.Clear();
                txtQuantity.Clear();
                txtStockDate.Clear();
                cmbCategoryName.Text = "";
                cmbCompanyName.Text  = "";
                cmbProductName.Text  = "";
                txtBarcode.Focus();
            }
        }
Ejemplo n.º 10
0
        private void btnSearch_Click(object sender, EventArgs e)
        {
            List <DatabaseColumn> list = new List <DatabaseColumn>();
            CombineDataGridView   combineDataGridView = new CombineDataGridView();

            if (txtSearch.Text != "")
            {
                DatabaseColumn databaseColumn = new DatabaseColumn();
                Connector      connector      = new MYSQLDatabaseConnection();
                connector.establish();

                if (redioBtnCompanyName.Checked == true)
                {
                    databaseColumn.company_name = txtSearch.Text.ToString();
                    connector.SetData(databaseColumn);
                    list = connector.SearchCompanyWithName();
                    combineDataGridView.SetDataGridViewList(list, mDgv);//connect main window datagridview
                }
                else if (redioBtnCompanyAddress.Checked == true)
                {
                    databaseColumn.company_address = txtSearch.Text.ToString();
                    connector.SetData(databaseColumn);
                    list = connector.SearchCompanyWithAddress();
                    combineDataGridView.SetDataGridViewList(list, mDgv);
                }
                else if (redioBtnCompanyPhoneNumber.Checked == true)
                {
                    databaseColumn.company_phone_no = txtSearch.Text.ToString();
                    connector.SetData(databaseColumn);
                    list = connector.SearchCompanyWithPhoneNo();
                    combineDataGridView.SetDataGridViewList(list, mDgv);
                }
                else if (redioBtnCompanyId.Checked == true)
                {
                    databaseColumn.company_id = txtSearch.Text.ToString();
                    connector.SetData(databaseColumn);
                    list = connector.SearchCompanyWithId();
                    combineDataGridView.SetDataGridViewList(list, mDgv);
                }

                if (list.Count > 0)
                {
                    txtCompanyAddress.Text     = list[0].company_address;
                    txtCompanyId.Text          = list[0].company_id;
                    txtCompanyName.Text        = list[0].company_name;
                    txtCompanyPhoneNumber.Text = list[0].company_phone_no;
                }
                else
                {
                    txtCompanyAddress.Clear();
                    txtCompanyId.Clear();
                    txtCompanyName.Clear();
                    txtCompanyPhoneNumber.Clear();
                }
            }
            else
            {
                combineDataGridView.SetDataGridViewList(list, mDgv);
            }
        }
Ejemplo n.º 11
0
        private void txtBarcode_KeyDown(object sender, KeyEventArgs e)
        {
            if (e.KeyCode == Keys.Enter)
            {
                Connector      conection = new MYSQLDatabaseConnection();
                DatabaseColumn dataset   = new DatabaseColumn();
                dataset.barcode = txtBarcode.Text.ToString();
                barcode         = txtBarcode.Text.ToString();
                conection.SetData(dataset);
                conection.establish();
                DatabaseColumn data = conection.GetStockUsingBarcode();
                txtBarcode.Clear();

                txtExpDate.Text       = data.exp_date;
                txtGetPrice.Text      = data.get_price;
                txtInvoiceNumber.Text = data.invoice_number;
                txtQuantity.Text      = data.start_quantity;
                txtStockDate.Text     = data.stock_date;
                cmbCompanyName.Text   = data.company_name;
                cmbCategoryName.Text  = data.category_name;
                cmbProductName.Text   = data.product_name;

                var t = new Task(() => { });
                t.Start();
                t.ContinueWith(task => {
                    Connector databaseConnectCompany = new MYSQLDatabaseConnection();

                    if (databaseConnectCompany.establish() == true)
                    {
                        List <DatabaseColumn> CompanyList = databaseConnectCompany.GetAllCompanyNameWithId();

                        foreach (DatabaseColumn databseColumn in CompanyList)
                        {
                            cmbCompanyName.Items.Add(databseColumn.company_name);//add company name into combo box

                            tempCompanyList.Add(new DatabaseColumn()
                            {
                                company_name = databseColumn.company_name,
                                company_id   = databseColumn.company_id,
                            }
                                                );
                        }
                    }
                    else
                    {
                        MessageBox.Show("connection error");
                    }
                }, System.Threading.CancellationToken.None, TaskContinuationOptions.None, TaskScheduler.FromCurrentSynchronizationContext());
            }
        }
Ejemplo n.º 12
0
        private void btnAdd_Click_1(object sender, EventArgs e)
        {
            if (txtDiscount.Text != "" && txtMinimumQuantity.Text != "" && txtProductId.Text != "" && txtProductName.Text != "" && txtSellPrice.Text != "" && cmbCategoryName.Text != "" && cmbCompanyName.Text != "")
            {
                Connector      databaseConnect = new MYSQLDatabaseConnection();
                DatabaseColumn databaseColumn  = new DatabaseColumn();

                CombineDataGridView   combineDataGridView = new CombineDataGridView();
                List <DatabaseColumn> list = new List <DatabaseColumn>();

                /*get data into database column object*/
                databaseColumn.product_id             = txtProductId.Text.ToString();
                databaseColumn.product_name           = txtProductName.Text.ToString();
                databaseColumn.company_name           = cmbCompanyName.Text;
                databaseColumn.category_id            = databaseConnect.SearchCategoryList(TempCategoryList, cmbCategoryName.Text).category_id;
                databaseColumn.category_name          = cmbCategoryName.Text;
                databaseColumn.company_id             = databaseConnect.SearchCompanyList(TempCompanyList, cmbCompanyName.Text).company_id;
                databaseColumn.minimum_quantity       = txtMinimumQuantity.Text.ToString();
                databaseColumn.product_discount_price = txtDiscount.Text.ToString();
                databaseColumn.sell_price             = txtSellPrice.Text.ToString();


                databaseConnect.SetData(databaseColumn);
                databaseConnect.establish();

                if (databaseConnect.InsertProductDetails() == true)
                {
                    list.Add(databaseColumn);
                    combineDataGridView.SetDataGridViewList(list, mDgv);//connect main window datagridview
                    MessageBox.Show("comlete");
                    txtDiscount.Clear();
                    txtMinimumQuantity.Clear();
                    txtProductId.Clear();
                    txtProductName.Clear();
                    txtSellPrice.Clear();
                    cmbCategoryName.Text = "";
                    cmbCompanyName.Text  = "";
                }
                else
                {
                    MessageBox.Show("operation error");
                }
            }
            else
            {
                MessageBox.Show("Fill all deteils");
            }
        }
Ejemplo n.º 13
0
        private void AddAccount_Shown(object sender, EventArgs e)
        {
            cmbCounterName.Focus();
            Connector connection = new MYSQLDatabaseConnection();

            connection.establish();

            List <DatabaseColumn> Data = connection.GetCounter();

            //  counterList.Clear();
            cmbCounterName.Items.Clear();
            foreach (DatabaseColumn data in Data)
            {
                cmbCounterName.Items.Add(data.counter_name);
                counterList.Add(data);
            }
        }
Ejemplo n.º 14
0
        private void btnSearch_Click(object sender, EventArgs e)
        {
            DatabaseColumn        databaseColumn      = new DatabaseColumn();
            List <DatabaseColumn> list                = new List <DatabaseColumn>();
            CombineDataGridView   combineDataGridView = new CombineDataGridView();

            if (txtSearch.Text != "")
            {
                Connector connector = new MYSQLDatabaseConnection();
                connector.establish();


                if (redioBtnCategoryName.Checked == true)
                {
                    databaseColumn.category_name = txtSearch.Text.ToString();
                    connector.SetData(databaseColumn);
                    list = connector.SearchCategoryWithName();
                    combineDataGridView.SetDataGridViewList(list, mDgv);//connect main window datagridview
                }
                else if (redioBtnCategoryId.Checked == true)
                {
                    databaseColumn.category_id = txtSearch.Text.ToString();
                    connector.SetData(databaseColumn);
                    list = connector.SearchCategoryWithId();
                    combineDataGridView.SetDataGridViewList(list, mDgv);
                }
                if (list.Count > 0)
                {
                    txtCategoryId.Text   = list[0].category_id;
                    txtCategoryName.Text = list[0].category_name;
                }
                else
                {
                    txtCategoryName.Clear();
                    txtCategoryId.Clear();
                }
            }
            else
            {
                txtCategoryName.Clear();
                txtCategoryId.Clear();
            }
        }
Ejemplo n.º 15
0
        private void btnChange_Click(object sender, EventArgs e)
        {
            DialogResult dialogResult = MessageBox.Show("Are you Sure update product details?", "Veryfy", MessageBoxButtons.YesNo);

            if (dialogResult == DialogResult.Yes)
            {
                Connector connector = new MYSQLDatabaseConnection();

                /*catch update details into databaseColumn*/
                DatabaseColumn updateDatabaseColumn = new DatabaseColumn();
                updateDatabaseColumn.company_id             = connector.SearchCompanyList(TempCompanyList, cmbCompanyName.SelectedItem.ToString()).company_id;
                updateDatabaseColumn.category_id            = connector.SearchCategoryList(TempCategoryList, cmbCategoryName.SelectedItem.ToString()).category_id;
                updateDatabaseColumn.product_id             = txtProductId.Text.ToString();
                updateDatabaseColumn.product_name           = txtProductName.Text;
                updateDatabaseColumn.sell_price             = txtSellPrice.Text;
                updateDatabaseColumn.product_discount_price = txtDiscount.Text;
                updateDatabaseColumn.minimum_quantity       = txtMinimumQuantity.Text;

                List <DatabaseColumn> TempListForDGV = new List <DatabaseColumn>();
                TempListForDGV.Add(updateDatabaseColumn);


                connector.establish();
                connector.SetData(updateDatabaseColumn);

                if (connector.ChangeProductDetails() == true)
                {
                    CombineDataGridView combineDataGridView = new CombineDataGridView();
                    combineDataGridView.SetDataGridViewList(TempListForDGV, mDgv);
                    MessageBox.Show("Update compliete");
                    txtDiscount.Clear();
                    txtMinimumQuantity.Clear();
                    txtProductId.Clear();
                    txtProductName.Clear();
                    txtSellPrice.Clear();
                }
                else
                {
                    MessageBox.Show("Try again");
                }
            }
        }
Ejemplo n.º 16
0
        private void cmbCategoryName_SelectedIndexChanged(object sender, EventArgs e)
        {
            cmbProductName.Text = "";
            cmbProductName.Items.Clear();

            var t = new Task(() => { });

            t.Start();
            t.ContinueWith(task => {
                Connector databaseConnectProduct = new MYSQLDatabaseConnection();
                DatabaseColumn dataSet           = new DatabaseColumn();

                categoryId = databaseConnectProduct.SearchCategoryList(tempCategoryList, cmbCategoryName.SelectedItem.ToString());

                if (databaseConnectProduct.establish() == true)
                {
                    dataSet.company_id  = companyId.company_id;
                    dataSet.category_id = categoryId.category_id;

                    databaseConnectProduct.SetData(dataSet);

                    List <DatabaseColumn> ProductList = databaseConnectProduct.GetProductNameForEachCompanyAndCategory();

                    foreach (DatabaseColumn databseColumn in ProductList)
                    {
                        cmbProductName.Items.Add(databseColumn.product_name);//add category name into combo box
                        tempProductList.Add(new DatabaseColumn()
                        {
                            product_name = databseColumn.product_name,
                            product_id   = databseColumn.product_id,
                        }
                                            );
                    }
                }
                else
                {
                    MessageBox.Show("connection error");
                }
            }, System.Threading.CancellationToken.None, TaskContinuationOptions.None, TaskScheduler.FromCurrentSynchronizationContext());
        }
Ejemplo n.º 17
0
        private void button1_Click(object sender, EventArgs e)
        {   // Add company details into database
            DatabaseColumn databaseColumn = new DatabaseColumn();

            Connector connector = new MYSQLDatabaseConnection();


            databaseColumn.company_name     = txtCompayName.Text.ToString();
            databaseColumn.company_phone_no = txtCompanyPhoneNumber.Text.ToString();
            databaseColumn.company_address  = txtCompanyAddress.Text.ToString();
            databaseColumn.company_id       = txtCompanyId.Text.ToString();
            connector.SetData(databaseColumn);

            if (connector.establish() == true && connector.InsertCompanyDetails() == true)
            {
                //create database column list with data
                var list = new List <DatabaseColumn>()
                {
                    new DatabaseColumn {
                        company_name = txtCompayName.Text.ToString(), company_phone_no = txtCompanyPhoneNumber.Text.ToString(), company_address = txtCompanyAddress.Text.ToString(), company_id = txtCompanyId.Text.ToString()
                    }
                };

                CombineDataGridView combineDataGridView = new CombineDataGridView();
                combineDataGridView.SetDataGridViewList(list, mDgv);//connect main window datagridview

                MessageBox.Show("Compleat");

                txtCompanyPhoneNumber.Clear();
                txtCompayName.Clear();
                txtCompanyAddress.Clear();
                txtCompanyId.Clear();
            }
            else
            {
                MessageBox.Show("operation error");
            }
        }
Ejemplo n.º 18
0
        private void getProductDetails()
        {
            var t = new Task(() => { });

            t.Start();
            t.ContinueWith(task => {
                Connector databaseConnectProductDetails = new MYSQLDatabaseConnection();

                if (databaseConnectProductDetails.establish() == true)
                {
                    DatabaseColumn databaseColumn = new DatabaseColumn();
                    databaseColumn.company_id     = databaseConnectProductDetails.SearchCompanyList(TempCompanyList, cmbSearchCompanyName.SelectedItem.ToString()).company_id;
                    databaseColumn.category_id    = databaseConnectProductDetails.SearchCategoryList(TempCategoryList, cmbSearchCategoryName.SelectedItem.ToString()).category_id;
                    databaseColumn.product_id     = databaseConnectProductDetails.SearchProductList(TempProductList, cmbSearchProductName.SelectedItem.ToString()).product_id;

                    databaseConnectProductDetails.SetData(databaseColumn);
                    DatabaseColumn ProductDetails = databaseConnectProductDetails.GetProductDetails();


                    txtProductId.Text = ProductDetails.product_id;



                    txtProductName.Text     = ProductDetails.product_name;
                    txtSellPrice.Text       = ProductDetails.sell_price;
                    txtDiscount.Text        = ProductDetails.product_discount_price;
                    txtMinimumQuantity.Text = ProductDetails.minimum_quantity;
                    cmbCategoryName.Text    = ProductDetails.category_name;
                    cmbCompanyName.Text     = ProductDetails.company_name;
                }
                else
                {
                    MessageBox.Show("connection error");
                }
            }, System.Threading.CancellationToken.None, TaskContinuationOptions.None, TaskScheduler.FromCurrentSynchronizationContext());
        }
Ejemplo n.º 19
0
        private void btnLogin_Click(object sender, EventArgs e)
        {
            prograsbarLogin.Value = 50;

            Connector      databaseConnection = new MYSQLDatabaseConnection();
            DatabaseColumn databaseColumn     = new DatabaseColumn();

            databaseColumn.user_name = txtUserName.Text.ToString();
            databaseColumn.password  = txtPassword.Text.ToString();

            databaseConnection.SetData(databaseColumn);

            prograsbarLogin.Value = 80;

            if (databaseConnection.establish() == true)
            {
                if (databaseConnection.CheckLogin() == true)
                {
                    prograsbarLogin.Value = 100;
                    MainWindow mainWindow = new MainWindow();

                    this.Hide();
                    mainWindow.Show();
                }
                else
                {
                    prograsbarLogin.Value = 100;
                    MessageBox.Show("wrong Password!");
                }
            }
            else
            {
                ServerConfiguration serverConfiguration = new ServerConfiguration();
                serverConfiguration.Show();
            }
        }
Ejemplo n.º 20
0
        private void cmbProductName_SelectedIndexChanged(object sender, EventArgs e)
        {
            Connector databaseConnectProductId = new MYSQLDatabaseConnection();

            productId = databaseConnectProductId.SearchProductList(tempProductList, cmbProductName.SelectedItem.ToString());
        }