Database Programming in MVC 3 in 5 Minutes

[HttpPost]
public ActionResult Create(Contact person)
{
db.Contacts.Add(person);
db.SaveChanges();
return RedirectToAction("Index");
}

Now, if you have done the above then you can run the application and it will add (create) the records in database but still you can't view them because we have not listed them. So, let's list the records too, and then we will run it.

Step 5: Adding View for "Index Action" by modifying it

In this step you need to modify the Index Action, here is the modified code:

public ActionResult Index()
{
var contact = db.Contacts.ToList();
return View(contact);
}

Now, add the view for it as directed in Step 3 also, find the image below.

When you click on Add button, you can see that the system has added one View to your project explorer (Views > Contact > Index.cshtml).

Now run the application and navigate to "http://localhost:4329/Contact". Your port number in the URL might be different.

Step 6: Adding New Record & Listing

You cannot see any records as we have not added any, so let's click on "Create New" to add the record.

Look at the image; I have added a new record.

Step 7: Required Field Validation

Now, if you try to insert a blank record it will show you an error only for the Date field, we have not even added any validation. Remember, in the model class (in Step 2) we have created all properties using string type data for Name, Address and Mobile but for the DataDate it is DateTime, that's why the database can't accept invalid dates. Now, modify the Step 2 code so that validation can work for rest fields also. Even we will add maximum length to string. Here is the modified code:

using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Data.Entity;
using System.ComponentModel.DataAnnotations;
namespace MvcApplication2.Models
{
public class Contact
{
public int ID { get; set; }

[Required]
[StringLength(20)]
public string Name { get; set; }

[Required]
[StringLength(20)]
public string Address { get; set; }

[Required]
[StringLength(12)]
public string Mobile { get; set; }

public DateTime DataDate { get; set; }
}

public class ContactContext : DbContext
{
public DbSet<Contact> Contacts { get; set; }
}
}

Four modifications are made in the above code:

1. Added a namespace "using System.ComponentModel.DataAnnotations;".

2. Made Name field as required and its length to 20.

3. Made Address field as required and its length to 20.

4. Made Mobile field as required and its length to 12.

Now, let's try to insert records without filling it in completely, it will show you the following errors:

Step 8: Editing Records

To edit the records, let's modify its Edit Action and its HttpPost handler. Here is the modified one.

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

[HttpPost]
public ActionResult Edit(Contact contact)
{
db.Entry(contact).State = System.Data.EntityState.Modified;
db.SaveChanges();
return RedirectToAction("Index");
}

Now, add the view for the edit action by right-clicking in the above code (not in HttpPost), find the image below.

Run the project, now you can edit the records there.

Step 9: Details of Record

To view the details of any record, we need to modify its action to:

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

And add the view for the Details Action, as given in the screen below:

Now, run the application and check it.

Step 10: Deleting Record

To delete the record, we need to modify its action to:

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

//
// POST: /Contact/Delete/5

[HttpPost]
public ActionResult Delete(int id, Contact contact)
{
var dcontact = db.Contacts.Find(id);
db.Contacts.Remove(dcontact);
db.SaveChanges();
return RedirectToAction("Index");
}

And add the view for the Delete Action, as given in the screen below:

Now, we are done with all the coding, let's run the project and check all functionality.

Video Reference

I will recommend you to download the attached file and look at the complete coding. You can also watch the audio-less video given above. I hope you like it. Thanks.