public void LogIn(String name, String password)
{
if ((bool)checkBoxWithoutSQL.IsChecked)
{
userLevel = comboBoxChooseJob.SelectedIndex;
userId = 66;
userName = (String)((ComboBoxItem)comboBoxChooseJob.SelectedValue).Content;
Visibility = Visibility.Collapsed;
LoggedInEventArgs LoggedInArgs = new LoggedInEventArgs(userId, userLevel, userName, userSurname);
LoggedInEvent(this, LoggedInArgs);
}
else
if (name.Length > 0 && password.Length > 0)
{
try
{
MySqlCommand command = DBConnection.Instance.Conn.CreateCommand();
MySqlDataReader Reader;
command.CommandText = "select p.level, u.id, u.name, u.surname from users u, privilages p where p.uid = u.id and u.login = \"" + textBoxLogin.Text + "\" and u.password = \"" + textBoxPassword.Password + "\"";
DBConnection.Instance.Conn.Open();
Reader = command.ExecuteReader();
if (Reader.Read())
{
userId = Reader.GetInt32(0);
userLevel = Reader.GetInt32(1);
userName = Reader.GetString(2);
userSurname = Reader.GetString(3);
}
DBConnection.Instance.Conn.Close();
Visibility = Visibility.Collapsed;
LoggedInEventArgs LoggedInArgs = new LoggedInEventArgs(userId, userLevel, userName, userSurname);
LoggedInEvent(this, LoggedInArgs);
}
catch (MySqlException e)
{
MessageBox.Show(e.ToString());
}
}
else
{
//nie podane haslo/nick
}
}
private void LoginControl1_LoggedInEvent(object sender, LoggedInEventArgs fe)
{
//ustawiam widzialnosc labelek w gornym lewym rogu
labelNotLoggedIn.Visibility = Visibility.Collapsed;
labelLoggedAs.Visibility = Visibility.Visible;
labelUserNameSurname.Visibility = Visibility.Visible;
ButtonLogOut.Visibility = Visibility.Visible;
labelUserLevel.Visibility = Visibility.Visible;
labelUserNameSurname.Content = fe.userName + " " + fe.userSurname;
userLevel = fe.userLevel;
userId = fe.userId;
//pokazuje/ukrywam funkcje wszystkich userow, potrzebne do szybkiego ukrycia wszystkiego jak klikniemy 'wyloguj'
if (userLevel == -1)
{
GridPanelFunctions.Visibility = Visibility.Collapsed;
}
else
{
GridPanelFunctions.Visibility = Visibility.Visible;
}
switch (userLevel)
{
//nie zalogowany
case -1:
labelNotLoggedIn.Visibility = Visibility.Visible;
labelLoggedAs.Visibility = Visibility.Collapsed;
labelUserNameSurname.Visibility = Visibility.Collapsed;
ButtonLogOut.Visibility = Visibility.Collapsed;
labelUserLevel.Visibility = Visibility.Collapsed;
break;
case 0: labelUserLevel.Content = "Gość";
break;
case 1: labelUserLevel.Content = "Asysten(ka)";
break;
case 2: labelUserLevel.Content = "Kierownik";
break;
case 3: labelUserLevel.Content = "Specjalista";
break;
case 4: labelUserLevel.Content = "Administrator";
break;
case 5: labelUserLevel.Content = "Deweloper";
break;
}
RefreshLeftButtonMenu();
}
public void LogOut()
{
LoggedInEventArgs LoggedInArgs = new LoggedInEventArgs(-1, -1, "", "");
userId = -1;
userLevel = -1;
userName = "";
userSurname = "";
Visibility = Visibility.Visible;
//zadbanie o usuniecie przyciskow
((MainWindow)Application.Current.MainWindow).stackPanelLeftButtons.Children.Clear();
//zadbanie o wyczyszczenie dodanych elementów do GridPanelFunctions
((MainWindow)Application.Current.MainWindow).GridPanelFunctions.Children.Clear();
LoggedInEvent(this, LoggedInArgs);
}
