private void comboBoxChooseProd_SelectedIndexChanged(object sender, EventArgs e)
{
prodName = comboBoxChooseProd.Text;
com = "SELECT DISTINCT [Size] FROM Product " +
"join Warehouse on Product.[Id_ProductKA] = Warehouse.[Id_Product]" +
"join ProductType on Product.[Id_ProductType] = ProductType.[Id_ProductTypeKA] " +
"join TableProdImg on ProductType.[Id_ProductTypeKA] = TableProdImg.[Id_Type] " +
$"WHERE TableProdImg.[Id_Type] = {comboBoxChooseType.SelectedIndex + 1} AND " +
$"TableProdImg.[ProductName] = '{comboBoxChooseProd.Text}' AND " +
$"Product.[ProductName] = '{comboBoxChooseProd.Text}' AND " +
$"Warehouse.[Id_Affiliate] = {affiliateId}";
comboBoxSizeBuy.SelectedIndex = -1;
comboBoxSizeBuy.Items.Clear();
textBoxPriceProd.Clear();
richTextBox.Clear();
MyConnection.comboBoxLoading(comboBoxSizeBuy, com, "Size");
com = "SELECT TOP 1 [PriceOfUnit] FROM Product " +
"join ProductType on Product.[Id_ProductType] = ProductType.[Id_ProductTypeKA] " +
"join TableProdImg on ProductType.[Id_ProductTypeKA] = TableProdImg.[Id_Type] " +
$"WHERE TableProdImg.[Id_Type] = {comboBoxChooseType.SelectedIndex + 1} AND " +
$"TableProdImg.[ProductName] = '{comboBoxChooseProd.Text}' AND " +
$"Product.[ProductName] = '{comboBoxChooseProd.Text}'";
MyConnection.textBoxLoading(textBoxPriceProd, com);
com = "SELECT TOP 1 [Descriprion] FROM Product " +
"join ProductType on Product.[Id_ProductType] = ProductType.[Id_ProductTypeKA] " +
"join TableProdImg on ProductType.[Id_ProductTypeKA] = TableProdImg.[Id_Type] " +
$"WHERE TableProdImg.[Id_Type] = {comboBoxChooseType.SelectedIndex + 1} AND " +
$"TableProdImg.[ProductName] = '{comboBoxChooseProd.Text}' AND " +
$"Product.[ProductName] = '{comboBoxChooseProd.Text}'";
MyConnection.richTextBoxLoading(richTextBox, com);
}
