public List <Car> GetCarsbyMakeandModel(string make, string model)
{
GCCarsDBEntities ORM = new GCCarsDBEntities();
List <Car> CarsbyMake = ORM.Cars.Where(c => c.Make.Contains(make)).ToList();
return(CarsbyMake.Where(c => c.Model.Contains(model)).ToList());
}
public List <Car> GetCarsByColorandYear(string color, string year)
{
GCCarsDBEntities ORM = new GCCarsDBEntities();
List <Car> CarsbyColor = ORM.Cars.Where(c => c.Color.Contains(color)).ToList();
return(CarsbyColor.Where(c => c.Year.Contains(year)).ToList());
}
public List <Car> GetCarsByColor(string color)
{
//lists all cars of a certain color
GCCarsDBEntities ORM = new GCCarsDBEntities();
return(ORM.Cars.Where(c => c.Color.Contains(color)).ToList());
}
public List <Car> GetCarsByModel(string model)
{
//lists all cars of a certain model
GCCarsDBEntities ORM = new GCCarsDBEntities();
return(ORM.Cars.Where(c => c.Model.Contains(model)).ToList());
}
public List <Car> GetAllCars()
{
//lists all cars in the Database
GCCarsDBEntities ORM = new GCCarsDBEntities();
return(ORM.Cars.ToList());
}
public List <Car> GetCarInformation(string make, string model, string color, string year)
{
GCCarsDBEntities ORM = new GCCarsDBEntities();
List <Car> CarsbyMake = ORM.Cars.Where(c => c.Make.Contains(make)).ToList();
List <Car> CarsbyMakeAndModel = CarsbyMake.Where(c => c.Model.Contains(model)).ToList();
List <Car> CarsbyMakeAndModelAndColor = CarsbyMakeAndModel.Where(c => c.Color.Contains(color)).ToList();
return(CarsbyMakeAndModelAndColor.Where(c => c.Year.Contains(year)).ToList());
}
public List <string> ListofModels()
{
GCCarsDBEntities ORM = new GCCarsDBEntities();
return(ORM.Cars.Select(c => c.Model).Distinct().ToList());
}
public List <Car> GetCarsByYear(string year)
{
GCCarsDBEntities ORM = new GCCarsDBEntities();
return(ORM.Cars.Where(c => c.Year.Contains(year)).ToList());
}
public List <Car> GetCarsByMake(string make)
{
GCCarsDBEntities ORM = new GCCarsDBEntities();
return(ORM.Cars.Where(c => c.Make.Contains(make)).ToList());
}
