/// <summary> /// Methode: Liste von Hotel lesen anhand Teilmatch auf Name /// </summary> /// <param name="hotelName"></param> /// <returns></returns> public static List <DB.Hotel> Lesen_NameWie(string hotelName) { using (var db = new DB.M120Datenbank()) { return((from rec in db.Hotel where rec.Name.Contains(hotelName) select rec).ToList()); } }
public static List <DB.Kunde> ReadingAll() { using (var db = new DB.M120Datenbank()) { return((from rec in db.Kunde select rec).ToList()); } }
/// <summary> /// Methode: Liste von Hotels lesen anhand Sterne /// </summary> /// <param name="sterne"></param> /// <returns></returns> public static List <DB.Hotel> Lesen_Sterne(byte sterne) { using (var db = new DB.M120Datenbank()) { return((from rec in db.Hotel where rec.Sterne == sterne select rec).ToList()); } }
/// <summary> /// Methode: Liste von Reisen lesen anhand KundenID /// </summary> /// <param name="kundeID"></param> /// <returns></returns> public static List <DB.Reise> Lesen_KundenID(Int64 kundeID) { using (var db = new DB.M120Datenbank()) { return((from rec in db.Reise join rk in db.Kunde_Reise on rec.ReiseID equals rk.Reise where rk.Kunde == kundeID select rec).ToList()); } }
/// <summary> /// Methode: ein Land lesen anhand Primärschlüssel /// </summary> /// <param name="landID"></param> /// <returns></returns> public static DB.Land Lesen_LandID(Int64 landID) { using (var db = new DB.M120Datenbank()) { return((from rec in db.Land where rec.LandID == landID select rec).FirstOrDefault()); } }
/// <summary> /// Methode: Liste von allen Reisen lesen /// </summary> /// <returns></returns> public static List <DB.Reise> Lesen_Alle() { using (var db = new DB.M120Datenbank()) { return((from rec in db.Reise select rec).ToList()); } }
/// <summary> /// Methode: eine Reise lesen anhand Primärschlüssel /// </summary> /// <param name="reiseID"></param> /// <returns></returns> public static DB.Reise Lesen_ReiseID(Int64 reiseID) { using (var db = new DB.M120Datenbank()) { return((from rec in db.Reise where rec.ReiseID == reiseID select rec).FirstOrDefault()); } }
/// <summary> /// Methode: Liste von Laendern lesen anhand Teilmatch auf Name /// </summary> /// <param name="landName"></param> /// <returns></returns> public static List <DB.Land> Lesen_NameWie(string landName) { using (var db = new DB.M120Datenbank()) { return((from rec in db.Land where rec.Name.Contains(landName) select rec).ToList()); } }
/// <summary> /// Methode: ein Hotel lesen anhand Primärschlüssel /// </summary> /// <param name="hotelID"></param> /// <returns></returns> public static DB.Hotel Lesen_HotelID(Int64 hotelID) { using (var db = new DB.M120Datenbank()) { return((from rec in db.Hotel where rec.HotelID == hotelID select rec).FirstOrDefault()); } }
/// <summary> /// Methode: Liste von Reisen lesen anhand HotelID /// </summary> /// <param name="hotelID"></param> /// <returns></returns> public static List <DB.Reise> Lesen_HotelID(Int64 hotelID) { using (var db = new DB.M120Datenbank()) { return((from rec in db.Reise join rh in db.Reise_Hotel on rec.ReiseID equals rh.Reise where rh.Hotel == hotelID select rec).ToList()); } }
/// <summary> /// Methode: Liste von Reisen lesen anhand LandID /// </summary> /// <param name="landID"></param> /// <returns></returns> public static List <DB.Reise> Lesen_LandID(Int64 landID) { using (var db = new DB.M120Datenbank()) { return((from rec in db.Reise where rec.Land == landID select rec).ToList()); } }
public static List <DB.Kunde> Lesen_NameWie(string kundeName) { using (var db = new DB.M120Datenbank()) { return((from rec in db.Kunde where rec.Name.Contains(kundeName) select rec).ToList()); } }
public static DB.Kunde Lesen_KundeID(Int64 kundenID) { using (var db = new DB.M120Datenbank()) { return((from rec in db.Kunde where rec.KundeID == kundenID select rec).FirstOrDefault()); } }
/// <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(); } }
/// <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(); } }
/// <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 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(); } }
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(); } }
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); } }
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); } }
/// <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); } }
/// <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); } }
/// <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); } }
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); } }