예제 #1
0
        protected void Modificar_Click(object sender, EventArgs e)
        {
            using (ModeloFMI contextoBD = new ModeloFMI())
            {
                int modificar = Convert.ToInt32(cmbpais.SelectedValue);

                GestionPrestamos aux = contextoBD.GestionPrestamoes.Where(x => x.idPais == modificar).FirstOrDefault();
                if (aux == null)
                {
                    ScriptManager.RegisterStartupScript(this, this.GetType(), "s1", "alert('El registro no se encontro')", true);
                    return;
                }

                aux.idPais     = Convert.ToInt32(cmbpais.SelectedValue);
                aux.Habitantes = Convert.ToInt32(txtHabitantes.Text);
                aux.idIdioma   = Convert.ToInt32(cmbIdioma.SelectedValue);
                aux.PIB        = Convert.ToDecimal(txtPIB.Text);
                aux.Superficie = Convert.ToInt32(txtSuperficie.Text);
                aux.Prestamo   = Check.Checked;
                aux.Riesgo     = Radio.SelectedItem.Text;


                contextoBD.SaveChanges();
                cargarGrid();
            }
        }
예제 #2
0
        protected void Eliminar_Click(object sender, EventArgs e)
        {
            using (ModeloFMI contextoBD = new ModeloFMI())
            {
                int borrado = Convert.ToInt32(cmbpais.SelectedValue);

                GestionPrestamos aux = contextoBD.GestionPrestamoes.Where(x => x.idPais == borrado).FirstOrDefault();
                if (aux == null)
                {
                    ScriptManager.RegisterStartupScript(this, this.GetType(), "s1", "alert('El registro no se encontro')", true);
                    return;
                }
                contextoBD.GestionPrestamoes.Remove(aux);
                contextoBD.SaveChanges();
                cargarGrid();
            }
        }
예제 #3
0
        protected void Registrar_Click(object sender, EventArgs e)
        {
            using (ModeloFMI contextoBD = new ModeloFMI())
            {
                GestionPrestamos objPrestamo = new GestionPrestamos();
                objPrestamo.idPais     = Convert.ToInt32(cmbpais.SelectedValue);
                objPrestamo.Habitantes = Convert.ToInt32(txtHabitantes.Text);
                objPrestamo.idIdioma   = Convert.ToInt32(cmbIdioma.SelectedValue);
                objPrestamo.PIB        = Convert.ToDecimal(txtPIB.Text);
                objPrestamo.Superficie = Convert.ToInt32(txtSuperficie.Text);
                objPrestamo.Prestamo   = Check.Checked;
                objPrestamo.Riesgo     = Radio.SelectedItem.Text;


                contextoBD.GestionPrestamoes.Add(objPrestamo);
                contextoBD.SaveChanges();     //COMMIT
                cargarGrid();
            }
        }