private void OpenNextWindow()
{
this.Hide();
View.Boxes boxes = new View.Boxes();
boxes.ShowDialog();
this.Close();
}
private void btnLoginLogin_Click(object sender, RoutedEventArgs e)
{
CurrentInfo currentuser = new CurrentInfo();
using (var bb = new BoxesEntities())
{
//var users = bb.Users
// .ToList()
// .Select(x => x.Login.ToString() && x.Password.ToString())
// .ToList();
try
{
//var users = bb.Users
// .ToList()
// .Select(x => x.UserId)
// .Select(x => ViewModel.UserViewModel.Create(x.Login, x.Password, x.UserId))
// .Where(x => x.Login == tbLoginLogin.Text && x.Password == pbPasswordLogin.Text)
// .ToList();
//rekord z tabeli users
IQueryable <Users> us =
from u in bb.Users
where u.Login == tbLoginLogin.Text
select u;
int zmienna = 0;
foreach (var i in us)
{
//string haslo = i.Password.Trim();
//string haslo1 = tbPasswordLogin.Text;//pbPasswordLogin.SecurePassword.ToString();
//MessageBox.Show(haslo);
//MessageBox.Show(haslo1);
if (tbPasswordLogin.Text == i.Password.Trim())
{
zmienna = i.UserId;
}
}
if (zmienna == 0)
{
MessageBox.Show("Błędne dane logowania \n Użytkownik nie istnieje");
}
else
{
currentuser.UserId = zmienna;//int.Parse(uid.ToString())
MessageBox.Show(currentuser.UserId.ToString());
this.Hide();
View.Boxes boxes = new View.Boxes(currentuser.UserId);
boxes.ShowDialog();
this.Close();
}
//var zm = (from u in us
// where u.Password == pbPasswordLogin.ToString()
// select u.UserId);
//var uid = (from u in bb.Users
// where u.Login == tbLoginLogin.Text
// select u.UserId).First();
//var uid = (from u in bb.Users
// where u.Login == tbLoginLogin.Text && u.Password == pbPasswordLogin.ToString()
// select u.UserId).First();
//var uid = (from u in bb.Users
// where u.Login == tbLoginLogin.Text && u.Password == tbPasswordLogin.Text
// select u.UserId).First();
//if (int.Parse(zm.ToString()) != 0)
//{
// currentuser.UserId = int.Parse(zm.ToString());//int.Parse(uid.ToString())
// this.Hide();
// View.Boxes boxes = new View.Boxes();
// boxes.ShowDialog();
// this.Close();
//}
//else
//{
// MessageBox.Show("Błędne dane logowania \n Użytkownik nie istnieje");
// tbLoginLogin.Clear();
// tbPasswordLogin.Clear();
//}
}
catch
{
MessageBox.Show("Błędne dane logowania \n Użytkownik nie istnieje");
}
//currentuser.UserId = zmienna;
//var users = bb.Users
// .ToList()
// .Select(x => x.UserId == Id)
// .Where(x => tbLoginLogin.Text==ViewModel.UserViewModel.Check(x.login,x.password))
// .ToList();
}
}