Step a: Using Model (Purchase.dbml) class are ICustomerRepository and

Customer Repository.

Part1: How to create Linq to sql classess   (Purchase.dbml)

Part2: How to create Repository Pattern in Model (ICustomerRepository and CustomerRepository)

Step b: Creating controller in Controller folder name is DropdownController

PurchaseDataContext db = new PurchaseDataContext();

public ActionResult Index()

{

ViewData["CustomerID"] = new SelectList

(

db.tblCustomers,

“CustomerID”,

“Name”

);

return View();

}

Step c: Go to View Folder in Solution Explorer ->Create new folder in view folder , folder name is dropdown -> right click on tblCustomers Add  New Item -> choose view -> then Add view dialog box Popups

View Name (Index)

Choose Create a strongly-typed view -> In view data class dropdown

choose -> myFirstMVCapp.Models.tblCustomer

View content :In dropdown choose Empty

Write code as below in Index.aspx Page

<asp:Content ID=”Content2″

ContentPlaceHolderID=”MainContent” runat=”server”>

<h2>DropDown At runtime</h2>

<%= Html.DropDownList(”CustomerID”)%>

</asp:Content>

Link to dropdown/Index in view from Home/index page

Give in Home folder index.aspx page redirect ot dropdown/Index

<div>

<%= Html.ActionLink(”DropDownFill”, “Index”, “dropdown”) %>

</div>

mvc-dropdownlist

Create a new record in MVC (Create.aspx)

This article contain validation for

Empty values

Email validation

PhoneNo validation

[AcceptVerbs(HttpVerbs.Post)]

public ActionResult Create(tblCustomer customer)

{

if (customer.Name.Trim().Length == 0)

ModelState.AddModelError(”Name”, “First name is required.”);

if (!Regex.IsMatch(customer.PhoneNo, @”\b\d{7}”))

ModelState.AddModelError(”PhoneNo”, “Invalid phone number.”);

if (!Regex.IsMatch(customer.EmailID, @”^[\w-\.]+@([\w-]+\.)+[\w-]{2,4}$”))

ModelState.AddModelError(”EmailID”, “Invalid email address.”);

if (!ModelState.IsValid)

return View();

try

{

//TODO: Add insert logic here

customerRepository.Add(customer);

customerRepository.Save();

return RedirectToAction(”Details”, new { id = customer.CustomerID });

}

catch

{

return View();

}

}

To match a date in mm/dd/yyyy format, rearrange the regular expression to (0[1-9]|1[012])[- /.](0[1-9]|[12][0-9]|3[01])[- /.](19|20)\d\d. For dd-mm-yyyy format, use (0[1-9]|[12][0-9]|3[01])[- /.](0[1-9]|1[012])[- /.](19|20)\d\d