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)); }