public List <RepositorioModel> IntegrarAPIGitHub()
{
List <RepositorioModel> repositorio = new List <RepositorioModel>();
using (var client = new HttpClient())
{
client.DefaultRequestHeaders.UserAgent.TryParseAdd("request");
HttpResponseMessage response = client.GetAsync("https://api.github.com/orgs/takenet/repos").Result;
response.EnsureSuccessStatusCode();
string conteudo = response.Content.ReadAsStringAsync().Result;
dynamic resultado = JsonConvert.DeserializeObject(conteudo);
foreach (var item in resultado)
{
RepositorioModel repos = new RepositorioModel();
repos.NomeCompleto = item.full_name;
repos.DescricaoRepositorio = item.description;
repos.Imagem = item.owner.avatar_url;
repos.DataCriacao = item.created_at;
repos.linguagemRepositorio = item.language.ToString();
repositorio.Add(repos);
}
return(repositorio.Where(b => b.linguagemRepositorio.Equals("C#")).OrderBy(a => a.DataCriacao).Take(5).ToList());
}
}
private void treeView1_AfterSelect(object sender, TreeViewEventArgs e)
{
var nodeSelecionado = treeView1.SelectedNode;
//Se o nó clicado for um subnó, nada acontece
if (nodeSelecionado.Level == 1)
{
return;
}
RepositorioModel repositorio = ListaDeRepositorios.Find(repo => repo.Nome == nodeSelecionado.Text);
labelNomeRepositorio.Text = repositorio.Nome;
linkRepositorioURL.Text = repositorio.Url;
labelDescricao.Text = repositorio.Descricao;
}
public void InserirFavorito(RepositorioModel model)
{
try
{
using (SqlConnection conn = new SqlConnection())
{
conn.ConnectionString = connectionString;
using (SqlCommand cmd = new SqlCommand())
{
cmd.Connection = conn;
cmd.CommandType = CommandType.Text;
cmd.CommandText = @"INSERT INTO TbFavoritos
(id
,name
,full_name
,html_url
,description
,forks_url
,watchers_count
,updated_at
,default_branch)
VALUES
(@param1,@param2,@param3,@param4,@param5,@param6,@param7,@param8,@param9)";
cmd.Parameters.AddWithValue("@param1", model.id);
cmd.Parameters.AddWithValue("@param2", model.name);
cmd.Parameters.AddWithValue("@param3", model.full_name);
cmd.Parameters.AddWithValue("@param4", model.html_url);
cmd.Parameters.AddWithValue("@param5", model.description);
cmd.Parameters.AddWithValue("@param6", model.forks_url);
cmd.Parameters.AddWithValue("@param7", model.watchers_count);
cmd.Parameters.AddWithValue("@param8", model.updated_at);
cmd.Parameters.AddWithValue("@param9", model.default_branch);
try
{
conn.Open();
cmd.ExecuteNonQuery();
}
catch (Exception ex) { }
}
}
}
catch (Exception ex) { }
}
