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));
}
