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