public IEnumerable<OrderMovie> GetAllOrderMoviesByOrder(Order item) { using (Context mCon = new Context()) { return mCon.OrderMovie.Include("Movie.Genres").Include("Order").Where(x => x.Order.Id == item.Id).ToList(); } }
public Movie GetMovieByOrderMovie(OrderMovie item) { using (Context mCon = new Context()) { return mCon.OrderMovie.Include("Movie.Genres").Include("Order").Where(x => x.Id == item.Id).FirstOrDefault().Movie; } }
public IEnumerable<OrderMovie> GetAll() { using (Context mCon = new Context()) { return mCon.OrderMovie.Include("Order").Include("Movie.Genres").ToList(); } }
public IEnumerable<Movie> GetAll() { using (Context mCon = new Context()) { return mCon.Movies.Include("Genres").ToList(); } }
public Genre Get(int id) { using (Context mCon = new Context()) { return mCon.Genres.FirstOrDefault(x => x.Id == id); } }
public IEnumerable<Login> GetAll() { using (Context mCon = new Context()) { return mCon.Login.Include("Customer").ToList(); } }
public Order Get(int id) { using (Context mCon = new Context()) { return mCon.Orders.Include("OrderMovie").Include("Customer").FirstOrDefault(x => x.Id == id); } }
public OrderMovie Get(int id) { using (Context mCon = new Context()) { return mCon.OrderMovie.Include("Order").Include("Movie.Genres").FirstOrDefault(x => x.Id == id); } }
public IEnumerable<Genre> GetAll() { using (Context mCon = new Context()) { return mCon.Genres.ToList(); } }
public Login Get(String username) { using (Context mCon = new Context()) { return mCon.Login.Include("Customer").FirstOrDefault(x => x.Username == username); } }
public IEnumerable<Order> GetAll() { using (Context mCon = new Context()) { return mCon.Orders.Include("OrderMovie").Include("Customer").ToList(); } }
public Movie Get(int id) { using (Context mCon = new Context()) { return mCon.Movies.Include("Genres").FirstOrDefault(x => x.Id == id); } }
public Movie Add(Movie item) { if (item == null) throw new ArgumentNullException("movie is null"); if (item.Name == null) throw new ArgumentException("FirstName can not be null"); using (Context mCon = new Context()) { if (item.Genres.Count > 0) { List<Genre> temp = new List<Genre>(); bool found = false; foreach (var gen in item.Genres.ToList()) { found = false; foreach (var item2 in mCon.Genres.ToList()) { if (gen.Id == item2.Id) { temp.Add(item2); found = true; } } if (!found) temp.Add(gen); } item.Genres = temp; } item = mCon.Movies.Add(item); mCon.SaveChanges(); } return item; }
public Customer GetCustomerByLoginUsername(string item) { using (Context mCon = new Context()) { if (mCon.Login.Where(x => x.Username.Equals(item)).FirstOrDefault() != null) return mCon.Login.Include("Customer").FirstOrDefault(x => x.Username.Equals(item)).Customer; return null; } }
public IEnumerable<Genre> GetGenreByMovie(Movie mov) { if (mov == null) throw new ArgumentNullException("Movie can not be null"); using (Context mCon = new Context()) { return mCon.Movies.Include("Genres").FirstOrDefault(x => x.Id == mov.Id).Genres.ToList(); } }
public IEnumerable<Order> GetOrdersByCustomer(Customer item) { if (item == null) throw new ArgumentNullException("Customer can not be null"); using (Context mCon = new Context()) { return mCon.Orders.Include("Customer").Include("OrderMovie").Where(x => x.Customer.Id == item.Id).ToList(); } }
public void Remove(int id) { using (Context mCon = new Context()) { OrderMovie ord = mCon.OrderMovie.Where(x => x.Id == id).FirstOrDefault(); mCon.OrderMovie.Remove(ord); mCon.SaveChanges(); } }
public void Genre_added_on_call_test() { Genre temp = new Genre() { Name = "test" }; Facade facade = new Facade(); temp = facade.GetGenreRepo().Add(temp); Context context = new Context(); Assert.IsNotNull(context.Genres.FirstOrDefault(x=> x.Id == temp.Id)); Assert.AreNotEqual(temp.Id, 0); }
public void Movie_added_on_call_test() { Movie temp = new Movie() { Name = "test", Price = 120d, TrailerURL = "test" }; Facade facade = new Facade(); temp = facade.GetMovieRepo().Add(temp); Context context = new Context(); Assert.IsNotNull(context.Movies.FirstOrDefault(x=>x.Id == temp.Id)); Assert.AreNotEqual(temp.Id, 0); }
public void Remove(string username) { Login temp = Get(username); if (temp == null) throw new ArgumentNullException("Login is null"); using (Context mCon = new Context()) { mCon.Login.Attach(temp); mCon.Login.Remove(temp); mCon.SaveChanges(); } }
public Login Add(Login item) { if (item == null) throw new ArgumentNullException("Login cant be null"); using (Context mCon = new Context()) { item.Customer = mCon.Customers.FirstOrDefault(x => x.Id == item.Customer.Id); item = mCon.Login.Add(item); mCon.SaveChanges(); } return item; }
public void Remove(int id) { Order temp = Get(id); if (temp == null) throw new ArgumentNullException("Order is null"); using (Context mCon = new Context()) { mCon.Orders.Attach(temp); mCon.Orders.Remove(temp); mCon.SaveChanges(); } }
public bool Update(Genre item) { if (item == null) throw new ArgumentNullException("Genre is null"); if (Get(item.Id) == null) return false; using (Context mCon = new Context()) { mCon.Entry(item).State = EntityState.Modified; mCon.SaveChanges(); } return true; }
public Genre Add(Genre item) { if (item == null) throw new ArgumentNullException("Genre is null"); if (item.Name == null) throw new ArgumentException("FirstName can not be null"); using (Context mCon = new Context()) { item = mCon.Genres.Add(item); mCon.SaveChanges(); } return item; }
public OrderMovie Add(OrderMovie item) { if (item == null) throw new ArgumentNullException("Ordermovie can not be null"); using (Context mCon = new Context()) { item.Movie = mCon.Movies.Where(x => x.Id == item.Movie.Id).FirstOrDefault(); item.Order = mCon.Orders.Where(x => x.Id == item.Order.Id).FirstOrDefault(); item = mCon.OrderMovie.Add(item); mCon.SaveChanges(); } return item; }
public bool Update(OrderMovie item) { if (item == null) throw new ArgumentNullException("OrderMovie is null"); if (Get(item.Id) == null) return false; using (Context mCon = new Context()) { OrderMovie temp = mCon.OrderMovie.FirstOrDefault(x => x.Id == item.Id); temp.Movie = item.Movie; temp.Order = item.Order; mCon.SaveChanges(); } return true; }
public IEnumerable<Movie> GetMoviesByOrder(Order item) { if (item == null) throw new ArgumentNullException("Order can not be null"); using (Context mCon = new Context()) { List<OrderMovie> oms = mCon.OrderMovie.Include("Movie.Genres").Include("Order").Where(x => x.Order.Id == item.Id).ToList(); List<Movie> movies = new List<Movie>(); foreach (var i in oms) { movies.Add(i.Movie); } return movies; } }
public IEnumerable<Movie> GetMovieByGenre(Genre item) { if (item == null) throw new ArgumentNullException("Genre is null"); using (Context mCon = new Context()) { List<Movie> temp = new List<Movie>(); foreach (var genre in mCon.Genres.ToList()) { if (genre.Id == item.Id) temp = item.Movies; } return temp; } }
public bool Update(Login item) { if (item == null) throw new ArgumentNullException("Login is null"); if (Get(item.Username) == null) return false; using (Context mCon = new Context()) { Login temp = mCon.Login.FirstOrDefault(x => x.Username == item.Username); temp.Password = item.Password; temp.Customer = item.Customer; mCon.SaveChanges(); } return true; }
public Order Add(Order item) { if (item == null) throw new ArgumentNullException("Order is null"); if (item.Customer == null) throw new ArgumentException("Customer can not be null"); using (Context mCon = new Context()) { if (mCon.Customers.FirstOrDefault(x => x.Id == item.Customer.Id) != null) item.Customer = mCon.Customers.FirstOrDefault(x => x.Id == item.Customer.Id); item = mCon.Orders.Add(item); mCon.SaveChanges(); } return item; }