public int CarsCount()
{
DealershipEntities db = new DealershipEntities();
List <Car> Cars = db.Cars.ToList();
int carcount = Cars.Count();
return(carcount);
}
public List <Car> Make(string make)
{
DealershipEntities db = new DealershipEntities();
List <Car> Cars = db.Cars.ToList();
List <Car> CarMakeList = (from p in db.Cars
where p.Make.Contains(make)
select p).ToList();
return(CarMakeList);
}
public List <Car> Color(string color)
{
DealershipEntities db = new DealershipEntities();
List <Car> Cars = db.Cars.ToList();
List <Car> CarWColorList = (from p in db.Cars
where p.Color.Contains(color)
select p).ToList();
return(CarWColorList);
}
public List <Car> Year(int?year)
{
DealershipEntities db = new DealershipEntities();
List <Car> Cars = db.Cars.ToList();
List <Car> CarYearList = (from p in db.Cars
where p.Year == year
select p).ToList();
return(CarYearList);
}
public List <Car> Car(int?id)
{
DealershipEntities db = new DealershipEntities();
List <Car> CarIDList = new List <Car>();
try
{
List <Car> Cars = db.Cars.ToList();
CarIDList = (from p in db.Cars
where p.ID == id
select p).ToList();
}
catch
{
Exception e;
}
return(CarIDList);
}
