How to Create Mvc Db
MVC DATABASE APPLICATION USING C# CODE
using System; using System.Collections.Generic; using System.Linq; using System.Web; using System.Web.Mvc; using Pharmacy.Models;
namespace Pharmacy.Controllers
{
public class HomeController : Controller { private MedicineEntities _datamodel = new MedicineEntities(); public ActionResult Index() { return View(_datamodel.MDs.ToList()); }
// // GET: /Home/Details/5
public ActionResult Details(int id) { var prod = _datamodel.MDs.Where(item => item.id == id).First(); return View(prod); }
// // GET: /Home/Create
public ActionResult Create() { return View(); }
// // POST: /Home/Create
[AcceptVerbs(HttpVerbs.Post)] public ActionResult Create([Bind(Exclude = "ID")] MD productToCreate) { if (!ModelState.IsValid) return View(); try { _datamodel.AddToMDs(productToCreate); _datamodel.SaveChanges(); return RedirectToAction("Index"); } catch { return View(); } } // // GET: /Home/Edit/5 public ActionResult Edit(int id) { return View(_datamodel.MDs.FirstOrDefault(item => item.id == id)); }
// // POST: /Home/Edit/5
[HttpPost] public ActionResult Edit(MD productToCreate) { try { var prod = _datamodel.MDs.Where(item => item.id == productToCreate.id).First(); prod.medicine_name = productToCreate.medicine_name; prod.description = productToCreate.description; prod.quantity =
using System; using System.Collections.Generic; using System.Linq; using System.Web; using System.Web.Mvc; using Pharmacy.Models;
namespace Pharmacy.Controllers
{
public class HomeController : Controller { private MedicineEntities _datamodel = new MedicineEntities(); public ActionResult Index() { return View(_datamodel.MDs.ToList()); }
// // GET: /Home/Details/5
public ActionResult Details(int id) { var prod = _datamodel.MDs.Where(item => item.id == id).First(); return View(prod); }
// // GET: /Home/Create
public ActionResult Create() { return View(); }
// // POST: /Home/Create
[AcceptVerbs(HttpVerbs.Post)] public ActionResult Create([Bind(Exclude = "ID")] MD productToCreate) { if (!ModelState.IsValid) return View(); try { _datamodel.AddToMDs(productToCreate); _datamodel.SaveChanges(); return RedirectToAction("Index"); } catch { return View(); } } // // GET: /Home/Edit/5 public ActionResult Edit(int id) { return View(_datamodel.MDs.FirstOrDefault(item => item.id == id)); }
// // POST: /Home/Edit/5
[HttpPost] public ActionResult Edit(MD productToCreate) { try { var prod = _datamodel.MDs.Where(item => item.id == productToCreate.id).First(); prod.medicine_name = productToCreate.medicine_name; prod.description = productToCreate.description; prod.quantity =