コード例 #1
0
ファイル: Reise.cs プロジェクト: Weiskopfseeadler/GUITravel
 /// <summary>
 /// Methode: Löschen einer Reise
 /// </summary>
 /// <param name="reise"></param>
 public static void Loeschen(DB.Reise reise)
 {
     using (var db = new DB.M120Datenbank())
     {
         db.Entry(reise).State = System.Data.Entity.EntityState.Deleted;
         db.SaveChanges();
     }
 }
コード例 #2
0
 /// <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();
     }
 }
コード例 #3
0
ファイル: Reise.cs プロジェクト: Weiskopfseeadler/GUITravel
 /// <summary>
 /// Methode: Bestehende Reise aktualisieren
 /// </summary>
 /// <param name="reise"></param>
 public static void Aktualisieren(DB.Reise reise)
 {
     using (var db = new DB.M120Datenbank())
     {
         db.Entry(reise).State = System.Data.Entity.EntityState.Modified;
         db.SaveChanges();
     }
 }
コード例 #4
0
 public static void Loeschen(DB.Kunde Kunde)
 {
     using (var DB = new DB.M120Datenbank())
     {
         DB.Entry(Kunde).State = System.Data.Entity.EntityState.Deleted;
         DB.SaveChanges();
     }
 }
コード例 #5
0
 public static void Aktualisieren(DB.Kunde Kunde)
 {
     using (var DB = new DB.M120Datenbank())
     {
         DB.Entry(Kunde).State = System.Data.Entity.EntityState.Modified;
         DB.SaveChanges();
     }
 }
コード例 #6
0
 public static void Loeschen_Reise_Hotel(Int64 reiseID, Int64 hotelID)
 {
     using (var db = new DB.M120Datenbank())
     {
         IQueryable <DB.Reise_Hotel> query = from rec in db.Reise_Hotel where rec.Reise == reiseID && rec.Hotel == hotelID select rec;
         foreach (DB.Reise_Hotel element in query)
         {
             db.Entry(element).State = System.Data.Entity.EntityState.Deleted;
         }
         db.SaveChanges();
     }
 }
コード例 #7
0
 public static void Loeschen_Kunde_Reise(Int64 kundeID, Int64 reiseID)
 {
     using (var db = new DB.M120Datenbank())
     {
         IQueryable <DB.Kunde_Reise> query = from rec in db.Kunde_Reise where rec.Kunde == kundeID && rec.Reise == reiseID select rec;
         foreach (DB.Kunde_Reise element in query)
         {
             db.Entry(element).State = System.Data.Entity.EntityState.Deleted;
         }
         db.SaveChanges();
     }
 }
コード例 #8
0
 public static Int64 Erstellen_Reise_Hotel(Int64 reiseID, Int64 hotelID)
 {
     using (var db = new DB.M120Datenbank())
     {
         DB.Reise_Hotel rec = new DB.Reise_Hotel();
         rec.Reise = reiseID;
         rec.Hotel = hotelID;
         db.Reise_Hotel.Add(rec);
         db.SaveChanges();
         db.Entry(rec).Reload();
         return(rec.Reise_Hotel_ID);
     }
 }
コード例 #9
0
 public static Int64 Erstellen_Kunde_Reise(Int64 kundeID, Int64 reiseID)
 {
     using (var db = new DB.M120Datenbank())
     {
         DB.Kunde_Reise rec = new DB.Kunde_Reise();
         rec.Kunde = kundeID;
         rec.Reise = reiseID;
         db.Kunde_Reise.Add(rec);
         db.SaveChanges();
         db.Entry(rec).Reload();
         return(rec.Kunde_Reise_ID);
     }
 }
コード例 #10
0
 /// <summary>
 /// Methode: Neues Land erstellen
 /// </summary>
 /// <param name="land"></param>
 /// <returns></returns>
 public static Int64 Erstellen(DB.Land land)
 {
     if (land.Name == null)
     {
         land.Name = "";
     }
     if (land.Kurzname == null)
     {
         land.Kurzname = "";
     }
     using (var db = new DB.M120Datenbank())
     {
         db.Land.Add(land);
         db.SaveChanges();
         db.Entry(land).Reload();
         return(land.LandID);
     }
 }
コード例 #11
0
ファイル: Reise.cs プロジェクト: Weiskopfseeadler/GUITravel
 /// <summary>
 /// Methode: Neue Reise erstellen
 /// </summary>
 /// <param name="reise"></param>
 /// <returns></returns>
 public static Int64 Erstellen(DB.Reise reise)
 {
     if (reise.Start == null)
     {
         reise.Start = DateTime.Now;
     }
     if (reise.Ende == null)
     {
         reise.Ende = DateTime.Now;
     }
     if (reise.NameLeitung == null)
     {
         reise.NameLeitung = "";
     }
     using (var db = new DB.M120Datenbank())
     {
         db.Reise.Add(reise);
         db.SaveChanges();
         db.Entry(reise).Reload();
         return(reise.ReiseID);
     }
 }
コード例 #12
0
 /// <summary>
 /// Methode: Neues Hotel erstellen
 /// </summary>
 /// <param name="hotel"></param>
 /// <returns></returns>
 public static Int64 Erstellen(DB.Hotel hotel)
 {
     if (hotel.Name == null)
     {
         hotel.Name = "";
     }
     if (hotel.Ort == null)
     {
         hotel.Ort = "";
     }
     if (hotel.Land == 0)
     {
         hotel.Land = 192;
     }
     if (hotel.Manager == null)
     {
         hotel.Manager = "";
     }
     if (hotel.Telefon == null)
     {
         hotel.Telefon = "";
     }
     if (hotel.Email == null)
     {
         hotel.Email = "";
     }
     if (hotel.Web == null)
     {
         hotel.Web = "";
     }
     using (var db = new DB.M120Datenbank())
     {
         db.Hotel.Add(hotel);
         db.SaveChanges();
         db.Entry(hotel).Reload();
         return(hotel.HotelID);
     }
 }
コード例 #13
0
 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);
     }
 }