dotnet tutorials Studio: 2016

ASP.NET MVC scaffolding provides a quick way to generate the CRUD operations in a standardized way, creating the necessary logic that lets your application interact with the database layer. in this post, explained with example for how to use scaffolding.

Create new employee table with existing/new sql database

We created new table Emplyoyee in sql DB and this table will be used for Scaffolding.

Create New Project

created the project with name MvcScaffolding with basic template

Create the edmx file

Step 1

Step 2

Step 3

Step 4

Step 5

Step 6

This edmx created and included newly created employee table also.we will use this edmx for scaffolding

Create the controller

created the new controller with name Employee and used the template read/write actions,views using entity framework

After Created the controller using scaffolding

Index.cshtml file

Code Snippet

@model IEnumerable<MvcScaffolding.Employee>
 
@{
    ViewBag.Title = "Index";
}
 
<h2>Index</h2>
 
<p>
    @Html.ActionLink("Create New", "Create")
</p>
<table>
    <tr>
        <th>
            @Html.DisplayNameFor(model => model.EmpId)
        </th>
        <th>
            @Html.DisplayNameFor(model => model.EmployeeName)
        </th>
        <th>
            @Html.DisplayNameFor(model => model.Position)
        </th>
        <th>
            @Html.DisplayNameFor(model => model.CityID)
        </th>
        <th></th>
    </tr>
 
@foreach (var item in Model) {
    <tr>
        <td>
            @Html.DisplayFor(modelItem => item.EmpId)
        </td>
        <td>
            @Html.DisplayFor(modelItem => item.EmployeeName)
        </td>
        <td>
            @Html.DisplayFor(modelItem => item.Position)
        </td>
        <td>
            @Html.DisplayFor(modelItem => item.CityID)
        </td>
        <td>
            @Html.ActionLink("Edit", "Edit", new {  id=item.EmpId  }) |
            @Html.ActionLink("Details", "Details", new {id=item.EmpId }) |
            @Html.ActionLink("Delete", "Delete", new { id=item.EmpId })
        </td>
    </tr>
}
 
</table>

Details.cshtml file

Code Snippet

@model MvcScaffolding.Employee
 
@{
    ViewBag.Title = "Details";
}
 
<h2>Details</h2>
 
<fieldset>
    <legend>Employee</legend>
 
    <div class="display-label">
         @Html.DisplayNameFor(model => model.EmpId)
    </div>
    <div class="display-field">
        @Html.DisplayFor(model => model.EmpId)
    </div>
 
    <div class="display-label">
         @Html.DisplayNameFor(model => model.EmployeeName)
    </div>
    <div class="display-field">
        @Html.DisplayFor(model => model.EmployeeName)
    </div>
 
    <div class="display-label">
         @Html.DisplayNameFor(model => model.Position)
    </div>
    <div class="display-field">
        @Html.DisplayFor(model => model.Position)
    </div>
 
    <div class="display-label">
         @Html.DisplayNameFor(model => model.CityID)
    </div>
    <div class="display-field">
        @Html.DisplayFor(model => model.CityID)
    </div>
</fieldset>
<p>
    @Html.ActionLink("Edit", "Edit", new { /* id=Model.PrimaryKey */ }) |
    @Html.ActionLink("Back to List", "Index")
</p>

Employee Controller

Code Snippet

using System;
using System.Collections.Generic;
using System.Data;
using System.Data.Entity;
using System.Linq;
using System.Web;
using System.Web.Mvc;
 
namespace MvcScaffolding.Controllers
{
    public class EmployeeController : Controller
    {
        private TestDBEntities db = new TestDBEntities();
 
        //
        // GET: /Employee/
 
        public ActionResult Index()
        {
            return View(db.Employees.ToList());
        }
 
        //
        // GET: /Employee/Details/5
 
        public ActionResult Details(int id = 0)
        {
            Employee employee = db.Employees.Find(id);
            if (employee == null)
            {
                return HttpNotFound();
            }
            return View(employee);
        }
 
        //
        // GET: /Employee/Create
 
        public ActionResult Create()
        {
            return View();
        }
 
        //
        // POST: /Employee/Create
 
        [HttpPost]
        public ActionResult Create(Employee employee)
        {
            if (ModelState.IsValid)
            {
                db.Employees.Add(employee);
                db.SaveChanges();
                return RedirectToAction("Index");
            }
 
            return View(employee);
        }
 
        //
        // GET: /Employee/Edit/5
 
        public ActionResult Edit(int id = 0)
        {
            Employee employee = db.Employees.Find(id);
            if (employee == null)
            {
                return HttpNotFound();
            }
            return View(employee);
        }
 
        //
        // POST: /Employee/Edit/5
 
