MVC Code

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

@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

@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

@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

@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

@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:

Tagged in:

Database code

Model Code

Controller Code

View Code

Index.cshtml

create.cshtml

edit.cshtml

Details.cshtml

Delete.cshtml

Leave a Reply

Other Stories

Project Details for DOTNET / JAVA / PYTHON /PHP

What is a marquee tag ?

What is the output of the following pseudo code ? Int a = 456, b, c, d = 10; b = a/d; c = a-b; print c ?

A mother her little daughter and her just born infant boy together stood on a weighing machine which shows 74kgs. How much does the daughter weight if the mother weights 46kg more than the combined weight of daughter and the infant and the infant weights 60% less than the daughter ?

16, 24, 48, 120, 360, 1260, ?

A number is divided by 5, 3, 2 successively in order to get remainders of 0, 2, 1 respectively. What will be the remainder when the same number is divided by 2, 3, 5 respectively ?

Project Details for DOTNET / JAVA /PHP

UI/UX Design Projects

Project Details for Python

Cyber Security Projects

Project Details for Java

Ads Blocker Detected!!!

Press ESC to close

Or check our Popular Categories...

Database code

Model Code

Controller Code

View Code

Index.cshtml

create.cshtml

edit.cshtml

Details.cshtml

Delete.cshtml

Leave a Reply

Related Articles

Other Stories

Project Details for DOTNET / JAVA / PYTHON /PHP

What is a marquee tag ?

Ads Blocker Detected!!!