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"); } }
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"); } } }
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()); }
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()); }