示例#1
0
        private void CityComboBox_SelectionChanged(object sender, SelectionChangedEventArgs e)
        {
            if (CityComboBox.SelectedItem != null)
            {
                Id_City = CityService.GetCity()
                          .Where(x => (x.Name == CityComboBox.SelectedItem.ToString()))
                          .Select(x => x.Id).FirstOrDefault();

                cityName = CitySetName.Text = CityService.GetCity()
                                              .Where(x => (x.Name == CityComboBox.SelectedItem.ToString()))
                                              .Select(x => x.Name).FirstOrDefault().ToString();

                cityPopulation = CitySetPopulation.Text = CityService.GetCity()
                                                          .Where(x => (x.Name == CityComboBox.SelectedItem.ToString()))
                                                          .Select(x => x.Population).FirstOrDefault().ToString();


                PlaceComboBoxList();
                BuildingComboBoxList();

                PlaceSetStreet.Clear();
                PlaceSetPopulation.Clear();
                BuildingSetType.Clear();
                BuildingSetWindows.Clear();
                BuildingSetIsIndustrial.Clear();
            }
        }
示例#2
0
        private void CountryComboBox_SelectionChanged(object sender, SelectionChangedEventArgs e)
        {
            if (CountryComboBox.SelectedItem != null)
            {
                Id_Country = CountryService.GetCountry()
                             .Where(x => (x.Name == CountryComboBox.SelectedItem.ToString()))
                             .Select(x => x.Id).FirstOrDefault();

                countryName = CountrySetName.Text = CountryService.GetCountry()
                                                    .Where(x => (x.Name == CountryComboBox.SelectedItem.ToString()))
                                                    .Select(x => x.Name).FirstOrDefault().ToString();

                countryContinent = CountrySetContinent.Text = CountryService.GetCountry()
                                                              .Where(x => (x.Name == CountryComboBox.SelectedItem.ToString()))
                                                              .Select(x => x.Continent).FirstOrDefault().ToString();

                PresidentComboBoxList();
                CityComboBoxList();
                PlaceComboBoxList();
                BuildingComboBoxList();


                PresidentSetName.Clear();
                PresidentSetAge.Clear();
                CitySetName.Clear();
                CitySetPopulation.Clear();

                PlaceSetStreet.Clear();
                PlaceSetPopulation.Clear();
                BuildingSetType.Clear();
                BuildingSetWindows.Clear();
                BuildingSetIsIndustrial.Clear();
            }
        }
