MVC Tutorials
· Models: Model objects are the parts of the application that implement the domain logic. Often, model objects also retrieve and store model state in a database.
· Views: Views are the components that display the application's user interface (UI). Typically, this UI is created from the model data. An example would be the edit view of Albums that displays text boxes and a drop-down list based on the current state of an Album object.
· Controllers: Controllers are the components that handle user interaction, manipulate the model, and ultimately select a view to render the UI. In an MVC application, the view only displays information; the controller handles and responds to user input and interaction.
Start page setting in _ViewStart.cshtml in Views folder
@{
// Set the layout page for the whole site
Layout = "~/Shared/Layout.cshtml";
}
Eg:- @{
Layout = "~/Views/Shared/Index.cshtml";
}
1. Main Folders
· Controllers- for storing controllers
· Models-for storing models
· Views-for storing views
· App_Data - for storing databases and data files
· Content/Images - for storing images
· Scripts - for storing browser scripts
· Views/Shared - for storing shared style and layout files
2. Database Connection and management in Models
Creating the Model
On the Models folder, right click and create a new class by clicking on Add -> Class.
Example:-
using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Data;
using System.Data.SqlClient;
using System.Configuration;
using System.ComponentModel.DataAnnotations;
using connectionClass;
namespace CabAutomationSystem.Models
{
public class Country
{
connectionClass.connectionClass cs = new connectionClass.connectionClass();
public string conStr = ConfigurationManager.ConnectionStrings["SLMFConnection"].ToString();
SqlConnection cn = new SqlConnection(ConfigurationManager.ConnectionStrings["SLMFConnection"].ToString());
public int id { get; set; }
[Required(ErrorMessage = "Country is required")]
[Display(Name = "Country:")]
public string country { get; set; }
public DataSet GetAllCountry()
{
SqlCommand cmd = new SqlCommand("select id,cntry from cntry order by id", cn);
DataSet ds = new DataSet();
SqlDataAdapter da = new SqlDataAdapter(cmd);
da.Fill(ds);
return ds;
}
public int Insert(string country)
{
Int64 id = cs.GenerateId("cntry", "id", conStr);
SqlCommand cmd = new SqlCommand("insert into cntry(id,cntry) values('" + id + "','" + country + "')", cn);
cn.Open();
return cmd.ExecuteNonQuery();
}
public int Update(string country, int id)
{
SqlCommand cmd = new SqlCommand("Update cntry Set cntry='" + country + "' Where id=" + id, cn);
cn.Open();
return cmd.ExecuteNonQuery();
}
public int Delete(int id)
{
SqlCommand cmd = new SqlCommand("Delete From cntry Where id=" + id, cn);
cn.Open();
return cmd.ExecuteNonQuery();
}
}
}
3. User interaction management and model manipulation in Controllers
Creating our Controller
Right click on the Controllers folder and select Add -> Controller.
Example:-
using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.Mvc;
using CabAutomationSystem.Models;
using CabAutomationSystem.DatabaseContext;
using System.Data;
using System.Data.SqlClient;
using System.Configuration;
using System.ComponentModel.DataAnnotations;
using connectionClass;
namespace CabAutomationSystem.Controllers
{
public class AdminController : Controller
{
connectionClass.connectionClass cs = new connectionClass.connectionClass();
public string conStr = ConfigurationManager.ConnectionStrings["SLMFConnection"].ToString();
SqlConnection cn = new SqlConnection(ConfigurationManager.ConnectionStrings["SLMFConnection"].ToString());
#region ManageCountry
public ActionResult ManageCountry(CabAutomationSystem.Models.Country CountryList)
{
DataSet ds = CountryList.GetAllCountry();
ViewBag.AuthorList = ds.Tables[0];
return View();
}
[HttpGet]
public ActionResult AddCountry()
{
return View();
}
[HttpPost]
public ActionResult AddCountry(CabAutomationSystem.Models.Country countryinsert)
{
if (ModelState.IsValid)
{
int _records = countryinsert.Insert(countryinsert.country);
if (_records > 0)
{
return RedirectToAction("ManageCountry", "Admin");
}
else
{
ModelState.AddModelError("", "Can Not Insert");
}
}
return View(countryinsert);
}
[HttpGet]
public ActionResult EditCountry(int id, CabAutomationSystem.Models.Country countryupdate)
{
SqlCommand cmd = new SqlCommand("select id,cntry from cntry where id=" + id, cn);
cn.Open();
SqlDataReader dr = cmd.ExecuteReader();
if (dr.Read())
{
countryupdate.id = Convert.ToInt32(dr["id"].ToString());
countryupdate.country = dr["cntry"].ToString();
}
else
{
dr.Close();
}
dr.Close();
cn.Close();
return View(countryupdate);
}
[HttpPost]
public ActionResult EditCountry(CabAutomationSystem.Models.Country countryupdate, FormCollection form, int id)
{
if (ModelState.IsValid)
{
int _records = countryupdate.Update(countryupdate.country, id);
if (_records > 0)
{
return RedirectToAction("ManageCountry", "Admin");
}
else
{
ModelState.AddModelError("", "Can Not Update");
}
}
return View(countryupdate);
}
public ActionResult DeleteCountry(int id, CabAutomationSystem.Models.Country countrydelete)
{
int records = countrydelete.Delete(id);
if (records > 0)
{
return RedirectToAction("ManageCountry", "Admin");
}
else
{
ModelState.AddModelError("", "Can Not Delete");
return View("ManageCountry");
}
// return View("Index");
}
#endregion ManageCountry
}
}
4. User Interface Management in Views
Example:-
v Right click on “ManageCountry” in Controller and create view “ManageCountry.cshtml”
@model CabAutomationSystem.Models.Country
@{
ViewBag.Title = "ManageCountry";
Layout = "~/Views/Admin/Master.cshtml";
}
<h2>ManageCountry</h2>
<div>
@Html.ActionLink("Add Country", "AddCountry")
<br />
<table border="1" style="border-color:LightSkyBlue;border-bottom-style:double">
<tr>
<td></td>
<td></td>
<td style="background-color: #800080; color: #FFFFFF; font-family: 'Times New Roman', Times, serif;
font-size: large; border-style: inset; border-width: thin">Country</td>
</tr>
@foreach (System.Data.DataRow dr in ViewBag.AuthorList.Rows)
{
<tr>
<td>
@Html.ActionLink("Edit", "EditCountry", new { id = dr["id"].ToString() })
</td>
<td>
@Html.ActionLink("Delete", "DeleteCountry", new { id = dr["id"].ToString() })
</td>
<td>
@dr["cntry"].ToString()
</td>
</tr>
}
</table>
</div>
v Right click on “AddCountry” in Controller and create view “AddCountry.cshtml”
@model CabAutomationSystem.Models.Country
@{
ViewBag.Title = "AddCountry";
Layout = "~/Views/Admin/Master.cshtml";
}
<body>
<h1>Add New Country</h1>
@using (Html.BeginForm()) {
@Html.ValidationSummary(true, "Insertion was unsuccessful. Please correct the errors and try again.")
<div>
<fieldset>
<legend>Country Information</legend>
<div class="editor-label">
@Html.LabelFor(m => m.country)
</div>
<div class="editor-field">
@Html.TextBoxFor(m => m.country)
@Html.ValidationMessageFor(m => m.country)
</div>
<p>
<input type="submit" value="Insert" />
</p>
</fieldset>
</div>
}
</body>
v Right click on “EditCountry” in Controller and create view “EditCountry.cshtml”
@model CabAutomationSystem.Models.Country
@{
ViewBag.Title = "EditCountry";
Layout = "~/Views/Admin/Master.cshtml";
}
<body>
<h1>Edit Country</h1>
@using (Html.BeginForm()) {
@Html.ValidationSummary(true, "Insertion was unsuccessful. Please correct the errors and try again.")
<div>
<fieldset>
<legend>Country Information</legend>
<div class="editor-label">
@Html.LabelFor(m => m.country)
</div>
<div class="editor-field">
@Html.TextBoxFor(m => m.country)
@Html.ValidationMessageFor(m => m.country)
</div>
<p>
<input type="submit" value="Update" />
</p>
</fieldset>
</div>
}
</body>
5. Master.cshtml in Views
<!DOCTYPE html>
<html>
<head>
<title></title>
<link href="@Url.Content("~/Content/admin_style.css")" rel="stylesheet" type="text/css" />
<link href="@Url.Content("~/Content/Mystyle.css")" rel="stylesheet" type="text/css" />
<script src="@Url.Content("~/Scripts/jquery-1.4.4.min.js")" type="text/javascript"></script>
</head>
<body>
<div class="top">
<div class=""></div>
<div class="contact">
<p>
</p>
</div>
</div>
<input id="hdndranch" runat="server" type="hidden" />
<div>
<div>
<div id="ConetntAreaContainer" class="clear">
<table style="width: 100%" width="100%">
<tr>
<td style="width: 20%" valign="top">
<table cellpadding="6" cellspacing="3" width="100%" style="background-color: #996633">
<tr>
<td style="width: 8px">
</td>
<td height="10">
</td>
</tr>
<tr >
<td style="width: 8px">
<img src="../../Content/images/arrow_doublebl.jpg" /></td>
<td>
@*@Html.ActionLink("Home", "Home", "Admin", new { @class = "ad_link" })*@
@Html.ActionLink("Home", "Home", "Admin")
</td>
</tr>
<tr id="tr3" runat="server">
<td style="width: 8px">
<img src="../../Content/images/arrow_doublebl.jpg" /></td>
<td>
@Html.ActionLink("ManageCountry", "ManageCountry", "Admin")
</td>
</tr>
<tr id="tr49" runat="server">
<td style="width: 8px">
<img src="../../Content/images/arrow_doublebl.jpg" /></td>
<td>
@Html.ActionLink("Logout", "Logout", "Admin", new { @class = "ad_link" })
</td>
</tr>
</table>
</td>
<td style="width: 80%" valign="top">
<div id="ContentContainer" style="width:75%">
<div id="Welcomecontent">
<p>
<br />
@RenderBody()
<br />
</p>
</div>
</div>
</td>
</tr>
</table>
<div style="clear:both"></div>
</div>
<div id="FooterConatiner" style="height:25px"></div>
</div>
</div>
</body>
</html>
