Can I Use Two Orderby Condition Together

  private int TypeValue(string type){
    switch(type.ToLower()){
       case "bird":
         return 0;
       case "flower":
         return 1;
       case "animal":
         return 2;
       case "vegitable":
         return 3;
       default:
         return 100;
    }
}
....
  list = list.OrderBy(i=>TypeValue(i.type)).ThenBy(i=>i.newId);

//paging

  list = list.skip(pageIndex * pageSize).take(pageSize);

  DataTable dt= new DataTable();


foreach (DataRow row in DT.Rows){
    row("CalculatedColumnName") = TypeValue(row.type);
} 
  DataView dv = new DataView(dt);


  dv.Sort = "CalculatedColumnName, newIdASC";
  
  //paging
  var paging = dv.AsEnumerable().skip(pageIndex * pageSize).take(pageSize)

   Select *,
    case type
      when 'bird' then 0
      when 'flower' then 1
      when 'animal' then 2
      when 'vegitable' then 3
    end as TypeSort

 from list
   order by 
    case type 
      when 'bird' then 0
      when 'flower' then 1
      when 'animal' then 2
      when 'vegitable' then 3
    end
-- Yes you do have to type it out again (without the name), unless you use common table expressions (cte) but this is simpler
, newId

Sql
<pre lang="SQL">
with firstCTE as ( -- just to get the data and sort column
   Select *,
    case type
      when 'bird' then 0
      when 'flower' then 1
      when 'animal' then 2
      when 'vegitable' then 3
    end as TypeSort
 from list
),
secondCTE as ( -- to set up the RowNumber
   select * , 
   ROW_NUMBER() OVER (ORDER BY TypeSort, newId) AS RowNumber
   -- this will give the items a RowNumber in order of the sort
   from firstCTE 
)
select * from secondCTE
where RowNumber >= (@PageStart * @PageSize) AND RowNumber < ((@PageStart+1) * @PageSize)
order by RowNumber

--This is very inexpensive as the cte's are like views and won't select any data until the last 'select'

    var sortbyVat= function(a, b){
        a= a.VatRate;
        b= b.VatRate;
        if(a== b) return 0;
        return a> b? 1:-1;
    }
    var sortbyPriceAndVat= function(a, b){
        a= a.Price;
        b= b.Price;
        if(a== b) return sortbyVat(a,b);
        return a> b? 1:-1;
    }

...

    array.sort(sortbyPriceAndVat);