private void StatesByYear_Load(System.Object sender, System.EventArgs e)
{
// ----- Perform the lookup.
using (SalesOrderEntities context = new SalesOrderEntities(General.GetConnectionString()))
{
}
}
private void StatesByYear_Load(System.Object sender, System.EventArgs e)
{
// ----- Perform the lookup.
using (SalesOrderEntities context = new SalesOrderEntities(General.GetConnectionString()))
{
var result = from st in context.StateRegions
orderby st.Admitted
select new
{
StateName = st.FullName,
AdmitYear = SqlFunctions.DatePart("year", st.Admitted),
TotalAdmittedInYear = AdmittedInYear(st.Admitted)
};
StateAdmittance.DataSource = result.ToList();
}
}
private void OrderViewer_Load(System.Object sender, System.EventArgs e)
{
// ----- Open the context to the set of customer orders.
OrderContext = new SalesOrderEntities(General.GetConnectionString());
}