public static ShowDTO AsShowDTO(this TopAnime show)
{
return(new ShowDTO
{
Id = show.mal_id,
Title = show.title,
Media_type = show.type,
Description = "To be implemented",
Release_date = show.start_date,
Image_url = show.image_url
});
}
public void LoadLists()
{
using (var _connection = new SqlConnection(Global.WaifString))
{
_connection.Open();
var sCmd = "SELECT TOP 10 Id, Name, Image, Popularity FROM {0} {1} ORDER BY Popularity DESC ";
using (var cmd = new SqlCommand(String.Format(sCmd, "Waifu", " WHERE Confirmed = N'1'"), _connection))
{
using (var rd = cmd.ExecuteReader())
{
while (rd.Read())
{
TopWaifu.Add(new WaifuLight(rd));
}
}
}
using (var cmd = new SqlCommand(String.Format(sCmd, "Anime", ""), _connection))
{
using (var rd = cmd.ExecuteReader())
{
while (rd.Read())
{
TopAnime.Add(new AnimeLight(rd));
}
}
}
using (var cmd = new SqlCommand("SELECT TOP 6 Id, Name, Image, Popularity FROM Waifu WHERE Confirmed=N'1' ORDER BY Newid()", _connection))
{
using (var rd = cmd.ExecuteReader())
{
while (rd.Read())
{
RandomWaifu.Add(new WaifuLight(rd));
}
}
}
using (var cmd = new SqlCommand("SELECT TOP 10 Id, Title, Date FROM News ORDER BY Id DESC", _connection))
{
using (var rd = cmd.ExecuteReader())
{
while (rd.Read())
{
var temp = new NewsFull(rd);
temp.Date = temp.Date.Remove(temp.Date.LastIndexOf('.'));
TopNews.Add(temp);
}
}
}
}
}
private async Task <IEnumerable <TopAnime> > CallAnime()
{
string uri = "https://api.jikan.moe/v3/top/anime/0/airing";
HttpResponseMessage response = await _httpClient.GetAsync(uri);
var content = await response.Content.ReadAsStringAsync();
IList <JToken> results = JObject.Parse(content)["top"].Children().ToList(); //Parses content, gets the "top" list and converts to list.
IList <TopAnime> topAnimes = new List <TopAnime>();
for (int animeCount = 0; animeCount < 10; animeCount++)
{
TopAnime topAnime = results[animeCount].ToObject <TopAnime>();
topAnimes.Add(topAnime);
}
return(topAnimes);
}
