public ActionResult FilterMenuCustomization_Titles()
{
using (var db = new SampleEntitiesDataContext())
{
return(Json(db.Employees.Select(e => e.Title).Distinct().ToList()));
}
}
private static OrderViewModel GetFirstOrder()
{
using (var northwind = new SampleEntitiesDataContext())
{
return(northwind.Orders.Select(order => new OrderViewModel
{
OrderDate = order.OrderDate,
}).First());
}
}
public JsonResult GetCascadeProducts(int?categories)
{
var northwind = new SampleEntitiesDataContext();
var products = northwind.Products.AsQueryable();
if (categories != null)
{
products = products.Where(p => p.CategoryID == categories);
}
return(Json(products.Select(p => new { ProductID = p.ProductID, ProductName = p.ProductName })));
}
public JsonResult GetCascadeOrders(int?products)
{
var northwind = new SampleEntitiesDataContext();
var orders = northwind.OrderDetails.AsQueryable();
if (products != null)
{
orders = orders.Where(o => o.ProductID == products);
}
return(Json(orders.Select(o => new { OrderID = o.OrderID, ShipCity = o.Order.ShipCity })));
}
public ActionResult Tag_Helper()
{
using (var northwind = new SampleEntitiesDataContext())
{
var categories = northwind.Categories.ToList();
categories.ForEach(c =>
c.Products = northwind.Products
.Where(p => p.CategoryID == c.CategoryID)
.ToList());
return(View(categories));
}
}
private void PopulateCategories()
{
var dataContext = new SampleEntitiesDataContext();
var categories = dataContext.Categories
.Select(c => new CategoryViewModel
{
CategoryID = c.CategoryID,
CategoryName = c.CategoryName
})
.OrderBy(e => e.CategoryName);
ViewData["categories"] = categories;
ViewData["defaultCategory"] = categories.First();
}
public ActionResult Pdf_Export_Read([DataSourceRequest] DataSourceRequest request)
{
using (var northwind = new SampleEntitiesDataContext())
{
return(Json(northwind.Employees.ToList().ToDataSourceResult(request, e => new EmployeeViewModel
{
EmployeeID = e.EmployeeID,
Country = e.Country,
Title = e.Title,
FirstName = e.FirstName,
LastName = e.LastName
})));
}
}
public IActionResult _StockData([DataSourceRequest] DataSourceRequest request)
{
var dateFrom = MIN_DATE;
var dateTo = DateTime.Now;
var baseUnit = DEFAULT_UNIT;
IEnumerable <StockDataPoint> result;
using (var db = new SampleEntitiesDataContext())
{
if (request != null && request.Filters != null && request.Filters.Count > 0)
{
var composite = request.Filters[0] as CompositeFilterDescriptor;
if (composite != null)
{
dateFrom = (DateTime)((FilterDescriptor)composite.FilterDescriptors[0]).ConvertedValue;
dateTo = (DateTime)((FilterDescriptor)composite.FilterDescriptors[1]).ConvertedValue;
baseUnit = GetBaseUnit(dateFrom, dateTo);
}
}
var groupedData =
from s in db.Intradays
where s.Date >= dateFrom && s.Date <= dateTo
group s by new
{
Year = s.Date.Year,
Month = baseUnit >= BaseUnit.Months ? s.Date.Month : 1,
Day = baseUnit >= BaseUnit.Weeks ? s.Date.Day : 1,
Hour = baseUnit >= BaseUnit.Hours ? s.Date.Hour : 0,
Minute = baseUnit >= BaseUnit.Minutes ? s.Date.Minute : 0
} into g
select g;
var points =
from g in groupedData.ToList()
select new StockDataPoint
{
Date = new DateTime(g.Key.Year, g.Key.Month, g.Key.Day, g.Key.Hour, g.Key.Minute, 0),
Open = g.Max(s => s.Open),
High = g.Max(s => s.High),
Low = g.Min(s => s.Low),
Close = g.Max(s => s.Close),
Volume = g.Sum(s => s.Volume)
};
result = points.ToList().OrderBy(g => g.Date);
}
return(Json(result));
}
private static IEnumerable <ProductViewModel> GetProducts()
{
var northwind = new SampleEntitiesDataContext();
return(northwind.Products.Select(product => new ProductViewModel
{
ProductID = product.ProductID,
ProductName = product.ProductName,
UnitPrice = product.UnitPrice.HasValue ? product.UnitPrice.Value : default(decimal),
UnitsInStock = product.UnitsInStock.HasValue ? product.UnitsInStock.Value : default(int),
UnitsOnOrder = product.UnitsOnOrder.HasValue ? product.UnitsOnOrder.Value : default(int),
Discontinued = product.Discontinued,
LastSupply = DateTime.Today
}));
}
public ActionResult ToolbarTemplate_Categories()
{
using (var dataContext = new SampleEntitiesDataContext())
{
var categories = dataContext.Categories
.Select(c => new CategoryViewModel
{
CategoryID = c.CategoryID,
CategoryName = c.CategoryName
})
.OrderBy(e => e.CategoryName);
return(Json(categories.ToList()));
}
}
public IActionResult _Weather(string station, int year, int month)
{
var db = new SampleEntitiesDataContext();
var weatherData = db.Weather
.Where(x => x.Station == station && x.Date.Year == year && x.Date.Month == month)
.Select(x => new
{
ID = x.ID,
Rain = x.Rain,
TMax = x.TMax,
Wind = x.Wind
});
return(Json(weatherData));
}
private static IEnumerable <ProductViewModel> GetProducts()
{
var northwind = new SampleEntitiesDataContext();
return(northwind.Products.Select(product => new ProductViewModel
{
ProductID = product.ProductID,
ProductName = product.ProductName,
UnitPrice = product.UnitPrice ?? 0,
UnitsInStock = product.UnitsInStock ?? 0,
UnitsOnOrder = product.UnitsOnOrder ?? 0,
Discontinued = product.Discontinued,
LastSupply = DateTime.Today
}));
}
private static IEnumerable <EmployeeViewModel> GetEmployees()
{
var northwind = new SampleEntitiesDataContext();
return(northwind.Employees.ToList().Select(employee => new EmployeeViewModel
{
EmployeeID = employee.EmployeeID,
FirstName = employee.FirstName,
LastName = employee.LastName,
Country = employee.Country,
City = employee.City,
Notes = employee.Notes,
Title = employee.Title,
Address = employee.Address,
HomePhone = employee.HomePhone
}));
}
public JsonResult Employees(int?id)
{
var dataContext = new SampleEntitiesDataContext();
var employees = from e in dataContext.Employees
where (id.HasValue ? e.ReportsTo == id : e.ReportsTo == null)
select new
{
id = e.EmployeeID,
Name = e.FirstName + " " + e.LastName,
hasChildren = (from q in dataContext.Employees
where (q.ReportsTo == e.EmployeeID)
select q
).Count() > 0
};
return(Json(employees));
}
public IActionResult _BoeingStockData()
{
var db = new SampleEntitiesDataContext();
return(Json(
from s in db.Stocks
where s.Symbol == "BA"
select new StockDataPoint
{
Date = s.Date,
Open = s.Open,
High = s.High,
Low = s.Low,
Close = s.Close,
Volume = s.Volume
}
));
}
public JsonResult GetCascadeOrders(int?products, string orderFilter)
{
using (var northwind = new SampleEntitiesDataContext())
{
var orders = northwind.OrderDetails.AsQueryable();
if (products != null)
{
orders = orders.Where(o => o.ProductID == products);
}
if (!string.IsNullOrEmpty(orderFilter))
{
orders = orders.Where(o => o.Order.ShipCity.Contains(orderFilter));
}
return(Json(orders.Select(o => new { OrderID = o.OrderID, ShipCity = o.Order.ShipCity }).ToList()));
}
}
private static IEnumerable <OrderViewModel> GetOrders()
{
var northwind = new SampleEntitiesDataContext();
return(northwind.Orders.Select(order => new OrderViewModel
{
ContactName = order.Customer.ContactName,
Freight = order.Freight,
OrderDate = order.OrderDate,
ShippedDate = order.ShippedDate,
OrderID = order.OrderID,
ShipAddress = order.ShipAddress,
ShipCountry = order.ShipCountry,
ShipName = order.ShipName,
ShipCity = order.ShipCity,
EmployeeID = order.EmployeeID,
CustomerID = order.CustomerID
}));
}
private static IEnumerable <CustomerViewModel> GetCustomers()
{
var northwind = new SampleEntitiesDataContext();
return(northwind.Customers.ToList().Select(customer => new CustomerViewModel
{
CustomerID = customer.CustomerID,
CompanyName = customer.CompanyName,
ContactName = customer.ContactName,
ContactTitle = customer.ContactTitle,
Address = customer.Address,
City = customer.City,
Region = customer.Region,
PostalCode = customer.PostalCode,
Country = customer.Country,
Phone = customer.Phone,
Fax = customer.Fax,
Bool = customer.Bool
}));
}
public IEnumerable <ProductSignalR> Read()
{
using (var context = new SampleEntitiesDataContext())
{
var createdAt = DateTime.Now;
var products = context.Products
.OrderBy(p => p.ProductName)
.ToList()
.Select((p, index) => new ProductSignalR
{
ID = (index + 1),
ProductName = p.ProductName,
UnitPrice = (double)p.UnitPrice.GetValueOrDefault(),
UnitsInStock = p.UnitsInStock.GetValueOrDefault(),
CreatedAt = createdAt = createdAt.AddMilliseconds(1)
})
.ToList();
return(products);
}
}
public JsonResult GetProducts(string text)
{
var northwind = new SampleEntitiesDataContext();
var products = northwind.Products.Select(product => new ProductViewModel
{
ProductID = product.ProductID,
ProductName = product.ProductName,
UnitPrice = product.UnitPrice ?? 0,
UnitsInStock = product.UnitsInStock ?? 0,
UnitsOnOrder = product.UnitsOnOrder ?? 0,
Discontinued = product.Discontinued
});
if (!string.IsNullOrEmpty(text))
{
products = products.Where(p => p.ProductName.Contains(text));
}
return(Json(products));
}
public IEnumerable <ProductSignalR> Read()
{
using (var context = new SampleEntitiesDataContext())
{
var products = context.Products.Select(p => new ProductSignalR
{
ID = p.ProductID,
ProductName = p.ProductName,
UnitPrice = (double)p.UnitPrice.GetValueOrDefault(),
UnitsInStock = p.UnitsInStock.GetValueOrDefault(),
CreatedAt = DateTime.Now.AddMilliseconds(1),
Category = new CategorySignalR()
{
CategoryID = p.Category.CategoryID,
CategoryName = p.Category.CategoryName
}
})
.ToList();
return(products);
}
}
public ActionResult CustomAjaxBinding_Read([DataSourceRequest] DataSourceRequest request)
{
var dataContext = new SampleEntitiesDataContext();
// Convert to view model to avoid JSON serialization problems due to circular references.
IQueryable <OrderViewModel> orders = dataContext.Orders.Select(o => new OrderViewModel
{
OrderID = o.OrderID,
ShipCity = o.ShipCity,
ShipCountry = o.ShipCountry,
ShipName = o.ShipName
});
orders = orders.ApplyOrdersFiltering(request.Filters);
var total = orders.Count();
orders = orders.ApplyOrdersSorting(request.Groups, request.Sorts);
if (!request.Sorts.Any())
{
// Entity Framework doesn't support paging on unsorted data.
orders = orders.OrderBy(o => o.OrderID);
}
orders = orders.ApplyOrdersPaging(request.Page, request.PageSize);
IEnumerable data = orders.ApplyOrdersGrouping(request.Groups);
var result = new DataSourceResult()
{
Data = data,
Total = total
};
return(Json(result));
}
public EmployeeDirectoryService(SampleEntitiesDataContext context)
{
db = context;
}
public JsonResult GetCascadeCategories()
{
var northwind = new SampleEntitiesDataContext();
return(Json(northwind.Categories.Select(c => new { CategoryId = c.CategoryID, CategoryName = c.CategoryName })));
}
public GanttAssignmentService(SampleEntitiesDataContext context)
{
db = context;
}
public ActionResult FilterMenuCustomization_Cities()
{
var db = new SampleEntitiesDataContext();
return(Json(db.Employees.Select(e => e.City).Distinct()));
}
public SchedulerMeetingService(SampleEntitiesDataContext context)
{
db = context;
}
public GanttDependencyService(SampleEntitiesDataContext context)
{
db = context;
}
public EmployeeDirectoryService(SampleEntitiesDataContext context)
{
db = context;
}
public SchedulerTaskService(SampleEntitiesDataContext context)
{
db = context;
}
public ProductRepository(SampleEntitiesDataContext db)
{
_db = db;
}
