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