private async Task <Dictionary <int, MalAnime> > SlurpAnimeAsync(CancellationToken cancellationToken)
{
using (NpgsqlConnection conn = new NpgsqlConnection(m_connectionString))
{
Logging.Log.Debug("Connecting to PostgreSQL.");
await conn.OpenAsync(cancellationToken).ConfigureAwait(false);
Logging.Log.Debug("Connected to PostgreSQL.");
Logging.Log.Debug("Slurping anime from the database.");
IList <mal_anime> dbAnimeSlurp = await mal_anime.GetAllAsync(conn, transaction : null, cancellationToken : cancellationToken).ConfigureAwait(false);
Logging.Log.Debug("Processing anime from the database.");
Dictionary <int, MalAnime> animes = new Dictionary <int, MalAnime>(dbAnimeSlurp.Count);
foreach (mal_anime dbAnime in dbAnimeSlurp)
{
MalAnime anime = new MalAnime(
malAnimeId: dbAnime.mal_anime_id,
type: (MalAnimeType)dbAnime.mal_anime_type_id,
title: dbAnime.title
);
animes[dbAnime.mal_anime_id] = anime;
}
Logging.Log.DebugFormat("Done processing {0} anime from the database.", animes.Count);
return(animes);
}
}
public static MalAnime SearchListForShow(string username, string title)
{
// Clean out any accented characters from the show title
var tempBytes = System.Text.Encoding.GetEncoding("ISO-8859-8").GetBytes(title);
title = System.Text.Encoding.UTF8.GetString(tempBytes);
var searchRequest = WebRequest.Create(string.Format(MalListUrl, username)) as HttpWebRequest;
searchRequest.Method = "GET";
var searchResponse = (HttpWebResponse)searchRequest.GetResponse();
string animeList = string.Empty;
using (var reader = new System.IO.StreamReader(searchResponse.GetResponseStream(), ASCIIEncoding.ASCII))
{
// this is XML
animeList = reader.ReadToEnd();
}
var responseAsXml = new XmlDocument();
responseAsXml.LoadXml(animeList);
var responseAsJson = JsonConvert.SerializeXmlNode(responseAsXml.GetElementsByTagName("myanimelist")[0]);
var malList = JsonConvert.DeserializeObject <MyAnimeList>(responseAsJson);
var currentlyWatching = from show in malList.AnimeList.AllAnime
where show.MyStatus == MalStatus.Watching
select show;
MalAnime currentShow = new MalAnime();
try
{
currentShow = (from show in currentlyWatching
where (TitleComparer.Compute(show.Title, title) < 5 || show.Title.ToLower().Contains(title.ToLower()))
select show).First();
}
catch
{
//Usually the title from Plex is the English title and not the default Japanese title. Check the Synonyms.
foreach (var show in currentlyWatching)
{
foreach (var altTitle in show.Synonyms.Replace("; ", ";").ToLower().Split(';'))
{
currentShow = (altTitle.Contains(title.ToLower())) ? show : null;
if (currentShow != null)
{
break;
}
}
if (currentShow != null)
{
break;
}
}
if (currentShow == null)
{
// Last resort, split the show by spaces and try to find a word
try
{
foreach (var word in title.Split(' '))
{
var showByWord = (from show in currentlyWatching
where show.Title.Contains(word)
select show);
if (showByWord.Any())
{
currentShow = showByWord.First();
break;
}
}
}
catch (Exception ex)
{
Logger.CreateLogEntry(LogType.Error, ex, DateTime.Now);
currentShow = null;
}
}
}
if (string.IsNullOrEmpty(currentShow.Title))
{
Logger.CreateLogEntry(LogType.Error, "MAL Search was not successful.", DateTime.Now);
throw new Exception("MAL show was not found successfully.");
}
Logger.CreateLogEntry(LogType.Success, $"MAL API search was successful for {title}. ID: {currentShow.Id} | Total Episodes: {currentShow.Episodes}", DateTime.Now);
return(currentShow);
}
public static bool UpdateList(RegisterValues values, PlexRequest plexRequest)
{
if (!(plexRequest.Account.Title == values.Email))
{
return(false);
}
MalAnime show = SearchListForShow(values.UserName, plexRequest.Metadata.GrandparentTitle);
if (!(show is MalAnime) || string.IsNullOrEmpty(show.Title))
{
Logger.CreateLogEntry(Enumerations.LogType.Error, new ArgumentException("Show was not found through MAL API search or some other error occured."), DateTime.Now);
}
var episodeCompleted = plexRequest.Metadata.Index;
var isFinished = (episodeCompleted == show.Episodes) ? true : false;
if (!ValidateMalCredentials(values.UserName, values.Password))
{
Logger.CreateLogEntry(LogType.Error, "Failed to verify MAL credentials.", DateTime.UtcNow);
return(false);
}
MalAnimeValues add = new MalAnimeValues
{
Episode = show.MyWatchedEpisodes++,
Status = (isFinished) ? (int)Enumerations.MalStatus.Completed : (int)Enumerations.MalStatus.Watching
};
string json = JsonConvert.SerializeObject(add);
XmlDocument doc = JsonConvert.DeserializeXmlNode(json, "entry");
HttpWebRequest updateRequest = WebRequest.Create($"{MalApiBaseUrl}/update/{show.Id}.xml?data={doc.OuterXml}") as HttpWebRequest;
updateRequest.Method = "GET";
updateRequest.Headers["Authorization"] = "Basic " +
Convert.ToBase64String(Encoding.ASCII.GetBytes($"{values.UserName}:{values.Password}"));
updateRequest.ContentType = "application/x-www-form-urlencoded";
bool updated = false;
try
{
HttpWebResponse updateResponse = (HttpWebResponse)updateRequest.GetResponse();
}
catch (Exception ex)
{
Logger.CreateLogEntry(LogType.Error, ex, createdOn: DateTime.Now);
updated = false;
}
Logger.CreateLogEntry(LogType.Success, $"Successfully updated show on {values.UserName}'s list.", DateTime.Now);
updated = true;
if (!updated)
{
Logger.CreateLogEntry(Enumerations.LogType.Error, "Failed to update list with show.", DateTime.Now);
return(updated);
}
else
{
TwilioClient.Init(values.TwilioUserName, values.TwilioPassword);
MessageResource.Create(
to: new Twilio.Types.PhoneNumber(values.UserPhoneNumber),
from: new Twilio.Types.PhoneNumber(values.TwilioPhoneNumber),
body: $"Successfully updated MAL with episode {episodeCompleted} of {show.Title}");
return(updated);
}
}
