private void ChangeNotation()
 {
     BlockEverything();
     if (Notation == Notation.Client)
     {
         InfoButton.Enabled = true;
         InfoButton.Visible = true;
     }
     if (Notation == Notation.Delete)
     {
         DeleteButton.Visible = true;
         DeleteButton.Enabled = true;
     }
     if (Notation == Notation.Update)
     {
         ChangeButton.Visible = true;
         ChangeButton.Enabled = true;
     }
     if (Notation == Notation.ManagerRequests)
     {
         RequestButton.Visible = true;
         RequestButton.Enabled = true;
         BlockFilter();
         dataGridView1.DataSource = ShowTable.DisplayCurrentRequests(SqlConnection);
     }
 }
 private void TradesSMI_Click(object sender, EventArgs e)
 {
     Exit();
     BackButton.Visible       = true;
     personSMI.Visible        = true;
     personSMI.Enabled        = true;
     dataGridView1.Visible    = true;
     dataGridView1.DataSource = ShowTable.DisplayTrades(SqlConnection, CurrentUser.ClientId);
 }
 private void accountSMI_Click(object sender, EventArgs e)
 {
     Exit();
     personSMI.Visible        = true;
     personSMI.Enabled        = true;
     paymentButton.Visible    = true;
     RefuseButton.Visible     = true;
     BackButton.Visible       = true;
     dataGridView1.Visible    = true;
     paymentButton.Visible    = true;
     dataGridView1.DataSource = ShowTable.DisplayClientRequests(SqlConnection, CurrentUser.ClientId, 3);
 }
 private void RefreshData()
 {
     if (filter)
     {
         ShowSearchResults();
     }
     else
     {
         ShowTable.AllTable(SqlConnection);
     }
     if (Links)
     {
         dataGridView1.DataSource = ShowTable.DisplayClientRequests(SqlConnection, CurrentUser.ClientId, 3);
     }
 }
        public void DataLoad()
        {
            int   realtyType  = Convert.ToInt32(RealtyTypeComboBox.SelectedValue);
            int   tradeType   = Convert.ToInt32(TradeTypeComboBox.SelectedValue);
            float minPrice    = PriceMinTextBox.Value;
            float maxPrice    = PriceMaxTextBox.Value;
            float minArea     = AreaMinTextBox.Value;
            float maxArea     = AreaMaxTextBox.Value;
            float minLandArea = LandAreaMinTextBox.Value;
            float maxLandArea = LandAreaMaxTextBox.Value;

            var    elements  = DistrictCheckedListBox.CheckedItems;
            string districts = ManagerForm.CreateParameters(DistrictCheckedListBox);
            string rooms     = ManagerForm.CreateParameters(RoomsCheckedListBox);

            if (notation == Notation.ManagerRequests)
            {
                dataGridView1.DataSource = ShowTable.DisplayCurrentRequests(SqlConnection);
            }
            else
            {
                dataGridView1.DataSource = Query.SelectEstateObjects(realtyType, tradeType, minPrice, maxPrice, minArea, maxArea, minLandArea, maxLandArea, districts, rooms, SqlConnection);
            }
        }