private void Log_in_button_Click(object sender, RoutedEventArgs e) { if (Models_Combobox.SelectedIndex < 0) { MessageBox.Show("Выберите модель из списка"); return; } string model = Models_Combobox.SelectedItem.ToString(); string Cur_dir = Directory.GetCurrentDirectory(); string model_dir = Cur_dir + "\\" + model; if (!Directory.Exists(model_dir)) { MessageBox.Show("Модель не существует!"); Models.Remove(model); return; } if (!Is_Model_Valid(model_dir)) { if (MessageBox.Show("Модель повреждена! Удалить каталог?", "Ошибка модели", MessageBoxButton.YesNo) == MessageBoxResult.Yes) { Directory.Delete(model_dir, true); Models.Remove(model); } else { Models.Remove(model); } return; } string login = Login_textbox.Text; List <Model_Subject> subjects = JsonConvert.DeserializeObject <List <Model_Subject> > (File.ReadAllText(model_dir + "\\Subject_list.json")); Model_Subject subject = subjects.Find(s => s.Login == login); if (subject == null || Model_Subject.Get_Hash(Passwordbox.Password) != subject.Password_hash) { MessageBox.Show("Неверный логин или пароль!"); return; } Passwordbox.Clear(); this.Visibility = Visibility.Hidden; if (subject.Security_Level == 0) { Administrator_Window administrator_Window = new Administrator_Window(subject, model); administrator_Window.ShowDialog(); } else { User_Window user_Window = new User_Window(subject, model); user_Window.ShowDialog(); } this.Visibility = Visibility.Visible; Login_textbox.Clear(); }
private void SingUp_button_Click(object sender, EventArgs e) { Login_textbox.Clear(); Password_textbox.Clear(); Guest_checkbox.Checked = false; Regestration reg = new Regestration(connect_sql); reg.ShowDialog(); }
private void Guest_checkbox_CheckedChanged(object sender, EventArgs e) { if (Guest_checkbox.Checked == true) { Login_textbox.Clear(); Password_textbox.Clear(); Login_textbox.Enabled = false; Password_textbox.Enabled = false; } else { Login_textbox.Enabled = true; Password_textbox.Enabled = true; } }
private void SingUp_button_Click(object sender, EventArgs e) { if (Login_textbox.Text.Length == 0 || Password1_textbox.Text.Length == 0 || Password2_textbox.Text.Length == 0) { MessageBox.Show("Будь ласка, заповніть всі поля!", "Помилка", MessageBoxButtons.OK, MessageBoxIcon.Error); } if (Password1_textbox.Text.Length != 0 && Password2_textbox.Text.Length != 0 && Password1_textbox.Text != Password2_textbox.Text) { Password1_textbox.Clear(); Password2_textbox.Clear(); MessageBox.Show("Повториний пароль не співпадає з паролем!", "Помилка", MessageBoxButtons.OK, MessageBoxIcon.Error); } if (Login_textbox.Text.Length != 0 && Password1_textbox.Text.Length != 0 && Password2_textbox.Text.Length != 0 && Password1_textbox.Text == Password2_textbox.Text) { SqlCommand command_sql = connect_sql.CreateCommand(); command_sql.CommandType = CommandType.Text; command_sql.CommandText = "SELECT COUNT(*) FROM Таблиця_входу WHERE Логін = '" + Login_textbox.Text + "'and Пароль = '" + Password1_textbox.Text + "';"; command_sql.ExecuteNonQuery(); string res = command_sql.ExecuteScalar().ToString(); int count = Convert.ToInt32(res); if (count == 1) { MessageBox.Show("Логін - " + Login_textbox.Text + "зайнятий\n Оберіть новий логін!", "Помилка", MessageBoxButtons.OK, MessageBoxIcon.Error); Login_textbox.Clear(); Password1_textbox.Clear(); Password2_textbox.Clear(); } else { command_sql.CommandText = "INSERT INTO Таблиця_входу ([Логін], [Пароль], [Рівень_доступу]) VALUES" + "(N'" + Login_textbox.Text + "', N'" + Password1_textbox.Text + "', N'" + "Низький" + "')"; command_sql.ExecuteNonQuery(); MessageBox.Show("Користувач - '" + Login_textbox.Text + "' зареєстрований в системі!", "Повідомлення", MessageBoxButtons.OK, MessageBoxIcon.Information); this.Close(); } } }
private void DeleteClientButton_Click(object sender, RoutedEventArgs e) { try { int id = Convert.ToInt32(ID_textbox.Text); string connectionString = @"Data Source =.\SQLEXPRESS; Initial Catalog = FitnessCenter; Integrated Security = True"; SqlConnection connection = new SqlConnection(connectionString); connection.Open(); string cmdTxt = $"DELETE FROM Clients WHERE ID_client = '{id}'"; SqlCommand command = new SqlCommand(cmdTxt, connection); int number = command.ExecuteNonQuery(); MessageBox.Show("Изменения сохранены успешно!\nУдалено объектов: " + number, "Статус действия", MessageBoxButton.OK, MessageBoxImage.Information); ID_textbox.Clear(); Surname_textbox.Clear(); Name_textbox.Clear(); Patronymic_textbox.Clear(); Phone_textbox.Clear(); DataBirth_textbox.Clear(); Address_textbox.Clear(); Login_textbox.Clear(); Password_textbox.Clear(); } catch (Exception ex) { MessageBox.Show(ex.Message, "ERROR!", MessageBoxButton.OK, MessageBoxImage.Error); } }
private void AddClientButton_Click(object sender, RoutedEventArgs e) { try { int id = Convert.ToInt32(ID_textbox.Text); string surname = Surname_textbox.Text; string name = Name_textbox.Text; string patronymic = Patronymic_textbox.Text; string phone = Phone_textbox.Text; string data = DataBirth_textbox.Text; string adres = Address_textbox.Text; string login = Login_textbox.Text; string password = Password_textbox.Text; string connectionString = @"Data Source =.\SQLEXPRESS; Initial Catalog = FitnessCenter; Integrated Security = True"; SqlConnection connection = new SqlConnection(connectionString); connection.Open(); string cmdTxt = $"INSERT INTO Clients (ID_client, Surname, Name, Patronymic, PhoneNumber, DateOfBirth, Address, Login, Password) VALUES ('{id}', '{surname}', '{name}', '{patronymic}', '{phone}', '{data}', '{adres}', '{login}', '{password}')"; SqlCommand command = new SqlCommand(cmdTxt, connection); int number = command.ExecuteNonQuery(); MessageBox.Show("Изменения сохранены успешно!\nВставлено объектов: " + number, "Статус действия", MessageBoxButton.OK, MessageBoxImage.Information); ID_textbox.Clear(); Surname_textbox.Clear(); Name_textbox.Clear(); Patronymic_textbox.Clear(); Phone_textbox.Clear(); DataBirth_textbox.Clear(); Address_textbox.Clear(); Login_textbox.Clear(); Password_textbox.Clear(); } catch (Exception ex) { MessageBox.Show(ex.Message, "ERROR!", MessageBoxButton.OK, MessageBoxImage.Error); } }
private void ChangeClientButton_Click(object sender, RoutedEventArgs e) { try { int old_id = Convert.ToInt32(ID_textbox.Text); string old_surname = Surname_textbox.Text; string old_name = Name_textbox.Text; string old_patronymic = Patronymic_textbox.Text; string old_phone = Phone_textbox.Text; string old_data = DataBirth_textbox.Text; string old_adres = Address_textbox.Text; string old_login = Login_textbox.Text; string old_password = Password_textbox.Text; int id = Convert.ToInt32(NewID_textbox.Text); string surname = NewSurname_textbox.Text; string name = NewName_textbox.Text; string patronymic = NewPatronymic_textbox.Text; string phone = Phone_textbox.Text; string data = NewDateBirth_textbox.Text; string adres = NewAddress_textbox.Text; string connectionString = @"Data Source =.\SQLEXPRESS; Initial Catalog = FitnessCenter; Integrated Security = True"; SqlConnection connection = new SqlConnection(connectionString); connection.Open(); string cmdTxt1 = $"UPDATE Clients SET Surname = '{surname}' WHERE ID_client = '{old_id}'"; SqlCommand command1 = new SqlCommand(cmdTxt1, connection); string cmdTxt2 = $"UPDATE Clients SET Name = '{name}' WHERE ID_client = '{old_id}'"; SqlCommand command2 = new SqlCommand(cmdTxt2, connection); string cmdTxt3 = $"UPDATE Clients SET Patronymic = '{patronymic}' WHERE ID_client = '{old_id}'"; SqlCommand command3 = new SqlCommand(cmdTxt3, connection); string cmdTxt4 = $"UPDATE Clients SET PhoneNumber = '{phone}' WHERE ID_client = '{old_id}'"; SqlCommand command4 = new SqlCommand(cmdTxt4, connection); string cmdTxt5 = $"UPDATE Clients SET DateOfBirth = '{data}' WHERE ID_client = '{old_id}'"; SqlCommand command5 = new SqlCommand(cmdTxt5, connection); string cmdTxt6 = $"UPDATE Clients SET Address = '{adres}' WHERE ID_client = '{old_id}'"; SqlCommand command6 = new SqlCommand(cmdTxt6, connection); command1.ExecuteNonQuery(); command2.ExecuteNonQuery(); command3.ExecuteNonQuery(); command4.ExecuteNonQuery(); command5.ExecuteNonQuery(); command6.ExecuteNonQuery(); MessageBox.Show("Изменения сохранены успешно!", "Статус действия", MessageBoxButton.OK, MessageBoxImage.Information); ID_textbox.Clear(); Surname_textbox.Clear(); Name_textbox.Clear(); Patronymic_textbox.Clear(); Phone_textbox.Clear(); DataBirth_textbox.Clear(); Address_textbox.Clear(); Login_textbox.Clear(); Password_textbox.Clear(); NewID_textbox.Clear(); NewSurname_textbox.Clear(); NewName_textbox.Clear(); NewPatronymic_textbox.Clear(); NewPhone_textbox.Clear(); NewDateBirth_textbox.Clear(); NewAddress_textbox.Clear(); } catch (Exception ex) { MessageBox.Show(ex.Message, "ERROR!", MessageBoxButton.OK, MessageBoxImage.Error); } }
private void Enter_button_Click(object sender, EventArgs e) { if (Guest_checkbox.Checked == true) { Add_form add = new Add_form(connect_sql); add.ShowDialog(); Guest_checkbox.Checked = false; } else if (Guest_checkbox.Checked == false) { if (Login_textbox.Text.Length == 0 && Password_textbox.Text.Length != 0) { MessageBox.Show("Поле 'Логін' не заповнено!", "Помилка", MessageBoxButtons.OK, MessageBoxIcon.Error); } else if (Login_textbox.Text.Length != 0 && Password_textbox.Text.Length == 0) { MessageBox.Show("Поле 'Пароль' не заповнено!", "Помилка", MessageBoxButtons.OK, MessageBoxIcon.Error); } else if (Login_textbox.Text.Length == 0 && Password_textbox.Text.Length == 0) { MessageBox.Show("Поля 'Логін' і 'Пароль' не заповнено!", "Помилка", MessageBoxButtons.OK, MessageBoxIcon.Error); } else if (Password_textbox.Text.Length != 0 && Login_textbox.Text.Length != 0) { SqlCommand command_sql = connect_sql.CreateCommand(); command_sql.CommandType = CommandType.Text; string access; command_sql.CommandText = "SELECT COUNT(*) FROM Таблиця_входу WHERE Логін = '" + Login_textbox.Text + "'and Пароль = '" + Password_textbox.Text + "';"; command_sql.ExecuteNonQuery(); string res = command_sql.ExecuteScalar().ToString(); int count = Convert.ToInt32(res); if (count == 1) { command_sql.CommandText = "SELECT Рівень_доступу FROM Таблиця_входу WHERE Логін = '" + Login_textbox.Text + "'and Пароль = '" + Password_textbox.Text + "';"; access = command_sql.ExecuteScalar().ToString(); main_menu menu = new main_menu(connect_sql); MainForm main = new MainForm(connect_sql); Add_form add = new Add_form(connect_sql); if (access == "Високий") { menu.enter_level(access); main.enter_level(access); menu.ShowDialog(); } if (access == "Середній") { menu.enter_level(access); main.enter_level(access); menu.ShowDialog(); } if (access == "Низький") { menu.enter_level(access); main.enter_level(access); add.ShowDialog(); } Login_textbox.Clear(); Password_textbox.Clear(); } else { Password_textbox.Clear(); MessageBox.Show("Невірний логін чи пароль!", "Помилка", MessageBoxButtons.OK, MessageBoxIcon.Information); } } } }