Diwakar's Blog

Form

Processing Page

You can use all the above selectors with any HTML/XML element in generic way. For example if selector $("li:first") works for

element then $("p:first") would also work for element.

model = from b in db.books.Take(6).ToList()
       where b.writerId==id
       select b;

var wtrName = model.FirstOrDefault().writer.WriterName;
ViewBag.title = "Book List of Writer : " + wtrName;

Model
Controller
Method Index

View
Index Display part

Combo Box, Drop Down List in MVC 4 ASP.NET using Entity Framework>
Models Class
writer.cs
public class Writer
{
public int WriterId { get; set; }
public string WriterName { get; set; }
}

book.cs
[Bind(Exclude="bookId")]
public class book
{
public int bookId { get; set; }
[Required]
public int writerId { get; set; }
[Required]
public string title { get; set; }
public decimal price { get; set; }
public string imagepath { get; set; }
}
Controller 

bookController.cs
public ActionResult Create()
{
ViewBag.WriterId = new SelectList(db.writers, "WriterId", "WriterName");
return View();
}

View
Create.cshtml
@Html.DropDownList("WriterId",string.Empty)

Model

    [Bind(Exclude="GenreId")]
    public class Genre
    {
        [ScaffoldColumn(false)]
        public int GenreId { get; set; }
        public string GenreName { get; set; }
        public string Description { get; set; }
        public Boolean Status { get; set; }
             
    }


Entity Class

    public class MVCBookStoreEntities:DbContext
    {
        public MVCBookStoreEntities()
            : base("name=ApplicationServices")
        { }
        public DbSet genres { get; set; }
    }

Global.asax

on Application_Start add this
       
    Database.SetInitializer(new DropCreateDatabaseIfModelChanges());


Controller

MVCBookStoreEntities db = new MVCBookStoreEntities();

        public ActionResult Index()
        {
            List gen =new List();
            gen=db.genres.ToList();
            var model=from g in gen
                      orderby g.GenreId descending
                      where g.Status==true
                      select g;
            return View(model);
        }

public class genreController : Controller
    {
        //
        // GET: /genre/
        MVCBookStoreEntities db = new MVCBookStoreEntities();

        public ActionResult Index()
        {
            //var model = db.genres.ToList();
            //return View(model);          

            List gen =new List();
            gen=db.genres.ToList();
            var model=from g in gen
                      orderby g.GenreId descending
                      where g.Status==true
                      select g;
            return View(model);
        }


        //
        // GET: /genre/Details/5

        public ActionResult Details(int id)
        {
            var model = db.genres.Find(id);
            return View(model);
        }

        //
        // GET: /genre/Create

        public ActionResult Create()
        {
            return View();
        }

        //
        // POST: /genre/Create

        [HttpPost]
        public ActionResult Create(Genre addgen)
        // public ActionResult Create(FormCollection collection)
        {
            try
            {
                // TODO: Add insert logic here
                //return RedirectToAction("Index");
                db.Entry(addgen).State = EntityState.Added;
                //db.genres.Add(addgen);
                db.SaveChanges();
                return RedirectToAction("Index");


            }
            catch
            {
                return View();
            }
        }

        //
        // GET: /genre/Edit/5

        public ActionResult Edit(int id)
        {
            var model=db.genres.Find(id);
            return View(model);
        }

        //
        // POST: /genre/Edit/5

        [HttpPost]
        public ActionResult Edit(int id, Genre editgen)
        //public ActionResult Edit(int id, FormCollection collection)
        {
                try
                {
                    if (ModelState.IsValid)
                    {
                        // TODO: Add update logic here
                        editgen.GenreId = id;
                        db.Entry(editgen).State = EntityState.Modified;
                        db.SaveChanges();
                        return RedirectToAction("Index");
                    }
                    else {
                        return RedirectToAction("Index");
                    }
                }
                catch
                {
                    return View();
                }
           
        }

        //
        // GET: /genre/Delete/5

        public ActionResult Delete(int id)
        {
            var model = db.genres.Find(id);
            return View(model);
        }

        //
        // POST: /genre/Delete/5

        [HttpPost]
        public ActionResult Delete(int id, Genre deletegen)
        {
            try
            {
                if (ModelState.IsValid)
                {
                    // TODO: Add update logic here
                    deletegen.GenreId = id;
                    db.Entry(deletegen).State = EntityState.Deleted;
                    db.SaveChanges();
                    return RedirectToAction("Index");
                }
                else
                {
                    return RedirectToAction("Index");
                }
            }
            catch
            {
                return View();
            }
        }
    }

Microsoft Visual Studio 2012

Tools
Library Package Manager
Package Manager Console

Then
PM> Install-Package EntityFramework -Pre  

required Internet Connection............

Scaffolding is a technique supported by some model-view-controller frameworks, in which the programmer may write a specification that describes how the application database may be used. The compiler uses this specification to generate code that the application can use to create, read, update and delete database entries, effectively treating the template as a "scaffold" on which to build a more powerful application.