[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
|