Ejemplo n.º 1
0
        private void pickDbComboBox_SelectedIndexChanged(object sender, EventArgs e)
        {
            int selectedDatabase = ((ComboBox)sender).SelectedIndex;

            switch (selectedDatabase)
            {
            case (int)CarDealerEnum.CarDealer1:
                DatabaseConnection.Set(CarDealerConnectionString.carDealer1);
                break;

            case (int)CarDealerEnum.CarDealer2:
                DatabaseConnection.Set(CarDealerConnectionString.carDealer2);
                break;

            default:
                DatabaseConnection.Set();
                break;
            }

            RateCar.service.GetDataService.Most3DataTableFromHost =
                CarsData.GetCars
                    ("SELECT id, brand, model, car_engine, production_year, avg_rate, no_rates FROM cars ORDER BY no_rates DESC LIMIT 3");

            RateCar.service.GetDataService.Best3DataTableFromHost =
                CarsData.GetCars
                    ("SELECT id, brand, model, car_engine, production_year, avg_rate, no_rates FROM cars ORDER BY avg_rate DESC LIMIT 3");

            this.cars1BindingSource.DataSource = CarsData.GetCars();
        }
Ejemplo n.º 2
0
        private void lacquerColorComboBox_DropDown(object sender, EventArgs e)
        {
            bool isMetallicType = isMetallicLacquerCheckBox.Checked;
            //MessageBox.Show("metallicType: " + isMetallicType);
            string appendToSqlQuery = isMetallicType ? " WHERE has_metallic_lacquer=1" : "";

            lacquerColorComboBox.DataSource    = CarsData.GetCars("SELECT DISTINCT lacquer_color FROM cars" + appendToSqlQuery);
            lacquerColorComboBox.DisplayMember = "lacquer_color";
        }
Ejemplo n.º 3
0
        private void addNewCarButton_Click(object sender, EventArgs e)
        {
            try
            {
                System.Diagnostics.Debug.WriteLine("Attempt to add new car...");

                string carBrand = !addBrandTextBox.Text.Equals("") ?
                                  "'" + (addBrandTextBox.Text) + "'" : "NULL";
                string carModel = !addModelTextBox.Text.Equals("") ?
                                  "'" + (addModelTextBox.Text) + "'" : "NULL";
                string carEngine = !addEngineTextBox.Text.Equals("") ?
                                   "'" + (addEngineTextBox.Text) + "'" : "NULL";
                string prodYear = !addProdYearTextBox.Text.Equals("") ?
                                  "'" + (addProdYearTextBox.Text) + "'" : "NULL";
                string lacquerColor = !addLacquerTextBox.Text.Equals("") ?
                                      "'" + (addLacquerTextBox.Text) + "'" : "NULL";
                string hasMetallicLacquer = addMetalicLacquerCheckBox.Checked ?
                                            "1" : "0";
                string hasPowerSteering = addPowerSteeringCheckBox.Checked ?
                                          "1" : "0";
                string hasAutomaticTransmission = addAutomaticTransmissionCheckBox.Checked ?
                                                  "1" : "0";
                string hasAirConditioning = addAirConditionCheckBox.Checked ?
                                            "1" : "0";
                string price = !addPriceTextBox.Text.Equals("") ?
                               "'" + (addPriceTextBox.Text) + "'" : "NULL";

                string insertQuery = "INSERT INTO cars " +
                                     "(brand, model, car_engine, production_year, lacquer_color, has_metallic_lacquer, has_power_steering, has_automatic_transmission, has_air_conditioning, price) " +
                                     "VALUES (" +
                                     "" + carBrand + ", " +
                                     "" + carModel + ", " +
                                     "" + carEngine + ", " +
                                     "" + prodYear + ", " +
                                     "" + lacquerColor + ", " +
                                     "'" + hasMetallicLacquer + "', " +
                                     "'" + hasPowerSteering + "', " +
                                     "'" + hasAutomaticTransmission + "', " +
                                     "'" + hasAirConditioning + "', " +
                                     "" + price + ") ";

                System.Diagnostics.Debug.WriteLine("Insert query: " + insertQuery);
                CarsData.InsertCar(insertQuery);
                this.cars1BindingSource.DataSource = CarsData.GetCars();
                MessageBox.Show("Dodano nowy samochód do komisu: " + CarsData.DbConnection.Database);
            }
            catch (System.Exception ex)
            {
                CarsData.DbConnection.Close();
                MessageBox.Show("NIE udalo sie dodac nowego wpisu! \n" + ex.Message);
                System.Diagnostics.Debug.WriteLine("NIE udalo sie dodac nowego wpisu: " + ex.StackTrace);
                System.Diagnostics.Debug.WriteLine("NIE udalo sie dodac nowego wpisu MESSAGE: " + ex.Message);
            }
        }
