using System.Configuration;

using System.Data.SqlClient;

@model  List<Html_Grid_MVC.Models.Customers>

@{

    ViewBag.Title = "Display Data in Gridmvc based on Dropdownlist selected value in MVC Razor";

}

@using GridMvc.Html

<h2>Index</h2>

<script src="~/Scripts/jquery-1.10.2.js"></script>

<link href="@Url.Content("~/Content/Gridmvc.css")" rel="stylesheet" />

<script src="@Url.Content("~/Scripts/gridmvc.min.js")"></script>

<script src="~/bootstrap/js/bootstrap.min.js"></script>

<link href="~/bootstrap/css/bootstrap.min.css" rel="stylesheet" />

<link href="~/Content/Site.css" rel="stylesheet" />

<div class="container">

    <div style="margin-top: 10px"></div>

    <div class="logo col-sm-12 text-center col-md-12 ">

    </div>

    <div class="clearfix"></div>

    @using (Html.BeginForm("Index", "HTMLGrid_", FormMethod.Post, new { @name = "Form1" }))

    {

        <fieldset>

            <legend class="legend">All Customers Detail</legend>

            Address <select id="ddlType" class="form-control" onchange="OnChange()" name="ddlType">

                <option value="0">Select</option>

                <option value="Russia">Russia</option>

                <option value="Canada">Canada</option>

                <option value="China">China</option>

                <option value="United States">United States</option>

            </select>

            <div style="margin-top: 5px"></div>

            <div class="test" style="overflow: scroll; height: auto; width: 600px">

                <div style="width: 600px">

                    <div class="panel">

                        <div class="panel-body">

                            @Html.Grid(Model).Columns(columns =>

                    {

                        columns.Add(c => c.customerID).Titled("CustomerID");

                        columns.Add(c => c.FirstName).Titled("FirstName");

                        columns.Add(c => c.LastName).Titled("LastName");

                        columns.Add(c => c.CreatedDate).Titled("CreatedDate").Format("{0:dd/MM/yyyy}");

                        columns.Add(c => c.Address).Titled("Address");

                    }).WithPaging(10);

                        </div>

                    </div>

                </div>

            </div>

        </fieldset>

    }

    <script>

        function OnChange() {

            document.forms["Form1"].submit();

        }

        window.onload = function () {

            $("#ddlType").val("@ViewBag.Selected")

        }

    </script>

</div>

public class Customers

    {

        public int customerID { get; set; }

        public string FirstName { get; set; }

        public string LastName { get; set; }

        public string Address { get; set; }

        public DateTime CreatedDate { get; set; }

    }

public class HTMLGrid_Controller : Controller

{

    // GET: HTMLGrid_

    public ActionResult Index()

    {

        List<Customers> customers = PopulateCustomers();

        ViewBag.Selected = "Select";

        return View(customers);

    }

    [HttpPost]

    public ActionResult Index(FormCollection formCollection)

    {

        String Address = formCollection["ddlType"];

        List<Customers> customers = new List<Customers>();

        if (Address != "0")

        {

            customers = PopulateCustomers().Where(x => x.Address == Address).ToList();

        }

        else

        {

            customers = PopulateCustomers();

        }

        ViewBag.Selected = Address;

        return View(customers);

    }

    [NonAction]

    private List<Customers> PopulateCustomers()

    {

        List<Customers> customers = new List<Customers>();

        string constr = Convert.ToString(ConfigurationManager.ConnectionStrings["Connection"]);

        SqlConnection con = new SqlConnection(constr);

        SqlCommand cmd = new SqlCommand("Select * from dim_Customer_Master", con);

        con.Open();

        SqlDataReader idr = cmd.ExecuteReader();

        if (idr.HasRows)

        {

            while (idr.Read())

            {

                customers.Add(new Customers

                {

                    customerID = Convert.ToInt32(idr["Customer_id"]),

                    FirstName = Convert.ToString(idr["FirstName"]),

                    LastName = Convert.ToString(idr["lastname"]),

                    CreatedDate = Convert.ToDateTime(idr["createddate"]),

                    Address = Convert.ToString(idr["Address"])

                });

            }

        }

        return customers;

    }

}