public BindingList <HistoriaAcademica> buscar_enHistoriaA(int id_becadoBUSCAR) { BindingList <HistoriaAcademica> lista = new BindingList <HistoriaAcademica>(); String cadena = "server=quilla.lab.inf.pucp.edu.pe;" + "user=inf282g6;" + "database=inf282g6;" + "port=3306;" + "password=Nk2ewy;" + "SslMode=none;"; MySqlConnection con = new MySqlConnection(cadena); MySqlCommand comando = new MySqlCommand(); comando.CommandText = "SELECT * FROM HISTORIA_ACADEMICA;"; comando.Connection = con; con.Open(); MySqlDataReader rs = comando.ExecuteReader(); while (rs.Read()) { int id_becado = rs.GetInt32("ID_BECADO"); if (id_becado == id_becadoBUSCAR) { HistoriaAcademica h = new HistoriaAcademica(); h.Id_historia_academica = rs.GetInt32("ID_HISTORIA_ACADEMICA"); h.Id_becado = id_becado; h.Ciclo = rs.GetString("CICLO"); h.Id_especialidad_actual = rs.GetInt32("ID_ESPECIALIDAD_ACTUAL"); h.Id_facultad_actual = rs.GetInt32("ID_FACULTAD_ACTUAL"); h.Ultimo_ciclom = rs.GetString("ULTIMO_CICLOM"); h.Craest = rs.GetDouble("CRAEST"); h.Orden = rs.GetDouble("ORDEN"); h.Ncm = rs.GetInt32("NCM"); h.Etapa = rs.GetString("ETAPA"); h.Crpe = rs.GetDouble("CRPE"); h.Ncur_msr = rs.GetInt32("NCUR_MSR"); h.Ncur_r = rs.GetInt32("NCUR_R"); h.Ncre_msr = rs.GetDouble("NCRE_MSR"); h.Ncre_mr = rs.GetDouble("NCRE_MR"); h.Ncre_1 = rs.GetDouble("NCRE_1"); h.Ncre_2 = rs.GetDouble("NCRE_2"); h.Ncre_3 = rs.GetDouble("NCRE_3"); h.Ncre_4 = rs.GetDouble("NCRE_4"); h.Cahn = rs.GetDouble("CAHN"); h.Tcac = rs.GetDouble("TCAC"); h.Cdh = rs.GetDouble("CDH"); h.Cur = rs.GetDouble("CUR"); h.Cac = rs.GetDouble("CAC"); h.Cr = rs.GetDouble("CR"); h.Cah_exi = rs.GetDouble("CAH_EXI"); h.Cah_exo = rs.GetDouble("CAH_EXO"); h.Cah_con = rs.GetDouble("CAH_CON"); h.Ncre_rh = rs.GetDouble("NCRE_RH"); lista.Add(h); } } con.Close(); return(lista); }
public void actualizar_enHistoriaA(HistoriaAcademica h) { String cadena = "server=quilla.lab.inf.pucp.edu.pe;" + "user=inf282g6;" + "database=inf282g6;" + "port=3306;" + "password=Nk2ewy;" + "SslMode=none;"; MySqlConnection con = new MySqlConnection(cadena); MySqlCommand comando = new MySqlCommand(); comando.CommandType = System.Data.CommandType.StoredProcedure; comando.CommandText = "F_ACTUALIZAR_HISTORIA"; comando.Parameters.Add("_id_historia", MySqlDbType.Int32).Value = h.Id_historia_academica; comando.Parameters.Add("_ciclo", MySqlDbType.VarChar).Value = h.Ciclo; comando.Parameters.Add("_id_especialidad_actual", MySqlDbType.Int32).Value = h.Id_especialidad_actual; comando.Parameters.Add("_id_facultad_actual", MySqlDbType.Int32).Value = h.Id_facultad_actual; comando.Parameters.Add("_ultimo_ciclom", MySqlDbType.VarChar).Value = h.Ultimo_ciclom; comando.Parameters.Add("_craest", MySqlDbType.Double).Value = h.Craest; comando.Parameters.Add("_orden", MySqlDbType.Double).Value = h.Orden; comando.Parameters.Add("_ncm", MySqlDbType.Int32).Value = h.Ncm; comando.Parameters.Add("_etapa", MySqlDbType.VarChar).Value = h.Etapa; comando.Parameters.Add("_crpe", MySqlDbType.Double).Value = h.Crpe; comando.Parameters.Add("_ncur_msr", MySqlDbType.Int32).Value = h.Ncur_msr; comando.Parameters.Add("_ncur_r", MySqlDbType.Int32).Value = h.Ncur_r; comando.Parameters.Add("_ncre_msr", MySqlDbType.Double).Value = h.Ncre_msr; comando.Parameters.Add("_ncre_mr", MySqlDbType.Double).Value = h.Ncre_mr; comando.Parameters.Add("_ncre_1", MySqlDbType.Double).Value = h.Ncre_1; comando.Parameters.Add("_ncre_2", MySqlDbType.Double).Value = h.Ncre_2; comando.Parameters.Add("_ncre_3", MySqlDbType.Double).Value = h.Ncre_3; comando.Parameters.Add("_ncre_4", MySqlDbType.Double).Value = h.Ncre_4; comando.Parameters.Add("_cahn", MySqlDbType.Double).Value = h.Cahn; comando.Parameters.Add("_tcac", MySqlDbType.Double).Value = h.Tcac; comando.Parameters.Add("_cdh", MySqlDbType.Double).Value = h.Cdh; comando.Parameters.Add("_cur", MySqlDbType.Double).Value = h.Cur; comando.Parameters.Add("_cac", MySqlDbType.Double).Value = h.Cac; comando.Parameters.Add("_cr", MySqlDbType.Double).Value = h.Cr; comando.Parameters.Add("_cah_exi", MySqlDbType.Double).Value = h.Cah_exi; comando.Parameters.Add("_cah_exo", MySqlDbType.Double).Value = h.Cah_exo; comando.Parameters.Add("_cah_con", MySqlDbType.Double).Value = h.Cah_con; comando.Parameters.Add("_ncre_rh", MySqlDbType.Double).Value = h.Ncre_rh; comando.Connection = con; con.Open(); comando.ExecuteNonQuery(); con.Close(); }
public void actualizarHistoriaAcademica(HistoriaAcademica h) { accesoDatos.actualizar_enHistoriaA(h); }
private void btnGuardar_Click(object sender, EventArgs e) { if (validar()) { HistoriaAcademica h = new HistoriaAcademica(); if (flag_elementoEditar == 1) { h.Id_historia_academica = Int32.Parse(tbox_id_historia_academica.Text); } h.Id_becado = id_becado; h.Ciclo = cbox_ciclo_nuevo1.Text + "-" + cbox_ciclo_nuevo2.Text; h.Ultimo_ciclom = cbox_ultimociclo1.Text + "-" + cbox_ultimociclo2.Text; h.Id_especialidad_actual = ((Especialidad)cbox_especialidad.SelectedItem).Id_especialidad; h.Id_facultad_actual = ((Especialidad)cbox_especialidad.SelectedItem).Facultad.Id_facultad; h.Craest = Double.Parse(tbox_craest.Text, CultureInfo.InvariantCulture); h.Orden = Double.Parse(tbox_ordenmerito.Text, CultureInfo.InvariantCulture); h.Ncm = Int32.Parse(tbox_nciclos.Text); h.Etapa = cbox_etapa.Text; h.Crpe = Double.Parse(tbox_creditosrestantes.Text, CultureInfo.InvariantCulture); h.Ncur_msr = Int32.Parse(tbox_ncursosSR.Text); h.Ncur_r = Int32.Parse(tbox_ncursosR.Text); h.Ncre_msr = Double.Parse(tbox_creditosSR.Text, CultureInfo.InvariantCulture); h.Ncre_mr = Double.Parse(tbox_creditosR.Text, CultureInfo.InvariantCulture); h.Ncre_1 = Double.Parse(tbox_ncreditos1.Text, CultureInfo.InvariantCulture); h.Ncre_2 = Double.Parse(tbox_ncreditos2.Text, CultureInfo.InvariantCulture); h.Ncre_3 = Double.Parse(tbox_ncreditos3.Text, CultureInfo.InvariantCulture); h.Ncre_4 = Double.Parse(tbox_ncreditos4.Text, CultureInfo.InvariantCulture); h.Cahn = Double.Parse(tbox_cahn.Text, CultureInfo.InvariantCulture); h.Tcac = Double.Parse(tbox_tcac.Text, CultureInfo.InvariantCulture); h.Cdh = Double.Parse(tbox_cdh.Text, CultureInfo.InvariantCulture); h.Cur = Double.Parse(tbox_cur.Text, CultureInfo.InvariantCulture); h.Cac = Double.Parse(tbox_cac.Text, CultureInfo.InvariantCulture); h.Cr = Double.Parse(tbox_cr.Text, CultureInfo.InvariantCulture); h.Cah_exi = Double.Parse(tbox_cah_exi.Text, CultureInfo.InvariantCulture); h.Cah_exo = Double.Parse(tbox_cah_exo.Text, CultureInfo.InvariantCulture); h.Cah_con = Double.Parse(tbox_cah_con.Text, CultureInfo.InvariantCulture); h.Ncre_rh = Double.Parse(tbox_ncre_rh.Text, CultureInfo.InvariantCulture); estadoComponentes(Estado.Deshabilitado); if (flag_elementoNuevo == 1) { flag_elementoNuevo = 0; logicaNegoHistoria.registrarHistoriaAcademica(h); MessageBox.Show("Se ha registrado un nuevo alumno con éxito", "Mensaje", MessageBoxButtons.OK, MessageBoxIcon.Information); } if (flag_elementoEditar == 1) { flag_elementoEditar = 0; logicaNegoHistoria.actualizarHistoriaAcademica(h); MessageBox.Show("Se ha actualizado con éxito", "Mensaje", MessageBoxButtons.OK, MessageBoxIcon.Information); } //se listará los ciclos nuevamente con la informacion actualizada logicaNegoHistoria = new HistoriaAcademicaBL(); BindingList <HistoriaAcademica> listaCiclo = logicaNegoHistoria.buscarHistoriaAcademica(id_becado); cbox_ciclo.DataSource = listaCiclo; cbox_ciclo.Sorted = false; btnGuardar.Enabled = false; } }
public void registrarHistoriaAcademica(HistoriaAcademica h) { accesoDatos.registrar_enHistoriaA(h); }