public async Task <IActionResult> PutAnimeManga(int id, AnimeManga animeManga)
{
if (id != animeManga.AnimeMangaId)
{
return(BadRequest());
}
_context.Entry(animeManga).State = EntityState.Modified;
try
{
await _context.SaveChangesAsync();
}
catch (DbUpdateConcurrencyException)
{
if (!AnimeMangaExists(id))
{
return(NotFound());
}
else
{
throw;
}
}
return(NoContent());
}
public static List <Tuple <string, string> > GetAnimeMangaDictionary(AnimeManga tempAnimeManga, XmlDocument baseXmlResponse)
{
List <Tuple <string, string> > tempAnimeMangaDictionary = new List <Tuple <string, string> >();
switch (tempAnimeManga)
{
case AnimeManga.Anime:
if (baseXmlResponse["anime"].ChildNodes.Count > 30)
{
return(null);
}
foreach (XmlElement tempEntry in baseXmlResponse["anime"].ChildNodes)
{
tempAnimeMangaDictionary.Add(new Tuple <string, string>(tempEntry["title"].InnerText, tempEntry["image"].InnerText));
}
break;
case AnimeManga.Manga:
if (baseXmlResponse["manga"].ChildNodes.Count > 30)
{
return(null);
}
foreach (XmlElement tempEntry in baseXmlResponse["manga"].ChildNodes)
{
tempAnimeMangaDictionary.Add(new Tuple <string, string>(tempEntry["title"].InnerText, tempEntry["image"].InnerText));
}
break;
}
return(tempAnimeMangaDictionary);
}
public static List <Tuple <string, string> > GetAnimeManga(string tag, AnimeManga tempAnimeManga)
{
string adress = AdressBuilder(tag, tempAnimeManga);
XmlDocument baseXmlResponse = HttpRequester.GetHttpXmlDocument(adress, "HaruhiBot", "HaruhiBot123");
if (baseXmlResponse == null)
{
return(null);
}
return(GetAnimeMangaDictionary(tempAnimeManga, baseXmlResponse));
}
public ActionResult <Helper> PostAnimeMangaExists(Helper helper)
{
//If the anime/manga does not exist, we should add it and link it to the useranimemangatable
//else we should just make a link in the intermediate table
var myAnimeManga = new AnimeManga();
var user = new User();
try {
myAnimeManga = _context.AnimeMangas.FromSqlInterpolated($"SELECT * FROM AnimeMangas WHERE MalCode = {helper.AnimeManga.MalCode}").First();
}
catch (System.Exception e)
{
Console.Write(e);
return(NotFound());
// _context.AnimeMangas.Add(helper.AnimeManga);
// await _context.SaveChangesAsync();
// myAnimeManga = _context.AnimeMangas.FromSqlInterpolated($"SELECT * FROM AnimeMangas WHERE MalCode = {helper.AnimeManga.MalCode}").First();
}
try {
user = _context.Users.FromSqlInterpolated($"SELECT * FROM Users WHERE Email = {helper.Email}").First();
}
catch (System.Exception e)
{
Console.Write(e);
return(NotFound());
}
UserAnimeManga userAnimeManga = new UserAnimeManga();
try
{
userAnimeManga = _context.UserAnimeMangas.FromSqlInterpolated($"SELECT * FROM UserAnimeMangas WHERE UserId = {user.UserId} AND AnimeMangaId = {myAnimeManga.AnimeMangaId}").First();
}
catch (System.Exception e)
{
Console.Write(e);
return(NotFound());
}
return(Ok(userAnimeManga));
}
public static string AdressBuilder(string tag, AnimeManga tempAnimeManga)
{
StringBuilder sb = new StringBuilder();
switch (tempAnimeManga)
{
case AnimeManga.Anime:
sb.Append("http://myanimelist.net/api/anime/search.xml?q=");
break;
case AnimeManga.Manga:
sb.Append("http://myanimelist.net/api/manga/search.xml?q=");
break;
}
sb.Append(tag);
return(sb.ToString());
}
public async Task <ActionResult <UserAnimeManga> > DeleteUserAnimeManga(Helper helper)
{
var myAnimeManga = new AnimeManga();
var user = new User();
try {
myAnimeManga = _context.AnimeMangas.FromSqlInterpolated($"SELECT * FROM AnimeMangas WHERE MalCode = {helper.AnimeManga.MalCode}").First();
}
catch (System.Exception e)
{
Console.Write(e);
return(NotFound());
}
try {
user = _context.Users.FromSqlInterpolated($"SELECT * FROM Users WHERE Email = {helper.Email}").First();
}
catch (System.Exception e)
{
Console.Write(e);
return(NotFound());
}
UserAnimeManga userAnimeManga = new UserAnimeManga();
try
{
userAnimeManga = _context.UserAnimeMangas.FromSqlInterpolated($"SELECT * FROM UserAnimeMangas WHERE UserId = {user.UserId} AND AnimeMangaId = {myAnimeManga.AnimeMangaId}").First();
_context.UserAnimeMangas.Remove(userAnimeManga);
//_context.UserAnimeMangas.FromSqlInterpolated($"DELETE FROM UserAnimeMangas WHERE AnimeMangaId = (SELECT AnimeMangaId FROM AnimeMangas WHERE AnimeMangaId = {myAnimeManga.AnimeMangaId}) AND UserId = (SELECT UserId FROM Users WHERE UserId = {user.UserId})");
await _context.SaveChangesAsync();
}
catch (System.Exception e)
{
Console.Write(e);
return(NotFound());
}
return(Ok(userAnimeManga));
}
internal static List <Tuple <string, string> > GetAnimeManga(List <string> tags, AnimeManga tempAnimeManga)
{
return(GetAnimeManga(tags[0], tempAnimeManga));
}
