private void btlogin_Click(object sender, EventArgs e)
{
/* frmHome home = new frmHome();
* home.Show();
* this.Hide();
*/
//conexão banco
OracleConnection conexao = new OracleConnection(@"Data Source = (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = localhost)
(PORT = 1521))(CONNECT_DATA = (SERVER = DEDICATED)(SERVICE_NAME = xe)));Password=1234567;User ID= hotelsystem");
try
{
conexao.Open(); //abrir banco
OracleCommand command = new OracleCommand(@"select * from usuario where usuario =:usuario and senha_user = :senha_user", conexao);
command.Parameters.Add(":usuario", txtloginlog.Text);
command.Parameters.Add(":senha_user", txtsenhalog.Text);
command.ExecuteNonQuery(); //ler o resultado
OracleDataReader drms = command.ExecuteReader(); //roda resultado
if (drms.HasRows == false) //se as informações estiverem erradas, exibir mensagem de erro
{
throw new Exception("Usuário ou senha inválidos!");
}
drms.Read(); //informações correta abrir form home
MessageBox.Show("Login efetuado com sucesso!");
frmHome home = new frmHome();
home.Show();
this.Hide();
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
finally
{
conexao.Close();
}
}
private void btNao_Click(object sender, EventArgs e)
{
frmHome home = new frmHome();
home.Show();
}
