Database code
create database mvc
create table tbl_products
(
id int primary key identity(1,1),
product_name varchar(100),
quantity int
)
insert into tbl_products values ('rice',100)
create procedure get_products
as begin
select * from tbl_products
end
go
create procedure insert_products
(
@product_name varchar(100),
@quantity int
)
as begin
insert into tbl_products values
(@product_name,@quantity)
end
insert_products 'dhall',50
edit_products 1,'salt',50
create procedure edit_products
(
@id int,
@product_name varchar(100),
@quantity int
)
as begin
update tbl_products set product_name=@product_name
, quantity=@quantity where id =@id
end
create procedure delete_products
(
@id int
)
as begin
delete from tbl_products where id =@id
end
go
create procedure get_products_id
(@id int
)
as begin
select * from tbl_products where id=@id
endModel Code
using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
namespace ArunDepartmentalStore.Models
{
public class tbl_products
{
public int id { get; set; }
public string product_name { get; set; }
public int quantity { get; set; }
}
}Controller Code
using ArunDepartmentalStore.Models;
using System;
using System.Collections.Generic;
using System.Data.SqlClient;
using System.Linq;
using System.Web;
using System.Web.Mvc;
namespace ArunDepartmentalStore.Controllers
{
public class tbl_productsController : Controller
{
string constr = "Data Source=.\\sqlexpress;Initial Catalog=mvc;Integrated Security =true";
// GET: tbl_products
public ActionResult Index()
{
List<tbl_products> tbl_products_obj = new List<tbl_products>();
SqlConnection con = new SqlConnection(constr);
SqlCommand cmd = new SqlCommand("get_products", con);
cmd.CommandType = System.Data.CommandType.StoredProcedure;
con.Open();
SqlDataReader sdr = cmd.ExecuteReader();
while(sdr.Read())
{
tbl_products_obj.Add(new tbl_products
{
id = Convert.ToInt32( sdr["id"]),
product_name = Convert.ToString(sdr["product_name"]),
quantity = Convert.ToInt32(sdr["quantity"])
}
);
}
con.Close();
return View(tbl_products_obj);
}
// GET: tbl_products/Details/5
public ActionResult Details(int id,tbl_products tbl_products_obj)
{
SqlConnection con = new SqlConnection(constr);
string query = "get_products_id " + id;
SqlCommand cmd = new SqlCommand(query, con);
con.Open();
SqlDataReader sdr = cmd.ExecuteReader();
while (sdr.Read())
{
tbl_products_obj = new tbl_products
{
id = Convert.ToInt32(sdr["id"]),
product_name = Convert.ToString(sdr["product_name"]),
quantity = Convert.ToInt32(sdr["quantity"])
};
}
con.Close();
return View(tbl_products_obj);
}
// GET: tbl_products/Create
public ActionResult Create()
{
return View();
}
// POST: tbl_products/Create
[HttpPost]
public ActionResult Create(tbl_products tbl_productobj)
{
try
{
SqlConnection con = new SqlConnection(constr);
string query = "insert_products '" + tbl_productobj.product_name + "'," + tbl_productobj.quantity;
SqlCommand cmd = new SqlCommand(query, con);
con.Open();
int i = cmd.ExecuteNonQuery();
con.Close();
return RedirectToAction("Index");
}
catch
{
return View();
}
}
// GET: tbl_products/Edit/5
public ActionResult Edit(int id)
{
return View();
}
// POST: tbl_products/Edit/5
[HttpPost]
public ActionResult Edit(int id, tbl_products tbl_productobj)
{
try
{
SqlConnection con = new SqlConnection(constr);
string query = "edit_products " + id +",'" + tbl_productobj.product_name + "'," + tbl_productobj.quantity;
SqlCommand cmd = new SqlCommand(query, con);
con.Open();
int i = cmd.ExecuteNonQuery();
con.Close();
return RedirectToAction("Index");
}
catch
{
return View();
}
}
// GET: tbl_products/Delete/5
public ActionResult Delete(int id,tbl_products tbl_products_obj)
{
SqlConnection con = new SqlConnection(constr);
string query = "get_products_id " + id;
SqlCommand cmd = new SqlCommand(query, con);
con.Open();
SqlDataReader sdr = cmd.ExecuteReader();
while (sdr.Read())
{
tbl_products_obj = new tbl_products
{
id = Convert.ToInt32(sdr["id"]),
product_name = Convert.ToString(sdr["product_name"]),
quantity = Convert.ToInt32(sdr["quantity"])
} ;
}
con.Close();
return View(tbl_products_obj);
}
// POST: tbl_products/Delete/5
[HttpPost]
public ActionResult Delete(int id)
{
try
{
SqlConnection con = new SqlConnection(constr);
string query = "delete_products " + id ;
SqlCommand cmd = new SqlCommand(query, con);
con.Open();
int i = cmd.ExecuteNonQuery();
con.Close();
return RedirectToAction("Index");
}
catch
{
return View();
}
}
}
}View Code
Index.cshtml
Index.cshtml
@model IEnumerable<ArunDepartmentalStore.Models.tbl_products>
@{
ViewBag.Title = "Index";
}
<h2>Index</h2>
<p>
@Html.ActionLink("Create New", "Create")
</p>
<table class="table">
<tr>
<th>
@Html.DisplayNameFor(model => model.product_name)
</th>
<th>
@Html.DisplayNameFor(model => model.quantity)
</th>
<th></th>
</tr>
@foreach (var item in Model) {
<tr>
<td>
@Html.DisplayFor(modelItem => item.product_name)
</td>
<td>
@Html.DisplayFor(modelItem => item.quantity)
</td>
<td>
@Html.ActionLink("Edit", "Edit", new { id=item.id }) |
@Html.ActionLink("Details", "Details", new { id=item.id }) |
@Html.ActionLink("Delete", "Delete", new { id=item.id })
</td>
</tr>
}
</table>create.cshtml
create.cshtml
@model ArunDepartmentalStore.Models.tbl_products
@{
ViewBag.Title = "Create";
}
<h2>Create</h2>
@using (Html.BeginForm())
{
@Html.AntiForgeryToken()
<div class="form-horizontal">
<h4>tbl_products</h4>
<hr />
@Html.ValidationSummary(true, "", new { @class = "text-danger" })
<div class="form-group">
@Html.LabelFor(model => model.product_name, htmlAttributes: new { @class = "control-label col-md-2" })
<div class="col-md-10">
@Html.EditorFor(model => model.product_name, new { htmlAttributes = new { @class = "form-control" } })
@Html.ValidationMessageFor(model => model.product_name, "", new { @class = "text-danger" })
</div>
</div>
<div class="form-group">
@Html.LabelFor(model => model.quantity, htmlAttributes: new { @class = "control-label col-md-2" })
<div class="col-md-10">
@Html.EditorFor(model => model.quantity, new { htmlAttributes = new { @class = "form-control" } })
@Html.ValidationMessageFor(model => model.quantity, "", new { @class = "text-danger" })
</div>
</div>
<div class="form-group">
<div class="col-md-offset-2 col-md-10">
<input type="submit" value="Create" class="btn btn-default" />
</div>
</div>
</div>
}
<div>
@Html.ActionLink("Back to List", "Index")
</div>
@section Scripts {
@Scripts.Render("~/bundles/jqueryval")
}edit.cshtml
edit.cshtml
@model ArunDepartmentalStore.Models.tbl_products
@{
ViewBag.Title = "Edit";
}
<h2>Edit</h2>
@using (Html.BeginForm())
{
@Html.AntiForgeryToken()
<div class="form-horizontal">
<h4>tbl_products</h4>
<hr />
@Html.ValidationSummary(true, "", new { @class = "text-danger" })
@Html.HiddenFor(model => model.id)
<div class="form-group">
@Html.LabelFor(model => model.product_name, htmlAttributes: new { @class = "control-label col-md-2" })
<div class="col-md-10">
@Html.EditorFor(model => model.product_name, new { htmlAttributes = new { @class = "form-control" } })
@Html.ValidationMessageFor(model => model.product_name, "", new { @class = "text-danger" })
</div>
</div>
<div class="form-group">
@Html.LabelFor(model => model.quantity, htmlAttributes: new { @class = "control-label col-md-2" })
<div class="col-md-10">
@Html.EditorFor(model => model.quantity, new { htmlAttributes = new { @class = "form-control" } })
@Html.ValidationMessageFor(model => model.quantity, "", new { @class = "text-danger" })
</div>
</div>
<div class="form-group">
<div class="col-md-offset-2 col-md-10">
<input type="submit" value="Save" class="btn btn-default" />
</div>
</div>
</div>
}
<div>
@Html.ActionLink("Back to List", "Index")
</div>
@section Scripts {
@Scripts.Render("~/bundles/jqueryval")
}Details.cshtml
Details.cshtml
@model ArunDepartmentalStore.Models.tbl_products
@{
ViewBag.Title = "Details";
}
<h2>Details</h2>
<div>
<h4>tbl_products</h4>
<hr />
<dl class="dl-horizontal">
<dt>
@Html.DisplayNameFor(model => model.product_name)
</dt>
<dd>
@Html.DisplayFor(model => model.product_name)
</dd>
<dt>
@Html.DisplayNameFor(model => model.quantity)
</dt>
<dd>
@Html.DisplayFor(model => model.quantity)
</dd>
</dl>
</div>
<p>
@Html.ActionLink("Edit", "Edit", new { id = Model.id }) |
@Html.ActionLink("Back to List", "Index")
</p>Delete.cshtml
Delete.cshtml
@model ArunDepartmentalStore.Models.tbl_products
@{
ViewBag.Title = "Delete";
}
<h2>Delete</h2>
<h3>Are you sure you want to delete this?</h3>
<div>
<h4>tbl_products</h4>
<hr />
<dl class="dl-horizontal">
<dt>
@Html.DisplayNameFor(model => model.product_name)
</dt>
<dd>
@Html.DisplayFor(model => model.product_name)
</dd>
<dt>
@Html.DisplayNameFor(model => model.quantity)
</dt>
<dd>
@Html.DisplayFor(model => model.quantity)
</dd>
</dl>
@using (Html.BeginForm()) {
@Html.AntiForgeryToken()
<div class="form-actions no-color">
<input type="submit" value="Delete" class="btn btn-default" /> |
@Html.ActionLink("Back to List", "Index")
</div>
}
</div>