public List <Order> Read()
{
using (var db = new MovieShopContext())
{
return(db.Orders.Include("Customer").ToList());
}
}
public Address Read(int id)
{
using (var db = new MovieShopContext())
{
return(db.Addresses.FirstOrDefault(x => x.Id == id));
}
}
public Genre Read(int id)
{
using (var db = new MovieShopContext())
{
return(db.Genres.FirstOrDefault(x => x.GenreId == id));
}
}
public IEnumerable <Order> ReadAll()
{
using (var ctx = new MovieShopContext())
{
return(ctx.Orders.Include(x => x.Customer).ToList());
}
}
protected override List <Customer> ReadAll(MovieShopContext movieShopContext)
{
return(movieShopContext.Set <Customer>()
.Include(x => x.Order)
.Include(x => x.Address)
.ToList());
}
public List <Order> GetAll()
{
using (var db = new MovieShopContext())
{
return(db.Orders.Include("Customers").Include("Movies").ToList());
}
}
protected override List <Movie> ReadAll(MovieShopContext movieShopContext)
{
return(movieShopContext.Set <Movie>()
.Include(x => x.Genre)
.Include(x => x.Orders)
.ToList());
}
public IEnumerable <Customer> ReadAll()
{
using (var ctx = new MovieShopContext())
{
return(ctx.Customers.ToList());
}
}
public Customer ReadById(int Id)
{
using (var ctx = new MovieShopContext())
{
return(ctx.Customers.FirstOrDefault(cust => cust.Id == Id));
}
}
IEnumerable <Movie> IRepository <Movie> .ReadAll()
{
using (var ctx = new MovieShopContext())
{
return(ctx.Movies.Include("Genre").ToList());
}
}
public Movie ReadById(int Id)
{
using (var ctx = new MovieShopContext())
{
return(ctx.Movies.Include("Genre").FirstOrDefault(x => x.Id == Id));
}
}
/// <summary>
///
/// </summary>
/// <returns></returns>
public List <Movie> ReadAll()
{
using (var ctx = new MovieShopContext())
{
return(ctx.Movies.Include("Genres").ToList());
}
}
public List <Customer> Read()
{
using (var db = new MovieShopContext())
{
return(db.Customers.Include("Address").ToList());
}
}
public Customer Read(int id)
{
using (var db = new MovieShopContext())
{
return(db.Customers.Include("Address").FirstOrDefault(x => x.CustomerId == id));
}
}
public Customer Read(int id)
{
using (dbContext = new MovieShopContext())
{
return(dbContext.Customers.Include("Orders").Include("Address").FirstOrDefault(x => x.Id == id));
}
}
public Customer ReadByEmail(string Email)
{
using (var ctx = new MovieShopContext())
{
return(ctx.Customers.FirstOrDefault(cust => cust.Email.Equals(Email)));
}
}
public List <Customer> ReadAll()
{
using (dbContext = new MovieShopContext())
{
return(dbContext.Customers.Include("Address").ToList());
}
}
public Genre Get(int id)
{
using (var ctx = new MovieShopContext())
{
return(ctx.Genres.FirstOrDefault(x => x.ID == id));
}
}
public Order Get(int id)
{
using (var db = new MovieShopContext())
{
return(db.Orders.FirstOrDefault(x => x.ID == id));
}
}
public List <Genre> GetAll()
{
using (var ctx = new MovieShopContext())
{
return(ctx.Genres.ToList());
}
}
protected override Movie ReadOne(int id, MovieShopContext movieShopContext)
{
return(movieShopContext.Set <Movie>()
.Include(x => x.Genre)
.Include(x => x.Orders)
.FirstOrDefault(x => x.Id == id));
}
public Order Read(int id)
{
using (dbContext = new MovieShopContext())
{
return(dbContext.Orders.Include("Customer").Include("Movie").FirstOrDefault(x => x.Id == id));
}
}
public Order ReadById(int Id)
{
using (var ctx = new MovieShopContext())
{
return(ctx.Orders.FirstOrDefault(order => order.Id == Id));
}
}
public List <Order> ReadAll()
{
using (dbContext = new MovieShopContext())
{
return(dbContext.Orders.Include("Customer").Include("Movie").ToList());
}
}
protected override Customer ReadOne(int id, MovieShopContext movieShopContext)
{
return(movieShopContext.Set <Customer>()
.Include(x => x.Order)
.Include(x => x.Address)
.FirstOrDefault(x => x.Id == id));
}
public IEnumerable <Genre> ReadAll()
{
using (var ctx = new MovieShopContext())
{
return(ctx.Genres.ToList());
}
}
public List <Address> Read()
{
using (var db = new MovieShopContext())
{
return(db.Addresses.ToList());
}
}
public Genre ReadById(int Id)
{
using (var ctx = new MovieShopContext())
{
return(ctx.Genres.Where(ge => ge.Id == Id).FirstOrDefault());
}
}
public List <Genre> Read()
{
using (var db = new MovieShopContext())
{
return(db.Genres.ToList());
}
}
public Order Create(Order t)
{
using (var db = new MovieShopContext())
{
t.Customer = db.Customers.Include(x => x.Address).FirstOrDefault(x => x.CustomerId == t.Customer.CustomerId);
var tmpList = new List <Movie>();
foreach (var movie in db.Movies)
{
foreach (var moviesToBuy in t.Movies)
{
if (movie.Title == moviesToBuy.Title)
{
tmpList.Add(movie);
}
}
}
t.Movies = tmpList;
db.Orders.Add(t);
db.SaveChanges();
return(t);
}
}
