hecrus

Form SaveItem

Oct 24th, 2020
896
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. CREATE PROCEDURE [dbo].[fm_clientQuestionaries_saveItem]
  2.    @username nvarchar(256),
  3.    @itemID int,
  4.    @parameters ExtendedDictionaryParameter READONLY
  5. AS
  6. BEGIN
  7.     declare
  8.         @fieldchannel nvarchar(max) = '',
  9.         @fieldlink nvarchar(max) = '',
  10.         @fieldnegative nvarchar(max) = '',
  11.         @fieldpositive nvarchar(max) = '',
  12.         @fieldmostinteresting nvarchar(max) = '',
  13.         @fieldnotenough nvarchar(max) = '',
  14.         @fieldmoreinformation nvarchar(max) = '',
  15.         @fieldalternative nvarchar(max) = '',
  16.         @fieldpo nvarchar(max) = '',
  17.         @fieldlike nvarchar(max) = '',
  18.         @fieldemail nvarchar(max) = '',
  19.         @fieldphone nvarchar(max) = '',
  20.         @fieldaccess bit = 0
  21.        
  22.         declare @langID int
  23.     select @langID = try_cast(Value as int) from @parameters where [Key] = 'langID'
  24.  
  25.  
  26.     select @fieldchannel = value from @parameters where [key]='channel'
  27.     select @fieldlink  = value from @parameters where [key]='link'
  28.     select @fieldnegative = value from   @parameters where [key]='negative'
  29.     select @fieldpositive = value from   @parameters where [key]='positive'
  30.     select @fieldmostinteresting = value   from @parameters where [key]='mostinteresting'
  31.     select @fieldnotenough = value  from @parameters where [key]='notenough'
  32.     select @fieldmoreinformation = value   from @parameters where [key]='moreinformation'
  33.     select @fieldalternative = value  from @parameters where [key]='alternative'
  34.     select @fieldpo = value  from @parameters where [key]='po'
  35.     select @fieldlike = value  from @parameters where [key]='like'
  36.     select @fieldemail = value from @parameters where [key]='email'
  37.     select @fieldphone = value  from @parameters where [key]='phone'
  38.     select @fieldaccess = try_cast(value as bit) from @parameters where [key]='access'
  39.  
  40.     declare @percent decimal(18,2) = 0
  41.     if len(@fieldchannel) > 5 set @percent = @percent + 2
  42.     if len(@fieldlink) > 5 set @percent = @percent + 2
  43.     if len(@fieldnegative) > 5 set @percent = @percent + 2
  44.     if len(@fieldpositive) > 5 set @percent = @percent + 2
  45.     if len(@fieldmostinteresting) > 0 set @percent = @percent + 2
  46.     if len(@fieldnotenough) > 5 set @percent = @percent + 2
  47.     if len(@fieldmoreinformation) > 5 set @percent = @percent + 2
  48.     if len(@fieldalternative) > 5 set @percent = @percent + 2
  49.     if len(@fieldpo) > 5 set @percent = @percent + 2
  50.     if len(@fieldlike) > 0 set @percent = @percent + 2
  51.    
  52.     declare @userGuid uniqueidentifier
  53.     select @userGuid = try_convert(uniqueidentifier, Value) from @parameters where [key] = 'falconGuid'
  54.    
  55.     declare @percentText nvarchar(16), @sumText nvarchar(16)
  56.     select @percentText = cast(@percent as nvarchar)
  57.     select @sumText = cast(cast(60000 * @percent/100 as decimal(18,0)) as nvarchar)
  58.    
  59.     if (select count(*) from falcon_clientQuestionaries where userGuid = @userGuid and question = 'percent') > 0
  60.         update falcon_clientQuestionaries set answer = @percentText where userGuid = @userGuid and question = 'percent'
  61.     else
  62.         insert into falcon_clientQuestionaries (userGuid, question, answer) values (@userGuid, 'percent', @percentText)
  63.    
  64.     if (select count(*) from falcon_clientQuestionaries where userGuid = @userGuid and question = 'sum') > 0
  65.         update falcon_clientQuestionaries set answer = @sumText where userGuid = @userGuid and question = 'sum'
  66.     else
  67.         insert into falcon_clientQuestionaries (userGuid, question, answer) values (@userGuid, 'sum', @sumText)
  68.  
  69.    
  70.     declare @text nvarchar(max)
  71.     select @text =  iif(@langID=1, 'A discount is attached to your phone number. ' + @PercentText + '% discount for the purchase of a basic boxed solution is attached to your phone number.
  72. For additional questions, please contact via the chat on the website - at the bottom right. ', 'К номеру вашего телефона привязана скидка ' + @percentText + '% на покупку базового коробочного решения.
  73.                     По дополнительным вопросам обращайтесь пожалуйста через чат на сайте - справа внизу.' )  
  74.    
  75.     select 1 Result, @text Msg, 0 HideFormAfterSubmit
  76. END
RAW Paste Data

Adblocker detected! Please consider disabling it...

We've detected AdBlock Plus or some other adblocking software preventing Pastebin.com from fully loading.

We don't have any obnoxious sound, or popup ads, we actively block these annoying types of ads!

Please add Pastebin.com to your ad blocker whitelist or disable your adblocking software.

×