Combination query and paging of LinQ and combination query page of LinQ

Combination query and paging of LinQ and combination query page of LinQ

 

1. StartPublic List <Car> Select1 (string) {

Return con. Car. Where (r => r. Name. StartsWith (a). ToList ();
}

 

2. Search by end

Public List <Car> Select2 (string)

{
Return con. Car. Where (r => r. Name. EndsWith (a). ToList ();
}

 

3. Maximum Value

Public string Max ()

{
Return con. Car. Max (r => r. Price). ToString ();
}

 

4. Minimum value

Public string Min ()

{
Return con. Car. Min (r => r. Price). ToString ();
}

 

5. Sum

 

Public string Sum ()
{
Return con. Car. Sum (r => r. Price). ToString ();
}

 

6. Average Value

Public string avg ()
{
Return con. Car. Average (r => r. Price). ToString ();
}

7. ascending

 

Public List <Car> ss ()
{
Return con. Car. OrderBy (r => r. Price). ToList ();
}

 

8. Descending Order

 

Public List <Car> s ()
{
Return con. Car. OrderByDescending (r => r. Price). ToList ();
}

9. Combined paging Query

 

    public List<Car> Selecta(int d, string a, string b, string c)    {        List<Car> list = new List<Car>();        list = con.Car.ToList();     if (a != "")        {            List<Car> list1 = con.Car.Where(r => r.Code.Contains(a)).ToList();            list = list.Intersect(list1).ToList();        }        if (b != "")        {            List<Car> list1 = con.Car.Where(r => r.Name.Contains(b)).ToList();            list = list.Intersect(list1).ToList();        }        if (c != "")        {            List<Car> list1 = con.Car.Where(r => r.Brand.Contains(c)).ToList();            list = list.Intersect(list1).ToList();        }        return list.Skip((d-1-1) * PageCount).Take(PageCount).ToList();            }    int PageCount = 6;    public List<Car> start()    {        return con.Car.Skip(0 * PageCount).Take(PageCount).ToList();    }    public List<Car> prev(string a)    {        return con.Car.Skip((Convert.ToInt32(a) - 1 - 1) * PageCount).Take(PageCount).ToList();    }    public List<Car> next(string a)    {        return con.Car.Skip(Convert.ToInt32(a) * PageCount).Take(PageCount).ToList();    }    public List<Car> end()    {        return con.Car.Skip((max() - 1) * PageCount).Take(PageCount).ToList();    }    private int max()    {        int count = new CarData().Select().Count;        double aa = count / (PageCount * 1.0);        return Convert.ToInt32(Math.Ceiling(aa));    }}

Void LinkButton4_Click (object sender, EventArgs e) {Repeater1.DataSource = new CarData (). end (); Repeater1.DataBind (); Label2.Text = max (). toString ();} private int max () {int count = new CarData (). select (). count; double aa = count/(PageCount * 1.0); return Convert. toInt32 (Math. ceiling (aa);} void LinkButton3_Click (object sender, EventArgs e) {if (Convert. toInt32 (Label2.Text) <max () {int a = Convert. toInt32 (Label2.Text) + 1; Repeater1.DataSource = new CarData (). next (Label2.Text); Repeater1.DataBind (); Label2.Text =. toString () ;}else {return ;}} void LinkButton2_Click (object sender, EventArgs e) {if (Convert. toInt32 (Label2.Text)> 1) {int a = Convert. toInt32 (Label2.Text)-1; Repeater1.DataSource = new CarData (). prev (Label2.Text); Repeater1.DataBind (); Label2.Text =. toString () ;}else {return ;}} void linkbutton#click (object sender, EventArgs e) // homepage {Repeater1.DataSource = new CarData (). start (); Repeater1.DataBind (); Label2.Text = "1";} void Button13_Click (object sender, EventArgs e) {Label2.Text = "1"; int a = Convert. toInt32 (Label2.Text) + 1; Repeater1.DataSource = new CarData (). selecta (a, TextBox3.Text, TextBox4.Text, TextBox5.Text); Repeater1.DataBind (); int count = new CarData (). select (). count; Label3.Text = Math. ceiling (Convert. toDouble (count)/PageCount ). toString ();}