protected void btnNewAddress_Click(object sender, EventArgs e) { lblError.Text = ""; if (currentCustomer != null && txtCity.Text != "" && txtZip.Text != "" && txtStreet.Text != "" && txtStreetnumber.Text != "") { Adresses newAdress = new Adresses(); newAdress.city = txtCity.Text; newAdress.zip = txtZip.Text; newAdress.street = txtStreet.Text; newAdress.nr = txtStreetnumber.Text; newAdress.addToCustomer(currentCustomer.id); newAdress.save(); txtCity.Text = ""; txtZip.Text = ""; txtStreet.Text = ""; txtStreetnumber.Text = ""; //liste neu laden GVAdresses.DataSource = currentCustomer.getAdresses; GVAdresses.DataBind(); } else { lblError.Text = "Adresse kann nicht gespeichert werden! Bitte alle Felder ausfüllen!"; } }
// Laden aller Adressen als Liste von Objekten für einen bestimmten Kunden - Funktion wird von Customers aufgerufen! internal static List<Adresses> LoadAdressesForCustomer(Customers theCustomer) { SqlCommand cmd = new SqlCommand("select id, city, zip, street, nr, customerID from Adresses where customerID = @customerID", Main.GetConnection()); cmd.Parameters.Add(new SqlParameter("customerID", theCustomer.id)); SqlDataReader reader = cmd.ExecuteReader(); List<Adresses> allAdresses = new List<Adresses>(); //initialisiere lehre Liste von Adressen while (reader.Read()) { Adresses oneAdress = new Adresses(); oneAdress.id = reader.GetString(0); oneAdress.city = reader.GetString(1); oneAdress.zip = reader.GetString(2); oneAdress.street = reader.GetString(3); oneAdress.nr = reader.GetString(4); oneAdress.customerID = reader.GetString(5); allAdresses.Add(oneAdress); } return allAdresses; }