liqo

using Students.BLL;
using Students.Modal;
using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
using System.Windows.Forms;

namespace Students
{
public partial class Frm_07 : Form
{
StudentBLL studentBLL = new StudentBLL();
List studentModalList = null;
public Frm_07()
{
InitializeComponent();
studentModalList = studentBLL.FindStudentsAll();

    }

    private void btn_Query_Click(object sender, EventArgs e)
    {
        var queryList = (from stu in studentModalList
                         where stu.Sname == txt_QuereyName.Text.Trim()
                         select stu).ToList();
        dgv.DataSource = queryList;
    }

    private void btn_All_Click(object sender, EventArgs e)
    {
        var queryList = (from stu in studentModalList
                         select stu).ToList();
        dgv.DataSource = queryList;
    }

    private void button1_Click(object sender, EventArgs e)
    {
        var queryList = (from stu in studentModalList
                         where stu.Sname == txt_QuereyName.Text.Trim() && stu.Sage == int.Parse(txt_QueryAge.Text.Trim())
                         select stu).ToList();
        dgv.DataSource = queryList;
    }


    private void btn_Query3_Click(object sender, EventArgs e)
    {
        int index = txt_QueryAge.Text.Trim().Length > 0 ? int.Parse(txt_QueryAge.Text.Trim()) : 0;
        var queryList = (from stu in studentModalList
                         where stu.Sname.Equals(txt_QuereyName.Text.Trim())
                        || stu.Sage == index
                         select stu).ToList();
        dgv.DataSource = queryList;
    }

    private void button2_Click(object sender, EventArgs e)
    {
        var queryList = (from stu in studentModalList
                         where stu.Sname.Contains(txt_QuereyName.Text.Trim())
                         select stu).ToList();
        dgv.DataSource = queryList;
    }

    private void btn_QueryOrderBy_Click(object sender, EventArgs e)
    {
        var queryList = (from stu in studentModalList
                         where stu.Sname.Contains(txt_QuereyName.Text.Trim())
                         orderby stu.Sname descending
                         select stu).ToList();
        dgv.DataSource = queryList;
    }

    private void btn_QueryGropBy_Click(object sender, EventArgs e)
    {
        var queryList = (from stu in studentModalList
                         group stu by stu.Sage).ToList();
        dgv.DataSource = queryList;
    }

    private void btn_Max_Click(object sender, EventArgs e)
    {
        //var queryList = studentModalList.Max(x => x.Sage);
        var queryList = (from stu in studentModalList
                         orderby stu.Sname descending
                         select stu).Take(1).ToList();
        dgv.DataSource = queryList;
    }

    private void btn_Avg_Click(object sender, EventArgs e)
    {
        var queryList = studentModalList.Average(x => x.Sage);
    }

    private void btn_Sum_Click(object sender, EventArgs e)
    {
        var queryList = studentModalList.Sum(x => x.Sage);
    }

    int page = 1;

    private void linkLabel1_LinkClicked(object sender, LinkLabelLinkClickedEventArgs e)
    {
        page = 1;
        var pageList = (from stu in studentModalList
                        orderby stu.Sname descending
                        select stu).Skip((page - 1) * 5)
        .ToList().Take(5).ToList();
        dgv.DataSource = pageList;
    }
    private void linkLabel2_LinkClicked(object sender, LinkLabelLinkClickedEventArgs e)
    {
        page = page - 1 > 1 ? page - 1 : 1;
        var pageList = (from stu in studentModalList
                        orderby stu.Sname descending
                        select stu).Skip((page - 1) * 5)
      .ToList().Take(5).ToList();
        dgv.DataSource = pageList;
    }
    private void linkLabel3_LinkClicked(object sender, LinkLabelLinkClickedEventArgs e)
    {
        int maxpage = studentModalList.Count() % 5 == 0 ? studentModalList.Count() / 5 :
            (studentModalList.Count() / 5) + 1;
        page = page + 1 < maxpage ? page - +1 : maxpage;
        var pageList = (from stu in studentModalList
                        orderby stu.Sname descending
                        select stu).Skip((page - 1) * 5)
      .ToList().Take(5).ToList();
        dgv.DataSource = pageList;
    }

    private void linkLabel4_LinkClicked(object sender, LinkLabelLinkClickedEventArgs e)
    {
        page = studentModalList.Count() % 5 == 0 ? studentModalList.Count() / 5 : (studentModalList.Count() / 5) + 1;
        var pageList = (from stu in studentModalList
                        orderby stu.Sname descending
                        select stu).Skip((page - 1) * 5)
    .ToList().Take(5).ToList();
        dgv.DataSource = pageList;
    }

    private void btn_DataTable_Click(object sender, EventArgs e)
    {

        dgv.DataSource = studentBLL.FindStudentsAllDataTable(new StudentModal()
        {
            Sname = txt_QuereyName.Text.Trim()
        });
    }
}

}