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