public ActionResult _AutoCompleteFilteringAjax(string text, int? filterMode) { var nw = new NorthwindDataContext(); IQueryable<Product> products = nw.Products.AsQueryable(); switch (filterMode) { case 1: // StartsWith { products = products.Where((p) => p.ProductName.StartsWith(text)); break; } case 2: // Contains { products = products.Where((p) => p.ProductName.IndexOf(text) != -1); break; } default: // None { break; } } return new JsonResult { Data = products.Select(p => p.ProductName) }; }
public ActionResult Accessibility(string itemName) { ViewData["itemName"] = itemName; var list = new NorthwindDataContext().Categories.Take(2); return View(list); }
private IEnumerable<TreeViewItem> GetCategoryTreeViewItem() { NorthwindDataContext northwind = new NorthwindDataContext(); return from item in northwind.Categories select new TreeViewItem { Text = item.CategoryName, Value = item.CategoryID.ToString() }; }
public static IEnumerable<ClientEditableOrder> All() { IEnumerable<ClientEditableOrder> result = HttpContext.Current.Session["clietOrders"] as IEnumerable<ClientEditableOrder>; if (result == null) { HttpContext.Current.Session["clietOrders"] = result = new NorthwindDataContext().Orders.Select(o => new ClientEditableOrder { OrderID = o.OrderID, OrderDate = o.OrderDate ?? DateTime.Now, EmployeeID = o.EmployeeID, Employee = o.Employee.FirstName + " " + o.Employee.LastName, Freight = o.Freight ?? 0 }).ToList(); } return result; }
public GridModel GetOrders(GridState state) { NorthwindDataContext northwind = new NorthwindDataContext(); IQueryable<OrderDto> orders = from o in northwind.Orders select new OrderDto { OrderID = o.OrderID, ContactName = o.Customer.ContactName, ShipAddress = o.ShipAddress, OrderDate = o.OrderDate }; return orders.ToGridModel(state); }
public IEnumerable GetEmployees(TreeViewItemModel node) { NorthwindDataContext northwind = new NorthwindDataContext(); int? parentId = !string.IsNullOrEmpty(node.Value) ? (int?)Convert.ToInt32(node.Value) : null; IEnumerable nodes = from item in northwind.Employees where item.ReportsTo == parentId || (parentId == null && item.ReportsTo == null) select new TreeViewItemModel { Text = item.FirstName + " " + item.LastName, Value = item.EmployeeID.ToString(), LoadOnDemand = item.Employees.Count > 0 }; return nodes; }
public ActionResult FirstLook(ComboBoxFirstLookModel model) { model.AutoCompleteAttributes.Width = model.AutoCompleteAttributes.Width ?? 200; model.AutoCompleteAttributes.HighlightFirst = model.AutoCompleteAttributes.HighlightFirst ?? true; model.AutoCompleteAttributes.AutoFill = model.AutoCompleteAttributes.AutoFill ?? false; model.AutoCompleteAttributes.AllowMultipleValues = model.AutoCompleteAttributes.AllowMultipleValues ?? true; model.AutoCompleteAttributes.MultipleSeparator = model.AutoCompleteAttributes.MultipleSeparator ?? ", "; model.ComboBoxAttributes.Width = model.ComboBoxAttributes.Width ?? 200; model.ComboBoxAttributes.SelectedIndex = model.ComboBoxAttributes.SelectedIndex ?? 0; model.ComboBoxAttributes.HighlightFirst = model.ComboBoxAttributes.HighlightFirst ?? true; model.ComboBoxAttributes.AutoFill = model.ComboBoxAttributes.AutoFill ?? true; model.ComboBoxAttributes.OpenOnFocus = model.ComboBoxAttributes.OpenOnFocus ?? false; model.DropDownListAttributes.Width = model.DropDownListAttributes.Width ?? 200; model.DropDownListAttributes.SelectedIndex = model.DropDownListAttributes.SelectedIndex ?? 0; var nw = new Telerik.Web.Mvc.Examples.Models.NorthwindDataContext(); model.Products = nw.Products.ToList(); return View(model); }
public ActionResult FirstLook(ComboBoxFirstLookModel model) { model.AutoCompleteAttributes.Width = model.AutoCompleteAttributes.Width ?? 200; model.AutoCompleteAttributes.HighlightFirst = model.AutoCompleteAttributes.HighlightFirst ?? true; model.AutoCompleteAttributes.AutoFill = model.AutoCompleteAttributes.AutoFill ?? false; model.AutoCompleteAttributes.AllowMultipleValues = model.AutoCompleteAttributes.AllowMultipleValues ?? true; model.AutoCompleteAttributes.MultipleSeparator = model.AutoCompleteAttributes.MultipleSeparator ?? ", "; model.ComboBoxAttributes.Width = model.ComboBoxAttributes.Width ?? 200; model.ComboBoxAttributes.SelectedIndex = model.ComboBoxAttributes.SelectedIndex ?? 0; model.ComboBoxAttributes.HighlightFirst = model.ComboBoxAttributes.HighlightFirst ?? true; model.ComboBoxAttributes.AutoFill = model.ComboBoxAttributes.AutoFill ?? true; model.ComboBoxAttributes.OpenOnFocus = model.ComboBoxAttributes.OpenOnFocus ?? false; model.DropDownListAttributes.Width = model.DropDownListAttributes.Width ?? 200; model.DropDownListAttributes.SelectedIndex = model.DropDownListAttributes.SelectedIndex ?? 0; var nw = new Telerik.Web.Mvc.Examples.Models.NorthwindDataContext(); model.Products = nw.Products.ToList(); return(View(model)); }
private static IEnumerable<Employee> GetRootEmployees() { NorthwindDataContext northwind = new NorthwindDataContext(); return northwind.Employees.Where(e => e.ReportsTo == null); }
private static IEnumerable<Category> GetCategories() { NorthwindDataContext northwind = new NorthwindDataContext(); return northwind.Categories; }
private void PopulateEmployees() { ViewData["employees"] = new NorthwindDataContext().Employees .Select(e => new { Id = e.EmployeeID, Name = e.FirstName + " " + e.LastName }) .OrderBy(e => e.Name); }
public ActionResult DataBindingToModel() { NorthwindDataContext northwind = new NorthwindDataContext(); return View(northwind.Categories); }
public ActionResult RtlSupport() { var nw = new Telerik.Web.Mvc.Examples.Models.NorthwindDataContext(); return(View(nw.Products)); }
public ActionResult _FilteringAjax(string text, int? filterMode) { var nw = new NorthwindDataContext(); IQueryable<Product> products = nw.Products.AsQueryable(); switch ( filterMode ) { case 1: // StartsWith { products = products.Where((p) => p.ProductName.StartsWith(text)); break; } case 2: // Contains { products = products.Where((p) => p.ProductName.IndexOf(text) != -1); break; } default: // None { break; } } return new JsonResult { JsonRequestBehavior = JsonRequestBehavior.AllowGet, Data = new SelectList(products.ToList(), "ProductID", "ProductName") }; }
public ActionResult AggregatesServerSide() { var northwind = new NorthwindDataContext(); return View(northwind.Products); }
public GridModel GetOrders(GridState state) { NorthwindDataContext northwind = new NorthwindDataContext(); return northwind.Orders.ToGridModel(state); }
public ActionResult RtlSupport() { var nw = new Telerik.Web.Mvc.Examples.Models.NorthwindDataContext(); return View(nw.Products); }
public ActionResult AggregatesAjax_Select() { var northwind = new NorthwindDataContext(); return View(new GridModel(northwind.Products)); }