Ejemplo n.º 4
0
        private void button1_Click(object sender, EventArgs e)
        {
            try
            {
                string sqlQuery = "SELECT * FROM cars";

                List <string> queryElements = new List <string>();
                queryElements.Add((carBrandComboBox.SelectedIndex > -1 && !("".Equals(carBrandComboBox.Text))) ?
                                  ("brand='" + carBrandComboBox.Text + "'") : null);
                queryElements.Add((carModelComboBox.SelectedIndex > -1 && !("".Equals(carModelComboBox.Text))) ?
                                  ("model='" + carModelComboBox.Text + "'") : null);
                queryElements.Add((engineComboBox.SelectedIndex > -1 && !("".Equals(engineComboBox.Text))) ?
                                  ("car_engine='" + engineComboBox.Text + "'") : null);
                queryElements.Add(isMetallicLacquerCheckBox.Checked ?
                                  ("has_metallic_lacquer='" + 1 + "'") : null);
                queryElements.Add((lacquerColorComboBox.SelectedIndex > -1 && !("".Equals(lacquerColorComboBox.Text))) ?
                                  ("lacquer_color='" + lacquerColorComboBox.Text + "'") : null);
                queryElements.Add(automaticTransmissionCheckBox.Checked ?
                                  ("has_automatic_transmission='" + 1 + "'") : null);
                queryElements.Add(powerSteeringCheckBox.Checked ?
                                  ("has_power_steering='" + 1 + "'") : null);
                queryElements.Add(airConditionCheckBox.Checked ?
                                  ("has_air_conditioning='" + 1 + "'") : null);

                queryElements.RemoveAll(query => query == null || query.Equals(""));
                if (queryElements.Count > 0)
                {
                    sqlQuery += " WHERE ";

                    foreach (string query in queryElements)
                    {
                        if (queryElements.IndexOf(query) == queryElements.Count - 1)
                        {
                            sqlQuery += query;
                            break;
                        }
                        sqlQuery += query + " AND ";
                    }
                }

                System.Diagnostics.Debug.WriteLine("Search sqlQuery : " + sqlQuery);

                this.cars1BindingSource.DataSource = CarsData.GetCars(sqlQuery);
            }
            catch (SqlException ex)
            {
                System.Diagnostics.Debug.WriteLine("SQL EXCEPTION when searching! : " + ex.Message + "\n" + ex.StackTrace);
            }
        }
Ejemplo n.º 5
0
        private void Form1_Load(object sender, EventArgs e)
        {
            // TODO: This line of code loads data into the 'carDealer2DataSet.cars' table. You can move, or remove it, as needed.
            this.cars2TableAdapter.Fill(this.carDealer2DataSet.cars);
            // TODO: This line of code loads data into the 'carDealer1DataSet.cars' table. You can move, or remove it, as needed.
            this.cars1TableAdapter.Fill(this.carDealer1DataSet.cars);
            // TODO: This line of code loads data into the 'car_dealer_dbDataSet.samochody' table. You can move, or remove it, as needed.
            this.samochodyTableAdapter.Fill(this.carDealerDataSet.samochody);
            System.Diagnostics.Debug.WriteLine("Form1_Load");

            label10.Text = computer1.CPU.Architecture;

            RateCar.service.GetDataService.BindingSourceFromHost  = this.cars1BindingSource;
            RateCar.service.GetDataService.Most3DataTableFromHost = CarsData.GetCars
                                                                        ("SELECT id, brand, model, car_engine, production_year, avg_rate, no_rates FROM cars ORDER BY no_rates DESC LIMIT 3");
            RateCar.service.GetDataService.Best3DataTableFromHost = CarsData.GetCars
                                                                        ("SELECT id, brand, model, car_engine, production_year, avg_rate, no_rates FROM cars ORDER BY avg_rate DESC LIMIT 3");

            foreach (CarDealerEnum enumValue in Enum.GetValues(typeof(CarDealerEnum)))
            {
                pickDbComboBox.Items.Add(enumValue.ToString());
            }

            newCarPanel.Visible = false;

            carBrandComboBox.DropDown += new EventHandler(carBrandComboBox_DropDown);
            carBrandComboBox.SelectionChangeCommitted += new EventHandler(carBrandComboBox_SelectionChangeCommitted);
            carModelComboBox.DropDown += new EventHandler(carModelComboBox_DropDown);
            carModelComboBox.SelectionChangeCommitted += new EventHandler(carModelComboBox_SelectionChangeCommitted);
            engineComboBox.DropDown += new EventHandler(engineComboBox_DropDown);
            //engineComboBox.SelectionChangeCommitted += new EventHandler(engineComboBox_SelectionChangeCommitted);
            lacquerColorComboBox.DropDown += new EventHandler(lacquerColorComboBox_DropDown);
            //lacquerColorComboBox.SelectionChangeCommitted += new EventHandler(lacquerColorComboBox_SelectionChangeCommitted);
            mainDataGridView.CellClick += new DataGridViewCellEventHandler(mainDataGridView_CellClick);
            addNewCarButton.Click      += new EventHandler(addNewCarButton_Click);

            rateCarController.SelectedIndexChangedInRateCB += new RateEventHandler(RateComboBox_SelectedIndexChanged);

            if (OnParentLoad != null)
            {
                // Event leci on mouse enter Form1
                this.OnParentLoad(sender, e);
            }
        }
