public bool isUserInDB(string usn, string pw)
{
using (e1 = new M120Entities())
{
g1 = e1.GUIUSERs.FirstOrDefault(r => r.Gu_Benutzername == usn);
g2 = e1.GUIUSERs.FirstOrDefault(p => p.GU_Password == pw);
try
{
if (g1.Gu_Benutzername == usn && g2.GU_Password == pw)
{
m1 = new Menu2();
m1.Show();
return(true);
}
else
{
return(false);
}
}
catch (Exception e)
{
MessageBox.Show("No User found in Database");
}
return(false);
}
}
private void Button_Click(object sender, RoutedEventArgs e)
{
using (e1 = new M120Entities())
{
try
{
k1 = e1.Hotels.FirstOrDefault(c => c.Name == tbLoad.Text);
k2 = e1.Lands.FirstOrDefault(c => c.LandID == k1.Land);
if (k1 != null)
{
hiddenLabel.Foreground = new SolidColorBrush(Colors.ForestGreen);
hiddenLabel.Content = "Hotel found";
tbOOrt.Text = k1.Ort;
tbLand.Text = k2.Name;
tbSterne.Text = k1.Sterne.ToString();
tbManager.Text = k1.Manager;
tbAnzahlZimmer.Text = k1.AnzahlZimmer.ToString();
tbEmail.Text = k1.Email;
tbTäglicheKosten.Text = k1.TagesPreis.ToString();
}
else
{
hiddenLabel.Foreground = new SolidColorBrush(Colors.PaleVioletRed);
hiddenLabel.Content = "Hotel not found";
}
}
catch (Exception)
{
MessageBox.Show("No user found");
}
}
}
public void saveUserToDB(string anrede, string vorname, string name, string namezusatz, string strassennr, short plz, string ort, string telefon, string mobile, string email, string web, DateTime geburtsdatum, string passnr, long nationalität, string usn, string pw)
{
using (e1 = new M120Entities())
{
Kunde k1 = new Kunde
{
Anrede = anrede,
Vorname = vorname,
Name = name,
NameZusatz = namezusatz,
StrasseNr = strassennr,
PLZ = plz,
Ort = ort,
Telefon = telefon,
Mobile = mobile,
Email = email,
Web = web,
Geburtsdatum = geburtsdatum,
PassNr = passnr,
Nationalitaet = nationalität
};
GUIUSER g1 = new GUIUSER
{
Gu_Benutzername = usn,
GU_Password = pw,
};
m1 = new Menu2();
m1.Show();
e1.GUIUSERs.Add(g1);
e1.Kundes.Add(k1);
e1.SaveChanges();
}
}
public UserDiagram()
{
InitializeComponent();
using (m120 = new M120Entities())
{
var k1 = m120.Kundes.Count(c => c.Anrede == "Herr");
var k2 = m120.Kundes.Count(x => x.Anrede == "Frau");
if (k1 > 0 || k2 > 0)
{
tblockHerren.Text = k1.ToString();
tblockHerren.Height = k1 * 20;
tblockFrauen.Text = k2.ToString();
tblockFrauen.Height = k2 * 20;
}
else if (k1 == 0)
{
tblockHerren.Text = k1.ToString();
tblockHerren.Height = 0;
}
else if (k2 == 0)
{
tblockFrauen.Text = k2.ToString();
tblockFrauen.Height = 0;
}
}
}
private void updateValuesOnClick(object sender, RoutedEventArgs e)
{
using (e1 = new M120Entities())
{
k1 = e1.Kundes.FirstOrDefault(c => c.Name == tbLoad.Text);
try
{
if (k1.Anrede == "Frau" && l2.IsChecked == false)
{
k1.Anrede = "Herr";
hiddenLabel2.Content = updatedMessage();
}
else if (k1.Anrede == "Herr" && l1.IsChecked == false)
{
k1.Anrede = "Frau";
hiddenLabel2.Content = updatedMessage();
}
else if (tbName.Text != k1.Name)
{
k1.Name = tbName.Text;
hiddenLabel2.Content = updatedMessage();
}
else if (tbVorname.Text != k1.Vorname)
{
k1.Vorname = tbVorname.Text;
hiddenLabel2.Content = updatedMessage();
}
else if (tbPlz.Text != k1.PLZ.ToString())
{
k1.PLZ = Convert.ToInt16(tbPlz.Text);
hiddenLabel2.Content = updatedMessage();
}
else if (tbOrt.Text != k1.Ort)
{
k1.Ort = tbOrt.Text;
hiddenLabel2.Content = updatedMessage();
}
else if (tbEmail.Text != k1.Email)
{
k1.Email = tbEmail.Text;
hiddenLabel2.Content = updatedMessage();
}
else if (DateTime.Parse(tbBirthdate.SelectedDate.ToString()) != k1.Geburtsdatum)
{
k1.Geburtsdatum = DateTime.Parse(tbBirthdate.SelectedDate.ToString());
hiddenLabel2.Content = updatedMessage();
}
else
{
hiddenLabel2.Foreground = new SolidColorBrush(Colors.Yellow);
hiddenLabel2.Content = "Nothing Updated";
}
e1.SaveChanges();
}
catch (NullReferenceException x)
{
MessageBox.Show(x.Message);
}
}
}
private void Button_Click(object sender, RoutedEventArgs e)
{
using (e1 = new M120Entities())
{
k1 = e1.Kundes.FirstOrDefault(c => c.Name == tbLoad.Text);
if (k1 != null)
{
hiddenLabel.Foreground = new SolidColorBrush(Colors.ForestGreen);
hiddenLabel.Content = "User Found";
if (k1.Anrede == "Frau")
{
l2.IsChecked = true;
}
else
{
l1.IsChecked = true;
}
tbName.Text = k1.Name;
tbVorname.Text = k1.Vorname;
tbPlz.Text = k1.PLZ.ToString();
tbOrt.Text = k1.Ort;
tbEmail.Text = k1.Email;
tbBirthdate.SelectedDate = DateTime.Parse(k1.Geburtsdatum.ToString());
}
else
{
hiddenLabel.Foreground = new SolidColorBrush(Colors.PaleVioletRed);
hiddenLabel.Content = "User not Found";
}
}
}
private void updateValuesOnClick(object sender, RoutedEventArgs e)
{
using (e1 = new M120Entities())
{
k1 = e1.Hotels.FirstOrDefault(c => c.Name == tbLoad.Text);
k2 = e1.Lands.FirstOrDefault(c => c.LandID == k1.Land);
try
{
if (tbOOrt.Text != k1.Ort)
{
k1.Ort = tbOOrt.Text;
hiddenLabel2.Content = updatedMessage();
}
else if (tbLand.Text != k2.Name)
{
k1.Land = k2.LandID;
hiddenLabel2.Content = updatedMessage();
}
else if (tbSterne.Text != k1.Sterne.ToString())
{
k1.Sterne = Convert.ToByte(tbSterne.Text);
hiddenLabel2.Content = updatedMessage();
}
else if (tbManager.Text != k1.Manager)
{
k1.Manager = tbManager.Text;
hiddenLabel2.Content = updatedMessage();
}
else if (tbAnzahlZimmer.Text != k1.AnzahlZimmer.ToString())
{
k1.AnzahlZimmer = Convert.ToInt16(tbAnzahlZimmer);
hiddenLabel2.Content = updatedMessage();
}
else if (tbEmail.Text != k1.Email)
{
k1.Email = tbEmail.Text;
hiddenLabel2.Content = updatedMessage();
}
else if (tbEmail.Text != k1.Email)
{
k1.TagesPreis = Convert.ToInt16(tbTäglicheKosten.Text);
hiddenLabel2.Content = updatedMessage();
}
else
{
hiddenLabel2.Foreground = new SolidColorBrush(Colors.Yellow);
hiddenLabel2.Content = "Nothing Updated";
}
e1.SaveChanges();
}
catch (NullReferenceException x)
{
MessageBox.Show(x.Message);
}
}
}
private void deleteValuesOnClick(object sender, RoutedEventArgs e)
{
using (e1 = new M120Entities())
{
k1 = e1.Hotels.FirstOrDefault(c => c.Name == tbLoad.Text);
e1.Hotels.Remove(k1);
e1.SaveChanges();
hiddenLabel2.Foreground = new SolidColorBrush(Colors.ForestGreen);
hiddenLabel2.Content = "Successfully deleted";
}
}
public void saveImageToDb(byte[] img, string description, string hotelName)
{
using (e1 = new M120Entities()){
Hotel h2 = e1.Hotels.FirstOrDefault(c => c.Name == hotelName);
HotelBild b1 = new HotelBild
{
Beschreibung = description,
Bild = img,
HotelID = h2.HotelID
};
e1.HotelBilds.Add(b1);
e1.SaveChanges();
}
}
public void saveHotelToDB(string hoName, string hoOrt, long hoLand, byte hoSterne, string hoManager, short hoAnzahlZimmer, int hoTagesPreis, string hoTelefon, string hoEmail, string hoWeb)
{
using (e1 = new M120Entities())
{
Hotel h1 = new Hotel
{
Name = hoName,
Ort = hoOrt,
Land = hoLand,
Sterne = hoSterne,
Manager = hoManager,
AnzahlZimmer = hoAnzahlZimmer,
TagesPreis = hoTagesPreis,
Telefon = hoTelefon,
Email = hoEmail,
Web = hoWeb
};
e1.Hotels.Add(h1);
e1.SaveChanges();
}
}
