public List<Adress> ReadAll()
{
using (var ctx = new MovieShopContextDB())
{
return ctx.Adresses.ToList();
}
}
public List<Order> ReadAll()
{
using (var ctx = new MovieShopContextDB())
{
return ctx.Orders.Include("Customer").Include("Movie").ToList();
}
}
public Adress Read(int addressID)
{
using (var ctx = new MovieShopContextDB())
{
return ctx.Adresses.FirstOrDefault(item => item.Id == addressID);
}
}
public Order Read(int orderID)
{
using (var ctx = new MovieShopContextDB())
{
return ctx.Orders.Include("Movie").Include("Customer").ToList().FirstOrDefault(item => item.Id == orderID);
}
}
public Movie Read(int movieId)
{
using (var ctx = new MovieShopContextDB())
{
return ctx.Movies.Include("Genre").FirstOrDefault(item => item.Id == movieId);
}
}
public List<Movie> ReadAll(bool asc = true)
{
using (var ctx = new MovieShopContextDB())
{
return ctx.Movies.Include("Genre").ToList();
}
}
public Customer Read(int customerID)
{
using (var ctx = new MovieShopContextDB())
{
return ctx.Customers.Include("Adress").FirstOrDefault(item => item.Id == customerID);
}
}
public Genre Read(int genreID)
{
using (var ctx = new MovieShopContextDB())
{
return ctx.Genres.FirstOrDefault(item => item.Id == genreID);
}
}
public List<Genre> ReadAll(bool asc = true)
{
using (var ctx = new MovieShopContextDB())
{
return ctx.Genres.ToList();
}
}
public void Delete(Adress address)
{
using (var ctx = new MovieShopContextDB())
{
var addressDB = ctx.Adresses.FirstOrDefault(item => item.Id == address.Id);
ctx.Adresses.Remove(addressDB);
}
}
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 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 void Add(Order order)
{
using (var ctx = new MovieShopContextDB())
{
//Create the queries
ctx.Orders.Add(order);
//Execute the queries
ctx.SaveChanges();
}
}
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 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(Customer customer)
{
using (var ctx = new MovieShopContextDB())
{
//Create the queries
ctx.Customers.Add(customer);
//Execute the queries
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 List<Customer> ReadAll(bool asc = true)
{
using (var ctx = new MovieShopContextDB())
{
if (asc)
{
return ctx.Customers.Include("Adress").OrderBy(x => x.FirstName).ToList();
}
return ctx.Customers.Include("Adress").OrderByDescending(x => x.FirstName).ToList();
}
}
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 void Add(Adress address)
{
using (var ctx = new MovieShopContextDB())
{
//Create the queries
ctx.Adresses.Add(address);
//Execute the queries
ctx.SaveChanges();
}
}
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 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 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 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 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;
}
}
