public void Initialize() { databaseConnection = DM_DBConnection.Instance; list = CL_List.Instance; customerNumbers = null; errorMessage = null; aAddress = null; placeHolderAddress = null; aContact = null; placeHolderContact = null; newAddress = false; newContact = false; LoadComboBoxAddress(); LoadComboBoxContact(); CustomerNumberSequence(); comboBoxGender.ItemsSource = new List <string> { "Männlich", "Weiblich" }; }
private void Initialize() { databaseConnection = DM_DBConnection.Instance; listobject = CL_List.Instance; }
//Constructor public DM_DBConnection() { aList = CL_List.Instance; _carRentalEntities = new Fi12_peterson_infrastrukturDBEntities( new Uri("http://localhost:5202/WcfCarRentalSchoolDataService.svc")); DataServiceQuery <Adresse> queryAddress = _carRentalEntities.Adresse; addressListEnumerable = queryAddress.Execute(); DataServiceQuery <Kontakt> queryContact = _carRentalEntities.Kontakt; contactListEnumerable = queryContact.Execute(); DataServiceQuery <Anmeldung> queryLogin = _carRentalEntities.Anmeldung; loginListEnumerable = queryLogin.Execute(); DataServiceQuery <Benutzerart> queryUserType = _carRentalEntities.Benutzerart; userTypeListEnumerable = queryUserType.Execute(); DataServiceQuery <Benutzer> queryUser = _carRentalEntities.Benutzer; userListEnumerable = queryUser.Execute(); DataServiceQuery <Fahrzeugtyp> queryVehicleType = _carRentalEntities.Fahrzeugtyp; vehicleTypeListEnumerable = queryVehicleType.Execute(); DataServiceQuery <Versicherungspaket> queryInsurancePackage = _carRentalEntities.Versicherungspaket; insurancePackageListEnumerable = queryInsurancePackage.Execute(); DataServiceQuery <Fahrzeug> queryVehicle = _carRentalEntities.Fahrzeug; vehicleListEnumerable = queryVehicle.Execute(); DataServiceQuery <Kunde> queryCustomer = _carRentalEntities.Kunde; customerListEnumerable = queryCustomer.Execute(); DataServiceQuery <Auftrag> queryOrder = _carRentalEntities.Auftrag; orderListEnumerable = queryOrder.Execute(); aList.AddressList = new ObservableCollection <Adresse>(addressListEnumerable.ToList()); aList.AddressComparisonList = new ObservableCollection <Adresse>(aList.AddressList.ToList()); aList.ContactList = new ObservableCollection <Kontakt>(contactListEnumerable.ToList()); aList.ContactComparisonList = new ObservableCollection <Kontakt>(aList.ContactList.ToList()); aList.LoginList = new ObservableCollection <Anmeldung>(loginListEnumerable.ToList()); aList.LoginComparisonList = new ObservableCollection <Anmeldung>(aList.LoginList.ToList()); aList.UserTypeList = new ObservableCollection <Benutzerart>(userTypeListEnumerable.ToList()); aList.UserList = new ObservableCollection <Benutzer>(userListEnumerable.ToList()); aList.UserComparisonList = new ObservableCollection <Benutzer>(aList.UserList.ToList()); aList.VehicleTypeList = new ObservableCollection <Fahrzeugtyp>(vehicleTypeListEnumerable.ToList()); aList.InsurancePackageList = new ObservableCollection <Versicherungspaket>(insurancePackageListEnumerable.ToList()); aList.VehicleList = new ObservableCollection <Fahrzeug>(vehicleListEnumerable.ToList()); foreach (Fahrzeug aVehicle in aList.VehicleList) { foreach (Fahrzeugtyp aVehicleType in aList.VehicleTypeList) { if (aVehicle.FahrzeugtypID == aVehicleType.FahrzeugtypID) { aVehicle.Fahrzeugtyp = aVehicleType; } } foreach (Versicherungspaket aInsurancePackage in aList.InsurancePackageList) { if (aVehicle.VersicherungspaketID == aInsurancePackage.VersicherungspaketID) { aVehicle.Versicherungspaket = aInsurancePackage; } } } aList.VehicleComparisonList = new ObservableCollection <Fahrzeug>(aList.VehicleList.ToList()); aList.CustomerList = new ObservableCollection <Kunde>(customerListEnumerable.ToList()); foreach (Kunde aCustomer in aList.CustomerList) { foreach (Adresse aAddress in aList.AddressList) { if (aCustomer.AdresseID == aAddress.AdresseID) { aCustomer.Adresse = aAddress; } } foreach (Kontakt aContact in aList.ContactList) { if (aCustomer.KontaktID == aContact.KontaktID) { aCustomer.Kontakt = aContact; } } } aList.CustomerComparisonList = new ObservableCollection <Kunde>(aList.CustomerList.ToList()); aList.OrderList = new ObservableCollection <Auftrag>(orderListEnumerable.ToList()); foreach (Auftrag aOrder in aList.OrderList) { foreach (Kunde aCustomer in aList.CustomerList) { if (aOrder.KundeID == aCustomer.KundeID) { aOrder.Kunde = aCustomer; } } foreach (Fahrzeug aVehicle in aList.VehicleList) { if (aOrder.FahrzeugID == aVehicle.FahrzeugID) { aOrder.Fahrzeug = aVehicle; } } } aList.OrderComparisonList = new ObservableCollection <Auftrag>(aList.OrderList.ToList()); aList.VehicleSortedByTypeList = new ObservableCollection <Fahrzeug>(); aList.OrderSortedByCustomerList = new ObservableCollection <Auftrag>(); }