private void Button_Click(object sender, RoutedEventArgs e)
{
//добавление данных о пользователе в БД, если все данные введены верно
if (PasswordTB.Password == RepPasswordTB.Password)
{
DB dB = new DB(Properties.Settings.Default.CinemaDBConnectionString);
object login = dB.ExecuteScalarQuery($"SELECT Логин FROM Пользователь WHERE Логин = '{LoginTB.Text}'");
if (login == null)
{
int rows = dB.ExecuteQuery($"INSERT INTO [Пользователь] Values(N'{LoginTB.Text}', N'{PasswordTB.Password}', N'{EmailTB.Text}', N'{PhoneTB.Text}', 0, 0, N'{LastNameTB.Text}', N'{FirstNameTB.Text}', N'{MiddleNameTB.Text}')");
if (rows == 1)
{
MessageBox.Show("Регистрация прошла успешно!");
LastNameTB.Clear();
FirstNameTB.Clear();
MiddleNameTB.Clear();
EmailTB.Clear();
PhoneTB.Clear();
LoginTB.Clear();
PasswordTB.Clear();
RepPasswordTB.Clear();
AddText();
}
}
else
{
MessageBox.Show("Такой логин уже существует!");
}
}
else
{
MessageBox.Show("Пароли не совпадают!");
}
}
private void CMain_Load(object sender, EventArgs e)
{
// TODO: This line of code loads data into the 'cyber_CafeDataSet.Console' table. You can move, or remove it, as needed.
//this.consoleTableAdapter.Fill(this.cyber_CafeDataSet.Console);
label15.Hide();
label16.Hide();
label17.Hide();
PasswordTB.Hide();
RePasswordTB.Hide();
try
{
int returnval = Program.ctrl.InsertShiftLog(Program.UserID);
if (returnval == 1)
{
MessageBox.Show("Shift Inserted");
}
else
{
MessageBox.Show("You Have Logged Before Today");
}
}
catch (Exception ex)
{
}
}
public void DataBaseRead(string log)
{
string connect = "server=localhost;user=root;database=users;password=butterflyknife558831yaYA;";
MySqlConnection conn = new MySqlConnection(connect);
try
{
conn.Open();
string sql = "SELECT password FROM users_data WHERE login = '******'";
MySqlCommand command = new MySqlCommand(sql, conn);
try
{
string pass = command.ExecuteScalar().ToString();
PasswordTB.Text = pass;
RememberCB.Checked = false;
RememberCB.Enabled = false;
ForgetBut.Enabled = true;
}
catch
{
ForgetBut.Enabled = false;
RememberCB.Enabled = true;
PasswordTB.Clear();
}
conn.Close();
}
catch
{
}
}
private void PasswordTB_Click(object sender, EventArgs e)
{
SignInBTN.Enabled = true;
PasswordTB.Clear();
PasswordTB.PasswordChar = '*';
PasswordTB.MaxLength = 6;
}
private void label7_Click(object sender, EventArgs e)
{
try
{
if (PasswordTB.Text.ToString() == RePasswordTB.Text.ToString())
{
Program.ctrl.ChangePassword(Program.UserID, 1, PasswordTB.Text.ToString());
MessageBox.Show("Password Changed Successfully");
}
else
{
MessageBox.Show("Please Check that the Passwords are the same");
}
}
catch (Exception ex)
{
MessageBox.Show("Please Enter a Correct Password");
}
label9.Hide();
label8.Hide();
label7.Hide();
PasswordTB.Hide();
RePasswordTB.Hide();
}
public void clearPasswords()
{
PasswordTB.Password = "";
PasswordChkTB.Password = "";
PasswordTB.Focus();
Keyboard.Focus(PasswordTB);
}
private void button3_Click(object sender, EventArgs e)
{
label5.Show();
label6.Show();
label7.Show();
PasswordTB.Show();
RePasswordTB.Show();
}
private void textBox2_Click(object sender, EventArgs e)
{
button1.Enabled = true;
label2.Visible = true;
PasswordTB.Clear();
PasswordTB.UseSystemPasswordChar = true;
PasswordTB.MaxLength = 10;
}
private void CMain_Load(object sender, EventArgs e)
{
label9.Hide();
label8.Hide();
label7.Hide();
PasswordTB.Hide();
RePasswordTB.Hide();
}
private void PasswordTB_Leave(object sender, EventArgs e)
{
if (PasswordTB.Text == "")
{
PasswordTB.Text = "password";
PasswordTB.UseSystemPasswordChar = false;
}
PasswordTB.DeselectAll();
}
private void LoginTB_KeyPress(object sender, KeyPressEventArgs e)
{
if (e.KeyChar == (char)Keys.Enter || e.KeyChar == (char)Keys.Tab)
{
PasswordTB.Focus();
}
if (e.KeyChar == (char)Keys.Escape)
{
Exit_Click(Exit, null);
}
}
private void UserLogin(object sender, EventArgs e)
{
var hashedPass = GenerateHash(PasswordTB.Text);
//MessageBox.Show(LibraryDBCon.ServerVersion);
// Open DataBase
if (LibraryDBCon.State == ConnectionState.Closed)
{
LibraryDBCon.Open();
}
// Create Connection With DataBase
sqlcom.Connection = LibraryDBCon;
sqlcom.CommandType = CommandType.Text;
sqlcom.CommandText = $"SELECT FullName FROM Librarians WHERE UserName = '******' AND PassHash = '{hashedPass}'";
SqlDataReader DR = sqlcom.ExecuteReader();
if (DR.Read())
{
// Set The Id To Static To Be Avilabile To The Other Forms
UserName = DR[0].ToString();
DashBoard Admin = new DashBoard();
this.Hide();
// Reset User Name And Password Field
UserNameTB.ResetText();
PasswordTB.ResetText();
if (Admin.ShowDialog() == DialogResult.OK)
{
this.Show();
}
else
{
this.Close();
}
}
else
{
MetroFramework.MetroMessageBox.Show(this, "Worng Name or Password.", "Error Message", 100);
}
// Close Data Reader
DR.Close();
// Close DataBase Connection
if (LibraryDBCon.State == ConnectionState.Open)
{
LibraryDBCon.Close();
}
}
//ssprivate OleDbConnection myCon;
//sspublic OleDbCommand command, command1;
//ssstring empName = "", empID = "";
public LoginForm()
{
//ssmyCon = new OleDbConnection(@"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\Users\uidw8018\Documents\ICTDB.mdb;Persist Security Info=False");
InitializeComponent();
menuStrip1.Visible = false;
//Create_DBTable();
KeyPreview = true;
//sscommand = new OleDbCommand("SELECT * FROM Login", myCon);
PasswordTB.Clear();
AcceptButton = LoginB;
}
private async void SignInBTN_Click(object sender, EventArgs e)
{
if ((LoginTB.Text == "") || (PasswordTB.Text == ""))
{
MessageBox.Show("Все поля должны быть заполнены!", "Ошибка.");
return;
}
TeacherLogin = LoginTB.Text;
TeacherPassword = PasswordTB.Text;
string answer = null;
label5.Text = "Идет процесс авторизации. Пожалуйста, ожидайте...";
try
{
answer = await Server.GetResponseAsync("http://*****:*****@"Неверно указан логин и\или пароль.", "Ошибка.");
return;
}
LoginTB.Clear();
PasswordTB.Clear();
label1.Visible = false;
label2.Visible = false;
LoginTB.Visible = false;
PasswordTB.Visible = false;
SignInBTN.Visible = false;
DepartmentChB.Visible = true;
DepartmentChB.Enabled = false;
GroupChB.Visible = true;
GroupChB.Enabled = false;
AllDepChB.Visible = true;
AllDepChB.Enabled = false;
SendFacultyRB.Visible = true;
SendDepartmentRB.Visible = true;
SendGroupRB.Visible = true;
label3.Visible = true;
MessageRTB.Visible = true;
MessageRTB.Enabled = false;
SendBTN.Visible = true;
DepartmentCB.Visible = true;
DepartmentCB.Enabled = false;
ThemeTB.Visible = true;
ThemeTB.Enabled = false;
label4.Visible = true;
}
private void ClearFields()
{
LoginTB.Clear();
PasswordTB.Clear();
CPasswordTB.Clear();
SurnameTB.Clear();
NameTB.Clear();
PatronymicTB.Clear();
FacultyCB.Text = "";
DepartmentCB.Text = "";
DepartmentCB.Enabled = false;
}
private void PasswordTB_Click(object sender, EventArgs e)
{
if (PasswordTB.Text.Equals("Password"))
{
PasswordTB.Clear();
PasswordTB.PasswordChar = '*';
}
PasswordIcon.IconColor = Color.FromArgb(67, 174, 208);
PassPanel.BackColor = Color.FromArgb(67, 174, 208);
EmailIcon.IconColor = Color.WhiteSmoke;
EmailPanel.BackColor = Color.WhiteSmoke;
}
private void ExitB_Click(object sender, EventArgs e)
{
DialogResult res = MessageBox.Show("Do you really want to exit?", "Quit", MessageBoxButtons.YesNo, MessageBoxIcon.Warning, MessageBoxDefaultButton.Button1);
if (res == DialogResult.Yes)
{
Application.Exit();
}
else
{
PasswordTB.Clear();
}
}
private void ClearFields()
{
BookNumberTB.Clear();
PhoneNumberTB.Clear();
EmailAddressTB.Clear();
PasswordTB.Clear();
CPasswordTB.Clear();
FacultyCB.Text = "";
DepartmentCB.Text = "";
DepartmentCB.Enabled = false;
GroupCB.Text = "";
GroupCB.Enabled = false;
RegCB.Checked = false;
}
private void Login_Load(object sender, EventArgs e)
{
StyleSM.MetroColorParameters = new DevComponents.DotNetBar.Metro.ColorTables.MetroColorGeneratorParameters(Color.White, Properties.Settings.Default.ColorScheme);
SelectedH.FocusHighlightColor = DevComponents.DotNetBar.Validator.eHighlightColor.Custom;
SelectedH.CustomHighlightColors = new Color[] { Properties.Settings.Default.ColorScheme, Properties.Settings.Default.ColorScheme, Properties.Settings.Default.ColorScheme };
ProgressCP.ProgressColor = Properties.Settings.Default.ColorScheme;
ProgressCP.IsRunning = true;
if (Properties.Settings.Default.LoginRemember)
{
UsernameTB.Text = Properties.Settings.Default.LoginUsername;
RememberCB.Checked = Properties.Settings.Default.LoginRemember;
PasswordTB.Select();
PasswordTB.Focus();
}
}
/// <summary>
/// clears the fields/textboxes
/// to enter a new user's information
/// </summary>
private void NewClearTB()
{
newID = db.Users.Max(m => m.UserID) + 1;
UseridTB.Text = newID.ToString();
FirstnameTB.Clear();
LastnameTB.Clear();
emailTB.Clear();
usernameTB.Clear();
PasswordTB.Clear();
usernameTB.ReadOnly = true;
PasswordTB.ReadOnly = true;
AccessTypeCB.Enabled = true;
AccessTypeCB.SelectedIndex = -1;
enable();
}
private void loginButton_Click(object sender, RoutedEventArgs e)
{
if (logicRef.checkLogin(UsernameTB.Text, PasswordTB.Password))
{
mainWRef.LoginOk = true;
mainWRef.SocSecNb = UsernameTB.Text;
this.Close();
}
else
{
MessageBox.Show("Brugernavn og password stemmer ikke overens.\nPrøv igen.");
PasswordTB.Clear();
UsernameTB.Focus();
UsernameTB.SelectAll();
}
}
private void Login_B_Click(object sender, RoutedEventArgs e)
{
logicObj = new Logic();
if (logicObj.checkLogin(UsernameTB.Text, PasswordTB.Password))
{
//viewmodel.ActivateButton = true;
this.Close();
}
else
{
MessageBox.Show("Brugernavn og password stemmer ikke overens.\nPrøv igen.");
PasswordTB.Clear();
UsernameTB.Focus();
UsernameTB.SelectAll();
}
}
private void CMain_Load(object sender, EventArgs e)
{
dataGridView1.AutoSizeColumnsMode = DataGridViewAutoSizeColumnsMode.Fill;
label4.Text = Program.UserID.ToString();
DataTable dt = Program.ctrl.ViewAllFeedback(); //view after insertion
dataGridView1.DataSource = null;
dataGridView1.Refresh();
dataGridView1.DataSource = dt;
dataGridView1.Refresh();
label5.Hide();
label6.Hide();
label7.Hide();
PasswordTB.Hide();
RePasswordTB.Hide();
}
private void Button_Click(object sender, RoutedEventArgs e)
{
if (FirstNameTB.Text != "" || EmailTB.Text != "" || PhoneTB.Text != "" ||
LoginTB.Text != "" || PasswordTB.Password != "" || RepPasswordTB.Password != "")
{
if (PasswordTB.Password == RepPasswordTB.Password)
{
using (SqlConnection connection = new SqlConnection(@"Data Source=(LocalDB)\MSSQLLocalDB;AttachDbFilename=E:\OlineCinema\OlineCinema\CinemaDB.mdf;Integrated Security=True"))
{
try
{
connection.Open();
}
catch
{
MessageBox.Show("Ошибка соединения с базой данных!");
return;
}
string query = $"INSERT INTO [Пользователь] Values('{LoginTB.Text}', '{PasswordTB.Password}', '{EmailTB.Text}', '{PhoneTB.Text}', 0, 0, '{LastNameTB.Text}', '{FirstNameTB.Text}', '{MiddleNameTB.Text}')";
SqlCommand command = new SqlCommand(query, connection);
command.ExecuteNonQuery();
MessageBox.Show("Регистрация прошла успешно!");
LastNameTB.Clear();
FirstNameTB.Clear();
MiddleNameTB.Clear();
EmailTB.Clear();
PhoneTB.Clear();
LoginTB.Clear();
PasswordTB.Clear();
RepPasswordTB.Clear();
}
}
else
{
MessageBox.Show("Пароли не свопадают!");
}
}
else
{
MessageBox.Show("Есть незаполненные поля!");
}
}
private void PasswordTB_Enter(object sender, EventArgs e)
{
if (PasswordTB.Text == "password")
{
PasswordTB.Clear();
}
if (hiddenPass)
{
PasswordTB.UseSystemPasswordChar = true;
}
PasswordTB.SelectAll();
PasswordTB.Focus();
passPic.BackgroundImage = Properties.Resources.userPassword2;
PasswordLn.BackColor = Color.White;
PasswordTB.ForeColor = Color.White;
userPic.BackgroundImage = Properties.Resources.userLogin;
UserNameLn.BackColor = Color.Black;
UserNameTB.ForeColor = Color.Black;
//wrongTB.Visible = false;
}
private void LoginB_Click(object sender, EventArgs e)
{
try
{
//using (OleDbDataReader reader = command.ExecuteReader())
//{
// while (reader.Read())
// {
//MessageBox.Show(reader.GetString(1) + ";" + UsernameCB.SelectedItem);
if (UsernameCB.SelectedItem.ToString() != "")
{
if (PasswordTB.Text == "MDPSBE@123")
{
//ssMessageBox.Show("Login Success");
//ssempName = reader.GetString(1).ToString();
//ssempID = reader.GetString(0).ToString();
Form1 MForm = new Form1();
MForm.Show();
this.Hide();
}
else
{
MessageBox.Show("Incorrect Password.");
PasswordTB.Clear();
ActiveControl = PasswordTB;
}
//ss break;
}
//ss }
//ssreader.Close();
//ss }
}
catch (Exception exct)
{
MessageBox.Show(exct.Message);
}
}
private void LoginBtn_Click(object sender, EventArgs e)
{
for (int i = 0; i < 5; i++)
{
if (dllfile.userN[i] == UserNameTB.Text)
{
if (dllfile.password[i] == dllfile.Decrypt(PasswordTB.Text))
{
MessageBox.Show("Login Successfull");
Purchase pur = new Purchase();
pur.Show();
UserNameTB.Clear();
PasswordTB.Clear();
break;
}
else
{
MessageBox.Show("Login Failed");
break;
}
}
}
}
private void LoginButton_Click(object sender, RoutedEventArgs e)
{
int ret = SendAuthenticationGet(LoginTB.Text, PasswordTB.Password);
if (ret == 1)
{
RQSApp win = new RQSApp(LoginTB.Text);
Visibility = Visibility.Hidden;
win.ShowDialog();
Visibility = Visibility.Visible;
LoginTB.Clear();
PasswordTB.Clear();
LoginTB.Focus();
}
else if (ret == 0)
{
MessageBox.Show("Vérifiez d'avoir les bons identifiants ou inscrivez-vous !", "Mot de passe incorrect", MessageBoxButton.OK, MessageBoxImage.Exclamation);
}
else
{
MessageBox.Show("Une problème est survenu !", "ERROR", MessageBoxButton.OK, MessageBoxImage.Error);
}
}
private void button5_Click(object sender, EventArgs e)
{
if (!changePass)
{
label9.Show();
label8.Show();
label7.Show();
PasswordTB.Show();
RePasswordTB.Show();
changePass = !changePass;
UserNameLp.Location = new Point(0, 74);
}
else
{
label9.Hide();
label8.Hide();
label7.Hide();
PasswordTB.Hide();
RePasswordTB.Hide();
changePass = !changePass;
UserNameLp.Location = Loc;
}
}
public LoginPage(string username = null)
{
/*
* Thread.CurrentThread.CurrentCulture = new CultureInfo("hu-HU");
* Thread.CurrentThread.CurrentUICulture = new CultureInfo("hu-HU");
* LanguageProperty.OverrideMetadata(typeof(FrameworkElement), new FrameworkPropertyMetadata(
* XmlLanguage.GetLanguage(CultureInfo.CurrentCulture.IetfLanguageTag)));
*/
InitializeComponent();
if (username != null)
{
UserNameTB.Text = username;
PasswordTB.Focus();
Keyboard.Focus(PasswordTB);
}
else
{
UserNameTB.Focus();
Keyboard.Focus(UserNameTB);
}
viewModel = FindResource("viewModel") as ViewModels.LoginViewModel;
viewModel.SetLoginPage(this);
//DataContext = new LoginViewModel(this);
}
