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));
}
