/// <summary>
/// Methode: Löschen eines Landes
/// </summary>
/// <param name="land"></param>
private static void Loeschen(DB.Kunde land)
{
using (var db = new DB.M120Datenbank())
{
db.Entry(land).State = System.Data.Entity.EntityState.Deleted;
db.SaveChanges();
}
}
public static void Loeschen(DB.Kunde Kunde)
{
using (var DB = new DB.M120Datenbank())
{
DB.Entry(Kunde).State = System.Data.Entity.EntityState.Deleted;
DB.SaveChanges();
}
}
public static void Aktualisieren(DB.Kunde Kunde)
{
using (var DB = new DB.M120Datenbank())
{
DB.Entry(Kunde).State = System.Data.Entity.EntityState.Modified;
DB.SaveChanges();
}
}
public NewClient(DB.Kunde client)
{
InitializeComponent();
Client = client;
ifNewL = false;
InitializeComponent();
Client = client;
ifNewL = false;
tbLastName.Text = Client.Anrede;
tbAnrede.Text = Client.Name;
tbNameZusatz.Text = Client.NameZusatz;
tbStrasseNr.Text = Client.StrasseNr;
tbPLZ.Text = Convert.ToString(Client.PLZ);
tbOrt.Text = Client.Ort;
tbTelefon.Text = Client.Telefon;
tbMobile.Text = Client.Mobile;
tbEmail.Text = Client.Email;
}
private void Button_Click(object sender, RoutedEventArgs e)
{
if (checktb())
{
if (ifNewL)
{
DB.Kunde Client = new DB.Kunde();
Client.Name = tbName.Text;
Client.Vorname = tbLastName.Text;
Client.Anrede = tbAnrede.Text;
Client.NameZusatz = tbNameZusatz.Text;
Client.StrasseNr = tbStrasseNr.Text;
Client.PLZ = Convert.ToInt16(tbPLZ.Text);
Client.Ort = tbOrt.Text;
Client.Telefon = tbTelefon.Text;
Client.Mobile = tbMobile.Text;
Client.Email = tbEmail.Text;
APP.Kunde.Erstellen(Client);
KundenListe.Clients.Add(Client);
}
else
{
Client.KundeID = Convert.ToInt16(tbName.Text);
Client.Anrede = tbAnrede.Text;
Client.Vorname = tbLastName.Text;
Client.Name = tbName.Text;
Client.NameZusatz = tbNameZusatz.Text;
Client.StrasseNr = tbStrasseNr.Text;
Client.PLZ = Convert.ToInt16(tbPLZ.Text);
Client.Ort = tbOrt.Text;
Client.Telefon = tbTelefon.Text;
Client.Mobile = tbMobile.Text;
Client.Email = tbEmail.Text;
DB.Kunde Kunde = APP.Kunde.Lesen_KundeID(Client.KundeID);
APP.Kunde.Aktualisieren(Kunde);
}
this.Close();
}
}
public NewClient()
{
InitializeComponent();
ifNewL = true;
Client = new DB.Kunde();
}
public static long Erstellen(DB.Kunde Kunde)
{
if (Kunde.Anrede == null)
{
Kunde.Anrede = "";
}
if (Kunde.Email == null)
{
Kunde.Email = "";
}
if (Kunde.Geburtsdatum == null)
{
Kunde.Geburtsdatum = DateTime.Today;
}
if (Kunde.Mobile == null)
{
Kunde.Mobile = "";
}
if (Kunde.Name == null)
{
Kunde.Name = "";
}
if (Kunde.NameZusatz == null)
{
Kunde.NameZusatz = "";
}
if (Kunde.Ort == null)
{
Kunde.Ort = "";
}
if (Kunde.PassNr == null)
{
Kunde.PassNr = "";
}
if (Kunde.StrasseNr == null)
{
Kunde.StrasseNr = "";
}
if (Kunde.Telefon == null)
{
Kunde.Telefon = "";
}
if (Kunde.Vorname == null)
{
Kunde.Vorname = "";
}
if (Kunde.Web == null)
{
Kunde.Web = "";
}
if (Kunde.Nationalitaet == 0)
{
Kunde.Nationalitaet = 192;
}
using (var db = new DB.M120Datenbank())
{
db.Kunde.Add(Kunde);
db.SaveChanges();
db.Entry(Kunde).Reload();
return(Kunde.KundeID);
}
}
