Exemple #1
0
        public void comprobar_calif2()
        {
            if (comboBox2.SelectedItem != null)
            {
                //MessageBox.Show("" + f + "");
                // OBTENGO CLAVE MATERIA
                comando = new MySqlCommand(string.Format("select clave_materia from materia where (nombre_materia = '" + comboBox2.SelectedItem + "' and grado_grupo = '" + comboBox1.SelectedItem + "');"), Conexion.conectar());
                MySqlDataReader read = comando.ExecuteReader(); read.Read();
                clave_mat = read[0].ToString();//clave materia
                // MessageBox.Show("" + clave_mat + "");
                read.Close();

                //VERIFICO SI LA CLAVE MATERIA CON LA CURP CORRESPONDIENTE ESTÁ DENTRO DE LA TABLA CALIFICACIONES
                comando = new MySqlCommand(string.Format("select calif_materia from calificacion where(curp_alumno = '" + curp.Trim() + "' and mes_calificacion = '" + cb_periodo.SelectedItem + "' and clave_materia ='" + clave_mat.Trim() + "');"), Conexion.conectar());
                read    = comando.ExecuteReader();
                while (read.Read())
                {
                    a++;
                }
                if (a > 0)
                {
                    read.Close();
                    MessageBox.Show("ALUMNO YA CUENTA CON CALIFICACIÓN EN PERIODO SELECCIONADO DE ESTA MATERIA", "SELECCIONE OTRA MATERIA", MessageBoxButtons.OK, MessageBoxIcon.Error);
                    a = 0;
                    c = comboBox2.SelectedIndex;
                }
                else
                {
                    //HABILITA LOS CONTROLS PARA INGRESAR LA CALIFICACION Y GUARDAR
                    comboBox2.Enabled  = false;
                    cb_entero.Enabled  = true;
                    cb_decimal.Enabled = true;
                    GUARDAR.Enabled    = true;
                    f = -1;
                }
            }
        }
