public async Task <JournalCreateViewModel> GetCreateDataAsync(int hoarderID)
{
var tagList = await tagDbService.GetAllAsync();
var gameList = await gameDbService.GetAllAsync();
var vm = JournalEntryMapper.ToCreateViewModel(hoarderID, tagList, gameList);
return(vm);
}
public async Task <GameIndexViewModel> GetGameIndexAsync(int hoarderID)
{
var games = await gameDbService.GetAllAsync(hoarderID);
var vm = GameMapper.ToIndexViewModel(games);
return(vm);
}
public async Task <string> ConvertGameData()
{
var games = await gameDbService.GetAllAsync();
StringBuilder stringBuilder = new StringBuilder();
stringBuilder.AppendLine("Platform;;Title;;ReleaseDate;;Genres;;Description");
foreach (var game in games)
{
stringBuilder.AppendLine($"{game.Platform.Name};;{game.Title};;{game.ReleaseDate:dd/MM/yyyy};;{game.FullGenres};;{game.Description?.Replace("\r\n\n", "[nn]").Replace("\r\n", "[n]")}");
}
var csv = stringBuilder.ToString();
return(csv);
}
public async Task <string> ConvertGameData()
{
var games = await gameDbService.GetAllAsync();
StringBuilder stringBuilder = new StringBuilder();
stringBuilder.AppendLine("<!DOCTYPE html>");
stringBuilder.AppendLine("<head>");
stringBuilder.AppendLine("<meta charset=\"UTF-8\"/>");
stringBuilder.AppendLine("</head>");
stringBuilder.AppendLine("<html xmlns:v=\"urn:schemas-microsoft-com:vml\" xmlns:o=\"urn:schemas-microsoft-com:office:office\" xmlns:x=\"urn:schemas-microsoft-com:office:excel\" xmlns=\"http://www.w3.org/TR/REC-html40\">");
stringBuilder.AppendLine(" <style>");
stringBuilder.AppendLine(" <!--");
stringBuilder.AppendLine(" br {mso-data-placement:same-cell;}");
stringBuilder.AppendLine(" -->");
stringBuilder.AppendLine(" </style>");
stringBuilder.AppendLine(" <body>");
stringBuilder.AppendLine(" <table>");
stringBuilder.AppendLine(" <tr>");
stringBuilder.AppendLine($" <th>Platform</th>");
stringBuilder.AppendLine($" <th>Title</th>");
stringBuilder.AppendLine($" <th>Release date</th>");
stringBuilder.AppendLine($" <th>Genre(s)</th>");
stringBuilder.AppendLine($" <th>Description</th>");
stringBuilder.AppendLine(" </tr>");
foreach (var game in games)
{
stringBuilder.AppendLine(" <tr>");
stringBuilder.AppendLine($" <td>{game.Platform.Name}</td>");
stringBuilder.AppendLine($" <td>{game.Title}</td>");
stringBuilder.AppendLine($" <td>{game.ReleaseDate:dd/MM/yyyy}</td>");
stringBuilder.AppendLine($" <td>{game.FullGenres}</td>");
stringBuilder.AppendLine($" <td>{game.Description?.Replace("\n", "<br/>")}</td>");
stringBuilder.AppendLine(" </tr>\n");
}
stringBuilder.AppendLine(" </table>");
stringBuilder.AppendLine(" </body>");
stringBuilder.AppendLine("</html>");
var html = stringBuilder.ToString();
return(html);
}