private void Button_Click(object sender, RoutedEventArgs e)
{
string connectionString = "Server=localhost;DATABASE=inwork;UID=root;password=root";
MySqlConnection connection = new MySqlConnection(connectionString);
MySqlCommand cmd = new MySqlCommand("select * from authorization where user_login='******' and user_password='******' and user_status_id = " + status_id + ";", connection);
try
{
if (connection.State == ConnectionState.Closed)
{
connection.Open();
}
if (status_id == 1)
{
cmd.CommandType = CommandType.Text;
MySqlDataAdapter adapter = new MySqlDataAdapter();
adapter.SelectCommand = cmd;
DataSet dataSet = new DataSet();
adapter.Fill(dataSet);
if (dataSet.Tables[0].Rows.Count > 0)
{
MainMenuWindow mainMenuWindow = new MainMenuWindow();
mainMenuWindow.Show();
this.Close();
}
else
{
MessageBox.Show("Пароль или логин неверный!");
}
}
else
{
cmd.CommandType = CommandType.Text;
MySqlDataAdapter adapter = new MySqlDataAdapter();
adapter.SelectCommand = cmd;
DataSet dataSet = new DataSet();
adapter.Fill(dataSet);
if (dataSet.Tables[0].Rows.Count > 0)
{
MainMenu2 mainMenuWindow2 = new MainMenu2();
mainMenuWindow2.Show();
this.Close();
}
else
{
MessageBox.Show("Пароль или логин неверный!");
}
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
finally
{
connection.Close();
}
}
private void Button_Click(object sender, RoutedEventArgs e)
{
string connectionString = "Server=localhost;DATABASE=menu;UID=root;password=c_ronaldo";
MySqlConnection connection = new MySqlConnection(connectionString);
//MySqlCommand cmd = new MySqlCommand("select * from users where user_login='******' and user_password='******';", connection);
//connection.Open();
//DataTable dt = new DataTable();
//dt.Load(cmd.ExecuteReader());
//connection.Close();
//MainMenuWindow mainMenuWindow = new MainMenuWindow();
//mainMenuWindow.mainMenu.DataContext = dt;
//this.Close();
//mainMenuWindow.Show();
try
{
if (connection.State == ConnectionState.Closed)
{
connection.Open();
}
MySqlCommand cmd = new MySqlCommand("select * from users where name='" + user_name.Text + "' and password='******';", connection);
cmd.CommandType = CommandType.Text;
MySqlDataAdapter adapter = new MySqlDataAdapter();
adapter.SelectCommand = cmd;
DataSet dataSet = new DataSet();
adapter.Fill(dataSet);
if (dataSet.Tables[0].Rows.Count > 0)
{
MainMenuWindow mainMenuWindow = new MainMenuWindow();
mainMenuWindow.Show();
this.Close();
}
else
{
MessageBox.Show("Пароль или логин неверный!");
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
finally
{
connection.Close();
}
}
private void Button_Click(object sender, RoutedEventArgs e)
{
string connectionString = "Server=localhost;DATABASE=dota2;UID=root;password=root";
MySqlConnection connection = new MySqlConnection(connectionString);
MySqlCommand cmd = new MySqlCommand("select * from users where user_login='******' and user_password='******';", connection);
connection.Open();
DataTable dt = new DataTable();
dt.Load(cmd.ExecuteReader());
connection.Close();
MainMenuWindow mainMenuWindow = new MainMenuWindow();
mainMenuWindow.mainMenu.DataContext = dt;
this.Close();
mainMenuWindow.Show();
}