Exemple #2
0
        public void comprobar_calif()
        {
            int seleccion_cbperiodo = cb_periodo.SelectedIndex - 1;

            //OBTENGO CURP
            comando = new MySqlCommand(string.Format("select * from alumno where (nombre_alumno = '" + tb_nombre.Text + "' and ap_pat_alumno = '" + tb_apP.Text + "' and ap_mat_alumno = '" + tb_apM.Text + "');"), Conexion.conectar());
            MySqlDataReader read = comando.ExecuteReader(); read.Read();

            curp = read[0].ToString();//obtengo curp
            read.Close();
            //OBTENGO LAS VECES QUE ESTÁ REGISTRADO DENTRO DE LA TABLA CALIFICACIONES, SI ES = A EL # DE MATERIAS, YA COMPLETO SU REGISTRO
            comando     = new MySqlCommand(string.Format("select count(curp_alumno) from calificacion where (curp_alumno = '" + curp + "' and mes_calificacion = '" + cb_periodo.SelectedItem + "' );"), Conexion.conectar());
            read        = comando.ExecuteReader(); read.Read();
            veces_regis = read[0].ToString();//verifico cuantas veces está registrado
            //MessageBox.Show("" + materias_exis + "cantidad de materia", "" + veces_regis + "veces registrado");
            aux2 = Convert.ToDouble(veces_regis);
            read.Close();
            //OBTENGO LAS VECES QUE ESTÁ REGISTRADO DENTRO DE LA TABLA CALIFICACIONES, SI ES = A EL # DE MATERIAS, YA COMPLETO SU REGISTRO EN EL MES ANTERIOR DEL SELECCIONADO
            if (cb_periodo.SelectedIndex != 0)
            {
                comando          = new MySqlCommand(string.Format("select count(curp_alumno) from calificacion where (curp_alumno = '" + curp + "' and mes_calificacion = '" + cb_periodo.Items[cb_periodo.SelectedIndex - 1] + "' );"), Conexion.conectar());
                read             = comando.ExecuteReader(); read.Read();
                veces_regis_ante = read[0].ToString();//verifico cuantas veces está registrado del mes pasado
                aux3             = Convert.ToDouble(veces_regis_ante);
                //  MessageBox.Show("" + aux3 + "", ""+materias_exis+ "cantidad de veces registrado en periodo anterior");
                read.Close();
            }



            if (materias_exis == aux2)
            {
                MessageBox.Show("ALUMNO YA COMPLETO TODOS SUS REGISTROS EN EL PERIODO SELECCIONADO");
                d         = cb_periodo.SelectedIndex;
                respuesta = true;
                if (MessageBox.Show("¿DESEA REGISTRAR EN OTRO PERIODO?", "", MessageBoxButtons.YesNo, MessageBoxIcon.Question) == DialogResult.Yes)
                {
                    cb_periodo.Enabled = true;
                }
                else
                {
                    LIMPIAR_REI();
                }
            }
            else
            {
                if (cb_periodo.SelectedIndex == 1)
                {
                    if (materias_exis_sep == aux3)
                    {
                        f = 1;
                        comboBox2.Enabled  = true;
                        cb_periodo.Enabled = false;
                    }
                    else
                    {
                        MessageBox.Show("ALUMNO NO HA COMPLETADO TODOS SUS REGISTROS EN EL PERIODO ANTERIOR");
                        d         = cb_periodo.SelectedIndex;
                        respuesta = true;
                        if (MessageBox.Show("¿DESEA REGISTRAR EN OTRO PERIODO?", "", MessageBoxButtons.YesNo, MessageBoxIcon.Question) == DialogResult.Yes)
                        {
                            cb_periodo.Enabled = true;
                        }
                        else
                        {
                            LIMPIAR_REI();
                        }
                    }
                }
                else
                {
                    if (cb_periodo.SelectedIndex != 0 && cb_periodo.SelectedIndex != 1)
                    {
                        if (materias_exis == aux3)
                        {
                            f = 1;
                            comboBox2.Enabled  = true;
                            cb_periodo.Enabled = false;
                        }
                        else
                        {
                            MessageBox.Show("ALUMNO NO HA COMPLETADO TODOS SUS REGISTROS EN EL PERIODO ANTERIOR");
                            d         = cb_periodo.SelectedIndex;
                            respuesta = true;
                            if (MessageBox.Show("¿DESEA REGISTRAR EN OTRO PERIODO?", "", MessageBoxButtons.YesNo, MessageBoxIcon.Question) == DialogResult.Yes)
                            {
                                cb_periodo.Enabled = true;
                            }
                            else
                            {
                                LIMPIAR_REI();
                            }
                        }
                    }
                    else
                    {
                        f = 1;
                        comboBox2.Enabled  = true;
                        cb_periodo.Enabled = false;
                    }
                }
            }
        }
