private void btnLogin_Click(object sender, EventArgs e) { if (String.IsNullOrEmpty(txtUsername.Text) || String.IsNullOrEmpty(txtPassword.Text)) { lblError.Text = "Логин или пароль пустые"; lblError.Show(); return; } if (txtUsername.Text == "admin") { SQLiteConnection conn = new SQLiteConnection(); try { conn = new SQLiteConnection(strConnect); conn.Open(); SQLiteCommand CMD = conn.CreateCommand(); CMD.CommandText = "SELECT password FROM LoginTable WHERE username = @username"; CMD.Parameters.Add("@username", System.Data.DbType.String).Value = txtUsername.Text; SQLiteDataReader SQL = CMD.ExecuteReader(); if (SQL.HasRows) { while (SQL.Read()) { if (SQL["password"].ToString() != txtPassword.Text) { lblError.Text = "Неправильный пароль"; } } } } catch (Exception ex) { throw ex; } finally { conn.Close(); } AdminProfileForm adminProfileForm = new AdminProfileForm(); adminProfileForm.Show(); this.Hide(); } else { string error = UserHandler.CheckUser(txtUsername.Text, txtPassword.Text); if (error == "ОК") { Worker user = UserHandler.GetUser(txtUsername.Text); UserProfileForm userProfileForm = new UserProfileForm(user); userProfileForm.Show(); this.Hide(); } else { lblError.Text = error; } } }
private void btnRegister_Click(object sender, EventArgs e) { Dictionary <string, string> parameters = new Dictionary <string, string>() { { "username", username }, { "password", password }, { "name", txtName.Text }, { "surname", txtSurname.Text }, { "role", cmbRole.Text }, }; Worker user = UserHandler.UserCreated(parameters, dtStartDate.Value.Date); UserProfileForm profile = new UserProfileForm(user); profile.Show(); this.Hide(); }