public int[] GetYears()
{
using (Forever16DBEntities DB = new Forever16DBEntities())
{
var query = from r in DB.Sales
select r.Date.Year;
return(query.Distinct().OrderBy(r => r).ToArray());
}
}
public ListItem[] GetProducts()
{
using (Forever16DBEntities DB = new Forever16DBEntities())
{
return(DB.Products
.Select(r => new ListItem()
{
Text = r.Name,
Value = r.Id
})
.OrderBy(r => r.Text)
.ToArray());
}
}
