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