- MvcJqGridSample.zip
- MvcJqGridSample.sln
- MvcJqGridSample.suo
- MvcJqGridSample
- bin
- EntityFramework.dll
- EntityFramework.xml
- MvcJqGrid.dll
- MvcJqGrid.pdb
- MvcJqGridSample.dll
- MvcJqGridSample.pdb
- Content
- images
- accent.png
- facebook.png
- heroAccent.png
- orderedListOne.png
- orderedListThree.png
- orderedListTwo.png
- twitter.png
- jquery.jqGrid
- Site.css
- themes
- base
- smoothness
- images
- ui-bg_flat_0_aaaaaa_40x100.png
- ui-bg_flat_75_ffffff_40x100.png
- ui-bg_glass_55_fbf9ee_1x400.png
- ui-bg_glass_65_ffffff_1x400.png
- ui-bg_glass_75_dadada_1x400.png
- ui-bg_glass_75_e6e6e6_1x400.png
- ui-bg_glass_95_fef1ec_1x400.png
- ui-bg_highlight-soft_75_cccccc_1x100.png
- ui-icons_222222_256x240.png
- ui-icons_2e83ff_256x240.png
- ui-icons_454545_256x240.png
- ui-icons_888888_256x240.png
- ui-icons_cd0a0a_256x240.png
- jquery-ui-1.8.custom.css
- Controllers
- Global.asax
- Global.asax.cs
- Models
- MvcJqGridSample.csproj
- MvcJqGridSample.csproj.user
- obj
- Debug
- packages.config
- Properties
- Ref
- MvcJqGrid.dll
- MvcJqGrid.pdb
- Scripts
- Views
- Web.config
- Web.Debug.config
- Web.Release.config
- packages
- EntityFramework.4.1.10331.0
- EntityFramework.4.1.10331.0.nupkg
- lib
- jQuery.1.5.1
- Content
- Scripts
- jQuery.1.5.1.nupkg
- jQuery.UI.Combined.1.8.11
- Content
- Content
- themes
- base
- Scripts
- jQuery.UI.Combined.1.8.11.nupkg
- jQuery.Validation.1.8.0
- Content
- Scripts
- jQuery.Validation.1.8.0.nupkg
- jQuery.vsdoc.1.5.1
- Content
- Scripts
- jQuery.vsdoc.1.5.1.nupkg
- Modernizr.1.7
- Content
- Scripts
- Modernizr.1.7.nupkg
- repositories.config
- MvcJqGridSample-noexe.zip
|
using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.Mvc;
using MvcJqGridSample.Models;
using MvcJqGrid;
namespace MvcJqGridSample.Controllers
{
public class CustomerController : Controller
{
public ActionResult Index()
{
var countries = new CountryRepository().Search();
ViewBag.Countries = (from c in countries select c.Name).ToArray();
return View();
}
public JsonResult Search(GridSettings gridSettings)
{
List<CustomerSearchResult> customers = null;
int totalRecords;
CustomerRepository customerRepository = new CustomerRepository();
CustomerSeachFilter filter = new CustomerSeachFilter();
if (gridSettings.IsSearch)
{
filter.FirstName = gridSettings.Where.rules.Any(r => r.field == "FirstName") ?
gridSettings.Where.rules.FirstOrDefault(r => r.field == "FirstName").data : string.Empty;
filter.LastName = gridSettings.Where.rules.Any(r => r.field == "LastName") ?
gridSettings.Where.rules.FirstOrDefault(r => r.field == "LastName").data : string.Empty;
filter.CountryName = gridSettings.Where.rules.Any(r => r.field == "CountryName") ?
gridSettings.Where.rules.FirstOrDefault(r => r.field == "CountryName").data : string.Empty;
filter.Phone = gridSettings.Where.rules.Any(r => r.field == "Phone") ?
gridSettings.Where.rules.FirstOrDefault(r => r.field == "Phone").data : string.Empty;
filter.BirthDate = gridSettings.Where.rules.Any(r => r.field == "BirthDate") ?
DateTime.ParseExact(gridSettings.Where.rules.FirstOrDefault(r => r.field == "BirthDate").data,
"yyyy-MM-dd", null) : DateTime.MinValue;
}
customers = customerRepository.Search(filter,
gridSettings.SortColumn,
gridSettings.SortOrder,
gridSettings.PageSize,
gridSettings.PageIndex,
out totalRecords);
var jsonData = new
{
total = totalRecords / gridSettings.PageSize + 1,
page = gridSettings.PageIndex,
records = totalRecords,
rows = (
from c in customers
select new
{
id = c.CustomerID,
FirstName = c.FirstName,
LastName = c.LastName,
BirthDate = c.BirthDate.ToString("yyyy-MM-dd"),
CountryName = c.CountryName,
EmailAddress = c.EmailAddress,
Phone = c.Phone,
})
};
return Json(jsonData);
}
}
}
|
By viewing downloads associated with this article you agree to the Terms of Service and the article's licence.
If a file you wish to view isn't highlighted, and is a text file (not binary), please
let us know and we'll add colourisation support for it.
I am an Experienced Senior Microsoft Consultant responsible for developing and defining architectures for various projects in a Microsoft environment, using a Service-Oriented Architecture (SOA) and web based applications.
I am also a project manager using agile methodologies and SCRUM.
Software Quality Assurance is a mandatory in every project I am responsible.
As someone said:
“Anyone can program, but not everyone is a programmer...”