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>();
}
