private void PictureBox2_Click(object sender, EventArgs e)
{
if (txtc.Text.Trim() != "" && dtp.Text.Trim() != "" && txtg.Text.Trim() != "" && txta.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", txtg.Text);
cmd2.Parameters.AddWithValue("@a", txta.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);
}
}
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);
}
}
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() != "")
{
if (email_bien_escrito(txtce.Text))
{
Conection.Conectar();
string actualizar = "UPDATE Maestros SET Codigo_maestro=@c, Nombre_maestro=@n, Apellido_maestro=@a, Correo_maestro=@ce, Alias_maestro=@u, Clave_maestro=@cl WHERE Codigo_maestro=@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("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);
}
}
