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