تمرین جلسه 83(صفحه بندی)

var count = (from s in database select s).Count();
int DataPerPage = 8;
int TotalPages = count / DataPerPage;
Console.WriteLine(count);
Console.WriteLine($"Total Pages: {TotalPages}");
Console.WriteLine($"Please enter page number (1 to {TotalPages})");
int SelectedPage = int.Parse(Console.ReadLine());

//8          8         8
//          50-8 =42
//42

if (SelectedPage ==1)
{
    var Take = (from s in database select s).Take(DataPerPage);
    foreach (var item in Take)
    {
        Console.WriteLine($"Id:{item.Id} - Name:{item.Name} - Family:{item.Family} - Age:{item.Age}");
    }
}
else
{
    
    var skip = (from s in database select s).Skip(DataPerPage*(SelectedPage-1));
    var WhatToShow = (from d in skip select d).Take(DataPerPage);
    foreach (var item in WhatToShow)
    {
        Console.WriteLine($"Id:{item.Id} - Name:{item.Name} - Family:{item.Family} - Age:{item.Age}");
    }
}