Creating Lookup Tables

Let’s start by creating lookup tables we’ll need.

Here is a list of these tables:

  • Meeting Types (Board Meeting, Weekly Analytics, SCRUM Meeting, Annual Meeting, so on…)
  • Locations (where meeting will be held, room numbers, address etc.)
  • Agenda Types (what subject(s) an agenda is about, might be multiple)
  • Units (which unit is organizing the meeting)
  • Contacts (people which would attend meetings, reporters, managers etc.)

We’ll use database schema met for tables.

Create a new migration under, Modules/Common/Migrations/DefaultDB with name DefaultDB_20160709_232400_MeetingLookups:

  1. using FluentMigrator;
  3. namespace MeetingManagement.Migrations.DefaultDB
  4. {
  5.     [Migration(20160709232400)]
  6.     public class DefaultDB_20160709_232400_MeetingLookups 
  7.         : AutoReversingMigration
  8.     {
  9.         public override void Up()
  10.         {
  11.             Create.Schema("met");
  13.             Create.Table("AgendaTypes").InSchema("met")
  14.                 .WithColumn("AgendaTypeId").AsInt32()
  15.                     .Identity().PrimaryKey().NotNullable()
  16.                 .WithColumn("Name").AsString(100).NotNullable();
  18.             Create.Table("Contacts").InSchema("met")
  19.                 .WithColumn("ContactId").AsInt32()
  20.                     .Identity().PrimaryKey().NotNullable()
  21.                 .WithColumn("Title").AsString(30).Nullable()
  22.                 .WithColumn("FirstName").AsString(50).NotNullable()
  23.                 .WithColumn("LastName").AsString(50).NotNullable()
  24.                 .WithColumn("Email").AsString(100).NotNullable();
  26.             Create.Table("Locations").InSchema("met")
  27.                 .WithColumn("LocationId").AsInt32()
  28.                     .Identity().PrimaryKey().NotNullable()
  29.                 .WithColumn("Name").AsString(100).NotNullable()
  30.                 .WithColumn("Address").AsString(300).Nullable()
  31.                 .WithColumn("Latitude").AsDouble()
  32.                 .WithColumn("Longitude").AsDouble();
  34.             Create.Table("MeetingTypes").InSchema("met")
  35.                 .WithColumn("MeetingTypeId").AsInt32()
  36.                     .Identity().PrimaryKey().NotNullable()
  37.                 .WithColumn("Name").AsString(100).NotNullable();
  39.             Create.Table("Units").InSchema("met")
  40.                 .WithColumn("UnitId").AsInt32()
  41.                     .Identity().PrimaryKey().NotNullable()
  42.                 .WithColumn("Name").AsString(100).NotNullable();
  43.         }
  44.     }
  45. }

Generating Code for Lookup Tables

Our module name will be Meetings. We should use non-plural entity identifiers for generated code:

  • AgendaTypes => AgendaType
  • Contacts => Contact
  • Locations => Location
  • MeetingTypes => MeetingType
  • Units => Unit

Generate code for these 5 tables using the entity identifiers given above:

Sergen Lookups

Generated interface for these tables is fine enough. Just need to do a few cosmetic touches.

Initial Lookups

Open AgendaTypePage.cs, ContactPage.cs, LocationPage.cs, MeetingTypePage.cs and UnitPage.cs files and move navigation links at top of them to NavigationItems.cs:

  1. using Serenity.Navigation;
  2. using Administration = MeetingManagement.Administration.Pages;
  3. using Meeting = MeetingManagement.Meeting.Pages;
  5. [assembly: NavigationLink(1000, "Dashboard", 
  6.     url: "~/", permission: "", icon: "icon-speedometer")]
  8. [assembly: NavigationMenu(2000, "Meeting")]
  9. [assembly: NavigationLink(2500, "Meeting/Agenda Types", 
  10.     typeof(Meeting.AgendaTypeController))]
  11. [assembly: NavigationLink(2600, "Meeting/Contacts", 
  12.     typeof(Meeting.ContactController))]
  13. [assembly: NavigationLink(2700, "Meeting/Locations", 
  14.     typeof(Meeting.LocationController))]
  15. [assembly: NavigationLink(2800, "Meeting/Meeting Types", 
  16.     typeof(Meeting.MeetingTypeController))]
  17. [assembly: NavigationLink(2900, "Meeting/Units", 
  18.     typeof(Meeting.UnitController))]

Setting DisplayName and InstanceName Attributes of Lookup Tables

Open AgendaTypeRow.cs, ContactRow.cs, LocationRow.cs, MeetingTypeRow.cs and UnitRow.cs files and change DisplayName and InstanceName attributes like below:

  • AgendaTypeRow => “Agenda Types”, “Agenda Type”
  • ContactRow => “Contacts”, “Contact”
  • LocationRow => “Locations”, “Location”
  • MeetingTypeRow => “Meeting Types”, “Meeting Type”
  • UnitRow => “Units”, “Unit”
  1. [ConnectionKey("Default"), TwoLevelCached,
  2.  DisplayName("Agenda Types"), InstanceName("Agenda Type")]
  3. [ReadPermission("Meeting")]
  4. [ModifyPermission("Meeting")]
  5. public sealed class AgendaTypeRow : Row, IIdRow, INameRow
  6. {