public ActionResult Inserir(CarroUsuario usuario) { try { CadastrarUsuario(usuario); return(RedirectToAction(nameof(Index))); } catch { return(View()); } }
private void CadastrarUsuario(CarroUsuario usuario) { var Conexao = new SqlConnection { ConnectionString = "Server=thanos-web.database.windows.net;user id=andrelivee;pwd=@andre123;Database=Carros" }; Conexao.Open(); using (SqlCommand command = Conexao.CreateCommand()) { command.CommandText = "INSERT INTO cliente (nome, email) VALUES(@param1,@param2)"; command.Parameters.AddWithValue("@param1", usuario.nome); command.Parameters.AddWithValue("@param2", usuario.email); command.ExecuteNonQuery(); } Conexao.Close(); }