// GET: Bil
public ActionResult Index()
{
var model = new ViewModels.BilIndexViewModel();
var db = new Models.DBContext();
model.Cars.AddRange(db.GetAll().Select(r => new ViewModels.BilIndexViewModel.BilListViewModel
{
Manufacturer = r.Manufacturer,
Model = r.Model,
Year = r.Year,
Id = r.Id
}));
return(View(model));
}
public ActionResult Search(string SearchManufacturer, string SearchYear)
{
var db = new Models.DBContext();
var model = new ViewModels.BilIndexViewModel
{
SearchManufacturer = SearchManufacturer,
SearchYear = SearchYear
};
model.Cars.AddRange(db.GetAll().Select(r => new ViewModels.BilIndexViewModel.BilListViewModel
{
Manufacturer = r.Manufacturer,
Model = r.Model,
Year = r.Year,
Id = r.Id
}).Where(c => Matches(c, SearchManufacturer, SearchYear)
));
return(View("Index", model));
}
// GET: Bil
public ActionResult Index(string sort)
{
var model = new ViewModels.BilIndexViewModel();
using (var db = new Models.BilModel2())
{
//var carsFromDB = db.Bilar.AsQueryable();
//if (sort == "NamnAsc")
// carsFromDB = carsFromDB.OrderBy(r => r.Manufacturer);
//else if (sort == "NamnDesc")
// carsFromDB = carsFromDB.OrderByDescending(r => r.Manufacturer);
//if (sort == "YearAsc")
// carsFromDB = carsFromDB.OrderBy(r => r.Year);
//else if (sort == "YearDesc")
// carsFromDB = carsFromDB.OrderByDescending(r => r.Year);
//model.Cars.AddRange(carsFromDB.Select( r => new ViewModels.BilIndexViewModel.BilListViewModel
//{
// Manufacturer = r.Manufacturer,
// Model = r.Model,
// Year = r.Year,
// Id = r.Id
//}));
model.Cars.AddRange(db.Bilar.Select(r => new ViewModels.BilIndexViewModel.BilListViewModel
{
Manufacturer = r.Manufacturer,
Model = r.Model,
Year = r.Year,
Id = r.Id
}));
if (sort == "NamnAsc")
{
model.Cars = model.Cars.OrderBy(r => r.Manufacturer).ToList();
}
else if (sort == "NamnDesc")
{
model.Cars = model.Cars.OrderByDescending(r => r.Manufacturer).ToList();
}
if (sort == "YearAsc")
{
model.Cars = model.Cars.OrderBy(r => r.Year).ToList();
}
else if (sort == "YearDesc")
{
model.Cars = model.Cars.OrderByDescending(r => r.Year).ToList();
}
model.CurrentSort = sort;
return(View(model));
}
}