Ejemplo n.º 6
0
        protected void RateComboBox_SelectedIndexChanged(object sender, RateEventArgs e)
        {
            System.Diagnostics.Debug.WriteLine("Rate " + ((ComboBox)sender).Text + "  from RateComboBox recieved in parent,  id: " + e.Id + " model: " + e.Model);

            try
            {
                CarsData.UpdateCar("UPDATE cars SET sum_rates=sum_rates+" + ((ComboBox)sender).Text + " WHERE id=" + e.Id);
                CarsData.UpdateCar("UPDATE cars SET no_rates=no_rates+1 WHERE id=" + e.Id);

                string sum_rates = CarsData.GetCars("SELECT sum_rates FROM cars WHERE id=" + e.Id).Rows[0].ItemArray[0].ToString();
                string no_rates  = CarsData.GetCars("SELECT no_rates FROM cars WHERE id=" + e.Id).Rows[0].ItemArray[0].ToString();

                float  float_avg_rate = (float)Int32.Parse(sum_rates) / Int32.Parse(no_rates);
                string avg_rate       = float_avg_rate.ToString().Replace(',', '.');
                System.Diagnostics.Debug.WriteLine("avg_rate: " + avg_rate + " sum_rates: " + sum_rates + " no_rates: " + no_rates);


                CarsData.UpdateCar("UPDATE cars SET avg_rate=" + avg_rate + " WHERE id=" + e.Id);

                RateCar.service.GetDataService.Most3DataTableFromHost =
                    CarsData.GetCars
                        ("SELECT id, brand, model, car_engine, production_year, avg_rate, no_rates FROM cars ORDER BY no_rates DESC LIMIT 3");

                RateCar.service.GetDataService.Best3DataTableFromHost =
                    CarsData.GetCars
                        ("SELECT id, brand, model, car_engine, production_year, avg_rate, no_rates FROM cars ORDER BY avg_rate DESC LIMIT 3");

                this.cars1BindingSource.DataSource = CarsData.GetCars();

                lastRatedCarLabel.Text = e.Brand + " " + e.Model + " oceniono na: " + ((ComboBox)sender).Text;
            }
            catch (SqlException ex)
            {
                System.Diagnostics.Debug.WriteLine("SQL EXCEPTION when rating car : " + ex.Message + "\n" + ex.StackTrace);
            }
        }
Ejemplo n.º 7
0
 private void engineComboBox_DropDown(object sender, EventArgs e)
 {
     engineComboBox.DataSource    = CarsData.GetCars("SELECT DISTINCT car_engine FROM cars");
     engineComboBox.DisplayMember = "car_engine";
 }
Ejemplo n.º 8
0
 private void carModelComboBox_DropDown(object sender, EventArgs e)
 {
     carModelComboBox.DataSource    = CarsData.GetCars("SELECT DISTINCT model FROM cars");
     carModelComboBox.DisplayMember = "model";
 }
Ejemplo n.º 9
0
 private void carBrandComboBox_DropDown(object sender, EventArgs e)
 {
     carBrandComboBox.DataSource    = CarsData.GetCars("SELECT DISTINCT brand FROM cars");
     carBrandComboBox.DisplayMember = "brand";
 }