private void refresh()
{
comboBoxWareHouseEditPrice.Items.Clear();
comboBoxAddProd.Items.Clear();
comboBoxViewWareHouseItem.Items.Clear();
comboBoxIdSupplier.Items.Clear();
comboBoxIdAffiliate.Items.Clear();
comboBoxSelectType.Items.Clear();
comboBoxIdAffiliateTable.Items.Clear();
comboBoxAffiliateAddProd.Items.Clear();
string com = "SELECT * FROM ProductSize";
MyConnection.comboBoxLoading(comboBoxWareHouseEditPrice, com, "Продукт с размером"); //Price
MyConnection.comboBoxLoading(comboBoxAddProd, com, "Продукт с размером"); //NumProd
MyConnection.comboBoxLoading(comboBoxViewWareHouseItem, com, "Продукт с размером"); //TableProd
com = "SELECT [NameCompany] FROM Supplier";
MyConnection.comboBoxLoading(comboBoxIdSupplier, com, "NameCompany"); //Supplier
com = "SELECT [NameAffiliate] FROM Affiliate";
MyConnection.comboBoxLoading(comboBoxIdAffiliate, com, "NameAffiliate"); //Affiliate
com = "SELECT [Type] FROM ProductType";
MyConnection.comboBoxLoading(comboBoxSelectType, com, "Type"); //TypeProd
com = "SELECT [NameAffiliate] FROM Affiliate";
MyConnection.comboBoxLoading(comboBoxIdAffiliateTable, com, "NameAffiliate");
com = "SELECT [NameAffiliate] FROM Affiliate";
MyConnection.comboBoxLoading(comboBoxAffiliateAddProd, com, "NameAffiliate"); //Affiliate
com = $"SELECT [Id_Position], Affiliate.[NameAffiliate], [ProductName], [Type], [NameCompany], [PriceOfUnit], [NumberOfProduct] FROM WarehouseInfo join Affiliate on WarehouseInfo.[Id_Affiliate] = Affiliate.[Id_AffiliateKA]";
MyConnection.loadingDataGridView(dataGridViewxViewWareHouseItem, com, "WarehouseInfo");
}
private void User_Load(object sender, EventArgs e)
{
com = $"SELECT TOP 1 CONCAT([Surname], ' ', [Name]) FROM Buyer WHERE [Id_User] = {Class.idUser}";
using (SqlConnection sqlConnection = new MyConnection().GetConnection())
{
sqlConnection.Open();
SqlCommand sqlCommand = new SqlCommand(com, sqlConnection);
labelName.Text = Convert.ToString(sqlCommand.ExecuteScalar());
sqlConnection.Close();
}
com = $"select count(*) from Buyer where [Id_User] = {Class.idUser} AND [Id_PurchaseNumber] IS NOT NULL";
using (SqlConnection sqlConnection = new MyConnection().GetConnection())
{
sqlConnection.Open();
SqlCommand sqlCommand = new SqlCommand(com, sqlConnection);
textBoxNumOrder.Text = Convert.ToString(sqlCommand.ExecuteScalar());
sqlConnection.Close();
}
com = "SELECT [Type] FROM ProductType";
MyConnection.comboBoxLoading(comboBoxChooseType, com, "Type");
com = "select [ProductName] from TableProdImg";
MyConnection.comboBoxLoading(comboBoxChooseProd, com, "ProductName");
com = "SELECT [NameAffiliate] FROM Affiliate";
MyConnection.comboBoxLoading(comboBoxAffiliate, com, "NameAffiliate");
}
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);
}
private void refresh()
{
com = "SELECT CONCAT(Buyer.[Surname], ' ', Buyer.[Name]) AS 'Ф.И.' FROM Buyer WHERE Buyer.[Id_Buyer] != 1";
MyConnection.comboBoxLoading(comboBoxOrdersUserChoose, com, "Ф.И.");
MyConnection.comboBoxLoading(comboBoxDeliveryChoose, com, "Ф.И.");
com = "SELECT COUNT(*) FROM Purchase";
MyConnection.textBoxLoading(textBoxOrders, com);
com = "SELECT * FROM PurchaseView";
MyConnection.loadingDataGridView(dataGridViewOrdersProducts, com, "PurchaseView");
com = "SELECT [Номер доставки], [Ф.И.], [Адрес доставки], [Дата доставки], [Статус доставки] FROM DeliveryToBuyerView";
MyConnection.loadingDataGridView(dataGridViewOrdersDelivery, com, "DeliveryToBuyerView");
}
private void comboBoxChooseType_SelectedIndexChanged(object sender, EventArgs e)
{
if (groupBoxBasket.Enabled == false)
{
comboBoxChooseType.SelectedIndex = -1;
comboBoxChooseProd.SelectedIndex = -1;
MessageBox.Show("Выберите филиал покупки!", "Ошибка.", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
else
{
if (comboBoxChooseType.Text.Length > 0)
{
int idType = comboBoxChooseType.SelectedIndex + 1;
com = $"SELECT [ProductName] FROM TableProdImg WHERE [Id_Type] = {idType}";
comboBoxChooseProd.Items.Clear();
comboBoxSizeBuy.SelectedIndex = -1;
comboBoxSizeBuy.Items.Clear();
textBoxPriceProd.Clear();
richTextBox.Clear();
MyConnection.comboBoxLoading(comboBoxChooseProd, com, "ProductName");
}
}
}
private void MessAdmin_Load(object sender, EventArgs e)
{
MessageBox.Show("Вы, как и покупатель, видите \nтолько последнее сообщение. Старайтесь уместить свои мысли в одно сообщение.", "", MessageBoxButtons.OK, MessageBoxIcon.Warning);
com = "SELECT DISTINCT Buyer.[Id_User], CONCAT(Buyer.[Surname], ' ', Buyer.[Name]) 'Чел' FROM Buyer WHERE [Id_Buyer] != 1";
MyConnection.comboBoxLoading(comboBoxBuyer, com, "Чел");
}