public IEnumerable <Data.VehicleModel> GetModels() { using (var context = new VehicleTestContext()) { return(context.VehicleModels.Include(t => t.Make).OrderBy(t => t.Make.Make).ThenBy(t => t.ModelName).ToList()); } }
public Data.VehicleModel GetModel(int id) { using (var context = new VehicleTestContext()) { return(context.VehicleModels.Include(t => t.Make).SingleOrDefault(t => t.ModelId == id)); } }
public Data.VehicleMake GetMake(int id) { using (var context = new VehicleTestContext()) { return(context.VehicleMakes.SingleOrDefault(t => t.MakeId == id)); } }
public IEnumerable <Data.VehicleMake> GetMakes() { using (var context = new VehicleTestContext()) { return(context.VehicleMakes.OrderBy(t => t.Make).ToList()); } }
public void DeleteModel(int id) { using (var context = new VehicleTestContext()) { var oldModel = context.VehicleModels.Include(t => t.Make).SingleOrDefault(t => t.ModelId == id); context.VehicleModels.Remove(oldModel); context.SaveChanges(); } }
public void UpdateModel(Data.VehicleModel vehicleModel) { using (var context = new VehicleTestContext()) { var oldModel = context.VehicleModels.Include(t => t.Make).SingleOrDefault(t => t.ModelId == vehicleModel.ModelId); context.Entry(oldModel).CurrentValues.SetValues(vehicleModel); context.SaveChanges(); } }
public int AddModel(Data.VehicleModel vehicleModel) { using (var context = new VehicleTestContext()) { context.VehicleModels.Add(vehicleModel); context.SaveChanges(); return(vehicleModel.ModelId); } }
public void DeleteMake(int id) { using (var context = new VehicleTestContext()) { var oldMake = context.VehicleMakes.SingleOrDefault(t => t.MakeId == id); context.VehicleMakes.Remove(oldMake); context.SaveChanges(); } }
public void UpdateMake(Data.VehicleMake vehicleMake) { using (var context = new VehicleTestContext()) { var oldMake = context.VehicleMakes.SingleOrDefault(t => t.MakeId == vehicleMake.MakeId); context.Entry(oldMake).CurrentValues.SetValues(vehicleMake); context.SaveChanges(); } }
public int AddMake(Data.VehicleMake vehicleMake) { using (var context = new VehicleTestContext()) { context.VehicleMakes.Add(vehicleMake); context.SaveChanges(); return(vehicleMake.MakeId); } }