A Database from a Designed Model

To use the entity framework, you can first create a visual design of a (the) table(s) you want to use in your database. First, from the Models folder of your project, create an ADO.NET Entity Data Model. In the Entity Data Model Wizard dialog box, click Empty EF Designer Model and click Finish.

Practical LearningPractical Learning: Starting a Design Model

  1. Microsoft Visual Studio
  2. On the main menu , click File -> New -> Project...
  3. In the New Project dialog, click ASP.NET Web Application (.NET Framework) and change the project Name to PropertiesRentalManagement1
  4. Click OK
  5. In the New ASP.NET Web Application dialog box, click the MVC icon and click OK
  6. In the Solution Explorer, right-click WattsALoan3 -> Add -> New Folder
  7. Type Images
  8. Copy and paste the following pictures to the Images folder:

    Properties Rental Management - Online Presence Properties Rental Management - Company Logo Properties Rental Management - Small Logo
    Properties Rental Management - Main Title Properties Rental Management - Single Family House
    Properties Rental Management - Apartments Properties Rental Management - Townhouses
  9. In the Solution Explorer, right-click Content -> Add -> New Item...
  10. In the left frame of the Add New Item dialog box, click Web and, in the middle frame, click Style Sheet
  11. Type PropertiesRentalManagement as the file Name
  12. Click Add
  13. Add the following formats:
    body {
        background-color: white;
    }
    
    .bold                                { font-weight:      bold;    }
    .blue                                { color:            #286090; }
    .pat-down1                           { padding-top:      0.65em;  }
    .pat-down2                           { padding-top:      1.65em;  }
    .pat-down3                           { padding-top:      1.05em;  }
    .pat-down4                           { padding-top:      3.25em;  }
    .push-down                           { margin-top:       10.25em; }
    .sub-title                           { padding-bottom:   5px;
                                           font-weight:      600;
                                           font-size:        20px;
                                           color:            #2D73B4;
                                           border-bottom:    2px dotted #0832a4; }
    .bordered                            { border:           1px solid black; }
    .parajust                            { text-align:       justify;
                                           font-family:     'Times New Roman', Garamond, Georgia, serif; }
    .navbar-inverse                      { height:           20px;
                                           background-color: #2D73B4;  }
    .navbar                              { border-radius:    0;
                                            min-height:       38px;     }
    .navbar-brand                        { font-size:        14px;
                                           padding:          6px 25px;
                                           line-height:      25px;     }
    .navbar-nav > li > a                 { padding-top:      10px;     }
    .navbar-inverse .navbar-nav > li > a { color:            #FFF;     }
    .navbar-inverse .navbar-brand:focus,
    .navbar-inverse .navbar-nav > li > a:focus {
                                           color:            #FFFFFF;  }
    .navbar-inverse .navbar-nav > li > a:hover,
    .navbar-inverse .navbar-brand:hover  { color:            #ffd800;  }
    .navbar-inverse .navbar-brand        { color:            #FFFFFF;  }
    .navbar-fixed-middle,
    .navbar-fixed-medium                 { left:             0;
                                           right:            0;
                                           width:            100%;
                                           bottom:           auto;
                                           z-index:          1100;
                                           position:         fixed;    }
    .navbar-fixed-middle                 { height:           7.5em;
                                           top:              2.625em;
                                           background-color: rgb(15, 50, 135); }
    .navbar-fixed-medium                 { top:              10.15em;
                                           height:           2.5em;
                                           background-color: rgb(0, 50, 100);  }
    .lease-crochet > ul                  { list-style-type:  none;
                                           overflow:         hidden;
                                           margin:           10px 0 0 0;
                                           padding:          10px 0 0 0;       }
    .lease-crochet > ul > li             { float:            left;
                                           margin:           3px 6px;          }
    .lease-crochet > ul > li a           { border-radius:    5px;
                                           font-weight:      600;
                                           font-size:        14px;
                                           text-decoration:  none;
                                           display:          block;
                                           text-align:       center;
                                           padding:          6px 16px;
                                           font-family:      Cambria, Cochin, Georgia, Times, Times New Roman, serif; }
    .lease-crochet > ul > li a:visited,
    .lease-crochet > ul > li a:link      { color:            azure;
                                           background-color: rgb(255, 155, 0); }
    .lease-crochet > ul > li a:focus     { color:            azure;
                                           background-color: black;            }
    .lease-crochet > ul > li a:hover     { color:            #a5bdd8;
                                           background-color: #327eb1;          }
    .centralized                         { margin:           auto;
                                           width:            600px;            }
    .community > ul                      { margin:           0;
                                           top:              9.45em;
                                           position:         fixed;
                                           padding:          10px;
                                           list-style-type:  none;
                                           overflow:         hidden;    }
    .community > ul > li                 { height:           10.5em;
                                           float:            left;
                                           margin:           1px 1px;   }
    .community > ul > li a               { font-size:        14px;
                                           text-decoration:  none;
                                           display:          block;
                                           text-align:       center;
                                           padding:          6px 16px;  }
    .community > ul > li a:link          { color:            azure;     }
    .community > ul > li a:focus         { color:            azure;
                                           background-color: gray;      }
    .community > ul > li a:visited       { color:            azure;
                                           background-color: #CECECE;   }
    .community > ul > li a:hover         { color:            navy;
                                           background-color: lightblue; }
    .side-menu                           { margin-top:       35px;
                                           float:            left;
                                           background-color: #93A5C4;   }
    ul.sm                                { margin:           0;
                                           padding:          0;
                                           margin-bottom:    1px;
                                           list-style-type:  none;
                                           border-top:       1px solid #666; }
    ul.sm li                             { border-bottom:    1px solid #666; }
    ul.sm a, ul.sm a:visited             { color:            #FFF;
                                           display:          block;
                                           text-decoration:  none;
                                           background-color: #2D73B4;
                                           padding:          5px 5px 5px 20px; }
    ul.sm a:active, ul.sm a:focus        { color:            #0f20a9;
                                           background-color: lightblue;        }
    ul.sm a:hover                        { color:            #2b71bb;
                                           background-color: lightblue;        }
    .common-font                         { font-family: Garamond, Georgia, Cambria, Times, Times New Roman, serif; }
  14. In the Solution Explorer, expand App_Start and double-click BundleConfig.cs
  15. Change the document as follows:
    using System.Web.Optimization;
    
    namespace PropertiesRentalManagement1
    {
        public class BundleConfig
        {
            // For more information on bundling, visit https://go.microsoft.com/fwlink/?LinkId=301862
            public static void RegisterBundles(BundleCollection bundles)
            {
                bundles.Add(new ScriptBundle("~/bundles/jquery").Include(
                            "~/Scripts/jquery-{version}.js"));
    
                bundles.Add(new ScriptBundle("~/bundles/jqueryval").Include(
                            "~/Scripts/jquery.validate*"));
    
                // Use the development version of Modernizr to develop with and learn from. Then, when you're
                // ready for production, use the build tool at https://modernizr.com to pick only the tests you need.
                bundles.Add(new ScriptBundle("~/bundles/modernizr").Include(
                            "~/Scripts/modernizr-*"));
    
                bundles.Add(new ScriptBundle("~/bundles/bootstrap").Include(
                          "~/Scripts/bootstrap.js"));
    
                bundles.Add(new StyleBundle("~/Content/css").Include(
                          "~/Content/bootstrap.css",
                          "~/Content/site.css",
                          "~/Content/PropertiesRentalManagement.css"));
            }
        }
    }
  16. In the Solution Explorer, right-click Models -> Add -> New Item...
  17. In the left frame of the Add New Item dialog box, click Data
  18. In the middle frame, click ADO.NET Entity Data Model and change the Name to PropertiesManagementModel
  19. Click Add
  20. In the Entity Data Model Wizard, click Empty EF Designer Model:

    Entity Data Model Wizard

  21. Click Finish

Designing a Table as an Entity

When you select the Empty EF Designer Model of the Entity Data Model Wizard and click Finish, Microsoft Visual Studio would open an empty designer. This allows you to design a table. To start creating a table, add an Entity table, which would represent a table. Of course, you should name the table. The name should be singular because it primarily represents a C# class.

You can add the columns of the table. To do that, you can right-click any part of the window and click Add New -> Scalar Property.

Practical LearningPractical Learning: Designing a Table as an Entity

  1. Right-click anywhere in the Designer -> Add New -> Entity
  2. Type Employee as the Entity Name
  3. In the Property Name text box, replace Id with EmployeeId
  4. Click OK
  5. In the Designer, right-click any part of the Employee window -> Add New -> Scalar Property
  6. Type EmployeeNumber for the name of the new field
  7. In the Designer, right-click any part of the Employee window -> Add New -> Scalar Property
  8. Type FirstName
  9. Right-click anywhere in the Designer -> Add New -> Entity
  10. Type RentalProperty as the Entity Name
  11. In the Property Name text box, replace Id with RentalPropertyId
  12. Click OK
  13. In the Designer, right-click any part of the RentalProperty window -> Add New -> Scalar Property
  14. Type PropertyNumber
  15. In the Designer, right-click any part of the RentalProperty window -> Add New -> Scalar Property
  16. Type PropertyType
  17. Right-click anywhere in the Designer -> Add New -> Entity
  18. Type RentContract as the Entity Name
  19. In the Property Name text box, replace Id with RentContractId
  20. Click OK
  21. In the Designer, right-click any part of the RentContract window -> Add New -> Scalar Property
  22. Type ContractNumber

Assistance with Data Entry

Data Types

One way you can control the value that a user can provide to a field is to specify an appropriate data type. If you are designing an entity, to specify a data type, click the desired field in the Designer, in the Type combo box of the Properties window, select the desired type.

If you specify the data of a property as Decimal, you have the option of setting its precision and scale.

Practical LearningPractical Learning: Setting the Data Type of a Column

An Identity Column

By default, when you add a new entity in the designer, that entity receives a column whose type is an integer and is an identity column. Otherwise, to create an identity column, add a scalar property. In the Properties window, set the data Type to an integer. Set the StoreGeneratedPattern to Identity. Here is an example:

Query Window - Creating a Schema

The Minimum Number of Characters

When configuring a property for an entity, you can set the minimum number of characters that a user must type in a certain field. To assist you with this, the System.ComponentModel.DataAnnotations namespace is equipped with the MinLength attribute named. If you are designing an entity, after adding a string-based Scalar Property, if you want to require a certain minimum number of characters, in the Properties window, click the Min Length and type the desired number.

The Maximum Number of Characters

When creating or changing a property for an entity, to let you specify the maximum number of characters that a column can hold, the System.ComponentModel.DataAnnotations namespace is equipped with the MaxLength attribute. If you are designing an entity, after adding a string-based Scalar Property, to specify the maximum number of characters for a field, in the Properties window, click the Max Length and type the desired number.

Practical LearningPractical Learning: Setting the Length of a Field

  1. In the Designer, in the Employee window, click EmployeeNumber to select it
  2. In the Properties window, click Max Length and type 10

A Default Value

When creating or modifying a property for an entity, if you want the column of that property to hold a default value, after selecting that property in the Designer, in the Properties, click Default and type the desired (but appropriate) value.

Practical LearningPractical Learning: Setting a Default Value

  1. In the RentalProperty window, click PropertyType to give it focus
  2. In the Properties window, click Default Value and type Unknown

The Nullity of a Field

A field is referred to as required if the user must provide a value for it before moving to another record. In other words, the field cannot be left empty during data entry.

If you are designing an entity, to specify whether a column must always hold a value, after adding its Scalar Property, in the Properties, use the Nullable field. If you set it to True, the user must provide a value for the column, otherwise the record will not be saved.

Practical LearningPractical Learning: Creating Database Fields

  1. In the Designer, in the Employee window, click FirstName to give it focus
  2. In the Properties window, double-click Nullable to set its value to (None)

Data Relationships

Introduction

A relational database is a system is which objects, namely tables exchange data (from their records). To make this possible, you must first create a primary key in a table that will make its data available to other tables. For a table B to receive data from a table A, table B must have a column that will act as a foreign key. At a minimum, the field in the second table must have the same data type as the primary key of the first table. Although both the primary and the foreign keys don't have to have the same name, it is a good idea if they do.

Practical LearningPractical Learning: Introducing Foreign Keys

  1. Complete the Employee table with the following scalar properties

    Name Type Max Length Nullable
    EmployeeId      
    EmployeeNumber   10  
    FirstName   25 (None)
    LastName   25  
    EmploymentTitle   50 True
  2. Complete the RentalProperty table with the following fields:

    Name Type Precision Scale Max Length Nullable Default Value
    RentalPropertyId            
    PropertyNumber       10    
    PropertyType       25   Unknown
    Address       100 True  
    City       40    
    State       40    
    ZIPCode       12 (None)  
    Bedrooms Int32          
    Bathrooms Decimal 3 2      
    MonthlyRate Int32         0
    SecurityDeposit Int32         0
    OccupancyStatus       25   Unknown
  3. Complete the RentContract table as follows:

    Property Name Precision Scale Max Length Type Nullable Default Value
    RentContractId            
    ContractNumber       Int32    
    ContractDate     50      
    EmployeeId       Int32    
    TenantFirstName     25   True  
    TenantLastName     25      
    MaritalStatus     25     Unknown
    NumberOfChildren       Int32   0
    RentalPropertyId       Int32    
    RentStartDate     50      
  4. To start a new table, in the Toolbox, drag Entity and drop it in the designing area
  5. In the Properties window, click Name, type Payment, and press Enter
  6. In the Payment window in the Designer, click Id
  7. In the Properties window, edit the Name fieldd to get PaymentId
  8. Add the following scalar entities

    Name Max Length Type
    PaymentId   Int32
    ReceiptNumber   Int32
    EmployeeId   Int32
    RentContractId   Int32
    PaymentDate 50  
    AmountPaid   Int32
    Notes    

    Model Preparation

Establishing a Relationship

After creating a primary and foreign keys in their respective tables, you can establish a relationsh between both tables. When it comes to the Entity Framework used in Microsoft Visual Studio, you can visually create the relationship.

To create a relationship this, right-click anywhere in the Designer, position the mouse on Add New, and click Association... This will display the Add Association dialog box. In the left Entity combo box, select the table that holds the primary column. In the right Entity combo box, select the table that holds the foreign key. As an alternative, in the Toolbox, click the Association icon. In the Designer, click the table that has the primary key, then click the table that has the foreign key.

Practical LearningPractical Learning: Establishing Relationships

  1. Right-click anywhere in the Designer -> Add New -> Association...
  2. The left Entity combo box should display Employee already. If not, click the arrow of the left Entity combo box and select Employee
    In the right Entity combo box, select RentContract

    Add Assotiation

  3. Click OK

  4. Right-click anywhere in the Designer -> Add New -> Association...
  5. In the left Entity combo box, select RentalProperty
  6. In the right Entity combo box, select RentContract

    Add Assotiation

  7. Click OK

  8. Right-click anywhere in the Designer -> Add New -> Association...
  9. In the left Entity combo box, select Employee
  10. In the right Entity combo box, select Payment
  11. Click OK

  12. Right-click anywhere in the Designer -> Add New -> Association...
  13. In the left Entity combo box, select RentContract
  14. In the right Entity combo box, select Payment
  15. Click OK

Generating a Database from a Designed Model

After designing one or more tables, you can ask Microsoft Visual Studio to create a database that would have that (those) model(s) as (a) table(s).

Practical LearningPractical Learning: Generating the Database

  1. Right-click anywhere in the Designer and click Generate Database From Model...

    Generate Database Wizard

  2. In the Generate Database Wizard, click the New Connection button
  3. In the Connection Properties dialog box:
    • If you want to use (or work on) a local database
      1. In the Connection Properties dialog box, click Change
      2. Click Microsoft SQL Server Database File
      3. Click OK
      4. In the Database File Name (New or Existing) text box, type PropertiesRentalManagement1

        Connection Properties

      5. Click OK
      6. You will receive a message box asking you whether you want to create the database:

        Connection Propertie

        Read the message and click Yes

        Generate Database Wizard

    • If you want to use Microsoft SQL Server professional or enterprise:
      1. Make sure the Data Source text box displays Microsoft SQL Server (SqlClient). If not, click the Change button. In the Change Data Source dialog box, click Microsoft SQL Server and click OK
      2. In the Server Name, if Microsoft SQL Server is installed in the same computer you are using, type the name of the computer or type (local)
      3. In the Select Or Enter A Database Name combo box, type PropertiesRentalManagement1

        Connection Propertie

      4. Click OK
      5. You will receive a message box asking you whether you want to create the database.

        Connection Propertie

        Read the message and click Yes

        Generate Database Wizard

  4. Click Next

    Generate Database Wizard

  5. In the Generate Database Wizard, click Next
  6. In the Generate Database Wizard, click Entity Framework 6.x and click Next
  7. Check the suggested DDL text and click Finish
  8. Read the text piece(s) on the Secutiry Warning message box(es)

    Security Warning

    Click OK
    -- --------------------------------------------------
    -- Entity Designer DDL Script for SQL Server 2005, 2008, 2012 and Azure
    -- --------------------------------------------------
    -- Date Created: 09/23/2018 18:49:00
    -- Generated from EDMX file: C:\Applications\Finals\PropertiesRentalManagement1\PropertiesRentalManagement1\Models\PropertiesManagementModel.edmx
    -- --------------------------------------------------
    
    SET QUOTED_IDENTIFIER OFF;
    GO
    USE [PropertiesRentalManagement1];
    GO
    IF SCHEMA_ID(N'dbo') IS NULL EXECUTE(N'CREATE SCHEMA [dbo]');
    GO
    
    -- --------------------------------------------------
    -- Dropping existing FOREIGN KEY constraints
    -- --------------------------------------------------
    
    
    -- --------------------------------------------------
    -- Dropping existing tables
    -- --------------------------------------------------
    
    
    -- --------------------------------------------------
    -- Creating all tables
    -- --------------------------------------------------
    
    -- Creating table 'Employees'
    CREATE TABLE [dbo].[Employees] (
        [EmployeeId] int IDENTITY(1,1) NOT NULL,
        [EmployeeNumber] nvarchar(10)  NOT NULL,
        [FirstName] nvarchar(25)  NULL,
        [LastName] nvarchar(25)  NOT NULL,
        [EmploymentTitle] nvarchar(50)  NOT NULL
    );
    GO
    
    -- Creating table 'RentalProperties'
    CREATE TABLE [dbo].[RentalProperties] (
        [RentalPropertyId] int IDENTITY(1,1) NOT NULL,
        [PropertyNumber] nvarchar(10)  NOT NULL,
        [PropertyType] nvarchar(25)  NOT NULL,
        [Address] nvarchar(100)  NULL,
        [City] nvarchar(50)  NOT NULL,
        [State] nvarchar(50)  NOT NULL,
        [ZIPCode] nvarchar(12)  NOT NULL,
        [Bedrooms] int  NOT NULL,
        [Bathrooms] decimal(3,2)  NOT NULL,
        [MonthlyRate] int  NOT NULL,
        [SecurityDeposit] int  NOT NULL,
        [OccupancyStatus] nvarchar(25)  NOT NULL
    );
    GO
    
    -- Creating table 'Payments'
    CREATE TABLE [dbo].[Payments] (
        [PaymentId] int IDENTITY(1,1) NOT NULL,
        [ReceiptNumber] int  NOT NULL,
        [EmployeeId] int  NOT NULL,
        [RentContractId] int  NOT NULL,
        [PaymentDate] nvarchar(50)  NOT NULL,
        [AmountPaid] int  NOT NULL,
        [Notes] nvarchar(max)  NOT NULL,
        [RentContractRentContractId] int  NOT NULL,
        [EmployeeEmployeeId] int  NOT NULL
    );
    GO
    
    -- Creating table 'RentContracts'
    CREATE TABLE [dbo].[RentContracts] (
        [RentContractId] int IDENTITY(1,1) NOT NULL,
        [ContractNumber] int  NOT NULL,
        [ContractDate] nvarchar(50)  NOT NULL,
        [EmployeeId] int  NOT NULL,
        [TenantFirstName] nvarchar(25)  NULL,
        [TenantLastName] nvarchar(25)  NOT NULL,
        [MaritalStatus] nvarchar(25)  NOT NULL,
        [NumberOfChildren] int  NOT NULL,
        [RentalPropertyId] int  NOT NULL,
        [RentStartDate] nvarchar(50)  NOT NULL,
        [EmployeeEmployeeId] int  NOT NULL,
        [RentalPropertyRentalPropertyId] int  NOT NULL
    );
    GO
    
    -- --------------------------------------------------
    -- Creating all PRIMARY KEY constraints
    -- --------------------------------------------------
    
    -- Creating primary key on [EmployeeId] in table 'Employees'
    ALTER TABLE [dbo].[Employees]
    ADD CONSTRAINT [PK_Employees]
        PRIMARY KEY CLUSTERED ([EmployeeId] ASC);
    GO
    
    -- Creating primary key on [RentalPropertyId] in table 'RentalProperties'
    ALTER TABLE [dbo].[RentalProperties]
    ADD CONSTRAINT [PK_RentalProperties]
        PRIMARY KEY CLUSTERED ([RentalPropertyId] ASC);
    GO
    
    -- Creating primary key on [PaymentId] in table 'Payments'
    ALTER TABLE [dbo].[Payments]
    ADD CONSTRAINT [PK_Payments]
        PRIMARY KEY CLUSTERED ([PaymentId] ASC);
    GO
    
    -- Creating primary key on [RentContractId] in table 'RentContracts'
    ALTER TABLE [dbo].[RentContracts]
    ADD CONSTRAINT [PK_RentContracts]
        PRIMARY KEY CLUSTERED ([RentContractId] ASC);
    GO
    
    -- --------------------------------------------------
    -- Creating all FOREIGN KEY constraints
    -- --------------------------------------------------
    
    -- Creating foreign key on [EmployeeEmployeeId] in table 'RentContracts'
    ALTER TABLE [dbo].[RentContracts]
    ADD CONSTRAINT [FK_EmployeeRentContract]
        FOREIGN KEY ([EmployeeEmployeeId])
        REFERENCES [dbo].[Employees]
            ([EmployeeId])
        ON DELETE NO ACTION ON UPDATE NO ACTION;
    GO
    
    -- Creating non-clustered index for FOREIGN KEY 'FK_EmployeeRentContract'
    CREATE INDEX [IX_FK_EmployeeRentContract]
    ON [dbo].[RentContracts]
        ([EmployeeEmployeeId]);
    GO
    
    -- Creating foreign key on [RentalPropertyRentalPropertyId] in table 'RentContracts'
    ALTER TABLE [dbo].[RentContracts]
    ADD CONSTRAINT [FK_RentalPropertyRentContract]
        FOREIGN KEY ([RentalPropertyRentalPropertyId])
        REFERENCES [dbo].[RentalProperties]
            ([RentalPropertyId])
        ON DELETE NO ACTION ON UPDATE NO ACTION;
    GO
    
    -- Creating non-clustered index for FOREIGN KEY 'FK_RentalPropertyRentContract'
    CREATE INDEX [IX_FK_RentalPropertyRentContract]
    ON [dbo].[RentContracts]
        ([RentalPropertyRentalPropertyId]);
    GO
    
    -- Creating foreign key on [RentContractRentContractId] in table 'Payments'
    ALTER TABLE [dbo].[Payments]
    ADD CONSTRAINT [FK_RentContractPayment]
        FOREIGN KEY ([RentContractRentContractId])
        REFERENCES [dbo].[RentContracts]
            ([RentContractId])
        ON DELETE NO ACTION ON UPDATE NO ACTION;
    GO
    
    -- Creating non-clustered index for FOREIGN KEY 'FK_RentContractPayment'
    CREATE INDEX [IX_FK_RentContractPayment]
    ON [dbo].[Payments]
        ([RentContractRentContractId]);
    GO
    
    -- Creating foreign key on [EmployeeEmployeeId] in table 'Payments'
    ALTER TABLE [dbo].[Payments]
    ADD CONSTRAINT [FK_EmployeePayment]
        FOREIGN KEY ([EmployeeEmployeeId])
        REFERENCES [dbo].[Employees]
            ([EmployeeId])
        ON DELETE NO ACTION ON UPDATE NO ACTION;
    GO
    
    -- Creating non-clustered index for FOREIGN KEY 'FK_EmployeePayment'
    CREATE INDEX [IX_FK_EmployeePayment]
    ON [dbo].[Payments]
        ([EmployeeEmployeeId]);
    GO
    
    -- --------------------------------------------------
    -- Script has ended
    -- --------------------------------------------------
  9. Click inside the Query window that contains the code and press Ctrl + A to select everything
  10. Press Ctrl + C to copy
  11. In the Server Explorer, under Data Connections, right-click PropertiesManagementModelContainer (PropertiesRentalManagement1) -> New Query (as an alternative, or if the PropertiesManagementModelContainer (PropertiesRentalManagement1) node doesn't expand, on the main menu, click View and click SQL Server Object Explorer; in the window that opens, look for PropertiesRentalManagement1, right-click its node and click New Query)
  12. Press Ctrl + V to paste
  13. Change the document as follows (you are asked to delete all references to [dbo] and [dbo].):
    -- Creating table 'Employees'
    CREATE TABLE [Employees] (
        [EmployeeId] int IDENTITY(1,1) NOT NULL,
        [EmployeeNumber] nvarchar(10)  NOT NULL,
        [FirstName] nvarchar(25)  NULL,
        [LastName] nvarchar(25)  NOT NULL,
        [EmploymentTitle] nvarchar(50)  NOT NULL
    );
    GO
    
    -- Creating table 'RentalProperties'
    CREATE TABLE [RentalProperties] (
        [RentalPropertyId] int IDENTITY(1,1) NOT NULL,
        [PropertyNumber] nvarchar(10)  NOT NULL,
        [PropertyType] nvarchar(25)  NOT NULL,
        [Address] nvarchar(100)  NULL,
        [City] nvarchar(50)  NOT NULL,
        [State] nvarchar(50)  NOT NULL,
        [ZIPCode] nvarchar(12)  NOT NULL,
        [Bedrooms] int  NOT NULL,
        [Bathrooms] decimal(3,2)  NOT NULL,
        [MonthlyRate] int  NOT NULL,
        [SecurityDeposit] int  NOT NULL,
        [OccupancyStatus] nvarchar(25)  NOT NULL
    );
    GO
    
    -- Creating table 'Payments'
    CREATE TABLE [Payments] (
        [PaymentId] int IDENTITY(1,1) NOT NULL,
        [ReceiptNumber] int  NOT NULL,
        [EmployeeId] int  NOT NULL,
        [RentContractId] int  NOT NULL,
        [PaymentDate] nvarchar(50)  NOT NULL,
        [AmountPaid] int  NOT NULL,
        [Notes] nvarchar(max)  NOT NULL,
        [RentContractRentContractId] int  NOT NULL,
        [EmployeeEmployeeId] int  NOT NULL
    );
    GO
    
    -- Creating table 'RentContracts'
    CREATE TABLE [RentContracts] (
        [RentContractId] int IDENTITY(1,1) NOT NULL,
        [ContractNumber] int  NOT NULL,
        [ContractDate] nvarchar(50)  NOT NULL,
        [EmployeeId] int  NOT NULL,
        [TenantFirstName] nvarchar(25)  NULL,
        [TenantLastName] nvarchar(25)  NOT NULL,
        [MaritalStatus] nvarchar(25)  NOT NULL,
        [NumberOfChildren] int  NOT NULL,
        [RentalPropertyId] int  NOT NULL,
        [RentStartDate] nvarchar(50)  NOT NULL,
        [EmployeeEmployeeId] int  NOT NULL,
        [RentalPropertyRentalPropertyId] int  NOT NULL
    );
    GO
    
    -- --------------------------------------------------
    -- Creating all PRIMARY KEY constraints
    -- --------------------------------------------------
    
    -- Creating primary key on [EmployeeId] in table 'Employees'
    ALTER TABLE [Employees]
    ADD CONSTRAINT [PK_Employees]
        PRIMARY KEY CLUSTERED ([EmployeeId] ASC);
    GO
    
    -- Creating primary key on [RentalPropertyId] in table 'RentalProperties'
    ALTER TABLE [RentalProperties]
    ADD CONSTRAINT [PK_RentalProperties]
        PRIMARY KEY CLUSTERED ([RentalPropertyId] ASC);
    GO
    
    -- Creating primary key on [PaymentId] in table 'Payments'
    ALTER TABLE [Payments]
    ADD CONSTRAINT [PK_Payments]
        PRIMARY KEY CLUSTERED ([PaymentId] ASC);
    GO
    
    -- Creating primary key on [RentContractId] in table 'RentContracts'
    ALTER TABLE [RentContracts]
    ADD CONSTRAINT [PK_RentContracts]
        PRIMARY KEY CLUSTERED ([RentContractId] ASC);
    GO
    
    -- --------------------------------------------------
    -- Creating all FOREIGN KEY constraints
    -- --------------------------------------------------
    
    -- Creating foreign key on [EmployeeEmployeeId] in table 'RentContracts'
    ALTER TABLE [RentContracts]
    ADD CONSTRAINT [FK_EmployeeRentContract]
        FOREIGN KEY ([EmployeeEmployeeId])
        REFERENCES [Employees]
            ([EmployeeId])
        ON DELETE NO ACTION ON UPDATE NO ACTION;
    GO
    
    -- Creating non-clustered index for FOREIGN KEY 'FK_EmployeeRentContract'
    CREATE INDEX [IX_FK_EmployeeRentContract]
    ON [RentContracts]
        ([EmployeeEmployeeId]);
    GO
    
    -- Creating foreign key on [RentalPropertyRentalPropertyId] in table 'RentContracts'
    ALTER TABLE [RentContracts]
    ADD CONSTRAINT [FK_RentalPropertyRentContract]
        FOREIGN KEY ([RentalPropertyRentalPropertyId])
        REFERENCES [RentalProperties]
            ([RentalPropertyId])
        ON DELETE NO ACTION ON UPDATE NO ACTION;
    GO
    
    -- Creating non-clustered index for FOREIGN KEY 'FK_RentalPropertyRentContract'
    CREATE INDEX [IX_FK_RentalPropertyRentContract]
    ON [RentContracts]
        ([RentalPropertyRentalPropertyId]);
    GO
    
    -- Creating foreign key on [RentContractRentContractId] in table 'Payments'
    ALTER TABLE [Payments]
    ADD CONSTRAINT [FK_RentContractPayment]
        FOREIGN KEY ([RentContractRentContractId])
        REFERENCES [RentContracts]
            ([RentContractId])
        ON DELETE NO ACTION ON UPDATE NO ACTION;
    GO
    
    -- Creating non-clustered index for FOREIGN KEY 'FK_RentContractPayment'
    CREATE INDEX [IX_FK_RentContractPayment]
    ON [Payments]
        ([RentContractRentContractId]);
    GO
    
    -- Creating foreign key on [EmployeeEmployeeId] in table 'Payments'
    ALTER TABLE [Payments]
    ADD CONSTRAINT [FK_EmployeePayment]
        FOREIGN KEY ([EmployeeEmployeeId])
        REFERENCES [Employees]
            ([EmployeeId])
        ON DELETE NO ACTION ON UPDATE NO ACTION;
    GO
    
    -- Creating non-clustered index for FOREIGN KEY 'FK_EmployeePayment'
    CREATE INDEX [IX_FK_EmployeePayment]
    ON [Payments]
        ([EmployeeEmployeeId]);
    GO
    
    -- --------------------------------------------------
    -- Script has ended
    -- --------------------------------------------------
  14. On the toolbar of the Query window, click the Execute button Execute
  15. Close the Query window
  16. When asked whether you want to save, click No
  17. In the Solution Explorer, under Models and under PropertiesManagementModel.edmx, expand PropertiesManagementModel.tt
  18. Click Employee.cs
  19. Change the class as follows:
    //------------------------------------------------------------------------------
    // <auto-generated>
    //     This code was generated from a template.
    //
    //     Manual changes to this file may cause unexpected behavior in your application.
    //     Manual changes to this file will be overwritten if the code is regenerated.
    // </auto-generated>
    //------------------------------------------------------------------------------
    
    namespace PropertiesRentalManagement1.Models
    {
        using System.Collections.Generic;
        using System.ComponentModel.DataAnnotations;
        
        public partial class Employee
        {
            [System.Diagnostics.CodeAnalysis.SuppressMessage("Microsoft.Usage", "CA2214:DoNotCallOverridableMethodsInConstructors")]
            public Employee()
            {
                this.RentContracts = new HashSet<RentContract>();
                this.Payments = new HashSet<Payment>();
            }
    
            [Display(Name = "Employee Id")]
            public int EmployeeId { get; set; }
            [Display(Name = "Employee #")]
            public string EmployeeNumber { get; set; }
            [Display(Name = "First Name")]
            public string FirstName { get; set; }
            [Display(Name = "Last Name")]
            public string LastName { get; set; }
            [Display(Name = "Employment Title")]
            public string EmploymentTitle { get; set; }
    
            public string Identification
            {
                get
                {
                    return EmployeeId + " - " + EmployeeNumber + " - " + FirstName + " " + LastName + " (" + EmploymentTitle + ")";
                }
            }
        
            [System.Diagnostics.CodeAnalysis.SuppressMessage("Microsoft.Usage", "CA2227:CollectionPropertiesShouldBeReadOnly")]
            public virtual ICollection<RentContract> RentContracts { get; set; }
            [System.Diagnostics.CodeAnalysis.SuppressMessage("Microsoft.Usage", "CA2227:CollectionPropertiesShouldBeReadOnly")]
            public virtual ICollection<Payment> Payments { get; set; }
        }
    }
  20. In the Solution Explorer, under Models, click Payment.cs
  21. Change the class as follows:
    //------------------------------------------------------------------------------
    // <auto-generated>
    //     This code was generated from a template.
    //
    //     Manual changes to this file may cause unexpected behavior in your application.
    //     Manual changes to this file will be overwritten if the code is regenerated.
    // </auto-generated>
    //------------------------------------------------------------------------------
    
    namespace PropertiesRentalManagement1.Models
    {
        using System.ComponentModel.DataAnnotations;
        
        public partial class Payment
        {
            [Display(Name = "Payment Id")]
            public int PaymentId { get; set; }
            [Display(Name = "Receipt #")]
            public int ReceiptNumber { get; set; }
            [Display(Name = "Processed By")]
            public int EmployeeId { get; set; }
            [Display(Name = "Rent Contract")]
            public int RentContractId { get; set; }
            [Display(Name = "Payment Date")]
            public string PaymentDate { get; set; }
            [Display(Name = "Amount Paid")]
            public string AmountPaid { get; set; }
            public string Notes { get; set; }
    
            public int EmployeeEmployeeId { get; set; }
            public int RentContractRentContractId { get; set; }
        
            public virtual Employee Employee { get; set; }
            public virtual RentContract RentContract { get; set; }
        }
    }
  22. In the Solution Explorer, under Models, click RentalProperty.cs
  23. Change the class as follows:
    //------------------------------------------------------------------------------
    // <auto-generated>
    //     This code was generated from a template.
    //
    //     Manual changes to this file may cause unexpected behavior in your application.
    //     Manual changes to this file will be overwritten if the code is regenerated.
    // </auto-generated>
    //------------------------------------------------------------------------------
    
    namespace PropertiesRentalManagement1.Models
    {
        using System.Collections.Generic;
        using System.ComponentModel.DataAnnotations;
        
        public partial class RentalProperty
        {
            [System.Diagnostics.CodeAnalysis.SuppressMessage("Microsoft.Usage", "CA2214:DoNotCallOverridableMethodsInConstructors")]
            public RentalProperty()
            {
                this.Bedrooms = 0;
                this.MonthlyRate = 0;
                this.Bathrooms = 0.00m;
                this.SecurityDeposit = 0;
                this.PropertyType = "Unknown";
                this.OccupancyStatus = "Unknown";
                this.RentContracts = new HashSet<RentContract>();
            }
    
            [Display(Name = "Property Id")]
            public int RentalPropertyId { get; set; }
            [Display(Name = "Property #")]
            public string PropertyNumber { get; set; }
            [Display(Name = "Property Type")]
            public string PropertyType { get; set; }
            public string Address { get; set; }
            public string City { get; set; }
            public string State { get; set; }
            [Display(Name = "ZIP Code")]
            public string ZIPCode { get; set; }
            public int Bedrooms { get; set; }
            public decimal Bathrooms { get; set; }
            [Display(Name = "Monthly Rate")]
            public int MonthlyRate { get; set; }
            [Display(Name = "Security Deposit")]
            public Nullable<int> SecurityDeposit { get; set; }
            [Display(Name = "Occupancy Status")]
            public string OccupancyStatus { get; set; }
    
            public string Residence
            {
                get
                {
                    string beds = Bedrooms + " bedrooms";
                    string baths = Bathrooms + " bathrooms";
    
                    if (Bedrooms == 1)
                        beds = Bedrooms + " bedroom";
                    if (Bathrooms == 1)
                        baths = Bedrooms + " bathroom";
    
                    return RentalPropertyId + " - " + PropertyNumber + " - " + beds + ", " + baths + ", rent = " +
                           MonthlyRate.ToString() + "/month, deposit = " +
                           SecurityDeposit.ToString() + ", " + OccupancyStatus;
                }
            }
        
            [System.Diagnostics.CodeAnalysis.SuppressMessage("Microsoft.Usage", "CA2227:CollectionPropertiesShouldBeReadOnly")]
            public virtual ICollection<RentContract> RentContracts { get; set; }
        }
    }
  24. In the Solution Explorer, under Models, click RentContract.cs
  25. Change the class as follows:
    //------------------------------------------------------------------------------
    // <auto-generated>
    //     This code was generated from a template.
    //
    //     Manual changes to this file may cause unexpected behavior in your application.
    //     Manual changes to this file will be overwritten if the code is regenerated.
    // </auto-generated>
    //------------------------------------------------------------------------------
    
    namespace PropertiesRentalManagement1.Models
    {
        using System.Collections.Generic;
        using System.ComponentModel.DataAnnotations;
        
        public partial class RentContract
        {
            [System.Diagnostics.CodeAnalysis.SuppressMessage("Microsoft.Usage", "CA2214:DoNotCallOverridableMethodsInConstructors")]
            public RentContract()
            {
                this.NumberOfChildren = 0;
                this.MaritalStatus = "Unknown";
                this.Payments = new HashSet<Payment>();
            }
    
            [Display(Name = "Rent Contract Id")]
            public int RentContractId { get; set; }
            [Display(Name = "Contract #")]
            public int ContractNumber { get; set; }
            [Display(Name = "Contract Date")]
            public string ContractDate { get; set; }
            [Display(Name = "Created/Prepared By")]
            public int EmployeeId { get; set; }
            [Display(Name = "Tenant First Name")]
            public string TenantFirstName { get; set; }
            [Display(Name = "Tenant Last Name")]
            public string TenantLastName { get; set; }
            [Display(Name = "Marital Status")]
            public string MaritalStatus { get; set; }
            [Display(Name = "Number of Children")]
            public int NumberOfChildren { get; set; }
            [Display(Name = "Property/Residence")]
            public int RentalPropertyId { get; set; }
            [Display(Name = "Rent Start Date")]
            public string RentStartDate { get; set; }
    
            public string Description
            {
                get
                {
                    return RentContractId + " - " + ContractNumber + " - " + 
                           TenantFirstName + " " + TenantLastName + 
                           " (renting since " + RentStartDate + " for " + 
                           RentalProperty.MonthlyRate + "/Month)";
                }
            }
    
            public int EmployeeEmployeeId { get; set; }
            public int RentalPropertyRentalPropertyId { get; set; }
        
            public virtual Employee Employee { get; set; }
            public virtual RentalProperty RentalProperty { get; set; }
            [System.Diagnostics.CodeAnalysis.SuppressMessage("Microsoft.Usage", "CA2227:CollectionPropertiesShouldBeReadOnly")]
            public virtual ICollection<Payment> Payments { get; set; }
        }
    }
  26. To prepare the context, on the main menu, click Build -> Build Solution
  27. In the Solution Explorer, right-click Controllers -> Add -> Controller...
  28. In the middle list of the Add Scaffold dialog box, click MVC 5 Controller With Views, Using Entity Framework

    Add Scaffold

  29. Click Add
  30. In the Add Controller dialog box, click the arrow of the Model Class combo box and select Employee (PropertiesRentalManagement1.Models)
  31. Click the arrow of the Data Context Class combo box and select PropertiesManagementModelContainer (PropertiesRentalManagement1.Models)
  32. Click Add
  33. In the Solution Explorer, under Views and under Employees, double-click Create.cshtml
  34. Change the document as follows:
    @model PropertiesRentalManagement1.Models.Employee
    
    @{
        ViewBag.Title = "Create Employee";
    }
    
    <h2 class="bold blue common-font">Employment Application</h2>
    
    <hr />
    
    @using (Html.BeginForm())
    {
        @Html.AntiForgeryToken()
    
        <div class="form-horizontal common-font">
            @Html.ValidationSummary(true, "", new { @class = "text-danger" })
            <div class="form-group">
                @Html.LabelFor(model => model.EmployeeNumber, htmlAttributes: new { @class = "control-label col-md-2" })
                <div class="col-md-10">
                    @Html.EditorFor(model => model.EmployeeNumber, new { htmlAttributes = new { @class = "form-control" } })
                    @Html.ValidationMessageFor(model => model.EmployeeNumber, "", new { @class = "text-danger" })
                </div>
            </div>
    
            <div class="form-group">
                @Html.LabelFor(model => model.FirstName, htmlAttributes: new { @class = "control-label col-md-2" })
                <div class="col-md-10">
                    @Html.EditorFor(model => model.FirstName, new { htmlAttributes = new { @class = "form-control" } })
                    @Html.ValidationMessageFor(model => model.FirstName, "", new { @class = "text-danger" })
                </div>
            </div>
    
            <div class="form-group">
                @Html.LabelFor(model => model.LastName, htmlAttributes: new { @class = "control-label col-md-2" })
                <div class="col-md-10">
                    @Html.EditorFor(model => model.LastName, new { htmlAttributes = new { @class = "form-control" } })
                    @Html.ValidationMessageFor(model => model.LastName, "", new { @class = "text-danger" })
                </div>
            </div>
    
            <div class="form-group">
                @Html.LabelFor(model => model.EmploymentTitle, htmlAttributes: new { @class = "control-label col-md-2" })
                <div class="col-md-10">
                    @Html.EditorFor(model => model.EmploymentTitle, new { htmlAttributes = new { @class = "form-control" } })
                    @Html.ValidationMessageFor(model => model.EmploymentTitle, "", new { @class = "text-danger" })
                </div>
            </div>
    
            <div class="form-group">
                <label class="control-label col-md-2">
                    @Html.ActionLink("Employees - Staff Members", "Index")
                </label>
                <div class="col-md-10">
                    <input type="submit" value="Save Employee Record" class="btn btn-primary" />
                </div>
            </div>
        </div>
    }
    
    @section Scripts {
        @Scripts.Render("~/bundles/jqueryval")
    }
  35. In the Solution Explorer, under Views and under Employees, double-click Delete.cshtml
  36. Change the document as follows:
    @model PropertiesRentalManagement1.Models.Employee
    
    @{
        ViewBag.Title = "Delete Employee";
    }
    
    <h2 class="bold common-font blue">Delete Employee Record</h2>
    
    <hr />
    
    <h3 class="common-font blue">Are you sure you want to delete this employee's record?</h3>
    
    <div>
        <dl class="dl-horizontal common-font">
            <dt>@Html.DisplayNameFor(model => model.EmployeeId)</dt>
            <dd>@Html.DisplayFor(model => model.EmployeeId)</dd>
    
            <dt>@Html.DisplayNameFor(model => model.EmployeeNumber)</dt>
            <dd>@Html.DisplayFor(model => model.EmployeeNumber)</dd>
    
            <dt>@Html.DisplayNameFor(model => model.FirstName)</dt>
            <dd>@Html.DisplayFor(model => model.FirstName)</dd>
    
            <dt>@Html.DisplayNameFor(model => model.LastName)</dt>
            <dd>@Html.DisplayFor(model => model.LastName)</dd>
    
            <dt>@Html.DisplayNameFor(model => model.EmploymentTitle)</dt>
            <dd>@Html.DisplayFor(model => model.EmploymentTitle)</dd>
        </dl>
    
        @using (Html.BeginForm())
        {
            @Html.AntiForgeryToken()
    
            <div class="form-actions no-color">
                <input type="submit" value="Delete Employee" class="btn btn-primary" /> |
                @Html.ActionLink("Employees - Staff Members", "Index", null, htmlAttributes: new { @class = "btn btn-primary" })
            </div>
        }
    </div>
  37. In the Solution Explorer, under Views and under Employees, double-click Details.cshtml
  38. Change the document as follows:
    @model PropertiesRentalManagement1.Models.Employee
    
    @{
        ViewBag.Title = "Employee Details";
    }
    
    <h2 class="bold common-font blue">Employee Details</h2>
    
    <hr />
    
    <div>
        <dl class="dl-horizontal common-font">
            <dt>@Html.DisplayNameFor(model => model.EmployeeId)</dt>
            <dd>@Html.DisplayFor(model => model.EmployeeId)</dd>
    
            <dt>@Html.DisplayNameFor(model => model.EmployeeNumber)</dt>
            <dd>@Html.DisplayFor(model => model.EmployeeNumber)</dd>
    
            <dt>@Html.DisplayNameFor(model => model.FirstName)</dt>
            <dd>@Html.DisplayFor(model => model.FirstName)</dd>
    
            <dt>@Html.DisplayNameFor(model => model.LastName)</dt>
            <dd>@Html.DisplayFor(model => model.LastName)</dd>
    
            <dt>@Html.DisplayNameFor(model => model.EmploymentTitle)</dt>
            <dd>@Html.DisplayFor(model => model.EmploymentTitle)</dd>
        </dl>
    </div>
    
    <p>
        @Html.ActionLink("Edit Employee Record", "Edit", new { id = Model.EmployeeId }) |
        @Html.ActionLink("Employees - Staff Members", "Index")
    </p>
  39. In the Solution Explorer, under Views and under Employees, double-click Edit.cshtml
  40. Change the document as follows:
    @model PropertiesRentalManagement1.Models.Employee
    
    @{
        ViewBag.Title = "Edit Employee";
    }
    
    <h2 class="bold blue common-font">Edit/Update Employee Record</h2>
    
    <hr />
    
    @using (Html.BeginForm())
    {
        @Html.AntiForgeryToken()
    
        <div class="form-horizontal common-font">
            @Html.ValidationSummary(true, "", new { @class = "text-danger" })
            @Html.HiddenFor(model => model.EmployeeId)
    
            <div class="form-group">
                @Html.LabelFor(model => model.EmployeeNumber, htmlAttributes: new { @class = "control-label col-md-2" })
                <div class="col-md-10">
                    @Html.EditorFor(model => model.EmployeeNumber, new { htmlAttributes = new { @class = "form-control" } })
                    @Html.ValidationMessageFor(model => model.EmployeeNumber, "", new { @class = "text-danger" })
                </div>
            </div>
    
            <div class="form-group">
                @Html.LabelFor(model => model.FirstName, htmlAttributes: new { @class = "control-label col-md-2" })
                <div class="col-md-10">
                    @Html.EditorFor(model => model.FirstName, new { htmlAttributes = new { @class = "form-control" } })
                    @Html.ValidationMessageFor(model => model.FirstName, "", new { @class = "text-danger" })
                </div>
            </div>
    
            <div class="form-group">
                @Html.LabelFor(model => model.LastName, htmlAttributes: new { @class = "control-label col-md-2" })
                <div class="col-md-10">
                    @Html.EditorFor(model => model.LastName, new { htmlAttributes = new { @class = "form-control" } })
                    @Html.ValidationMessageFor(model => model.LastName, "", new { @class = "text-danger" })
                </div>
            </div>
    
            <div class="form-group">
                @Html.LabelFor(model => model.EmploymentTitle, htmlAttributes: new { @class = "control-label col-md-2" })
                <div class="col-md-10">
                    @Html.EditorFor(model => model.EmploymentTitle, new { htmlAttributes = new { @class = "form-control" } })
                    @Html.ValidationMessageFor(model => model.EmploymentTitle, "", new { @class = "text-danger" })
                </div>
            </div>
    
            <div class="form-group">
                <label class="control-label col-md-2">
                    @Html.ActionLink("Employees - Staff Members", "Index")
                </label>
                <div class="col-md-10">
                    <input type="submit" value="Update this Record" class="btn btn-primary" />
                </div>
            </div>
        </div>
    }
    
    @section Scripts {
        @Scripts.Render("~/bundles/jqueryval")
    }
  41. In the Solution Explorer, under Views and under Employees, double-click Index.cshtml
  42. Change the document as follows:
    @model IEnumerable<PropertiesRentalManagement1.Models.Employee>
    
    @{
        ViewBag.Title = "Employees";
    }
    
    <h2 class="bold blue common-font text-center">Employees - Staff Members</h2>
    
    <table class="table table-hover common-font">
        <tr>
            <th class="text-center">@Html.DisplayNameFor(model => model.EmployeeId)</th>
            <th class="text-center">@Html.DisplayNameFor(model => model.EmployeeNumber)</th>
            <th>@Html.DisplayNameFor(model => model.FirstName)</th>
            <th>@Html.DisplayNameFor(model => model.LastName)</th>
            <th>@Html.DisplayNameFor(model => model.EmploymentTitle)</th>
            <th>@Html.ActionLink("Hire New Employee", "Create")</th>
        </tr>
    
        @foreach (var item in Model)
        {
            <tr>
                <td class="text-center">@Html.DisplayFor(modelItem => item.EmployeeId)</td>
                <td class="text-center">@Html.DisplayFor(modelItem => item.EmployeeNumber)</td>
                <td>@Html.DisplayFor(modelItem => item.FirstName)</td>
                <td>@Html.DisplayFor(modelItem => item.LastName)</td>
                <td>@Html.DisplayFor(modelItem => item.EmploymentTitle)</td>
                <td>
                    @Html.ActionLink("Edit", "Edit", new { id = item.EmployeeId }) |
                    @Html.ActionLink("Details", "Details", new { id = item.EmployeeId }) |
                    @Html.ActionLink("Delete", "Delete", new { id = item.EmployeeId })
                </td>
            </tr>
        }
    </table>
  43. In the Solution Explorer, right-click Controllers -> Add -> New Scaffolded Item...
  44. In the middle list of the Add Scaffold dialog box, click MVC 5 Controller With Views, Using Entity Framework

    Add Scaffold

  45. Click Add
  46. In the Model Class combo box, select RentalProperty (PropertiesRentalManagement1.Models)
  47. Make sure the Data Context Class combo box is displaying PropertiesManagementModelContainer (PropertiesRentalManagement1.Models). Click Add
  48. Change the RentalPropertiesController class as follows:
    using PropertiesRentalManagement1.Models;
    using System;
    using System.Collections.Generic;
    using System.Data.Entity;
    using System.Linq;
    using System.Net;
    using System.Web.Mvc;
    
    namespace PropertiesRentalManagement1.Controllers
    {
        public class RentalPropertiesController : Controller
        {
            private PropertiesManagementModelContainer db = new PropertiesManagementModelContainer();
    
            // GET: RentalProperties
            public ActionResult Index()
            {
                return View(db.RentalProperties.ToList());
            }
    
            // GET: RentalProperties/Details/5
            public ActionResult Details(int? id)
            {
                if (id == null)
                {
                    return new HttpStatusCodeResult(HttpStatusCode.BadRequest);
                }
                RentalProperty rentalProperty = db.RentalProperties.Find(id);
                if (rentalProperty == null)
                {
                    return HttpNotFound();
                }
                return View(rentalProperty);
            }
    
            // GET: RentalProperties/Create
            public ActionResult Create()
            {
                Random rndNumber = new Random();
    
                ViewData["PropertyNumber"] = rndNumber.Next(1000001, 9999999);
    
                List<SelectListItem> types = new List<SelectListItem>();
    
                types.Add(new SelectListItem() { Text = "Unknown",       Value = "Unknown"       });
                types.Add(new SelectListItem() { Text = "Apartment",     Value = "Apartment"     });
                types.Add(new SelectListItem() { Text = "Townhouse",     Value = "Townhouse"     });
                types.Add(new SelectListItem() { Text = "Condominium",   Value = "Condominium"   });
                types.Add(new SelectListItem() { Text = "Single Family", Value = "Single Family" });
    
                List<SelectListItem> conditions = new List<SelectListItem>
                {
                    new SelectListItem() { Text = "Unknown",           Value = "Unknown"           },
                    new SelectListItem() { Text = "Occupied",          Value = "Occupied"          },
                    new SelectListItem() { Text = "Available",         Value = "Available"         },
                    new SelectListItem() { Text = "Not Ready",         Value = "Not Ready"         },
                    new SelectListItem() { Text = "Needs Maintenance", Value = "Needs Maintenance" }
                };
    
                ViewData["PropertyType"] = types;
                ViewData["OccupancyStatus"] = conditions;
                return View();
            }
    
            // POST: RentalProperties/Create
            // To protect from overposting attacks, please enable the specific properties you want to bind to, for 
            // more details see https://go.microsoft.com/fwlink/?LinkId=317598.
            [HttpPost]
            [ValidateAntiForgeryToken]
            public ActionResult Create([Bind(Include = "RentalPropertyId,PropertyNumber,PropertyType,Address,City,State,ZIPCode,Bedrooms,Bathrooms,MonthlyRate,SecurityDeposit,OccupancyStatus")] RentalProperty rentalProperty)
            {
                if (ModelState.IsValid)
                {
                    db.RentalProperties.Add(rentalProperty);
                    db.SaveChanges();
                    return RedirectToAction("Index");
                }
    
                return View(rentalProperty);
            }
    
            // GET: RentalProperties/Edit/5
            public ActionResult Edit(int? id)
            {
                if (id == null)
                {
                    return new HttpStatusCodeResult(HttpStatusCode.BadRequest);
                }
                RentalProperty rentalProperty = db.RentalProperties.Find(id);
                if (rentalProperty == null)
                {
                    return HttpNotFound();
                }
    
                List<SelectListItem> types = new List<SelectListItem>();
    
                types.Add(new SelectListItem() { Text = "Unknown",       Value = "Unknown",       Selected = (rentalProperty.PropertyType == "Unknown")       });
                types.Add(new SelectListItem() { Text = "Apartment",     Value = "Apartment",     Selected = (rentalProperty.PropertyType == "Apartment")     });
                types.Add(new SelectListItem() { Text = "Townhouse",     Value = "Townhouse",     Selected = (rentalProperty.PropertyType == "Townhouse")     });
                types.Add(new SelectListItem() { Text = "Condominium",   Value = "Condominium",   Selected = (rentalProperty.PropertyType == "Condominium")   });
                types.Add(new SelectListItem() { Text = "Single Family", Value = "Single Family", Selected = (rentalProperty.PropertyType == "Single Family") });
    
                List<SelectListItem> conditions = new List<SelectListItem>
                {
                    new SelectListItem() { Text = "Unknown",           Value = "Unknown",           Selected = (rentalProperty.OccupancyStatus == "Unknown")           },
                    new SelectListItem() { Text = "Occupied",          Value = "Occupied",          Selected = (rentalProperty.OccupancyStatus == "Occupied")          },
                    new SelectListItem() { Text = "Available",         Value = "Available",         Selected = (rentalProperty.OccupancyStatus == "Available")         },
                    new SelectListItem() { Text = "Not Ready",         Value = "Not Ready",         Selected = (rentalProperty.OccupancyStatus == "Not Ready")         },
                    new SelectListItem() { Text = "Needs Maintenance", Value = "Needs Maintenance", Selected = (rentalProperty.OccupancyStatus == "Needs Maintenance") }
                };
    
                ViewData["PropertyType"] = types;
                ViewData["OccupancyStatus"] = conditions;
    
                return View(rentalProperty);
            }
    
            // POST: RentalProperties/Edit/5
            // To protect from overposting attacks, please enable the specific properties you want to bind to, for 
            // more details see https://go.microsoft.com/fwlink/?LinkId=317598.
            [HttpPost]
            [ValidateAntiForgeryToken]
            public ActionResult Edit([Bind(Include = "RentalPropertyId,PropertyNumber,PropertyType,Address,City,State,ZIPCode,Bedrooms,Bathrooms,MonthlyRate,SecurityDeposit,OccupancyStatus")] RentalProperty rentalProperty)
            {
                if (ModelState.IsValid)
                {
                    db.Entry(rentalProperty).State = EntityState.Modified;
                    db.SaveChanges();
                    return RedirectToAction("Index");
                }
                return View(rentalProperty);
            }
    
            // GET: RentalProperties/Delete/5
            public ActionResult Delete(int? id)
            {
                if (id == null)
                {
                    return new HttpStatusCodeResult(HttpStatusCode.BadRequest);
                }
                RentalProperty rentalProperty = db.RentalProperties.Find(id);
                if (rentalProperty == null)
                {
                    return HttpNotFound();
                }
                return View(rentalProperty);
            }
    
            // POST: RentalProperties/Delete/5
            [HttpPost, ActionName("Delete")]
            [ValidateAntiForgeryToken]
            public ActionResult DeleteConfirmed(int id)
            {
                RentalProperty rentalProperty = db.RentalProperties.Find(id);
                db.RentalProperties.Remove(rentalProperty);
                db.SaveChanges();
                return RedirectToAction("Index");
            }
    
            protected override void Dispose(bool disposing)
            {
                if (disposing)
                {
                    db.Dispose();
                }
                base.Dispose(disposing);
            }
        }
    }
  49. In the class, right-click Index() and click Go To View...
  50. Change the webpage as follows:
    @model IEnumerable<PropertiesRentalManagement1.Models.RentalProperty>
    
    @{
        ViewBag.Title = "Rental Properties";
    }
    
    <h2 class="bold blue common-font text-center">Rental Properties</h2>
    
    <table class="table table-hover common-font">
        <tr>
            <th class="text-center">@Html.DisplayNameFor(model => model.RentalPropertyId)</th>
            <th class="text-center">@Html.DisplayNameFor(model => model.PropertyNumber)</th>
            <th>@Html.DisplayNameFor(model => model.PropertyType)</th>
            <th>@Html.DisplayNameFor(model => model.Address)</th>
            <th>@Html.DisplayNameFor(model => model.City)</th>
            <th>@Html.DisplayNameFor(model => model.State)</th>
            <th>@Html.DisplayNameFor(model => model.ZIPCode)</th>
            <th>@Html.DisplayNameFor(model => model.Bedrooms)</th>
            <th>@Html.DisplayNameFor(model => model.Bathrooms)</th>
            <th>@Html.DisplayNameFor(model => model.MonthlyRate)</th>
            <th>@Html.DisplayNameFor(model => model.SecurityDeposit)</th>
            <th>@Html.DisplayNameFor(model => model.OccupancyStatus)</th>
            <th>@Html.ActionLink("Set Up Rental Property", "Create")</th>
        </tr>
    
    @foreach (var item in Model) {
        <tr>
            <td class="text-center">@Html.DisplayFor(modelItem => item.RentalPropertyId)</td>
            <td class="text-center">@Html.DisplayFor(modelItem => item.PropertyNumber)</td>
            <td>@Html.DisplayFor(modelItem => item.PropertyType)</td>
            <td>@Html.DisplayFor(modelItem => item.Address)</td>
            <td>@Html.DisplayFor(modelItem => item.City)</td>
            <td>@Html.DisplayFor(modelItem => item.State)</td>
            <td>@Html.DisplayFor(modelItem => item.ZIPCode)</td>
            <td>@Html.DisplayFor(modelItem => item.Bedrooms)</td>
            <td>@Html.DisplayFor(modelItem => item.Bathrooms)</td>
            <td>@Html.DisplayFor(modelItem => item.MonthlyRate)</td>
            <td>@Html.DisplayFor(modelItem => item.SecurityDeposit)</td>
            <td>@Html.DisplayFor(modelItem => item.OccupancyStatus)</td>
            <td>
                @Html.ActionLink("Edit", "Edit", new { id = item.RentalPropertyId }) |
                @Html.ActionLink("Details", "Details", new { id = item.RentalPropertyId }) |
                @Html.ActionLink("Delete", "Delete", new { id = item.RentalPropertyId })
            </td>
        </tr>
    }
    </table>
  51. In the Solution Explorer, under Views and under RentalProperties, double-click Create.cshtml
  52. Change the form as follows:
    @model PropertiesRentalManagement1.Models.RentalProperty
    
    @{
        ViewBag.Title = "Create Rental Property";
    }
    
    <h2 class="bold blue common-font">Rental Property Setup</h2>
    
    <hr />
    
    @using (Html.BeginForm())
    {
        @Html.AntiForgeryToken()
    
        <div class="form-horizontal common-font">
            @Html.ValidationSummary(true, "", new { @class = "text-danger" })
            <div class="form-group">
                @Html.LabelFor(model => model.PropertyNumber, htmlAttributes: new { @class = "control-label col-md-2" })
                <div class="col-md-10">
                    @Html.TextBox("PropertyNumber", null, htmlAttributes: new { @class = "form-control" })
                    @Html.ValidationMessageFor(model => model.PropertyNumber, "", new { @class = "text-danger" })
                </div>
            </div>
    
            <div class="form-group">
                @Html.LabelFor(model => model.PropertyType, htmlAttributes: new { @class = "control-label col-md-2" })
                <div class="col-md-10">
                    @Html.DropDownList("PropertyType", null, htmlAttributes: new { @class = "form-control" })
                    @Html.ValidationMessageFor(model => model.PropertyType, "", new { @class = "text-danger" })
                </div>
            </div>
    
            <div class="form-group">
                @Html.LabelFor(model => model.Address, htmlAttributes: new { @class = "control-label col-md-2" })
                <div class="col-md-10">
                    @Html.EditorFor(model => model.Address, new { htmlAttributes = new { @class = "form-control" } })
                    @Html.ValidationMessageFor(model => model.Address, "", new { @class = "text-danger" })
                </div>
            </div>
    
            <div class="form-group">
                @Html.LabelFor(model => model.City, htmlAttributes: new { @class = "control-label col-md-2" })
                <div class="col-md-10">
                    @Html.EditorFor(model => model.City, new { htmlAttributes = new { @class = "form-control" } })
                    @Html.ValidationMessageFor(model => model.City, "", new { @class = "text-danger" })
                </div>
            </div>
    
            <div class="form-group">
                @Html.LabelFor(model => model.State, htmlAttributes: new { @class = "control-label col-md-2" })
                <div class="col-md-10">
                    @Html.EditorFor(model => model.State, new { htmlAttributes = new { @class = "form-control" } })
                    @Html.ValidationMessageFor(model => model.State, "", new { @class = "text-danger" })
                </div>
            </div>
    
            <div class="form-group">
                @Html.LabelFor(model => model.ZIPCode, htmlAttributes: new { @class = "control-label col-md-2" })
                <div class="col-md-10">
                    @Html.EditorFor(model => model.ZIPCode, new { htmlAttributes = new { @class = "form-control" } })
                    @Html.ValidationMessageFor(model => model.ZIPCode, "", new { @class = "text-danger" })
                </div>
            </div>
    
            <div class="form-group">
                @Html.LabelFor(model => model.Bedrooms, htmlAttributes: new { @class = "control-label col-md-2" })
                <div class="col-md-10">
                    @Html.EditorFor(model => model.Bedrooms, new { htmlAttributes = new { @class = "form-control" } })
                    @Html.ValidationMessageFor(model => model.Bedrooms, "", new { @class = "text-danger" })
                </div>
            </div>
    
            <div class="form-group">
                @Html.LabelFor(model => model.Bathrooms, htmlAttributes: new { @class = "control-label col-md-2" })
                <div class="col-md-10">
                    @Html.EditorFor(model => model.Bathrooms, new { htmlAttributes = new { @class = "form-control" } })
                    @Html.ValidationMessageFor(model => model.Bathrooms, "", new { @class = "text-danger" })
                </div>
            </div>
    
            <div class="form-group">
                @Html.LabelFor(model => model.MonthlyRate, htmlAttributes: new { @class = "control-label col-md-2" })
                <div class="col-md-10">
                    @Html.EditorFor(model => model.MonthlyRate, new { htmlAttributes = new { @class = "form-control" } })
                    @Html.ValidationMessageFor(model => model.MonthlyRate, "", new { @class = "text-danger" })
                </div>
            </div>
    
            <div class="form-group">
                @Html.LabelFor(model => model.SecurityDeposit, htmlAttributes: new { @class = "control-label col-md-2" })
                <div class="col-md-10">
                    @Html.EditorFor(model => model.SecurityDeposit, new { htmlAttributes = new { @class = "form-control" } })
                    @Html.ValidationMessageFor(model => model.SecurityDeposit, "", new { @class = "text-danger" })
                </div>
            </div>
    
            <div class="form-group">
                @Html.LabelFor(model => model.OccupancyStatus, htmlAttributes: new { @class = "control-label col-md-2" })
                <div class="col-md-10">
                    @Html.DropDownList("OccupancyStatus", null, htmlAttributes: new { @class = "form-control" })
                    @Html.ValidationMessageFor(model => model.OccupancyStatus, "", new { @class = "text-danger" })
                </div>
            </div>
    
            <div class="form-group">
                <label class="control-label col-md-2">
                    @Html.ActionLink("Rental Properties", "Index")
                </label>
                <div class="col-md-10">
                    <input type="submit" value="Save Rental Property" class="btn btn-primary" />
                </div>
            </div>
        </div>
    }
    
    @section Scripts {
        @Scripts.Render("~/bundles/jqueryval")
    }
  53. Click the RentalPropertiesController.cs tab
  54. In the class, right-click Details() and click Go To View
  55. Change the document as follows:
    @model PropertiesRentalManagement1.Models.RentalProperty
    
    @{
        ViewBag.Title = "Rental Property Details";
    }
    
    <h2 class="bold common-font blue">Rental Property Details</h2>
    
    <hr />
    
    <div>
        <dl class="dl-horizontal common-font">
            <dt>@Html.DisplayNameFor(model => model.RentalPropertyId)</dt>
            <dd>@Html.DisplayFor(model => model.RentalPropertyId)</dd>
    
            <dt>@Html.DisplayNameFor(model => model.PropertyNumber)</dt>
            <dd>@Html.DisplayFor(model => model.PropertyNumber)</dd>
    
            <dt>@Html.DisplayNameFor(model => model.PropertyType)</dt>
            <dd>@Html.DisplayFor(model => model.PropertyType)</dd>
    
            <dt>@Html.DisplayNameFor(model => model.Address)</dt>
            <dd>@Html.DisplayFor(model => model.Address)</dd>
    
            <dt>@Html.DisplayNameFor(model => model.City)</dt>
            <dd>@Html.DisplayFor(model => model.City)</dd>
    
            <dt>@Html.DisplayNameFor(model => model.State)</dt>
            <dd>@Html.DisplayFor(model => model.State)</dd>
    
            <dt>@Html.DisplayNameFor(model => model.ZIPCode)</dt>
            <dd>@Html.DisplayFor(model => model.ZIPCode)</dd>
    
            <dt>@Html.DisplayNameFor(model => model.Bedrooms)</dt>
            <dd>@Html.DisplayFor(model => model.Bedrooms)</dd>
    
            <dt>@Html.DisplayNameFor(model => model.Bathrooms)</dt>
            <dd>@Html.DisplayFor(model => model.Bathrooms)</dd>
    
            <dt>@Html.DisplayNameFor(model => model.MonthlyRate)</dt>
            <dd>@Html.DisplayFor(model => model.MonthlyRate)</dd>
    
            <dt>@Html.DisplayNameFor(model => model.SecurityDeposit)</dt>
            <dd>@Html.DisplayFor(model => model.SecurityDeposit)</dd>
    
            <dt>@Html.DisplayNameFor(model => model.OccupancyStatus)</dt>
            <dd>@Html.DisplayFor(model => model.OccupancyStatus)</dd>
        </dl>
    </div>
    <p>
        @Html.ActionLink("Update this Property Details", "Edit", new { id = Model.RentalPropertyId }) |
        @Html.ActionLink("Rental Properties", "Index")
    </p>
  56. In the Solution Explorer, under Views and under RentalProperties, double-click Delete.cshtml
  57. Change the document as follows:
    @model PropertiesRentalManagement1.Models.RentalProperty
    
    @{
        ViewBag.Title = "Delete Rental Property";
    }
    
    <h2 class="bold common-font blue">Delete Rental Property</h2>
    
    <hr />
    
    <h3 class="common-font blue">Are you sure you want to delete/suspend this?</h3>
    
    <div>
        <dl class="dl-horizontal common-font">
            <dt> @Html.DisplayNameFor(model => model.RentalPropertyId)</dt>
            <dd>@Html.DisplayFor(model => model.RentalPropertyId)</dd>
    
            <dt> @Html.DisplayNameFor(model => model.PropertyNumber)</dt>
            <dd>@Html.DisplayFor(model => model.PropertyNumber)</dd>
    
            <dt>@Html.DisplayNameFor(model => model.PropertyType)</dt>
            <dd>@Html.DisplayFor(model => model.PropertyType)</dd>
    
            <dt>@Html.DisplayNameFor(model => model.Address)</dt>
            <dd>@Html.DisplayFor(model => model.Address)</dd>
    
            <dt>@Html.DisplayNameFor(model => model.City)</dt>
            <dd>@Html.DisplayFor(model => model.City)</dd>
    
            <dt>@Html.DisplayNameFor(model => model.State)</dt>
            <dd>@Html.DisplayFor(model => model.State)</dd>
    
            <dt>@Html.DisplayNameFor(model => model.ZIPCode)</dt>
            <dd>@Html.DisplayFor(model => model.ZIPCode)</dd>
    
            <dt>@Html.DisplayNameFor(model => model.Bedrooms)</dt>
            <dd>@Html.DisplayFor(model => model.Bedrooms)</dd>
    
            <dt>@Html.DisplayNameFor(model => model.Bathrooms)</dt>
            <dd>@Html.DisplayFor(model => model.Bathrooms)</dd>
    
            <dt>@Html.DisplayNameFor(model => model.MonthlyRate)</dt>
            <dd>@Html.DisplayFor(model => model.MonthlyRate)</dd>
    
            <dt>@Html.DisplayNameFor(model => model.SecurityDeposit)</dt>
            <dd>@Html.DisplayFor(model => model.SecurityDeposit)</dd>
    
            <dt>@Html.DisplayNameFor(model => model.OccupancyStatus)</dt>
            <dd>@Html.DisplayFor(model => model.OccupancyStatus)</dd>
        </dl>
    
        @using (Html.BeginForm())
        {
            @Html.AntiForgeryToken()
    
            <div class="form-actions no-color">
                <input type="submit" value="Delete this Property" class="btn btn-primary" /> |
                @Html.ActionLink("Rental Properties", "Index", null, htmlAttributes: new { @class = "btn btn-primary" })
            </div>
        }
    </div>
  58. In the Solution Explorer, under Views and under RentalProperties, double-click Edit.cshtml
  59. Change the docucment as follows:
    @model PropertiesRentalManagement1.Models.RentalProperty
    
    @{
        ViewBag.Title = "Edit Rental Property";
    }
    
    <h2 class="bold blue common-font">Edit/Update Rental Property</h2>
    
    <hr />
    
    @using (Html.BeginForm())
    {
        @Html.AntiForgeryToken()
    
        <div class="form-horizontal common-font">
            @Html.ValidationSummary(true, "", new { @class = "text-danger" })
            @Html.HiddenFor(model => model.RentalPropertyId)
    
            <div class="form-group">
                @Html.LabelFor(model => model.PropertyNumber, htmlAttributes: new { @class = "control-label col-md-2" })
                <div class="col-md-10">
                    @Html.EditorFor(model => model.PropertyNumber, new { htmlAttributes = new { @class = "form-control" } })
                    @Html.ValidationMessageFor(model => model.PropertyNumber, "", new { @class = "text-danger" })
                </div>
            </div>
    
            <div class="form-group">
                @Html.LabelFor(model => model.PropertyType, htmlAttributes: new { @class = "control-label col-md-2" })
                <div class="col-md-10">
                    @Html.DropDownList("PropertyType", null, htmlAttributes: new { @class = "form-control" })
                    @Html.ValidationMessageFor(model => model.PropertyType, "", new { @class = "text-danger" })
                </div>
            </div>
    
            <div class="form-group">
                @Html.LabelFor(model => model.Address, htmlAttributes: new { @class = "control-label col-md-2" })
                <div class="col-md-10">
                    @Html.EditorFor(model => model.Address, new { htmlAttributes = new { @class = "form-control" } })
                    @Html.ValidationMessageFor(model => model.Address, "", new { @class = "text-danger" })
                </div>
            </div>
    
            <div class="form-group">
                @Html.LabelFor(model => model.City, htmlAttributes: new { @class = "control-label col-md-2" })
                <div class="col-md-10">
                    @Html.EditorFor(model => model.City, new { htmlAttributes = new { @class = "form-control" } })
                    @Html.ValidationMessageFor(model => model.City, "", new { @class = "text-danger" })
                </div>
            </div>
    
            <div class="form-group">
                @Html.LabelFor(model => model.State, htmlAttributes: new { @class = "control-label col-md-2" })
                <div class="col-md-10">
                    @Html.EditorFor(model => model.State, new { htmlAttributes = new { @class = "form-control" } })
                    @Html.ValidationMessageFor(model => model.State, "", new { @class = "text-danger" })
                </div>
            </div>
    
            <div class="form-group">
                @Html.LabelFor(model => model.ZIPCode, htmlAttributes: new { @class = "control-label col-md-2" })
                <div class="col-md-10">
                    @Html.EditorFor(model => model.ZIPCode, new { htmlAttributes = new { @class = "form-control" } })
                    @Html.ValidationMessageFor(model => model.ZIPCode, "", new { @class = "text-danger" })
                </div>
            </div>
    
            <div class="form-group">
                @Html.LabelFor(model => model.Bedrooms, htmlAttributes: new { @class = "control-label col-md-2" })
                <div class="col-md-10">
                    @Html.EditorFor(model => model.Bedrooms, new { htmlAttributes = new { @class = "form-control" } })
                    @Html.ValidationMessageFor(model => model.Bedrooms, "", new { @class = "text-danger" })
                </div>
            </div>
    
            <div class="form-group">
                @Html.LabelFor(model => model.Bathrooms, htmlAttributes: new { @class = "control-label col-md-2" })
                <div class="col-md-10">
                    @Html.EditorFor(model => model.Bathrooms, new { htmlAttributes = new { @class = "form-control" } })
                    @Html.ValidationMessageFor(model => model.Bathrooms, "", new { @class = "text-danger" })
                </div>
            </div>
    
            <div class="form-group">
                @Html.LabelFor(model => model.MonthlyRate, htmlAttributes: new { @class = "control-label col-md-2" })
                <div class="col-md-10">
                    @Html.EditorFor(model => model.MonthlyRate, new { htmlAttributes = new { @class = "form-control" } })
                    @Html.ValidationMessageFor(model => model.MonthlyRate, "", new { @class = "text-danger" })
                </div>
            </div>
    
            <div class="form-group">
                @Html.LabelFor(model => model.SecurityDeposit, htmlAttributes: new { @class = "control-label col-md-2" })
                <div class="col-md-10">
                    @Html.EditorFor(model => model.SecurityDeposit, new { htmlAttributes = new { @class = "form-control" } })
                    @Html.ValidationMessageFor(model => model.SecurityDeposit, "", new { @class = "text-danger" })
                </div>
            </div>
    
            <div class="form-group">
                @Html.LabelFor(model => model.OccupancyStatus, htmlAttributes: new { @class = "control-label col-md-2" })
                <div class="col-md-10">
                    @Html.DropDownList("OccupancyStatus", null, htmlAttributes: new { @class = "form-control" })
                    @Html.ValidationMessageFor(model => model.OccupancyStatus, "", new { @class = "text-danger" })
                </div>
            </div>
    
            <div class="form-group">
                <label class="control-label col-md-2">
                    @Html.ActionLink("Rental Properties", "Index")
                </label>
                <div class="col-md-10">
                    <input type="submit" value="Update Rental Property" class="btn btn-primary" />
                </div>
            </div>
        </div>
    }
    
    @section Scripts {
        @Scripts.Render("~/bundles/jqueryval")
    }
  60. In the Solution Explorer, right-click Controllers -> Add -> Controller...
  61. In the middle list of the Add Scaffold dialog box, make sure MVC 5 Controller With Views, Using Entity Framework is selected. Click Add
  62. In the Model Class combo box, select RentContract (PropertiesRentalManagement1.Models)
  63. Make sure the Data Context Class combo box is displaying PropertiesManagementModelContainer (PropertiesRentalManagement1.Models). Click Add
  64. Change the RentContractsController class as follows:
    using PropertiesRentalManagement1.Models;
    using System;
    using System.Collections.Generic;
    using System.Data.Entity;
    using System.Linq;
    using System.Net;
    using System.Web.Mvc;
    
    namespace PropertiesRentalManagement1.Controllers
    {
        public class RentContractsController : Controller
        {
            private PropertiesManagementModelContainer db = new PropertiesManagementModelContainer();
    
            // GET: RentContracts
            public ActionResult Index()
            {
                var rentContracts = db.RentContracts.Include(r => r.Employee).Include(r => r.RentalProperty);
                return View(rentContracts.ToList());
            }
    
            // GET: RentContracts/Details/5
            public ActionResult Details(int? id)
            {
                if (id == null)
                {
                    return new HttpStatusCodeResult(HttpStatusCode.BadRequest);
                }
                RentContract rentContract = db.RentContracts.Find(id);
                if (rentContract == null)
                {
                    return HttpNotFound();
                }
                return View(rentContract);
            }
    
            // GET: RentContracts/Create
            public ActionResult Create()
            {
                Random rndNumber = new Random();
    
                List<SelectListItem> maritals = new List<SelectListItem>
                {
                    new SelectListItem() { Text = "Unknown",   Value = "Unknown"   },
                    new SelectListItem() { Text = "Single",    Value = "Single"    },
                    new SelectListItem() { Text = "Widdow",    Value = "Widdow"    },
                    new SelectListItem() { Text = "Married",   Value = "Married"   },
                    new SelectListItem() { Text = "Divorced",  Value = "Divorced"  },
                    new SelectListItem() { Text = "Separated", Value = "Separated" }
                };
    
                ViewData["MaritalStatus"] = maritals;
    
                ViewData["ContractNumber"] = rndNumber.Next(1001, 99999999);
                ViewBag.EmployeeEmployeeId = new SelectList(db.Employees, "EmployeeId", "Identification");
                ViewBag.RentalPropertyRentalPropertyId = new SelectList(db.RentalProperties, "RentalPropertyId", "Residence");
                return View();
            }
    
            // POST: RentContracts/Create
            // To protect from overposting attacks, please enable the specific properties you want to bind to, for 
            // more details see https://go.microsoft.com/fwlink/?LinkId=317598.
            [HttpPost]
            [ValidateAntiForgeryToken]
            public ActionResult Create([Bind(Include = "RentContractId,ContractNumber,ContractDate,EmployeeId,TenantFirstName,TenantLastName,MaritalStatus,NumberOfChildren,RentalPropertyId,RentStartDate,EmployeeEmployeeId,RentalPropertyRentalPropertyId")] RentContract rentContract)
            {
                if (ModelState.IsValid)
                {
                    db.RentContracts.Add(rentContract);
                    db.SaveChanges();
                    return RedirectToAction("Index");
                }
    
                ViewBag.EmployeeEmployeeId = new SelectList(db.Employees, "EmployeeId", "Identification", rentContract.EmployeeEmployeeId);
                ViewBag.RentalPropertyRentalPropertyId = new SelectList(db.RentalProperties, "RentalPropertyId", "Residence", rentContract.RentalPropertyRentalPropertyId);
                return View(rentContract);
            }
    
            // GET: RentContracts/Edit/5
            public ActionResult Edit(int? id)
            {
                if (id == null)
                {
                    return new HttpStatusCodeResult(HttpStatusCode.BadRequest);
                }
                RentContract rentContract = db.RentContracts.Find(id);
                if (rentContract == null)
                {
                    return HttpNotFound();
                }
    
                List<SelectListItem> maritals = new List<SelectListItem>
                {
                    new SelectListItem() { Text = "Single",    Value = "Single",    Selected = (rentContract.MaritalStatus == "Single")    },
                    new SelectListItem() { Text = "Widdow",    Value = "Widdow",    Selected = (rentContract.MaritalStatus == "Widdow")    },
                    new SelectListItem() { Text = "Married",   Value = "Married",   Selected = (rentContract.MaritalStatus == "Married")   },
                    new SelectListItem() { Text = "Unknown",   Value = "Unknown",   Selected = (rentContract.MaritalStatus == "Unknown")   },
                    new SelectListItem() { Text = "Divorced",  Value = "Divorced",  Selected = (rentContract.MaritalStatus == "Divorced")  },
                    new SelectListItem() { Text = "Separated", Value = "Separated", Selected = (rentContract.MaritalStatus == "Separated") }
                };
    
                ViewData["MaritalStatus"] = maritals;
                ViewBag.EmployeeEmployeeId = new SelectList(db.Employees, "EmployeeId", "Identification", rentContract.EmployeeEmployeeId);
                ViewBag.RentalPropertyRentalPropertyId = new SelectList(db.RentalProperties, "RentalPropertyId", "Residence", rentContract.RentalPropertyRentalPropertyId);
                return View(rentContract);
            }
    
            // POST: RentContracts/Edit/5
            // To protect from overposting attacks, please enable the specific properties you want to bind to, for 
            // more details see https://go.microsoft.com/fwlink/?LinkId=317598.
            [HttpPost]
            [ValidateAntiForgeryToken]
            public ActionResult Edit([Bind(Include = "RentContractId,ContractNumber,ContractDate,EmployeeId,TenantFirstName,TenantLastName,MaritalStatus,NumberOfChildren,RentalPropertyId,RentStartDate,EmployeeEmployeeId,RentalPropertyRentalPropertyId")] RentContract rentContract)
            {
                if (ModelState.IsValid)
                {
                    db.Entry(rentContract).State = EntityState.Modified;
                    db.SaveChanges();
                    return RedirectToAction("Index");
                }
    
                ViewBag.EmployeeEmployeeId = new SelectList(db.Employees, "EmployeeId", "Identification", rentContract.EmployeeEmployeeId);
                ViewBag.RentalPropertyRentalPropertyId = new SelectList(db.RentalProperties, "RentalPropertyId", "Residence", rentContract.RentalPropertyRentalPropertyId);
                return View(rentContract);
            }
    
            // GET: RentContracts/Delete/5
            public ActionResult Delete(int? id)
            {
                if (id == null)
                {
                    return new HttpStatusCodeResult(HttpStatusCode.BadRequest);
                }
                RentContract rentContract = db.RentContracts.Find(id);
                if (rentContract == null)
                {
                    return HttpNotFound();
                }
                return View(rentContract);
            }
    
            // POST: RentContracts/Delete/5
            [HttpPost, ActionName("Delete")]
            [ValidateAntiForgeryToken]
            public ActionResult DeleteConfirmed(int id)
            {
                RentContract rentContract = db.RentContracts.Find(id);
                db.RentContracts.Remove(rentContract);
                db.SaveChanges();
                return RedirectToAction("Index");
            }
    
            protected override void Dispose(bool disposing)
            {
                if (disposing)
                {
                    db.Dispose();
                }
                base.Dispose(disposing);
            }
        }
    }
  65. In the class, right-click Index() and click Go To View
  66. Create the small webpage as follows:
    @model IEnumerable<PropertiesRentalManagement1.Models.RentContract>
    
    @{
        ViewBag.Title = "Rent Contracts";
    }
    
    <h2 class="bold blue common-font text-center">Rent Contracts</h2>
    
    <table class="table table-hover common-font">
        <tr>
            <th colspan="3" class="text-center">Contract Setup</th>
            <th>&nbsp;</th>
            <th colspan="4" class="text-center">Tenant</th>
            <th colspan="2" class="text-center">Rent Setup</th>
            <th>@Html.DisplayNameFor(model => model.RentStartDate)</th>
            <th>&nbsp;</th>
        </tr>
        <tr>
            <th class="text-center">ID</th>
            <th class="text-center">Number</th>
            <th class="text-center">Date</th>
            <th class="text-center">@Html.DisplayNameFor(model => model.EmployeeId)</th>
            <th>First Name</th>
            <th>Last Name</th>
            <th>Status</th>
            <th>Children</th>
            <th>Property</th>
            <th>Start Date</th>
            <th class="text-center">@Html.ActionLink("Prepare Rent Contract", "Create")</th>
        </tr>
    
        @foreach (var item in Model)
        {
        <tr>
            <td class="text-center">@Html.DisplayFor(modelItem => item.RentContractId)</td>
            <td class="text-center">@Html.DisplayFor(modelItem => item.ContractNumber)</td>
            <td class="text-center">@Html.DisplayFor(modelItem => item.ContractDate)</td>
            <td>@Html.DisplayFor(modelItem => item.Employee.Identification)</td>
            <td>@Html.DisplayFor(modelItem => item.TenantFirstName)</td>
            <td>@Html.DisplayFor(modelItem => item.TenantLastName)</td>
            <td>@Html.DisplayFor(modelItem => item.MaritalStatus)</td>
            <td>@Html.DisplayFor(modelItem => item.NumberOfChildren)</td>
            <td>@Html.DisplayFor(modelItem => item.RentalProperty.Residence)</td>
            <td class="text-center">@Html.DisplayFor(modelItem => item.RentStartDate)</td>
            <td>
                @Html.ActionLink("Edit", "Edit", new { id = item.RentContractId }) |
                @Html.ActionLink("Details", "Details", new { id = item.RentContractId }) |
                @Html.ActionLink("Delete", "Delete", new { id = item.RentContractId })
            </td>
        </tr>
        }
    </table>
  67. In the Solution Explorer, under Views and under RentContracts, double-click Create.cshtml
  68. Change the code of the form as follows:
    @model PropertiesRentalManagement1.Models.RentContract
    
    @{
        ViewBag.Title = "Create Rent Contract";
    }
    
    <h2 class="bold blue common-font">Create Rent Contract</h2>
    
    <hr />
    
    @using (Html.BeginForm())
    {
        @Html.AntiForgeryToken()
    
    <div class="form-horizontal common-font">
        @Html.ValidationSummary(true, "", new { @class = "text-danger" })
        <div class="form-group">
            @Html.LabelFor(model => model.ContractNumber, htmlAttributes: new { @class = "control-label col-md-2" })
            <div class="col-md-10">
                @Html.TextBox("ContractNumber", null, htmlAttributes: new { @class = "form-control" })
                @Html.ValidationMessageFor(model => model.ContractNumber, "", new { @class = "text-danger" })
            </div>
        </div>
    
        <div class="form-group">
            @Html.LabelFor(model => model.ContractDate, htmlAttributes: new { @class = "control-label col-md-2" })
            <div class="col-md-10">
                @Html.EditorFor(model => model.ContractDate, new { htmlAttributes = new { @class = "form-control", type = "Date" } })
                @Html.ValidationMessageFor(model => model.ContractDate, "", new { @class = "text-danger" })
            </div>
        </div>
    
        <div class="form-group">
            <label for="emplId" class="control-label col-md-2">Created/Prepared By</label>
            <div class="col-md-10">
                @Html.DropDownList("EmployeeEmployeeId", null, htmlAttributes: new { @class = "form-control", id = "emplId" })
                @Html.ValidationMessageFor(model => model.EmployeeEmployeeId, "", new { @class = "text-danger" })
            </div>
        </div>
    
        <div class="form-group">
            @Html.LabelFor(model => model.TenantFirstName, htmlAttributes: new { @class = "control-label col-md-2" })
            <div class="col-md-10">
                @Html.EditorFor(model => model.TenantFirstName, new { htmlAttributes = new { @class = "form-control" } })
                @Html.ValidationMessageFor(model => model.TenantFirstName, "", new { @class = "text-danger" })
            </div>
        </div>
    
        <div class="form-group">
            @Html.LabelFor(model => model.TenantLastName, htmlAttributes: new { @class = "control-label col-md-2" })
            <div class="col-md-10">
                @Html.EditorFor(model => model.TenantLastName, new { htmlAttributes = new { @class = "form-control" } })
                @Html.ValidationMessageFor(model => model.TenantLastName, "", new { @class = "text-danger" })
            </div>
        </div>
    
        <div class="form-group">
            @Html.LabelFor(model => model.MaritalStatus, htmlAttributes: new { @class = "control-label col-md-2" })
            <div class="col-md-10">
                @Html.DropDownList("MaritalStatus", null, htmlAttributes: new { @class = "form-control" })
                @Html.ValidationMessageFor(model => model.MaritalStatus, "", new { @class = "text-danger" })
            </div>
        </div>
    
        <div class="form-group">
            @Html.LabelFor(model => model.NumberOfChildren, htmlAttributes: new { @class = "control-label col-md-2" })
            <div class="col-md-10">
                @Html.EditorFor(model => model.NumberOfChildren, new { htmlAttributes = new { @class = "form-control" } })
                @Html.ValidationMessageFor(model => model.NumberOfChildren, "", new { @class = "text-danger" })
    
            </div>
        </div>
    
        <div class="form-group">
            <label for="propId" class="control-label col-md-2">Property/Residence</label>
            <div class="col-md-10">
                @Html.DropDownList("RentalPropertyRentalPropertyId", null, htmlAttributes: new { @class = "form-control", id = "propId" })
                @Html.ValidationMessageFor(model => model.RentalPropertyRentalPropertyId, "", new { @class = "text-danger" })
            </div>
        </div>
    
        <div class="form-group">
            @Html.LabelFor(model => model.RentStartDate, htmlAttributes: new { @class = "control-label col-md-2" })
            <div class="col-md-10">
                @Html.EditorFor(model => model.RentStartDate, new { htmlAttributes = new { @class = "form-control" } })
                @Html.ValidationMessageFor(model => model.RentStartDate, "", new { @class = "text-danger" })
            </div>
        </div>
    
        <div class="form-group">
            <label class="control-label col-md-2">
                @Html.ActionLink("Rent Contracts", "Index")
            </label>
            <div class="col-md-10">
                <input type="submit" value="Save Rent Contracts" class="btn btn-primary" />
            </div>
        </div>
    </div>
    }
    
    @section Scripts {
        @Scripts.Render("~/bundles/jqueryval")
    }
  69. In the Solution Explorer, under Views and under RentContracts, double-click Delete.cshtml
  70. Change the webpage as follows:
    @model PropertiesRentalManagement06.Models.RentContract
    
    @{
        ViewBag.Title = "Delete Rent Contract";
    }
    
    <h2 class="bold common-font blue">Delete Rent Contract</h2>
    
    <hr />
    
    <h3 class="common-font blue">Are you sure you want to cancel this rent contract?</h3>
    
    <div>
        <dl class="dl-horizontal common-font">
            <dt>@Html.DisplayNameFor(model => model.RentContractId)</dt>
            <dd>@Html.DisplayFor(model => model.RentContractId)</dd>
    
            <dt>@Html.DisplayNameFor(model => model.ContractNumber)</dt>
            <dd>@Html.DisplayFor(model => model.ContractNumber)</dd>
    
            <dt>@Html.DisplayNameFor(model => model.ContractDate)</dt>
            <dd>@Html.DisplayFor(model => model.ContractDate)</dd>
    
            <dt>@Html.DisplayNameFor(model => model.EmployeeId)</dt>
            <dd>@Html.DisplayFor(model => model.Employee.Identification)</dd>
    
            <dt>@Html.DisplayNameFor(model => model.TenantFirstName)</dt>
            <dd>@Html.DisplayFor(model => model.TenantFirstName)</dd>
    
            <dt>@Html.DisplayNameFor(model => model.TenantLastName)</dt>
            <dd>@Html.DisplayFor(model => model.TenantLastName)</dd>
    
            <dt>@Html.DisplayNameFor(model => model.MaritalStatus)</dt>
            <dd>@Html.DisplayFor(model => model.MaritalStatus)</dd>
    
            <dt>@Html.DisplayNameFor(model => model.NumberOfChildren)</dt>
            <dd>@Html.DisplayFor(model => model.NumberOfChildren)</dd>
    
            <dt>@Html.DisplayNameFor(model => model.RentalPropertyId)</dt>
            <dd>@Html.DisplayFor(model => model.RentalProperty.Residence)</dd>
    
            <dt>@Html.DisplayNameFor(model => model.RentStartDate)</dt>
            <dd>@Html.DisplayFor(model => model.RentStartDate)</dd>
    
            <dt>@Html.DisplayNameFor(model => model.Employee.EmployeeNumber)</dt>
            <dd>@Html.DisplayFor(model => model.Employee.EmployeeNumber)</dd>
    
            <dt>@Html.DisplayNameFor(model => model.RentalProperty.PropertyNumber)</dt>
            <dd>@Html.DisplayFor(model => model.RentalProperty.PropertyNumber)</dd>
        </dl>
    
        @using (Html.BeginForm())
        {
            @Html.AntiForgeryToken()
    
            <div class="form-actions no-color">
                <input type="submit" value="Delete this Rent Contract" class="btn btn-primary" /> |
                @Html.ActionLink("Rent Contracts", "Index", null, htmlAttributes: new { @class = "btn btn-primary" })
            </div>
        }
    </div>
  71. In the Solution Explorer, under Views and under Payments, double-click Details.cshtml
  72. Change the document as follows:
    @model PropertiesRentalManagement1.Models.RentContract
    
    @{
        ViewBag.Title = "Rent Contract Details";
    }
    
    <h2 class="bold common-font blue">Rent Contract Details</h2>
    
    <hr />
    
    <div>
        <dl class="dl-horizontal common-font">
            <dt>@Html.DisplayNameFor(model => model.RentContractId)</dt>
            <dd>@Html.DisplayFor(model => model.RentContractId)</dd>
    
            <dt>@Html.DisplayNameFor(model => model.ContractNumber)</dt>
            <dd>@Html.DisplayFor(model => model.ContractNumber)</dd>
    
            <dt>@Html.DisplayNameFor(model => model.ContractDate)</dt>
            <dd>@Html.DisplayFor(model => model.ContractDate)</dd>
    
            <dt>@Html.DisplayNameFor(model => model.EmployeeId)</dt>
            <dd>@Html.DisplayFor(model => model.Employee.Identification)</dd>
    
            <dt>@Html.DisplayNameFor(model => model.TenantFirstName)</dt>
            <dd>@Html.DisplayFor(model => model.TenantFirstName)</dd>
    
            <dt>@Html.DisplayNameFor(model => model.TenantLastName)</dt>
            <dd>@Html.DisplayFor(model => model.TenantLastName)</dd>
    
            <dt>@Html.DisplayNameFor(model => model.MaritalStatus)</dt>
            <dd>@Html.DisplayFor(model => model.MaritalStatus)</dd>
    
            <dt>@Html.DisplayNameFor(model => model.NumberOfChildren)</dt>
            <dd>@Html.DisplayFor(model => model.NumberOfChildren)</dd>
    
            <dt>@Html.DisplayNameFor(model => model.RentalPropertyId)</dt>
            <dd>@Html.DisplayFor(model => model.RentalProperty.Residence) </dd>
    
            <dt>@Html.DisplayNameFor(model => model.RentStartDate)</dt>
            <dd>@Html.DisplayFor(model => model.RentStartDate)</dd>
        </dl>
    </div>
    
    <p>
        @Html.ActionLink("Edit this Rent Contract", "Edit", new { id = Model.RentContractId }) |
        @Html.ActionLink("Rent Contracts", "Index")
    </p>
  73. In the Solution Explorer, under Views and under Payments, double-click Edit.cshtml
  74. Change the code as follows:
    @model PropertiesRentalManagement1.Models.RentContract
    
    @{
        ViewBag.Title = "Edit Rent Contract";
    }
    
    <h2 class="bold blue common-font">Edit/Update Rent Contract</h2>
    
    <hr />
    
    @using (Html.BeginForm())
    {
        @Html.AntiForgeryToken()
    
    <div class="form-horizontal common-font">
        @Html.ValidationSummary(true, "", new { @class = "text-danger" })
        @Html.HiddenFor(model => model.RentContractId)
    
        <div class="form-group">
            @Html.LabelFor(model => model.ContractNumber, htmlAttributes: new { @class = "control-label col-md-2" })
            <div class="col-md-10">
                @Html.EditorFor(model => model.ContractNumber, new { htmlAttributes = new { @class = "form-control" } })
                @Html.ValidationMessageFor(model => model.ContractNumber, "", new { @class = "text-danger" })
            </div>
        </div>
    
        <div class="form-group">
            @Html.LabelFor(model => model.ContractDate, htmlAttributes: new { @class = "control-label col-md-2" })
            <div class="col-md-10">
                @Html.EditorFor(model => model.ContractDate, new { htmlAttributes = new { @class = "form-control" } })
                @Html.ValidationMessageFor(model => model.ContractDate, "", new { @class = "text-danger" })
            </div>
        </div>
    
        <div class="form-group">
            <label for="emplId" class="control-label col-md-2">Created/Prepared By</label>
            <div class="col-md-10">
                @Html.DropDownList("EmployeeEmployeeId", null, htmlAttributes: new { @class = "form-control", id = "emplId" })
                @Html.ValidationMessageFor(model => model.EmployeeEmployeeId, "", new { @class = "text-danger" })
            </div>
        </div>
    
        <div class="form-group">
            @Html.LabelFor(model => model.TenantFirstName, htmlAttributes: new { @class = "control-label col-md-2" })
            <div class="col-md-10">
                @Html.EditorFor(model => model.TenantFirstName, new { htmlAttributes = new { @class = "form-control" } })
                @Html.ValidationMessageFor(model => model.TenantFirstName, "", new { @class = "text-danger" })
            </div>
        </div>
    
        <div class="form-group">
            @Html.LabelFor(model => model.TenantLastName, htmlAttributes: new { @class = "control-label col-md-2" })
            <div class="col-md-10">
                @Html.EditorFor(model => model.TenantLastName, new { htmlAttributes = new { @class = "form-control" } })
                @Html.ValidationMessageFor(model => model.TenantLastName, "", new { @class = "text-danger" })
            </div>
        </div>
    
        <div class="form-group">
            @Html.LabelFor(model => model.MaritalStatus, htmlAttributes: new { @class = "control-label col-md-2" })
            <div class="col-md-10">
                @Html.DropDownList("MaritalStatus", null, htmlAttributes: new { @class = "form-control" })
                @Html.ValidationMessageFor(model => model.MaritalStatus, "", new { @class = "text-danger" })
            </div>
        </div>
    
        <div class="form-group">
            @Html.LabelFor(model => model.NumberOfChildren, htmlAttributes: new { @class = "control-label col-md-2" })
            <div class="col-md-10">
                @Html.EditorFor(model => model.NumberOfChildren, new { htmlAttributes = new { @class = "form-control" } })
                @Html.ValidationMessageFor(model => model.NumberOfChildren, "", new { @class = "text-danger" })
            </div>
        </div>
    
        <div class="form-group">
            <label for="propId" class="control-label col-md-2">Property/Residence</label>
            <div class="col-md-10">
                @Html.DropDownList("RentalPropertyRentalPropertyId", null, htmlAttributes: new { @class = "form-control", id = "propId" })
                @Html.ValidationMessageFor(model => model.RentalPropertyRentalPropertyId, "", new { @class = "text-danger" })
            </div>
        </div>
    
        <div class="form-group">
            @Html.LabelFor(model => model.RentStartDate, htmlAttributes: new { @class = "control-label col-md-2" })
            <div class="col-md-10">
                @Html.EditorFor(model => model.RentStartDate, new { htmlAttributes = new { @class = "form-control" } })
                @Html.ValidationMessageFor(model => model.RentStartDate, "", new { @class = "text-danger" })
            </div>
        </div>
    
        <div class="form-group">
            <label class="control-label col-md-2">
                @Html.ActionLink("Rent Contracts", "Index")
            </label>
            <div class="col-md-10">
                <input type="submit" value="Save Rent Contract" class="btn btn-primary" />
            </div>
        </div>
    </div>
    }
    
    @section Scripts {
        @Scripts.Render("~/bundles/jqueryval")
    }
  75. In the Solution Explorer, right-click Controllers -> Add -> New Scaffolded Item...
  76. In the Model Class combo box, select Payment (PropertiesRentalManagement1.Models)
  77. In the Add Scaffed dialog box, make sure PropertiesManagementModelContainer (PropertiesRentalManagement1.Models). Click Add
  78. Change the PaymentsController class as follows:
    using PropertiesRentalManagement1.Models;
    using System;
    using System.Data.Entity;
    using System.Linq;
    using System.Net;
    using System.Web.Mvc;
    
    namespace PropertiesRentalManagement1.Controllers
    {
        public class PaymentsController : Controller
        {
            private PropertiesManagementModelContainer db = new PropertiesManagementModelContainer();
    
            // GET: Payments
            public ActionResult Index()
            {
                var payments = db.Payments.Include(p => p.Employee).Include(p => p.RentContract);
                return View(payments.ToList());
            }
    
            // GET: Payments/Details/5
            public ActionResult Details(int? id)
            {
                if (id == null)
                {
                    return new HttpStatusCodeResult(HttpStatusCode.BadRequest);
                }
                Payment payment = db.Payments.Find(id);
                if (payment == null)
                {
                    return HttpNotFound();
                }
                return View(payment);
            }
    
            // GET: Payments/Create
            public ActionResult Create()
            {
                Random rndNumber = new Random();
    
                ViewData["ReceiptNumber"] = rndNumber.Next(1001, 999999);
                ViewBag.EmployeeEmployeeId = new SelectList(db.Employees, "EmployeeId", "Identification");
                ViewBag.RentContractRentContractId = new SelectList(db.RentContracts, "RentContractId", "Description");
                return View();
            }
    
            // POST: Payments/Create
            // To protect from overposting attacks, please enable the specific properties you want to bind to, for 
            // more details see https://go.microsoft.com/fwlink/?LinkId=317598.
            [HttpPost]
            [ValidateAntiForgeryToken]
            public ActionResult Create([Bind(Include = "PaymentId,ReceiptNumber,EmployeeId,RentContractId,PaymentDate,AmountPaid,Notes,EmployeeEmployeeId,RentContractRentContractId")] Payment payment)
            {
                if (ModelState.IsValid)
                {
                    db.Payments.Add(payment);
                    db.SaveChanges();
                    return RedirectToAction("Index");
                }
    
                ViewBag.EmployeeEmployeeId = new SelectList(db.Employees, "EmployeeId", "EmployeeNumber", payment.EmployeeEmployeeId);
                ViewBag.RentContractRentContractId = new SelectList(db.RentContracts, "RentContractId", "ContractDate", payment.RentContractRentContractId);
                return View(payment);
            }
    
            // GET: Payments/Edit/5
            public ActionResult Edit(int? id)
            {
                if (id == null)
                {
                    return new HttpStatusCodeResult(HttpStatusCode.BadRequest);
                }
                Payment payment = db.Payments.Find(id);
                if (payment == null)
                {
                    return HttpNotFound();
                }
                ViewBag.EmployeeEmployeeId = new SelectList(db.Employees, "EmployeeId", "Identification", payment.EmployeeEmployeeId);
                ViewBag.RentContractRentContractId = new SelectList(db.RentContracts, "RentContractId", "Description", payment.RentContractRentContractId);
                return View(payment);
            }
    
            // POST: Payments/Edit/5
            // To protect from overposting attacks, please enable the specific properties you want to bind to, for 
            // more details see https://go.microsoft.com/fwlink/?LinkId=317598.
            [HttpPost]
            [ValidateAntiForgeryToken]
            public ActionResult Edit([Bind(Include = "PaymentId,ReceiptNumber,EmployeeId,RentContractId,PaymentDate,AmountPaid,Notes,EmployeeEmployeeId,RentContractRentContractId")] Payment payment)
            {
                if (ModelState.IsValid)
                {
                    db.Entry(payment).State = EntityState.Modified;
                    db.SaveChanges();
                    return RedirectToAction("Index");
                }
                ViewBag.EmployeeEmployeeId = new SelectList(db.Employees, "EmployeeId", "EmployeeNumber", payment.EmployeeEmployeeId);
                ViewBag.RentContractRentContractId = new SelectList(db.RentContracts, "RentContractId", "ContractDate", payment.RentContractRentContractId);
                return View(payment);
            }
    
            // GET: Payments/Delete/5
            public ActionResult Delete(int? id)
            {
                if (id == null)
                {
                    return new HttpStatusCodeResult(HttpStatusCode.BadRequest);
                }
                Payment payment = db.Payments.Find(id);
                if (payment == null)
                {
                    return HttpNotFound();
                }
                return View(payment);
            }
    
            // POST: Payments/Delete/5
            [HttpPost, ActionName("Delete")]
            [ValidateAntiForgeryToken]
            public ActionResult DeleteConfirmed(int id)
            {
                Payment payment = db.Payments.Find(id);
                db.Payments.Remove(payment);
                db.SaveChanges();
                return RedirectToAction("Index");
            }
    
            protected override void Dispose(bool disposing)
            {
                if (disposing)
                {
                    db.Dispose();
                }
                base.Dispose(disposing);
            }
        }
    }
  79. In the Solution Explorer, under Views and under Payments, double-click Create.cshtml
  80. Change the webform as follows:
    @model PropertiesRentalManagement1.Models.Payment
    
    @{
        ViewBag.Title = "Create Payment";
    }
    
    <h2 class="bold blue common-font">Make Rent Payment</h2>
    
    <hr />
    
    @using (Html.BeginForm())
    {
        @Html.AntiForgeryToken()
    
    <div class="form-horizontal common-font">
        @Html.ValidationSummary(true, "", new { @class = "text-danger" })
        <div class="form-group">
            @Html.LabelFor(model => model.ReceiptNumber, htmlAttributes: new { @class = "control-label col-md-2" })
            <div class="col-md-10">
                @Html.TextBox("ReceiptNumber", null, htmlAttributes: new { @class = "form-control" })
                @Html.ValidationMessageFor(model => model.ReceiptNumber, "", new { @class = "text-danger" })
            </div>
        </div>
    
        <div class="form-group">
            <label for="emplId" class="control-label col-md-2">Processed By</label>
            <div class="col-md-10">
                @Html.DropDownList("EmployeeEmployeeId", null, htmlAttributes: new { @class = "form-control", id = "emplId" })
                @Html.ValidationMessageFor(model => model.EmployeeEmployeeId, "", new { @class = "text-danger" })
            </div>
        </div>
    
        <div class="form-group">
            <label for="contractId" class = "control-label col-md-2">Rent Contract</label>
            <div class="col-md-10">
                @Html.DropDownList("RentContractRentContractId", null, htmlAttributes: new { @class = "form-control", id = "contractId" })
                @Html.ValidationMessageFor(model => model.RentContractRentContractId, "", new { @class = "text-danger" })
            </div>
        </div>
    
        <div class="form-group">
            @Html.LabelFor(model => model.PaymentDate, htmlAttributes: new { @class = "control-label col-md-2" })
            <div class="col-md-10">
                @Html.EditorFor(model => model.PaymentDate, new { htmlAttributes = new { @class = "form-control" } })
                @Html.ValidationMessageFor(model => model.PaymentDate, "", new { @class = "text-danger" })
            </div>
        </div>
    
        <div class="form-group">
            @Html.LabelFor(model => model.AmountPaid, htmlAttributes: new { @class = "control-label col-md-2" })
            <div class="col-md-10">
                @Html.EditorFor(model => model.AmountPaid, new { htmlAttributes = new { @class = "form-control" } })
                @Html.ValidationMessageFor(model => model.AmountPaid, "", new { @class = "text-danger" })
            </div>
        </div>
    
        <div class="form-group">
            @Html.LabelFor(model => model.Notes, htmlAttributes: new { @class = "control-label col-md-2" })
            <div class="col-md-10">
                @Html.TextArea("Notes", null, htmlAttributes: new { @class = "form-control", rows = 5 })
                @Html.ValidationMessageFor(model => model.Notes, "", new { @class = "text-danger" })
            </div>
        </div>
    
        <div class="form-group">
            <label class="control-label col-md-2">
                @Html.ActionLink("Rent Payments", "Index")
            </label>
            <div class="col-md-10">
                <input type="submit" value="Make Rent Payment" class="btn btn-primary" />
            </div>
        </div>
    </div>
    }
    
    @section Scripts {
        @Scripts.Render("~/bundles/jqueryval")
    }
  81. In the Solution Explorer, under Views and under Payments, double-click Delete.cshtml
  82. Change the webform as follows:
    @model PropertiesRentalManagement1.Models.Payment
    
    @{
        ViewBag.Title = "Delete Payment";
    }
    
    <h2 class="bold common-font blue">Delete Rent Payment</h2>
    
    <hr />
    
    <h3 class="common-font blue">Are you sure you want to cancel this payment?</h3>
    
    <div>
        <dl class="dl-horizontal common-font">
            <dt>@Html.DisplayNameFor(model => model.PaymentId)</dt>
            <dd>@Html.DisplayFor(model => model.PaymentId)</dd>
    
            <dt>@Html.DisplayNameFor(model => model.ReceiptNumber)</dt>
            <dd>@Html.DisplayFor(model => model.ReceiptNumber)</dd>
    
            <dt>@Html.DisplayNameFor(model => model.EmployeeId)</dt>
            <dd>@Html.DisplayFor(model => model.Employee.Identification)</dd>
    
            <dt>@Html.DisplayNameFor(model => model.RentContractId)</dt>
            <dd>@Html.DisplayFor(model => model.RentContract.Description)</dd>
    
            <dt>@Html.DisplayNameFor(model => model.PaymentDate)</dt>
            <dd>@Html.DisplayFor(model => model.PaymentDate)</dd>
    
            <dt>@Html.DisplayNameFor(model => model.AmountPaid)</dt>
            <dd>@Html.DisplayFor(model => model.AmountPaid)</dd>
    
            <dt>@Html.DisplayNameFor(model => model.Notes)</dt>
            <dd>@Html.DisplayFor(model => model.Notes)</dd>
            
            <dt>@Html.DisplayNameFor(model => model.RentContract.ContractDate)</dt>
            <dd>@Html.DisplayFor(model => model.RentContract.ContractDate)</dd>
        </dl>
    
        @using (Html.BeginForm())
        {
            @Html.AntiForgeryToken()
    
            <div class="form-actions no-color">
                <input type="submit" value="Delete/Cancel this Payment" class="btn btn-primary" /> |
                @Html.ActionLink("Rent Payments", "Index", null, htmlAttributes: new { @class = "btn btn-primary" })
            </div>
        }
    </div>
  83. In the Solution Explorer, under Views and under Payments, double-click Details.cshtml
  84. Change the webform as follows:
    @model PropertiesRentalManagement1.Models.Payment
    
    @{
        ViewBag.Title = "Payment Details";
    }
    
    <h2 class="bold common-font blue">Payment Details</h2>
    
    <hr />
    
    <div>
        <dl class="dl-horizontal common-font">
            <dt>@Html.DisplayNameFor(model => model.ReceiptNumber)</dt>
            <dd>@Html.DisplayFor(model => model.ReceiptNumber)</dd>
    
            <dt>@Html.DisplayNameFor(model => model.EmployeeId)</dt>
            <dd>@Html.DisplayFor(model => model.Employee.Identification)</dd>
    
            <dt>@Html.DisplayNameFor(model => model.RentContractId)</dt>
            <dd>@Html.DisplayFor(model => model.RentContract.Description)</dd>
    
            <dt>@Html.DisplayNameFor(model => model.PaymentDate)</dt>
            <dd>@Html.DisplayFor(model => model.PaymentDate)</dd>
    
            <dt>@Html.DisplayNameFor(model => model.AmountPaid)</dt>
            <dd>@Html.DisplayFor(model => model.AmountPaid)</dd>
    
            <dt>@Html.DisplayNameFor(model => model.Notes)</dt>
            <dd>@Html.DisplayFor(model => model.Notes)</dd>
        </dl>
    </div>
    
    <p>
        @Html.ActionLink("Edit this Rent Payment", "Edit", new { id = Model.PaymentId }) |
        @Html.ActionLink("Rent Payments", "Index")
    </p>
  85. In the Solution Explorer, under Views and under Payments, double-click Edit.cshtml
  86. Change the webform as follows:
    @model PropertiesRentalManagement1.Models.Payment
    
    @{
        ViewBag.Title = "Edit Payment";
    }
    
    <h2 class="bold blue common-font">Edit/Update Payment</h2>
    
    <hr />
    
    @using (Html.BeginForm())
    {
        @Html.AntiForgeryToken()
    
    <div class="form-horizontal common-font">
        @Html.ValidationSummary(true, "", new { @class = "text-danger" })
        @Html.HiddenFor(model => model.PaymentId)
    
        <div class="form-group">
            @Html.LabelFor(model => model.ReceiptNumber, htmlAttributes: new { @class = "control-label col-md-2" })
            <div class="col-md-10">
                @Html.EditorFor(model => model.ReceiptNumber, new { htmlAttributes = new { @class = "form-control" } })
                @Html.ValidationMessageFor(model => model.ReceiptNumber, "", new { @class = "text-danger" })
            </div>
        </div>
    
        <div class="form-group">
            <label for="emplId" class="control-label col-md-2">Processed By</label>
            <div class="col-md-10">
                @Html.DropDownList("EmployeeEmployeeId", null, htmlAttributes: new { @class = "form-control", id = "emplId" })
                @Html.ValidationMessageFor(model => model.EmployeeEmployeeId, "", new { @class = "text-danger" })
            </div>
        </div>
    
        <div class="form-group">
            <label for="contractId" class="control-label col-md-2">Rent Contract</label>
            <div class="col-md-10">
                @Html.DropDownList("RentContractRentContractId", null, htmlAttributes: new { @class = "form-control", id = "contractId" })
                @Html.ValidationMessageFor(model => model.RentContractRentContractId, "", new { @class = "text-danger" })
            </div>
        </div>
    
        <div class="form-group">
            @Html.LabelFor(model => model.PaymentDate, htmlAttributes: new { @class = "control-label col-md-2" })
            <div class="col-md-10">
                @Html.EditorFor(model => model.PaymentDate, new { htmlAttributes = new { @class = "form-control" } })
                @Html.ValidationMessageFor(model => model.PaymentDate, "", new { @class = "text-danger" })
            </div>
        </div>
    
        <div class="form-group">
            @Html.LabelFor(model => model.AmountPaid, htmlAttributes: new { @class = "control-label col-md-2" })
            <div class="col-md-10">
                @Html.EditorFor(model => model.AmountPaid, new { htmlAttributes = new { @class = "form-control" } })
                @Html.ValidationMessageFor(model => model.AmountPaid, "", new { @class = "text-danger" })
            </div>
        </div>
    
        <div class="form-group">
            @Html.LabelFor(model => model.Notes, htmlAttributes: new { @class = "control-label col-md-2" })
            <div class="col-md-10">
                @Html.EditorFor(model => model.Notes, new { htmlAttributes = new { @class = "form-control" } })
                @Html.ValidationMessageFor(model => model.Notes, "", new { @class = "text-danger" })
            </div>
        </div>
    
        <div class="form-group">
            <label class="control-label col-md-2">
                @Html.ActionLink("Rent Payments", "Index")
            </label>
            <div class="col-md-10">
                <input type="submit" value="Update this Payment" class="btn btn-primary" />
            </div>
        </div>
    </div>
    }
    
    @section Scripts {
        @Scripts.Render("~/bundles/jqueryval")
    }
  87. In the Solution Explorer, under Views and under Payments, double-click Index.cshtml
  88. Change the webform as follows:
    @model IEnumerable<PropertiesRentalManagement1.Models.Payment>
    
    @{
        ViewBag.Title = "Rent Payments";
    }
    
    <h2 class="bold blue common-font text-center">Rent Payments</h2>
    
    <table class="table table-hover common-font">
        <tr>
            <th class="text-center">@Html.DisplayNameFor(model => model.PaymentId)</th>
            <th class="text-center">@Html.DisplayNameFor(model => model.ReceiptNumber)</th>
            <th>@Html.DisplayNameFor(model => model.EmployeeId)</th>
            <th>@Html.DisplayNameFor(model => model.RentContractId)</th>
            <th>@Html.DisplayNameFor(model => model.PaymentDate)</th>
            <th>@Html.DisplayNameFor(model => model.AmountPaid)</th>
            <th>@Html.DisplayNameFor(model => model.Notes)</th>
            <th>@Html.ActionLink("Make Rent Payment", "Create")</th>
        </tr>
    
    @foreach (var item in Model) {
        <tr>
            <td class="text-center">@Html.DisplayFor(modelItem => item.PaymentId)</td>
            <td class="text-center">@Html.DisplayFor(modelItem => item.ReceiptNumber)</td>
            <td>@Html.DisplayFor(modelItem => item.Employee.Identification)</td>
            <td>@Html.DisplayFor(modelItem => item.RentContract.Description)</td>
            <td>@Html.DisplayFor(modelItem => item.PaymentDate)</td>
            <td>@Html.DisplayFor(modelItem => item.AmountPaid)</td>
            <td>@Html.DisplayFor(modelItem => item.Notes)</td>
        <td>
            @Html.ActionLink("Edit", "Edit", new { id = item.PaymentId }) |
            @Html.ActionLink("Details", "Details", new { id = item.PaymentId }) |
            @Html.ActionLink("Delete", "Delete", new { id = item.PaymentId })
        </td>
        </tr>
    }
    </table>
  89. In the Solution Explorer, under Views, expand Shared
  90. Double-click _Layout.cshtml to open it
  91. Change the document as follows:
    <!DOCTYPE html>
    <html>
    <head>
        <meta charset="utf-8" />
        <meta name="viewport" content="width=device-width, initial-scale=1.0">
        <title>Properties Rental Management :: @ViewBag.Title</title>
        @Styles.Render("~/Content/css")
        @Scripts.Render("~/bundles/modernizr")
    </head>
    <body>
        <div class="navbar navbar-inverse navbar-fixed-top">
            <div class="container">
                <div class="navbar-header">
                    <button type="button" class="navbar-toggle" data-toggle="collapse" data-target=".navbar-collapse">
                        <span class="icon-bar"></span>
                        <span class="icon-bar"></span>
                        <span class="icon-bar"></span>
                    </button>
                    <a href="/Home/Index" class="navbar-brand"><img src="~/Images/prm1.png" width="134" height="28" alt="Online Presence" /></a>
                </div>
                <div class="navbar-collapse collapse navbar-right">
                    <ul class="nav navbar-nav">
                        <li>@Html.ActionLink("REQUEST ASSISTANCE", "Index", "Home")</li>
                        <li>@Html.ActionLink("CAREERS", "About", "Home")</li>
                        <li>@Html.ActionLink("COMMUNITY/PUBLIC RELATIONS", "Contact", "Home")</li>
                    </ul>
                </div>
            </div>
        </div>
        
        <div class="navbar navbar-inverse navbar-fixed-middle">
            <div class="container">
                <div class="row">
                    <div class="col-md-1 pat-down1">
                        <p><img src="~/Images/prm2.png" alt="Properties Rental Management" width="88" height="88" /></p>
                    </div>
                    <div class="col-md-4 pat-down2">
                        <p><img src="~/Images/prm3.png" alt="Properties Rental Management" width="373" height="59" /></p>
                    </div>
                    <div class="col-md-5 navbar-right pat-down3 lease-crochet">
                        <ul>
                            <li>@Html.ActionLink("Lease Application", "Index", "Home")</li>
                            <li>@Html.ActionLink("Renew Lease", "About", "Home")</li>
                            <li>@Html.ActionLink("Manage Lease", "Contact", "Home")</li>
                        </ul>
                    </div>
                </div>
            </div>
        </div>
    
        <div class="navbar-fixed-medium">
            <div class="container">
                <div class="pat-down4 community ">
                    <ul>
                        <li>@Html.ActionLink("ABOUT PRM", "Index", "Home")</li>
                        <li>@Html.ActionLink("EMPLOYEES", "Index", "Employees")</li>
                        <li>@Html.ActionLink("PROPERTIES LISTING", "Index", "RentalProperties")</li>
                        <li>@Html.ActionLink("RENT CONTRACTS", "Index", "RentContracts")</li>
                        <li>@Html.ActionLink("RENT PAYMENTS", "Index", "Payments")</li>
                        <li>@Html.ActionLink("CONTACT US", "Contact", "Home")</li>
                    </ul>
                </div>    
            </div>
        </div>
        <div class="container body-content push-down">
            @RenderBody()
            <hr />
            <footer>
                <p class="text-center common-font">&copy; @DateTime.Now.Year - Properties Rental Management</p>
            </footer>
        </div>
    
        @Scripts.Render("~/bundles/jquery")
        @Scripts.Render("~/bundles/bootstrap")
        @RenderSection("scripts", required: false)
    </body>
    </html>
  92. In the Solution Explorer, under Views, expand Home and double-click Index.cshtml
  93. Change the document as follows:
    @{
        ViewBag.Title = "Properties Rental Management";
    }
    
    <div class="row">
        <div class="col-md-2">
            <div class="text-center"><img src="~/Images/prm4.png" alt="Properties Rental Management" width="77" height="74" /></div>
            <div class="side-menu">
                <ul class="sm">
                    <li>@Html.ActionLink("Emergency", "About", "Home")</li>
                    <li>@Html.ActionLink("Future Improvements", "About", "Home")</li>
                    <li>@Html.ActionLink("Floor Plans", "About", "Home")</li>
                    <li>@Html.ActionLink("Gallery/Models", "About", "Home")</li>
                    <li>@Html.ActionLink("Media Relations", "About", "Home")</li>
                    <li>@Html.ActionLink("Neighborhoods", "About", "Home")</li>
                    <li>@Html.ActionLink("Testimonies", "About", "Home")</li>
                    <li>@Html.ActionLink("Partnerships", "About", "Home")</li>
                    <li>@Html.ActionLink("Security", "About", "Home")</li>
                    <li>@Html.ActionLink("Schools Districts", "About", "Home")</li>
                    <li>@Html.ActionLink("Affiliations", "About", "Home")</li>
                    <li>@Html.ActionLink("Places to Visit", "About", "Home")</li>
                    <li>@Html.ActionLink("Entertainment", "About", "Home")</li>
                    <li>@Html.ActionLink("Newsletter", "About", "Home")</li>
                    <li>@Html.ActionLink("Survey", "About", "Home")</li>
                    <li>@Html.ActionLink("Web Site Map", "About", "Home")</li>
                </ul>
            </div>
        </div>
    
        <div class="col-md-10">
            <p class="sub-title">Single Family Homes</p>
            <div class="row">
                <div class="col-md-4"><img src="~/Images/prm5.png" alt="Single Family Home" width="297" height="150" class="bordered" /></div>
                <div class="col-md-7">
                    <p class="parajust">Our vast collection of homes includes 2, 3, 4, and 5-bedroom single family houses in many categories (small, medium, estate, contemporary, country, ranch, Victorian, etc). All our houses have a master bedroom featuring large (and sometimes very large) walking closets and expanded bathtubs. Most of our houses contain (at least) 3.5 bathrooms.</p>
                    <p class="parajust">Check our gallery of photos and videos. Also the descriptions of our various categories of houses provide as nuch detailed information as possible to assist you in making the right decision for an appropriate residence that will make you proud.</p>
                </div>
            </div>
    
            <p class="sub-title text-right">Apartments and Condominiums</p>
            <div class="row">
                <div class="col-md-8">
                    <p class="parajust">Our residences include simple apartments (such as efficiencies) to luxurious condominiums, from regular studios to penthouses. All apartments are well equipped with heat, air condition, refrigerators, microwave ovens, and dishwashers. Most apartments are also equipped with laundry mashines and dryers.</p>
                    <p class="parajust">Most of the residents have access to a conveniently monitored swimming pool that functions at least six months in a year. The residents also have access to nearby publicly accessible community parks managed by local governments and the close community. At the same time, we provide the highest level of security for our residents. The security is local, community-based, and/or government-managed.</p>
                </div>
                <div class="col-md-3"><img src="~/Images/prm6.png" alt="Apartment or Condominiums" width="331" height="150" class="bordered" /></div>
            </div>
    
            <p class="sub-title">Townhouses</p>
            <div class="row">
                <div class="col-md-4"><img src="~/Images/prm7.png" alt="Townhouse" width="317" height="150" class="bordered" /></div>
                <div class="col-md-7">
                    <p class="parajust">We have townhouses in groups of two, four, five, seven, or eight units. Whether you want to live between units or at an end block, we have them all. Most of our townhouses have finished basements. Some of them have interior garages.</p>
                    <p class="parajust">The majority of our townhouses have a master bedroom that includes a complete bathroom with many boards and a walking closet with multiple shelves. The finished basements resemble a complete apartment with everything necessary (kitchen corner, complete bathroom, and a combined bedroom/living room/dining room.</p>
                </div>
            </div>
        </div>
    </div>
  94. To execute the project, on the main menu, click Debug -> Start Without Debugging

    Properties Rental Management - Home Page

  95. Click the EMPLOYEES link

    Properties Rental Management - Home Page

  96. In the webpage, click Hire New Employee

    Joins Fundamentals

  97. Create the following records:
     
    Employee # First Name Last Name Employment Title
    939470 Catherine Watts Owner - General Manager
    728407 Robert Preston Maintenance Technician
    204483 Nancy Longhorm Accounts Representative
    406851 Justine Sandt Accounts Manager
    609492 Mark Reason Maintenance Technician
    947059 Michael Adler Webmaster - IT Specialist
    384759 Marianne Huriez Accounts Representative
    INSERT Employees(EmployeeNumber, FirstName, LastName, EmploymentTitle)
    VALUES(N'939470', N'Catherine', N'Watts',    N'Owner'),
          (N'728407', N'Robert',    N'Preston',  N'Maintenance Technician'),
          (N'204483', N'Nancy',     N'Longhorn', N'Assistant Representative'),
          (N'406851', N'Justine',   N'Sandt',    N'Accounts Manager'),
          (N'609492', N'Mark',      N'Reason',   N'Maintenance Technician'),
          (N'947059', N'Michael',   N'Adler',    N'Webmaster - IT Specialist'),
          (N'384759', N'Marianne',  N'Huriez',   N'Accounts Representative');
    GO

    Views Fundamentals

  98. Click the PROPERTIES LISTING link

    Views Fundamentals

  99. Click the Set Up Rental Property link

    Entity Framework - Create Rental Property

  100. Create a few properties as follows:

    Property Type Address City State ZIP Code Bedrooms Bathrooms Monthly Rate Security Deposit Occupancy Status
    Apartment 6288 Mariner Ave #A1 Carlisle Pennsylvania 17013 1 1 950 650 Available
    Apartment 6288 Mariner Ave #A2 Carlisle Pennsylvania 17013 2 1 1250 950 Available
    Apartment 6288 Mariner Ave #A3 Carlisle Pennsylvania 17013 3 2 1650 1250 Needs Maintenance
    Apartment 6288 Mariner Ave #A4 Carlisle Pennsylvania 17013 2 2 1325 1000 Available
    Townhouse 12061 Crow Mills Rd Melville North Carolina 27302 3 2.50 1200 1000 Available
    Single Family 846 Old Ring Court College Park Maryland 20740 4 3.50 1750 1500 Available
    Apartment 6288 Mariner Ave #B1 Carlisle Pennsylvania 17013 1 1 1150 850 Available
    Townhouse 4738 Colson Str Burlington North Carolina 27215 4 3.50 1350 750 Available
    Single Family 6404 Gray Bear Hwy Brookville Pennsylvania 15825 3 2.5 1450 1200 Needs Maintenance
    Apartment 6288 Mariner Ave #B2 Carlisle Pennsylvania 17013 3 2 1600 1250 Available
    Townhouse 12066 Crow Mills Rd Melville North Carolina 27302 3 2.50 1325 1150 Available
    Single Family 1848 Warholds Drv Burlington North Carolina 27215 5 3.50 1550 1250 Available
    INSERT RentalProperties(PropertyNumber, PropertyType, [Address], City, [State], ZIPCode, Bedrooms, Bathrooms, MonthlyRate, SecurityDeposit, OccupancyStatus)
    VALUES(N'8374605', N'Apartment',     N'6288 Mariner Ave #A1', N'Carlisle',     N'Pennsylvania',   N'170133', 1, 1,     950,  650, N'Available'),
          (N'7930259', N'Apartment',     N'6288 Mariner Ave #A2', N'Carlisle',     N'Pennsylvania',   N'170133', 2, 1,    1250,  950, N'Available'),
          (N'9794706', N'Apartment',     N'6288 Mariner Ave #A3', N'Carlisle',     N'Pennsylvania',   N'170133', 3, 2,    1650, 1250, N'Needs Maintenance'),
          (N'3940869', N'Apartment',     N'6288 Mariner Ave #A4', N'Carlisle',     N'Pennsylvania',   N'170133', 2, 2,    1325, 1000, N'Available'),
          (N'8030480', N'Townhouse',     N'12061 Crow Mills Rd',  N'Melville',     N'North Carolina', N'273023', 3, 2.50, 1200, 1000, N'Available'),
          (N'1836614', N'Single Family', N'846 Old Ring Court',   N'College Park', N'Maryland',       N'207403', 4, 3.50, 1750, 1500, N'Available'),
          (N'7380463', N'Apartment',     N'6288 Mariner Ave #B1', N'Carlisle',     N'Pennsylvania',   N'170133', 1, 1,    1150,  850, N'Available'),
          (N'5049711', N'Townhouse',     N'4738 Colson Str',      N'Burlington',   N'North Carolina', N'272153', 4, 3.50, 1350,  750, N'Available'), 
          (N'6496880', N'Single Family', N'6404 Gray Bear Hwy',   N'Brookville',   N'Pennsylvania',   N'158253', 3, 2.50, 1450, 1200, N'Needs Maintenance'), 
          (N'9705940', N'Apartment',     N'6288 Mariner Ave #B2', N'Carlisle',     N'Pennsylvania',   N'170133', 3, 2,    1600, 1250, N'Available'),
          (N'3059752', N'Townhouse',     N'12066 Crow Mills Rd',  N'Melville',     N'North Carolina', N'273023', 3, 2.50, 1325, 1150, N'Available'),
          (N'9304705', N'Single Family', N'1848 Warholds Drv',    N'Burlington',   N'North Carolina', N'272153', 5, 3.50, 1550, 1250, N'Available');
    GO

    Properties Rental Management

  101. Click the RENT CONTRACTS link

    Properties Rental Management

  102. Click Prepare Rent Contract

    Entity Framework - Create Rental Property

  103. Create a few payments as follows

    Contract Date Create/Prepared By Tenant First Name Tenant Last Name Marital Status Number of Children Property/Residence Rent Start Date
    10/15/2018 3 Rachel Walton Single 0 7 12/1/2018
    10/15/2018 7 Frank Ficher Married 3 6 11/1/2018
    10/24/2018 3 Ernest Brewton Married 5 8 11/1/2018
    10/24/2018 4 Jennifer Gilmer Separated 2 10 12/1/2018

    Properties Rental Management

  104. Click the RENT PAYMENTS link

    Properties Rental Management

  105. Click Make Rent Payment

    Entity Framework - Create Rental Property

  106. Create a few payments as follows

    Processed By Rent Contract Payment Date Amount Paid Note
    4 2 10-15-2018 1500 This is the payment for the security deposit.
    1 1 10/24/2018 850 This is the payment for the security deposit.
    1 3 10/30/2018 1000 This is the payment for the security deposit.
    7 3 11/25/2018 1325 This is the first rent payment (for November 2018).
    4 2 11/30/2018 1750 This is payment for the rent of November 2018.
    3 3 12-27-2018 1325 This is the second rent payment (for December 2018).
    1 1 12/28/2018 1150 This is rent payment for December 2018.
    1 2 12/31/2018 1750 Rent Payment for December 2018.
    4 1 01-27-2018 1150 This is the payment for rent for January 2019.
    3 4 01/31/2019 1750 This is the January 2019 rent payment.
    3 1 02-02-2019 1150 This is the rent payment for January 2019.
    4 1 02-28-2019 1150 February 2019 rent payment
    7 3 02-28-2019 1325 Rent Payment for February 2019
    3 2 03/04/2019 1750 February 2019 rent payment

    Entity Framework

  107. Close the browser and return to your programming environment
  108. Close your programming environment

Home Copyright © 2017-2019, FunctionX Home