Index: trunk/SQL/Tables/ProvisionSettings.txt
===================================================================
--- trunk/SQL/Tables/ProvisionSettings.txt (revision 677)
+++ trunk/SQL/Tables/ProvisionSettings.txt (revision 677)
@@ -0,0 +1,22 @@
+
+/****** Object:  Table [dbo].[ProvisionSettings]    Script Date: 06/03/2009 15:47:19 ******/
+SET ANSI_NULLS ON
+GO
+SET QUOTED_IDENTIFIER ON
+GO
+CREATE TABLE [dbo].[ProvisionSettings](
+	[AgencyId] [int] NOT NULL,
+	[Year] [int] NOT NULL,
+	[Month] [int] NOT NULL,
+	[IsBlocked] [bit] NULL,
+	[UpdatedBy] [nvarchar](100) COLLATE SQL_Latin1_General_CP1250_CI_AS NULL,
+	[UpdatedOn] [datetime] NULL,
+	[CreatedBy] [nvarchar](100) COLLATE SQL_Latin1_General_CP1250_CI_AS NULL,
+	[CreatedOn] [datetime] NULL,
+ CONSTRAINT [PK_ProvisionSettings] PRIMARY KEY CLUSTERED 
+(
+	[AgencyId] ASC,
+	[Year] ASC,
+	[Month] ASC
+) ON [PRIMARY]
+) ON [PRIMARY]
Index: trunk/SQL/StoredProcedures/sp_SetProvision.txt
===================================================================
--- trunk/SQL/StoredProcedures/sp_SetProvision.txt (revision 677)
+++ trunk/SQL/StoredProcedures/sp_SetProvision.txt (revision 677)
@@ -0,0 +1,39 @@
+/****** Object:  StoredProcedure [dbo].[sp_SetProvision]    Script Date: 06/03/2009 15:49:05 ******/
+SET ANSI_NULLS ON
+GO
+SET QUOTED_IDENTIFIER ON
+GO
+
+-- =============================================
+-- Author:		marek
+-- Create date: 03/06/2009
+-- Description:	Ustawia czy prowizje dla danej agencji jest juz zablokowana
+-- =============================================
+CREATE PROCEDURE [dbo].[sp_SetProvision] 
+	@isBlocked bit,
+	@agencyId int,
+	@year int,
+	@month int,
+	@userName nvarchar(100)
+AS
+BEGIN
+	-- SET NOCOUNT ON added to prevent extra result sets from
+	-- interfering with SELECT statements.
+	SET NOCOUNT ON;
+
+IF EXISTS(SELECT * FROM dbo.ProvisionSettings WHERE agencyId=@agencyId AND [year]=@year AND [Month]=@month)
+	BEGIN
+		PRINT 'UPDATE'
+		UPDATE dbo.ProvisionSettings
+		SET IsBlocked=@isBlocked, UpdatedOn=GETDATE(), UpdatedBy=@userName
+		WHERE agencyId=@agencyId AND [year]=@year AND [Month]=@month 
+	END
+ELSE
+	BEGIN
+		INSERT INTO dbo.ProvisionSettings(AgencyId, [Year], [Month], IsBlocked, CreatedOn, CreatedBy, UpdatedOn, UpdatedBy) 
+		VALUES(@agencyId, @year, @month, @isBlocked, GETDATE(), @userName, GETDATE(), @userName)
+	END
+
+RETURN
+
+END
Index: trunk/SQL/StoredProcedures/sp_IsProvisionBlocked.txt
===================================================================
--- trunk/SQL/StoredProcedures/sp_IsProvisionBlocked.txt (revision 677)
+++ trunk/SQL/StoredProcedures/sp_IsProvisionBlocked.txt (revision 677)
@@ -0,0 +1,29 @@
+/****** Object:  StoredProcedure [dbo].[sp_IsProvisionBlocked]    Script Date: 06/03/2009 15:48:21 ******/
+SET ANSI_NULLS ON
+GO
+SET QUOTED_IDENTIFIER ON
+GO
+
+-- =============================================
+-- Author:		<Author,,Name>
+-- Create date: <Create Date,,>
+-- Description:	<Description,,>
+-- =============================================
+CREATE PROCEDURE [dbo].[sp_IsProvisionBlocked]
+					@agencyId int,
+					@year int,
+					@month int
+AS
+BEGIN
+	-- SET NOCOUNT ON added to prevent extra result sets from
+	-- interfering with SELECT statements.
+	SET NOCOUNT ON;
+
+IF EXISTS(SELECT * FROM dbo.ProvisionSettings WHERE agencyId=@agencyId AND [year]=@year AND [Month]=@month)
+ SELECT IsBlocked FROM dbo.ProvisionSettings WHERE agencyId=@agencyId AND [year]=@year AND [Month]=@month
+ELSE
+ SELECT 0
+
+RETURN
+
+END