private void PictureBox3_Click(object sender, EventArgs e)
{
try
{
if (txtc.Text.Trim() != "" && txtn.Text.Trim() != "" && txta.Text.Trim() != "" && txtce.Text.Trim() != "" && txtu.Text.Trim() != "" && txtcl.Text.Trim() != "")
{
Conection.Conectar();
string eliminar = "DELETE FROM Administradores WHERE Codigo_administrador=@c";
SqlCommand cmd3 = new SqlCommand(eliminar, Conection.Conectar());
cmd3.Parameters.AddWithValue("@c", txtc.Text);
cmd3.ExecuteNonQuery();
MessageBox.Show("Registro eliminado", "HECHO", MessageBoxButtons.OK, MessageBoxIcon.Information);
limpiar();
dgv.DataSource = llenar_grid();
}
else
{
MessageBox.Show("Campos Vacios", "ERROR", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
catch (Exception error)
{
MessageBox.Show("Algo salio mal", "ERROR", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
private void PictureBox1_Click(object sender, EventArgs e)
{
try
{
if (txtc.Text.Trim() != "" && txtn.Text.Trim() != "" && cmb1.Text.Trim() != "" && cmb2.Text.Trim() != "")
{
Conection.Conectar();
string insertar = "INSERT INTO Grados(Codigo_grado, Nombre_grado, Codigo_maestro, Carnet) VALUES (@c, @n, @m, @a)";
SqlCommand cmd1 = new SqlCommand(insertar, Conection.Conectar());
cmd1.Parameters.AddWithValue("@c", txtc.Text);
cmd1.Parameters.AddWithValue("@n", txtn.Text);
cmd1.Parameters.AddWithValue("@m", cmb1.Text);
cmd1.Parameters.AddWithValue("@a", cmb2.Text);
cmd1.ExecuteNonQuery();
MessageBox.Show("Registro agregado", "HECHO", MessageBoxButtons.OK, MessageBoxIcon.Information);
limpiar();
dgv.DataSource = llenar_grid();
}
else
{
MessageBox.Show("Campos Vacios", "ERROR", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
catch (Exception error)
{
MessageBox.Show("Algo salio mal", "ERROR", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
private void PictureBox2_Click(object sender, EventArgs e)
{
try
{
if (txtc.Text.Trim() != "" && txtn.Text.Trim() != "" && txta.Text.Trim() != "" && txtce.Text.Trim() != "" && txtu.Text.Trim() != "" && txtcl.Text.Trim() != "")
{
Conection.Conectar();
string actualizar = "UPDATE Administradores SET Codigo_administrador=@c, Nombre_administrador=@n, Apellido_administrador=@a, Correo_administrador=@ce, Alias_administrador=@u, Clave_administrador=@cl WHERE Codigo_administrador=@c";
SqlCommand cmd2 = new SqlCommand(actualizar, Conection.Conectar());
cmd2.Parameters.AddWithValue("@c", txtc.Text);
cmd2.Parameters.AddWithValue("@n", txtn.Text);
cmd2.Parameters.AddWithValue("@a", txta.Text);
cmd2.Parameters.AddWithValue("@ce", txtce.Text);
cmd2.Parameters.AddWithValue("@u", txtu.Text);
cmd2.Parameters.AddWithValue("@cl", txtcl.Text);
cmd2.ExecuteNonQuery();
MessageBox.Show("Registro modificdo", "HECHO", MessageBoxButtons.OK, MessageBoxIcon.Information);
limpiar();
dgv.DataSource = llenar_grid();
}
else
{
MessageBox.Show("Campos Vacios", "ERROR", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
catch (Exception error)
{
MessageBox.Show("Algo salio mal", "ERROR", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
private void PictureBox2_Click(object sender, EventArgs e)
{
try
{
if (txtc.Text.Trim() != "" && txtn.Text.Trim() != "" && cmb1.Text.Trim() != "" && cmb2.Text.Trim() != "")
{
Conection.Conectar();
string actualizar = "UPDATE Grados SET Codigo_grado=@c, Nombre_grado=@n, Codigo_maestro=@m, Carnet=@a WHERE Codigo_grado=@c";
SqlCommand cmd2 = new SqlCommand(actualizar, Conection.Conectar());
cmd2.Parameters.AddWithValue("@c", txtc.Text);
cmd2.Parameters.AddWithValue("@n", txtn.Text);
cmd2.Parameters.AddWithValue("@m", cmb1.Text);
cmd2.Parameters.AddWithValue("@a", cmb2.Text);
cmd2.ExecuteNonQuery();
MessageBox.Show("Registro modificdo", "HECHO", MessageBoxButtons.OK, MessageBoxIcon.Information);
limpiar();
dgv.DataSource = llenar_grid();
}
else
{
MessageBox.Show("Campos Vacios", "ERROR", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
catch (Exception error)
{
MessageBox.Show("Algo salio mal", "ERROR", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
private void PictureBox1_Click(object sender, EventArgs e)
{
try
{
if (txtc.Text.Trim() != "" && txtn.Text.Trim() != "" && txta.Text.Trim() != "" && dtp.Text.Trim() != "")
{
Conection.Conectar();
string insertar = "INSERT INTO Alumnos(Carnet, Nombre_alumno, Apellido_alumno, Fecha_nacimineto) VALUES (@c, @n, @a, @f)";
SqlCommand cmd1 = new SqlCommand(insertar, Conection.Conectar());
cmd1.Parameters.AddWithValue("@c", txtc.Text);
cmd1.Parameters.AddWithValue("@n", txtn.Text);
cmd1.Parameters.AddWithValue("@a", txta.Text);
cmd1.Parameters.Add(new SqlParameter("@f", SqlDbType.Date));
cmd1.Parameters["@f"].Value = dtp.Text;
cmd1.ExecuteNonQuery();
MessageBox.Show("Registro agregado", "HECHO", MessageBoxButtons.OK, MessageBoxIcon.Information);
limpiar();
dgv.DataSource = llenar_grid();
}
else
{
MessageBox.Show("Campos Vacios", "ERROR", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
catch (Exception error)
{
MessageBox.Show("Algo salio mal", "ERROR", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
private void PictureBox2_Click(object sender, EventArgs e)
{
try
{
if (txtc.Text.Trim() != "" && txtn.Text.Trim() != "" && txta.Text.Trim() != "" && dtp.Text.Trim() != "")
{
Conection.Conectar();
string actualizar = "UPDATE Alumnos SET Carnet=@c, Nombre_alumno=@n, Apellido_alumno=@a, Fecha_nacimineto=@f WHERE Carnet=@c";
SqlCommand cmd2 = new SqlCommand(actualizar, Conection.Conectar());
cmd2.Parameters.AddWithValue("@c", txtc.Text);
cmd2.Parameters.AddWithValue("@n", txtn.Text);
cmd2.Parameters.AddWithValue("@a", txta.Text);
cmd2.Parameters.Add(new SqlParameter("@f", SqlDbType.Date));
cmd2.Parameters["@f"].Value = dtp.Text;
cmd2.ExecuteNonQuery();
MessageBox.Show("Registro modificdo", "HECHO", MessageBoxButtons.OK, MessageBoxIcon.Information);
limpiar();
dgv.DataSource = llenar_grid();
}
else
{
MessageBox.Show("Campos Vacios", "ERROR", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
catch (Exception error)
{
MessageBox.Show("Algo salio mal", "ERROR", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
private void PictureBox1_Click(object sender, EventArgs e)
{
try
{
if (txtc.Text.Trim() != "" && dtp.Text.Trim() != "" && cmb1.Text.Trim() != "" && cmb3.Text.Trim() != "" && cmb4.Text.Trim() != "")
{
Conection.Conectar();
string insertar = "INSERT INTO Asistencias(Codigo_asistencia, Fecha_asistencia, Codigo_grado, Carnet, Control_asistencia) VALUES (@c, @f, @g, @a, @ca)";
SqlCommand cmd1 = new SqlCommand(insertar, Conection.Conectar());
cmd1.Parameters.AddWithValue("@c", txtc.Text);
cmd1.Parameters.Add(new SqlParameter("@f", SqlDbType.Date));
cmd1.Parameters["@f"].Value = dtp.Text;
cmd1.Parameters.AddWithValue("@g", cmb1.Text);
cmd1.Parameters.AddWithValue("@a", cmb3.Text);
cmd1.Parameters.AddWithValue("@ca", cmb4.Text);
cmd1.ExecuteNonQuery();
MessageBox.Show("Registro agregado", "HECHO", MessageBoxButtons.OK, MessageBoxIcon.Information);
limpiar();
dgv.DataSource = llenar_grid();
}
else
{
MessageBox.Show("Campos Vacios", "ERROR", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
catch (Exception error)
{
MessageBox.Show("Algo salio mal", "ERROR", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
private void PictureBox2_Click(object sender, EventArgs e)
{
try
{
if (txtc.Text.Trim() != "" && dtp.Text.Trim() != "" && cmb1.Text.Trim() != "" && cmb3.Text.Trim() != "" && cmb4.Text.Trim() != "")
{
Conection.Conectar();
string actualizar = "UPDATE Asistencias SET Codigo_asistencia=@c, Fecha_asistencia=@f, Codigo_grado=@g, Carnet=@a, Control_asistencia=@ca WHERE Codigo_asistencia=@c";
SqlCommand cmd2 = new SqlCommand(actualizar, Conection.Conectar());
cmd2.Parameters.AddWithValue("@c", txtc.Text);
cmd2.Parameters.Add(new SqlParameter("@f", SqlDbType.Date));
cmd2.Parameters["@f"].Value = dtp.Text;
cmd2.Parameters.AddWithValue("@g", cmb1.Text);
cmd2.Parameters.AddWithValue("@a", cmb3.Text);
cmd2.Parameters.AddWithValue("@ca", cmb4.Text);
cmd2.ExecuteNonQuery();
MessageBox.Show("Registro modificdo", "HECHO", MessageBoxButtons.OK, MessageBoxIcon.Information);
limpiar();
dgv.DataSource = llenar_grid();
}
else
{
MessageBox.Show("Campos Vacios", "ERROR", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
catch (Exception error)
{
MessageBox.Show("Algo salio mal", "ERROR", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
public DataTable llenar_grid()
{
Conection.Conectar();
DataTable dt = new DataTable();
string Consulta = "SELECT * FROM Administradores";
SqlCommand cmd = new SqlCommand(Consulta, Conection.Conectar());
SqlDataAdapter da = new SqlDataAdapter(cmd);
da.Fill(dt);
return(dt);
}
private void PictureBox1_Click(object sender, EventArgs e)
{
try
{
if (txtc.Text.Trim() != "" && txtn.Text.Trim() != "" && txta.Text.Trim() != "" && txtce.Text.Trim() != "" && txtu.Text.Trim() != "" && txtcl.Text.Trim() != "")
{
if (email_bien_escrito(txtce.Text))
{
Conection.Conectar();
string insertar = "INSERT INTO Administradores(Codigo_administrador, Nombre_administrador, Apellido_administrador, Correo_administrador, Alias_administrador, Clave_administrador) VALUES (@c, @n, @a, @ce, @u, @cl)";
SqlCommand cmd1 = new SqlCommand(insertar, Conection.Conectar());
cmd1.Parameters.AddWithValue("@c", txtc.Text);
cmd1.Parameters.AddWithValue("@n", txtn.Text);
cmd1.Parameters.AddWithValue("@a", txta.Text);
cmd1.Parameters.AddWithValue("@ce", txtce.Text);
cmd1.Parameters.AddWithValue("@u", txtu.Text);
cmd1.Parameters.AddWithValue("@cl", txtcl.Text);
cmd1.ExecuteNonQuery();
MessageBox.Show("Registro agregado", "HECHO", MessageBoxButtons.OK, MessageBoxIcon.Information);
limpiar();
dgv.DataSource = llenar_grid();
}
else
{
MessageBox.Show("Ingrese un correo electronico valido", "ERROR", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
else
{
MessageBox.Show("Campos Vacios", "ERROR", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
catch (Exception error)
{
MessageBox.Show("Algo salio mal", "ERROR", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}