{"id":5073,"date":"2022-12-27T02:49:22","date_gmt":"2022-12-27T02:49:22","guid":{"rendered":"https:\/\/www.wikitechy.com\/interview-questions\/?p=5073"},"modified":"2023-06-24T11:41:25","modified_gmt":"2023-06-24T11:41:25","slug":"mvc-code","status":"publish","type":"post","link":"https:\/\/www.wikitechy.com\/interview-questions\/csharp\/mvc-code\/","title":{"rendered":"MVC Code"},"content":{"rendered":"

Database code<\/h2>\n
<\/div> 
create database mvccreate 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_productsas beginselect * from tbl_productsendgocreate procedure insert_products(@product_name varchar(100),@quantity int)as begininsert into tbl_products values(@product_name,@quantity)endinsert_products 'dhall',50edit_products 1,'salt',50create procedure edit_products(@id int,@product_name varchar(100),@quantity int)as beginupdate tbl_products set product_name=@product_name, quantity=@quantity  where id =@idendcreate procedure delete_products(@id int)as begindelete from tbl_products where id =@idendgocreate procedure get_products_id(@id int)as beginselect * from tbl_products where id=@idend<\/code><\/pre> <\/div>\n
Model Code<\/h2>\n
 
 <\/div> 
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; }    }}<\/code><\/pre> <\/div>\n
Controller Code<\/h2>\n
 
 <\/div> 
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_obj = new List();            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();            }        }    }}<\/code><\/pre> <\/div>\n
View Code<\/h2>\n
Index.cshtml<\/h4>\n
 
 Index.cshtml<\/span> <\/div> 
