public void Delete(Customer customer)
{
using (var ctx = new MovieShopContextDB())
{
var customerDB = ctx.Customers.FirstOrDefault(item => item.Id == customer.Id);
ctx.Customers.Remove(customerDB);
ctx.SaveChanges();
}
}
public void Delete(Order order)
{
using (var ctx = new MovieShopContextDB())
{
var orderDB = ctx.Orders.ToList().FirstOrDefault(item => item.Id == order.Id);
ctx.Orders.Remove(orderDB);
ctx.SaveChanges();
}
}
public void Add(Order order)
{
using (var ctx = new MovieShopContextDB())
{
//Create the queries
ctx.Orders.Add(order);
//Execute the queries
ctx.SaveChanges();
}
}
public Movie Delete(Movie movie)
{
using (var ctx = new MovieShopContextDB())
{
var movieDB = ctx.Movies.FirstOrDefault(item => item.Id == movie.Id);
ctx.Movies.Remove(movieDB);
ctx.SaveChanges();
return movie;
}
}
public Genre Delete(Genre genre)
{
using (var ctx = new MovieShopContextDB())
{
var genreDB = ctx.Genres.FirstOrDefault(item => item.Id == genre.Id);
ctx.Genres.Remove(genreDB);
ctx.SaveChanges();
return genre;
}
}
public void Add(Customer customer)
{
using (var ctx = new MovieShopContextDB())
{
//Create the queries
ctx.Customers.Add(customer);
//Execute the queries
ctx.SaveChanges();
}
}
public void Update(Order order)
{
using (var ctx = new MovieShopContextDB())
{
var orderDB = ctx.Orders.ToList().FirstOrDefault(item => item.Id == order.Id);
orderDB.Customer = order.Customer;
orderDB.Date = order.Date;
ctx.SaveChanges();
}
}
public Genre Update(Genre genre)
{
using (var ctx = new MovieShopContextDB())
{
var genreDB = ctx.Genres.FirstOrDefault(item => item.Id == genre.Id);
genreDB.Name = genre.Name;
genreDB.Movies = genre.Movies;
ctx.SaveChanges();
return genre;
}
}
public void Add(Adress address)
{
using (var ctx = new MovieShopContextDB())
{
//Create the queries
ctx.Adresses.Add(address);
//Execute the queries
ctx.SaveChanges();
}
}
public Movie Add(Movie movie)
{
using (var ctx = new MovieShopContextDB())
{
ctx.Genres.Attach(movie.Genre);
//Create the queries
ctx.Movies.Add(movie);
//Execute the queries
ctx.SaveChanges();
return movie;
}
}
public Genre Add(Genre genre)
{
using (var ctx = new MovieShopContextDB())
{
//Create the queries
ctx.Genres.Add(genre);
//Execute the queries
ctx.SaveChanges();
return genre;
}
}
public void Update(Customer customer)
{
using (var ctx = new MovieShopContextDB())
{
var customerDB = ctx.Customers.FirstOrDefault(item => item.Id == customer.Id);
customerDB.FirstName = customer.FirstName;
customerDB.LastName = customer.LastName;
customerDB.Email = customer.Email;
customerDB.Adress = ctx.Adresses.FirstOrDefault(item => item.Id == customer.Adress.Id);
ctx.SaveChanges();
}
}
public void Update(Adress address)
{
using (var ctx = new MovieShopContextDB())
{
var addressDB = ctx.Adresses.FirstOrDefault(item => item.Id == address.Id);
addressDB.StreetName = address.StreetName;
addressDB.StreetNumber = address.StreetNumber;
addressDB.Zipcode = address.Zipcode;
addressDB.Country = address.Country;
ctx.SaveChanges();
}
}
public Movie Update(Movie movie)
{
using (var ctx = new MovieShopContextDB())
{
var movieDB = ctx.Movies.FirstOrDefault(item => item.Id == movie.Id);
movieDB.Genre = ctx.Genres.FirstOrDefault(item => item.Id == movie.Genre.Id);
movieDB.imageURL = movie.imageURL;
movieDB.Price = movie.Price;
movieDB.Title = movie.Title;
movieDB.trailerURL = movie.trailerURL;
movieDB.Year = movie.Year;
ctx.SaveChanges();
return movie;
}
}