        [HttpPost]
        public ActionResult Edit(Employee employee)
        {
            if (ModelState.IsValid)
            {
                db.Entry(employee).State = EntityState.Modified;
                db.SaveChanges();
                return RedirectToAction("Index");
            }
            return View(employee);
        }
 
        //
        // GET: /Employee/Delete/5
 
        public ActionResult Delete(int id = 0)
        {
            Employee employee = db.Employees.Find(id);
            if (employee == null)
            {
                return HttpNotFound();
            }
            return View(employee);
        }
 
        //
        // POST: /Employee/Delete/5
 
        [HttpPost, ActionName("Delete")]
        public ActionResult DeleteConfirmed(int id)
        {
            Employee employee = db.Employees.Find(id);
            db.Employees.Remove(employee);
            db.SaveChanges();
            return RedirectToAction("Index");
        }
 
        protected override void Dispose(bool disposing)
        {
            db.Dispose();
            base.Dispose(disposing);
        }
    }
}

Views (Create,Details,Edit,Index ,Delete) and controlller(Employee) codes are automatically cretaed for CRUD operations.

Run the project

Manage/Index

Create

Edit

Details

Delete

The CRUD operations are working fine after using scaffolding. by this way we can save time while develop the application.

ModelBinding is the mechanism ASP.NET MVC uses to create strongly-typed objects (or fill primitive-type parameters) from the input stream (usually an HTTP request). The Model-Binder is then responsible to fill that person parameter for you.

Model Binding allows you to map and bind the HTTP request data with a model. If you want to work with the form data, Model Binding makes it easier because the requested data is submitted automatically into a data model that we specify. The Default Binder is used to do this. i explained the modelbinding with example,

Create New Project

created the project with name MvcModelBinding with basic template

Create the controller

created the new controller with name User

Create a new view

created the new view with name Userinfo under views->User Folder

Create a new model

code

Code Snippet

using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
 
namespace MvcModelBinding.Models
{
    public class UserInfoModel     {
        public string Id { get; set; }
        public string Name { get; set; }
        public int Age { get; set; }
        public string City { get; set; }
        public string Country { get; set; }
 
    }
}

created the new model with name UserInfoModel under model folder.it is having Name,Age,City and Country properties.

Add input fields into view

Code Snippet

@{
    ViewBag.Title = "UserInfo";
}
<h2>UserInfo</h2>
    <div>
            @{Html.BeginForm("UserInfo", "User");
                <table>
                    <tr>
                        <td>First Name : </td>
                        <td>@Html.TextBox("fname")</td>
                    </tr>
                    <tr>
                        <td>Middle Name : </td>
                        <td>@Html.TextBox("midname")</td>
                    </tr>
                    <tr>
                        <td>lastName :</td>
                        <td> @Html.TextBox("lname")</td>
                    </tr>
                    <tr>
                        <td>Age:</td>
                        <td> @Html.TextBox("age") </td>
                    </tr>
 
                     <tr>
                        <td>Place:</td>
                        <td> @Html.TextBox("place") </td>
                    </tr>
                     <tr>
                        <td>Nationality:</td>
                        <td> @Html.TextBox("nationality") </td>
                    </tr>
                    <tr>
                        <td></td>
                        <td>
                            <input type="submit" name="Save" value="submit" />
                        </td>
                    </tr>
                </table>
            }
    </div>

created the textbox inputs for first name,middle name,last name,place,nationality and age in newly created view.

Create new UserModelBinding class for ModelBinding

Code Snippet

using MvcModelBinding.Models;
using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.Http.Controllers;
using System.Web.Http.ModelBinding;
using System.Web.Mvc;
 
namespace MvcModelBinding.Data
{
    public class UserModelBinding : System.Web.Mvc.IModelBinder
    {
        public object BindModel(ControllerContext controllerContext, System.Web.Mvc.ModelBindingContext bindingContext)
        {
            var request = controllerContext.HttpContext.Request;
            var UserInfo = new UserInfoModel();
            UserInfo.Name = string.Format("{0}{1}{2}", request.Form.Get("fname"), request.Form.Get("midname"), request.Form.Get("lname"));
            UserInfo.Country = request.Form.Get("nationality");
            UserInfo.City = request.Form.Get("place");
            UserInfo.Age = Convert.ToInt32(request.Form.Get("age"));
            return UserInfo;
        }        
    }
}

created the new UserModelBinding class for model binding the inputs such as first name,middle name,last name,place,nationality and age from view.

Create action methods

Code Snippet

 public ActionResult UserInfo()
        {
            return View();
        }
        
        [HttpPost]
        public ActionResult UserInfo([ModelBinder(typeof(UserModelBinding))] UserInfoModel data)
        {
            // do database operations or any
 
            return View();
        }

created two action methods for userinfo view and one defined as post with model binder used for convert the input values into UserInfoModel.

