// GET: Information
public ActionResult Index()
{
var information = db.Information.ToList();
List <InformationView> model = new List <InformationView>();
foreach (var item in information)
{
InformationView driver = new InformationView();
driver.MapDataToViewModel(item);
model.Add(driver);
}
return(View(model.OrderBy(s => s.FillUpDate)));
}
public ActionResult Index(string searchName, string searchModel, DateTime?startDate, DateTime?endDate)
{
var information = from m in db.Information.ToList() select m;
List <InformationView> model = new List <InformationView>();
foreach (var item in information)
{
InformationView driver = new InformationView();
driver.MapDataToViewModel(item);
model.Add(driver);
}
var fueler = from f in model select f;
if (startDate != null)
{
fueler = fueler.Where(s => s.FillUpDate >= startDate);
}
if (endDate != null)
{
fueler = fueler.Where(s => s.FillUpDate <= endDate);
}
if (!string.IsNullOrEmpty(searchModel))
{
fueler = fueler.Where(s => s.CarModel.ToLower().Contains(searchModel.ToLower()));
}
if (!string.IsNullOrEmpty(searchName))
{
fueler = fueler.Where(s => s.LName.ToLower().Contains(searchName.ToLower()) || s.FName.ToLower().Contains(searchName.ToLower()));
}
try
{
ViewBag.AverageMPG = Math.Round(fueler.Average(s => s.MilesPerGallon), 2);
}
catch (Exception)
{
ViewBag.AverageMPG = 0;
}
return(View(fueler.OrderByDescending(s => s.FillUpDate).ThenBy(s => s.LName).ThenBy(s => s.CarModel)));
}
// GET: Information2
public ActionResult Index()
{
var information = from m in db.Information.ToList() select m;
List <InformationView> model = new List <InformationView>();
foreach (var item in information)
{
InformationView driver = new InformationView();
driver.MapDataToViewModel(item);
model.Add(driver);
}
try
{
ViewBag.AverageMPG = Math.Round(model.Average(s => s.MilesPerGallon), 2);
}
catch (Exception)
{
ViewBag.AverageMPG = 0;
}
return(View(model.OrderByDescending(s => s.FillUpDate).ThenBy(s => s.LName).ThenBy(s => s.CarModel)));
}