Server Error in '/' Application.

rest4u.dll->stconnection#002
with cars as (select ROW_NUMBER() over (order  by [dbo].[getHotelsCommentsTotalBall](id) desc,pay_status desc) as id_row,id,name,main_photo,slug,convert(varchar(500),description) as description,[dbo].[getHotelsTypeNameByID]([type]) as obj_type,'' as objectUrl,'' as stars_rate,stars,pay_status,[dbo].[getHotelsRoomsMinPrice](id,@date_from,@date_to) as min_price, '' as price_block, '' as pdate_from,'' as pdate_to,dbo.getRegionNameByID(region) as regionText, dbo.getDistrictNameByID(district) as districtText,dbo.getLocalityNameByID(locality) as localityText,[dbo].[getHotelsCommentsCount](id) as users_comments,[dbo].[getHotelsCommentsTotalBall](id) users_rate,'' as user_rate_ending_text,[dbo].[getHotelsDiscountByID](id) as discount, '' as object_photo from obj_hotels  where status='on' and main_photo<>'-1'  and region=@region and stars>=@stars_from and stars<=@stars_to and dbo.getHotelsCommentsTotalBall(id) >=@rating_from and dbo.getHotelsCommentsTotalBall(id) <=@rating_to and dbo.getHotelsRoomsMinPrice(id,@date_from,@date_to)>=@price_from and dbo.getHotelsRoomsMaxPrice(id,@date_from,@date_to)<=@price_to and ())select *, case when id_row=(1 - 1)*25 + 1 then (select count(id_row) from cars) else -1 end as [count] from cars where id_row between (1 - 1) * 25 +1 and 1 * 25;declare @autocomplete varchar(1024); set @autocomplete='';select top 200 @autocomplete=@autocomplete+'|'+name from obj_hotels  where status='on' and main_photo<>'-1'  and region=@region and stars>=@stars_from and stars<=@stars_to and dbo.getHotelsCommentsTotalBall(id) >=@rating_from and dbo.getHotelsCommentsTotalBall(id) <=@rating_to and dbo.getHotelsRoomsMinPrice(id,@date_from,@date_to)>=@price_from and dbo.getHotelsRoomsMaxPrice(id,@date_from,@date_to)<=@price_to and ();select @autocomplete;select distinct(id),name from dic_hotels_type where id in (select [type] from obj_hotels  where status='on' and main_photo<>'-1'  and region=@region and stars>=@stars_from and stars<=@stars_to and dbo.getHotelsCommentsTotalBall(id) >=@rating_from and dbo.getHotelsCommentsTotalBall(id) <=@rating_to and dbo.getHotelsRoomsMinPrice(id,@date_from,@date_to)>=@price_from and dbo.getHotelsRoomsMaxPrice(id,@date_from,@date_to)<=@price_to and ());

Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

Exception Details: System.NotImplementedException: rest4u.dll->stconnection#002
with cars as (select ROW_NUMBER() over (order  by [dbo].[getHotelsCommentsTotalBall](id) desc,pay_status desc) as id_row,id,name,main_photo,slug,convert(varchar(500),description) as description,[dbo].[getHotelsTypeNameByID]([type]) as obj_type,'' as objectUrl,'' as stars_rate,stars,pay_status,[dbo].[getHotelsRoomsMinPrice](id,@date_from,@date_to) as min_price, '' as price_block, '' as pdate_from,'' as pdate_to,dbo.getRegionNameByID(region) as regionText, dbo.getDistrictNameByID(district) as districtText,dbo.getLocalityNameByID(locality) as localityText,[dbo].[getHotelsCommentsCount](id) as users_comments,[dbo].[getHotelsCommentsTotalBall](id) users_rate,'' as user_rate_ending_text,[dbo].[getHotelsDiscountByID](id) as discount, '' as object_photo from obj_hotels  where status='on' and main_photo<>'-1'  and region=@region and stars>=@stars_from and stars<=@stars_to and dbo.getHotelsCommentsTotalBall(id) >=@rating_from and dbo.getHotelsCommentsTotalBall(id) <=@rating_to and dbo.getHotelsRoomsMinPrice(id,@date_from,@date_to)>=@price_from and dbo.getHotelsRoomsMaxPrice(id,@date_from,@date_to)<=@price_to and ())select *, case when id_row=(1 - 1)*25 + 1 then (select count(id_row) from cars) else -1 end as [count] from cars where id_row between (1 - 1) * 25 +1 and 1 * 25;declare @autocomplete varchar(1024); set @autocomplete='';select top 200 @autocomplete=@autocomplete+'|'+name from obj_hotels  where status='on' and main_photo<>'-1'  and region=@region and stars>=@stars_from and stars<=@stars_to and dbo.getHotelsCommentsTotalBall(id) >=@rating_from and dbo.getHotelsCommentsTotalBall(id) <=@rating_to and dbo.getHotelsRoomsMinPrice(id,@date_from,@date_to)>=@price_from and dbo.getHotelsRoomsMaxPrice(id,@date_from,@date_to)<=@price_to and ();select @autocomplete;select distinct(id),name from dic_hotels_type where id in (select [type] from obj_hotels  where status='on' and main_photo<>'-1'  and region=@region and stars>=@stars_from and stars<=@stars_to and dbo.getHotelsCommentsTotalBall(id) >=@rating_from and dbo.getHotelsCommentsTotalBall(id) <=@rating_to and dbo.getHotelsRoomsMinPrice(id,@date_from,@date_to)>=@price_from and dbo.getHotelsRoomsMaxPrice(id,@date_from,@date_to)<=@price_to and ());

