public long SavePhone(Phone phone)
{
var db = new SellPhoneDB();
db.phones.Add(phone);
return(db.SaveChanges());
}
public long SaveOrder(CustomerOrder order)
{
var db = new SellPhoneDB();
db.CustomerOrders.Add(order);
return(db.SaveChanges());
}
public List <CustomerOrder> GetAllCustomerOrders()
{
var db = new SellPhoneDB();
return((from p in db.CustomerOrders.Include("Customer")
select p).ToList());
}
public List <CustomerOrder> GetCustomerOrders(long customerID)
{
var db = new SellPhoneDB();
return((from p in db.CustomerOrders.Include("Customer")
where p.Customer.CustomerID == customerID
select p).ToList());
}
public long SaveOrderedPhone(OrdereredPhone orderPhone, long orderId)
{
var db = new SellPhoneDB();
CustomerOrder order = db.CustomerOrders.Find(orderId);
order.OrdereredPhones.Add(orderPhone);
return(db.SaveChanges());
}