@model IEnumerable@{    ViewBag.Title = "Index";}
Index<\/h2>
    @Html.ActionLink("Create New", "Create")<\/p>                    
            @Html.DisplayNameFor(model => model.product_name)        <\/th>                    @Html.DisplayNameFor(model => model.quantity)        <\/th>        <\/th>    <\/tr>@foreach (var item in Model) {    
            @Html.DisplayFor(modelItem => item.product_name)        <\/td>                    @Html.DisplayFor(modelItem => item.quantity)        <\/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><\/code><\/pre> <\/div>\n
create.cshtml<\/h4>\n
 
 create.cshtml<\/span> <\/div> 
@model ArunDepartmentalStore.Models.tbl_products@{    ViewBag.Title = "Create";}
Create<\/h2>@using (Html.BeginForm()) {    @Html.AntiForgeryToken()        
        
tbl_products<\/h4>        
        @Html.ValidationSummary(true, "", new { @class = "text-danger" })        
            @Html.LabelFor(model => model.product_name, htmlAttributes: new { @class = "control-label col-md-2" })            
                @Html.EditorFor(model => model.product_name, new { htmlAttributes = new { @class = "form-control" } })                @Html.ValidationMessageFor(model => model.product_name, "", new { @class = "text-danger" })            <\/div>        <\/div>        
            @Html.LabelFor(model => model.quantity, htmlAttributes: new { @class = "control-label col-md-2" })            
                @Html.EditorFor(model => model.quantity, new { htmlAttributes = new { @class = "form-control" } })                @Html.ValidationMessageFor(model => model.quantity, "", new { @class = "text-danger" })            <\/div>        <\/div>        
            
                            <\/div>        <\/div>    <\/div>}
    @Html.ActionLink("Back to List", "Index")<\/div>@section Scripts {    @Scripts.Render("~\/bundles\/jqueryval")}<\/code><\/pre> <\/div>\n
edit.cshtml<\/h4>\n
 
 edit.cshtml<\/span> <\/div> 
@model ArunDepartmentalStore.Models.tbl_products@{    ViewBag.Title = "Edit";}
Edit<\/h2>@using (Html.BeginForm()){    @Html.AntiForgeryToken()        
        
tbl_products<\/h4>        
        @Html.ValidationSummary(true, "", new { @class = "text-danger" })        @Html.HiddenFor(model => model.id)        
            @Html.LabelFor(model => model.product_name, htmlAttributes: new { @class = "control-label col-md-2" })            
                @Html.EditorFor(model => model.product_name, new { htmlAttributes = new { @class = "form-control" } })                @Html.ValidationMessageFor(model => model.product_name, "", new { @class = "text-danger" })            <\/div>        <\/div>        
            @Html.LabelFor(model => model.quantity, htmlAttributes: new { @class = "control-label col-md-2" })            
                @Html.EditorFor(model => model.quantity, new { htmlAttributes = new { @class = "form-control" } })                @Html.ValidationMessageFor(model => model.quantity, "", new { @class = "text-danger" })            <\/div>        <\/div>        
            
                            <\/div>        <\/div>    <\/div>}
    @Html.ActionLink("Back to List", "Index")<\/div>@section Scripts {    @Scripts.Render("~\/bundles\/jqueryval")}<\/code><\/pre> <\/div>\n
Details.cshtml<\/h4>\n
 
 Details.cshtml<\/span> <\/div> 
@model ArunDepartmentalStore.Models.tbl_products@{    ViewBag.Title = "Details";}
Details<\/h2>
    
tbl_products<\/h4>    
    
        
            @Html.DisplayNameFor(model => model.product_name)        <\/dt>        
            @Html.DisplayFor(model => model.product_name)        <\/dd>        
            @Html.DisplayNameFor(model => model.quantity)        <\/dt>        
            @Html.DisplayFor(model => model.quantity)        <\/dd>    <\/dl><\/div>
    @Html.ActionLink("Edit", "Edit", new { id = Model.id }) |    @Html.ActionLink("Back to List", "Index")<\/p><\/code><\/pre> <\/div>\n
Delete.cshtml<\/h4>\n
 
 Delete.cshtml<\/span> <\/div> 
@model ArunDepartmentalStore.Models.tbl_products@{    ViewBag.Title = "Delete";}
Delete<\/h2>
Are you sure you want to delete this?<\/h3>
    
tbl_products<\/h4>    
    
        
            @Html.DisplayNameFor(model => model.product_name)        <\/dt>        
            @Html.DisplayFor(model => model.product_name)        <\/dd>        
            @Html.DisplayNameFor(model => model.quantity)        <\/dt>        
            @Html.DisplayFor(model => model.quantity)        <\/dd>    <\/dl>    @using (Html.BeginForm()) {        @Html.AntiForgeryToken()        
             |            @Html.ActionLink("Back to List", "Index")        <\/div>    }<\/div><\/code><\/pre> <\/div>\n","protected":false},"excerpt":{"rendered":"
Database code Model Code Controller Code View Code Index.cshtml create.cshtml edit.cshtml Details.cshtml Delete.cshtml<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[19084],"tags":[19089,19090,19086,19088,19085,19087],"class_list":["post-5073","post","type-post","status-publish","format-standard","hentry","category-csharp","tag-net","tag-net-mvc","tag-asp-mvc","tag-charp-mvc","tag-mvc","tag-mvc-code"],"yoast_head":"\nMVC Code - Wikitechy<\/title>\n<meta name=\"description\" content=\"MVC stands for model-view-controller. MVC is a pattern for developing applications that are well architected, testable and easy to maintain.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.wikitechy.com\/interview-questions\/csharp\/mvc-code\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"MVC Code - Wikitechy\" \/>\n<meta property=\"og:description\" content=\"MVC stands for model-view-controller. MVC is a pattern for developing applications that are well architected, testable and easy to maintain.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.wikitechy.com\/interview-questions\/csharp\/mvc-code\/\" \/>\n<meta property=\"og:site_name\" content=\"Wikitechy\" \/>\n<meta property=\"article:published_time\" content=\"2022-12-27T02:49:22+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2023-06-24T11:41:25+00:00\" \/>\n<meta name=\"author\" content=\"webmaster\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"webmaster\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"1 minute\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/www.wikitechy.com\\\/interview-questions\\\/csharp\\\/mvc-code\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.wikitechy.com\\\/interview-questions\\\/csharp\\\/mvc-code\\\/\"},\"author\":{\"name\":\"webmaster\",\"@id\":\"https:\\\/\\\/www.wikitechy.com\\\/interview-questions\\\/#\\\/schema\\\/person\\\/f785ba3ecc599133e65ab6138042a3e4\"},\"headline\":\"MVC Code\",\"datePublished\":\"2022-12-27T02:49:22+00:00\",\"dateModified\":\"2023-06-24T11:41:25+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/www.wikitechy.com\\\/interview-questions\\\/csharp\\\/mvc-code\\\/\"},\"wordCount\":2217,\"commentCount\":0,\"keywords\":[\".net\",\".net mvc\",\"asp mvc\",\"charp mvc\",\"mvc\",\"mvc code\"],\"articleSection\":[\"C#\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\\\/\\\/www.wikitechy.com\\\/interview-questions\\\/csharp\\\/mvc-code\\\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/www.wikitechy.com\\\/interview-questions\\\/csharp\\\/mvc-code\\\/\",\"url\":\"https:\\\/\\\/www.wikitechy.com\\\/interview-questions\\\/csharp\\\/mvc-code\\\/\",\"name\":\"MVC Code - Wikitechy\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.wikitechy.com\\\/interview-questions\\\/#website\"},\"datePublished\":\"2022-12-27T02:49:22+00:00\",\"dateModified\":\"2023-06-24T11:41:25+00:00\",\"author\":{\"@id\":\"https:\\\/\\\/www.wikitechy.com\\\/interview-questions\\\/#\\\/schema\\\/person\\\/f785ba3ecc599133e65ab6138042a3e4\"},\"description\":\"MVC stands for model-view-controller. MVC is a pattern for developing applications that are well architected, testable and easy to maintain.\",\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/www.wikitechy.com\\\/interview-questions\\\/csharp\\\/mvc-code\\\/\"]}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/www.wikitechy.com\\\/interview-questions\\\/#website\",\"url\":\"https:\\\/\\\/www.wikitechy.com\\\/interview-questions\\\/\",\"name\":\"Wikitechy\",\"description\":\"Interview Questions\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/www.wikitechy.com\\\/interview-questions\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/www.wikitechy.com\\\/interview-questions\\\/#\\\/schema\\\/person\\\/f785ba3ecc599133e65ab6138042a3e4\",\"name\":\"webmaster\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/155b77fd8cdda3d0913fcb7e7ee63543b0c345d2d8f6dcebda5b0583ab61f967?s=96&d=mm&r=g\",\"url\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/155b77fd8cdda3d0913fcb7e7ee63543b0c345d2d8f6dcebda5b0583ab61f967?s=96&d=mm&r=g\",\"contentUrl\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/155b77fd8cdda3d0913fcb7e7ee63543b0c345d2d8f6dcebda5b0583ab61f967?s=96&d=mm&r=g\",\"caption\":\"webmaster\"},\"sameAs\":[\"https:\\\/\\\/www.wikitechy.com\\\/interview-questions\"],\"url\":\"https:\\\/\\\/www.wikitechy.com\\\/interview-questions\\\/author\\\/webmaster\\\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"MVC Code - Wikitechy","description":"MVC stands for model-view-controller. MVC is a pattern for developing applications that are well architected, testable and easy to maintain.","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.wikitechy.com\/interview-questions\/csharp\/mvc-code\/","og_locale":"en_US","og_type":"article","og_title":"MVC Code - Wikitechy","og_description":"MVC stands for model-view-controller. MVC is a pattern for developing applications that are well architected, testable and easy to maintain.","og_url":"https:\/\/www.wikitechy.com\/interview-questions\/csharp\/mvc-code\/","og_site_name":"Wikitechy","article_published_time":"2022-12-27T02:49:22+00:00","article_modified_time":"2023-06-24T11:41:25+00:00","author":"webmaster","twitter_card":"summary_large_image","twitter_misc":{"Written by":"webmaster","Est. reading time":"1 minute"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.wikitechy.com\/interview-questions\/csharp\/mvc-code\/#article","isPartOf":{"@id":"https:\/\/www.wikitechy.com\/interview-questions\/csharp\/mvc-code\/"},"author":{"name":"webmaster","@id":"https:\/\/www.wikitechy.com\/interview-questions\/#\/schema\/person\/f785ba3ecc599133e65ab6138042a3e4"},"headline":"MVC Code","datePublished":"2022-12-27T02:49:22+00:00","dateModified":"2023-06-24T11:41:25+00:00","mainEntityOfPage":{"@id":"https:\/\/www.wikitechy.com\/interview-questions\/csharp\/mvc-code\/"},"wordCount":2217,"commentCount":0,"keywords":[".net",".net mvc","asp mvc","charp mvc","mvc","mvc code"],"articleSection":["C#"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.wikitechy.com\/interview-questions\/csharp\/mvc-code\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.wikitechy.com\/interview-questions\/csharp\/mvc-code\/","url":"https:\/\/www.wikitechy.com\/interview-questions\/csharp\/mvc-code\/","name":"MVC Code - Wikitechy","isPartOf":{"@id":"https:\/\/www.wikitechy.com\/interview-questions\/#website"},"datePublished":"2022-12-27T02:49:22+00:00","dateModified":"2023-06-24T11:41:25+00:00","author":{"@id":"https:\/\/www.wikitechy.com\/interview-questions\/#\/schema\/person\/f785ba3ecc599133e65ab6138042a3e4"},"description":"MVC stands for model-view-controller. MVC is a pattern for developing applications that are well architected, testable and easy to maintain.","inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.wikitechy.com\/interview-questions\/csharp\/mvc-code\/"]}]},{"@type":"WebSite","@id":"https:\/\/www.wikitechy.com\/interview-questions\/#website","url":"https:\/\/www.wikitechy.com\/interview-questions\/","name":"Wikitechy","description":"Interview Questions","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.wikitechy.com\/interview-questions\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/www.wikitechy.com\/interview-questions\/#\/schema\/person\/f785ba3ecc599133e65ab6138042a3e4","name":"webmaster","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/secure.gravatar.com\/avatar\/155b77fd8cdda3d0913fcb7e7ee63543b0c345d2d8f6dcebda5b0583ab61f967?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/155b77fd8cdda3d0913fcb7e7ee63543b0c345d2d8f6dcebda5b0583ab61f967?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/155b77fd8cdda3d0913fcb7e7ee63543b0c345d2d8f6dcebda5b0583ab61f967?s=96&d=mm&r=g","caption":"webmaster"},"sameAs":["https:\/\/www.wikitechy.com\/interview-questions"],"url":"https:\/\/www.wikitechy.com\/interview-questions\/author\/webmaster\/"}]}},"_links":{"self":[{"href":"https:\/\/www.wikitechy.com\/interview-questions\/wp-json\/wp\/v2\/posts\/5073","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.wikitechy.com\/interview-questions\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.wikitechy.com\/interview-questions\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.wikitechy.com\/interview-questions\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.wikitechy.com\/interview-questions\/wp-json\/wp\/v2\/comments?post=5073"}],"version-history":[{"count":5,"href":"https:\/\/www.wikitechy.com\/interview-questions\/wp-json\/wp\/v2\/posts\/5073\/revisions"}],"predecessor-version":[{"id":5078,"href":"https:\/\/www.wikitechy.com\/interview-questions\/wp-json\/wp\/v2\/posts\/5073\/revisions\/5078"}],"wp:attachment":[{"href":"https:\/\/www.wikitechy.com\/interview-questions\/wp-json\/wp\/v2\/media?parent=5073"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.wikitechy.com\/interview-questions\/wp-json\/wp\/v2\/categories?post=5073"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.wikitechy.com\/interview-questions\/wp-json\/wp\/v2\/tags?post=5073"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}