Entity Framework Fundamentals

Introduction to the Models of a Database

An entity framework (EF) is a technique to establish a connection to a database and use the objects of that database. The EF makes it easy to perform most routine operations of a database. For example, you can manually select the objects you need for your database. You can visualize the relationships among those objects, and you can visually maintain your database. In short, the EF tremendously reduces the amount of code you need to write for your database project. The EF consists of a technique that uses existing .NET Framework classes and Microsoft Visual Studio to assist you with your database project in ASP.NET MVC.

To support the entity framewoek, the .NET Framework provides a namespace named System.Data.Entity.

There are various ways you can use the EF.

Practical LearningPractical Learning: Introducing the Entity Framework

  1. Start Microsoft Visual Studio
  2. On the main menu, click File -> New -> Project...
  3. In the New Project dialog box, click ASP.NET Web Application (.NET) and change the project Name to CeilInn1
  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 Models -> Add -> New Item...
  7. In the left frame of the Add New Item dialog box, click Data
  8. In the left frame of the Add New Item dialog box, click Data and, in the middle frame, click ADO.NET Entity Data Model
  9. Change the Name to CeilInnModel
  10. Click Add
  11. In the first page of the Entity Data Model Wizard, click Empty Code First Model

    Entity Data Model Wizard

  12. Click Finish

A Class for a Table

When using the entity framework, you need a C# class for each table of the database you will use. You can first create a database with its tables and then ask Microsoft Visual Studio to generate a class for each table. You can first create a (the) class(es) for a table or each table, then use Microsoft Visual Studio to create a database that will contain (a) table(s) based on the class(es).

A class used in the entity framework primarily resembles a normal C# class. The class must contain an automatic property for each column of the table; that is, the columns of a table that exist already or the columns for a table that will be created. Usually in SQL, the name of a table is in plural while in C#, the name of a class is singular. Here is an example of a class that would be used for a database table:

public class House
{
    public string PropertyNumber { get; set; }
    public string Address        { get; set; }
    public string City           { get; set; }
    public string County         { get; set; }
    public string State          { get; set; }
}

This type of class (is used to create an object that) represents a record of the equivalent table in the target database. The entity framework needs a class that relates that object to the actual data in the database. That EF class represents a record of its equivalent table in the database. This makes the class able to create records, select records, and maintain (edit/update and delete) records. To support these operations, the System.Data.Entity namespace provides a class named DbContext. It implements the IDisposable interface:

public class DbContext : IDisposable, IObjectContextAdapter

To use the DbContext class, derive a class from it. When the time comes, you or Microsoft Visual Studio will create a connection string in the Web.config file. The name you give to your DbContext-derived class is (must be) the same name of the connection string. Here is an example of deriving a class from DbContext:

using System.Data.Entity;

public class DepartmentStoreContext : DbContext
{
}

To support the classes that represent the tables of the database, the System.Data.Entity namespace provides an abstract class named DbSet:

public abstract class DbSet : DbQuery

To support values of any type, the namespace provides a generic version of this class:

public class DbSet<TEntity> : DbQuery<TEntity>,
                              IDbSet<TEntity>, 
	                          IQueryable<TEntity>,
                              IEnumerable<TEntity>,
                              IQueryable, IEnumerable
                              where TEntity : class

The DbContext class provides a property for each of the DbSet classes. In your DbContext-derived class, you must create a DbSet property for each class that represents a table. In most cases, you should use the generic class. In this case, pass the name of your table class as the parameter type. The name of the property should be in plural, which would be equivalent to the name of the table. Here is an example:

using System.Data.Entity;
    
namespace RealEstate.Models
{
    publicl class House
    {
        public string PropertyNumber { get; set; }
        public string Address { get; set; }
        public string City { get; set; }
        public string County { get; set; }
        public string State { get; set; }
    }

    public class RealEstateContext : DbContext
    {
        public DbSet<House> Properties { get; set; }
    }
}

The Database of an Entity Framework

To let you get access to a database, the System.Data.Entity namespace provides a class named Database. To give you access to the database to which the entity framework refers, the DbContext class is equipped with a property named Database of type Database

public Database Database { get; }

As a result, to have access to the database of your project, in your controller class, declare a variable of your DbContext-based class. Of course, you must be using the namespace of the model document. Here is an example:

using System.Data.Entity;
using System.Web.Mvc;
using RentalPropertiesManagement1.Models;

namespace RentalPropertiesManagement1.Controllers
{
    public class HousesController : Controller
    {
        private RealEstateContext db = new RealEstateContext();

        // GET: Houses
        public ActionResult Index()
        {
            return View();
        }
    }
}

Introductory Operations on a Database Context

This declaration gives you access to the DbSet<> object of the property you created. As you might have noticed, the DbSet class implements the IEnumerable<> interface. This means that its list of records can be converted to a List<> collection by calling its ToList() method.

The DbSet<> class implements the IQueryable<> interface. This means that its object gets all the LINQ functionalities.

Creating a Modeled Database: Starting from One or More Classes

Introduction

One way you can use the entity framework is to first create one or more C# classes in your project, then ask Microsoft Visual Studio to create a database that contains one or more tables based on the class(es) you had created. To make your job easier, start by creating an ADO.NET Entity Data Model for a non-existing database. This would cause Microsoft Visual Studio to create a class derived from DbContext and get it ready for your project.

Creating the Table Classes

When you use the Empty Code First Model option of the Entity Data Model Wizard, you indicate that you want the entity framework to prepare a database for you. At that time, Microsoft Visual Studio creates an empty database file for you. It also adds a connection string in your root Web.config file. The name of the connection string is the name you had provided when creating the ADO.NET Entity Data Model. Microsoft Visual Studio also creates a file that contains a class derived from DbContext. The name of the class is the name you had provided when creating the ADO.NET Entity Data Model, which is also the name of the connection string. You can change one of the names but you must also change the other to be the same. This means that if you change the name of the class, you must apply that same name to the connection string and vice-versa.

Once Microsoft Visual Studio has created a DbContext-based class for you, you can create the necessary class(es) for the table(s) of your database. Every table of your database must have a primary key. Since you start the project from at least one class (the class(es) you create after Microsoft Visual Studio has prepared the project for you), the class must indicate what property will serve as the primary key. In fact, every one of the classes you will create must indicate which one of its properties represents the primary key of its future table.

If you are creating a class for a database table, to indicate the property that holds the primary key, we saw that you can mark the necessary property with the KeyAttribute attribute.

Practical LearningPractical Learning: Creating a Class for a Table

  1. Notice that a file named CielInn1Model.cs displays.
    Change the document as follows:
    namespace CeilInn1.Models
    {
        using System.Data.Entity;
    
        public class CeilInnModel : DbContext
        {
            // Your context has been configured to use a 'CeilInnModel' connection string from your application's 
            // configuration file (App.config or Web.config). By default, this connection string targets the 
            // 'CeilInn1.Models.CeilInnModel' database on your LocalDb instance. 
            // 
            // If you wish to target a different database and/or database provider, modify the 'CeilInnModel' 
            // connection string in the application configuration file.
            public CeilInnModel()
                : base("name=CeilInnModel")
            {
            }
    
            // Add a DbSet for each entity type that you want to include in your model. For more information 
            // on configuring and using a Code First model, see http://go.microsoft.com/fwlink/?LinkId=390109.
    
            public virtual DbSet<Room> Rooms { get; set; }
        }
    
        public class Room
        {
            public int RoomId { get; set; }
            public string RoomNumber { get; set; }
            public string RoomType { get; set; }
            public string BedTypes { get; set; }
            public string OccupancyStatus { get; set; }
        }
    }
  2. To prepare the context, on the main menu, click Build -> Build Solution

Creating a Database Controller

As always, in order to use a database in your project, you must use a controller. Before creating the controller class, you must first build the solution. If the build is successful, create a controller that supports the entity framework. This would open the Add Controller dialog box. In the Model Class, select the option that has the name of the class and model in parentheses. In the Data Context Class, select the option that has the name of the DbContext-based class and the model in the parentheses.

When you create a controller that uses the entity framework, Microsoft Visual Studio adds all the necessary methods and associated views used to create, read, edit, and delete records.

Adding Records Through the Entity Framework

To let you add a record to the data context, the DbSet<> class is equipped with a method named Add. Its syntax is:

public virtual TEntity Add(TEntity entity)

When calling this method, you can simply pass an object of your table class. After calling this method, you can use its view to create a record. To do this:

Practical LearningPractical Learning: Creating a Database Controller

  1. In Solution Explorer, right-click Controllers -> Add -> Controller...
  2. In the Add Scaffold dialog box, click MVC 5 Controller With Views, Using Entity Framework

    Add Scaffold

  3. Click Add
  4. In the Model Class combo box, select Room (CeilInn1.Models)
  5. In the Data Context Class combo box, select CeilInnModel (CeilInn1.Models)

    Add Controller

  6. Click Add
  7. In the Solution Explorer, under Views and under Cars, double-click Create.cshtml
  8. To test the website, on the main menu, click Debug -> Start Without Debugging

    Web API Application - Getting the Data

  9. Close the browser and return to your programming environment
  10. To start another project, on the main menu of Microsoft Visual Studio, click File -> New -> Project...
  11. In the New Project dialog box, click ASP.NET Web Application (.NET) and change the project Name to BethesdaCarRental1
  12. Click OK
  13. In the New ASP.NET Web Application dialog box, click the MVC icon and click OK
  14. In the Solution Explorer, right-click Models -> Add -> New Item...
  15. In the left frame of the Add New Item dialog box, click Data
  16. In the left frame of the Add New Item dialog box, click Data and, in the middle frame, click ADO.NET Entity Data Model
  17. Change the Name to RentalManagementModel
  18. Click Add
  19. In the first page of the Entity Data Model Wizard, click Empty Code First Model

    Entity Data Model Wizard

  20. Click Finish
  21. To prepare the tables for the database, change the document as follows:
    namespace BethesdaCarRental1.Models
    {
        using System;
        using System.Data.Entity;
        using System.ComponentModel.DataAnnotations;
    
        public class RentalManagementModel : DbContext
        {
            // Your context has been configured to use a 'RentalManagementModel' connection string from your application's 
            // configuration file (App.config or Web.config). By default, this connection string targets the 
            // 'BethesdaCarRental1.Models.RentalManagementModel' database on your LocalDb instance. 
            // 
            // If you wish to target a different database and/or database provider, modify the 'RentalManagementModel' 
            // connection string in the application configuration file.
            public RentalManagementModel()
                : base("name=RentalManagementModel")
            {
            }
    
            // Add a DbSet for each entity type that you want to include in your model. For more information 
            // on configuring and using a Code First model, see http://go.microsoft.com/fwlink/?LinkId=390109.
    
            public virtual DbSet<Car> Cars { get; set; }
            public virtual DbSet<Employee> Employees { get; set; }
            public virtual DbSet<RentalOrder> RentalOrders { get; set; }
        }
    
        public class Car
        {
            public int    CarId { get; set; }
            public string TagNumber { get; set; }
            public string Category { get; set; }
            public string Make { get; set; }
            public string Model { get; set; }
            public int    Passengers { get; set; }
            public string Condition { get; set; }
            public string AvailabilityStatus { get; set; }
        }
    
        public class Employee
        {
            public int    EmployeeId { get; set; }
            public string EmployeeNumber { get; set; }
            public string FirstName { get; set; }
            public string LastName { get; set; }
            public string EmploymentTitle { get; set; }
        }
    
        public class RentalOrder
        {
            public int     RentalOrderId { get; set; }
            public int     EmployeeId { get; set; }
            public string  DriversLicenseNumber { get; set; }
            public string  FirstName { get; set; }
            public string  LastName { get; set; }
            public string  Address { get; set; }
            public string  City { get; set; }
            public string  County { get; set; }
            public string  State { get; set; }
            public string  ZIPCode { get; set; }
            public int     CarId { get; set; }
            public string  CarCondition { get; set; }
            public string  TankLevel { get; set; }
            public int     MileageStart { get; set; }
            public int     MileageEnd { get; set; }
            public int     MileageTotal { get; set; }
            public string  StartDate { get; set; }
            public string  EndDate { get; set; }
            public int     TotalDays { get; set; }
            public decimal RateApplied { get; set; }
            public decimal SubTotal { get; set; }
            public decimal TaxRate { get; set; }
            public decimal TaxAmount { get; set; }
            public decimal OrderTotal { get; set; }
            public string  PaymentDate { get; set; }
            public string  OrderStatus { get; set; }
        }
    }

Assistance with Data Entry

The Minimum Number of Characters

When creating a class for a table, you can specify that you want the user to enter a certain minimum number of character in the corresponding text box. To support this, the System.ComponentModel.DataAnnotations namespace provides an attribute named MinLength. When applying this attribute to a property in a class, add the parentheses to it and enter the desired number in the parentheses.

The Maximum Number of Characters

As seen in our introduction to text-based fields, databases support a maximum number of characters for a column. We have already seen many examples of how to specify this number in the parentheses of CHAR, VARCHAR, NCHAR and NVARCHAR. To let you specify the maximum number of characters that a column can hold, the System.ComponentModel.DataAnnotations namespace provides an attribute named MaxLength. This attribute is used or applied like its MinLength counterpart.

To let you specify both the minimum and maximum number of characters for a field, the System.ComponentModel.DataAnnotations namespace provides an attribute named StringLength. To support the minimum string length, the StringLengthAttribute class is equipped with a property named MinimumLength. To use it in a class, apply it to a proproperty and add parentheses to it. In the parentheses, assign the desired value to MinimumLength. The he StringLengthAttribute class also supports a maximum number of characters through a property named MaximumLength. It is used like its counterpart.

A Required Property

If you are creating a class that will be used in an entity framework, to let you indicate that the user must provide a value for the corresponding column of the table, the System.ComponentModel.DataAnnotations namespace provides an attribute named Required and that is reqpresented by the RequiredAttributre class.

To indicate that the user must provide a value for a column, mark its property with the Required attribute. Here are two examples:

using System.ComponentModel.DataAnnotations;

namespace DepartmentStore.Models
{
    public class StoreItem
    {
        public int ItemNumber { get; set; }

        [Required]
        public string ItemName { get; set; }

        public string Size { get; set; }

        [Required]
        public double UnitPrice { get; set; }
    }
}

The Caption of a Field

By default, when the value of a column displays, the database engine uses the name of the column to indicate the presence of the field. Some names are not very appropriate. The string that represents a field is referred to as its caption. Fortunately, you can set the caption to anything you want.

To assist you with the caption of a field, the System.ComponentModel.DataAnnotations namespace provides an attribute named DisplayAttribute. One of the properties of this attribute is named Name. The specify the caption of a field, assign the desired string to this property.

Practical LearningPractical Learning: Setting the Captions of Fields

  1. Change the classes as follows:
    namespace BethesdaCarRental1.Models
    {
        using System;
        using System.Data.Entity;
        using System.ComponentModel.DataAnnotations;
    
        public class RentalManagementModel : DbContext
        {
            // Your context has been configured to use a 'RentalManagementModel' connection string from your application's 
            // configuration file (App.config or Web.config). By default, this connection string targets the 
            // 'BethesdaCarRental1.Models.RentalManagementModel' database on your LocalDb instance. 
            // 
            // If you wish to target a different database and/or database provider, modify the 'RentalManagementModel' 
            // connection string in the application configuration file.
            public RentalManagementModel()
                : base("name=RentalManagementModel")
            {
            }
    
            // Add a DbSet for each entity type that you want to include in your model. For more information 
            // on configuring and using a Code First model, see http://go.microsoft.com/fwlink/?LinkId=390109.
    
            public virtual DbSet<Car> Cars { get; set; }
            public virtual DbSet<Employee> Employees { get; set; }
            public virtual DbSet<RentalOrder> RentalOrders { get; set; }
        }
    
        public class Car
        {
            [Display(Name = "Car ID")]
            public int    CarId { get; set; }
            [Required]
            [Display(Name = "Tag #")]
            public string TagNumber { get; set; }
            public string Category { get; set; }
            [Required]
            public string Make { get; set; }
            [Required]
            public string Model { get; set; }
            public int    Passengers { get; set; }
            public string Condition { get; set; }
            [Display(Name = "Availability Status")]
            public string AvailabilityStatus { get; set; }
        }
    
        public class Employee
        {
            [Display(Name = "Employee ID")]
            public int EmployeeId { get; set; }
            [Required]
            [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 class RentalOrder
        {
            [Display(Name = "Rental Order ID")]
            public int    RentalOrderId { get; set; }
            [Display(Name = "Processed By")]
            public int    EmployeeId { get; set; }
            [Required]
            [Display(Name = "Drv. Lic. #")]
            public string DriversLicenseNumber { get; set; }
            [Display(Name = "First Name")]
            public string FirstName { get; set; }
            [Required]
            [Display(Name = "Last Name")]
            public string LastName { get; set; }
            public string Address { get; set; }
            public string City { get; set; }
            public string County { get; set; }
            public string State { get; set; }
            [Display(Name = "ZIP Code")]
            public string  ZIPCode { get; set; }
            [Required]
            public int     CarId { get; set; }
            [Required]
            [Display(Name = "Car Condition")]
            public string  CarCondition { get; set; }
            [Required]
            [Display(Name = "Tank Level")]
            public string  TankLevel { get; set; }
            [Required]
            [Display(Name = "Mileage Start")]
            public int     MileageStart { get; set; }
            [Display(Name = "Mileage End")]
            public int     MileageEnd { get; set; }
            [Display(Name = "Total Mileage")]
            public int     MileageTotal { get; set; }
            [Display(Name = "Start Date")]
            public string  StartDate { get; set; }
            [Display(Name = "End Date")]
            public string  EndDate { get; set; }
            [Display(Name = "Total Days")]
            public int     TotalDays { get; set; }
            [Required]
            [Display(Name = "Rate Applied")]
            public decimal RateApplied { get; set; }
            [Display(Name = "Sub-Total")]
            public decimal SubTotal { get; set; }
            [Display(Name = "Tax Rate")]
            public decimal TaxRate { get; set; }
            [Display(Name = "Tax Amount")]
            public decimal TaxAmount { get; set; }
            [Display(Name = "Order Total")]
            public decimal OrderTotal { get; set; }
            [Display(Name = "Payment Date")]
            public string PaymentDate { get; set; }
            [Required]
            [Display(Name = "Order Status")]
            public string OrderStatus { get; set; }
        }
    }
  2. On the main menu, click Build -> Build Solution
  3. In the Solution Explorer, right-click BethesdaCarRental1 -> Add -> New Folder
  4. Type Images
  5. Copy and paste the following pictures to the Images folder:

    Background Picture
    Chair Chair Chair Chair
  6. In the Solution Explorer, right-click BethesdaCarRental1 -> Add -> Style Sheet
  7. Type BethesdaCarRental
  8. Click OK
  9. Create the styles as follows:
    body {
        background-color: white;
    }
    
    .bold             { font-weight:      600;       }
    .blue             { color:            #286090;   }
    .top-padding      { padding-top:      0.50em;    }
    .containment      { margin:           auto;
                        width:            500px;     }
    .centralized      { margin:           auto;
                        width:            780px;     }
    .heading          { color:            white;
                        background-color: steelblue; }
    #top-banner       { top:              0;
                        left:             0;
                        right:            0;
                        z-index:          1120;
                        width:            100%;
                        bottom:           auto;
                        position:         fixed;
                        height:           6.25em;
                        background-color: #202460;   }
    .push-down        { margin-top:       8em;       }
    .bordered         { border:           1px solid black;  }
    .parajust         { text-align:       justify;
                        font-family:     'Times New Roman', Garamond, Georgia, serif; }
    .navbar-fixed-top { top:              6.25em;            }
    .sect-title       { font-weight:      600;
                        font-size:        16px;
                        color:            maroon;
                        padding-bottom:   5px;
                        border-bottom:    2px dotted #0832a4; }
    .navbar-brand     { height:           28px;
                        font-size:        12px;
                        line-height:      16px;               }
    
    .navbar-inverse   { background-color: #263b95;
                        border-top:       3px solid #000; }
    .common-font      { font-family:      Georgia, Garamond, 'Times New Roman', serif; }
    
    .navbar-inverse .navbar-nav > li > a,
    .navbar-inverse .navbar-nav > li > a:link {
                        font-size:        12px;
                        line-height:      16px;
                        color:            #faf76f; }
    .navbar-inverse .navbar-nav > li > a:hover,
    .navbar-inverse .navbar-nav > li > a:focus {
                        font-size:        12px;
                        line-height:      16px;
                        background-color: #202460;
                        color:            lavender; }
  10. In the Solution Explorer, expand App_Start and double-click BundleConfig.cs
  11. Change the document as follows:
    using System.Web.Optimization;
    
    namespace BethesdaCarRental1
    {
        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/BethesdaCarRental.css"));
            }
        }
    }

A Controller to Create and Manage Records

The entity framework make it particularly easy to create views that are connected to the appropriate tables of a database. This is done by creating or generating a controller for each class that was created for the tables.

Practical LearningPractical Learning: Adding Controllers

  1. In the Solution Explorer, right-click Controllers -> Add -> Controller...
  2. In the middle frame, click MVC 5 Controller With Views, Using Entity Framework

    Add Scaffold

  3. Click Add
  4. In the Model Class combo box, select Employee (BethesdaCarRental1.Models)
  5. In the Data Context Class combo box, select RentalManagementModel (BethesdaCarRental1.Models).
    Make sure the Controller Name text box is displaying EmployeesController
  6. Click Add
  7. In the Solution Explorer, under Views and under Employees, double-click Create.cshtml
  8. Change the document as follows:
    @model BethesdaCarRental1.Models.Employee
    
    @{
        ViewBag.Title = "Create Employee";
    }
    
    <h2 class="common-font text-center bold blue">Employment Application</h2>
    
    <hr />
    
    @using (Html.BeginForm())
    {
        @Html.AntiForgeryToken()
    
        <div class="containment">
            <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-5" })
                    <div class="col-md-7">
                        @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-5" })
                    <div class="col-md-7">
                        @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-5" })
                    <div class="col-md-7">
                        @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-5" })
                    <div class="col-md-7">
                        @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="col-md-6 control-label">
                        @Html.ActionLink("Employees - Staff Members", "Index")
                    </label>
                    <div class="col-md-6">
                        <input type="submit" value="Hire this Employee" class="btn btn-primary" />
                    </div>
                </div>
            </div>
        </div>
    }
    
    @section Scripts {
        @Scripts.Render("~/bundles/jqueryval")
    }
  9. In the Solution Explorer, under Views and under Employees, double-click Delete.cshtml
  10. Change the document as follows:
    @model BethesdaCarRental1.Models.Employee
    
    @{
        ViewBag.Title = "Delete Employee";
    }
    
    <h2 class="common-font text-center bold blue">Delete Employee</h2>
    
    <h3 class="common-font text-center bold blue">Are you sure you want to delete this employee record?</h3>
    
    <div class="containment">
        <hr />
        <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 Record" class="btn btn-primary" /> ::
                @Html.ActionLink("Employees - Staff Members", "Index")
            </div>
        }
    </div>
  11. In the Solution Explorer, under Views and under Employees, double-click Details.cshtml
  12. Change the document as follows:
    @model BethesdaCarRental1.Models.Employee
    
    @{
        ViewBag.Title = "Employee Details";
    }
    
    <h2 class="common-font text-center bold blue">Employee Details</h2>
    
    <hr />
    
    <div class="containment">
        <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 class="text-center">
        @Html.ActionLink("Edit", "Edit", new { id = Model.EmployeeId }) |
        @Html.ActionLink("Employees - Staff Members", "Index")
    </p>
  13. In the Solution Explorer, under Views and under Employees, double-click Edit.cshtml
  14. Change the document as follows:
    @model BethesdaCarRental1.Models.Employee
    
    @{
        ViewBag.Title = "Edit/Update Employee Details";
    }
    
    <h2 class="common-font text-center bold blue">Edit/Update Employee Details</h2>
    
    <hr />
    
    @using (Html.BeginForm())
    {
        @Html.AntiForgeryToken()
    
        <div class="containment">
            <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-5" })
                    <div class="col-md-7">
                        @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-5" })
                    <div class="col-md-7">
                        @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-5" })
                    <div class="col-md-7">
                        @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-5" })
                    <div class="col-md-7">
                        @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="col-md-6 control-label">
                        @Html.ActionLink("Employees - Staff Members", "Index")
                    </label>
                    <div class="col-md-6">
                        <input type="submit" value="Update Employee Record" class="btn btn-primary" />
                    </div>
                </div>
            </div>
        </div>
    }
    
    @section Scripts {
        @Scripts.Render("~/bundles/jqueryval")
    }
  15. In the Solution Explorer, under Views and under Employees, double-click Index.cshtml
  16. Change the document as follows:
    @model IEnumerable<BethesdaCarRental1.Models.Employee>
    
    @{
        ViewBag.Title = "Employees";
    }
    
    <h2 class="bold blue common-font text-center">Employees - Staff Members</h2>
    
    <table class="table table-striped common-font">
        <tr>
            <th class="text-center">@Html.DisplayNameFor(model => model.EmployeeId)</th>
            <th>@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>@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>
  17. In the Solution Explorer, right-click Controllers -> Add -> New Scaffolded Item...
  18. In the left frame of the Add Scaffold dialog box, expand Common and click MVC
  19. In the middle list, click MVC 5 Controller With Views, Using Entity Framework

    Add Scaffold

  20. Click Add
  21. In the Model Class combo box, select Car (BethesdaCarRental1.Models)
  22. Make sure the Data Context Class combo box displays RentalManagementModel (BethesdaCarRental1.Models).
    Make sure the Controller Name text box is displaying CarsController.
    Click Add
  23. Change the CarsController class as follows:
    using BethesdaCarRental1.Models;
    using System.Collections.Generic;
    using System.Data.Entity;
    using System.Linq;
    using System.Net;
    using System.Web.Mvc;
    
    namespace BethesdaCarRental1.Controllers
    {
        public class CarsController : Controller
        {
            private RentalManagementModel db = new RentalManagementModel();
    
            // GET: Cars
            public ActionResult Index()
            {
                return View(db.Cars.ToList());
            }
    
            // GET: Cars/Details/5
            public ActionResult Details(int? id)
            {
                if (id == null)
                {
                    return new HttpStatusCodeResult(HttpStatusCode.BadRequest);
                }
                Car car = db.Cars.Find(id);
                if (car == null)
                {
                    return HttpNotFound();
                }
                return View(car);
            }
    
            // GET: Cars/Create
            public ActionResult Create()
            {
                List<SelectListItem> types = new List<SelectListItem>();
                List<SelectListItem> conditions = new List<SelectListItem>();
                List<SelectListItem> availabilities = new List<SelectListItem>();
    
                types.Add(new SelectListItem() { Text = "SUV",           Value = "SUV" });
                types.Add(new SelectListItem() { Text = "Compact",       Value = "Compact" });
                types.Add(new SelectListItem() { Text = "Economy",       Value = "Economy" });
                types.Add(new SelectListItem() { Text = "Mini Van",      Value = "Mini Van" });
                types.Add(new SelectListItem() { Text = "Standard",      Value = "Standard" });
                types.Add(new SelectListItem() { Text = "Full Size",     Value = "Full Size" });
                types.Add(new SelectListItem() { Text = "Pickup Truck",  Value = "Pickup Truck" });
                types.Add(new SelectListItem() { Text = "Passenger Van", Value = "Passenger Van" });
    
                availabilities.Add(new SelectListItem() { Text = "Other",          Value = "Other" });
                availabilities.Add(new SelectListItem() { Text = "Rented",         Value = "Rented" });
                availabilities.Add(new SelectListItem() { Text = "Available",      Value = "Available" });
                availabilities.Add(new SelectListItem() { Text = "Being Serviced", Value = "Being Serviced" });
    
                conditions.Add(new SelectListItem() { Text = "Other",         Value = "Other" });
                conditions.Add(new SelectListItem() { Text = "Excellent",     Value = "Excellent" });
                conditions.Add(new SelectListItem() { Text = "Driveable",     Value = "Driveable" });
                conditions.Add(new SelectListItem() { Text = "Needs Service", Value = "Needs Service" });
    
                ViewBag.Category           = types;
                ViewBag.Condition          = conditions;
                ViewBag.AvailabilityStatus = availabilities;
    
                return View();
            }
    
            // POST: Cars/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 = "CarId,TagNumber,Category,Make,Model,Passengers,Condition,AvailabilityStatus")] Car car)
            {
                if (ModelState.IsValid)
                {
                    db.Cars.Add(car);
                    db.SaveChanges();
                    return RedirectToAction("Index");
                }
    
                return View(car);
            }
    
            // GET: Cars/Edit/5
            public ActionResult Edit(int? id)
            {
                if (id == null)
                {
                    return new HttpStatusCodeResult(HttpStatusCode.BadRequest);
                }
                Car car = db.Cars.Find(id);
                if (car == null)
                {
                    return HttpNotFound();
                }
    
                List<SelectListItem> types = new List<SelectListItem>();
                List<SelectListItem> conditions = new List<SelectListItem>();
                List<SelectListItem> availabilities = new List<SelectListItem>();
    
                types.Add(new SelectListItem() { Text = "SUV",           Value = "SUV",           Selected = (car.Category == "SUV") });
                types.Add(new SelectListItem() { Text = "Compact",       Value = "Compact",       Selected = (car.Category == "Compact") });
                types.Add(new SelectListItem() { Text = "Economy",       Value = "Economy",       Selected = (car.Category == "Economy") });
                types.Add(new SelectListItem() { Text = "Mini Van",      Value = "Mini Van",      Selected = (car.Category == "Mini Van") });
                types.Add(new SelectListItem() { Text = "Category",      Value = "Category",      Selected = (car.Category == "Category") });
                types.Add(new SelectListItem() { Text = "Standard",      Value = "Standard",      Selected = (car.Category == "Standard") });
                types.Add(new SelectListItem() { Text = "Full Size",     Value = "Full Size",     Selected = (car.Category == "Full Size") });
                types.Add(new SelectListItem() { Text = "Pickup Truck",  Value = "Pickup Truck",  Selected = (car.Category == "Pickup Truck") });
                types.Add(new SelectListItem() { Text = "Passenger Van", Value = "Passenger Van", Selected = (car.Category == "Passenger Van") });
    
                availabilities.Add(new SelectListItem() { Text = "Other",          Value = "Other",          Selected = (car.AvailabilityStatus == "Other") });
                availabilities.Add(new SelectListItem() { Text = "Rented",         Value = "Rented",         Selected = (car.AvailabilityStatus == "Rented") });
                availabilities.Add(new SelectListItem() { Text = "Available",      Value = "Available",      Selected = (car.AvailabilityStatus == "Available") });
                availabilities.Add(new SelectListItem() { Text = "Being Serviced", Value = "Being Serviced", Selected = (car.AvailabilityStatus == "Being Serviced") });
    
                conditions.Add(new SelectListItem() { Text = "Other",         Value = "Other",         Selected = (car.Condition == "Other") });
                conditions.Add(new SelectListItem() { Text = "Excellent",     Value = "Excellent",     Selected = (car.Condition == "Excellent") });
                conditions.Add(new SelectListItem() { Text = "Driveable",     Value = "Driveable",     Selected = (car.Condition == "Driveable") });
                conditions.Add(new SelectListItem() { Text = "Needs Service", Value = "Needs Service", Selected = (car.Condition == "Needs Service") });
    
                ViewBag.Category           = types;
                ViewBag.Condition          = conditions;
                ViewBag.AvailabilityStatus = availabilities;
    
                return View(car);
            }
    
            // POST: Cars/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 = "CarId,TagNumber,Category,Make,Model,Passengers,Condition,AvailabilityStatus")] Car car)
            {
                if (ModelState.IsValid)
                {
                    db.Entry(car).State = EntityState.Modified;
                    db.SaveChanges();
                    return RedirectToAction("Index");
                }
                return View(car);
            }
    
            // GET: Cars/Delete/5
            public ActionResult Delete(int? id)
            {
                if (id == null)
                {
                    return new HttpStatusCodeResult(HttpStatusCode.BadRequest);
                }
                Car car = db.Cars.Find(id);
                if (car == null)
                {
                    return HttpNotFound();
                }
                return View(car);
            }
    
            // POST: Cars/Delete/5
            [HttpPost, ActionName("Delete")]
            [ValidateAntiForgeryToken]
            public ActionResult DeleteConfirmed(int id)
            {
                Car car = db.Cars.Find(id);
                db.Cars.Remove(car);
                db.SaveChanges();
                return RedirectToAction("Index");
            }
    
            protected override void Dispose(bool disposing)
            {
                if (disposing)
                {
                    db.Dispose();
                }
                base.Dispose(disposing);
            }
        }
    }
  24. In the Solution Explorer, under Views and under Cars, double-click Create.cshtml
  25. Change the document as follows:
    @model BethesdaCarRental1.Models.Car
    
    @{
        ViewBag.Title = "Create Car";
    }
    
    <h2 class="common-font text-center bold blue">Create Car/Vehicle</h2>
    
    <hr />
    
    @using (Html.BeginForm())
    {
        @Html.AntiForgeryToken()
    
        <div class="containment">
            <div class="form-horizontal common-font">
                @Html.ValidationSummary(true, "", new { @class = "text-danger" })
                <div class="form-group">
                    @Html.LabelFor(model => model.TagNumber, htmlAttributes: new { @class = "control-label col-md-5" })
                    <div class="col-md-7">
                        @Html.EditorFor(model => model.TagNumber, new { htmlAttributes = new { @class = "form-control" } })
                        @Html.ValidationMessageFor(model => model.TagNumber, "", new { @class = "text-danger" })
                    </div>
                </div>
    
                <div class="form-group">
                    @Html.LabelFor(model => model.Make, htmlAttributes: new { @class = "control-label col-md-5" })
                    <div class="col-md-7">
                        @Html.EditorFor(model => model.Make, new { htmlAttributes = new { @class = "form-control" } })
                        @Html.ValidationMessageFor(model => model.Make, "", new { @class = "text-danger" })
                    </div>
                </div>
    
                <div class="form-group">
                    @Html.LabelFor(model => model.Model, htmlAttributes: new { @class = "control-label col-md-5" })
                    <div class="col-md-7">
                        @Html.EditorFor(model => model.Model, new { htmlAttributes = new { @class = "form-control" } })
                        @Html.ValidationMessageFor(model => model.Model, "", new { @class = "text-danger" })
                    </div>
                </div>
    
                <div class="form-group">
                    @Html.LabelFor(model => model.Passengers, htmlAttributes: new { @class = "control-label col-md-5" })
                    <div class="col-md-7">
                        @Html.EditorFor(model => model.Passengers, new { htmlAttributes = new { @class = "form-control" } })
                        @Html.ValidationMessageFor(model => model.Passengers, "", new { @class = "text-danger" })
                    </div>
                </div>
    
                <div class="form-group">
                    @Html.LabelFor(model => model.Category, htmlAttributes: new { @class = "control-label col-md-5" })
                    <div class="col-md-7">
                        @Html.DropDownList("Category", ViewBag.Category as SelectList, htmlAttributes: new { @class = "form-control" })
                        @Html.ValidationMessageFor(model => model.Category, "", new { @class = "text-danger" })
                    </div>
                </div>
    
                <div class="form-group">
                    @Html.LabelFor(model => model.Condition, htmlAttributes: new { @class = "control-label col-md-5" })
                    <div class="col-md-7">
                        @Html.DropDownList("Condition", ViewBag.Condition as SelectList, htmlAttributes: new { @class = "form-control" })
                        @Html.ValidationMessageFor(model => model.Condition, "", new { @class = "text-danger" })
                    </div>
                </div>
    
                <div class="form-group">
                    @Html.LabelFor(model => model.AvailabilityStatus, htmlAttributes: new { @class = "control-label col-md-5" })
                    <div class="col-md-7">
                        @Html.DropDownList("AvailabilityStatus", ViewBag.AvailabilityStatus as SelectList, htmlAttributes: new { @class = "form-control" })
                        @Html.ValidationMessageFor(model => model.AvailabilityStatus, "", new { @class = "text-danger" })
                    </div>
                </div>
    
                <div class="form-group">
                    <label class="control-label col-md-6">
                        @Html.ActionLink("Cars/Vehicles", "Index")
                    </label>
                    <div class="col-md-6">
                        <input type="submit" value="Save Car Information" class="btn btn-primary" />
                    </div>
                </div>
            </div>
        </div>
    }
    
    @section Scripts {
        @Scripts.Render("~/bundles/jqueryval")
    }
  26. In the Solution Explorer, under Views and under Cars, double-click Delete.cshtml
  27. Change the document as follows:
    @model BethesdaCarRental1.Models.Car
    
    @{
        ViewBag.Title = "Delete Car";
    }
    
    <h2 class="common-font text-center bold blue">Delete Car/Vehicle</h2>
    <hr />
    
    <h3 class="common-font text-center bold blue">Are you sure you want to remove this car from our fleet?</h3>
    <div class="containment">
        <dl class="dl-horizontal common-font">
            <dt>@Html.DisplayNameFor(model => model.CarId)</dt>
            <dd>@Html.DisplayFor(model => model.CarId)</dd>
    
            <dt>@Html.DisplayNameFor(model => model.Category)</dt>
            <dd>@Html.DisplayFor(model => model.Category)</dd>
    
            <dt>@Html.DisplayNameFor(model => model.Make)</dt>
            <dd>@Html.DisplayFor(model => model.Make)</dd>
    
            <dt>@Html.DisplayNameFor(model => model.Model)</dt>
            <dd>@Html.DisplayFor(model => model.Model)</dd>
    
            <dt>@Html.DisplayNameFor(model => model.Passengers)</dt>
            <dd>@Html.DisplayFor(model => model.Passengers)</dd>
    
            <dt>@Html.DisplayNameFor(model => model.Condition)</dt>
            <dd>@Html.DisplayFor(model => model.Condition)</dd>
    
            <dt>@Html.DisplayNameFor(model => model.AvailabilityStatus)</dt>
            <dd>@Html.DisplayFor(model => model.AvailabilityStatus)</dd>
        </dl>
    
        @using (Html.BeginForm())
        {
            @Html.AntiForgeryToken()
    
            <div class="form-actions no-color">
                <input type="submit" value="Delete Car from System" class="btn btn-primary" /> ::
                @Html.ActionLink("Cars/Vehicles", "Index")
            </div>
        }
    </div>
  28. In the Solution Explorer, under Views and under Cars, double-click Details.cshtml
  29. Change the document as follows:
    @model BethesdaCarRental1.Models.Car
    
    @{
        ViewBag.Title = "Car Details";
    }
    
    <h2 class="common-font text-center bold blue">Car/Vehicle Details</h2>
    
    <hr />
    <div class="containment">
        <dl class="dl-horizontal common-font">
            <dt>@Html.DisplayNameFor(model => model.CarId)</dt>
            <dd>@Html.DisplayFor(model => model.CarId)</dd>
    
            <dt>@Html.DisplayNameFor(model => model.TagNumber)</dt>
            <dd>@Html.DisplayFor(model => model.TagNumber)</dd>
    
            <dt>@Html.DisplayNameFor(model => model.Category)</dt>
            <dd>@Html.DisplayFor(model => model.Category)</dd>
    
            <dt>@Html.DisplayNameFor(model => model.Make)</dt>
            <dd>@Html.DisplayFor(model => model.Make)</dd>
    
            <dt>@Html.DisplayNameFor(model => model.Model)</dt>
            <dd>@Html.DisplayFor(model => model.Model)</dd>
    
            <dt>@Html.DisplayNameFor(model => model.Passengers)</dt>
            <dd>@Html.DisplayFor(model => model.Passengers)</dd>
    
            <dt>@Html.DisplayNameFor(model => model.Condition)</dt>
            <dd>@Html.DisplayFor(model => model.Condition)</dd>
    
            <dt>@Html.DisplayNameFor(model => model.AvailabilityStatus)</dt>
            <dd>@Html.DisplayFor(model => model.AvailabilityStatus)</dd>
        </dl>
    </div>
    
    <p class="text-center">
        @Html.ActionLink("Edit Car Information", "Edit", new { id = Model.CarId }) |
        @Html.ActionLink("Cars/Vehicles", "Index")
    </p>
  30. In the Solution Explorer, under Views and under Cars, double-click Edit.cshtml
  31. Change the document as follows:
    @model BethesdaCarRental1.Models.Car
    
    @{
        ViewBag.Title = "Edit/Update Car Details";
    }
    
    <h2 class="common-font text-center bold blue">Edit/Update Car Information</h2>
    
    <hr />
    
    @using (Html.BeginForm())
    {
        @Html.AntiForgeryToken()
    
        <div class="containment">
            <div class="form-horizontal common-font">
                @Html.ValidationSummary(true, "", new { @class = "text-danger" })
                @Html.HiddenFor(model => model.CarId)
    
                <div class="form-group">
                    @Html.LabelFor(model => model.TagNumber, htmlAttributes: new { @class = "control-label col-md-5" })
                    <div class="col-md-7">
                        @Html.EditorFor(model => model.TagNumber, new { htmlAttributes = new { @class = "form-control" } })
                        @Html.ValidationMessageFor(model => model.TagNumber, "", new { @class = "text-danger" })
                    </div>
                </div>
    
                <div class="form-group">
                    @Html.LabelFor(model => model.Make, htmlAttributes: new { @class = "control-label col-md-5" })
                    <div class="col-md-7">
                        @Html.EditorFor(model => model.Make, new { htmlAttributes = new { @class = "form-control" } })
                        @Html.ValidationMessageFor(model => model.Make, "", new { @class = "text-danger" })
                    </div>
                </div>
    
                <div class="form-group">
                    @Html.LabelFor(model => model.Model, htmlAttributes: new { @class = "control-label col-md-5" })
                    <div class="col-md-7">
                        @Html.EditorFor(model => model.Model, new { htmlAttributes = new { @class = "form-control" } })
                        @Html.ValidationMessageFor(model => model.Model, "", new { @class = "text-danger" })
                    </div>
                </div>
    
                <div class="form-group">
                    @Html.LabelFor(model => model.Passengers, htmlAttributes: new { @class = "control-label col-md-5" })
                    <div class="col-md-7">
                        @Html.EditorFor(model => model.Passengers, new { htmlAttributes = new { @class = "form-control" } })
                        @Html.ValidationMessageFor(model => model.Passengers, "", new { @class = "text-danger" })
                    </div>
                </div>
    
                <div class="form-group">
                    @Html.LabelFor(model => model.Category, htmlAttributes: new { @class = "control-label col-md-5" })
                    <div class="col-md-7">
                        @Html.DropDownList("Category", ViewBag.Category as SelectList, htmlAttributes: new { @class = "form-control" })
                        @Html.ValidationMessageFor(model => model.Category, "", new { @class = "text-danger" })
                    </div>
                </div>
    
                <div class="form-group">
                    @Html.LabelFor(model => model.Condition, htmlAttributes: new { @class = "control-label col-md-5" })
                    <div class="col-md-7">
                        @Html.DropDownList("Condition", ViewBag.Condition as SelectList, htmlAttributes: new { @class = "form-control" })
                        @Html.ValidationMessageFor(model => model.Condition, "", new { @class = "text-danger" })
                    </div>
                </div>
    
                <div class="form-group">
                    @Html.LabelFor(model => model.AvailabilityStatus, htmlAttributes: new { @class = "control-label col-md-5" })
                    <div class="col-md-7">
                        @Html.DropDownList("AvailabilityStatus", ViewBag.AvailabilityStatus as SelectList, htmlAttributes: new { @class = "form-control" })
                        @Html.ValidationMessageFor(model => model.AvailabilityStatus, "", new { @class = "text-danger" })
                    </div>
                </div>
    
                <div class="form-group">
                    <label class="col-md-6 control-label">
                        @Html.ActionLink("Cars/Vehicles", "Index")
                    </label>
                    <div class="col-md-6">
                        <input type="submit" value="Update Car Information" class="btn btn-primary" />
                    </div>
                </div>
            </div>
        </div>
    }
    
    @section Scripts {
        @Scripts.Render("~/bundles/jqueryval")
    }
  32. In the Solution Explorer, under Views and under Cars, double-click Index.cshtml
  33. Change the document as follows:
    @model IEnumerable<BethesdaCarRental1.Models.Car>
    
    @{
        ViewBag.Title = "Cars/Vehicles";
    }
    
    <h2 class="bold blue common-font text-center">Cars/Vehicles</h2>
    
    <table class="table table-striped common-font">
        <tr>
            <th class="text-center">@Html.DisplayNameFor(model => model.CarId)</th>
            <th class="text-center">@Html.DisplayNameFor(model => model.TagNumber)</th>
            <th>@Html.DisplayNameFor(model => model.Make)</th>
            <th>@Html.DisplayNameFor(model => model.Model)</th>
            <th class="text-center">@Html.DisplayNameFor(model => model.Passengers)</th>
            <th>@Html.DisplayNameFor(model => model.Category)</th>
            <th>@Html.DisplayNameFor(model => model.Condition)</th>
            <th>@Html.DisplayNameFor(model => model.AvailabilityStatus)</th>
            <th>@Html.ActionLink("Create New Car", "Create")</th>
        </tr>
    
        @foreach (var item in Model)
        {
            <tr>
                <td class="text-center">@Html.DisplayFor(modelItem => item.CarId)</td>
                <td class="text-center">@Html.DisplayFor(modelItem => item.TagNumber)</td>
                <td>@Html.DisplayFor(modelItem => item.Make)</td>
                <td>@Html.DisplayFor(modelItem => item.Model)</td>
                <td class="text-center">@Html.DisplayFor(modelItem => item.Passengers)</td>
                <td>@Html.DisplayFor(modelItem => item.Category)</td>
                <td>@Html.DisplayFor(modelItem => item.Condition)</td>
                <td>@Html.DisplayFor(modelItem => item.AvailabilityStatus)</td>
                <td>
                    @Html.ActionLink("Edit", "Edit", new { id = item.CarId }) |
                    @Html.ActionLink("Details", "Details", new { id = item.CarId }) |
                    @Html.ActionLink("Delete", "Delete", new { id = item.CarId })
                </td>
            </tr>
        }
    </table>
  34. In the Solution Explorer, right-click Controllers -> Add -> Controller...
  35. In the middle frame of the Add Scaffold dialog box, make sure MVC 5 Controller With Views, Using Entity Framework is selected.
    Click Add
  36. In the Model Class combo box, select RentalOrder (BethesdaCarRental1.Models)
  37. Make sure the Data Context Class combo box is displaying RentalManagementModel (BethesdaCarRental1.Models).
    Make sure the Controller Name text box is displaying RentalOrdersController.
    Click Add
  38. Change the class as follows:
    using BethesdaCarRental1.Models;
    using System;
    using System.Collections.Generic;
    using System.Data.Entity;
    using System.Linq;
    using System.Net;
    using System.Web.Mvc;
    
    namespace BethesdaCarRental1.Controllers
    {
        public class RentalOrdersController : Controller
        {
            private RentalManagementModel db = new RentalManagementModel();
    
            // GET: RentalOrders
            public ActionResult Index()
            {
                return View(db.RentalOrders.ToList());
            }
    
            // GET: RentalOrders/Details/5
            public ActionResult Details(int? id)
            {
                if (id == null)
                {
                    return new HttpStatusCodeResult(HttpStatusCode.BadRequest);
                }
                RentalOrder rentalOrder = db.RentalOrders.Find(id);
    
                foreach(Employee staff in db.Employees)
                {
                    if( staff.EmployeeId == rentalOrder.EmployeeId)
                    {
                        ViewData["Clerk"] = staff.EmployeeNumber + " - " + staff.FirstName + " " + staff.LastName + " (" + staff.EmploymentTitle + ")";
                    }
                }
    
                foreach (Car vehicle in db.Cars)
                {
                    if (vehicle.CarId == rentalOrder.CarId)
                    {
                        ViewData["CarSelected"] = vehicle.Make + " - " + vehicle.Model + " (" + vehicle.TagNumber + ")";
                    }
                }
    
                if (rentalOrder == null)
                {
                    return HttpNotFound();
                }
                return View(rentalOrder);
            }
    
            // GET: RentalOrders/NewRentalOrder
            public ActionResult StartRentalOrder()
            {
                return View();
            }
    
            // GET: RentalOrders/PrepareRentalOrder
            public ActionResult PrepareRentalOrder(string EmployeeNumber, string TagNumber)
            {
                if (!string.IsNullOrEmpty(EmployeeNumber))
                {
                    foreach (var staff in db.Employees)
                    {
                        if (staff.EmployeeNumber == EmployeeNumber)
                        {
                            ViewBag.EmployeeId = staff.EmployeeId;
                            ViewBag.EmployeeDetails = EmployeeNumber + " - " +
                                                      staff.FirstName + " " + staff.LastName +
                                                      " (" + staff.EmploymentTitle + ")";
                            break;
                        }
                    }
                }
    
                if (!string.IsNullOrEmpty(TagNumber))
                {
                    foreach (var car in db.Cars)
                    {
                        if (car.TagNumber == TagNumber)
                        {
                            ViewBag.CarId = car.CarId;
                            ViewBag.VehicleDetails = car.Make + " " + car.Model +
                                                     " (" + car.Category + ")";
                            break;
                        }
                    }
                }
    
                List<SelectListItem> tanks      = new List<SelectListItem>();
                List<SelectListItem> status     = new List<SelectListItem>();
                List<SelectListItem> conditions = new List<SelectListItem>();
    
                conditions.Add(new SelectListItem() { Text = "Other",         Value = "Other" });
                conditions.Add(new SelectListItem() { Text = "Excellent",     Value = "Excellent" });
                conditions.Add(new SelectListItem() { Text = "Driveable",     Value = "Driveable" });
                conditions.Add(new SelectListItem() { Text = "Needs Service", Value = "Needs Service" });
    
                tanks.Add(new SelectListItem() { Text = "Empty",     Value = "Empty" });
                tanks.Add(new SelectListItem() { Text = "1/4 Empty", Value = "1/4 Empty" });
                tanks.Add(new SelectListItem() { Text = "Half",      Value = "Half" });
                tanks.Add(new SelectListItem() { Text = "3/4 Full",  Value = "3/4 Full" });
                tanks.Add(new SelectListItem() { Text = "Full",      Value = "Full" });
    
                status.Add(new SelectListItem() { Text = "Other",           Value = "Other" });
                status.Add(new SelectListItem() { Text = "Ongoing",         Value = "Ongoing" });
                status.Add(new SelectListItem() { Text = "Order Reserved",  Value = "Order Reserved" });
                status.Add(new SelectListItem() { Text = "Order Completed", Value = "Order Completed" });
    
                ViewBag.TankLevel    = tanks;
                ViewBag.OrderStatus  = status;
                ViewBag.CarCondition = conditions;
    
                return View();
            }
    
            // GET: RentalOrders/Create
            public ActionResult Create()
            {
                return View();
            }
    
            // POST: RentalOrders/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 = "RentalOrderId,EmployeeId,DriversLicenseNumber,FirstName,LastName,Address,City,County,State,ZIPCode,CarId,CarCondition,TankLevel,MileageStart,MileageEnd,MileageTotal,StartDate,EndDate,TotalDays,RateApplied,SubTotal,TaxRate,TaxAmount,OrderTotal,PaymentDate,OrderStatus")] RentalOrder rentalOrder)
            {
                if (ModelState.IsValid)
                {
                    db.RentalOrders.Add(rentalOrder);
    
                    // Find the car that was just rented...
                    foreach (Car vehicle in db.Cars)
                    {
                        if (vehicle.CarId == rentalOrder.CarId)
                        {
                            // ... and set its availability to Rented
                            vehicle.AvailabilityStatus = "Rented";
                            break;
                        }
                    }
                    
                    db.SaveChanges();
                    return RedirectToAction("Index");
                }
    
                return View(rentalOrder);
            }
    
            // GET: RentalOrders/StartRentalOrderReturn
            public ActionResult StartRentalOrderReturn()
            {
                return View();
            }
    
            // GET: RentalOrders/StartRentalOrderReturn
            public ActionResult ContinueRentalOrderReturn(FormCollection collection)
            {
                if (collection["RentalOrderId"] == null)
                {
                    return new HttpStatusCodeResult(HttpStatusCode.BadRequest);
                }
                RentalOrder rentalOrder = db.RentalOrders.Find(int.Parse(collection["RentalOrderId"]));
                if (rentalOrder == null)
                {
                    return HttpNotFound();
                }
    
                foreach (var staff in db.Employees)
                {
                    if (staff.EmployeeId == rentalOrder.EmployeeId)
                    {
                        ViewBag.EmployeeDetails = staff.EmployeeNumber + " - " +
                                                  staff.FirstName + " " + staff.LastName +
                                                  " (" + staff.EmploymentTitle + ")";
                        break;
                    }
                }
    
                foreach (var car in db.Cars)
                {
                    if (car.CarId == rentalOrder.CarId)
                    {
                        ViewBag.VehicleDetails = car.Make + " " + car.Model +
                                                 " (" + car.Category + ")";
                        break;
                    }
                }
    
                return View(rentalOrder);
            }
    
            // GET: RentalOrders/PrepareRentalOrderReturn
            public ActionResult PrepareRentalOrderReturn(FormCollection collection)
            {
                if (collection["RentalOrderId"] == null)
                {
                    return new HttpStatusCodeResult(HttpStatusCode.BadRequest);
                }
                RentalOrder rentalOrder = db.RentalOrders.Find(int.Parse(collection["RentalOrderId"]));
                if (rentalOrder == null)
                {
                    return HttpNotFound();
                }
    
                ViewData["RentalOrderId"] = rentalOrder.RentalOrderId;
    
                foreach (var staff in db.Employees)
                {
                    if (staff.EmployeeId == rentalOrder.EmployeeId)
                    {
                        ViewData["EmployeeId"] = rentalOrder.EmployeeId;
                        ViewBag.EmployeeDetails = staff.EmployeeNumber + " - " +
                                                  staff.FirstName + " " + staff.LastName +
                                                  " (" + staff.EmploymentTitle + ")";
                        break;
                    }
                }
    
                foreach (var car in db.Cars)
                {
                    if (car.CarId == rentalOrder.CarId)
                    {
                        ViewData["CarId"] = rentalOrder.CarId;
                        ViewBag.VehicleDetails = car.Make + " " + car.Model +
                                                 " (" + car.Category + ")";
                        break;
                    }
                }
    
                ViewData["DriversLicenseNumber"] = rentalOrder.DriversLicenseNumber;
                ViewData["FirstName"] = rentalOrder.FirstName;
                ViewData["LastName"] = rentalOrder.LastName;
                ViewData["Address"] = rentalOrder.Address;
                ViewData["City"] = rentalOrder.City;
                ViewData["County"] = rentalOrder.County;
                ViewData["State"] = rentalOrder.State;
                ViewData["ZIPCode"] = rentalOrder.ZIPCode;
    
                List<SelectListItem> tanks      = new List<SelectListItem>();
                List<SelectListItem> status     = new List<SelectListItem>();
                List<SelectListItem> conditions = new List<SelectListItem>();
    
                conditions.Add(new SelectListItem() { Text = "Other",         Value = "Other",         Selected = (rentalOrder.CarCondition == "Other") });
                conditions.Add(new SelectListItem() { Text = "Excellent",     Value = "Excellent",     Selected = (rentalOrder.CarCondition == "Excellent") });
                conditions.Add(new SelectListItem() { Text = "Driveable",     Value = "Driveable",     Selected = (rentalOrder.CarCondition == "Driveable") });
                conditions.Add(new SelectListItem() { Text = "Needs Service", Value = "Needs Service", Selected = (rentalOrder.CarCondition == "Needs Service") });
    
                tanks.Add(new SelectListItem() { Text = "Empty",     Value = "Empty",     Selected = (rentalOrder.TankLevel == "Empty") });
                tanks.Add(new SelectListItem() { Text = "1/4 Empty", Value = "1/4 Empty", Selected = (rentalOrder.TankLevel == "1/4 Empty") });
                tanks.Add(new SelectListItem() { Text = "Half",      Value = "Half",      Selected = (rentalOrder.TankLevel == "Half") });
                tanks.Add(new SelectListItem() { Text = "3/4 Full",  Value = "3/4 Full",  Selected = (rentalOrder.TankLevel == "3/4 Full") });
                tanks.Add(new SelectListItem() { Text = "Full",      Value = "Full",      Selected = (rentalOrder.TankLevel == "Full") });
    
                status.Add(new SelectListItem() { Text = "Other",           Value = "Other",           Selected = (rentalOrder.OrderStatus == "Other") });
                status.Add(new SelectListItem() { Text = "Ongoing",         Value = "Ongoing",         Selected = (rentalOrder.OrderStatus == "Ongoing") });
                status.Add(new SelectListItem() { Text = "Order Reserved",  Value = "Order Reserved",  Selected = (rentalOrder.OrderStatus == "Order Reserved") });
                status.Add(new SelectListItem() { Text = "Order Completed", Value = "Order Completed", Selected = (rentalOrder.OrderStatus == "Order Completed") });
    
                ViewBag.TankLevel = tanks;
                ViewBag.OrderStatus = status;
                ViewBag.CarCondition = conditions;
    
                TimeSpan tsDays = DateTime.Parse(collection["EndDate"]) - DateTime.Parse(collection["StartDate"]);
    
                int days = tsDays.Days;
                decimal subTotal = decimal.Parse(collection["RateApplied"]) * days;
                decimal taxAmount = subTotal * decimal.Parse(collection["TaxRate"]) / 100;
    
                ViewBag.TotalDays = days;
                ViewBag.TaxRate = collection["TaxRate"];
                ViewBag.SubTotal = subTotal.ToString("F");
                ViewBag.TaxAmount = taxAmount.ToString("F");
                ViewData["EndDate"] = collection["EndDate"];
                ViewData["StartDate"] = collection["StartDate"];
                ViewBag.RateApplied = collection["RateApplied"];
                ViewData["MileageEnd"] = collection["MileageEnd"];
                ViewData["MileageStart"] = collection["MileageStart"];
                ViewBag.OrderTotal = (subTotal + taxAmount).ToString("F");
                ViewBag.MileageTotal = int.Parse(collection["MileageEnd"]) - int.Parse(collection["MileageStart"]);
    
                ViewBag.TankLevel = tanks;
                ViewBag.OrderStatus = status;
                ViewBag.CarCondition = conditions;
    
                return View();
            }
    
            // POST: RentalOrders/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 SaveRentalOrderReturn([Bind(Include = "RentalOrderId,EmployeeId,DriversLicenseNumber,FirstName,LastName,Address,City,County,State,ZIPCode,CarId,CarCondition,TankLevel,MileageStart,MileageEnd,MileageTotal,StartDate,EndDate,TotalDays,RateApplied,SubTotal,TaxRate,TaxAmount,OrderTotal,PaymentDate,OrderStatus")] RentalOrder rentalOrder)
            {
                if (ModelState.IsValid)
                {
                    db.Entry(rentalOrder).State = EntityState.Modified;
                    db.SaveChanges();
                    return RedirectToAction("Index");
                }
                
                return View(rentalOrder);
            }
    
            // GET: RentalOrders/Edit/5
            public ActionResult Edit(int? id)
            {
                if (id == null)
                {
                    return new HttpStatusCodeResult(HttpStatusCode.BadRequest);
                }
                RentalOrder rentalOrder = db.RentalOrders.Find(id);
                if (rentalOrder == null)
                {
                    return HttpNotFound();
                }
    
                List<SelectListItem> gas        = new List<SelectListItem>();
                List<SelectListItem> status     = new List<SelectListItem>();
                List<SelectListItem> conditions = new List<SelectListItem>();
    
                foreach (var staff in db.Employees)
                {
                    if (staff.EmployeeId == rentalOrder.EmployeeId)
                    {
                        ViewBag.EmployeeDetails = staff.EmployeeNumber + " - " +
                                                  staff.FirstName + " " + staff.LastName +
                                                  " (" + staff.EmploymentTitle + ")";
                        break;
                    }
                }
    
                foreach (var car in db.Cars)
                {
                    if (car.CarId == rentalOrder.CarId)
                    {
                        ViewBag.VehicleDetails = car.Make + " " + car.Model +
                                                 " (" + car.Category + ")";
                        break;
                    }
                }
    
                conditions.Add(new SelectListItem() { Text = "Other",         Value = "Other",         Selected = (rentalOrder.CarCondition == "Other")         });
                conditions.Add(new SelectListItem() { Text = "Excellent",     Value = "Excellent",     Selected = (rentalOrder.CarCondition == "Excellent")     });
                conditions.Add(new SelectListItem() { Text = "Driveable",     Value = "Driveable",     Selected = (rentalOrder.CarCondition == "Driveable")     });
                conditions.Add(new SelectListItem() { Text = "Needs Service", Value = "Needs Service", Selected = (rentalOrder.CarCondition == "Needs Service") });
    
                gas.Add(new SelectListItem() { Text = "Empty",     Value = "Empty",     Selected = (rentalOrder.TankLevel == "Empty")     });
                gas.Add(new SelectListItem() { Text = "1/4 Empty", Value = "1/4 Empty", Selected = (rentalOrder.TankLevel == "1/4 Empty") });
                gas.Add(new SelectListItem() { Text = "Half",      Value = "Half",      Selected = (rentalOrder.TankLevel == "Half")      });
                gas.Add(new SelectListItem() { Text = "3/4 Full",  Value = "3/4 Full",  Selected = (rentalOrder.TankLevel == "3/4 Full")  });
                gas.Add(new SelectListItem() { Text = "Full",      Value = "Full",      Selected = (rentalOrder.TankLevel == "Full")      });
    
                status.Add(new SelectListItem() { Text = "Other",           Value = "Other",           Selected = (rentalOrder.OrderStatus == "Other")           });
                status.Add(new SelectListItem() { Text = "Ongoing",         Value = "Ongoing",         Selected = (rentalOrder.OrderStatus == "Ongoing")         });
                status.Add(new SelectListItem() { Text = "Order Reserved",  Value = "Order Reserved",  Selected = (rentalOrder.OrderStatus == "Order Reserved")  });
                status.Add(new SelectListItem() { Text = "Order Completed", Value = "Order Completed", Selected = (rentalOrder.OrderStatus == "Order Completed") });
    
                ViewBag.TankLevel    = gas;
                ViewBag.OrderStatus  = status;
                ViewBag.CarCondition = conditions;
    
                return View(rentalOrder);
            }
    
            // POST: RentalOrders/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 = "RentalOrderId,EmployeeId,DriversLicenseNumber,FirstName,LastName,Address,City,County,State,ZIPCode,CarId,CarCondition,TankLevel,MileageStart,MileageEnd,MileageTotal,StartDate,EndDate,TotalDays,RateApplied,SubTotal,TaxRate,TaxAmount,OrderTotal,PaymentDate,OrderStatus")] RentalOrder rentalOrder)
            {
                if (ModelState.IsValid)
                {
                    db.Entry(rentalOrder).State = EntityState.Modified;
                    db.SaveChanges();
                    return RedirectToAction("Index");
                }
                return View(rentalOrder);
            }
    
            // GET: RentalOrders/Delete/5
            public ActionResult Delete(int? id)
            {
                if (id == null)
                {
                    return new HttpStatusCodeResult(HttpStatusCode.BadRequest);
                }
                RentalOrder rentalOrder = db.RentalOrders.Find(id);
    
                foreach (Employee staff in db.Employees)
                {
                    if (staff.EmployeeId == rentalOrder.EmployeeId)
                    {
                        ViewData["Clerk"] = staff.EmployeeNumber + " - " + staff.FirstName + " " + staff.LastName + " (" + staff.EmploymentTitle + ")";
                    }
                }
    
                foreach (Car vehicle in db.Cars)
                {
                    if (vehicle.CarId == rentalOrder.CarId)
                    {
                        ViewData["CarSelected"] = vehicle.Make + " - " + vehicle.Model + " (" + vehicle.TagNumber + ")";
                    }
                }
    
                if (rentalOrder == null)
                {
                    return HttpNotFound();
                }
                return View(rentalOrder);
            }
    
            // POST: RentalOrders/Delete/5
            [HttpPost, ActionName("Delete")]
            [ValidateAntiForgeryToken]
            public ActionResult DeleteConfirmed(int id)
            {
                RentalOrder rentalOrder = db.RentalOrders.Find(id);
                db.RentalOrders.Remove(rentalOrder);
                db.SaveChanges();
                return RedirectToAction("Index");
            }
    
            protected override void Dispose(bool disposing)
            {
                if (disposing)
                {
                    db.Dispose();
                }
                base.Dispose(disposing);
            }
        }
    }
  39. In the class, right-click StartRentalOrder -> Add View...
  40. Make sure the View Name text box is displaying StartRentalOrder. Click Add
  41. Create the webpage as follows:
    @model BethesdaCarRental1.Models.RentalOrder
    
    @{
        ViewBag.Title = "Rental Order Start-Up";
    }
    
    <h2 class="common-font text-center bold blue">Rental Order Start-Up</h2>
    
    @using (Html.BeginForm("PrepareRentalOrder", "RentalOrders", FormMethod.Post))
    {
        <div class="containment">
            <div class="form-horizontal common-font">
                <div class="heading"><p class="text-center">Rental Order Processed By</p></div>
    
                <div class="form-group">
                    <label class="control-label col-md-5">Employee #</label>
    
                    <div class="col-md-7">
                        @Html.TextBox("EmployeeNumber", null,
                                      htmlAttributes: new { @class = "form-control", placeholder = "Enter Employee #" })
                    </div>
                </div>
    
                <div class="heading"><p class="text-center">Car Selected</p></div>
    
                <div class="form-group">
                    <label class="control-label col-md-5">Vehicle Tag #</label>
                    <div class="col-md-7">
                        @Html.TextBox("TagNumber", null,
                                        htmlAttributes: new { @class = "form-control", placeholder = "Enter Car Tag #" })
                    </div>
                </div>
                <hr />
                <div class="form-group">
                    <label class="col-md-6 control-label">
                        @Html.ActionLink("Rental Orders", "Index")
                    </label>
                    <div class="col-md-6">
                        <input type="submit" value="Prepare Rental Order" class="btn btn-primary" />
                    </div>
                </div>
            </div>
        </div>
    }
  42. In the Solution Explorer, under Views, right-click RentalOrders -> Add -> View...
  43. Type PrepareRentalOrder as the name of the view
  44. Click Add
  45. Create the webpage as follows:
    @model BethesdaCarRental1.Models.RentalOrder
    
    @{
        ViewBag.Title = "Prepare Rental Order";
    }
    
    <h2 class="common-font text-center bold blue">Prepare Rental Order</h2>
    
    @using (Html.BeginForm("Create", "RentalOrders", FormMethod.Post))
    {
        @Html.AntiForgeryToken()
    
        <div class="form-horizontal common-font">
                <div class="heading"><p class="text-center">Rental Order Preliminary Information</p></div>
    
                <div class="form-group">
                    @Html.LabelFor(model => model.EmployeeId, htmlAttributes: new { @class = "control-label col-md-3 blue" })
                    <div class="col-md-1">
                        @Html.TextBox("EmployeeId", ViewBag.EmployeeId as string, htmlAttributes: new { @class = "form-control" })
                    </div>
                    <div class="col-md-6 top-padding">@ViewBag.EmployeeDetails</div>
                </div>
    
                <div class="heading"><p class="text-center">Customer Information</p></div>
    
                <div class="form-group">
                    @Html.LabelFor(model => model.DriversLicenseNumber, htmlAttributes: new { @class = "control-label col-md-3 blue" })
                    <div class="col-md-2">
                        @Html.TextBox("DriversLicenseNumber", ViewData["DriversLicenseNumber"], htmlAttributes: new { @class = "form-control" })
                        @Html.ValidationMessageFor(model => model.DriversLicenseNumber, "", new { @class = "text-danger" })
                    </div>
                </div>
    
                <div class="form-group">
                    @Html.LabelFor(model => model.FirstName, htmlAttributes: new { @class = "control-label col-md-3 blue" })
                    <div class="col-md-2">
                        @Html.TextBox("FirstName", ViewData["FirstName"], htmlAttributes: new { @class = "form-control" })
                        @Html.ValidationMessageFor(model => model.FirstName, "", new { @class = "text-danger" })
                    </div>
                    @Html.LabelFor(model => model.LastName, htmlAttributes: new { @class = "control-label col-md-3 blue" })
                    <div class="col-md-2">
                        @Html.TextBox("LastName", ViewData["LastName"], htmlAttributes: new { @class = "form-control" })
                        @Html.ValidationMessageFor(model => model.LastName, "", new { @class = "text-danger" })
                    </div>
                </div>
    
                <div class="form-group">
                    @Html.LabelFor(model => model.Address, htmlAttributes: new { @class = "control-label col-md-3 blue" })
                    <div class="col-md-7">
                        @Html.TextBox("Address", ViewData["Address"], 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-3 blue" })
                    <div class="col-md-2">
                        @Html.TextBox("City", ViewData["City"], htmlAttributes: new { @class = "form-control" })
                        @Html.ValidationMessageFor(model => model.City, "", new { @class = "text-danger" })
                    </div>
                    @Html.LabelFor(model => model.County, htmlAttributes: new { @class = "control-label col-md-3 blue" })
                    <div class="col-md-2">
                        @Html.TextBox("County", ViewData["County"], htmlAttributes: new { @class = "form-control" })
                        @Html.ValidationMessageFor(model => model.County, "", new { @class = "text-danger" })
                    </div>
                </div>
    
                <div class="form-group">
                    @Html.LabelFor(model => model.State, htmlAttributes: new { @class = "control-label col-md-3 blue" })
                    <div class="col-md-2">
                        @Html.TextBox("State", ViewData["State"], htmlAttributes: new { @class = "form-control" })
                        @Html.ValidationMessageFor(model => model.State, "", new { @class = "text-danger" })
                    </div>
                    @Html.LabelFor(model => model.ZIPCode, htmlAttributes: new { @class = "control-label col-md-3 blue" })
                    <div class="col-md-2">
                        @Html.TextBox("ZIPCode", ViewData["ZIPCode"], htmlAttributes: new { @class = "form-control" })
                        @Html.ValidationMessageFor(model => model.ZIPCode, "", new { @class = "text-danger" })
                    </div>
                </div>
    
                <div class="heading"><p class="text-center">Rental Summary</p></div>
    
                <div class="form-group">
                    <label for="carId" class="control-label col-md-3 blue">Car Selected</label>
                    <div class="col-md-1">
                        @Html.TextBox("CarId", ViewBag.CarId as string,
                                      htmlAttributes: new { @class = "form-control" })
                    </div>
                    <div class="col-md-6 top-padding">@ViewBag.VehicleDetails</div>
                </div>
    
                <div class="form-group">
                    @Html.LabelFor(model => model.CarCondition, htmlAttributes: new { @class = "control-label col-md-3 blue" })
                    <div class="col-md-2">
                        @Html.DropDownList("CarCondition", ViewBag.CarCondition as SelectList, htmlAttributes: new { @class = "form-control" })
                        @Html.ValidationMessageFor(model => model.CarCondition, "", new { @class = "text-danger" })
                    </div>
                    @Html.LabelFor(model => model.TankLevel, htmlAttributes: new { @class = "control-label col-md-3 blue" })
                    <div class="col-md-2">
                        @Html.DropDownList("TankLevel", ViewBag.TankLevel as SelectList, htmlAttributes: new { @class = "form-control" })
                        @Html.ValidationMessageFor(model => model.TankLevel, "", new { @class = "text-danger" })
                    </div>
                </div>
    
                <div class="form-group">
                    @Html.LabelFor(model => model.MileageStart, htmlAttributes: new { @class = "control-label col-md-3 blue" })
                    <div class="col-md-2">
                        @Html.EditorFor(model => model.MileageStart, new { htmlAttributes = new { @class = "form-control" } })
                        @Html.ValidationMessageFor(model => model.MileageStart, "", new { @class = "text-danger" })
                    </div>
                    @Html.LabelFor(model => model.StartDate,
                                   htmlAttributes: new { @class = "control-label col-md-3 blue" })
                    <div class="col-md-2">
                        @Html.EditorFor(model => model.StartDate,
                                        new { htmlAttributes = new { @class = "form-control", type = "date" } })
                        @Html.ValidationMessageFor(model => model.StartDate, "", new { @class = "text-danger" })
                    </div>
                </div>
    
                <div class="form-group">
                    @Html.LabelFor(model => model.RateApplied, htmlAttributes: new { @class = "control-label col-md-2 blue" })
                    <div class="col-md-2">
                        @Html.EditorFor(model => model.RateApplied, new { htmlAttributes = new { @class = "form-control" } })
                        @Html.ValidationMessageFor(model => model.RateApplied, "", new { @class = "text-danger" })
                    </div>
    
                    @Html.LabelFor(model => model.TaxRate, htmlAttributes: new { @class = "control-label col-md-2 blue" })
                    <div class="col-md-1">
                        @Html.EditorFor(model => model.TaxRate, new { htmlAttributes = new { @class = "form-control" } })
                        @Html.ValidationMessageFor(model => model.TaxRate, "", new { @class = "text-danger" })
                    </div>
                    <div class="form-group">
                        @Html.LabelFor(model => model.OrderStatus, htmlAttributes: new { @class = "control-label col-md-3 blue" })
                        <div class="col-md-2">
                            @Html.DropDownList("OrderStatus", ViewBag.OrderStatus as SelectList, htmlAttributes: new { @class = "form-control" })
                            @Html.ValidationMessageFor(model => model.OrderStatus, "", new { @class = "text-danger" })
                        </div>
                    </div>
                </div>
    
                <hr />
    
                <div class="form-group">
                    <label class="col-md-6 control-label">
                        @Html.ActionLink("Rental Orders", "Index")
                    </label>
                    <div class="col-md-6">
                        <input type="submit" value="Save Rental Order" class="btn btn-primary" />
                    </div>
                </div>
     
        </div>
    }
  46. In the Solution Explorer, under Views, right-click RentalOrders and click Add View...
  47. Type StartRentalOrderReturn as the Name of the view
  48. Click Add
  49. Change the document as follows:
    @model BethesdaCarRental1.Models.RentalOrder
    
    @{
        ViewBag.Title = "Rental Order Return Start-Up";
    }
    
    <h2 class="common-font text-center bold blue">Rental Order Return Start-Up</h2>
    
    @using (Html.BeginForm("ContinueRentalOrderReturn", "RentalOrders", FormMethod.Post))
    {
        @Html.AntiForgeryToken()
    
        <div class="form-horizontal common-font">
            @Html.ValidationSummary(true, "", new { @class = "text-danger" })
            <div class="form-group">
                @Html.LabelFor(model => model.RentalOrderId, htmlAttributes: new { @class = "control-label col-md-5" })
                <div class="col-md-1">
                    @Html.EditorFor(model => model.RentalOrderId, new { htmlAttributes = new { @class = "form-control" } })
                    @Html.ValidationMessageFor(model => model.RentalOrderId, "", new { @class = "text-danger" })
                </div>
            </div>
    
            <div class="form-group">
                <label class="control-label col-md-6">
                    @Html.ActionLink("Rental Orders", "Index")
                </label>
                <div class="col-md-6">
                    <input type="submit" value="Continue Rental Order Return" class="btn btn-primary" />
                </div>
            </div>
        </div>
    }
  50. In the Solution Explorer, under Views, right-click RentalOrders and click Add View...
  51. Type ContinueRentalOrderReturn as the Name of the view
  52. Click Add
  53. Change the document as follows:
    @model BethesdaCarRental1.Models.RentalOrder
    
    @{
        ViewBag.Title = "Continue Rental Order Return";
    }
    
    <h2 class="common-font text-center bold blue">Continue Rental Order Return</h2>
    
    @using (Html.BeginForm("PrepareRentalOrderReturn", "RentalOrders", FormMethod.Post))
    {
        @Html.AntiForgeryToken()
    
    <div class="form-horizontal common-font">
        <div class="heading"><p class="text-center">Rental Order Preliminary Information</p></div>
    
        <div class="form-group">
            @Html.LabelFor(model => model.RentalOrderId, htmlAttributes: new { @class = "control-label col-md-3 blue" })
            <div class="col-md-1">
                @Html.EditorFor(model => model.RentalOrderId, new { htmlAttributes = new { @class = "form-control" } })
                @Html.ValidationMessageFor(model => model.RentalOrderId, "", new { @class = "text-danger" })
            </div>
        </div>
        <div class="form-group">
            @Html.LabelFor(model => model.EmployeeId, htmlAttributes: new { @class = "control-label col-md-3 blue" })
            <div class="col-md-1">
                @Html.EditorFor(model => model.EmployeeId, new { htmlAttributes = new { @class = "form-control" } })
                @Html.ValidationMessageFor(model => model.EmployeeId, "", new { @class = "text-danger" })
            </div>
            <div class="col-md-6 top-padding">@ViewBag.EmployeeDetails</div>
        </div>
    
        <div class="heading"><p class="text-center">Customer Information</p></div>
    
        <div class="form-group">
            @Html.LabelFor(model => model.DriversLicenseNumber, htmlAttributes: new { @class = "control-label col-md-3 blue" })
            <div class="col-md-2">
                @Html.EditorFor(model => model.DriversLicenseNumber, new { htmlAttributes = new { @class = "form-control" } })
                @Html.ValidationMessageFor(model => model.DriversLicenseNumber, "", new { @class = "text-danger" })
            </div>
        </div>
    
        <div class="form-group">
            @Html.LabelFor(model => model.FirstName, htmlAttributes: new { @class = "control-label col-md-3 blue" })
            <div class="col-md-2">
                @Html.EditorFor(model => model.FirstName, new { htmlAttributes = new { @class = "form-control" } })
                @Html.ValidationMessageFor(model => model.FirstName, "", new { @class = "text-danger" })
            </div>
            @Html.LabelFor(model => model.LastName, htmlAttributes: new { @class = "control-label col-md-3 blue" })
            <div class="col-md-2">
                @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.Address, htmlAttributes: new { @class = "control-label col-md-3 blue" })
            <div class="col-md-7">
                @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-3 blue" })
            <div class="col-md-2">
                @Html.EditorFor(model => model.City, new { htmlAttributes = new { @class = "form-control" } })
                @Html.ValidationMessageFor(model => model.City, "", new { @class = "text-danger" })
            </div>
            @Html.LabelFor(model => model.County, htmlAttributes: new { @class = "control-label col-md-3 blue" })
            <div class="col-md-2">
                @Html.EditorFor(model => model.County, new { htmlAttributes = new { @class = "form-control" } })
                @Html.ValidationMessageFor(model => model.County, "", new { @class = "text-danger" })
            </div>
        </div>
    
        <div class="form-group">
            @Html.LabelFor(model => model.State, htmlAttributes: new { @class = "control-label col-md-3 blue" })
            <div class="col-md-2">
                @Html.EditorFor(model => model.State, new { htmlAttributes = new { @class = "form-control" } })
                @Html.ValidationMessageFor(model => model.State, "", new { @class = "text-danger" })
            </div>
            @Html.LabelFor(model => model.ZIPCode, htmlAttributes: new { @class = "control-label col-md-3 blue" })
            <div class="col-md-2">
                @Html.EditorFor(model => model.ZIPCode, new { htmlAttributes = new { @class = "form-control" } })
                @Html.ValidationMessageFor(model => model.ZIPCode, "", new { @class = "text-danger" })
            </div>
        </div>
    
        <div class="heading"><p class="text-center">Rental Summary</p></div>
    
        <div class="form-group">
            <label for="carId" class="control-label col-md-3 blue">Car Selected</label>
            <div class="col-md-1">
                @Html.EditorFor(model => model.CarId, new { htmlAttributes = new { @class = "form-control" } })
            </div>
            <div class="col-md-6 top-padding">@ViewBag.VehicleDetails</div>
        </div>
    
        <div class="form-group">
            @Html.LabelFor(model => model.MileageStart, htmlAttributes: new { @class = "control-label col-md-3 blue" })
            <div class="col-md-2">
                @Html.EditorFor(model => model.MileageStart, new { htmlAttributes = new { @class = "form-control" } })
                @Html.ValidationMessageFor(model => model.MileageStart, "", new { @class = "text-danger" })
            </div>
            @Html.LabelFor(model => model.MileageEnd, htmlAttributes: new { @class = "control-label col-md-3 blue" })
            <div class="col-md-2">
                @Html.EditorFor(model => model.MileageEnd, new { htmlAttributes = new { @class = "form-control" } })
                @Html.ValidationMessageFor(model => model.MileageEnd, "", new { @class = "text-danger" })
            </div>
        </div>
    
        <div class="form-group">
            @Html.LabelFor(model => model.StartDate, htmlAttributes: new { @class = "control-label col-md-3 blue" })
            <div class="col-md-2">
                @Html.EditorFor(model => model.StartDate, new { htmlAttributes = new { @class = "form-control" } })
                @Html.ValidationMessageFor(model => model.StartDate, "", new { @class = "text-danger" })
            </div>
            @Html.LabelFor(model => model.EndDate, htmlAttributes: new { @class = "control-label col-md-3 blue" })
            <div class="col-md-2">
                @Html.EditorFor(model => model.EndDate, new { htmlAttributes = new { @class = "form-control", type = "date" } })
                @Html.ValidationMessageFor(model => model.EndDate, "", new { @class = "text-danger" })
            </div>
        </div>
    
        <div class="form-group">
            @Html.LabelFor(model => model.RateApplied, htmlAttributes: new { @class = "control-label col-md-3 blue" })
            <div class="col-md-2">
                @Html.EditorFor(model => model.RateApplied, new { htmlAttributes = new { @class = "form-control" } })
                @Html.ValidationMessageFor(model => model.RateApplied, "", new { @class = "text-danger" })
            </div>
            @Html.LabelFor(model => model.TaxRate, htmlAttributes: new { @class = "control-label col-md-2 blue" })
            <div class="col-md-2">
                @Html.EditorFor(model => model.TaxRate, new { htmlAttributes = new { @class = "form-control" } })
                @Html.ValidationMessageFor(model => model.TaxRate, "", new { @class = "text-danger" })
            </div>
        </div>
    
        <hr />
    
        <div class="form-group">
            <label class="col-md-6 control-label">
                @Html.ActionLink("Rental Orders", "Index")
            </label>
            <div class="col-md-6">
                <input type="submit" value="Prepare Rental Order Return" class="btn btn-primary" />
            </div>
        </div>
    </div>
    }
  54. In the Solution Explorer, under Views, right-click RentalOrders and click Add View...
  55. Type PrepareRentalOrderReturn as the Name of the view
  56. Click Add
  57. Create the webform as follows:
    @model BethesdaCarRental1.Models.RentalOrder
    
    @{
        ViewBag.Title = "Continue Rental Order Return";
    }
    
    <h2 class="common-font text-center bold blue">Continue Rental Order Return</h2>
    
    @using (Html.BeginForm("SaveRentalOrderReturn", "RentalOrders", FormMethod.Post))
    {
        @Html.AntiForgeryToken()
    
    <div class="form-horizontal common-font">
        <div class="heading"><p class="text-center">Rental Order Preliminary Information</p></div>
    
        <div class="form-group">
            @Html.LabelFor(model => model.RentalOrderId, htmlAttributes: new { @class = "control-label col-md-3 blue" })
            <div class="col-md-1">
                @Html.TextBox("RentalOrderId", ViewData["RentalOrderId"], htmlAttributes: new { @class = "form-control" })
                @Html.ValidationMessageFor(model => model.RentalOrderId, "", new { @class = "text-danger" })
            </div>
        </div>
        <div class="form-group">
            @Html.LabelFor(model => model.EmployeeId, htmlAttributes: new { @class = "control-label col-md-3 blue" })
            <div class="col-md-1">
                @Html.TextBox("EmployeeId", ViewData["EmployeeId"], htmlAttributes: new { @class = "form-control" })
                @Html.ValidationMessageFor(model => model.EmployeeId, "", new { @class = "text-danger" })
            </div>
            <div class="col-md-6 top-padding">@ViewBag.EmployeeDetails</div>
        </div>
    
        <div class="heading"><p class="text-center">Customer Information</p></div>
    
        <div class="form-group">
            @Html.LabelFor(model => model.DriversLicenseNumber, htmlAttributes: new { @class = "control-label col-md-3 blue" })
            <div class="col-md-2">
                @Html.TextBox("DriversLicenseNumber", ViewData["DriversLicenseNumber"], htmlAttributes: new { @class = "form-control" })
                @Html.ValidationMessageFor(model => model.DriversLicenseNumber, "", new { @class = "text-danger" })
            </div>
        </div>
    
        <div class="form-group">
            @Html.LabelFor(model => model.FirstName, htmlAttributes: new { @class = "control-label col-md-3 blue" })
            <div class="col-md-2">
                @Html.TextBox("FirstName", ViewData["FirstName"], htmlAttributes: new { @class = "form-control" })
                @Html.ValidationMessageFor(model => model.FirstName, "", new { @class = "text-danger" })
            </div>
            @Html.LabelFor(model => model.LastName, htmlAttributes: new { @class = "control-label col-md-3 blue" })
            <div class="col-md-2">
                @Html.TextBox("LastName", ViewData["LastName"], htmlAttributes: new { @class = "form-control" })
                @Html.ValidationMessageFor(model => model.LastName, "", new { @class = "text-danger" })
            </div>
        </div>
    
        <div class="form-group">
            @Html.LabelFor(model => model.Address, htmlAttributes: new { @class = "control-label col-md-3 blue" })
            <div class="col-md-7">
                @Html.TextBox("Address", ViewData["Address"], 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-3 blue" })
            <div class="col-md-2">
                @Html.TextBox("City", ViewData["City"], htmlAttributes: new { @class = "form-control" })
                @Html.ValidationMessageFor(model => model.City, "", new { @class = "text-danger" })
            </div>
            @Html.LabelFor(model => model.County, htmlAttributes: new { @class = "control-label col-md-3 blue" })
            <div class="col-md-2">
                @Html.TextBox("County", ViewData["County"], htmlAttributes: new { @class = "form-control" })
                @Html.ValidationMessageFor(model => model.County, "", new { @class = "text-danger" })
            </div>
        </div>
    
        <div class="form-group">
            @Html.LabelFor(model => model.State, htmlAttributes: new { @class = "control-label col-md-3 blue" })
            <div class="col-md-2">
                @Html.TextBox("State", ViewData["State"], htmlAttributes: new { @class = "form-control" })
                @Html.ValidationMessageFor(model => model.State, "", new { @class = "text-danger" })
            </div>
            @Html.LabelFor(model => model.ZIPCode, htmlAttributes: new { @class = "control-label col-md-3 blue" })
            <div class="col-md-2">
                @Html.TextBox("ZIPCode", ViewData["ZIPCode"], htmlAttributes: new { @class = "form-control" })
                @Html.ValidationMessageFor(model => model.ZIPCode, "", new { @class = "text-danger" })
            </div>
        </div>
    
        <div class="heading"><p class="text-center">Rental Summary</p></div>
    
        <div class="form-group">
            <label for="carId" class="control-label col-md-3 blue">Car Selected</label>
            <div class="col-md-1">
                @Html.TextBox("CarId", ViewData["CarId"], htmlAttributes: new { @class = "form-control" })
            </div>
            <div class="col-md-6 top-padding">@ViewBag.VehicleDetails</div>
        </div>
    
        <div class="form-group">
            @Html.LabelFor(model => model.CarCondition, htmlAttributes: new { @class = "control-label col-md-3 blue" })
            <div class="col-md-2">
                @Html.DropDownList("CarCondition", ViewBag.CarCondition as SelectList, htmlAttributes: new { @class = "form-control" })
                @Html.ValidationMessageFor(model => model.CarCondition, "", new { @class = "text-danger" })
            </div>
            @Html.LabelFor(model => model.TankLevel, htmlAttributes: new { @class = "control-label col-md-3 blue" })
            <div class="col-md-2">
                @Html.DropDownList("TankLevel", ViewBag.TankLevel as SelectList, htmlAttributes: new { @class = "form-control" })
                @Html.ValidationMessageFor(model => model.TankLevel, "", new { @class = "text-danger" })
            </div>
        </div>
    
        <div class="form-group">
            @Html.LabelFor(model => model.MileageStart, htmlAttributes: new { @class = "control-label col-md-2 blue" })
            <div class="col-md-2">
                @Html.TextBox("MileageStart", ViewData["MileageStart"], htmlAttributes: new { @class = "form-control" })
                @Html.ValidationMessageFor(model => model.MileageStart, "", new { @class = "text-danger" })
            </div>
            @Html.LabelFor(model => model.MileageEnd, htmlAttributes: new { @class = "control-label col-md-2 blue" })
            <div class="col-md-2">
                @Html.TextBox("MileageEnd", ViewData["MileageEnd"], htmlAttributes: new { @class = "form-control" })
                @Html.ValidationMessageFor(model => model.MileageEnd, "", new { @class = "text-danger" })
            </div>
            @Html.LabelFor(model => model.MileageTotal, htmlAttributes: new { @class = "control-label col-md-2 blue" })
            <div class="col-md-2">
                @Html.TextBox("MileageTotal", ViewBag.MileageTotal as string, htmlAttributes: new { @class = "form-control" })
                @Html.ValidationMessageFor(model => model.MileageTotal, "", new { @class = "text-danger" })
            </div>
        </div>
    
        <div class="form-group">
            @Html.LabelFor(model => model.StartDate, htmlAttributes: new { @class = "control-label col-md-2 blue" })
            <div class="col-md-2">
                @Html.TextBox("StartDate", ViewData["StartDate"], htmlAttributes: new { @class = "form-control" })
                @Html.ValidationMessageFor(model => model.StartDate, "", new { @class = "text-danger" })
            </div>
            @Html.LabelFor(model => model.EndDate, htmlAttributes: new { @class = "control-label col-md-2 blue" })
            <div class="col-md-2">
                @Html.TextBox("EndDate", ViewData["EndDate"], htmlAttributes: new { @class = "form-control" })
                @Html.ValidationMessageFor(model => model.EndDate, "", new { @class = "text-danger" })
            </div>
            @Html.LabelFor(model => model.TotalDays, htmlAttributes: new { @class = "control-label col-md-2 blue" })
            <div class="col-md-2">
                @Html.TextBox("TotalDays", ViewBag.TotalDays as string, htmlAttributes: new { @class = "form-control" })
                @Html.ValidationMessageFor(model => model.TotalDays, "", new { @class = "text-danger" })
            </div>
        </div>
    
        <div class="form-group">
            @Html.LabelFor(model => model.RateApplied, htmlAttributes: new { @class = "control-label col-md-2 blue" })
            <div class="col-md-2">
                @Html.TextBox("RateApplied", ViewBag.RateApplied as string, htmlAttributes: new { @class = "form-control" })
                @Html.ValidationMessageFor(model => model.RateApplied, "", new { @class = "text-danger" })
            </div>
            @Html.LabelFor(model => model.SubTotal, htmlAttributes: new { @class = "control-label col-md-2 blue" })
            <div class="col-md-2">
                @Html.TextBox("SubTotal", ViewBag.SubTotal as string, htmlAttributes: new { @class = "form-control" })
                @Html.ValidationMessageFor(model => model.SubTotal, "", new { @class = "text-danger" })
            </div>
        </div>
    
        <div class="form-group">
            @Html.LabelFor(model => model.TaxRate, htmlAttributes: new { @class = "control-label col-md-2 blue" })
            <div class="col-md-2">
                @Html.TextBox("TaxRate", ViewBag.TaxRate as string, htmlAttributes: new { @class = "form-control" })
                @Html.ValidationMessageFor(model => model.TaxRate, "", new { @class = "text-danger" })
            </div>
            @Html.LabelFor(model => model.TaxAmount, htmlAttributes: new { @class = "control-label col-md-2 blue" })
            <div class="col-md-2">
                @Html.TextBox("TaxAmount", ViewBag.TaxAmount as string, htmlAttributes: new { @class = "form-control" })
                @Html.ValidationMessageFor(model => model.TaxAmount, "", new { @class = "text-danger" })
            </div>
            @Html.LabelFor(model => model.OrderTotal, htmlAttributes: new { @class = "control-label col-md-2 blue" })
            <div class="col-md-2">
                @Html.TextBox("OrderTotal", ViewBag.OrderTotal as string, htmlAttributes: new { @class = "form-control" })
                @Html.ValidationMessageFor(model => model.OrderTotal, "", new { @class = "text-danger" })
            </div>
        </div>
    
        <div class="form-group">
            @Html.LabelFor(model => model.OrderStatus, htmlAttributes: new { @class = "control-label col-md-3 blue" })
            <div class="col-md-2">
                @Html.DropDownList("OrderStatus", ViewBag.OrderStatus as SelectList, htmlAttributes: new { @class = "form-control" })
                @Html.ValidationMessageFor(model => model.OrderStatus, "", new { @class = "text-danger" })
            </div>
        </div>
    
        <hr />
    
        <div class="form-group">
            <label class="col-md-6 control-label">
                @Html.ActionLink("Rental Orders", "Index")
            </label>
            <div class="col-md-6">
                <input type="submit" value="Save Rental Order Return" class="btn btn-primary" />
            </div>
        </div>
    </div>
    }
  58. In the Solution Explorer, under Views and under RentalOrders, double-click Delete.cshtml
  59. Change the document as follows:
    @model BethesdaCarRental1.Models.RentalOrder
    
    @{
        ViewBag.Title = "Delete Rental Order";
    }
    
    <h2 class="common-font text-center bold blue">Delete Rental Order</h2>
    
    <hr />
    
    <h3 class="common-font text-center bold blue">Are you sure you want to cancel this rental order?</h3>
    
    <div class="containment">
        <dl class="dl-horizontal common-font">
            <dt>@Html.DisplayNameFor(model => model.RentalOrderId)</dt>
            <dd>@Html.DisplayFor(model => model.RentalOrderId)</dd>
    
            <dt>@Html.DisplayNameFor(model => model.EmployeeId)</dt>
            <dd>@ViewData["Clerk"]</dd>
    
            <dt>@Html.DisplayNameFor(model => model.DriversLicenseNumber)</dt>
            <dd>@Html.DisplayFor(model => model.DriversLicenseNumber)</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.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.County)</dt>
            <dd>@Html.DisplayFor(model => model.County)</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.CarId)</dt>
            <dd>@ViewData["CarSelected"]</dd>
    
            <dt>@Html.DisplayNameFor(model => model.CarCondition)</dt>
            <dd>@Html.DisplayFor(model => model.CarCondition)</dd>
    
            <dt>@Html.DisplayNameFor(model => model.TankLevel)</dt>
            <dd>@Html.DisplayFor(model => model.TankLevel)</dd>
    
            <dt>@Html.DisplayNameFor(model => model.MileageStart)</dt>
            <dd>@Html.DisplayFor(model => model.MileageStart)</dd>
    
            <dt>@Html.DisplayNameFor(model => model.MileageEnd)</dt>
            <dd>@Html.DisplayFor(model => model.MileageEnd)</dd>
    
            <dt>@Html.DisplayNameFor(model => model.MileageTotal)</dt>
            <dd>@Html.DisplayFor(model => model.MileageTotal)</dd>
    
            <dt>@Html.DisplayNameFor(model => model.StartDate)</dt>
            <dd>@Html.DisplayFor(model => model.StartDate)</dd>
    
            <dt>@Html.DisplayNameFor(model => model.EndDate)</dt>
            <dd>@Html.DisplayFor(model => model.EndDate)</dd>
    
            <dt>@Html.DisplayNameFor(model => model.TotalDays)</dt>
            <dd>@Html.DisplayFor(model => model.TotalDays)</dd>
    
            <dt>@Html.DisplayNameFor(model => model.RateApplied)</dt>
            <dd>@Html.DisplayFor(model => model.RateApplied)</dd>
    
            <dt>@Html.DisplayNameFor(model => model.SubTotal)</dt>
            <dd>@Html.DisplayFor(model => model.SubTotal)</dd>
    
            <dt>@Html.DisplayNameFor(model => model.TaxRate)</dt>
            <dd>@Html.DisplayFor(model => model.TaxRate)</dd>
    
            <dt>@Html.DisplayNameFor(model => model.TaxAmount)</dt>
            <dd>@Html.DisplayFor(model => model.TaxAmount)</dd>
    
            <dt>@Html.DisplayNameFor(model => model.OrderTotal)</dt>
            <dd>@Html.DisplayFor(model => model.OrderTotal)</dd>
    
            <dt>@Html.DisplayNameFor(model => model.PaymentDate)</dt>
            <dd>@Html.DisplayFor(model => model.PaymentDate)</dd>
    
            <dt>@Html.DisplayNameFor(model => model.OrderStatus)</dt>
            <dd>@Html.DisplayFor(model => model.OrderStatus)</dd>
        </dl>
    
        @using (Html.BeginForm())
        {
            @Html.AntiForgeryToken()
    
            <div class="form-actions no-color">
                <input type="submit" value="Delete this Rental Order" class="btn btn-primary" /> |
                @Html.ActionLink("Rental Orders", "Index")
            </div>
        }
    </div>
  60. In the Solution Explorer, under Views and under RentalOrders, double-click Details.cshtml
  61. Change the document as follows:
    @model BethesdaCarRental1.Models.RentalOrder
    
    @{
        ViewBag.Title = "Rental Order Details";
    }
    
    <h2 class="common-font text-center bold blue">Rental Order Details</h2>
    
    <hr />
    <div class="containment">
        <dl class="dl-horizontal common-font">
            <dt>@Html.DisplayNameFor(model => model.RentalOrderId)</dt>
            <dd>@Html.DisplayFor(model => model.RentalOrderId)</dd>
    
            <dt>@Html.DisplayNameFor(model => model.EmployeeId)</dt>
            <dd>@ViewData["Clerk"]</dd>
    
            <dt>@Html.DisplayNameFor(model => model.DriversLicenseNumber)</dt>
            <dd>@Html.DisplayFor(model => model.DriversLicenseNumber)</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.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.County)</dt>
            <dd>@Html.DisplayFor(model => model.County)</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.CarId)</dt>
            <dd>@ViewData["CarSelected"]</dd>
            
            <dt>@Html.DisplayNameFor(model => model.CarCondition)</dt>
            <dd>@Html.DisplayFor(model => model.CarCondition)</dd>
            
            <dt>@Html.DisplayNameFor(model => model.TankLevel)</dt>
            <dd>@Html.DisplayFor(model => model.TankLevel)</dd>
            
            <dt>@Html.DisplayNameFor(model => model.MileageStart)</dt>
            <dd>@Html.DisplayFor(model => model.MileageStart)</dd>
            
            <dt>@Html.DisplayNameFor(model => model.MileageEnd)</dt>
            <dd>@Html.DisplayFor(model => model.MileageEnd)</dd>
            
            <dt>@Html.DisplayNameFor(model => model.MileageTotal)</dt>
            <dd>@Html.DisplayFor(model => model.MileageTotal)</dd>
            
            <dt>@Html.DisplayNameFor(model => model.StartDate)</dt>
            <dd>@Html.DisplayFor(model => model.StartDate)</dd>
            
            <dt>@Html.DisplayNameFor(model => model.EndDate)</dt>
            <dd>@Html.DisplayFor(model => model.EndDate)</dd>
            
            <dt>@Html.DisplayNameFor(model => model.TotalDays)</dt>
            <dd>@Html.DisplayFor(model => model.TotalDays)</dd>
            
            <dt>@Html.DisplayNameFor(model => model.RateApplied)</dt>
            
            <dd>@Html.DisplayFor(model => model.RateApplied)</dd>
            <dt>@Html.DisplayNameFor(model => model.SubTotal)</dt>
            
            <dd>@Html.DisplayFor(model => model.SubTotal)</dd>
            
            <dt>@Html.DisplayNameFor(model => model.TaxRate)</dt>
            <dd>@Html.DisplayFor(model => model.TaxRate)</dd>
            
            <dt>@Html.DisplayNameFor(model => model.TaxAmount)</dt>
            <dd>@Html.DisplayFor(model => model.TaxAmount)</dd>
            
            <dt>@Html.DisplayNameFor(model => model.OrderTotal)</dt>
            <dd>@Html.DisplayFor(model => model.OrderTotal)</dd>
            
            <dt>@Html.DisplayNameFor(model => model.PaymentDate)</dt>
            <dd>@Html.DisplayFor(model => model.PaymentDate)</dd>
            
            <dt>@Html.DisplayNameFor(model => model.OrderStatus)</dt>
            <dd>@Html.DisplayFor(model => model.OrderStatus)</dd>
        </dl>
    </div>
    
    <p class="text-center">
        @Html.ActionLink("Edit this Rental Order", "Edit", new { id = Model.RentalOrderId }) |
        @Html.ActionLink("Rental Orders", "Index")
    </p>
  62. In the Solution Explorer, under Views and under Cars, double-click Edit.cshtml
  63. Change the document as follows:
    @model BethesdaCarRental1.Models.RentalOrder
    
    @{
        ViewBag.Title = "Edit Rental Order";
    }
    
    <h2 class="common-font text-center bold blue">Edit/Update Rental Order</h2>
    
    <hr />
    
    @using (Html.BeginForm())
    {
        @Html.AntiForgeryToken()
    
        <div class="containment">
            <div class="form-horizontal common-font">
                @Html.ValidationSummary(true, "", new { @class = "text-danger" })
                @Html.HiddenFor(model => model.RentalOrderId)
    
                <div class="form-group">
                    @Html.LabelFor(model => model.EmployeeId, htmlAttributes: new { @class = "control-label col-md-5" })
                    <div class="col-md-7">
                        @Html.EditorFor(model => model.EmployeeId, new { htmlAttributes = new { @class = "form-control" } })
                        @Html.ValidationMessageFor(model => model.EmployeeId, "", new { @class = "text-danger" })
                    </div>
                </div>
    
                <div class="form-group">
                    @Html.LabelFor(model => model.DriversLicenseNumber, htmlAttributes: new { @class = "control-label col-md-5" })
                    <div class="col-md-7">
                        @Html.EditorFor(model => model.DriversLicenseNumber, new { htmlAttributes = new { @class = "form-control" } })
                        @Html.ValidationMessageFor(model => model.DriversLicenseNumber, "", new { @class = "text-danger" })
                    </div>
                </div>
    
                <div class="form-group">
                    @Html.LabelFor(model => model.FirstName, htmlAttributes: new { @class = "control-label col-md-5" })
                    <div class="col-md-7">
                        @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-5" })
                    <div class="col-md-7">
                        @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.Address, htmlAttributes: new { @class = "control-label col-md-5" })
                    <div class="col-md-7">
                        @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-5" })
                    <div class="col-md-7">
                        @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.County, htmlAttributes: new { @class = "control-label col-md-5" })
                    <div class="col-md-7">
                        @Html.EditorFor(model => model.County, new { htmlAttributes = new { @class = "form-control" } })
                        @Html.ValidationMessageFor(model => model.County, "", new { @class = "text-danger" })
                    </div>
                </div>
    
                <div class="form-group">
                    @Html.LabelFor(model => model.State, htmlAttributes: new { @class = "control-label col-md-5" })
                    <div class="col-md-7">
                        @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-5" })
                    <div class="col-md-7">
                        @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.CarId, htmlAttributes: new { @class = "control-label col-md-5" })
                    <div class="col-md-7">
                        @Html.EditorFor(model => model.CarId, new { htmlAttributes = new { @class = "form-control" } })
                        @Html.ValidationMessageFor(model => model.CarId, "", new { @class = "text-danger" })
                    </div>
                </div>
    
                <div class="form-group">
                    @Html.LabelFor(model => model.CarCondition, htmlAttributes: new { @class = "control-label col-md-5" })
                    <div class="col-md-7">
                        @Html.DropDownList("CarCondition", ViewBag.CarCondition as SelectList, htmlAttributes: new { @class = "form-control" })
                        @Html.ValidationMessageFor(model => model.CarCondition, "", new { @class = "text-danger" })
                    </div>
                </div>
    
                <div class="form-group">
                    @Html.LabelFor(model => model.TankLevel, htmlAttributes: new { @class = "control-label col-md-5" })
                    <div class="col-md-7">
                        @Html.DropDownList("TankLevel", ViewBag.TankLevel as SelectList, htmlAttributes: new { @class = "form-control" })
                        @Html.ValidationMessageFor(model => model.TankLevel, "", new { @class = "text-danger" })
                    </div>
                </div>
    
                <div class="form-group">
                    @Html.LabelFor(model => model.MileageStart, htmlAttributes: new { @class = "control-label col-md-5" })
                    <div class="col-md-7">
                        @Html.EditorFor(model => model.MileageStart, new { htmlAttributes = new { @class = "form-control" } })
                        @Html.ValidationMessageFor(model => model.MileageStart, "", new { @class = "text-danger" })
                    </div>
                </div>
    
                <div class="form-group">
                    @Html.LabelFor(model => model.MileageEnd, htmlAttributes: new { @class = "control-label col-md-5" })
                    <div class="col-md-7">
                        @Html.EditorFor(model => model.MileageEnd, new { htmlAttributes = new { @class = "form-control" } })
                        @Html.ValidationMessageFor(model => model.MileageEnd, "", new { @class = "text-danger" })
                    </div>
                </div>
    
                <div class="form-group">
                    @Html.LabelFor(model => model.MileageTotal, htmlAttributes: new { @class = "control-label col-md-5" })
                    <div class="col-md-7">
                        @Html.EditorFor(model => model.MileageTotal, new { htmlAttributes = new { @class = "form-control" } })
                        @Html.ValidationMessageFor(model => model.MileageTotal, "", new { @class = "text-danger" })
                    </div>
                </div>
    
                <div class="form-group">
                    @Html.LabelFor(model => model.StartDate, htmlAttributes: new { @class = "control-label col-md-5" })
                    <div class="col-md-7">
                        @Html.EditorFor(model => model.StartDate, new { htmlAttributes = new { @class = "form-control" } })
                        @Html.ValidationMessageFor(model => model.StartDate, "", new { @class = "text-danger" })
                    </div>
                </div>
    
                <div class="form-group">
                    @Html.LabelFor(model => model.EndDate, htmlAttributes: new { @class = "control-label col-md-5" })
                    <div class="col-md-7">
                        @Html.EditorFor(model => model.EndDate, new { htmlAttributes = new { @class = "form-control" } })
                        @Html.ValidationMessageFor(model => model.EndDate, "", new { @class = "text-danger" })
                    </div>
                </div>
    
                <div class="form-group">
                    @Html.LabelFor(model => model.TotalDays, htmlAttributes: new { @class = "control-label col-md-5" })
                    <div class="col-md-7">
                        @Html.EditorFor(model => model.TotalDays, new { htmlAttributes = new { @class = "form-control" } })
                        @Html.ValidationMessageFor(model => model.TotalDays, "", new { @class = "text-danger" })
                    </div>
                </div>
    
                <div class="form-group">
                    @Html.LabelFor(model => model.RateApplied, htmlAttributes: new { @class = "control-label col-md-5" })
                    <div class="col-md-7">
                        @Html.EditorFor(model => model.RateApplied, new { htmlAttributes = new { @class = "form-control" } })
                        @Html.ValidationMessageFor(model => model.RateApplied, "", new { @class = "text-danger" })
                    </div>
                </div>
    
                <div class="form-group">
                    @Html.LabelFor(model => model.SubTotal, htmlAttributes: new { @class = "control-label col-md-5" })
                    <div class="col-md-7">
                        @Html.EditorFor(model => model.SubTotal, new { htmlAttributes = new { @class = "form-control" } })
                        @Html.ValidationMessageFor(model => model.SubTotal, "", new { @class = "text-danger" })
                    </div>
                </div>
    
                <div class="form-group">
                    @Html.LabelFor(model => model.TaxRate, htmlAttributes: new { @class = "control-label col-md-5" })
                    <div class="col-md-7">
                        @Html.EditorFor(model => model.TaxRate, new { htmlAttributes = new { @class = "form-control" } })
                        @Html.ValidationMessageFor(model => model.TaxRate, "", new { @class = "text-danger" })
                    </div>
                </div>
    
                <div class="form-group">
                    @Html.LabelFor(model => model.TaxAmount, htmlAttributes: new { @class = "control-label col-md-5" })
                    <div class="col-md-7">
                        @Html.EditorFor(model => model.TaxAmount, new { htmlAttributes = new { @class = "form-control" } })
                        @Html.ValidationMessageFor(model => model.TaxAmount, "", new { @class = "text-danger" })
                    </div>
                </div>
    
                <div class="form-group">
                    @Html.LabelFor(model => model.OrderTotal, htmlAttributes: new { @class = "control-label col-md-5" })
                    <div class="col-md-7">
                        @Html.EditorFor(model => model.OrderTotal, new { htmlAttributes = new { @class = "form-control" } })
                        @Html.ValidationMessageFor(model => model.OrderTotal, "", new { @class = "text-danger" })
                    </div>
                </div>
    
                <div class="form-group">
                    @Html.LabelFor(model => model.PaymentDate, htmlAttributes: new { @class = "control-label col-md-5" })
                    <div class="col-md-7">
                        @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.OrderStatus, htmlAttributes: new { @class = "control-label col-md-5" })
                    <div class="col-md-7">
                        @Html.DropDownList("OrderStatus", ViewBag.OrderStatus as SelectList, htmlAttributes: new { @class = "form-control" })
                        @Html.ValidationMessageFor(model => model.OrderStatus, "", new { @class = "text-danger" })
                    </div>
                </div>
    
                <div class="form-group">
                    <label class="col-md-6 control-label">
                        @Html.ActionLink("Rental Orders", "Index")
                    </label>
                    <div class="col-md-6">
                        <input type="submit" value="Update Rental Order" class="btn btn-primary" />
                    </div>
                </div>
            </div>
        </div>
    }
    
    @section Scripts {
        @Scripts.Render("~/bundles/jqueryval")
    }
  64. In the Solution Explorer, under Views and under Cars, double-click Index.cshtml
  65. Change the document as follows:
    @model IEnumerable<BethesdaCarRental1.Models.RentalOrder>
    
    @{
        ViewBag.Title = "Rental Orders";
    }
    
    <h2 class="common-font text-center bold blue">Rental Orders</h2>
    
    <table class="table table-striped common-font">
        <tr>
            <th class="text-center">@Html.DisplayNameFor(model => model.RentalOrderId)</th>
            <th class="text-center">@Html.DisplayNameFor(model => model.EmployeeId)</th>
            <th class="text-center">@Html.DisplayNameFor(model => model.DriversLicenseNumber)</th>
            <th>@Html.DisplayNameFor(model => model.FirstName)</th>
            <th>@Html.DisplayNameFor(model => model.LastName)</th>
            <th>@Html.DisplayNameFor(model => model.Address)</th>
            <th>@Html.DisplayNameFor(model => model.City)</th>
            <th>@Html.DisplayNameFor(model => model.County)</th>
            <th>@Html.DisplayNameFor(model => model.State)</th>
            <th>@Html.DisplayNameFor(model => model.ZIPCode)</th>
            <th>@Html.DisplayNameFor(model => model.CarId)</th>
            <th>@Html.DisplayNameFor(model => model.CarCondition)</th>
            <th>@Html.DisplayNameFor(model => model.TankLevel)</th>
            <th>@Html.DisplayNameFor(model => model.MileageStart)</th>
            <th>@Html.DisplayNameFor(model => model.MileageEnd)</th>
            <th>@Html.DisplayNameFor(model => model.MileageTotal)</th>
            <th>@Html.DisplayNameFor(model => model.StartDate)</th>
            <th>@Html.DisplayNameFor(model => model.EndDate)</th>
            <th>@Html.DisplayNameFor(model => model.TotalDays)</th>
            <th>@Html.DisplayNameFor(model => model.RateApplied)</th>
            <th>@Html.DisplayNameFor(model => model.SubTotal)</th>
            <th>@Html.DisplayNameFor(model => model.TaxRate)</th>
            <th>@Html.DisplayNameFor(model => model.TaxAmount)</th>
            <th>@Html.DisplayNameFor(model => model.OrderTotal)</th>
            <th>@Html.DisplayNameFor(model => model.OrderStatus)</th>
            <th>@Html.DisplayNameFor(model => model.PaymentDate)</th>
            <th></th>
        </tr>
    
        @foreach (var item in Model)
        {
            <tr>
                <td class="text-center">@Html.DisplayFor(modelItem => item.RentalOrderId)</td>
                <td class="text-center">@Html.DisplayFor(modelItem => item.EmployeeId)</td>
                <td class="text-center">@Html.DisplayFor(modelItem => item.DriversLicenseNumber)</td>
                <td>@Html.DisplayFor(modelItem => item.FirstName)</td>
                <td>@Html.DisplayFor(modelItem => item.LastName)</td>
                <td>@Html.DisplayFor(modelItem => item.Address)</td>
                <td>@Html.DisplayFor(modelItem => item.City)</td>
                <td>@Html.DisplayFor(modelItem => item.County)</td>
                <td>@Html.DisplayFor(modelItem => item.State)</td>
                <td>@Html.DisplayFor(modelItem => item.ZIPCode)</td>
                <td>@Html.DisplayFor(modelItem => item.CarId)</td>
                <td>@Html.DisplayFor(modelItem => item.CarCondition)</td>
                <td>@Html.DisplayFor(modelItem => item.TankLevel)</td>
                <td>@Html.DisplayFor(modelItem => item.MileageStart)</td>
                <td>@Html.DisplayFor(modelItem => item.MileageEnd)</td>
                <td>@Html.DisplayFor(modelItem => item.MileageTotal)</td>
                <td>@Html.DisplayFor(modelItem => item.StartDate)</td>
                <td>@Html.DisplayFor(modelItem => item.EndDate)</td>
                <td>@Html.DisplayFor(modelItem => item.TotalDays)</td>
                <td>@Html.DisplayFor(modelItem => item.RateApplied)</td>
                <td>@Html.DisplayFor(modelItem => item.SubTotal)</td>
                <td>@Html.DisplayFor(modelItem => item.TaxRate)</td>
                <td>@Html.DisplayFor(modelItem => item.TaxAmount)</td>
                <td>@Html.DisplayFor(modelItem => item.OrderTotal)</td>
                <td>@Html.DisplayFor(modelItem => item.OrderStatus)</td>
                <td>@Html.DisplayFor(modelItem => item.PaymentDate)</td>
                <td>
                    @Html.ActionLink("Edit", "Edit", new { id = item.RentalOrderId }) |
                    @Html.ActionLink("Details", "Details", new { id = item.RentalOrderId }) |
                    @Html.ActionLink("Delete", "Delete", new { id = item.RentalOrderId })
                </td>
            </tr>
        }
    </table>
    
    <p class="text-center">
        @Html.ActionLink("New Rental Order", "StartRentalOrder") |
        @Html.ActionLink("Rental Order Return", "StartRentalOrderReturn") |
        @Html.ActionLink("Rental Orders", "Index")
    </p>
  66. In the Solution Explorer, under Views, expand Shared
  67. Double-click _Layout.cshtml and change it as follows:
    <!DOCTYPE html>
    <html>
    <head>
        <meta charset="utf-8" />
        <meta name="viewport" content="width=device-width, initial-scale=1.0">
        <title>Bethesda Car Rental :: @ViewBag.Title</title>
        @Styles.Render("~/Content/css")
        @Scripts.Render("~/bundles/modernizr")
    </head>
    <body>
        <div id="top-banner">
            <p class="text-center"><img src="~/Images/bcr1.png" alt="Bethesda Car Rental" width="638" height="85" /></p>
        </div>
        <div class="navbar navbar-inverse navbar-fixed-top">
            <div class="container centralized">
                <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>
                    @Html.ActionLink("BETHESDA CAR RENTAL", "Index", "Home", new { area = "" }, new { @class = "navbar-brand" })
                </div>
                <div class="navbar-collapse collapse">
                    <ul class="nav navbar-nav">
                        <li>@Html.ActionLink("EMPLOYEES", "Index", "Employees")</li>
                        <li>@Html.ActionLink("CARS/VEHICLES", "Index", "Cars")</li>
                        <li>@Html.ActionLink("RENTAL ORDERS", "Index", "RentalOrders")</li>
                        <li>@Html.ActionLink("ABOUT BCR", "About", "Home")</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 blue">&copy; @DateTime.Now.Year - Bethesda Car Rental</p>
            </footer>
        </div>
    
        @Scripts.Render("~/bundles/jquery")
        @Scripts.Render("~/bundles/bootstrap")
        @RenderSection("scripts", required: false)
    </body>
    </html>
  68. In the Solution Explorer, under Views, expand Home and double-click Index.cshtml
  69. Change the document as follows:
    @{
        ViewBag.Title = "Bethesda Car Rental";
    }
    
    <div class="row">
        <div class="col-md-6">
            <div class="row">
                <div class="col-md-4">
                    <p><img src="~/Images/bcr2.png" alt="Bethesda Car Rental - Chief Executive Officer Message" width="150" height="150" class="bordered" /></p>
                </div>
                <div class="col-md-8">
                    <p class="sect-title">CEO'S MESSAGE</p>
                    <p class="parajust">Bethesda Car Rental is a medium-size business that provides cars in many category to address various needs for car rent or short-term lease. We provide small/compact/economic cars, convertibles, sport utilities, pick-up trucks, and passenger vans.</p>
                </div>
            </div>
        </div>
        <div class="col-md-6">
            <div class="row">
                <div class="col-md-4">
                    <p><img src="~/Images/bcr3.png" alt="Bethesda Car Rental - Chief Executive Officer Message" width="150" height="150" class="bordered" /></p>
                </div>
                <div class="col-md-8">
                    <p class="sect-title">CAREER/EMPLOYMENT</p>
                    <p class="parajust">We are currently hiring in various categories in management, driving, maintenance, community service, public relations, research, and professional/technical writing, etc. You can apply to one or as many positions as you need.</p>
                </div>
            </div>
        </div>
    </div>
    
    <hr />
    
    <div class="row">
        <div class="col-md-6">
            <div class="row">
                <div class="col-md-4">
                    <p><img src="~/Images/bcr4.png" alt="Bethesda Car Rental - Chief Executive Officer Message" width="150" height="150" class="bordered" /></p>
                </div>
                <div class="col-md-8">
                    <p class="sect-title">OUR FLEET</p>
                    <p class="parajust">Bethesda Car Rental has a large collection of cars to meet any need. Whether you need a simple ride for the weekend, a convenient solution to attend a conference, a means to visit the area, or a comfortable vehicle for a trip to the countryside, BCR will come to the rescue.</p>
                </div>
            </div>
        </div>
        <div class="col-md-6">
            <div class="row">
                <div class="col-md-4">
                    <p><img src="~/Images/bcr5.png" alt="Bethesda Car Rental - Chief Executive Officer Message" width="150" height="150" class="bordered" /></p>
                </div>
                <div class="col-md-8">
                    <p class="sect-title">RESERVATIONS</p>
                    <ul>
                        <li>@Html.ActionLink("Make a reservation", "Index", "Home")</li>
                        <li>@Html.ActionLink("Check your reservation", "Index", "Home")</li>
                        <li>@Html.ActionLink("Change your reservation", "Index", "Home")</li>
                        <li>@Html.ActionLink("Cancel a reservation", "Index", "Home")</li>
                        <li>@Html.ActionLink("Contact our Office", "Index", "Home")</li>
                    </ul>
                </div>
            </div>
        </div>
    </div>
  70. To execute the application and test record creation, on the main menu, click Debug -> Start Without Debugging

    Data Sets Maintenance

  71. Click the EMPLOYEES link

    Data Sets Maintenance - Gas Meters

  72. Click Hire New Employee

    Data Sets Maintenance - New Gas Meters

  73. Create a few records as follows:
    Employee # First Name Last Name Employment Title
    92735 Jeffrey Leucart General Manager
    29268 Kathleen Rawley Technician
    73948 Allison Garlow Accounts Associate
    40508 David Stillson Accounts Manager
    24793 Michelle Taylor Accounts Associate
    20480 Peter Futterman Accounts Associate
    72084 Georgia Rosen Customer Service Representative
    38408 Karen Blackney Accounts Associate

    Data Sets Maintenance - Gas Meters

    INSERT INTO Employees(EmployeeNumber, FirstName, LastName, EmploymentTitle)
    VALUES(N'92735', N'Jeffrey',  N'Leucart',   N'General Manager'),
          (N'29268', N'Kathleen', N'Rawley',    N'Technician'),
          (N'73948', N'Allison',  N'Garlow',    N'Accounts Associate'),
          (N'40508', N'David',    N'Stillson',  N'Accounts Manager'),
          (N'24793', N'Michelle', N'Taylor',    N'Accounts Associate'),
          (N'20480', N'Peter',    N'Futterman', N'Accounts Associate'),
          (N'72084', N'Georgia',  N'Rosen',     N'Customer Service Representative'),
          (N'38408', N'Karen',    N'Blackney',  N'Accounts Associate');
    GO
  74. Click the CARS/VEHICLES Link

    Data Sets Maintenance - Gas Meters

  75. Click the Create New Car link:

    Data Sets Maintenance - New Gas Meters

  76. Create some records as follows:
    Tag # Make Model Passengers Category Condition Availability Status
    M297304 Jeep Wrangler Sahara 4 SUV Excellent Available
    1AD8049 Dodge Charger SXT 4 Standard Driveable Available
    DFP924 Toyota Sienna LE FWD 8 Passenger Van Driveable Available
    GTH295 Kia Rio LX 4 Economy Excellent Available
    2AL9485 Chrysler 200 2 Compact Needs Repair Being Serviced
    BND927 Ford Fiesta SE 4 Economy Excellent Available
    9KM8206 Honda Accord EX 4 Standard Good Unknown
    8AE9294 Lincoln MKT 3.5L 4 Full Size Excellent Available
    M280360 Toyota Rav4 LE 4 SUV Excellent Being Serviced
    5MD2084 Buick Enclave 4 Mini Van Driveable Unknown
    2AT9274 Ford Focus SF 4 Compact Excellent Available
    6AD8274 Mazda CX-9 7 Mini Van Driveable Available
    4AF9284 Ford F-150 Reg Cap 4X4 2 Pickup Truck Driveable Available
    ADG279 GMC Acadia SLE 5 SUV Excellent Available
    8DN8604 Toyota Camry XSE 4 Standard Excellent Available
    4DP2731 Buick Lacrosse Avenir 4 Full Size Other Being Serviced

    Introduction to Maintenance of Data Sets

    INSERT INTO Cars(TagNumber, Make, Model, Passengers, Category, Condition, AvailabilityStatus)
    VALUES(N'M297304', N'Jeep',     N'Wrangler Sahara',   4, N'SUV',           N'Excellent',    N'Available'),
          (N'1AD8049', N'Dodge',    N'Charger SXT',       4, N'Standard',      N'Driveable',    N'Available'),
          (N'DFP924',  N'Toyota',   N'Sienna LE FWD',     8, N'Passenger Van', N'Driveable',    N'Available'),
          (N'GTH295',  N'Kia',      N'Rio LX',            4, N'Economy',       N'Excellent',    N'Available'),
          (N'2AL9485', N'Chrysler', N'200',               2, N'Compact',       N'Needs Repair', N'Being Serviced'),
          (N'BND927',  N'Ford',     N'Fiesta SE',         4, N'Economy',       N'Excellent',    N'Available'),
          (N'9KM8206', N'Honda',    N'Accord EX',         4, N'Standard',      N'Good',         N'Unknown'),
          (N'8AE9294', N'Lincoln',  N'MKT 3.5L',          4, N'Full Size',     N'Excellent',    N'Available'),
          (N'M280360', N'Toyota',   N'Rav4 LE',           4, N'SUV',           N'Excellent',    N'Being Serviced'),
          (N'5MD2084', N'Buick',    N'Enclave',           4, N'Mini Van',      N'Driveable',    N'Unknown'),
          (N'2AT9274', N'Ford',     N'Focus SF',          4, N'Compact',       N'Excellent',    N'Available'),
          (N'6AD8274', N'Mazda',    N'CX-9',              7, N'Mini Van',      N'Driveable',    N'Available'),
          (N'4AF9284', N'Ford',     N'F-150 Reg Cap 4X4', 2, N'Pickup Truck',  N'Driveable',    N'Available'),
          (N'ADG279',  N'GMC',      N'Acadia SLE',        5, N'SUV',           N'Excellent',    N'Available'),
          (N'8DN8604', N'Toyota',   N'Camry XSE',         4, N'Standard',      N'Excellent',    N'Available'),
          (N'4DP2731', N'Buick',    N'Lacrosse Avenir',   4, N'Full Size',     N'Other',        N'Being Serviced');
    GO
  77. Click the RENTAL ORDERS link
  78. Click New Rental Order

    Data Sets Maintenance - New Gas Meters

  79. In the text boxes, type the following values:
    Employee #: 20480
    Vehicle Tag #: DFP924

    Data Sets Maintenance - New Gas Meters

  80. Click Prepare Rental Order

    Data Sets Maintenance - New Gas Meters

  81. In the webpage, enter the following values or make selections:
    Drv. Lic. #:   293-84-9374
    First Name:    Marcel
    Last Name:     Buhler
    Address:       6800 Haxell Crt
    City:          Alexandria
    State:         VA
    ZIP Code:      22314
    Car Condition: Excellent
    Tank Level:    Half
    Mileage Start: 12728
    Start Date:    12/10/2018
    Rate Applied:  69.95
    Tax Rate:      7.75
    Order Status:  Ongoing

    Data Sets Maintenance - New Gas Meters

  82. Click Save Rental Order
  83. Create other rental order with the following values:

    Employee # Vehicle Tag # Drv. Lic. # First Name Last Name Address City State ZIP Code Car Condition Tank Level Mileage Start Start Date Rate Applied Tax Rate Order Status
    24793 4AF9284 826-83-0479 Joan Altman 3725 South Dakota Ave NW Washington DC 20012 Driveable 1/4 Empty 24715 12/10/2018 62.95 6.85 Ongoing
    38408 BND927 958-27-4050 Thomas Filder 4905 Herrenden St Arlington VA 22204 Excellent Full 6064 12/12/2018 34.95 8.35 Ongoing
  84. On the Rental Contracts webpage (the Index page of the Rental Contracts controller, click the Rental Order Return link
  85. In the Rental Order ID text box, type 3
  86. Click Continue Rental Order Return
  87. In the text boxes, type the following values:
    Mileage End: 6229
    End Date:    12/16/2018
  88. Click Prepare Rental Order Return
  89. Change the Order Status combo box to Order Completed
  90. Create another Rental Order Returns with the following values:
    Rental Order Id: 1
    Mileage End: 13022
    End Date:    12/16/2018
    Order Status: Order Completed
  91. Create another Rental Order Returns with the following values:
    Rental Order Id: 2
    Mileage End: 25694
    End Date:    12/17/2018
    Order Status: Order Completed
  92. Close the browser and return to your programming environment
  93. Close your programming environment

Home Copyright © 2001-2019, FunctionX Home