private void button1_Click(object sender, EventArgs e)
{
Form ware = new WareForm();
ware.Show();
this.Close();
}
private void button1_Click(object sender, EventArgs e)
{
SqlConnection connection = new SqlConnection(Properties.Settings.Default.dbConnectionSettings);
connection.Open();
String login = textBox1.Text;
String pass = textBox2.Text;
SqlCommand command = new SqlCommand("SELECT * FROM users WHERE login = '******' AND password = '******'", connection);
SqlDataReader reader = command.ExecuteReader();
String role = "", name = "";
while (reader.Read())
{
role = reader[2].ToString();
name = reader[3].ToString();
}
Form form = null;
switch (role)
{
case "User":
form = new UserForm(login);
Hide();
form.Show();
break;
case "Director":
form = new AdminForm();
Hide();
form.Show();
break;
case "Ware":
form = new WareForm();
Hide();
form.Show();
break;
case "Manager":
form = new ManagerForm();
Hide();
form.Show();
break;
default:
MessageBox.Show("Роль не установлена или пользователь не найден!");
break;
}
reader.Close();
connection.Close();
}