private void button7_Click(object sender, EventArgs e)
{
OdbcConnection conexion = TaquillaDB.getDB();
try
{
string sql = string.Format("SELECT * FROM USUARIO WHERE USU_USUARIO = '{0}'", Txt_loginUser.Text);
OdbcCommand cmd = new OdbcCommand(sql, conexion);
OdbcDataReader reader = cmd.ExecuteReader();
if (reader.Read())
{
if (reader.GetString(1) == Txt_loginPass.Text)
{
if (reader.GetInt32(2) == 0)
{
Txt_loginUser.Text = "";
Txt_loginPass.Text = "";
frm_main nuevo = new frm_main(this);
this.Hide();
nuevo.Show();
}
else
{
MessageBox.Show("Falta de privilegios!!", "ERROR", MessageBoxButtons.OK, MessageBoxIcon.Error);
Txt_loginUser.Text = "";
Txt_loginUser.Focus();
}
}
else
{
MessageBox.Show("Password incorrect!!", "ERROR", MessageBoxButtons.OK, MessageBoxIcon.Error);
Txt_loginPass.Focus();
}
}
else
{
MessageBox.Show("Usuario no valido!!", "ERROR", MessageBoxButtons.OK, MessageBoxIcon.Error);
Txt_loginUser.Text = "";
Txt_loginUser.Focus();
}
}
catch (Exception ex)
{
MessageBox.Show(ex.ToString());
}
Txt_loginPass.Text = "";
Chk_gestionPass.Checked = false;
conexion.Close();
}
public frm_funciones(frm_main anterior, bool[] privilegios)
{
InitializeComponent();
menu = anterior;
actualizar();
peli();
subt();
idiom();
sala();
hora();
formato();
Btn_formatoAceptar.Enabled = privilegios[0];
dataGridView2.Visible = privilegios[1];
button10.Enabled = privilegios[2];
button2.Visible = privilegios[3];
}
public frm_usuarios(frm_main anterior)
{
InitializeComponent();
menu = anterior;
actualizar();
}
public frm_bitacora(frm_main anterior)
{
InitializeComponent();
menu = anterior;
actualizar();
}
public frm_subtitulado(frm_main anterior)
{
InitializeComponent();
menu = anterior;
actualizar();
}
public frm_experiencia(frm_main anterior)
{
InitializeComponent();
menu = anterior;
actualizar();
}
private void button7_Click(object sender, EventArgs e)
{
OdbcConnection conexion = TaquillaDB.getDB();
try
{
string sql = string.Format("SELECT * FROM USUARIO WHERE USU_USUARIO = '{0}'", Txt_loginUser.Text);
OdbcCommand cmd = new OdbcCommand(sql, conexion);
OdbcDataReader reader = cmd.ExecuteReader();
bool[] privilegios = new bool[4];
if (reader.Read())
{
conexion.Close();
conexion = TaquillaDB.getDB();
sql = string.Format("SELECT INSERT_USUARIO, SELECT_USUARIO, UPDATE_USUARIO, DELETE_USUARIO FROM USUARIO WHERE USU_USUARIO = '{0}' AND PASS_USUARIO = MD5('{1}');", Txt_loginUser.Text, Txt_loginPass.Text);
cmd = new OdbcCommand(sql, conexion);
reader = cmd.ExecuteReader();
if (reader.Read())
{
privilegios[0] = Convert.ToBoolean(reader.GetInt32(0));
privilegios[1] = Convert.ToBoolean(reader.GetInt32(1));
privilegios[2] = Convert.ToBoolean(reader.GetInt32(2));
privilegios[3] = Convert.ToBoolean(reader.GetInt32(3));
if (privilegios[0] || privilegios[1] || privilegios[2] || privilegios[3])
{
OdbcConnection cnx = TaquillaDB.getDB();
sql = string.Format("INSERT INTO BITACORA VALUES (NULL, 'LOG IN', NOW(), '{0}', USER());", Txt_loginUser.Text);
OdbcCommand cm = new OdbcCommand(sql, cnx);
cm.ExecuteNonQuery();
Txt_loginUser.Text = "";
Txt_loginPass.Text = "";
Txt_loginUser.Focus();
frm_main nuevo = new frm_main(this, privilegios);
this.Hide();
nuevo.Show();
cnx.Close();
}
else
{
MessageBox.Show("Falta de privilegios!!", "ERROR", MessageBoxButtons.OK, MessageBoxIcon.Error);
Txt_loginUser.Text = "";
Txt_loginUser.Focus();
}
}
else
{
MessageBox.Show("Password incorrect!!", "ERROR", MessageBoxButtons.OK, MessageBoxIcon.Error);
Txt_loginPass.Focus();
}
}
else
{
MessageBox.Show("Usuario no valido!!", "ERROR", MessageBoxButtons.OK, MessageBoxIcon.Error);
Txt_loginUser.Text = "";
Txt_loginUser.Focus();
}
}
catch (Exception ex)
{
MessageBox.Show(ex.ToString());
}
Txt_loginPass.Text = "";
Chk_gestionPass.Checked = false;
conexion.Close();
}
