CREATE PROCEDURE CONFIG.usp_GeneralSettings_Insert
--+++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
--+  Copyright + 2016, Improvement Path Systems, Inc.
--+  All rights reserved.
--+
--+  Description:
--+		*** Procedure creates a single CONFIG.GeneralSettings record.
--+
--+  Date		Developer	Description
--+  ----		--------- 	-----------
--+  12/15/2016 Joel Ewald  SIN-9 Initial Implementation
--++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++

@SettingName varchar(100),
@SettingValue nvarchar(150),
@LastChangeUser varchar(20) = 'DEFAULT',
@SettingGroup int OUTPUT

AS
SET NOCOUNT ON
BEGIN TRY

	INSERT INTO CONFIG.GeneralSettings
	(	SettingGroup, SettingName, SettingValue, LastChangeUser )
	VALUES
	(	@SettingGroup,
		@SettingName,
		@SettingValue,
		@LastChangeUser	)

	SET @SettingGroup = SCOPE_IDENTITY()

END TRY
BEGIN CATCH
	EXECUTE APP.[usp_SystemErrors_Database_Insert] 1
END CATCH
GO



CREATE PROCEDURE CONFIG.usp_GeneralSettings_Update
--+++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
--+  Copyright + 2016, Improvement Path Systems, Inc.
--+  All rights reserved.
--+
--+  Description:
--+		*** Procedure updates a single CONFIG.GeneralSettings record.
--+
--+  Date		Developer	Description
--+  ----		--------- 	-----------
--+  12/15/2016 Joel Ewald  SIN-9 Initial Implementation
--++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++

@SettingGroup varchar(25),
@SettingName varchar(100),
@SettingValue nvarchar(150),
@LastChangeUser varchar(20) = 'DEFAULT'

AS
SET NOCOUNT ON
BEGIN TRY

	UPDATE CONFIG.GeneralSettings
	SET SettingName = @SettingName,
		SettingValue = @SettingValue,
		LastChangeUser = @LastChangeUser
	WHERE SettingGroup = @SettingGroup

END TRY
BEGIN CATCH
	EXECUTE APP.[usp_SystemErrors_Database_Insert] 1
END CATCH
GO



CREATE PROCEDURE CONFIG.usp_GeneralSettings_Delete
--+++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
--+  Copyright + 2016, Improvement Path Systems, Inc.
--+  All rights reserved.
--+
--+  Description:
--+		*** Procedure deletes a single CONFIG.GeneralSettings record.
--+
--+  Date		Developer	Description
--+  ----		--------- 	-----------
--+  12/15/2016 Joel Ewald  SIN-9 Initial Implementation
--++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++

@SettingGroup varchar(25)

AS
SET NOCOUNT ON
BEGIN TRY

	DELETE FROM CONFIG.GeneralSettings
	WHERE SettingGroup = @SettingGroup

END TRY
BEGIN CATCH
	EXECUTE APP.[usp_SystemErrors_Database_Insert] 1
END CATCH
GO



CREATE PROCEDURE CONFIG.usp_GeneralSettings_GetListing
--+++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
--+  Copyright + 2016, Improvement Path Systems, Inc.
--+  All rights reserved.
--+
--+  Description:
--+		*** Procedure returns a listing for CONFIG.GeneralSettings.
--+
--+  Date		Developer	Description
--+  ----		--------- 	-----------
--+  12/15/2016 Joel Ewald  SIN-9 Initial Implementation
--++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++

AS
SET NOCOUNT ON
BEGIN TRY

	SELECT
		SettingGroup,
		SettingName,
		SettingValue,
		LastChangeUser
	FROM CONFIG.GeneralSettings

END TRY
BEGIN CATCH
	EXECUTE APP.[usp_SystemErrors_Database_Insert] 1
END CATCH
GO



CREATE PROCEDURE CONFIG.usp_GeneralSettings_GetInfoById
--+++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
--+  Copyright + 2016, Improvement Path Systems, Inc.
--+  All rights reserved.
--+
--+  Description:
--+		*** Procedure returns a CONFIG.GeneralSettings record by ID.
--+
--+  Date		Developer	Description
--+  ----		--------- 	-----------
--+  12/15/2016 Joel Ewald  SIN-9 Initial Implementation
--++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++

@SettingGroup varchar(25)

AS
SET NOCOUNT ON
BEGIN TRY

	SELECT
		SettingGroup,
		SettingName,
		SettingValue,
		LastChangeUser
	FROM CONFIG.GeneralSettings
	WHERE SettingGroup = @SettingGroup

END TRY
BEGIN CATCH
	EXECUTE APP.[usp_SystemErrors_Database_Insert] 1
END CATCH
GO