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