rahuldass

Default MVC 5 Controller

namespace Bigcart.Web.Controllers
{
    public class TestController : Controller
    {
        private BigcartContext db = new BigcartContext();

        // GET: Test

rahuldass

###Insert data in MVC 4

Insert record in database using Entity Framework

Method 1 using FormCollection

[HttpPost]
public ActionResult Create(FormCollection formCollection)
{
    if (ModelState.IsValid)

rahuldass

###Hyperlinks in MVC 4

Display Text, Name of Action Method, Name of Controller

@Html.ActionLink("Back To List", "Index", "Department")

Display Text, Name of Action Method, Name of Controller, Id, HTML Attributes

@Html.ActionLink(department.Name, "Index", "Employee",new {id = department.Id}, null)

rahuldass

###Code First Data Migrations Commands

From the Tools menu, click Library Package Manager and then Package Manager Console then choose default project EF.Data in it, which means always choose that project where you want to install a package.

1. Enable-Migrations
2. Add-Migration database name
3. Update-Database

rahuldass

###Stored Procedure to check user login

Validating (Check) Username and Password from database using stored procedure.

CREATE PROCEDURE [dbo].[usp_CheckLogin] 
	-- ADD THE PARAMETERS FOR THE STORED PROCEDURE
	@UserID		int,
	@Password	nvarchar(50),
	@Result int = '0' 

rahuldass

###View version of MVC 4 or later used in project

In runtime

public class HomeController : Controller
{
    public string Index()
 {

rahuldass

###Clear all Textboxes

Clear all Textboxes in C#

Button Click

private void clearButton_Click(object sender, EventArgs e)
        {
            ClearAllText(this);
 }

rahuldass

###Gender Dropdownlist in MVC 4

Gender Dropdownlist in ASP.NET MVC 4

<div class="editor-field">
     @Html.DropDownList("Gender", new List<SelectListItem>
        {
        	new SelectListItem{ Text="Male", Value="Male"},
        	new SelectListItem{ Text="Female", Value="Female"}
 }, "--- Select ---", new { @class = "form-control" })

rahuldass

###Customizing Autogenerated classes in MVC 4

In order to customize classes autogenerated by .edmx add a new class file in Models folder.

Eg: Department.cs or DepartmentCustom.cs

Copy and paste the following code in "Department.cs" file

namespace MVCDemo.Models

rahuldass

###Downgrade Entity Framework from 6 to 5

In Nuget package console type:

Uninstall-package EntityFramework
Install-Package EntityFramework -version 5.0.0