q͗jdWttv/Հwj[Il^/<D|2Qf7INFc;:2fhc`|&iÄEȔwY9T6"&,bN:K kI}fCb( ǗpFì~󺎦CPQ7x@\pPSU+sb20xV=[-,o7ͯ z,N4+ykaqfͫG_/&$Mm(s%@!~~&^9SrbLN{t{EJӿ](x0mL.+pcoYW<#)@G(' X wܜ*ݰ*Ja%흻^1+9.2 >..'L'n" ݎ@+Y2x^?!>{ 5] i)oům%Ł@>8c˜7g#jQ >.E;waoEc 7Ԡƈx><`/s 5;[@6ڨy?!z4fU#5s^v0?N//A`jќeؓ&H7M+TKESjc8? DT% <Ŝ0?N//A`j p&N."I9.jlo ?.Rz 5M?:NJζ)!%Y N|Y݇oCtmO?&֙HQϮJaΥ$|3qf2ZM$!+wX+ ֲ<|REp%Sg- 55摉{NԐLŁ;VCXȶҝ;'RJgH& Eىs=S*F/YfX \p`o=uv7E6[le`GYvQ5xƇ02@I\9XȾAŤ/6kÁb05X? b!F}]! rot&ftmqcJ Y 1(FLIx!jZO&{J*<. Er7USuHeaS2R9T7 D妬N?s(+&P;iJȊ}]!m|I5 *e`SczPlg4=Jg2<_U&`F[K @gp] hZ緾/5؃JP%{^2yh6<}7d 7βޖF M ` IJ->ǻ*RX+JJ? >FԊWW1fd|=Tf;Y܃w6;nSx㜋9X >R!2yC`yiAE6cWϧV!/)ߠ?UH% Du]1T-pLvEr m8-Q䙿̀")A3}4םa)- ycF۹TǁρFq@b :L5oP7zNMM<E'eU(Q&nߨa Йeyd)`˔1Hojvma3g~Xm\@7=~NrP)樱~~dot YߛaivjZ) x7:>9qp8I82V`yAl BOOnO@=u瘮eVQ S,,I5SZ0ɚ2;y\'4,_VwTpahEw0LN(wdEG-Ϝ7(hKskNfoVrO!͏T ke;1Ni$!^iǽ1xa8p ϰx ' Gh #1ZNABΖR#JCF37L1RQQj3:bI q/,А[`ׄ~SAOs7fh/۷'rc~Ȱ5 KoHʐr٣9a膭Mnb&D|L߳A4r6|l,dsMeKR_SvFSei yL++IesH *]c|%O\'PXG]h Ulin'[_QisMK.&`Am|C2T0ZE w-!͆ƂQէ x 20;V0J u3 9DO*A:VSuDNHT9^֠#&ksyXj'ԛ8AZap]ƖN7&ģSϑʗz{r %\ &u\F]>Zű`w-ǰ286G¢oR$6s1xK~: y׍ {nv`ֵt 册zn2>` McRI Ъu+ TEs 7"b[.q젒һZMg5uVx ;Ѹ 0;1dZVȽ yj'˾+8 V4 TEs 7"b[.qI|#'22d֥ ZAWLQG0)j@~\|[PZVȽ yj'˾+8 V4pBҌ$I')W?(\av ޠs| ]oNQ[|$I5{a6Dm KJD[46^QO(-y>Zh KD1)?17Ž|ǀ?++[Qa<:Կx^$n99CnrlrT"ܵڻ=s-)F* !ljHxFr^ VEEaTSz4: IQ 5 R&Yf!K,o?AOϪ~,qhυ9U܇CzC@@LQ82R˶'6[y\iB r"F]H"QV:ѿҊ*m*9~ cD8G܈0+'YB(]Ȣm2 ]RS6HOrbObyljHxFr^ VEEaTSz4: IQ 5Eni22V8g #C}tW]. < Yc];M? 1˘@.:= VEEaTSz4: IQ 5Eni22rYJЯ6ss%/ ۔02y4s*CisOI/G0)j@~\|[PVpL>#L.v1Y oޓ vW?amYsoR鴭̬GJN:9l>re|GG]:ZVȽ yj'~//HOϪ~qAї㊎Xc# ]ev gJ 9 {nv`ֵt 册zn2>MŮj#B:.q+[(T(ei 0Eȁ/8H88le z}^g(JQgRr(this.BuildQuery(query)); var employees = (from employee in dbResult select new { employee.FirstName, employee.LastName, employee.EmployeeID, employee.BirthDate, employee.HireDate, employee.ManagerID, employee.Title, employee.City, employee.Country, employee.Address }); var total = dbResult.Count(); if (sortorder != null && sortorder != "") { if (sortorder == "asc") { employees = employees.OrderBy(o => o.GetType().GetProperty(sortdatafield).GetValue(o, null)); } else { employees = employees.OrderByDescending(o => o.GetType().GetProperty(sortdatafield).GetValue(o, null)); } } employees = employees.Skip(pagesize * pagenum).Take(pagesize); var result = new { TotalRows = total, Rows = employees }; return Json(result, JsonRequestBehavior.AllowGet); } protected override void Dispose(bool disposing) { if (disposing) { db.Dispose(); } base.Dispose(disposing); } } }