private void Contract_Wizard_Click(object sender, RoutedEventArgs e) { try { CreateContractWindow wizard = new CreateContractWindow(); wizard.ShowDialog(); } catch (Exception ex) { MessageBox.Show("Error: " + ex.Message); } }
private void loginButton_Click(object sender, RoutedEventArgs e) { currentEmployee = new CurrentEmployee(); currentClient = new CurrentClient(); try { using (OracleConnection connection = new OracleConnection(OracleDatabaseConnection.adminConn)) { connection.Open(); OracleParameter login = new OracleParameter { ParameterName = "in_login", Direction = ParameterDirection.Input, OracleDbType = OracleDbType.NVarchar2, Value = loginText.Text }; OracleParameter password = new OracleParameter { ParameterName = "in_password", Direction = ParameterDirection.Input, OracleDbType = OracleDbType.NVarchar2, Value = passwordText.Password }; OracleParameter user = new OracleParameter { ParameterName = "user_cur", Direction = ParameterDirection.Output, OracleDbType = OracleDbType.RefCursor }; if (!loginText.Text.StartsWith("+37533")) { using (OracleCommand command = new OracleCommand("findUser", connection)) { command.CommandType = CommandType.StoredProcedure; command.Parameters.AddRange(new OracleParameter[] { login, password, user }); var reader = command.ExecuteReader(); DataTable dt = new DataTable(); dt.Load(reader); foreach (DataRow row in dt.Rows) { check = true; currentEmployee.id = int.Parse(row["Id"].ToString()); currentEmployee.position = row["Position"].ToString(); } } connection.Close(); if (adminPos == currentEmployee.position) { AdminWindow adminWindow = new AdminWindow(); adminWindow.Show(); this.Close(); } if (employeePos == currentEmployee.position) { CreateContractWindow createContractWindow = new CreateContractWindow(currentEmployee); createContractWindow.Show(); this.Close(); } } else { using (OracleCommand command = new OracleCommand("findClient")) { command.Connection = connection; command.CommandType = CommandType.StoredProcedure; command.Parameters.AddRange(new OracleParameter[] { login, password, user }); var reader = command.ExecuteReader(); DataTable dt = new DataTable(); dt.Load(reader); foreach (DataRow row in dt.Rows) { check = true; currentClient.id = int.Parse(row["Id"].ToString()); } connection.Close(); ClientWindow clientWindow = new ClientWindow(currentClient); clientWindow.Show(); this.Close(); } } } } catch (OracleException ex) { MessageBox.Show(ex.Message); } }