/// <summary>
/// Methode: Löschen eines Hotels
/// </summary>
/// <param name="hotel"></param>
public static void Loeschen(DB.Hotel hotel)
{
using (var db = new DB.M120Datenbank())
{
db.Entry(hotel).State = System.Data.Entity.EntityState.Deleted;
db.SaveChanges();
}
}
/// <summary>
/// Methode: Bestehendes Hotel aktualisieren
/// </summary>
/// <param name="hotel"></param>
public static void Aktualisieren(DB.Hotel hotel)
{
using (var db = new DB.M120Datenbank())
{
db.Entry(hotel).State = System.Data.Entity.EntityState.Modified;
db.SaveChanges();
}
}
private void Button_Click(object sender, RoutedEventArgs e)
{
if (checktb())
{
if (ifNew)
{
DB.Hotel Hotel = new DB.Hotel();
Hotel.Name = tbName.Text;
Hotel.Ort = tbOrt.Text;
Hotel.Land = Convert.ToInt64(tbLand.Text);
// Hotel.Sterne = tbManager.Text;
Hotel.Manager = Sterne.Text;
Hotel.AnzahlZimmer = Convert.ToInt16(tbAnzahlZimmer.Text);
Hotel.TagesPreis = Convert.ToDecimal(tbTagesPreis.Text);
Hotel.Telefon = tbTelefon.Text;
Hotel.BitmapImage = image;
Hotel.Manager = tbManager.Text;
Hotel.Email = tbEmail.Text;
Hotel.Web = tbWeb.Text;
APP.Hotel.Erstellen(Hotel);
HotelBild HB = new HotelBild();
HB.Bild = Byte;
Hotel.HotelBild.Add(HB);
HotelAdministration.Hotels.Add(Hotel);
}
else
{
// Hotel.BitmapImage = Program.BitmapImageFromBytes((Program.BytesFromPath(tblastName.Text)));
Hotel.Name = tbName.Text;
Hotel.Ort = tbOrt.Text;
Hotel.Land = Convert.ToInt64(tbLand.Text);
// Hotel.Sterne = tbManager.Text;
Hotel.Manager = Sterne.Text;
Hotel.AnzahlZimmer = Convert.ToInt16(tbAnzahlZimmer.Text);
Hotel.TagesPreis = Convert.ToDecimal(tbTagesPreis.Text);
Hotel.Telefon = tbTelefon.Text;
Hotel.BitmapImage = image;
Hotel.Manager = tbManager.Text;
Hotel.Email = tbEmail.Text;
Hotel.Web = tbWeb.Text;
APP.Hotel.Aktualisieren(Hotel);
HotelBild HB = new HotelBild();
HB.Bild = Byte;
Hotel.HotelBild.Add(HB);
}
this.Close();
}
else
{
MessageBox.Show("Input Erreor");
}
}
public EditHotels(DB.Hotel Hotel)
{
InitializeComponent();
this.Hotel = Hotel;
ifNew = false;
preShow.Source = Hotel.BitmapImage;
tbName.Text = Hotel.Name;
tbOrt.Text = Hotel.Ort;
tbLand.Text = Convert.ToString(Hotel.Land);
tbManager.Text = Hotel.Manager;
tbAnzahlZimmer.Text = Convert.ToString(Hotel.AnzahlZimmer);
tbTagesPreis.Text = Convert.ToString(Hotel.TagesPreis);
tbTelefon.Text = Hotel.Telefon;
tbEmail.Text = Hotel.Email;
tbWeb.Text = Hotel.Web;
}
/// <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 EditHotels()
{
InitializeComponent();
ifNew = true;
Hotel = new DB.Hotel();
}
