private void btCancel_Click(object sender, RoutedEventArgs e)
{
KladovchikWindow k = new KladovchikWindow();
k.Show();
this.Close();
}
private void btnSubmit_Click(object sender, RoutedEventArgs e)
{
String connectionString = ConfigurationManager.ConnectionStrings["myConnectionString"].ConnectionString;
con = new OracleConnection(connectionString);
try
{
if (con.State == ConnectionState.Closed)
{
con.Open();
}
OracleCommand cmd = con.CreateCommand();
cmd.BindByName = true;
cmd.CommandText = "SELECT COUNT(1) FROM ПОЛЬЗОВАТЕЛЬ WHERE ЛОГИН=:ЛОГИН AND ПАРОЛЬ=:ПАРОЛЬ AND РОЛЬ=:РОЛЬ";
cmd.CommandType = CommandType.Text;
cmd.Parameters.Add("ЛОГИН", OracleDbType.Varchar2, 150).Value = txtUsername.Text;
cmd.Parameters.Add("ПАРОЛЬ", OracleDbType.Varchar2, 150).Value = txtPassword.Password;
cmd.Parameters.Add("РОЛЬ", OracleDbType.Varchar2, 150).Value = FunctionCBox.SelectedItem.ToString();
int count = Convert.ToInt32(cmd.ExecuteScalar());
if (count == 1)
{
if (FunctionCBox.SelectedItem.ToString() == "Дирекция")
{
DirekciaWindow d = new DirekciaWindow(txtUsername.Text);
d.Show();
this.Close();
}
else if (FunctionCBox.SelectedItem.ToString() == "Заказчик")
{
ZakazWindow z = new ZakazWindow(txtUsername.Text);
z.Show();
this.Close();
}
else if (FunctionCBox.SelectedItem.ToString() == "Менеджер")
{
MainWindow main = new MainWindow(txtUsername.Text);
main.Show();
this.Close();
}
else
{
KladovchikWindow k = new KladovchikWindow(txtUsername.Text);
k.Show();
this.Close();
}
}
else
{
MessageBox.Show("Логин, пароль или роль не правилно");
}
}
catch (Exception)
{
MessageBox.Show("Пожалуйста запольняйте все поли");
}
finally
{
con.Close();
}
}