public static List <Customer> GetAllCustomers()
{
HondaDBContext context = new HondaDBContext();
return(context.Customers
.OrderBy(c => c.LastName)
.ToList());
}
public static List <Vehicle> GetAllVehicles()
{
HondaDBContext context = new HondaDBContext();
return(context.Vehicles
.OrderBy(c => c.Model)
.ToList());
}
public static void Delete(int id)
{
var context = new HondaDBContext();
Customer c = context.Customers.Find(id);
context.Customers.Remove(c);
context.SaveChanges();
}
public static void AddCustomer(Customer c)
{
//create db
HondaDBContext context = new HondaDBContext();
//add customer c to database
context.Customers.Add(c);
//save changes
context.SaveChanges();
}
public static List <Vehicle> GetVehiclesByMileage(int mileage)
{
HondaDBContext context = new HondaDBContext();
List <Vehicle> vehicles = (from v in context.Vehicles
where v.Mileage < mileage
select v).ToList();
return(vehicles);
}
public static List <Vehicle> GetVehiclesByPrice(double lowPrice, double highPrice)
{
HondaDBContext context = new HondaDBContext();
List <Vehicle> vehicles = (from v in context.Vehicles
where v.Price <= highPrice && v.Price >= lowPrice
select v).ToList();
return(vehicles);
}
public static List <Vehicle> GetVehiclesByYear(int year)
{
HondaDBContext context = new HondaDBContext();
List <Vehicle> vehicles = (from v in context.Vehicles
where v.Year == year
select v).ToList();
return(vehicles);
}
public static List <Vehicle> GetVehiclesByModel(string model)
{
HondaDBContext context = new HondaDBContext();
List <Vehicle> vehicles = (from v in context.Vehicles
where v.Model == model
select v).ToList();
return(vehicles);
}
/// <summary>
/// adds a Vehical Object to the dataBase
/// </summary>
/// <param name="v"></param>
public static void AddVehicle(Vehicle v)
{
//creates db context
HondaDBContext context = new HondaDBContext();
//adds the the object to database
context.Vehicles.Add(v);
//saves the changes
context.SaveChanges();
}
//public static bool CheckForCustomerID(int id)
//{
// HondaDBContext context = new HondaDBContext();
// try
// {
// context.Customers.Find(id);
// }
//}
public static void Update(Customer c)
{
HondaDBContext context = new HondaDBContext();
//tell EF this product has only been modified
//its already in the db
context.Entry(c).State = EntityState.Modified;
//sends update query to the database
context.SaveChanges();
}
public static Customer GetCustomer(int id)
{
HondaDBContext context = new HondaDBContext();
return(context.Customers.Find(id));
}
public static Vehicle GetVehicle(int id)
{
HondaDBContext context = new HondaDBContext();
return(context.Vehicles.Find(id));
}
