private void addbtn_Click(object sender, RoutedEventArgs e) { OwnerEntities db = new OwnerEntities(); string a = usernamecombo.Text.Split(' ')[1].ToString(); string b = usernamecombo.Text.Split(' ')[0].ToString(); int tempID = db.People.Where(x => x.fName == b).Where(x => x.lName == a).FirstOrDefault().ID; try { var eMailValidator = new System.Net.Mail.MailAddress(emailtxt.Text); EmailAddresses email = new EmailAddresses() { Email = this.emailtxt.Text.ToString(), PersonID = tempID }; } catch (Exception) { MessageBox.Show("Podany Email jest nieprawidłowy. Spróbuj ponownie"); emailtxt.Text = ""; } PhoneNumbers number = new PhoneNumbers() { Number = this.numbertxt.Text.ToString(), PersonID = tempID }; emailtxt.Text = ""; numbertxt.Text = ""; }
public Register() { InitializeComponent(); UsersEntities db = new UsersEntities(); OwnerEntities owner = new OwnerEntities(); //db.Database.ExecuteSqlCommand("DBCC CHECKIDENT ('Users.dbo.User', RESEED, 3)"); //owner.Database.ExecuteSqlCommand("DBCC CHECKIDENT ('Owner.dbo.Owners', RESEED, 3)"); //owner.Database.ExecuteSqlCommand("DBCC CHECKIDENT ('Owner.dbo.PhoneBooks', RESEED, 2)"); //db.SaveChanges(); //owner.SaveChanges(); }
private void numbertxt_TextChanged(object sender, TextChangedEventArgs e) { OwnerEntities db = new OwnerEntities(); try { string lastName = usernamecombo.Text.Split(' ')[1].ToString(); string firstName = usernamecombo.Text.Split(' ')[0].ToString(); string country = db.Countries.Where(x => x.ID == db.People.Where(o => o.fName == firstName).Where(o => o.lName == lastName).FirstOrDefault().CountryID).First().Country; switch (country) { case "Poland": numbertxt.MaxLength = 15; numbertxt.Text = Validate.Number(numbertxt.Text, country); break; case "Germany": numbertxt.MaxLength = 17; numbertxt.Text = Validate.Number(numbertxt.Text, country); break; case "Norway": numbertxt.MaxLength = 14; numbertxt.Text = Validate.Number(numbertxt.Text, country); break; case "Czech": numbertxt.MaxLength = 16; numbertxt.Text = Validate.Number(numbertxt.Text, country); break; case "": numbertxt.MaxLength = 0; numbertxt.Text = ""; break; default: break; } } catch (Exception) { MessageBox.Show("Wybierz osobę."); } }
public AddMore() { InitializeComponent(); OwnerEntities db = new OwnerEntities(); int pID = db.PhoneBooks.Where(x => x.OwnerID == ActualOwner.ID).FirstOrDefault().ID; var q = from p in db.People where p.PhoneBookID == pID select new { Name = p.fName + " " + p.lName }; var q2 = q.ToList(); //usernamecombo.ItemsSource = q.ToList(); usernamecombo.ItemsSource = q2; }
private void registerbtn_Click(object sender, RoutedEventArgs e) { using (UsersEntities db = new UsersEntities()) { OwnerEntities owner = new OwnerEntities(); if (db.User.Where(x => x.Username == usernametxt.Text).Count() == 1) { MessageBox.Show("Użytkownik o tej nazwie już istnieje. Spróbuj innej"); usernametxt.Text = ""; passwordtxt.Password = ""; } else if (owner.Owners.Where(x => x.fName == fNametxt.Text).Where(x => x.lName == lnametxt.Text).Count() == 1) { MessageBoxResult result = MessageBox.Show("Chcesz się zalogować?", "Ta osoba posiada już konto", MessageBoxButton.YesNo, MessageBoxImage.Question, MessageBoxResult.No); if (result == MessageBoxResult.Yes) { Login log = new Login(); log.Show(); this.Close(); } else { fNametxt.Text = ""; lnametxt.Text = ""; } } else if (usernametxt.Text == "" || fNametxt.Text == "" || lnametxt.Text == "") { MessageBox.Show("Nazwa użytkownika, imię i nazwisko nie mogą być puste"); } else { User user = new User() { Username = usernametxt.Text, Password = passwordtxt.Password, fName = fNametxt.Text, lName = lnametxt.Text }; Owners ow = new Owners() { fName = fNametxt.Text, lName = lnametxt.Text }; db.User.Add(user); owner.Owners.Add(ow); db.SaveChanges(); owner.SaveChanges(); Login log = new Login(); log.Show(); this.Close(); } } }