示例#3
0
        private void PlaceComboBox_SelectionChanged(object sender, SelectionChangedEventArgs e)
        {
            if (PlaceComboBox.SelectedItem != null)
            {
                Place_Id = PlaceService.GetPlace()
                           .Where(x => (x.Street == PlaceComboBox.SelectedItem.ToString()))
                           .Select(x => x.Id).FirstOrDefault();
                Place_Id_Building = PlaceService.GetPlace()
                                    .Where(x => (x.Street == PlaceComboBox.SelectedItem.ToString()))
                                    .Select(x => x.BuildingModel.Id).FirstOrDefault();
                placeStreet = PlaceSetStreet.Text = PlaceService.GetPlace()
                                                    .Where(x => (x.Street == PlaceComboBox.SelectedItem.ToString()))
                                                    .Select(x => x.Street).FirstOrDefault().ToString();

                placePopulation = PlaceSetPopulation.Text = PlaceService.GetPlace()
                                                            .Where(x => (x.Street == PlaceComboBox.SelectedItem.ToString()))
                                                            .Select(x => x.PlacePopulation).FirstOrDefault().ToString();

                BuildingComboBoxList();
                BuildingSetType.Clear();
                BuildingSetWindows.Clear();
                BuildingSetIsIndustrial.Clear();
            }
        }
        private void Delete_Click(object sender, RoutedEventArgs e)
        {
            if (Id_Country != 0)
            {
                DeleteService.DeleteAllCoutry(Id_Country);
            }
            CountryComboBoxList();
            PresidentComboBoxList();
            CityComboBoxList();
            PlaceComboBoxList();
            BuildingComboBoxList();

            CountrySetName.Clear();
            CountrySetContinent.Clear();
            PresidentSetName.Clear();
            PresidentSetAge.Clear();
            CitySetName.Clear();
            CitySetPopulation.Clear();
            PlaceSetStreet.Clear();
            PlaceSetPopulation.Clear();
            BuildingSetType.Clear();
            BuildingSetWindows.Clear();
            BuildingSetIsIndustrial.Clear();
        }
        private void Save_Click(object sender, RoutedEventArgs e)
        {
            string _countryName      = CountrySetName.Text;
            string _countryContinent = CountrySetContinent.Text;
            string _presidentName    = PresidentSetName.Text;
            int    _presidentAge;
            bool   _presidentAgeBool = Int32.TryParse(PresidentSetAge.Text, out _presidentAge);
            string _cityName         = CitySetName.Text;
            int    _cityPopulation;
            bool   _cityPopulationBool = Int32.TryParse(CitySetPopulation.Text, out _cityPopulation);
            string _placeStreet        = PlaceSetStreet.Text;
            int    _placePopulation;
            bool   _placePopulationBool = Int32.TryParse(PlaceSetPopulation.Text, out _placePopulation);
            string _buildingType        = BuildingSetType.Text;
            string _buildingWindows     = BuildingSetWindows.Text;
            string _buildingIndustrial  = BuildingSetIsIndustrial.Text;
            bool   _buildingWindowsBool;
            bool   _buildingIndustrialBool;

            if (_buildingWindows.ToUpper().Trim() == "TAK")
            {
                _buildingWindowsBool = true;
            }
            else
            {
                _buildingWindowsBool = false;
            }
            if (_buildingIndustrial.ToUpper().Trim() == "TAK")
            {
                _buildingIndustrialBool = true;
            }
            else
            {
                _buildingIndustrialBool = false;
            }

            if (_countryName == "" || _presidentName == "")
            {
                MessageBox.Show("Nie została podana nazwa państwa lub/i nazwisko prezydenta");
                return;
            }
            if (!_presidentAgeBool || !_cityPopulationBool || !_placePopulationBool)
            {
                MessageBox.Show("Wartości dla wieku czy populacji należy podawać w liczbach całkowitych");
                return;
            }

            if (_countryName == countryName)
            {
                if (_countryContinent != countryContinent)
                {
                    CountryService.SaveCountry(_countryName, _countryContinent, Id_Country);
                }


                if (_cityName == cityName && _cityPopulation != Convert.ToInt32(cityPopulation))
                {
                    CityService.SaveCity(_cityName, Convert.ToInt32(_cityPopulation), Id_Country, Id_City);
                }

                if (_cityName != cityName)
                {
                    CityService.SaveCity(_cityName, Convert.ToInt32(_cityPopulation), Id_Country);
                    Id_City = CityService.GetCity().Select(x => x.Id).LastOrDefault();
                }

                if ((_buildingType == buildingType && (_buildingWindows != buildingWindows || _buildingIndustrial != buildingIndustrial)))
                {
                    BuildingService.SaveBuilding(_buildingType, _buildingWindowsBool, _buildingIndustrialBool, Place_Id_Building);
                }

                if (_buildingType != buildingType)
                {
                    BuildingService.SaveBuilding(_buildingType, _buildingWindowsBool, _buildingIndustrialBool);
                    Place_Id_Building = BuildingService.GetBuilding().Select(x => x.Id).LastOrDefault();
                }

                if (_placeStreet == placeStreet && _placePopulation != Convert.ToInt32(placePopulation))
                {
                    PlaceService.SavePlace(_placeStreet, _placePopulation, Id_City, Place_Id_Building, Place_Id);
                }

                if (_placeStreet != placeStreet)
                {
                    PlaceService.SavePlace(_placeStreet, _placePopulation, Id_City, Place_Id_Building);
                }
            }
            else
            {
                CountryService.SaveCountry(_countryName, _countryContinent);
                int id_Country = CountryService.GetCountry().Select(x => x.Id).LastOrDefault();
                PresidentService.SavePresident(_presidentName, Convert.ToInt32(_presidentAge), id_Country);
                CityService.SaveCity(_cityName, Convert.ToInt32(_cityPopulation), id_Country);
                int id_City = CityService.GetCity().Select(x => x.Id).LastOrDefault();

                BuildingService.SaveBuilding(_buildingType, _buildingWindowsBool, _buildingIndustrialBool);
                Place_Id_Building = BuildingService.GetBuilding().Select(x => x.Id).LastOrDefault();
                PlaceService.SavePlace(_placeStreet, Convert.ToInt32(_placePopulation), id_City, Place_Id_Building);
            }


            CountryComboBoxList();
            PresidentComboBoxList();
            CityComboBoxList();
            PlaceComboBoxList();
            BuildingComboBoxList();
            CountrySetName.Clear();
            CountrySetContinent.Clear();
            PresidentSetName.Clear();
            PresidentSetAge.Clear();
            CitySetName.Clear();
            CitySetPopulation.Clear();
            CitySetPopulation.Clear();
            PlaceSetStreet.Clear();
            PlaceSetPopulation.Clear();
            BuildingSetType.Clear();
            BuildingSetWindows.Clear();
            BuildingSetIsIndustrial.Clear();
        }