Exemple #3
0
        }//COMBOBOX DE MATERIAS

        private void GUARDAR_Click(object sender, EventArgs e)
        {
            if (c == comboBox2.SelectedIndex)
            {
                MessageBox.Show("CAMBIE A OTRA MATERIA");
            }
            else
            {
                aux   = cb_entero.SelectedItem.ToString() + "." + cb_decimal.SelectedItem.ToString(); //CONCATENO LA CALIFICACION
                calif = Convert.ToDouble(aux);
                // MessageBox.Show("" + calif + "");
                try
                {
                    comando = new MySqlCommand(String.Format("INSERT INTO calificacion (calif_materia,mes_calificacion,clave_materia,curp_alumno) values ('{0}','{1}','{2}','{3}')", calif, cb_periodo.SelectedItem, clave_mat.Trim(), curp), Conexion.conectar());
                    comando.ExecuteNonQuery();

                    /*comboBox2.SelectedItem = null;
                     * cb_periodo.SelectedItem = null;*/
                    MessageBox.Show("REGISTRADO CON EXITO", "REGISTRADO", MessageBoxButtons.OK, MessageBoxIcon.Information);

                    //BUSQUEDA SI EL ALUMNO YA CUMPLIO CON TODAS SUS CALIFICACIONES REGISTRADAS
                    comando = new MySqlCommand(string.Format("select count(curp_alumno) from calificacion where (curp_alumno = '" + curp + "' and mes_calificacion = '" + cb_periodo.SelectedItem + "' );"), Conexion.conectar());
                    MySqlDataReader read = comando.ExecuteReader(); read.Read();
                    veces_regis = read[0].ToString();//verifico cuantas veces está registrado
                    // MessageBox.Show("" + materias_exis + "", "" + veces_regis + "");
                    aux2 = Convert.ToDouble(veces_regis);
                    read.Close();
                    if (materias_exis == aux2)
                    {
                        MessageBox.Show("ALUMNO YA COMPLETO TODOS SUS REGISTROS EN EL PERIODO SELECCIONADO");
                        LIMPIAR_REI();
                    }
                    else
                    {
                        if (MessageBox.Show("¿DESEA SEGUIR CALIFICANDO ALUMNO?", "", MessageBoxButtons.YesNo, MessageBoxIcon.Question) == DialogResult.Yes)
                        {
                            f = -1;//variable para que hasta que se seleccione un elemento de las materias se compruebe si ya tiene una calificacion seleccionada
                            //habilita los controles para seguir calificando
                            comboBox2.SelectedItem   = null;
                            comboBox2.Enabled        = true;
                            cb_entero.Enabled        = false;
                            cb_decimal.Enabled       = false;
                            cb_decimal.SelectedIndex = 0;
                            cb_entero.SelectedIndex  = 0;
                            cb_decimal.Enabled       = false;
                        }
                        else
                        {
                            LIMPIAR_REI();
                        }
                    }
                }
                catch (Exception)
                {
                    MessageBox.Show("ERROR AL REGISTRAR CALIFICACIÓN", "ERROR", MessageBoxButtons.OK, MessageBoxIcon.Error);
                }
            }
        }
Exemple #4
0
        public static string obtenermes(string crp)
        {
            int concurrencia = 0;

            string[] meses = new string[] { "Diag", "Sept", "Octu", "Novi", "Dici", "Ener", "Febr", "Marz", "Abri", "Mayo", "Juni" };
            for (int i = 0; i < 11; i++)
            {
                MySqlCommand consulta = new MySqlCommand(string.Format("SELECT COUNT(*) from calificacion where mes_calificacion='{0}' and curp_alumno='{1}';", meses[i], crp), Conexion.conectar());
                concurrencia = Convert.ToInt16(consulta.ExecuteScalar());
                if (concurrencia == 0)
                {
                    return(meses[i]);
                }
            }
            return("1");
        }
Exemple #5
0
        private void comboBox1_SelectedIndexChanged(object sender, EventArgs e)
        {
            comboBox2.SelectedIndex = -1;
            comboBox2.Items.Clear();

            MySqlDataAdapter grupo = new MySqlDataAdapter("Select curp_alumno,ap_pat_alumno,ap_mat_alumno,nombre_alumno from alumno where grado_grupo='" + comboBox1.SelectedItem.ToString() + "';", Conexion.conectar());
            DataTable        tabla = new DataTable();

            grupo.Fill(tabla);
            dataGridView1.DataSource = tabla;
        }