Modify the default action method

Code Snippet

public static void RegisterRoutes(RouteCollection routes)
        {
            routes.IgnoreRoute("{resource}.axd/{*pathInfo}");
 
            routes.MapRoute(
                name: "Default",
                url: "{controller}/{action}/{id}",
                defaults: new { controller = "User", action = "UserInfo", id = UrlParameter.Optional }
            );
        }

modified the action and controller names for default in RouteConfig.cs file .

Run the project

just filled the informations for input fields

While debug the action method

The values are converted/assigned into UserInfoModel by ModelBinding

Application variable is available to all classes in an ASP.NET application. Application state is stored in memory on the server and is faster than storing and retrieving information in a database. Unlike session state, which is specific to a single user session, application state applies to all users and sessions.

Create application variable

Application["Message"] = "Welcome to the Contoso site.";

it shows how you can set the application variable Message to a string.

Application variable when the application starts

Application["Message"] = "Welcome to the site."; Application["PageRequestCount"] = 0;

it shows how you can set the application variable Message to a string and initialize the variable PageRequestCount to 0.

Application variable with locking

Application.Lock(); Application["PageRequestCount"] = ((int)Application["PageRequestCount"])+1; Application.UnLock();

it shows how you can lock and unlock application variable. The code increases the PageRequestCount variable by 1 and then unlocks application variable.

The MVC programming model is a lighter alternative to traditional ASP.NET (Web Forms). It is a lightweight, highly testable framework, integrated with all existing ASP.NET features, such as Master Pages, Security, and Authentication.

Create new Empty Project

in the above image, created new project with type of mvc 4.

Empty project template type with razor engine

Solution explorer with empty project template

we selected the empty project template while creating project so it is showing empty for controller section as well view section

Create new controller

Navigation for create

Controller name

After added

ViewBag used with controller

viewbag is used for transfer the values from controller to view. here, we used welcome for pass the welcome message.

Create new view

need create a folder

This folder name should be same as controller name.

Navigation for create

view name

After added

ViewBag used with view for display

This viewbag is passed from controller.

Update the default route

we need update the default controller and action names. because need update the newly created controller and action name.

In Browser

The datepicker is used to choose a date for input field.i just created sample page for jquery datepicker in aspx pages

Create a new project

This image shows the new project creation with name DatePicker

Create a new page

This image shows the new page creation with name DatePickerSamle

Add required files

We need add js (jquery-1.10.2.js,jquery-ui.js) and css(jquery-ui.css) files and these files are used for show datepicker.images folder added inside css folder

Call/Configure DatePicker Function

added textbox control txtdate and it is configured for datepicker.

DatePicker in Browser

DatePicker with previous/future dates only

In client side function

added textbox controls txtFutureDtae,txtPreviousDtae and it is configured for datepicker.

Previous days datepicker in Browser

Future days datepicker in Browser

DatePicker with sunday only

added textbox control txtSunday and it is configured for datepicker with allowed sunday only.

Sunday only datepicker in browser

A loop statement allows us to execute a statement or a group of statements multiple times and following is the general from of a loop statement in most of the programming languages.

The following loop types are available to handle looping requirements.

While loop
for loop
do while loop
Foreach loop

While loop

Description :

A while loop will check a condition and then continues to execute a block of code as long as the condition evaluates to a boolean value of true.

for loop

Description :

A for loop works like a while loop, except that the syntax of the for loop includes initialization and condition modification. for loops are appropriate when you know exactly how many times you want to perform the statements within the loop.

do while loop

Description :

A do loop is similar to the while loop, except that it checks its condition at the end of the loop. This means that the do loop is guaranteed to execute at least one time.

Foreach

Description :

A foreach loop is used to iterate through the items in a list. It operates on arrays or collections such as ArrayList, which can be found in the System.Collections namespace.

Create new employee table with existing/new sql database

Create New Project

Create the edmx file

Create the controller

After Created the controller using scaffolding

Run the project

Create New Project

Create the controller

Create a new view

Create a new model

Add input fields into view

Create new UserModelBinding class for ModelBinding

Create action methods

Modify the default action method

Run the project

While debug the action method

Create application variable

Application variable when the application starts

Application variable with locking

Create new Empty Project

Empty project template type with razor engine

Solution explorer with empty project template

Create new controller

Create new view

Update the default route

In Browser

Create a new project

Create a new page

Add required files

Call/Configure DatePicker Function

DatePicker in Browser

DatePicker with previous/future dates only

Previous days datepicker in Browser

Future days datepicker in Browser

DatePicker with sunday only

Sunday only datepicker in browser

While loop

for loop

do while loop

Foreach

About Me

Blog Archive

About

Popular Posts

Instagram

Facebook

Labels