public static object GetSpotRateByFilter(SessionInfo sessioninfo, string processdate, int jtStartIndex, int jtPageSize, string jtSorting) { try { LookupBusiness _lookupbusiness = new LookupBusiness(); //Get data from database List <MA_SPOT_RATE> SpotRates = _lookupbusiness.GetSpotRateByFilter(sessioninfo, processdate, jtSorting); //var jsonData = (from s in SpotRates // select new // { // ID = s.ID, // CurrencyLabel = s.MA_CURRENCY.LABEL, // Proc_date = s.PROC_DATE, // Rate = s.RATE // }).ToList(); //Return result to jTable return(new { Result = "OK", Records = jtPageSize > 0 ? SpotRates.Skip(jtStartIndex).Take(jtPageSize).ToList() : SpotRates, TotalRecordCount = SpotRates.Count }); } catch (BusinessWorkflowsException bex) { return(new { Result = "ERROR", Message = bex.Message }); } catch (Exception ex) { return(new { Result = "ERROR", Message = ex.Message }); } }
public static object GetSpotRateByFilter(SessionInfo sessioninfo, string processdate, int jtStartIndex, int jtPageSize, string jtSorting) { try { LookupBusiness _lookupbusiness = new LookupBusiness(); //Get data from database List<MA_SPOT_RATE> SpotRates = _lookupbusiness.GetSpotRateByFilter(sessioninfo, processdate, jtSorting); //var jsonData = (from s in SpotRates // select new // { // ID = s.ID, // CurrencyLabel = s.MA_CURRENCY.LABEL, // Proc_date = s.PROC_DATE, // Rate = s.RATE // }).ToList(); //Return result to jTable return new { Result = "OK", Records = jtPageSize > 0 ? SpotRates.Skip(jtStartIndex).Take(jtPageSize).ToList() : SpotRates, TotalRecordCount = SpotRates.Count }; } catch (BusinessWorkflowsException bex) { return new { Result = "ERROR", Message = bex.Message }; } catch (Exception ex) { return new { Result = "ERROR", Message = ex.Message }; } }