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
end

Model 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>

Categorized in:

C#

Tagged in:

, , , , ,

Share Article:

Leave a Reply

Ads Blocker Image Powered by Code Help Pro

Ads Blocker Detected!!!

We have detected that you are using extensions to block ads. Please support us by disabling these ads blocker.

Powered By
Best Wordpress Adblock Detecting Plugin | CHP Adblock