public static IList<CustomerModel> All()
{
IList<CustomerModel> result = HttpContext.Current.Session["Customers"] as IList<CustomerModel>;
if (result == null)
{
HttpContext.Current.Session["Customers"] = result = new SampleDataContext().Customers.Select(c => new CustomerModel
{
CustomerID = c.CustomerID,
ContactName = c.ContactName,
CompanyName = c.CompanyName,
}).ToList();
}
return result;
}
public static IList<WeatherModel> ByMonth(string station, int year, int month)
{
var sessionKey = "w_byMonth_" + station + year + month;
var result = HttpContext.Current.Session[sessionKey] as IList<WeatherModel>;
if (result == null)
{
using (var db = new SampleDataContext()) {
HttpContext.Current.Session[sessionKey] = result =
ByStation(station)
.Where(w => w.Date.Year == year && w.Date.Month == month)
.ToList();
}
}
return result;
}
public static IList<OrderModel> All()
{
IList<OrderModel> result = HttpContext.Current.Session["Orders"] as IList<OrderModel>;
if (result == null)
{
HttpContext.Current.Session["Customers"] = result = new SampleDataContext().Orders.Select(c => new OrderModel
{
OrderID = c.OrderID,
ShipName = c.ShipName,
ShipCity = c.ShipCity,
ShipCountry = c.ShipCountry
}).ToList();
}
return result;
}
public static IList<EmployeeModel> All()
{
IList<EmployeeModel> result = HttpContext.Current.Session["Employees"] as IList<EmployeeModel>;
if (result == null)
{
HttpContext.Current.Session["Employees"] = result = new SampleDataContext().Employees.Select(e => new EmployeeModel
{
EmployeeId = e.EmployeeID,
FullName = e.FirstName + " " + e.LastName,
ReportsTo = e.ReportsTo,
HasEmployees = e.Employees.Count > 0
}).ToList();
}
return result;
}
public static IList<EmployeeCompleteModel> AllComplete()
{
IList<EmployeeCompleteModel> result = HttpContext.Current.Session["EmployeesComplete"] as IList<EmployeeCompleteModel>;
if (result == null)
{
HttpContext.Current.Session["EmployeesComplete"] = result = new SampleDataContext().Employees.Select(m => new EmployeeCompleteModel {
FirstName = m.FirstName,
LastName = m.LastName,
Country = m.Country,
City = m.City,
Title = m.Title
}).ToList();
}
return result;
}
public static IList<ProductModel> All()
{
var result = HttpContext.Current.Session["Products"] as IList<ProductModel>;
if (result == null)
{
HttpContext.Current.Session["Products"] = result =
new SampleDataContext().Products.Select(p => new ProductModel
{
ProductID = p.ProductID,
ProductName = p.ProductName,
UnitPrice = (double)p.UnitPrice.GetValueOrDefault(),
UnitsInStock = p.UnitsInStock.GetValueOrDefault(),
Discontinued = p.Discontinued
}).ToList();
}
return result;
}
public static IList<WeatherModel> ByStation(string station)
{
var sessionKey = "w_byStation_" + station;
var result = HttpContext.Current.Session[sessionKey] as IList<WeatherModel>;
if (result == null)
{
HttpContext.Current.Session[sessionKey] = result =
new SampleDataContext().Weather.Select(w => new WeatherModel
{
Date = w.Date,
TMax = w.TMax,
TMin = w.TMin,
Rain = w.Rain,
Wind = w.Wind
}).ToList();
}
return result;
}
public IEnumerable<ProductSignalR> Read()
{
var products = HttpContext.Current.Cache["products"] as IEnumerable<ProductSignalR>;
if (products == null)
{
using (var context = new SampleDataContext())
{
var createdAt = DateTime.Now;
products = context.Products
.OrderBy(p => p.ProductName)
.ToList() // Execute the query because Linq to SQL doesn't get Guid.NewGuid()
.Select(p => new ProductSignalR
{
ID = Guid.NewGuid(),
ProductName = p.ProductName,
UnitPrice = (double)p.UnitPrice.GetValueOrDefault(),
UnitsInStock = p.UnitsInStock.GetValueOrDefault(),
CreatedAt = createdAt = createdAt.AddMilliseconds(1)
})
.ToList();
}
HttpContext.Current.Cache.Add("products",
products,
null,
Cache.NoAbsoluteExpiration,
TimeSpan.FromMinutes(30),
System.Web.Caching.CacheItemPriority.Normal,
null
);
}
return products;
}