示例#6
0
        private void Save_Click(object sender, RoutedEventArgs e)
        {
            string _countryName        = CountrySetName.Text;
            string _countryContinent   = CountrySetContinent.Text;
            string _presidentName      = PresidentSetName.Text;
            string _presidentAge       = PresidentSetAge.Text;
            string _cityName           = CitySetName.Text;
            string _cityPopulation     = CitySetPopulation.Text;
            string _palceStreet        = PlaceSetStreet.Text;
            string _placePopulation    = PlaceSetPopulation.Text;
            string _buildingType       = BuildingSetType.Text;
            string _buildingWindows    = BuildingSetWindows.Text;
            string _buildingIndustrial = BuildingSetIsIndustrial.Text;

            //if(_countryName==""||)


            if ((_countryName == countryName && _countryContinent != countryContinent) || (_countryName == countryName && _countryContinent == countryContinent))
            {
                CountryService.SaveCountry(_countryName, _countryContinent, Id_Country); //bez sensu. nawet jak nie zmieniam country to męczy DB i updatuje

                if ((_presidentName == presidentName && _presidentAge != presidentAge) || _presidentName != presidentName)
                {
                    PresidentService.SavePresident(_presidentName, Convert.ToInt32(_presidentAge), Id_Country);
                }
                if (_cityName != "")
                {
                    CityService.SaveCity(_cityName, Convert.ToInt32(_cityPopulation), Id_Country, Id_City);
                }
            }
            if (_countryName != countryName)
            {
                bool _buildingWindowsBool;
                bool _buildingIndustrialBool;
                CountryService.SaveCountry(_countryName, _countryContinent);
                int id_Country = CountryService.GetCountry().Select(x => x.Id).LastOrDefault();
                PresidentService.SavePresident(_presidentName, Convert.ToInt32(_presidentAge), id_Country);
                CityService.SaveCity(_cityName, Convert.ToInt32(_cityPopulation), id_Country);
                int id_City = CityService.GetCity().Select(x => x.Id).LastOrDefault();
                if (_buildingWindows.ToUpper().Trim() == "TAK")
                {
                    _buildingWindowsBool = true;
                }
                else
                {
                    _buildingWindowsBool = false;
                }
                if (_buildingIndustrial.ToUpper().Trim() == "TAK")
                {
                    _buildingIndustrialBool = true;
                }
                else
                {
                    _buildingIndustrialBool = false;
                }
                BuildingService.SaveBuilding(_buildingType, _buildingWindowsBool, _buildingIndustrialBool);
                int id_Building = BuildingService.GetBuilding().Select(x => x.Id).LastOrDefault();
                PlaceService.SavePlace(_palceStreet, Convert.ToInt32(_placePopulation), id_City, id_Building);
            }

            CountryComboBoxList();
            PresidentComboBoxList();
            CityComboBoxList();
            PlaceComboBoxList();
            BuildingComboBoxList();
            CountrySetName.Clear();
            CountrySetContinent.Clear();
            PresidentSetName.Clear();
            PresidentSetAge.Clear();
            CitySetName.Clear();
            CitySetPopulation.Clear();
            CitySetPopulation.Clear();
            PlaceSetStreet.Clear();
            PlaceSetPopulation.Clear();
            BuildingSetType.Clear();
            BuildingSetWindows.Clear();
            BuildingSetIsIndustrial.Clear();
        }