public void AddTestRide(Business.Model.TestRide testride) { using (var db = new BikeShopContext()) { var dbEntity = Business.Model.TestRide.ToDataEntity(testride); // Create and save a new TestRide db.TestRides.Add(dbEntity); db.SaveChanges(); } }
public void AddBikeAccessoryMap(Business.Model.BikeAccessoryMap bikeAccessoryMap) { using (var db = new BikeShopContext()) { // Create and save a new BikeAccessoryMap db.BikeAccessoryMap.Add(new Data.Model.BikeAccessoryMap { BikeId = bikeAccessoryMap.BikeId }); db.SaveChanges(); } }
public void AddOrder(Business.Model.Order order) { using (var db = new BikeShopContext()) { // Create and save a new Order var dbEntity = Business.Model.Order.ToDataEntity(order); db.Orders.Add(dbEntity); db.SaveChanges(); } }
public void AddAccessory(Business.Model.Accessory accessory) { using (var db = new BikeShopContext()) { // Create and save a new Accessory db.Accessories.Add(new Data.Model.Accessory { Name = accessory.Name }); db.SaveChanges(); } }
public void AddEngine(Business.Model.Engine engine) { using (var db = new BikeShopContext()) { // Create and save a new Engine db.Engines.Add(new Data.Model.Engine { Name = engine.Name }); db.SaveChanges(); } }
public void AddBike(Business.Model.Bike bike) { using (var db = new BikeShopContext()) { // Create and save a new Bike db.Bikes.Add(new Data.Model.Bike { Model = bike.Model }); db.SaveChanges(); } }
public void AddUser(Business.Model.User user) { using (var db = new BikeShopContext()) { // Create and save a new User db.Users.Add(new Data.Model.User { Name = user.Name, AccessKey = user.AccessKey }); db.SaveChanges(); } }
public void AddBattery(Business.Model.Battery battery) { using (var db = new BikeShopContext()) { // Create and save a new Battery db.Batteries.Add(new Data.Model.Battery { Model = battery.Model }); db.SaveChanges(); } }
public List <Business.Model.Order> GetOrdersForUser(string userId) { var orders = new List <Data.Model.Order>(); using (var db = new BikeShopContext()) { // Display all Orders from the database orders = (from b in db.Orders.Include(o => o.Bike) where b.UserId == userId orderby b.Id select b).ToList(); } return(orders.Select(b => Data.Model.Order.ToBusiness(b)).ToList()); }
public Business.Model.Bike GetBike(int id) { var bike = new Data.Model.Bike(); using (var db = new BikeShopContext()) { // Display all Bikes from the database bike = (from b in db.Bikes where b.Id == id orderby b.Model select b).FirstOrDefault(); } return(Data.Model.Bike.ToBusiness(bike)); }
public List <Business.Model.BikeAccessoryMap> GetBikeAccessoryMaps() { var bikeAccessoryMaps = new List <Data.Model.BikeAccessoryMap>(); using (var db = new BikeShopContext()) { // Display all BikeAccessoryMaps from the database bikeAccessoryMaps = (from b in db.BikeAccessoryMap orderby b.BikeId select b).ToList(); Console.WriteLine("All bikeAccessoryMaps in the database:"); foreach (var item in bikeAccessoryMaps) { Console.WriteLine(item.BikeId); } } return(bikeAccessoryMaps.Select(b => Data.Model.BikeAccessoryMap.ToBusiness(b)).ToList()); }
public List <Business.Model.Accessory> GetBikes() { var accessory = new List <Data.Model.Accessory>(); using (var db = new BikeShopContext()) { // Display all Accessories from the database accessory = (from b in db.Accessories orderby b.Name select b).ToList(); Console.WriteLine("All accessories in the database:"); foreach (var item in accessory) { Console.WriteLine(item.Name); } } return(accessory.Select(b => Data.Model.Accessory.ToBusiness(b)).ToList()); }
public List <Business.Model.Engine> GetEngines() { var engines = new List <Data.Model.Engine>(); using (var db = new BikeShopContext()) { // Display all Engines from the database engines = (from b in db.Engines orderby b.Name select b).ToList(); Console.WriteLine("All engines in the database:"); foreach (var item in engines) { Console.WriteLine(item.Name); } } return(engines.Select(b => Data.Model.Engine.ToBusiness(b)).ToList()); }
public List <Business.Model.User> GetUsers() { var users = new List <Data.Model.User>(); using (var db = new BikeShopContext()) { // Display all Users from the database users = (from b in db.Users orderby b.Name select b).ToList(); Console.WriteLine("All users in the database:"); foreach (var item in users) { Console.WriteLine(item.Name); } } return(users.Select(b => Data.Model.User.ToBusiness(b)).ToList()); }
public List <Business.Model.Battery> GetBatteries() { var batteries = new List <Data.Model.Battery>(); using (var db = new BikeShopContext()) { // Display all Batteries from the database batteries = (from b in db.Batteries orderby b.Model select b).ToList(); Console.WriteLine("All batteries in the database:"); foreach (var item in batteries) { Console.WriteLine(item.Model); } } return(batteries.Select(b => Data.Model.Battery.ToBusiness(b)).ToList()); }
public List <Business.Model.TestRide> GetTestRidesForUser(string accessKey) { var testrides = new List <Data.Model.TestRide>(); using (var db = new BikeShopContext()) { // Display all TestRides from the database testrides = (from b in db.TestRides.Include(p => p.Bike) where b.UserId == accessKey orderby b.Id select b).ToList(); foreach (var item in testrides) { Console.WriteLine(item.Id); } } return(testrides.Select(b => Data.Model.TestRide.ToBusiness(b)).ToList()); }