public static string ExportOldestBooks(BookShopContext context, DateTime date) { var oldestBooks = context.Books .Where(b => b.PublishedOn < date && b.Genre == (Genre)3) .Select(b => new ExportBookDto { Name = b.Name, Date = b.PublishedOn.ToString("d", CultureInfo.InvariantCulture), Pages = b.Pages }) .OrderByDescending(b => b.Pages) .ThenByDescending(b => b.Date) .Take(10) .ToArray(); string res = XmlConverter.Serialize(oldestBooks, "Books"); return(res); }
public static string ExportOldestBooks(BookShopContext context, DateTime date) { var data = context.Books .Where(b => b.PublishedOn < date && b.Genre == Genre.Science) .OrderByDescending(b => b.Pages) .ThenByDescending(b => b.PublishedOn) .Select(b => new BookXmlExportModel { Pages = b.Pages, Name = b.Name, Date = b.PublishedOn.ToString("d", CultureInfo.InvariantCulture) }) .Take(10) .ToArray(); string xml = XmlConverter.Serialize(data, "Books"); return(xml); }
public static string ExportOldestBooks(BookShopContext context, DateTime date) { var targetBooks = context.Books .AsEnumerable() .Where(x => x.PublishedOn < date && x.Genre.ToString().ToLower() == "science") .Select(x => new ExportBookDTO { Pages = x.Pages, Name = x.Name, Date = x.PublishedOn.ToString("MM/dd/yyyy") }) .OrderByDescending(x => x.Pages) .ThenByDescending(x => DateTime.Parse(x.Date)) .Take(10) .ToList(); var resultXml = XmlConverter.Serialize(targetBooks, "Books"); return(resultXml); }
public static string ExportOldestBooks(BookShopContext context, DateTime date) { var books = context.Books.ToList() .Where(x => x.PublishedOn < date && x.Genre.ToString() == "Science") .Select(x => new BookExportXmlModel { Pages = x.Pages, Name = x.Name, Date = x.PublishedOn.ToString("d", CultureInfo.InvariantCulture) }) .OrderByDescending(x => x.Pages) .ThenByDescending(x => x.Date) .Take(10) .ToList(); string root = "Books"; var result = XmlConverter.Serialize(books, root); return(result.ToString().TrimEnd()); }
public static string ExportOldestBooks(BookShopContext context, DateTime date) { var books = context.Books .ToArray() .Where(x => x.PublishedOn < date && x.Genre == Genre.Science) .OrderByDescending(o => o.Pages) .ThenByDescending(o => o.PublishedOn) .Select(x => new ExportBookDto { Name = x.Name, Date = x.PublishedOn.ToString("d", CultureInfo.InvariantCulture), Pages = x.Pages }) .Take(10) .ToArray(); string xml = XmlConverter.Serialize(books, "Books"); return(xml); }
public static string ExportOldestBooks(BookShopContext context, DateTime date) { var books = context.Books.Where(x => x.PublishedOn < date && x.Genre == Genre.Science) .ToList() .OrderByDescending(x => x.Pages) .ThenByDescending(x => x.PublishedOn) .Select(x => new BooksXmlOutputDto { Pages = x.Pages.ToString(), Name = x.Name, Date = x.PublishedOn.ToString("d", CultureInfo.InvariantCulture), }).ToList() .Take(10) .ToList(); var result = XmlConverter.Serialize(books, "Books"); return(result); }
public static string ExportOldestBooks(BookShopContext context, DateTime date) { var sortedBooks = context .Books .ToList() .Where(b => b.PublishedOn < date && b.Genre.ToString() == "Science") .OrderByDescending(b => b.Pages) .ThenBy(b => b.PublishedOn) .Select(b => new OldestBooksExportModel() { Name = b.Name, Date = b.PublishedOn.ToString("MM/dd/yyyy", CultureInfo.InvariantCulture), Pages = b.Pages.ToString() }) .Take(10) .ToList(); var jsonResult = XmlConverter.Serialize(sortedBooks, "Books"); return(jsonResult); }
public static string ExportOldestBooks(BookShopContext context, DateTime date) { var books = context.Books .ToArray() .Where(b => b.PublishedOn <= date && b.Genre == Data.Models.Enums.Genre.Science) .Select(b => new ExportBookDTO { Pages = b.Pages, Name = b.Name, Date = b.PublishedOn.ToString("MM/dd/yyyy"), }) .OrderByDescending(b => b.Pages) .ThenByDescending(b => b.Date) .Take(10) .ToList(); var root = "Books"; var xml = XmlConverter.Serialize(books, root); return(xml); }