//pseudo botão pra abrir a tela de adm rapido
private void btnadm_Click(object sender, EventArgs e)
{
adminlogin frmadmin = new adminlogin(TxtBoxUser.Text);
frmadmin.Show();
this.Hide();
}
public void BtnLogin_Click(object sender, EventArgs e)
{
try
{
//string strConexao = @"Data Source=(LocalDB)\MSSQLLocalDB;AttachDbFilename=C: \Users\JR TECH\source\repos\CinemaV1\CinemaV1\bdGeral.mdf;Integrated Security=True";
//cria a conexao
OleDbConnection conn = new OleDbConnection(CinemaV1.Properties.Settings.Default.strConexao);
//SqlConnection conn = new SqlConnection(strConexao);
OleDbCommand comm = new OleDbCommand("select * from Cadastros where Nome = @user and Senha = @senha", conn);
// SqlCommand comm = new SqlCommand("select * from Cadastros where Nome = @user and Senha = @senha", conn);
comm.Parameters.Add("@user", OleDbType.VarChar).Value = TxtBoxUser.Text;
//comm.Parameters.Add("@user", SqlDbType.VarChar).Value = TxtBoxUser.Text;
//comm.Parameters.Add("@senha", SqlDbType.VarChar).Value = TxtBoxPass.Text;
comm.Parameters.Add("@senha", OleDbType.VarChar).Value = TxtBoxPass.Text;
conn.Open();
if (TxtBoxUser.Text == "genji" && TxtBoxPass.Text == "genji")
{
adminlogin frmadmin = new adminlogin(TxtBoxUser.Text);
frmadmin.Show();
this.Hide();
}
int i = int.Parse(comm.ExecuteScalar().ToString());
if (i > 0)
{
//Abre o form Home e esconde o form1
Home frmHome = new Home(TxtBoxUser.Text);
frmHome.Show();
this.Hide();
}
else
{
MessageBox.Show("Error Usuario não foi encontrado, verifique a senha e o Login");
}
conn.Close();
}
catch (Exception)
{
MessageBox.Show("Error, Usuario ou Senha invalidos, ou bd danificado");
}
}