Source Error:

An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below.

Stack Trace:


[NotImplementedException: rest4u.dll->stconnection#002
with cars as (select ROW_NUMBER() over (order  by [dbo].[getHotelsCommentsTotalBall](id) desc,pay_status desc) as id_row,id,name,main_photo,slug,convert(varchar(500),description) as description,[dbo].[getHotelsTypeNameByID]([type]) as obj_type,'' as objectUrl,'' as stars_rate,stars,pay_status,[dbo].[getHotelsRoomsMinPrice](id,@date_from,@date_to) as min_price, '' as price_block, '' as pdate_from,'' as pdate_to,dbo.getRegionNameByID(region) as regionText, dbo.getDistrictNameByID(district) as districtText,dbo.getLocalityNameByID(locality) as localityText,[dbo].[getHotelsCommentsCount](id) as users_comments,[dbo].[getHotelsCommentsTotalBall](id) users_rate,'' as user_rate_ending_text,[dbo].[getHotelsDiscountByID](id) as discount, '' as object_photo from obj_hotels  where status='on' and main_photo<>'-1'  and region=@region and stars>=@stars_from and stars<=@stars_to and dbo.getHotelsCommentsTotalBall(id) >=@rating_from and dbo.getHotelsCommentsTotalBall(id) <=@rating_to and dbo.getHotelsRoomsMinPrice(id,@date_from,@date_to)>=@price_from and dbo.getHotelsRoomsMaxPrice(id,@date_from,@date_to)<=@price_to and ())select *, case when id_row=(1 - 1)*25 + 1 then (select count(id_row) from cars) else -1 end as [count] from cars where id_row between (1 - 1) * 25 +1 and 1 * 25;declare @autocomplete varchar(1024); set @autocomplete='';select top 200 @autocomplete=@autocomplete+'|'+name from obj_hotels  where status='on' and main_photo<>'-1'  and region=@region and stars>=@stars_from and stars<=@stars_to and dbo.getHotelsCommentsTotalBall(id) >=@rating_from and dbo.getHotelsCommentsTotalBall(id) <=@rating_to and dbo.getHotelsRoomsMinPrice(id,@date_from,@date_to)>=@price_from and dbo.getHotelsRoomsMaxPrice(id,@date_from,@date_to)<=@price_to and ();select @autocomplete;select distinct(id),name from dic_hotels_type where id in (select [type] from obj_hotels  where status='on' and main_photo<>'-1'  and region=@region and stars>=@stars_from and stars<=@stars_to and dbo.getHotelsCommentsTotalBall(id) >=@rating_from and dbo.getHotelsCommentsTotalBall(id) <=@rating_to and dbo.getHotelsRoomsMinPrice(id,@date_from,@date_to)>=@price_from and dbo.getHotelsRoomsMaxPrice(id,@date_from,@date_to)<=@price_to and ());]
   Connection.SiteConnection.getDataSet(String query, List`1 parametrs) in D:\work-old\rest4u-2\rest4u\system\Connection.cs:262
   rest4u_2.residence.objects.loadData() in D:\work-old\rest4u-2\rest4u-2\objects\hotels\list.aspx.cs:350
   rest4u_2.residence.objects.Page_Load(Object sender, EventArgs e) in D:\work-old\rest4u-2\rest4u-2\objects\hotels\list.aspx.cs:63
   System.Web.UI.Control.OnLoad(EventArgs e) +108
   System.Web.UI.Control.LoadRecursive() +90
   System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +1533


Version Information: Microsoft .NET Framework Version:4.0.30319; ASP.NET Version:4.8.4667.0