Exemple #6
0
        private void pictureBox1_Click(object sender, EventArgs e)
        {
            try
            {
                if (comboBox1.SelectedItem.ToString() == "3" && comboBox2.SelectedItem.ToString() != "Diag")
                {
                    ciclo = 12; calificaciones[0] = Cb_Val1_ent.SelectedItem.ToString() + "." + CB_Val1_dec.SelectedItem.ToString(); calificaciones[1] = Cb_Val2_ent.SelectedItem.ToString() + "." + CB_Val2_dec.SelectedItem.ToString(); calificaciones[2] = Cb_Val3_ent.SelectedItem.ToString() + "." + CB_Val3_dec.SelectedItem.ToString(); calificaciones[3] = Cb_Val4_ent.SelectedItem.ToString() + "." + CB_Val4_dec.SelectedItem.ToString(); calificaciones[4] = Cb_Val5_ent.SelectedItem.ToString() + "." + CB_Val5_dec.SelectedItem.ToString(); calificaciones[5] = Cb_Val6_ent.SelectedItem.ToString() + "." + CB_Val6_dec.SelectedItem.ToString(); calificaciones[6] = Cb_Val7_ent.SelectedItem.ToString() + "." + CB_Val7_dec.SelectedItem.ToString(); calificaciones[7] = Cb_Val8_ent.SelectedItem.ToString() + "." + CB_Val8_dec.SelectedItem.ToString(); calificaciones[8] = Cb_Val9_ent.SelectedItem.ToString() + "." + CB_Val9_dec.SelectedItem.ToString(); calificaciones[9] = Cb_Val10_ent.SelectedItem.ToString() + "." + CB_Val10_dec.SelectedItem.ToString(); calificaciones[10] = Cb_Val11_ent.SelectedItem.ToString() + "." + CB_Val11_dec.SelectedItem.ToString(); calificaciones[11] = Cb_Val12_ent.SelectedItem.ToString() + "." + CB_Val12_dec.SelectedItem.ToString();
                }
                if (comboBox1.SelectedItem.ToString() == "3" && comboBox2.SelectedItem.ToString() == "Diag")
                {
                    ciclo = 7; calificaciones[0] = Cb_Val1_ent.SelectedItem.ToString() + "." + CB_Val1_dec.SelectedItem.ToString(); calificaciones[1] = Cb_Val2_ent.SelectedItem.ToString() + "." + CB_Val2_dec.SelectedItem.ToString(); calificaciones[2] = Cb_Val3_ent.SelectedItem.ToString() + "." + CB_Val3_dec.SelectedItem.ToString(); calificaciones[3] = Cb_Val4_ent.SelectedItem.ToString() + "." + CB_Val4_dec.SelectedItem.ToString(); calificaciones[4] = Cb_Val5_ent.SelectedItem.ToString() + "." + CB_Val5_dec.SelectedItem.ToString(); calificaciones[5] = Cb_Val6_ent.SelectedItem.ToString() + "." + CB_Val6_dec.SelectedItem.ToString(); calificaciones[6] = Cb_Val7_ent.SelectedItem.ToString() + "." + CB_Val7_dec.SelectedItem.ToString();
                }
                if ((comboBox1.SelectedItem.ToString() == "1" || comboBox1.SelectedItem.ToString() == "2") && comboBox2.SelectedItem.ToString() != "Diag")
                {
                    ciclo = 11; calificaciones[0] = Cb_Val1_ent.SelectedItem.ToString() + "." + CB_Val1_dec.SelectedItem.ToString(); calificaciones[1] = Cb_Val2_ent.SelectedItem.ToString() + "." + CB_Val2_dec.SelectedItem.ToString(); calificaciones[2] = Cb_Val3_ent.SelectedItem.ToString() + "." + CB_Val3_dec.SelectedItem.ToString(); calificaciones[3] = Cb_Val4_ent.SelectedItem.ToString() + "." + CB_Val4_dec.SelectedItem.ToString(); calificaciones[4] = Cb_Val5_ent.SelectedItem.ToString() + "." + CB_Val5_dec.SelectedItem.ToString(); calificaciones[5] = Cb_Val6_ent.SelectedItem.ToString() + "." + CB_Val6_dec.SelectedItem.ToString(); calificaciones[6] = Cb_Val7_ent.SelectedItem.ToString() + "." + CB_Val7_dec.SelectedItem.ToString(); calificaciones[7] = Cb_Val8_ent.SelectedItem.ToString() + "." + CB_Val8_dec.SelectedItem.ToString(); calificaciones[8] = Cb_Val9_ent.SelectedItem.ToString() + "." + CB_Val9_dec.SelectedItem.ToString(); calificaciones[9] = Cb_Val10_ent.SelectedItem.ToString() + "." + CB_Val10_dec.SelectedItem.ToString(); calificaciones[10] = Cb_Val11_ent.SelectedItem.ToString() + "." + CB_Val11_dec.SelectedItem.ToString();
                }
                if ((comboBox1.SelectedItem.ToString() == "1" || comboBox1.SelectedItem.ToString() == "2") && comboBox2.SelectedItem.ToString() == "Diag")
                {
                    ciclo = 6; calificaciones[0] = Cb_Val1_ent.SelectedItem.ToString() + "." + CB_Val1_dec.SelectedItem.ToString(); calificaciones[1] = Cb_Val2_ent.SelectedItem.ToString() + "." + CB_Val2_dec.SelectedItem.ToString(); calificaciones[2] = Cb_Val3_ent.SelectedItem.ToString() + "." + CB_Val3_dec.SelectedItem.ToString(); calificaciones[3] = Cb_Val4_ent.SelectedItem.ToString() + "." + CB_Val4_dec.SelectedItem.ToString(); calificaciones[4] = Cb_Val5_ent.SelectedItem.ToString() + "." + CB_Val5_dec.SelectedItem.ToString(); calificaciones[5] = Cb_Val6_ent.SelectedItem.ToString() + "." + CB_Val6_dec.SelectedItem.ToString();
                }
                if ((comboBox1.SelectedItem.ToString() == "4" || comboBox1.SelectedItem.ToString() == "5" || comboBox1.SelectedItem.ToString() == "6") && comboBox2.SelectedItem.ToString() == "Diag")
                {
                    ciclo = 8; calificaciones[0] = Cb_Val1_ent.SelectedItem.ToString() + "." + CB_Val1_dec.SelectedItem.ToString(); calificaciones[1] = Cb_Val2_ent.SelectedItem.ToString() + "." + CB_Val2_dec.SelectedItem.ToString(); calificaciones[2] = Cb_Val3_ent.SelectedItem.ToString() + "." + CB_Val3_dec.SelectedItem.ToString(); calificaciones[3] = Cb_Val4_ent.SelectedItem.ToString() + "." + CB_Val4_dec.SelectedItem.ToString(); calificaciones[4] = Cb_Val5_ent.SelectedItem.ToString() + "." + CB_Val5_dec.SelectedItem.ToString(); calificaciones[5] = Cb_Val6_ent.SelectedItem.ToString() + "." + CB_Val6_dec.SelectedItem.ToString(); calificaciones[6] = Cb_Val7_ent.SelectedItem.ToString() + "." + CB_Val7_dec.SelectedItem.ToString(); calificaciones[7] = Cb_Val8_ent.SelectedItem.ToString() + "." + CB_Val8_dec.SelectedItem.ToString();
                }
                if ((comboBox1.SelectedItem.ToString() == "4" || comboBox1.SelectedItem.ToString() == "5" || comboBox1.SelectedItem.ToString() == "6") && comboBox2.SelectedItem.ToString() != "Diag")
                {
                    ciclo = 13; calificaciones[0] = Cb_Val1_ent.SelectedItem.ToString() + "." + CB_Val1_dec.SelectedItem.ToString(); calificaciones[1] = Cb_Val2_ent.SelectedItem.ToString() + "." + CB_Val2_dec.SelectedItem.ToString(); calificaciones[2] = Cb_Val3_ent.SelectedItem.ToString() + "." + CB_Val3_dec.SelectedItem.ToString(); calificaciones[3] = Cb_Val4_ent.SelectedItem.ToString() + "." + CB_Val4_dec.SelectedItem.ToString(); calificaciones[4] = Cb_Val5_ent.SelectedItem.ToString() + "." + CB_Val5_dec.SelectedItem.ToString(); calificaciones[5] = Cb_Val6_ent.SelectedItem.ToString() + "." + CB_Val6_dec.SelectedItem.ToString(); calificaciones[6] = Cb_Val7_ent.SelectedItem.ToString() + "." + CB_Val7_dec.SelectedItem.ToString(); calificaciones[7] = Cb_Val8_ent.SelectedItem.ToString() + "." + CB_Val8_dec.SelectedItem.ToString(); calificaciones[8] = Cb_Val9_ent.SelectedItem.ToString() + "." + CB_Val9_dec.SelectedItem.ToString(); calificaciones[9] = Cb_Val10_ent.SelectedItem.ToString() + "." + CB_Val10_dec.SelectedItem.ToString(); calificaciones[10] = Cb_Val11_ent.SelectedItem.ToString() + "." + CB_Val11_dec.SelectedItem.ToString(); calificaciones[11] = Cb_Val12_ent.SelectedItem.ToString() + "." + CB_Val12_dec.SelectedItem.ToString(); calificaciones[12] = Cb_Val13_ent.SelectedItem.ToString() + "." + CB_Val13_dec.SelectedItem.ToString();
                }
                if (comboBox1.SelectedItem.ToString() == "1")
                {
                    m[0] = "EDA-1-SEP"; m[1] = "EDF-1-SEP"; m[2] = "ENS-1-SEP"; m[3] = "ESP-1-SEP"; m[4] = "FCE-1-SEP"; m[5] = "MAT-1-SEP"; m[6] = "CLE-1-EXT"; m[7] = "DIS-1-EXT"; m[8] = "PUN-1-EXT"; m[9] = "TAR-1-EXT"; m[10] = "UYA-1-EXT";
                }
                else if (comboBox1.SelectedItem.ToString() == "2")
                {
                    m[0] = "EDA-2-SEP"; m[1] = "EDF-2-SEP"; m[2] = "ENS-2-SEP"; m[3] = "ESP-2-SEP"; m[4] = "FCE-2-SEP"; m[5] = "MAT-2-SEP"; m[6] = "DIS-2-EXT"; m[7] = "ORT-2-EXT"; m[8] = "PAR-2-EXT"; m[9] = "TAR-2-EXT"; m[10] = "UYA-2-EXT";
                }

                else if (comboBox1.SelectedItem.ToString() == "3")
                {
                    m[0] = "CIN-3-SEP"; m[1] = "EDA-3-SEP"; m[2] = "EDF-3-SEP"; m[3] = "EDV-3-SEP"; m[4] = "ESP-3-SEP"; m[5] = "FCE-3-SEP"; m[6] = "MAT-3-SEP"; m[7] = "CLE-3-EXT"; m[8] = "DIS-3-EXT"; m[9] = "ORT-3-EXT"; m[10] = "TAR-3-EXT"; m[11] = "UYA-3-EXT";
                }

                else if (comboBox1.SelectedItem.ToString() == "4")
                {
                    m[0] = "CIN-4-SEP"; m[1] = "EDA-4-SEP"; m[2] = "EDF-4-SEP"; m[3] = "ESP-4-SEP"; m[4] = "FCE-4-SEP"; m[5] = "GEO-4-SEP"; m[6] = "HIS-4-SEP"; m[7] = "MAT-4-SEP"; m[8] = "CLE-4-EXT"; m[9] = "DIS-4-EXT"; m[10] = "ORT-4-EXT"; m[11] = "PAR-4-EXT"; m[12] = "TAR-4-EXT";
                }

                else if (comboBox1.SelectedItem.ToString() == "5")
                {
                    m[0] = "CIN-5-SEP"; m[1] = "EDA-5-SEP"; m[2] = "EDF-5-SEP"; m[3] = "ESP-5-SEP"; m[4] = "FCE-5-SEP"; m[5] = "GEO-5-SEP"; m[6] = "HIS-5-SEP"; m[7] = "MAT-5-SEP"; m[8] = "CLE-5-EXT"; m[9] = "ORT-5-EXT"; m[10] = "PAR-5-EXT"; m[11] = "TAR-5-EXT"; m[12] = "TRA-5-EXT";
                }

                else if (comboBox1.SelectedItem.ToString() == "6")
                {
                    m[0] = "CIN-6-SEP"; m[1] = "EDA-6-SEP"; m[2] = "EDF-6-SEP"; m[3] = "ESP-6-SEP"; m[4] = "FCE-6-SEP"; m[5] = "GEO-6-SEP"; m[6] = "HIS-6-SEP"; m[7] = "MAT-6-SEP"; m[8] = "CLE-6-EXT"; m[9] = "ORT-6-EXT"; m[10] = "PAR-6-EXT"; m[11] = "TAR-6-EXT"; m[12] = "UYA-6-EXT";
                }



                MySqlCommand    nombre = new MySqlCommand(string.Format("select ap_pat_alumno,ap_mat_alumno,nombre_alumno from alumno where curp_alumno='{0}';", curp), Conexion.conectar());
                MySqlDataReader le = nombre.ExecuteReader();
                string          ap = "", am = "", nom = "";
                while (le.Read())
                {
                    ap  = le.GetString(0);
                    am  = le.GetString(1);
                    nom = le.GetString(2);
                }
                le.Close();
                dat = ap + " " + am + " " + nom;
                for (int i = 0; i < ciclo; i++)
                {
                    MySqlCommand com = new MySqlCommand(string.Format("insert into calificacion values('{0}','{1}','{2}','{3}');", calificaciones[i], mesact, m[i], curp), Conexion.conectar());
                    com.ExecuteNonQuery();
                    Conexion.cerrar();
                }

                mm    = comboBox2.SelectedItem.ToString();
                grado = comboBox1.SelectedItem.ToString();

                if (mm == "Diag")
                {
                    pr = 0;
                }
                if (mm == "Sept")
                {
                    pr = 1;
                }
                if (mm == "Octu")
                {
                    pr = 2;
                }
                if (mm == "Novi")
                {
                    pr = 3;
                }
                if (mm == "Dici")
                {
                    pr = 4;
                }
                if (mm == "Ener")
                {
                    pr = 5;
                }
                if (mm == "Febr")
                {
                    pr = 6;
                }
                if (mm == "Marz")
                {
                    pr = 7;
                }
                if (mm == "Abri")
                {
                    pr = 8;
                }
                if (mm == "Mayo")
                {
                    pr = 9;
                }
                if (mm == "Juni")
                {
                    pr = 10;
                }

                calif.pdf1ro();
                comboBox2.Items.Clear();
                mesact = obtenermes(curp);
                if (mesact == "1")
                {
                    MessageBox.Show("El alumno ya ha sido evaluado en su totalidad", "Evaluación completa", MessageBoxButtons.OK, MessageBoxIcon.Information);
                    comboBox2.Items.Add("FINALIZADO");
                    comboBox2.SelectedIndex = 0;
                }
                else
                {
                    comboBox2.Items.Add(mesact);
                    comboBox2.SelectedIndex = 0;
                }
                System.Diagnostics.Process proc = new System.Diagnostics.Process();
                proc.StartInfo.FileName = boletas.nuevo;
                proc.Start();
                proc.Close();
                limpiar();
            }
            catch (Exception)
            {
                MessageBox.Show("Ha ocurrido un Error", "Error", MessageBoxButtons.OK, MessageBoxIcon.Exclamation);
            }
        }