 
SET ANSI_NULLS ON
 
GO
 
SET QUOTED_IDENTIFIER ON
 
GO
 
Alter PROCEDURE [dbo].[ResourcesInsert]
 
@tr nvarchar (max),
 
@eng nvarchar (max),
 
@de nvarchar (max),
 
@ar nvarchar (max)
 
AS
 
BEGIN
 
INSERT INTO Resources
 ( 
tr, 
 
eng, 
 
de, 
 
ar
 
 ) 
 
values 
 (
 
@tr,
 
@eng,
 
@de,
 
@ar
 
)
 
 RETURN @@IDENTITY
 
 END
 
SET ANSI_NULLS ON
 
GO
 
SET QUOTED_IDENTIFIER ON
 
GO
 

 
Alter PROCEDURE [dbo].[ResourcesUpdate]
 
 
 
@ID int ,
 
@tr nvarchar (max),
 
@eng nvarchar (max),
 
@de nvarchar (max),
 
@ar nvarchar (max)
 
AS
 
 
 
BEGIN
 
 
 
update Resources
 
 set 
 
tr=@tr,
 
eng=@eng,
 
de=@de,
 
ar=@ar
 
where ID=@ID
 
END
 
SET ANSI_NULLS ON
 
GO
 
SET QUOTED_IDENTIFIER ON
 
GO
 
Alter PROCEDURE [dbo].[ResourcesDelete]
 
@ID int
 
AS
 
 
 
BEGIN
 
 
 
delete from Resources
 
 where ID=@ID
 
END
 
SET ANSI_NULLS ON
 
GO
 
SET QUOTED_IDENTIFIER ON
 
GO
 
Alter PROCEDURE [dbo].[ResourcesGetOne]
 
@ID int
 
 
 
AS
 
 
 
BEGIN
 
 
 
select * from Resources
 
 where ID=@ID
 
END
 
SET ANSI_NULLS ON
 
GO
 
SET QUOTED_IDENTIFIER ON
 
GO
 
Alter PROCEDURE [dbo].[ResourcesGetAll]
 
 
 
AS
 
 
 
BEGIN
 
 
 
select * from Resources order by ID desc
 
END
