public async Task <IActionResult> Edit(int id, [Bind("LinguasId,Lingua,Coral,Leitura,Poral,Ioral,Escrita")] Linguas linguas) { if (id != linguas.LinguasId) { return(NotFound()); } if (ModelState.IsValid) { try { _context.Update(linguas); await _context.SaveChangesAsync(); } catch (DbUpdateConcurrencyException) { if (!LinguasExists(linguas.LinguasId)) { return(NotFound()); } else { throw; } } return(RedirectToAction(nameof(Index))); } return(View(linguas)); }
private void GetLinguas(string nrAluno) { string str = ConfigurationManager.ConnectionStrings["connectionString"].ConnectionString; SqlConnection conn = new SqlConnection(str); string query = "SELECT [Lingua],[Nivel] FROM [LPA].[dbo].[Linguas] WHERE Linguas.nrAluno = " + nrAluno; SqlCommand cmd = new SqlCommand(query, conn); conn.Open(); SqlDataReader dr = cmd.ExecuteReader(); while (dr.Read()) { try { Linguas novaLingua = new Linguas(); novaLingua.lingua = Convert.ToString(dr.GetValue(0)); novaLingua.nivel = Convert.ToString(dr.GetValue(1)); listaLinguas.Add(novaLingua); } catch (Exception ex) { throw ex; } } conn.Close(); }
public async Task <IActionResult> Create([Bind("LinguasId,Lingua,Coral,Leitura,Poral,Ioral,Escrita")] Linguas linguas) { if (ModelState.IsValid) { _context.Add(linguas); await _context.SaveChangesAsync(); return(RedirectToAction(nameof(Index))); } return(View(linguas)); }