public Customer Get(int id)
{
using (var db = new EsbjergCityContext())
{
return(db.Customers.Include(x => x.Orders.Select(y => y.GiftCards)).FirstOrDefault(x => x.Id == id));
}
}
public bool Delete(Customer t)
{
using (var db = new EsbjergCityContext())
{
var customer = db.Customers.Include(x => x.Orders.Select(y => y.GiftCards)).FirstOrDefault(x => x.Id == t.Id);
var orders = customer.Orders.ToList();
var giftCards = customer.Orders.SelectMany(x => x.GiftCards).ToList();
if (giftCards.Count != 0)
{
foreach (var giftCard in giftCards)
{
db.Entry(giftCard).State = EntityState.Deleted;
}
}
if (orders.Count != 0)
{
foreach (var order in orders)
{
db.Entry(order).State = EntityState.Deleted;
}
}
db.Entry(customer).State = EntityState.Deleted;
db.SaveChanges();
return(db.Orders.FirstOrDefault(x => x.Id == t.Id) == null);
}
}
public List <Customer> GetAll()
{
using (var db = new EsbjergCityContext())
{
return(db.Customers.Include(x => x.Orders.Select(y => y.GiftCards)).ToList());
}
}
public Order Get(int id)
{
using (var db = new EsbjergCityContext())
{
return(db.Orders.Include("GiftCards").FirstOrDefault(x => x.Id == id));
}
}
public GiftCard GetByCardNumber(string cardNumber)
{
using (var db = new EsbjergCityContext())
{
return(db.GiftCards.FirstOrDefault(x => x.CardNumber == cardNumber));
}
}
public List <GiftCard> GetAll()
{
using (var db = new EsbjergCityContext())
{
return(db.GiftCards.ToList());
}
}
public GiftCard Get(int id)
{
using (var db = new EsbjergCityContext())
{
return(db.GiftCards.FirstOrDefault(x => x.Id == id));
}
}
public List <Event> GetAll()
{
using (var db = new EsbjergCityContext())
{
return(db.Events.ToList());
}
}
public Event Get(int id)
{
using (var db = new EsbjergCityContext())
{
return(db.Events.FirstOrDefault(x => x.Id == id));
}
}
public List <Order> GetAll()
{
using (var db = new EsbjergCityContext())
{
return(db.Orders.Include("GiftCards").ToList());
}
}
public Customer GetByEmail(string email)
{
using (var db = new EsbjergCityContext())
{
return(db.Customers.FirstOrDefault(x => x.Email == email));
}
}
public Customer Update(Customer t)
{
using (var db = new EsbjergCityContext())
{
db.Entry(t).State = EntityState.Modified;
db.SaveChanges();
return(t);
}
}
public GiftCard Create(GiftCard t)
{
using (var db = new EsbjergCityContext())
{
db.GiftCards.Add(t);
db.SaveChanges();
return(t);
}
}
public Customer Create(Customer t)
{
using (var db = new EsbjergCityContext())
{
db.Customers.Add(t);
db.SaveChanges();
return(t);
}
}
public Event Create(Event t)
{
using (var db = new EsbjergCityContext())
{
db.Events.Add(t);
db.SaveChanges();
return(t);
}
}
public Event Update(Event t)
{
using (var db = new EsbjergCityContext())
{
db.Entry(t).State = System.Data.Entity.EntityState.Modified;
db.SaveChanges();
return(t);
}
}
public bool Delete(Event t)
{
using (var db = new EsbjergCityContext())
{
db.Entry(t).State = System.Data.Entity.EntityState.Deleted;
db.SaveChanges();
return(true);
}
}
public bool Delete(Order t)
{
using (var db = new EsbjergCityContext())
{
var order = db.Orders.Include("GiftCards").FirstOrDefault(x => x.Id == t.Id);
foreach (var giftcard in order.GiftCards.ToList())
{
db.Entry(giftcard).State = EntityState.Deleted;
}
db.Entry(order).State = System.Data.Entity.EntityState.Deleted;
db.SaveChanges();
return(db.Orders.FirstOrDefault(x => x.Id == t.Id) == null);
}
}
public Order Update(Order t)
{
using (var db = new EsbjergCityContext())
{
var orderToUpdate = db.Orders.Include("GiftCards").FirstOrDefault(x => x.Id == t.Id);
if (orderToUpdate != null)
{
orderToUpdate.DateOfPurchase = t.DateOfPurchase;
orderToUpdate.IsCompleted = t.IsCompleted;
}
db.SaveChanges();
return(t);
}
}
public Order Create(Order t)
{
using (var db = new EsbjergCityContext())
{
db.Customers.Attach(t.Customer);
List <GiftCard> giftCards = new List <GiftCard>();
foreach (var i in t.GiftCards)
{
giftCards.Add(i);
}
t.GiftCards = giftCards;
db.Orders.Add(t);
db.SaveChanges();
return(t);
}
}
