Now that we have create our new object and set up its data access, we can add the new module for viewing Projects.

This module must be in the database for the Project object to be displayed.

Run the following script to create a new record in the Table_Modules table and add the allowed entity types under this module.

CopySQL
declare @projectTypeID int

select @projectTypeID = ID from [Cartella].[dbo].[Table_EntityTypes]
where ClassPath = 'Cartella.Classes.Project'

declare @moduleID int

INSERT INTO [Table_Modules]
           ([Name]
           ,[DefaultLabel]
           ,[AvailableByDefault])
     VALUES
           ('Projects'
           ,'Projects'
           ,1) 
Select @moduleID = @@IDENTITY

INSERT INTO [Table_Module_AllowedEntityTypes]
           ([ID_Module]
           ,[ID_EntityType])
     VALUES
           (@moduleID
           ,@projectTypeID)