Advertisement
StoyanGrigorov

FindLatest10Projects

Feb 25th, 2017
153
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
C# 0.87 KB | None | 0 0
  1.         private static void FindLatest10Projects()
  2.         {
  3.             using (var context = new SoftUniContext())
  4.             {
  5.                 var projects = context.Projects
  6.                     .OrderByDescending(x => x.StartDate)
  7.                     .Take(10)
  8.                     .OrderBy(a => a.Name);
  9.                 string dateFormat = "M/d/yyyy h:mm:ss tt";
  10.                 foreach (Project proj in projects)
  11.                 {
  12.                     string EndDate = string.Empty;
  13.                     if (proj.EndDate.HasValue)
  14.                     {
  15.                         EndDate = proj.EndDate.Value.ToString(dateFormat, CultureInfo.InvariantCulture);
  16.                     }
  17.                     Console.WriteLine($"{proj.Name} {proj.Description} {proj.StartDate.ToString(dateFormat, CultureInfo.InvariantCulture)} {EndDate}");
  18.                 }
  19.             }
  20.         }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement