Introduction

Before using the entity framework, you can first create a database and add one or more tables to it. There is nothing particular about the database. It is just like any normal database and you can follow any to create the tables.

Practical LearningPractical Learning: Starting an EF with a Database

  1. Start Microsoft Visual Studio
  2. To start a new project, on the main menu, click File -> New -> Project...
  3. In the central list, click ASP.NET Web Application (.NET Framework) and change the project Name to GasUtilityCompany1
  4. Click OK
  5. In the list box of the New ASP.NET Web Application dialog box, click the MVC icon and click OK
  6. In the Solution Explorer, right-click GasUtilityCompany1 -> Add -> New Folder
  7. Type Images and press Enter
  8. Save the following image to your computer, then copy and paste it in the Image folder of the project:

    Gas Utility Company - Logo

  9. In the Solution Explorer, right-click Content -> Style Sheet
  10. Type GasUtilityCompany as the name of the file, and press Enter
  11. Add the following styles to the file:
    body {
        padding-top: 150px;
        background-color: #EEEEEE;
    }
    
    .bold             { font-weight:      600;     }
    .maroon           { color:            #800000; }
    .deep-brown       { color:            #410606; }
    #top-banner       { top:              0;
                        left:             0;
                        right:            0;
                        width:            100%;
                        bottom:           auto;
                        z-index:          1100;
                        position:         fixed;
                        height:           5.75em;
                        background-color: #192E46; }
    #bottom-banner    { left:             0;
                        right:            0;
                        bottom:           0;
                        top:              auto;
                        width:            100%;
                        position:         fixed;
                        height:           4.15em;
                        background-color: #003366;
                        border-top:       5pt solid black; }
    #copyright        { margin-top:       1em;
                        font-size:        1.15em;
                        text-align:       center;
                        line-height:      1.15em;
                        color:            lightcyan;
                        font-family:      Garamond, Georgia, 'Times New Roman', serif; }
    .containment      { width:            400px; }
    .body-holder      { margin:           auto;
                        width:            800px; }
    .centralizer      { margin:           auto;
                        width:            700px; }
    .col-md-3         { border-radius:    6px;
                        padding-top:      10px;
                        padding-bottom:   10px;
                        background-color: #800000;
                        border:           1px solid #000000; }
    .jumbotron        { padding-top:      3px;
                        border-radius:    10px;
                        background-color: #f1ddca; }
    .jumbotron h1     { font-size:        43px;
                        color:            #800000; }
    .lead             { margin-bottom:    0;       }
    .topic            { float:            left;    }
    .bottom-line      { border-bottom:    1px solid #410606; }
    .common-font      { font-family:      Garamond, Georgia, 'Times New Roman', serif; }
    
    .topic a:link, .topic a:active,
    .topic a:visited, .topic a:hover {
                        height:           32px;
                        font-size:        12pt;
                        line-height:      26px;
                        margin-left:     -10px;
                        padding-left:     20px;
                        text-decoration:  none;
                        display:          inline-block;
                        font-family:      'Segoe UI', Tahoma, Geneva, Verdana, sans-serif; }
    
    .topic, .topic a:link, .topic a:active,
    .topic a:visited, .topic a:hover {
        width: 190px;
    }
    .topic a:link     { color:            #FFFF00; }
    .topic a:active   { color:            #CC99FF; }
    .topic a:visited  { color:            #FFCC99; }
    .topic a:hover    { color:            #FFFFFF;
                        background-color: #ff6a00;
                        display:          inline-block;
                        outline:          1pt solid #CCFF33; }
    .navbar           { border-bottom:    5px solid navy;
                        border-top:       5px solid #faf76f; }
    .navbar-inverse   { background-color: orange;
                        border-color:     #080808;           }
    .navbar-fixed-top { top:              80px;              }
    
    .navbar-inverse .navbar-nav > li > a,
    .navbar-inverse .navbar-nav > li > a:link {
        color: #faf76f;
        background-color: transparent;
    }
    .navbar-inverse .navbar-nav > li > a:hover,
    .navbar-inverse .navbar-nav > li > a:focus {
            color: orange;
            background-color: #faf76f;
    }
  12. In the Solution Explorer, under Views, expand App_Start and double-click BundleConfig.cs to open it
  13. Change the document as follows:
    using System.Web.Optimization;
    
    namespace GasUtilityCompany1
    {
        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/GasUtilityCompany.css"));
            }
        }
    }
  14. In the Solution Explorer, under Views, right-click Shared -> Add -> New Item...
  15. In the left frame of the Add New Item dialog box, under Visual C# and under Web, click Razor
  16. In the middle frame, click Layout Page (Razor v3)
  17. Set the Name to _Arrangement
  18. Press Enter
  19. Change the document as follows:
    <!DOCTYPE html>
    <html>
    <head>
        <meta charset="utf-8" />
        <meta name="viewport" content="width=device-width, initial-scale=1.0">
        <title>Gas Utility Company :: @ViewBag.Title</title>
        @Styles.Render("~/Content/css")
        @Scripts.Render("~/bundles/modernizr")
    </head>
    <body>
        <header id="top-banner">
            <p class="text-center"><img src="~/Images/guc.png" alt="Gas Utility Company" width="649" height="74" /></p>
        </header>
    
        <div class="navbar navbar-inverse navbar-fixed-top">
            <div class="centralizer">
                <div class="container">
                    <div class="navbar-header">
                        <button type="button" class="navbar-toggle" data-toggle="collapse" data-target=".navbar-collapse">
                            <span class="icon-bar"></span>
                            <span class="icon-bar"></span>
                            <span class="icon-bar"></span>
                        </button>
                    </div>
                    <div class="navbar-collapse collapse">
                        <ul class="nav navbar-nav">
                            <li>@Html.ActionLink("GUC Home", "Index", "Home")</li>
                            <li>@Html.ActionLink("Gas Meters", "Index", "GasMeters")</li>
                            <li>@Html.ActionLink("Customers", "Index", "Customers")</li>
                            <li>@Html.ActionLink("Gas Bills", "Index", "GasBills")</li>
                            <li>@Html.ActionLink("Payments", "Index", "Payments")</li>
                            <li>@Html.ActionLink("Community", "Index", "Home")</li>
                            <li>@Html.ActionLink("Careers", "Index", "Home")</li>
                            <li>@Html.ActionLink("About GUC", "About", "Home")</li>
                            <li>@Html.ActionLink("Contact Us", "Contact", "Home")</li>
                        </ul>
                    </div>
                </div>
            </div>
        </div>
    
        <div class="body-holder">
                @RenderBody()
        </div>
    
        <hr />
    
        <footer id="bottom-banner">
            <p id="copyright">&copy; @DateTime.Now.Year - Gas Utility Company</p>
        </footer>
    
        @Scripts.Render("~/bundles/jquery")
        @Scripts.Render("~/bundles/bootstrap")
        @RenderSection("scripts", required: false)
    </body>
    </html>

An Entity Framework for an Existing Database

If you have (already created) a database, you can easily use it in your ASP.NE MVC project. To do this, after starting a Web project, add an ADO.NET Entity Data Model. In the Entity Data Model Wizard, select the first option and move to the other pages of the wizard. When you get to the page with a list of tables, click the check boxes of the desired tables.

Practical LearningPractical Learning: Adding a Property to an Interface

  1. In the Solution Explorer, right-click App_Data -> Add -> New Item...
  2. In the left frame of the Add New Items dialog box, click Data and, in the middle frame, click SQL Server Database
  3. Change the file Name to GasDistribution
  4. Click Add
  5. In the Solution Explorer, right-click PropertiesManagement.mdf and click Open
  6. In the Server Explorer, right-click PropertiesManagement.mdf and click New Query
  7. Type the following code:
    CREATE TABLE GasMeters
    (
            GasMeterID       INT IDENTITY(1, 1),
            MeterNumber      NVARCHAR(10),
    		  Make             NVARCHAR(40),
            Model            NVARCHAR(40),
            MeterReadingDate Date,
            CounterValue     INT,
    		  CONSTRAINT PK_GasMeters PRIMARY KEY(GasMeterID)
    );
    GO
    CREATE TABLE Customers
    (
            CustomerID    INT IDENTITY(1, 1),
            AccountNumber NVARCHAR(16),
            GasMeterID    INT,
            FirstName     NVARCHAR(20),
            LastName      NVARCHAR(20),
            [Address]     NVARCHAR(100),
            City          NVARCHAR(40),
            County        NVARCHAR(40),
            [State]       NVARCHAR(40),
            ZIPCode       NVARCHAR(12),
    		  CONSTRAINT FK_GasMeters FOREIGN KEY(GasMeterID) REFERENCES GasMeters(GasMeterID),
    		  CONSTRAINT PK_Customers PRIMARY KEY(CustomerID)
    );
    GO
    CREATE TABLE GasBills
    (
            GasBillID              INT IDENTITY(1, 1),
            CustomerID             INT,
            MeterReadingStartDate  Date,
            MeterReadingEndDate    Date,
            BillingDays            INT,
            CounterReadingStart    INT,
            CounterReadingEnd      INT,
            Consumption            INT,
            TotalTherms            DECIMAL(6, 2),
            TransportationCharges  DECIMAL(6, 2),
            First50Therms          DECIMAL(6, 2),
            Over50Therms           DECIMAL(6, 2),
            DeliveryTotal          DECIMAL(6, 2),
            DistributionAdjustment DECIMAL(6, 2),
            EnvironmentalCharges   DECIMAL(6, 2),
            TotalCharges           DECIMAL(6, 2),
            LocalTaxes             DECIMAL(6, 2),
            StateTaxes             DECIMAL(6, 2),
            PaymentDueDate         Date,
            AmountDue              DECIMAL(6, 2),
            LateAmountDue          DECIMAL(6, 2),
    		  CONSTRAINT FK_CustomersBills FOREIGN KEY(CustomerID) REFERENCES Customers(CustomerID),
    		  CONSTRAINT PK_GasBills PRIMARY KEY(GasBillID)
    );
    GO
    CREATE TABLE Payments
    (
            PaymentID     INT IDENTITY(1, 1),
            PaymentDate   Date,
            GasBillID     INT,
            PaymentAmount DECIMAL(6, 2),
            PaymentStatus NVARCHAR(35),
    		  CONSTRAINT FK_GasBills FOREIGN KEY(GasBillID) REFERENCES GasBills(GasBillID),
    		  CONSTRAINT PK_Payments PRIMARY KEY(PaymentID)
    );
    GO
  8. To get the table, on the toolbar of the Query window, click the Execute button Update
  9. Close the Query window
  10. When asked whether you want to save, click No
  11. To create a model, in the Solution Explorer, right-click Models -> Add -> New Item...
  12. In the left frame of the Add New Item dialog box, click Data and, in the middle frame, click ADO.NET Entity Data Model
  13. Change the Name to GasDistributionModel
  14. Click Add
  15. In the Entity Data Model Wizard, accept the EF Designer From Database

    Entity Data Model Wizard

    Click Next
  16. In the second page of the Entity Data Model Wizard, in the bottom text box, accept PropertiesManagementEntities

    Entity Data Model Wizard

    Click Next
  17. In the third page of the wizar, click Entity Framework 6.x

    Entity Data Model Wizard

    Click Next
  18. In the fourth page of the wizard, click the Tables check box

    Entity Data Model Wizard

  19. Click Finish
  20. Read the content of the message box

    Security Warning

    Click OK each time (three times)

    Model Preparation

  21. In the Solution Explorer, under Models and under GasDistributionModel.tt, double-click GasMeter.cs
  22. Change the class as follows:
    namespace GasUtilityCompany1.Models
    {
        using System;
        using System.Collections.Generic;
        using System.ComponentModel.DataAnnotations;
    
        public partial class GasMeter
        {
            [System.Diagnostics.CodeAnalysis.SuppressMessage("Microsoft.Usage", "CA2214:DoNotCallOverridableMethodsInConstructors")]
            public GasMeter()
            {
                this.Customers = new HashSet<Customer>();
            }
    
            [Display(Name = "Gas Meter ID")]
            public int           GasMeterID       { get; set; }
            [Display(Name = "Meter #")]
            public string        MeterNumber      { get; set; }
            public string        Make             { get; set; }
            public string        Model            { get; set; }
            [Display(Name = "Meter Reading Date")]
            public Nullable<System.DateTime>        MeterReadingDate { get; set; }
            [Display(Name = "Counter Value")]
            public Nullable<int> CounterValue     { get; set; }
    
            public string Identification
            {
                get
                {
                    return MeterNumber + " - " + Make + " " + Model;
                }
            }
            
            [System.Diagnostics.CodeAnalysis.SuppressMessage("Microsoft.Usage", "CA2227:CollectionPropertiesShouldBeReadOnly")]
            public virtual ICollection<Customer> Customers { get; set; }
        }
    }
  23. In the Solution Explorer, under Models and under GasDistributionModel.tt, double-click Customer.cs
  24. Change the class as follows:
    namespace GasUtilityCompany1.Models
    {
        using System;
        using System.Collections.Generic;
        using System.ComponentModel.DataAnnotations;
    
        public partial class Customer
        {
            [System.Diagnostics.CodeAnalysis.SuppressMessage("Microsoft.Usage", "CA2214:DoNotCallOverridableMethodsInConstructors")]
            public Customer()
            {
                this.GasBills = new HashSet<GasBill>();
            }
    
            [Display(Name = "Customer ID")]
            public int           CustomerID    { get; set; }
            [Display(Name = "Account #")]
            public string        AccountNumber { get; set; }
            [Display(Name = "Gas Meter ID")]
            public Nullable<int> GasMeterID    { get; set; }
            [Display(Name = "First Name")]
            public string        FirstName     { get; set; }
            [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; }
    
            public string Identification
            {
                get
                {
                    return AccountNumber + " - " + FirstName + " " + LastName + " (" + City + ", " + State + ")";
                }
            }
    
            [System.Diagnostics.CodeAnalysis.SuppressMessage("Microsoft.Usage", "CA2227:CollectionPropertiesShouldBeReadOnly")]
            public virtual ICollection<GasBill> GasBills { get; set; }
            public virtual GasMeter GasMeter { get; set; }
        }
    }
  25. In the Solution Explorer, under Models and under GasDistributionModel.tt, double-click GasBill.cs
  26. Change the class as follows:
    namespace GasUtilityCompany1.Models
    {
        using System;
        using System.Collections.Generic;
        using System.ComponentModel.DataAnnotations;
    
        public partial class GasBill
        {
            [System.Diagnostics.CodeAnalysis.SuppressMessage("Microsoft.Usage", "CA2214:DoNotCallOverridableMethodsInConstructors")]
            public GasBill()
            {
                this.Payments = new HashSet<Payment>();
            }
    
            [Display(Name = "Gas Bill ID")]
            public int GasBillID { get; set; }
            [Display(Name = "Customer ID")]
            public Nullable<int> CustomerID { get; set; }
            [Display(Name = "Meter Reading Start Date")]
            public Nullable<System.DateTime> MeterReadingStartDate { get; set; }
            [Display(Name = "Meter Reading End Date")]
            public Nullable<System.DateTime> MeterReadingEndDate { get; set; }
            [Display(Name = "Billing Days")]
            public Nullable<int> BillingDays { get; set; }
            [Display(Name = "Counter Reading Start")]
            public Nullable<int> CounterReadingStart { get; set; }
            [Display(Name = "Counter Reading End")]
            public Nullable<int> CounterReadingEnd { get; set; }
            public Nullable<int> Consumption { get; set; }
            [Display(Name = "Total Therms")]
            public Nullable<decimal> TotalTherms { get; set; }
            [Display(Name = "Transportation Charges")]
            public Nullable<decimal> TransportationCharges { get; set; }
            [Display(Name = "First 50 Therms")]
            public Nullable<decimal> First50Therms { get; set; }
            [Display(Name = "Over 50 Therms")]
            public Nullable<decimal> Over50Therms { get; set; }
            [Display(Name = "Delivery Total")]
            public Nullable<decimal> DeliveryTotal { get; set; }
            [Display(Name = "Distribution Adjustment")]
            public Nullable<decimal> DistributionAdjustment { get; set; }
            [Display(Name = "Environmental Charges")]
            public Nullable<decimal> EnvironmentalCharges { get; set; }
            [Display(Name = "Total Charges")]
            public Nullable<decimal> TotalCharges { get; set; }
            [Display(Name = "Local Taxes")]
            public Nullable<decimal> LocalTaxes { get; set; }
            [Display(Name = "State Taxes")]
            public Nullable<decimal> StateTaxes { get; set; }
            [Display(Name = "Payment Due Date")]
            public Nullable<System.DateTime> PaymentDueDate { get; set; }
            [Display(Name = "Amount Due")]
            public Nullable<decimal> AmountDue { get; set; }
            [Display(Name = "LateAmount Due")]
            public Nullable<decimal> LateAmountDue { get; set; }
        
            public virtual Customer Customer { get; set; }
            [System.Diagnostics.CodeAnalysis.SuppressMessage("Microsoft.Usage", "CA2227:CollectionPropertiesShouldBeReadOnly")]
            public virtual ICollection<Payment> Payments { get; set; }
        }
    }
  27. In the Solution Explorer, under Models and under GasDistributionModel.tt, double-click Payment.cs
  28. Change the class as follows:
    namespace GasUtilityCompany1.Models
    {
        using System;
        using System.ComponentModel.DataAnnotations;
        
        public partial class Payment
        {
            [Display(Name = "Payment ID")]
            public int               PaymentID     { get; set; }
            [Display(Name = "Payment Date")]
            public string            PaymentDate   { get; set; }
            [Display(Name = "Gas Bill ID")]
            public Nullable<int>     GasBillID     { get; set; }
            [Display(Name = "Payment Amount")]
            public Nullable<decimal> PaymentAmount { get; set; }
            [Display(Name = "Payment Status")]
            public string            PaymentStatus { get; set; }
        
            public virtual GasBill GasBill { get; set; }
        }
    }
  29. To prepage the project, on the main menu, click Build -> Build Solution
  30. In the Solution Explorer, right-click Controllers -> Add -> Controller...
  31. In the middle frame of the Add Scaffold dialog box, click MVC 5 Controller With Views, Using Entity Framework

    Add Scaffold

  32. Click Add
  33. Click the arrow of the Model Class combo box and select GasMeter (GasUtilityCompany1.Models)
  34. Click the arrow of the Data Context Class combo box and select GasDistributionEntities (GasUtilityCompany1.Models)
  35. Click the button on the right side of the Use A Layout Page page
  36. In the left list of the Select A Layout Page dialog box, expand Views, and click Shared
  37. In the Contents Of Folder list box, select _Management.cshtml

    Throwing an Exception

  38. On the Select A Layout Page dialog box, click OK

    Throwing an Exception

  39. On the Add Controller dialog box, click Add
  40. In the Solution Explorer, under Views and under GasMeters, double-click Create.cshtml
  41. Change the document as follows:
    @model GasUtilityCompany1.Models.GasMeter
    
    @{
        ViewBag.Title = "Create Gas Meter";
        Layout = "~/Views/Shared/_Arrangement.cshtml";
    }
    
    <h2 class="bold maroon common-font bottom-line">Create Gas Meter</h2>
    
    @using (Html.BeginForm())
    {
        @Html.AntiForgeryToken()
    
        <div class="form-horizontal common-font">
            @Html.ValidationSummary(true, "", new { @class = "text-danger" })
            <div class="form-group">
                @Html.LabelFor(model => model.MeterNumber, htmlAttributes: new { @class = "control-label col-md-2 deep-brown" })
                <div class="col-md-10">
                    @Html.EditorFor(model => model.MeterNumber, new { htmlAttributes = new { @class = "form-control" } })
                    @Html.ValidationMessageFor(model => model.MeterNumber, "", new { @class = "text-danger" })
                </div>
            </div>
    
            <div class="form-group">
                @Html.LabelFor(model => model.Make, htmlAttributes: new { @class = "control-label col-md-2 deep-brown" })
                <div class="col-md-10">
                    @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-2 deep-brown" })
                <div class="col-md-10">
                    @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.MeterReadingDate, htmlAttributes: new { @class = "control-label col-md-2 deep-brown" })
                <div class="col-md-10">
                    @Html.EditorFor(model => model.MeterReadingDate, new { htmlAttributes = new { @class = "form-control", type = "Date" } })
                    @Html.ValidationMessageFor(model => model.MeterReadingDate, "", new { @class = "text-danger" })
                </div>
            </div>
    
            <div class="form-group">
                @Html.LabelFor(model => model.CounterValue, htmlAttributes: new { @class = "control-label col-md-2 deep-brown" })
                <div class="col-md-10">
                    @Html.EditorFor(model => model.CounterValue, new { htmlAttributes = new { @class = "form-control" } })
                    @Html.ValidationMessageFor(model => model.CounterValue, "", new { @class = "text-danger" })
                </div>
            </div>
    
            <div class="form-group">
                <label class="control-label col-md-2">
                    @Html.ActionLink("Gas Meters", "Index")
                </label>
                <div class="col-md-10">
                    <input type="submit" value="Create Gas Meter" class="btn btn-warning" />
                </div>
            </div>
        </div>
    }
    
    @section Scripts {
        @Scripts.Render("~/bundles/jqueryval")
    }
  42. In the Solution Explorer, under Views and under Customers, double-click Delete.cshtml
  43. Change the document as follows:
    @model GasUtilityCompany1.Models.GasMeter
    
    @{
        ViewBag.Title = "Delete Gas Meter";
        Layout = "~/Views/Shared/_Arrangement.cshtml";
    }
    
    <h2 class="common-font maroon bold bottom-line">Are you sure you want to delete this gas meter?</h2>
    
    <h3 class="maroon common-font">Are you sure you want to delete this gas meter?</h3>
    
    <div>
        <dl class="dl-horizontal common-font">
            <dt>@Html.DisplayNameFor(model => model.GasMeterID)</dt>
            <dd>@Html.DisplayFor(model => model.GasMeterID)</dd>
            <dt>@Html.DisplayNameFor(model => model.MeterNumber)</dt>
            <dd>@Html.DisplayFor(model => model.MeterNumber)</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.MeterReadingDate)</dt>
            <dd>@Html.DisplayFor(model => model.MeterReadingDate)</dd>
            <dt>@Html.DisplayNameFor(model => model.CounterValue)</dt>
            <dd>
                @Html.DisplayFor(model => model.CounterValue)
        </dd>
        </dl>
    
        @using (Html.BeginForm()) {
            @Html.AntiForgeryToken()
    
            <div class="form-actions no-color">
                <input type="submit" value="Delete this Gas Meter" class="btn btn-warning" /> |
                @Html.ActionLink("Gas Meters", "Index")
            </div>
        }
    </div>
  44. In the Solution Explorer, under Views and under Customers, double-click Details.cshtml
  45. Change the document as follows:
    @model GasUtilityCompany1.Models.GasMeter
    
    @{
        ViewBag.Title = "Gas Meter Details";
        Layout = "~/Views/Shared/_Arrangement.cshtml";
    }
    
    <h2 class="maroon common-font bold bottom-line">Gas Meter Details</h2>
    
    <div>
        <dl class="dl-horizontal common-font">
            <dt>@Html.DisplayNameFor(model => model.GasMeterID)</dt>
            <dd>@Html.DisplayFor(model => model.GasMeterID)</dd>
    
            <dt>@Html.DisplayNameFor(model => model.MeterNumber)</dt>
            <dd>@Html.DisplayFor(model => model.MeterNumber)</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.MeterReadingDate)</dt>
            <dd>@Html.DisplayFor(model => model.MeterReadingDate)</dd>
    
            <dt>@Html.DisplayNameFor(model => model.CounterValue)</dt>
            <dd>@Html.DisplayFor(model => model.CounterValue)</dd>
        </dl>
    </div>
    <p>
        @Html.ActionLink("Edit", "Edit", new { id = Model.GasMeterID }) |
        @Html.ActionLink("Gas Meters", "Index")
    </p>
  46. In the Solution Explorer, under Views and under Customers, double-click Edit.cshtml
  47. Change the document as follows:
    @model GasUtilityCompany1.Models.GasMeter
    
    @{
        ViewBag.Title = "Edit/Update Gas Meter";
        Layout = "~/Views/Shared/_Arrangement.cshtml";
    }
    
    <h2 class="maroon bold bottom-line common-font">Edit/Update Gas Meter</h2>
    
    
    @using (Html.BeginForm())
    {
        @Html.AntiForgeryToken()
        
         <div class="form-horizontal common-font">
            @Html.ValidationSummary(true, "", new { @class = "text-danger" })
            @Html.HiddenFor(model => model.GasMeterID)
    
            <div class="form-group">
                @Html.LabelFor(model => model.MeterNumber, htmlAttributes: new { @class = "control-label col-md-2 deep-brown" })
                <div class="col-md-10">
                    @Html.EditorFor(model => model.MeterNumber, new { htmlAttributes = new { @class = "form-control" } })
                    @Html.ValidationMessageFor(model => model.MeterNumber, "", new { @class = "text-danger" })
                </div>
            </div>
    
            <div class="form-group">
                @Html.LabelFor(model => model.Make, htmlAttributes: new { @class = "control-label col-md-2 deep-brown" })
                <div class="col-md-10">
                    @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-2 deep-brown" })
                <div class="col-md-10">
                    @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.MeterReadingDate, htmlAttributes: new { @class = "control-label col-md-2 deep-brown" })
                <div class="col-md-10">
                    @Html.EditorFor(model => model.MeterReadingDate, new { htmlAttributes = new { @class = "form-control" } })
                    @Html.ValidationMessageFor(model => model.MeterReadingDate, "", new { @class = "text-danger" })
                </div>
            </div>
    
            <div class="form-group">
                @Html.LabelFor(model => model.CounterValue, htmlAttributes: new { @class = "control-label col-md-2 deep-brown" })
                <div class="col-md-10">
                    @Html.EditorFor(model => model.CounterValue, new { htmlAttributes = new { @class = "form-control" } })
                    @Html.ValidationMessageFor(model => model.CounterValue, "", new { @class = "text-danger" })
                </div>
            </div>
    
            <div class="form-group">
                <label class="control-label col-md-2">
                    @Html.ActionLink("Gas Meters", "Index")
                </label>
                <div class="col-md-10">
                    <input type="submit" value="Update this Gas Meter" class="btn btn-warning" />
                </div>
            </div>
        </div>
    }
    
    @section Scripts {
        @Scripts.Render("~/bundles/jqueryval")
    }
  48. In the Solution Explorer, under Views and under Customers, double-click Index.cshtml
  49. Change the document as follows:
    @model IEnumerable<GasUtilityCompany1.Models.GasMeter>
    
    @{
        ViewBag.Title = "Gas Meters";
        Layout = "~/Views/Shared/_Arrangement.cshtml";
    }
    
    <h2 class="common-font bold maroon text-center">Gas Meters</h2>
    
    <table class="table table-striped common-font">
        <tr>
            <th>@Html.DisplayNameFor(model => model.GasMeterID)</th>
            <th>@Html.DisplayNameFor(model => model.MeterNumber)</th>
            <th>@Html.DisplayNameFor(model => model.Make)</th>
            <th>@Html.DisplayNameFor(model => model.Model)</th>
            <th>@Html.DisplayNameFor(model => model.MeterReadingDate)</th>
            <th>@Html.DisplayNameFor(model => model.CounterValue)</th>
            <th>@Html.ActionLink("Create New Gas Meter", "Create")</th>
        </tr>
    
    @foreach (var item in Model)
    {
        string mrd = DateTime.Parse(item.MeterReadingDate.ToString()).ToShortDateString();
    
        <tr>
            <td>@Html.DisplayFor(modelItem => item.GasMeterID)</td>
            <td>@Html.DisplayFor(modelItem => item.MeterNumber)</td>
            <td>@Html.DisplayFor(modelItem => item.Make)</td>
            <td>@Html.DisplayFor(modelItem => item.Model)</td>
            <td>@mrd</td>
            <td>@Html.DisplayFor(modelItem => item.CounterValue)</td>
            <td>
                @Html.ActionLink("Edit", "Edit", new { id = item.GasMeterID }) |
                @Html.ActionLink("Details", "Details", new { id = item.GasMeterID }) |
                @Html.ActionLink("Delete", "Delete", new { id = item.GasMeterID })
            </td>
        </tr>
    }
    </table>
  50. In the Solution Explorer, right-click Controllers -> Add -> New Scafolded Item...
  51. In the middle frame of the Add Scaffold dialog box, click MVC 5 Controller With Views, Using Entity Framework

    Add Scaffold

  52. Click Add
  53. Click the arrow of the Model Class combo box and select Customer (GasUtilityCompany1.Models)
  54. Make sure the Data Context Class combo box is displaying GasDistributionEntities (GasUtilityCompany1.Models).
    Make sure the Use A Layout Page text box is displaying ~/Views/Shared/_Arrangement.cshtml.
    Click Add
  55. Change the class as follows:
    using GasUtilityCompany1.Models;
    using System;
    using System.Data.Entity;
    using System.Linq;
    using System.Net;
    using System.Web.Mvc;
    
    namespace GasUtilityCompany1.Controllers
    {
        public class CustomersController : Controller
        {
            private GasDistributionEntities db = new GasDistributionEntities();
    
            // GET: Customers
            public ActionResult Index()
            {
                var customers = db.Customers.Include(c => c.GasMeter);
                return View(customers.ToList());
            }
    
            // GET: Customers/Details/5
            public ActionResult Details(int? id)
            {
                if (id == null)
                {
                    return new HttpStatusCodeResult(HttpStatusCode.BadRequest);
                }
                Customer customer = db.Customers.Find(id);
                if (customer == null)
                {
                    return HttpNotFound();
                }
                return View(customer);
            }
    
            // GET: Customers/Create
            public ActionResult Create()
            {
                ViewBag.GasMeterID = new SelectList(db.GasMeters, "GasMeterID", "Identification");
                return View();
            }
    
            // POST: Customers/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 = "CustomerID,AccountNumber,GasMeterID,FirstName,LastName,Address,City,County,State,ZIPCode")] Customer customer)
            {
                if (ModelState.IsValid)
                {
                    db.Customers.Add(customer);
                    db.SaveChanges();
                    return RedirectToAction("Index");
                }
    
                ViewBag.GasMeterID = new SelectList(db.GasMeters, "GasMeterID", "Identification", customer.GasMeterID);
                return View(customer);
            }
    
            // GET: Customers/Edit/5
            public ActionResult Edit(int? id)
            {
                if (id == null)
                {
                    return new HttpStatusCodeResult(HttpStatusCode.BadRequest);
                }
                Customer customer = db.Customers.Find(id);
                if (customer == null)
                {
                    return HttpNotFound();
                }
                ViewBag.GasMeterID = new SelectList(db.GasMeters, "GasMeterID", "Identification", customer.GasMeterID);
                return View(customer);
            }
    
            // POST: Customers/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 = "CustomerID,AccountNumber,GasMeterID,FirstName,LastName,Address,City,County,State,ZIPCode")] Customer customer)
            {
                if (ModelState.IsValid)
                {
                    db.Entry(customer).State = EntityState.Modified;
                    db.SaveChanges();
                    return RedirectToAction("Index");
                }
                ViewBag.GasMeterID = new SelectList(db.GasMeters, "GasMeterID", "Identification", customer.GasMeterID);
                return View(customer);
            }
    
            // GET: Customers/Delete/5
            public ActionResult Delete(int? id)
            {
                if (id == null)
                {
                    return new HttpStatusCodeResult(HttpStatusCode.BadRequest);
                }
                Customer customer = db.Customers.Find(id);
                if (customer == null)
                {
                    return HttpNotFound();
                }
                return View(customer);
            }
    
            // POST: Customers/Delete/5
            [HttpPost, ActionName("Delete")]
            [ValidateAntiForgeryToken]
            public ActionResult DeleteConfirmed(int id)
            {
                Customer customer = db.Customers.Find(id);
                db.Customers.Remove(customer);
                db.SaveChanges();
                return RedirectToAction("Index");
            }
    
            protected override void Dispose(bool disposing)
            {
                if (disposing)
                {
                    db.Dispose();
                }
                base.Dispose(disposing);
            }
        }
    }
  56. In the Solution Explorer, under Views and under GasMeters, double-click Create.cshtml
  57. Change the document as follows:
    @model GasUtilityCompany1.Models.Customer
    
    @{
        ViewBag.Title = "Create Customer";
        Layout = "~/Views/Shared/_Arrangement.cshtml";
    }
    
    <h2 class="bold maroon common-font bottom-line">Create Customer Account</h2>
    
    @using (Html.BeginForm()) 
    {
        @Html.AntiForgeryToken()
        
         <div class="form-horizontal common-font">
            @Html.ValidationSummary(true, "", new { @class = "text-danger" })
            <div class="form-group">
                @Html.LabelFor(model => model.AccountNumber, htmlAttributes: new { @class = "control-label col-md-2 deep-brown" })
                <div class="col-md-10">
                    @Html.EditorFor(model => model.AccountNumber, new { htmlAttributes = new { @class = "form-control" } })
                    @Html.ValidationMessageFor(model => model.AccountNumber, "", new { @class = "text-danger" })
                </div>
            </div>
    
            <div class="form-group">
                <label for="gasMeterID" class="control-label col-md-2 deep-brown">Gas Meter</label>
                <div class="col-md-10">
                    @Html.DropDownList("GasMeterID", null, htmlAttributes: new { @class = "form-control" })
                    @Html.ValidationMessageFor(model => model.GasMeterID, "", new { @class = "text-danger" })
                </div>
            </div>
    
            <div class="form-group">
                @Html.LabelFor(model => model.FirstName, htmlAttributes: new { @class = "control-label col-md-2 deep-brown" })
                <div class="col-md-10">
                    @Html.EditorFor(model => model.FirstName, new { htmlAttributes = new { @class = "form-control" } })
                    @Html.ValidationMessageFor(model => model.FirstName, "", new { @class = "text-danger" })
                </div>
            </div>
    
            <div class="form-group">
                @Html.LabelFor(model => model.LastName, htmlAttributes: new { @class = "control-label col-md-2 deep-brown" })
                <div class="col-md-10">
                    @Html.EditorFor(model => model.LastName, new { htmlAttributes = new { @class = "form-control" } })
                    @Html.ValidationMessageFor(model => model.LastName, "", new { @class = "text-danger" })
                </div>
            </div>
    
            <div class="form-group">
                @Html.LabelFor(model => model.Address, htmlAttributes: new { @class = "control-label col-md-2 deep-brown" })
                <div class="col-md-10">
                    @Html.EditorFor(model => model.Address, new { htmlAttributes = new { @class = "form-control" } })
                    @Html.ValidationMessageFor(model => model.Address, "", new { @class = "text-danger" })
                </div>
            </div>
    
            <div class="form-group">
                @Html.LabelFor(model => model.City, htmlAttributes: new { @class = "control-label col-md-2 deep-brown" })
                <div class="col-md-10">
                    @Html.EditorFor(model => model.City, new { htmlAttributes = new { @class = "form-control" } })
                    @Html.ValidationMessageFor(model => model.City, "", new { @class = "text-danger" })
                </div>
            </div>
    
            <div class="form-group">
                @Html.LabelFor(model => model.County, htmlAttributes: new { @class = "control-label col-md-2 deep-brown" })
                <div class="col-md-10">
                    @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-2 deep-brown" })
                <div class="col-md-10">
                    @Html.EditorFor(model => model.State, new { htmlAttributes = new { @class = "form-control" } })
                    @Html.ValidationMessageFor(model => model.State, "", new { @class = "text-danger" })
                </div>
            </div>
    
            <div class="form-group">
                @Html.LabelFor(model => model.ZIPCode, htmlAttributes: new { @class = "control-label col-md-2 deep-brown" })
                <div class="col-md-10">
                    @Html.EditorFor(model => model.ZIPCode, new { htmlAttributes = new { @class = "form-control" } })
                    @Html.ValidationMessageFor(model => model.ZIPCode, "", new { @class = "text-danger" })
                </div>
            </div>
    
            <div class="form-group">
                <label class="control-label col-md-2">
                    @Html.ActionLink("Customers Accounts", "Index")
                </label>
                <div class="col-md-10">
                    <input type="submit" value="Create Customer Account" class="btn btn-warning" />
                </div>
            </div>
        </div>
    }
    
    @section Scripts {
        @Scripts.Render("~/bundles/jqueryval")
    }
  58. In the Solution Explorer, under Views and under GasMeters, double-click Delete.cshtml
  59. Change the document as follows:
    @model GasUtilityCompany1.Models.Customer
    
    @{
        ViewBag.Title = "Delete Customer";
        Layout = "~/Views/Shared/_Arrangement.cshtml";
    }
    
    <h2 class="common-font maroon bold bottom-line">Deleting Customer's Account</h2>
    
    <h3 class="maroon common-font">Are you sure you want to cancel this customer's account? this?</h3>
    
    <div>
        <dl class="dl-horizontal common-font">
            <dt>@Html.DisplayNameFor(model => model.CustomerID)</dt>
            <dd>@Html.DisplayFor(model => model.CustomerID)</dd>
    
            <dt>@Html.DisplayNameFor(model => model.AccountNumber)</dt>
            <dd>@Html.DisplayFor(model => model.AccountNumber)</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.GasMeter.MeterNumber)</dt>
            <dd>@Html.DisplayFor(model => model.GasMeter.MeterNumber)</dd>
        </dl>
    
        @using (Html.BeginForm()) {
            @Html.AntiForgeryToken()
    
            <div class="form-actions no-color">
                <input type="submit" value="Delete this Customer's Account" class="btn btn-warning" /> |
                @Html.ActionLink("Customers Accounts", "Index")
            </div>
        }
    </div>
  60. In the Solution Explorer, under Views and under GasMeters, double-click Details.cshtml
  61. Change the document as follows:
    @model GasUtilityCompany1.Models.Customer
    
    @{
        ViewBag.Title = "Customer Details";
        Layout = "~/Views/Shared/_Arrangement.cshtml";
    }
    
    <h2 class="maroon common-font bold bottom-line">Customer Details</h2>
    
    <div>
        <dl class="dl-horizontal common-font">
            <dt>@Html.DisplayNameFor(model => model.CustomerID)</dt>
            <dd>@Html.DisplayFor(model => model.CustomerID)</dd>
    
            <dt>@Html.DisplayNameFor(model => model.AccountNumber)</dt>
            <dd>@Html.DisplayFor(model => model.AccountNumber)</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.GasMeter.MeterNumber)</dt>
            <dd>@Html.DisplayFor(model => model.GasMeter.MeterNumber)</dd>
        </dl>
    </div>
    
    <p>
        @Html.ActionLink("Edit", "Edit", new { id = Model.CustomerID }) |
        @Html.ActionLink("Customers Accounts", "Index")
    </p>
  62. In the Solution Explorer, under Views and under GasMeters, double-click Edit.cshtml
  63. Change the document as follows:
    @model GasUtilityCompany1.Models.Customer
    
    @{
        ViewBag.Title = "Edit/Update Customer";
        Layout = "~/Views/Shared/_Arrangement.cshtml";
    }
    
    <h2 class="maroon bold bottom-line common-font">Edit/Update Customer's Account</h2>
    
    @using (Html.BeginForm())
    {
        @Html.AntiForgeryToken()
        
         <div class="form-horizontal common-font">
            @Html.ValidationSummary(true, "", new { @class = "text-danger" })
            @Html.HiddenFor(model => model.CustomerID)
    
            <div class="form-group">
                @Html.LabelFor(model => model.AccountNumber, htmlAttributes: new { @class = "control-label col-md-2 deep-brown" })
                <div class="col-md-10">
                    @Html.EditorFor(model => model.AccountNumber, new { htmlAttributes = new { @class = "form-control" } })
                    @Html.ValidationMessageFor(model => model.AccountNumber, "", new { @class = "text-danger" })
                </div>
            </div>
    
            <div class="form-group">
                <label for="gasMeterID" class="control-label col-md-2 deep-brown">Gas Meter</label>
                <div class="col-md-10">
                    @Html.DropDownList("GasMeterID", null, htmlAttributes: new { @class = "form-control" })
                    @Html.ValidationMessageFor(model => model.GasMeterID, "", new { @class = "text-danger" })
                </div>
            </div>
    
            <div class="form-group">
                @Html.LabelFor(model => model.FirstName, htmlAttributes: new { @class = "control-label col-md-2 deep-brown" })
                <div class="col-md-10">
                    @Html.EditorFor(model => model.FirstName, new { htmlAttributes = new { @class = "form-control" } })
                    @Html.ValidationMessageFor(model => model.FirstName, "", new { @class = "text-danger" })
                </div>
            </div>
    
            <div class="form-group">
                @Html.LabelFor(model => model.LastName, htmlAttributes: new { @class = "control-label col-md-2 deep-brown" })
                <div class="col-md-10">
                    @Html.EditorFor(model => model.LastName, new { htmlAttributes = new { @class = "form-control" } })
                    @Html.ValidationMessageFor(model => model.LastName, "", new { @class = "text-danger" })
                </div>
            </div>
    
            <div class="form-group">
                @Html.LabelFor(model => model.Address, htmlAttributes: new { @class = "control-label col-md-2 deep-brown" })
                <div class="col-md-10">
                    @Html.EditorFor(model => model.Address, new { htmlAttributes = new { @class = "form-control" } })
                    @Html.ValidationMessageFor(model => model.Address, "", new { @class = "text-danger" })
                </div>
            </div>
    
            <div class="form-group">
                @Html.LabelFor(model => model.City, htmlAttributes: new { @class = "control-label col-md-2 deep-brown" })
                <div class="col-md-10">
                    @Html.EditorFor(model => model.City, new { htmlAttributes = new { @class = "form-control" } })
                    @Html.ValidationMessageFor(model => model.City, "", new { @class = "text-danger" })
                </div>
            </div>
    
            <div class="form-group">
                @Html.LabelFor(model => model.County, htmlAttributes: new { @class = "control-label col-md-2 deep-brown" })
                <div class="col-md-10">
                    @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-2 deep-brown" })
                <div class="col-md-10">
                    @Html.EditorFor(model => model.State, new { htmlAttributes = new { @class = "form-control" } })
                    @Html.ValidationMessageFor(model => model.State, "", new { @class = "text-danger" })
                </div>
            </div>
    
            <div class="form-group">
                @Html.LabelFor(model => model.ZIPCode, htmlAttributes: new { @class = "control-label col-md-2 deep-brown" })
                <div class="col-md-10">
                    @Html.EditorFor(model => model.ZIPCode, new { htmlAttributes = new { @class = "form-control" } })
                    @Html.ValidationMessageFor(model => model.ZIPCode, "", new { @class = "text-danger" })
                </div>
            </div>
    
            <div class="form-group">
                <label class="control-label col-md-2">
                    @Html.ActionLink("Customers Accounts", "Index")
                </label>
                <div class="col-md-10">
                    <input type="submit" value="Update this Customer's Account" class="btn btn-warning" />
                </div>
            </div>
        </div>
    }
    
    @section Scripts {
        @Scripts.Render("~/bundles/jqueryval")
    }
  64. In the Solution Explorer, under Views and under GasMeters, double-click Index.cshtml
  65. Change the document as follows:
    @model IEnumerable<GasUtilityCompany1.Models.Customer>
    
    @{
        ViewBag.Title = "Customers Accounts";
        Layout = "~/Views/Shared/_Arrangement.cshtml";
    }
    
    <h2 class="common-font bold maroon text-center">Customers Accounts</h2>
    
    <table class="table table-striped common-font">
        <tr>
            <th class="text-center">@Html.DisplayNameFor(model => model.CustomerID)</th>
            <th>@Html.DisplayNameFor(model => model.AccountNumber)</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.GasMeter.MeterNumber)</th>
            <th>@Html.ActionLink("Create Customer Account", "Create")</th>
        </tr>
    
    @foreach (var item in Model) {
        <tr>
            <td class="text-center">@Html.DisplayFor(modelItem => item.CustomerID)</td>
            <td>@Html.DisplayFor(modelItem => item.AccountNumber)</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.GasMeter.MeterNumber)</td>
            <td>
                @Html.ActionLink("Edit", "Edit", new { id = item.CustomerID }) |
                @Html.ActionLink("Details", "Details", new { id = item.CustomerID }) |
                @Html.ActionLink("Delete", "Delete", new { id = item.CustomerID })
            </td>
        </tr>
    }
    </table>
  66. In the Solution Explorer, right-click Controllers -> Add -> Controller...
  67. In the middle frame of the Add Scaffold dialog box, make sure MVC 5 Controller With Views, Using Entity Framework is selected.
    Click Add
  68. Click the arrow of the Model Class combo box and select GasBill (GasUtilityCompany1.Models)
  69. Make sure the Data Context Class combo box is displaying GasDistributionEntities (GasUtilityCompany1.Models).
    Make sure the Use A Layout Page text box is displaying ~/Views/Shared/_Arrangement.cshtml.
    Click Add
  70. Change the class as follows:
    using System;
    using System.Collections.Generic;
    using System.Data;
    using System.Data.Entity;
    using System.Linq;
    using System.Net;
    using System.Web;
    using System.Web.Mvc;
    using GasUtilityCompany1.Models;
    
    namespace GasUtilityCompany1.Controllers
    {
        public class GasBillsController : Controller
        {
            private GasDistributionEntities db = new GasDistributionEntities();
    
            // GET: GasBills
            public ActionResult Index()
            {
                var gasBills = db.GasBills.Include(g => g.Customer);
                return View(gasBills.ToList());
            }
    
            // GET: GasBills/Details/5
            public ActionResult Details(int? id)
            {
                if (id == null)
                {
                    return new HttpStatusCodeResult(HttpStatusCode.BadRequest);
                }
                GasBill gasBill = db.GasBills.Find(id);
                if (gasBill == null)
                {
                    return HttpNotFound();
                }
                return View(gasBill);
            }
    
            public ActionResult StartGasBill()
            {
                return View();
            }
    
            public ActionResult PrepareGasBill(string AccountNumber, string MeterReadingEndDate, string CounterReadingEnd)
            {
                int? mre = -1;
                int custID = -1;
                int? meterId = -1;
                int consumption = 0;
                DateTime mrsd = DateTime.Today;
                Random rndTransportation = new Random();
                decimal[] transportation = { 9.75m, 9.95m, 10.25m, 10.45m, 10.85m, 12.55m, 13.50m, 14.35m };
    
                if (!string.IsNullOrEmpty(AccountNumber))
                {
                    foreach (var client in db.Customers)
                    {
                        if (client.AccountNumber == AccountNumber)
                        {
                            custID = client.CustomerID;
                            meterId = client.GasMeterID;
                            ViewBag.CustomerDetails = AccountNumber + " - " +
                                                      client.FirstName + " " + client.LastName +
                                                      " (" + client.City + ", " + client.State + ")";
                            break;
                        }
                    }
                }
    
                if (meterId > 0)
                {
                    foreach (var mtr in db.GasMeters)
                    {
                        if (mtr.GasMeterID == meterId)
                        {
                            ViewBag.MeterDetails = "Meter #: " + mtr.MeterNumber + " - " + mtr.Make + " " + mtr.Model;
                            mrsd = DateTime.Parse(mtr.MeterReadingDate.ToString());
                            mre = mtr.CounterValue;
                            break;
                        }
                    }
                }
    
                foreach (var bill in db.GasBills)
                {
                    if (bill.CustomerID == custID)
                    {
                        mrsd = DateTime.Parse(bill.MeterReadingEndDate.ToString());
                        mre = bill.CounterReadingEnd;
                    }
                }
    
                int cre = int.Parse(CounterReadingEnd);
    
                consumption = cre - int.Parse(mre.ToString());
    
                decimal totalTherms = consumption * 1.0367M;
                decimal first50Therms = 0, over50Therms = 0;
    
                if (totalTherms < 50)
                {
                    first50Therms = totalTherms * 0.5269M;
                    over50Therms = 0;
                }
                else
                {
                    first50Therms = 50 * 0.5269M;
                    over50Therms = (totalTherms - 50) * 0.4995M;
                }
    
                decimal transCharges = rndTransportation.Next(1, transportation.Length);
                decimal deliveryTotal = transCharges + first50Therms + over50Therms;
                decimal distribution = totalTherms * 0.11086M;
                var environment = deliveryTotal * 0.0045M;
                decimal totalCharges = transCharges + deliveryTotal + distribution + environment;
                decimal local = transCharges * 0.05826M;
                decimal state = transCharges * 0.0225M;
                var amtDue = totalCharges + local + state;
    
                TimeSpan tsDays = DateTime.Parse(MeterReadingEndDate) - mrsd;
    
                ViewData["CounterReadingStart"]    = mre;
                ViewData["CustomerID"]             = custID;
                ViewData["BillingDays"]            = tsDays.Days;
                ViewData["Consumption"]            = consumption;
                ViewData["CounterReadingEnd"]      = CounterReadingEnd;
                ViewData["StateTaxes"]             = state.ToString("F");
                ViewData["LocalTaxes"]             = local.ToString("F");
                ViewData["MeterReadingEndDate"]    = MeterReadingEndDate;
                ViewData["AmountDue"]              = amtDue.ToString("F");
                ViewData["MeterReadingStartDate"]  = mrsd.ToShortDateString();
                ViewData["TotalTherms"]            = totalTherms.ToString("F");
                ViewData["EnvironmentalCharges"]   = environment.ToString("F");
                ViewData["TransportationCharges"]  = transCharges.ToString("F");
                ViewData["Over50Therms"]           = over50Therms.ToString("F");
                ViewData["DistributionAdjustment"] = distribution.ToString("F");
                ViewData["TotalCharges"]           = totalCharges.ToString("F");
                ViewData["DeliveryTotal"]          = deliveryTotal.ToString("F");
                ViewData["First50Therms"]          = first50Therms.ToString("F");
                ViewData["LateAmountDue"]          = (amtDue + 8.35M).ToString("F");
                ViewData["PaymentDueDate"]         = DateTime.Parse(MeterReadingEndDate).AddDays(25).ToShortDateString();
    
                return View();
            }
    
            // GET: GasBills/Create
            public ActionResult Create()
            {
                ViewBag.CustomerID = new SelectList(db.Customers, "CustomerID", "AccountNumber");
                return View();
            }
    
            // POST: GasBills/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 = "GasBillID,CustomerID,MeterReadingStartDate,MeterReadingEndDate,BillingDays,CounterReadingStart,CounterReadingEnd,Consumption,TotalTherms,TransportationCharges,First50Therms,Over50Therms,DeliveryTotal,DistributionAdjustment,EnvironmentalCharges,TotalCharges,LocalTaxes,StateTaxes,PaymentDueDate,AmountDue,LateAmountDue")] GasBill gasBill)
            {
                if (ModelState.IsValid)
                {
                    db.GasBills.Add(gasBill);
                    db.SaveChanges();
                    return RedirectToAction("Index");
                }
    
                ViewBag.CustomerID = new SelectList(db.Customers, "CustomerID", "Identification", gasBill.CustomerID);
                return View(gasBill);
            }
    
            // GET: GasBills/Edit/5
            public ActionResult Edit(int? id)
            {
                if (id == null)
                {
                    return new HttpStatusCodeResult(HttpStatusCode.BadRequest);
                }
                GasBill gasBill = db.GasBills.Find(id);
                if (gasBill == null)
                {
                    return HttpNotFound();
                }
                ViewBag.CustomerID = new SelectList(db.Customers, "CustomerID", "Identification", gasBill.CustomerID);
                return View(gasBill);
            }
    
            // POST: GasBills/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 = "GasBillID,CustomerID,MeterReadingStartDate,MeterReadingEndDate,BillingDays,CounterReadingStart,CounterReadingEnd,Consumption,TotalTherms,TransportationCharges,First50Therms,Over50Therms,DeliveryTotal,DistributionAdjustment,EnvironmentalCharges,TotalCharges,LocalTaxes,StateTaxes,PaymentDueDate,AmountDue,LateAmountDue")] GasBill gasBill)
            {
                if (ModelState.IsValid)
                {
                    db.Entry(gasBill).State = EntityState.Modified;
                    db.SaveChanges();
                    return RedirectToAction("Index");
                }
                ViewBag.CustomerID = new SelectList(db.Customers, "CustomerID", "Identification", gasBill.CustomerID);
                return View(gasBill);
            }
    
            // GET: GasBills/Delete/5
            public ActionResult Delete(int? id)
            {
                if (id == null)
                {
                    return new HttpStatusCodeResult(HttpStatusCode.BadRequest);
                }
                GasBill gasBill = db.GasBills.Find(id);
                if (gasBill == null)
                {
                    return HttpNotFound();
                }
                return View(gasBill);
            }
    
            // POST: GasBills/Delete/5
            [HttpPost, ActionName("Delete")]
            [ValidateAntiForgeryToken]
            public ActionResult DeleteConfirmed(int id)
            {
                GasBill gasBill = db.GasBills.Find(id);
                db.GasBills.Remove(gasBill);
                db.SaveChanges();
                return RedirectToAction("Index");
            }
    
            protected override void Dispose(bool disposing)
            {
                if (disposing)
                {
                    db.Dispose();
                }
                base.Dispose(disposing);
            }
        }
    }
  71. In the class, right-click StartGasBill() and click Add View...
  72. Make sure the View Name text box is displaying StartGasBill. Click Add
  73. Create the smalll webpage as follows:
    @{
        ViewBag.Title = "Gas Bill Start-Up";
        Layout = "~/Views/Shared/_Arrangement.cshtml";
    }
    
    <h2 class="bottom-line common-font bold maroon">Gas Bill Start-Up</h2>
    
    @using (Html.BeginForm("PrepareGasBill", "GasBills", FormMethod.Post))
    {
        @Html.AntiForgeryToken()
    
        <div class="form-horizontal common-font">
            @Html.ValidationSummary(true, "", new { @class = "text-danger" })
            <div class="form-group">
                <label for="custNbr" class="control-label col-md-4 deep-brown">Customer Account #</label>
                <div class="col-md-8">
                    @Html.TextBox("AccountNumber", null, htmlAttributes: new { @class = "form-control", id = "custNbr" })
                </div>
            </div>
    
            <div class="form-group">
                <label for="mred" class="control-label col-md-4 deep-brown">Meter Reading End Date</label>
                <div class="col-md-8">
                    @Html.TextBox("MeterReadingEndDate", null,
                                  htmlAttributes: new { @class = "form-control", id = "mred" })
                </div>
            </div>
    
            <div class="form-group">
                <label for="cre" class="control-label col-md-4 deep-brown">Counter Reading End</label>
                <div class="col-md-8">
                    @Html.TextBox("CounterReadingEnd", null, htmlAttributes: new { @class = "form-control", id = "cre" })
                </div>
            </div>
    
            <div class="form-group">
                <label class="control-label col-md-4">
                    @Html.ActionLink("Gas Bills", "Index")
                </label>
                <div class="col-md-8">
                    <input type="submit" value="Prepare Gas Bill" class="btn btn-warning" />
                </div>
            </div>
        </div>
    }
    
    @section Scripts {
        @Scripts.Render("~/bundles/jqueryval")
    }
  74. Click the GasBillsController.cs tab
  75. In the class, right-click PrepareGasBill() and click Add View...
  76. Make sure the View Name text box displays PrepareGasBill. Click Add
  77. Create the form as follows:
    @model GasUtilityCompany1.Models.GasBill
    
    @{
        ViewBag.Title = "Prepare Gas Bill";
        Layout = "~/Views/Shared/_Arrangement.cshtml";
    }
    
    <h2 class="bold maroon common-font bottom-line">Prepare Gas Bill</h2>
    
    @using (Html.BeginForm("Create", "GasBills", FormMethod.Post))
    {
        @Html.AntiForgeryToken()
    
        <div class="form-horizontal common-font">
            @Html.ValidationSummary(true, "", new { @class = "text-danger" })
            <div class="form-group">
                <label for="customerID" class="control-label col-md-4 deep-brown">Customer</label>
                <div class="col-md-2">
                    @Html.TextBox("CustomerID", ViewData["CustomerID"], htmlAttributes: new { @class = "form-control", id = "customerID" })
                    @Html.ValidationMessageFor(model => model.CustomerID, "", new { @class = "text-danger" })
                </div>
            </div>
    
            <div class="form-group">
                <label class="col-md-4">.</label>
                <div class="col-md-8">
                    @Html.TextBox("CustomerDetails", ViewData["CustomerDetails"], htmlAttributes: new { @class = "form-control", id = "customerID" })
                </div>
            </div>
    
            <div class="form-group">
                <label class="control-label col-md-4">Customer Meter</label>
                <div class="col-md-8">
                    @Html.TextBox("MeterDetails", ViewData["MeterDetails"], htmlAttributes: new { @class = "form-control", id = "customerID" })
                </div>
            </div>
    
            <div class="form-group">
                @Html.LabelFor(model => model.MeterReadingStartDate, htmlAttributes: new { @class = "control-label col-md-4 deep-brown" })
                <div class="col-md-8">
                    @Html.TextBox("MeterReadingStartDate", ViewData["MeterReadingStartDate"],
                                  htmlAttributes: new { @class = "form-control", type = "date" })
                    @Html.ValidationMessageFor(model => model.MeterReadingStartDate, "", new { @class = "text-danger" })
                </div>
            </div>
    
            <div class="form-group">
                @Html.LabelFor(model => model.MeterReadingEndDate, htmlAttributes: new { @class = "control-label col-md-4 deep-brown" })
                <div class="col-md-8">
                    @Html.TextBox("MeterReadingEndDate", ViewData["MeterReadingEndDate"],
                                  htmlAttributes: new { @class = "form-control", type = "date" })
                    @Html.ValidationMessageFor(model => model.MeterReadingEndDate, "", new { @class = "text-danger" })
                </div>
            </div>
    
            <div class="form-group">
                @Html.LabelFor(model => model.BillingDays, htmlAttributes: new { @class = "control-label col-md-4 deep-brown" })
                <div class="col-md-8">
                    @Html.TextBox("BillingDays", ViewData["BillingDays"],
                                  htmlAttributes: new { @class = "form-control" })
                    @Html.ValidationMessageFor(model => model.BillingDays, "", new { @class = "text-danger" })
                </div>
            </div>
    
            <div class="form-group">
                @Html.LabelFor(model => model.CounterReadingStart, htmlAttributes: new { @class = "control-label col-md-4 deep-brown" })
                <div class="col-md-8">
                    @Html.TextBox("CounterReadingStart", ViewData["CounterReadingStart"],
                                  htmlAttributes: new { @class = "form-control" })
                    @Html.ValidationMessageFor(model => model.CounterReadingStart, "", new { @class = "text-danger" })
                </div>
            </div>
    
            <div class="form-group">
                @Html.LabelFor(model => model.CounterReadingEnd, htmlAttributes: new { @class = "control-label col-md-4 deep-brown" })
                <div class="col-md-8">
                    @Html.TextBox("CounterReadingEnd", ViewData["CounterReadingEnd"],
                                  htmlAttributes: new { @class = "form-control" })
                    @Html.ValidationMessageFor(model => model.CounterReadingEnd, "", new { @class = "text-danger" })
                </div>
            </div>
    
            <div class="form-group">
                @Html.LabelFor(model => model.Consumption, htmlAttributes: new { @class = "control-label col-md-4 deep-brown" })
                <div class="col-md-8">
                    @Html.TextBox("Consumption", ViewData["Consumption"], htmlAttributes: new { @class = "form-control" })
                    @Html.ValidationMessageFor(model => model.Consumption, "", new { @class = "text-danger" })
                </div>
            </div>
    
            <div class="form-group">
                @Html.LabelFor(model => model.TotalTherms, htmlAttributes: new { @class = "control-label col-md-4 deep-brown" })
                <div class="col-md-8">
                    @Html.TextBox("TotalTherms", ViewData["TotalTherms"], htmlAttributes: new { @class = "form-control" })
                    @Html.ValidationMessageFor(model => model.TotalTherms, "", new { @class = "text-danger" })
                </div>
            </div>
    
            <div class="form-group">
                @Html.LabelFor(model => model.TransportationCharges, htmlAttributes: new { @class = "control-label col-md-4 deep-brown" })
                <div class="col-md-8">
                    @Html.TextBox("TransportationCharges", ViewData["TransportationCharges"], htmlAttributes: new { @class = "form-control" })
                    @Html.ValidationMessageFor(model => model.TransportationCharges, "", new { @class = "text-danger" })
                </div>
            </div>
    
            <div class="form-group">
                @Html.LabelFor(model => model.First50Therms, htmlAttributes: new { @class = "control-label col-md-4 deep-brown" })
                <div class="col-md-8">
                    @Html.TextBox("First50Therms", ViewData["First50Therms"], htmlAttributes: new { @class = "form-control" })
                    @Html.ValidationMessageFor(model => model.First50Therms, "", new { @class = "text-danger" })
                </div>
            </div>
    
            <div class="form-group">
                @Html.LabelFor(model => model.Over50Therms, htmlAttributes: new { @class = "control-label col-md-4 deep-brown" })
                <div class="col-md-8">
                    @Html.TextBox("Over50Therms", ViewData["Over50Therms"], htmlAttributes: new { @class = "form-control" })
                    @Html.ValidationMessageFor(model => model.Over50Therms, "", new { @class = "text-danger" })
                </div>
            </div>
    
            <div class="form-group">
                @Html.LabelFor(model => model.DeliveryTotal, htmlAttributes: new { @class = "control-label col-md-4 deep-brown" })
                <div class="col-md-8">
                    @Html.TextBox("DeliveryTotal", ViewData["DeliveryTotal"], htmlAttributes: new { @class = "form-control" })
                    @Html.ValidationMessageFor(model => model.DeliveryTotal, "", new { @class = "text-danger" })
                </div>
            </div>
    
            <div class="form-group">
                @Html.LabelFor(model => model.DistributionAdjustment, htmlAttributes: new { @class = "control-label col-md-4 deep-brown" })
                <div class="col-md-8">
                    @Html.TextBox("DistributionAdjustment", ViewData["DistributionAdjustment"], htmlAttributes: new { @class = "form-control" })
                    @Html.ValidationMessageFor(model => model.DistributionAdjustment, "", new { @class = "text-danger" })
                </div>
            </div>
    
            <div class="form-group">
                @Html.LabelFor(model => model.EnvironmentalCharges, htmlAttributes: new { @class = "control-label col-md-4 deep-brown" })
                <div class="col-md-8">
                    @Html.TextBox("EnvironmentalCharges", ViewData["EnvironmentalCharges"], htmlAttributes: new { @class = "form-control" })
                    @Html.ValidationMessageFor(model => model.EnvironmentalCharges, "", new { @class = "text-danger" })
                </div>
            </div>
    
            <div class="form-group">
                @Html.LabelFor(model => model.TotalCharges, htmlAttributes: new { @class = "control-label col-md-4 deep-brown" })
                <div class="col-md-8">
                    @Html.TextBox("TotalCharges", ViewData["TotalCharges"], htmlAttributes: new { @class = "form-control" })
                    @Html.ValidationMessageFor(model => model.TotalCharges, "", new { @class = "text-danger" })
                </div>
            </div>
    
            <div class="form-group">
                @Html.LabelFor(model => model.LocalTaxes, htmlAttributes: new { @class = "control-label col-md-4 deep-brown" })
                <div class="col-md-8">
                    @Html.TextBox("LocalTaxes", ViewData["LocalTaxes"], htmlAttributes: new { @class = "form-control" })
                    @Html.ValidationMessageFor(model => model.LocalTaxes, "", new { @class = "text-danger" })
                </div>
            </div>
    
            <div class="form-group">
                @Html.LabelFor(model => model.StateTaxes, htmlAttributes: new { @class = "control-label col-md-4 deep-brown" })
                <div class="col-md-8">
                    @Html.TextBox("StateTaxes", ViewData["StateTaxes"], htmlAttributes: new { @class = "form-control" })
                    @Html.ValidationMessageFor(model => model.StateTaxes, "", new { @class = "text-danger" })
                </div>
            </div>
    
            <div class="form-group">
                @Html.LabelFor(model => model.PaymentDueDate, htmlAttributes: new { @class = "control-label col-md-4 deep-brown" })
                <div class="col-md-8">
                    @Html.TextBox("PaymentDueDate", ViewData["PaymentDueDate"],
                                  htmlAttributes: new { @class = "form-control", type = "date" })
                    @Html.ValidationMessageFor(model => model.PaymentDueDate, "", new { @class = "text-danger" })
                </div>
            </div>
    
            <div class="form-group">
                @Html.LabelFor(model => model.AmountDue, htmlAttributes: new { @class = "control-label col-md-4 deep-brown" })
                <div class="col-md-8">
                    @Html.TextBox("AmountDue", ViewData["AmountDue"], htmlAttributes: new { @class = "form-control" })
                    @Html.ValidationMessageFor(model => model.AmountDue, "", new { @class = "text-danger" })
                </div>
            </div>
    
            <div class="form-group">
                @Html.LabelFor(model => model.LateAmountDue, htmlAttributes: new { @class = "control-label col-md-4 deep-brown" })
                <div class="col-md-8">
                    @Html.TextBox("LateAmountDue", ViewData["LateAmountDue"], htmlAttributes: new { @class = "form-control" })
                    @Html.ValidationMessageFor(model => model.LateAmountDue, "", new { @class = "text-danger" })
                </div>
            </div>
    
            <div class="form-group">
                <label class="control-label col-md-4">
                    @Html.ActionLink("Gas Bills", "Index")
                </label>
                <div class="col-md-8">
                    <input type="submit" value="Save Gas Bill" class="btn btn-warning" />
                </div>
            </div>
        </div>
    }
    
    @section Scripts {
        @Scripts.Render("~/bundles/jqueryval")
    }
  78. In the Solution Explorer, under Views and under GasBills, double-click Delete.cshtml
  79. Change the document as follows:
    @model GasUtilityCompany1.Models.GasBill
    
    @{
        ViewBag.Title = "Delete Gas Bill";
        Layout = "~/Views/Shared/_Arrangement.cshtml";
    }
    
    <h2 class="common-font maroon bold bottom-line">Are you sure you want to cancel this gas bill?</h2>
    
    <h3 class="maroon common-font">Are you sure you want to delete this?</h3>
    
    <div>
        <dl class="dl-horizontal common-font">
            <dt>@Html.DisplayNameFor(model => model.GasBillID)</dt>
            <dd>@Html.DisplayFor(model => model.GasBillID)</dd>
    
            <dt>@Html.DisplayNameFor(model => model.MeterReadingStartDate)</dt>
            <dd>@Html.DisplayFor(model => model.MeterReadingStartDate)</dd>
    
            <dt>@Html.DisplayNameFor(model => model.MeterReadingEndDate)</dt>
            <dd>@Html.DisplayFor(model => model.MeterReadingEndDate)</dd>
    
            <dt>@Html.DisplayNameFor(model => model.BillingDays)</dt>
            <dd>@Html.DisplayFor(model => model.BillingDays)</dd>
    
            <dt>@Html.DisplayNameFor(model => model.CounterReadingStart)</dt>
            <dd>@Html.DisplayFor(model => model.CounterReadingStart)</dd>
    
            <dt>@Html.DisplayNameFor(model => model.CounterReadingEnd)</dt>
            <dd>@Html.DisplayFor(model => model.CounterReadingEnd)</dd>
    
            <dt>@Html.DisplayNameFor(model => model.Consumption)</dt>
            <dd>@Html.DisplayFor(model => model.Consumption)</dd>
    
            <dt>@Html.DisplayNameFor(model => model.TotalTherms)</dt>
            <dd>@Html.DisplayFor(model => model.TotalTherms)</dd>
    
            <dt>@Html.DisplayNameFor(model => model.TransportationCharges)</dt>
            <dd>@Html.DisplayFor(model => model.TransportationCharges)</dd>
    
            <dt>@Html.DisplayNameFor(model => model.First50Therms)</dt>
            <dd>@Html.DisplayFor(model => model.First50Therms)</dd>
    
            <dt>@Html.DisplayNameFor(model => model.Over50Therms)</dt>
            <dd>@Html.DisplayFor(model => model.Over50Therms)</dd>
    
            <dt>@Html.DisplayNameFor(model => model.DeliveryTotal)</dt>
            <dd>@Html.DisplayFor(model => model.DeliveryTotal)</dd>
    
            <dt>@Html.DisplayNameFor(model => model.DistributionAdjustment)</dt>
            <dd>@Html.DisplayFor(model => model.DistributionAdjustment)</dd>
    
            <dt>@Html.DisplayNameFor(model => model.EnvironmentalCharges)</dt>
            <dd>@Html.DisplayFor(model => model.EnvironmentalCharges)</dd>
    
            <dt>@Html.DisplayNameFor(model => model.TotalCharges)</dt>
            <dd>@Html.DisplayFor(model => model.TotalCharges)</dd>
    
            <dt>@Html.DisplayNameFor(model => model.LocalTaxes)</dt>
            <dd>@Html.DisplayFor(model => model.LocalTaxes)</dd>
    
            <dt>@Html.DisplayNameFor(model => model.StateTaxes)</dt>
            <dd>@Html.DisplayFor(model => model.StateTaxes)</dd>
    
            <dt>@Html.DisplayNameFor(model => model.PaymentDueDate)</dt>
            <dd>@Html.DisplayFor(model => model.PaymentDueDate)</dd>
    
            <dt>@Html.DisplayNameFor(model => model.AmountDue)</dt>
            <dd>@Html.DisplayFor(model => model.AmountDue)</dd>
    
            <dt>@Html.DisplayNameFor(model => model.LateAmountDue)</dt>
            <dd>@Html.DisplayFor(model => model.LateAmountDue)</dd>
    
            <dt>@Html.DisplayNameFor(model => model.Customer.AccountNumber)</dt>
            <dd>@Html.DisplayFor(model => model.Customer.AccountNumber)</dd>
        </dl>
    
        @using (Html.BeginForm()) {
            @Html.AntiForgeryToken()
    
            <div class="form-actions no-color">
                <input type="submit" value="Delete this Gas Bill" class="btn btn-warning" /> |
                @Html.ActionLink("Gas Bills", "Index")
            </div>
        }
    </div>
  80. In the Solution Explorer, under Views and under GasBills, double-click Details.cshtml
  81. Change the document as follows:
    @model GasUtilityCompany1.Models.GasBill
    
    @{
        ViewBag.Title = "Gas Bill Details";
        Layout = "~/Views/Shared/_Arrangement.cshtml";
    }
    
    <h2 class="maroon common-font bold bottom-line">Gas Bill Details</h2>
    
    <div>
        <dl class="dl-horizontal common-font">
            <dt>@Html.DisplayNameFor(model => model.GasBillID)</dt>
            <dd>@Html.DisplayFor(model => model.GasBillID)</dd>
    
            <dt>@Html.DisplayNameFor(model => model.MeterReadingStartDate)</dt>
            <dd>@Html.DisplayFor(model => model.MeterReadingStartDate)</dd>
    
            <dt>@Html.DisplayNameFor(model => model.MeterReadingEndDate)</dt>
            <dd>@Html.DisplayFor(model => model.MeterReadingEndDate)</dd>
    
            <dt>@Html.DisplayNameFor(model => model.BillingDays)</dt>
            <dd>@Html.DisplayFor(model => model.BillingDays)</dd>
    
            <dt>@Html.DisplayNameFor(model => model.CounterReadingStart)</dt>
            <dd>@Html.DisplayFor(model => model.CounterReadingStart)</dd>
    
            <dt>@Html.DisplayNameFor(model => model.CounterReadingEnd)</dt>
            <dd>@Html.DisplayFor(model => model.CounterReadingEnd)</dd>
    
            <dt>@Html.DisplayNameFor(model => model.Consumption)</dt>
            <dd>@Html.DisplayFor(model => model.Consumption)</dd>
    
            <dt>@Html.DisplayNameFor(model => model.TotalTherms)</dt>
            <dd>@Html.DisplayFor(model => model.TotalTherms)</dd>
    
            <dt>@Html.DisplayNameFor(model => model.TransportationCharges)</dt>
            <dd>@Html.DisplayFor(model => model.TransportationCharges)</dd>
    
            <dt>@Html.DisplayNameFor(model => model.First50Therms)</dt>
            <dd>@Html.DisplayFor(model => model.First50Therms)</dd>
    
            <dt>@Html.DisplayNameFor(model => model.Over50Therms)</dt>
            <dd>@Html.DisplayFor(model => model.Over50Therms)</dd>
    
            <dt>@Html.DisplayNameFor(model => model.DeliveryTotal)</dt>
            <dd>@Html.DisplayFor(model => model.DeliveryTotal)</dd>
    
            <dt>@Html.DisplayNameFor(model => model.DistributionAdjustment)</dt>
            <dd>@Html.DisplayFor(model => model.DistributionAdjustment)</dd>
    
            <dt>@Html.DisplayNameFor(model => model.EnvironmentalCharges)</dt>
            <dd>@Html.DisplayFor(model => model.EnvironmentalCharges)</dd>
    
            <dt>@Html.DisplayNameFor(model => model.TotalCharges)</dt>
            <dd>@Html.DisplayFor(model => model.TotalCharges)</dd>
    
            <dt>@Html.DisplayNameFor(model => model.LocalTaxes)</dt>
            <dd>@Html.DisplayFor(model => model.LocalTaxes)</dd>
    
            <dt>@Html.DisplayNameFor(model => model.StateTaxes)</dt>
            <dd>@Html.DisplayFor(model => model.StateTaxes)</dd>
    
            <dt>@Html.DisplayNameFor(model => model.PaymentDueDate)</dt>
            <dd>@Html.DisplayFor(model => model.PaymentDueDate)</dd>
    
            <dt>@Html.DisplayNameFor(model => model.AmountDue)</dt>
            <dd>@Html.DisplayFor(model => model.AmountDue)</dd>
    
            <dt>@Html.DisplayNameFor(model => model.LateAmountDue)</dt>
            <dd>@Html.DisplayFor(model => model.LateAmountDue)</dd>
    
            <dt>@Html.DisplayNameFor(model => model.Customer.AccountNumber)</dt>
            <dd>@Html.DisplayFor(model => model.Customer.AccountNumber)</dd>
        </dl>
    </div>
    
    <p>
        @Html.ActionLink("Edit", "Edit", new { id = Model.GasBillID }) |
        @Html.ActionLink("Gas Bills", "Index")
    </p>
  82. In the Solution Explorer, under Views and under GasBills, double-click Edit.cshtml
  83. Change the document as follows:
    @model GasUtilityCompany1.Models.GasBill
    
    @{
        ViewBag.Title = "Edit/Update Gas Bill";
        Layout = "~/Views/Shared/_Arrangement.cshtml";
    }
    
    <h2 class="maroon bold bottom-line common-font">Edit/Update Gas Bill</h2>
    
    
    @using (Html.BeginForm())
    {
        @Html.AntiForgeryToken()
        
         <div class="form-horizontal common-font">
            @Html.ValidationSummary(true, "", new { @class = "text-danger" })
            @Html.HiddenFor(model => model.GasBillID)
    
            <div class="form-group">
                <label for="gasMeterID" class="control-label col-md-4 deep-brown">Customer</label>
                <div class="col-md-8">
                    @Html.DropDownList("CustomerID", null, htmlAttributes: new { @class = "form-control" })
                    @Html.ValidationMessageFor(model => model.CustomerID, "", new { @class = "text-danger" })
                </div>
            </div>
    
            <div class="form-group">
                @Html.LabelFor(model => model.MeterReadingStartDate, htmlAttributes: new { @class = "control-label col-md-4 deep-brown" })
                <div class="col-md-8">
                    @Html.EditorFor(model => model.MeterReadingStartDate, new { htmlAttributes = new { @class = "form-control" } })
                    @Html.ValidationMessageFor(model => model.MeterReadingStartDate, "", new { @class = "text-danger" })
                </div>
            </div>
    
            <div class="form-group">
                @Html.LabelFor(model => model.MeterReadingEndDate, htmlAttributes: new { @class = "control-label col-md-4 deep-brown" })
                <div class="col-md-8">
                    @Html.EditorFor(model => model.MeterReadingEndDate, new { htmlAttributes = new { @class = "form-control" } })
                    @Html.ValidationMessageFor(model => model.MeterReadingEndDate, "", new { @class = "text-danger" })
                </div>
            </div>
    
            <div class="form-group">
                @Html.LabelFor(model => model.BillingDays, htmlAttributes: new { @class = "control-label col-md-4 deep-brown" })
                <div class="col-md-8">
                    @Html.EditorFor(model => model.BillingDays, new { htmlAttributes = new { @class = "form-control" } })
                    @Html.ValidationMessageFor(model => model.BillingDays, "", new { @class = "text-danger" })
                </div>
            </div>
    
            <div class="form-group">
                @Html.LabelFor(model => model.CounterReadingStart, htmlAttributes: new { @class = "control-label col-md-4 deep-brown" })
                <div class="col-md-8">
                    @Html.EditorFor(model => model.CounterReadingStart, new { htmlAttributes = new { @class = "form-control" } })
                    @Html.ValidationMessageFor(model => model.CounterReadingStart, "", new { @class = "text-danger" })
                </div>
            </div>
    
            <div class="form-group">
                @Html.LabelFor(model => model.CounterReadingEnd, htmlAttributes: new { @class = "control-label col-md-4 deep-brown" })
                <div class="col-md-8">
                    @Html.EditorFor(model => model.CounterReadingEnd, new { htmlAttributes = new { @class = "form-control" } })
                    @Html.ValidationMessageFor(model => model.CounterReadingEnd, "", new { @class = "text-danger" })
                </div>
            </div>
    
            <div class="form-group">
                @Html.LabelFor(model => model.Consumption, htmlAttributes: new { @class = "control-label col-md-4 deep-brown" })
                <div class="col-md-8">
                    @Html.EditorFor(model => model.Consumption, new { htmlAttributes = new { @class = "form-control" } })
                    @Html.ValidationMessageFor(model => model.Consumption, "", new { @class = "text-danger" })
                </div>
            </div>
    
            <div class="form-group">
                @Html.LabelFor(model => model.TotalTherms, htmlAttributes: new { @class = "control-label col-md-4 deep-brown" })
                <div class="col-md-8">
                    @Html.EditorFor(model => model.TotalTherms, new { htmlAttributes = new { @class = "form-control" } })
                    @Html.ValidationMessageFor(model => model.TotalTherms, "", new { @class = "text-danger" })
                </div>
            </div>
    
            <div class="form-group">
                @Html.LabelFor(model => model.TransportationCharges, htmlAttributes: new { @class = "control-label col-md-4 deep-brown" })
                <div class="col-md-8">
                    @Html.EditorFor(model => model.TransportationCharges, new { htmlAttributes = new { @class = "form-control" } })
                    @Html.ValidationMessageFor(model => model.TransportationCharges, "", new { @class = "text-danger" })
                </div>
            </div>
    
            <div class="form-group">
                @Html.LabelFor(model => model.First50Therms, htmlAttributes: new { @class = "control-label col-md-4 deep-brown" })
                <div class="col-md-8">
                    @Html.EditorFor(model => model.First50Therms, new { htmlAttributes = new { @class = "form-control" } })
                    @Html.ValidationMessageFor(model => model.First50Therms, "", new { @class = "text-danger" })
                </div>
            </div>
    
            <div class="form-group">
                @Html.LabelFor(model => model.Over50Therms, htmlAttributes: new { @class = "control-label col-md-4 deep-brown" })
                <div class="col-md-8">
                    @Html.EditorFor(model => model.Over50Therms, new { htmlAttributes = new { @class = "form-control" } })
                    @Html.ValidationMessageFor(model => model.Over50Therms, "", new { @class = "text-danger" })
                </div>
            </div>
    
            <div class="form-group">
                @Html.LabelFor(model => model.DeliveryTotal, htmlAttributes: new { @class = "control-label col-md-4 deep-brown" })
                <div class="col-md-8">
                    @Html.EditorFor(model => model.DeliveryTotal, new { htmlAttributes = new { @class = "form-control" } })
                    @Html.ValidationMessageFor(model => model.DeliveryTotal, "", new { @class = "text-danger" })
                </div>
            </div>
    
            <div class="form-group">
                @Html.LabelFor(model => model.DistributionAdjustment, htmlAttributes: new { @class = "control-label col-md-4 deep-brown" })
                <div class="col-md-8">
                    @Html.EditorFor(model => model.DistributionAdjustment, new { htmlAttributes = new { @class = "form-control" } })
                    @Html.ValidationMessageFor(model => model.DistributionAdjustment, "", new { @class = "text-danger" })
                </div>
            </div>
    
            <div class="form-group">
                @Html.LabelFor(model => model.EnvironmentalCharges, htmlAttributes: new { @class = "control-label col-md-4 deep-brown" })
                <div class="col-md-8">
                    @Html.EditorFor(model => model.EnvironmentalCharges, new { htmlAttributes = new { @class = "form-control" } })
                    @Html.ValidationMessageFor(model => model.EnvironmentalCharges, "", new { @class = "text-danger" })
                </div>
            </div>
    
            <div class="form-group">
                @Html.LabelFor(model => model.TotalCharges, htmlAttributes: new { @class = "control-label col-md-4 deep-brown" })
                <div class="col-md-8">
                    @Html.EditorFor(model => model.TotalCharges, new { htmlAttributes = new { @class = "form-control" } })
                    @Html.ValidationMessageFor(model => model.TotalCharges, "", new { @class = "text-danger" })
                </div>
            </div>
    
            <div class="form-group">
                @Html.LabelFor(model => model.LocalTaxes, htmlAttributes: new { @class = "control-label col-md-4 deep-brown" })
                <div class="col-md-8">
                    @Html.EditorFor(model => model.LocalTaxes, new { htmlAttributes = new { @class = "form-control" } })
                    @Html.ValidationMessageFor(model => model.LocalTaxes, "", new { @class = "text-danger" })
                </div>
            </div>
    
            <div class="form-group">
                @Html.LabelFor(model => model.StateTaxes, htmlAttributes: new { @class = "control-label col-md-4 deep-brown" })
                <div class="col-md-8">
                    @Html.EditorFor(model => model.StateTaxes, new { htmlAttributes = new { @class = "form-control" } })
                    @Html.ValidationMessageFor(model => model.StateTaxes, "", new { @class = "text-danger" })
                </div>
            </div>
    
            <div class="form-group">
                @Html.LabelFor(model => model.PaymentDueDate, htmlAttributes: new { @class = "control-label col-md-4 deep-brown" })
                <div class="col-md-8">
                    @Html.EditorFor(model => model.PaymentDueDate, new { htmlAttributes = new { @class = "form-control" } })
                    @Html.ValidationMessageFor(model => model.PaymentDueDate, "", new { @class = "text-danger" })
                </div>
            </div>
    
            <div class="form-group">
                @Html.LabelFor(model => model.AmountDue, htmlAttributes: new { @class = "control-label col-md-4 deep-brown" })
                <div class="col-md-8">
                    @Html.EditorFor(model => model.AmountDue, new { htmlAttributes = new { @class = "form-control" } })
                    @Html.ValidationMessageFor(model => model.AmountDue, "", new { @class = "text-danger" })
                </div>
            </div>
    
            <div class="form-group">
                @Html.LabelFor(model => model.LateAmountDue, htmlAttributes: new { @class = "control-label col-md-4 deep-brown" })
                <div class="col-md-8">
                    @Html.EditorFor(model => model.LateAmountDue, new { htmlAttributes = new { @class = "form-control" } })
                    @Html.ValidationMessageFor(model => model.LateAmountDue, "", new { @class = "text-danger" })
                </div>
            </div>
    
            <div class="form-group">
                <label class="control-label col-md-4">
                    @Html.ActionLink("Gas Bills", "Index")
                </label>
                <div class="col-md-8">
                    <input type="submit" value="Update this Gas Bill" class="btn btn-warning" />
                </div>
            </div>
        </div>
    }
    
    @section Scripts {
        @Scripts.Render("~/bundles/jqueryval")
    }
  84. In the Solution Explorer, under Views and under GasBills, double-click Index.cshtml
  85. Change the document as follows:
    @model IEnumerable<GasUtilityCompany1.Models.GasBill>
    
    @{
        ViewBag.Title = "Gas Bills";
        Layout = "~/Views/Shared/_Arrangement.cshtml";
    }
    
    <h2 class="common-font bold maroon text-center">Gas Bills</h2>
    
    <table class="table table-striped common-font">
        <tr>
            <th>@Html.DisplayNameFor(model => model.GasBillID)</th>
            <th>@Html.DisplayNameFor(model => model.MeterReadingStartDate)</th>
            <th>@Html.DisplayNameFor(model => model.MeterReadingEndDate)</th>
            <th>@Html.DisplayNameFor(model => model.BillingDays)</th>
            <th>@Html.DisplayNameFor(model => model.CounterReadingStart)</th>
            <th>@Html.DisplayNameFor(model => model.CounterReadingEnd)</th>
            <th>@Html.DisplayNameFor(model => model.Consumption)</th>
            <th>@Html.DisplayNameFor(model => model.TotalTherms)</th>
            <th>@Html.DisplayNameFor(model => model.TransportationCharges)</th>
            <th>@Html.DisplayNameFor(model => model.First50Therms)</th>
            <th>@Html.DisplayNameFor(model => model.Over50Therms)</th>
            <th>@Html.DisplayNameFor(model => model.DeliveryTotal)</th>
            <th>@Html.DisplayNameFor(model => model.DistributionAdjustment)</th>
            <th>@Html.DisplayNameFor(model => model.EnvironmentalCharges)</th>
            <th>@Html.DisplayNameFor(model => model.TotalCharges)</th>
            <th>@Html.DisplayNameFor(model => model.LocalTaxes)</th>
            <th>@Html.DisplayNameFor(model => model.StateTaxes)</th>
            <th>@Html.DisplayNameFor(model => model.PaymentDueDate)</th>
            <th>@Html.DisplayNameFor(model => model.AmountDue)</th>
            <th>@Html.DisplayNameFor(model => model.LateAmountDue)</th>
            <th>@Html.DisplayNameFor(model => model.Customer.AccountNumber)</th>
            <th>@Html.ActionLink("Create Gas Bill", "StartGasBill")</th>
        </tr>
    
    @foreach (var item in Model)
    {
        string mrsd = DateTime.Parse(item.MeterReadingStartDate.ToString()).ToShortDateString();
        string mred = DateTime.Parse(item.MeterReadingEndDate.ToString()).ToShortDateString();
        string pdd = DateTime.Parse(item.PaymentDueDate.ToString()).ToShortDateString();
    
        <tr>
            <td>@Html.DisplayFor(modelItem => item.GasBillID)</td>
            <td>@mrsd</td>
            <td>@mred</td>
            <td>@Html.DisplayFor(modelItem => item.BillingDays)</td>
            <td>@Html.DisplayFor(modelItem => item.CounterReadingStart)</td>
            <td>@Html.DisplayFor(modelItem => item.CounterReadingEnd)</td>
            <td>@Html.DisplayFor(modelItem => item.Consumption)</td>
            <td>@Html.DisplayFor(modelItem => item.TotalTherms)</td>
            <td>@Html.DisplayFor(modelItem => item.TransportationCharges)</td>
            <td>@Html.DisplayFor(modelItem => item.First50Therms)</td>
            <td>@Html.DisplayFor(modelItem => item.Over50Therms)</td>
            <td>@Html.DisplayFor(modelItem => item.DeliveryTotal)</td>
            <td>@Html.DisplayFor(modelItem => item.DistributionAdjustment)</td>
            <td>@Html.DisplayFor(modelItem => item.EnvironmentalCharges)</td>
            <td>@Html.DisplayFor(modelItem => item.TotalCharges)</td>
            <td>@Html.DisplayFor(modelItem => item.LocalTaxes)</td>
            <td>@Html.DisplayFor(modelItem => item.StateTaxes)</td>
            <td>@pdd</td>
            <td>@Html.DisplayFor(modelItem => item.AmountDue)</td>
            <td>@Html.DisplayFor(modelItem => item.LateAmountDue)</td>
            <td>@Html.DisplayFor(modelItem => item.Customer.AccountNumber)</td>
            <td>
                @Html.ActionLink("Edit", "Edit", new { id = item.GasBillID }) |
                @Html.ActionLink("Details", "Details", new { id = item.GasBillID }) |
                @Html.ActionLink("Delete", "Delete", new { id = item.GasBillID })
            </td>
        </tr>
    }
    </table>
  86. In the Solution Explorer, right-click Controllers -> Add -> New Scafolded Item...
  87. In the middle frame of the Add Scaffold dialog box, click MVC 5 Controller With Views, Using Entity Framework.
    Click Add
  88. Click the arrow of the Model Class combo box and select Payment (GasUtilityCompany1.Models)
  89. Click the arrow of the Data Context Class combo box and select GasDistributionEntities (GasUtilityCompany1.Models)
  90. Make sure the Data Context Class combo box is displaying GasDistributionEntities (GasUtilityCompany1.Models).
    Make sure the Use A Layout Page text box is displaying ~/Views/Shared/_Arrangement.cshtml.
    Click Add
  91. Change the PaymentsController class as follows:
    using GasUtilityCompany1.Models;
    using System.Collections.Generic;
    using System.Data.Entity;
    using System.Linq;
    using System.Net;
    using System.Web.Mvc;
    
    namespace GasUtilityCompany1.Controllers
    {
        public class PaymentsController : Controller
        {
            private GasDistributionEntities db = new GasDistributionEntities();
    
            // GET: Payments
            public ActionResult Index()
            {
                var payments = db.Payments.Include(p => p.GasBill);
                return View(payments.ToList());
            }
    
            // GET: Payments/Details/5
            public ActionResult Details(int? id)
            {
                if (id == null)
                {
                    return new HttpStatusCodeResult(HttpStatusCode.BadRequest);
                }
                Payment payment = db.Payments.Find(id);
                ViewData["PaymentDate"] = DateTime.Parse(payment.PaymentDate.ToString()).ToLongDateString();
    
                if (payment == null)
                {
                    return HttpNotFound();
                }
                return View(payment);
            }
    
            // GET: Payments/Create
            public ActionResult Create()
            {
                List<SelectListItem> pmtStatus = new List<SelectListItem>();
    
                pmtStatus.Add(new SelectListItem() { Text = "Unknown", Value = "Unknown" });
                pmtStatus.Add(new SelectListItem() { Text = "On Time", Value = "On Time" });
                pmtStatus.Add(new SelectListItem() { Text = "Late Payment", Value = "Late Payment" });
    
                ViewData["PaymentStatus"] = pmtStatus;
                ViewBag.GasBillID = new SelectList(db.GasBills, "GasBillID", "Identification");
                return View();
            }
    
            // POST: Payments/Create
            // To protect from overposting attacks, please enable the specific properties you want to bind to, for 
            // more details see https://go.microsoft.com/fwlink/?LinkId=317598.
            [HttpPost]
            [ValidateAntiForgeryToken]
            public ActionResult Create([Bind(Include = "PaymentID,PaymentDate,GasBillID,PaymentAmount,PaymentStatus")] Payment payment)
            {
                if (ModelState.IsValid)
                {
                    db.Payments.Add(payment);
                    db.SaveChanges();
                    return RedirectToAction("Index");
                }
    
                ViewBag.GasBillID = new SelectList(db.GasBills, "GasBillID", "Identification", payment.GasBillID);
    
                return View(payment);
            }
    
            // GET: Payments/Edit/5
            public ActionResult Edit(int? id)
            {
                if (id == null)
                {
                    return new HttpStatusCodeResult(HttpStatusCode.BadRequest);
                }
                Payment payment = db.Payments.Find(id);
                if (payment == null)
                {
                    return HttpNotFound();
                }
    
                List<SelectListItem> pmtStatus = new List<SelectListItem>
                {
                    new SelectListItem() { Text = "Unknown", Value = "Unknown", Selected = (payment.PaymentStatus == "Unknown") },
                    new SelectListItem() { Text = "On Time", Value = "On Time", Selected = (payment.PaymentStatus == "On Time") },
                    new SelectListItem() { Text = "Late Payment", Value = "Late Payment", Selected = (payment.PaymentStatus == "Late Payment") }
                };
    
                ViewData["PaymentStatus"] = pmtStatus;
                ViewBag.GasBillID = new SelectList(db.GasBills, "GasBillID", "Identification", payment.GasBillID);
                return View(payment);
            }
    
            // POST: Payments/Edit/5
            // To protect from overposting attacks, please enable the specific properties you want to bind to, for 
            // more details see https://go.microsoft.com/fwlink/?LinkId=317598.
            [HttpPost]
            [ValidateAntiForgeryToken]
            public ActionResult Edit([Bind(Include = "PaymentID,PaymentDate,GasBillID,PaymentAmount,PaymentStatus")] Payment payment)
            {
                if (ModelState.IsValid)
                {
                    db.Entry(payment).State = EntityState.Modified;
                    db.SaveChanges();
                    return RedirectToAction("Index");
                }
                ViewBag.GasBillID = new SelectList(db.GasBills, "GasBillID", "Identification", payment.GasBillID);
                return View(payment);
            }
    
            // GET: Payments/Delete/5
            public ActionResult Delete(int? id)
            {
                if (id == null)
                {
                    return new HttpStatusCodeResult(HttpStatusCode.BadRequest);
                }
                Payment payment = db.Payments.Find(id);
                ViewData["PaymentDate"] = DateTime.Parse(payment.PaymentDate.ToString()).ToLongDateString();
    
                if (payment == null)
                {
                    return HttpNotFound();
                }
                return View(payment);
            }
    
            // POST: Payments/Delete/5
            [HttpPost, ActionName("Delete")]
            [ValidateAntiForgeryToken]
            public ActionResult DeleteConfirmed(int id)
            {
                Payment payment = db.Payments.Find(id);
                db.Payments.Remove(payment);
                db.SaveChanges();
                return RedirectToAction("Index");
            }
    
            protected override void Dispose(bool disposing)
            {
                if (disposing)
                {
                    db.Dispose();
                }
                base.Dispose(disposing);
            }
        }
    }
  92. In the class, right-click Index() and click Go To View.
  93. Change the document as follows:
    @model IEnumerable<GasUtilityCompany1.Models.Payment>
    
    @{
        ViewBag.Title = "Bills Payments";
        Layout = "~/Views/Shared/_Arrangement.cshtml";
    }
    
    <h2 class="common-font bold maroon text-center">Gas Bills Payments</h2>
    
    <table class="table table-striped common-font">
        <tr>
            <th class="text-center">@Html.DisplayNameFor(model => model.PaymentID)</th>
            <th>@Html.DisplayNameFor(model => model.PaymentDate)</th>
            <th>@Html.DisplayNameFor(model => model.PaymentAmount)</th>
            <th>@Html.DisplayNameFor(model => model.PaymentStatus)</th>
            <th>Gas Bill</th>
            <th>@Html.ActionLink("Make Bill Payment", "Create")</th>
        </tr>
    
    @foreach (var item in Model)
    {
        string strPaymentDate = DateTime.Parse(item.PaymentDate.ToString()).ToShortDateString();
    
        <tr>
            <td class="text-center">@Html.DisplayFor(modelItem => item.PaymentID)</td>
            <td>@strPaymentDate</td>
            <td>@Html.DisplayFor(modelItem => item.PaymentAmount)</td>
            <td>@Html.DisplayFor(modelItem => item.PaymentStatus)</td>
            <td>@Html.DisplayFor(modelItem => item.GasBill.Identification)</td>
            <td>
                @Html.ActionLink("Edit", "Edit", new { id = item.PaymentID }) |
                @Html.ActionLink("Details", "Details", new { id = item.PaymentID }) |
                @Html.ActionLink("Delete", "Delete", new { id = item.PaymentID })
            </td>
        </tr>
    }
    
    </table>
  94. In the Solution Explorer, under Views and under Payments, double-click Delete.cshtml
  95. Create the form as follows:
    @model GasUtilityCompany1.Models.Payment
    
    @{
        ViewBag.Title = "Delete Payment";
        Layout = "~/Views/Shared/_Arrangement.cshtml";
    }
    
    <h2 class="common-font maroon bold bottom-line">Deleting Bill Payment</h2>
    
    <h3 class="maroon common-font">Are you sure you want to cancel this bill payment?</h3>
    
    <div>
        <dl class="dl-horizontal common-font">
            <dt>@Html.DisplayNameFor(model => model.PaymentID)</dt>
            <dd>@Html.DisplayFor(model => model.PaymentID)</dd>
    
            <dt>@Html.DisplayNameFor(model => model.PaymentDate)</dt>
            <dd>@ViewData["PaymentDate"]</dd>
    
            <dt>@Html.DisplayNameFor(model => model.PaymentAmount)</dt>
            <dd>@Html.DisplayFor(model => model.PaymentAmount)</dd>
    
            <dt>@Html.DisplayNameFor(model => model.PaymentStatus)</dt>
            <dd>@Html.DisplayFor(model => model.PaymentStatus)</dd>
    
            <dt>@Html.DisplayNameFor(model => model.GasBill.GasBillID)</dt>
            <dd>@Html.DisplayFor(model => model.GasBill.Identification)</dd>
        </dl>
    
        @using (Html.BeginForm()) {
            @Html.AntiForgeryToken()
    
            <div class="form-actions no-color">
                <input type="submit" value="Cancel this Bill Payment" class="btn btn-warning" /> |
                @Html.ActionLink("Bills Payments", "Index")
            </div>
        }
    </div>
  96. In the Solution Explorer, under Views and under Payments, double-click Details.cshtml
  97. Change the document as follows:
    @model GasUtilityCompany1.Models.Payment
    
    @{
        ViewBag.Title = "Details Payment";
        Layout = "~/Views/Shared/_Arrangement.cshtml";
    }
    
    <h2 class="maroon common-font bold bottom-line">Bill Payment Details</h2>
    
    <div class="common-font">
        <dl class="dl-horizontal">
            <dt>@Html.DisplayNameFor(model => model.PaymentID)</dt>
            <dd>@Html.DisplayFor(model => model.PaymentID)</dd>
    
            <dt>@Html.DisplayNameFor(model => model.PaymentDate)</dt>
            <dd>@ViewData["PaymentDate"]</dd>
    
            <dt>@Html.DisplayNameFor(model => model.PaymentAmount)</dt>
            <dd>@Html.DisplayFor(model => model.PaymentAmount)</dd>
    
            <dt>@Html.DisplayNameFor(model => model.PaymentStatus)</dt>
            <dd>@Html.DisplayFor(model => model.PaymentStatus)</dd>
            
            <dt>@Html.DisplayNameFor(model => model.GasBill.GasBillID)</dt>
            <dd>@Html.DisplayFor(model => model.GasBill.Identification)</dd>
        </dl>
    </div>
    
    <p>
        @Html.ActionLink("Edit this Bill Payment", "Edit", new { id = Model.PaymentID }) |
        @Html.ActionLink("Bills Payments", "Index")
    </p>
  98. In the Solution Explorer, under Views and under Payments, double-click Edit.cshtml
  99. Change the document as follows:
    @model GasUtilityCompany1.Models.Payment
    
    @{
        ViewBag.Title = "Edit Payment";
        Layout = "~/Views/Shared/_Arrangement.cshtml";
    }
    
    <h2 class="maroon bold bottom-line common-font">Edit/Update Bill Payment</h2>
    
    @using (Html.BeginForm())
    {
        @Html.AntiForgeryToken()
        
        <div class="form-horizontal common-font">
            @Html.ValidationSummary(true, "", new { @class = "text-danger" })
            @Html.HiddenFor(model => model.PaymentID)
    
            <div class="form-group">
                @Html.LabelFor(model => model.PaymentDate, htmlAttributes: new { @class = "control-label col-md-2" })
                <div class="col-md-10">
                    @Html.EditorFor(model => model.PaymentDate, new { htmlAttributes = new { @class = "form-control" } })
                    @Html.ValidationMessageFor(model => model.PaymentDate, "", new { @class = "text-danger" })
                </div>
            </div>
    
            <div class="form-group">
                <label for="billID" class="control-label col-md-2 deep-brown">Gas Bill</label>
                <div class="col-md-10">
                    @Html.DropDownList("GasBillID", null, htmlAttributes: new { @class = "form-control" })
                    @Html.ValidationMessageFor(model => model.GasBillID, "", new { @class = "text-danger" })
                </div>
            </div>
    
            <div class="form-group">
                @Html.LabelFor(model => model.PaymentAmount, htmlAttributes: new { @class = "control-label col-md-2" })
                <div class="col-md-10">
                    @Html.EditorFor(model => model.PaymentAmount, new { htmlAttributes = new { @class = "form-control" } })
                    @Html.ValidationMessageFor(model => model.PaymentAmount, "", new { @class = "text-danger" })
                </div>
            </div>
    
            <div class="form-group">
                @Html.LabelFor(model => model.PaymentStatus, htmlAttributes: new { @class = "control-label col-md-2" })
                <div class="col-md-10">
                    @Html.DropDownList("PaymentStatus", ViewData["PaymentStatus"] as SelectList,
                                      htmlAttributes: new { @class = "form-control" })
                    @Html.ValidationMessageFor(model => model.PaymentStatus, "", new { @class = "text-danger" })
                </div>
            </div>
    
            <div class="form-group">              
                <label class="control-label col-md-2">
                    @Html.ActionLink("Bills Payments", "Index")
                </label>
                <div class="col-md-10">
                    <input type="submit" value="Update this Payment" class="btn btn-warning" />
                </div>
            </div>
        </div>
    }
  100. In the Solution Explorer, under Views, expand Shared
  101. 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>Gas Utility Company :: @ViewBag.Title</title>
        @Styles.Render("~/Content/css")
        @Scripts.Render("~/bundles/modernizr")
    </head>
    <body>
        <header id="top-banner">
            <p class="text-center"><img src="~/Images/guc.png" alt="Gas Utility Company" width="649" height="74" /></p>
        </header>
    
        <div class="navbar navbar-inverse navbar-fixed-top">
            <div class="centralizer">
                <div class="container">
                    <div class="navbar-header">
                        <button type="button" class="navbar-toggle" data-toggle="collapse" data-target=".navbar-collapse">
                            <span class="icon-bar"></span>
                            <span class="icon-bar"></span>
                            <span class="icon-bar"></span>
                        </button>
                    </div>
                    <div class="navbar-collapse collapse">
                        <ul class="nav navbar-nav">
                            <li>@Html.ActionLink("GUC Home", "Index", "Home")</li>
                            <li>@Html.ActionLink("Gas Meters", "Index", "GasMeters")</li>
                            <li>@Html.ActionLink("Customers", "Index", "Customers")</li>
                            <li>@Html.ActionLink("Gas Bills", "Index", "GasBills")</li>
                            <li>@Html.ActionLink("Payments", "Index", "Payments")</li>
                            <li>@Html.ActionLink("Community", "Index", "Home")</li>
                            <li>@Html.ActionLink("Careers", "Index", "Home")</li>
                            <li>@Html.ActionLink("About GUC", "About", "Home")</li>
                            <li>@Html.ActionLink("Contact Us", "Contact", "Home")</li>
                        </ul>
                    </div>
                </div>
            </div>
        </div>
    
        <div class="body-holder">
            <div class="col-md-3">
                <div class="topic">@Html.ActionLink("Safety", "Index", "Home")</div>
                <div class="topic">@Html.ActionLink("Outages", "Index", "Home")</div>
                <div class="topic">@Html.ActionLink("Commercial", "Index", "Home")</div>
                <div class="topic">@Html.ActionLink("Residential", "Index", "Home")</div>
                <div class="topic">@Html.ActionLink("Environment", "Index", "Home")</div>
                <div class="topic">@Html.ActionLink("Services/Appliances", "Index", "Home")</div>
                <div class="topic">@Html.ActionLink("Community Relations", "Index", "Home")</div>
            </div>
            <div class="col-md-9">
                @RenderBody()
            </div>
        </div>
    
        <hr />
    
        <footer id="bottom-banner">
            <p id="copyright">&copy; @DateTime.Now.Year - Gas Utility Company</p>
        </footer>
    
        @Scripts.Render("~/bundles/jquery")
        @Scripts.Render("~/bundles/bootstrap")
        @RenderSection("scripts", required: false)
    </body>
    </html>
  102. To execute the application and test record creation, on the main menu, click Debug -> Start Without Debugging

    Entity Framework

  103. Click the Gas Meters Link:

    Entity Framework - Gas Meters

  104. Click the Create New Gas Meter link:

    Entity Framework - New Gas Meters

    Entity Framework - New Gas Meters

  105. Create some records as follows:
    Meter # Make Model Meter Reading Date Counter Value
    582741-38 Sinton International D-244 5/22/2017 138
    293847-27 Archimeda LP2066 8/31/2017 2866
    928731-59 EnvioSmart 84-D9703 12/16/2016 8016
    797047-27 Archimeda LP2066 10/6/2015 725
    425837-14 EnvioSmart 28-G4428 1/8/2018 6114
    864085-92 Sinton International D-244 10/15/2014 83

    Introduction to Maintenance of Data Sets

  106. Click the Customers link

    Entity Framework - Gas Meters

  107. Click the New Customer's Account link
  108. Create a few records as follows:

    Entity Framework - Gas Meters

    Entity Framework - Gas Meters

    tr>
    Account # Meter # First Name Last Name Address City County State ZIP-Code
    60-9720-824 293847-27 Jefferey Parriot 688 Gorman Str Rockville Montgomery MD 20856
    82-1397-851 425837-14 Christopher McGee 3316 Sanderson Rd Alexandria   VA 22312
    82-9360-597 582741-38 Sandra Rhodes 11158 Grattos Ave Hyattsville Prince George MD 20783
    29-5384-805 928731-59 Marco Ramos 9012 Jefferson Crt Washington   DC 20012
    92-3848-393 797047-27 Gabrielle Bayley 799 Boomerang Str Columbia Howard MD 21042

    Entity Framework

  109. Click the Gas Bills link

    Passing an Array By Reference

  110. Click the New Gas Bill link

    Entity Framework - New Gas Meters

  111. In the text boxes, enther the following values:
    Customer Account #:     60-9720-824
    Meter Reading End Date: 02/20/2018
    Counter Reading End:    3024
    Entity Framework - New Customer Gas Bill
  112. Click Prepare Gas Bill
  113. Click Save Gas Bill
  114. Create other gas bills with the following values:

    Customer Account # Meter Reading End Date Counter Reading End
    82-9360-597 2/22/2018 165
    92-3848-393 2/25/2018 997
    29-5384-805 2/28/2018 8418
    60-9720-824 3/15/2018 3195
    82-1397-851 3/22/2018 6156
    92-3848-393 3/24/2018 1229
    29-5384-805 3/31/2018 8808
    82-1397-851 4/19/2018 6288
    60-9720-824 4/20/2018 3407
    82-1397-851 5/21/2018 6338

    Passing an Array By Reference

  115. Click the Payments link

    Passing an Array By Reference

  116. Click the Make Bill Payment link

    Entity Framework - New Gas Meters

  117. Create a few records as follows:

    Entity Framework - New Gas Meters

    Gas Bill # Payment Date Payment Amount Payment Status
    1 3/5/2018 112.15 On Time
    3 3/6/2018 186.63 On Time
    2 3/30/2018 28.35 Late Payment
    6 4/1/2018 29.96 On Time
    4 4/2/2018 307.83 Late Payment
    5 4/5/2018 120.40 On Time
    8 4/15/2018 290.84 On Time
    7 4/30/2018 60.54 Late Payment

    Passing an Array By Reference

  118. Close the browser and return to your programming environment
  119. Close your programming environment

Previous Copyright © 2001-2018, FunctionX Next