Declare @TId int;
Declare @AnimationTypeId int;
declare @AnimationId int;
declare @AnimationModelId int;
declare @returnvalue int;
SELECT @AnimationModelId=6;
use MPIPackages;
Select @TId=TaskID
From Task
WHERE Name=''
AND PackageID in
(SELECT PackageId from Package WHERE Package.Name='
EDGE 160-Point Inspection
EDGE WCI Inspection 3.5
');
select @AnimationTypeId=1
select @AnimationTypeId=2
select @AnimationTypeId=3
select @AnimationTypeId=4
select @AnimationTypeId=5
select @AnimationTypeId=3
use InteractiveInspectionsData;
select @AnimationId=AnimationViewId
from AnimationView
where AnimationModelId=@AnimationModelId and AnimationViewTypeId=@AnimationTypeId;
if NOT EXISTS(
select AnimationViewId
from AnimationView
where AnimationModelId=@AnimationModelId and AnimationViewTypeId=@AnimationTypeId
)
BEGIN
INSERT INTO AnimationView(AnimationModelId,AnimationViewTypeId,CreatedAt,CreatedBy)
VALUES(@AnimationModelId,@AnimationTypeId,SYSDATETIME(),CURRENTUSER);
select @AnimationId=scopeidentity();
END
use InteractiveInspectionsCode;
EXEC @returnvalue = [dbo].[InsertTaskPinPoint]
@TaskPinPointID = NULL,
@TaskID = @TId,
@AnimationViewID = @AnimationId,
@PinLocationX1 = ,
@PinLocationY1 = ,
@PinLocationX2 = ,
@PinLocationY2 =