public List <Categoryes> SelectCategory() { using (db = new DbContextDrowDataBase()) { return(db.Categoryes.ToList()); } }
public void InsertMovie(Movies newMovies) { using (db = new DbContextDrowDataBase()) { db.Movies.Add(newMovies); db.SaveChanges(); } }
public void RemoveInvntory(int amout, int idMovie) { using (db = new DbContextDrowDataBase()) { Movies removeInvntory = db.Movies.FirstOrDefault(m => m.MoviesID.Equals(idMovie)); removeInvntory.Inventory -= amout; } }
public void AddCustomer(Customer creatNewCustomer) { using (db = new DbContextDrowDataBase()) { db.Customers.Add(creatNewCustomer); db.SaveChanges(); } }
public Customer SearchCustomer(string userName, string password) { using (db = new DbContextDrowDataBase()) { Customer customer = db.Customers.FirstOrDefault(m => m.UserName.Equals(userName) && (m.Pasword.Equals(password))); return(customer); } }
public List <Movies> SelectMoviesBest() { using (db = new DbContextDrowDataBase()) { db = new DbContextDrowDataBase(); List <Movies> best = db.Movies.OrderByDescending(m => m.Rating).Take(3).ToList(); return(best); } }
public Customer CheckCustomer(string email, string phone) { Customer checkCustomer; using (db = new DbContextDrowDataBase()) { checkCustomer = db.Customers.FirstOrDefault(m => m.Email.Equals(email) && (m.Phone.Equals(phone))); } return(checkCustomer); }
public static List <string> SearchNameMovies(string prefixText, int count) { using (DbContextDrowDataBase db = new DbContextDrowDataBase()) { List <string> matches = (from m in db.Movies where m.NameMovies.StartsWith(prefixText) select m.NameMovies).ToList(); return(matches); } }
public Manger ChecksItIsManger(string userName, string password) { Manger checkerItIs; using (db = new DbContextDrowDataBase()) { checkerItIs = db.Manger.FirstOrDefault(m => m.UserName.Equals(userName) && (m.Password.Equals(password))); } return(checkerItIs); }
public void RatingAdd(int rating, int iDmovies) { using (db = new DbContextDrowDataBase()) { Movies addRatintToMovies = db.Movies.FirstOrDefault(x => x.MoviesID.Equals(iDmovies)); addRatintToMovies.Rating = addRatintToMovies.Rating + rating; addRatintToMovies.CuntRating += 1; db.Entry(addRatintToMovies).State = EntityState.Modified; db.SaveChanges(); } }
public Movies SelectOneMovie(string nameMovies) { Movies SearchOne; using (db = new DbContextDrowDataBase()) { SearchOne = (db.Movies.FirstOrDefault(m => m.NameMovies == nameMovies)); } return(SearchOne); }
public Movies SelectOneMovie(int MoviesID) { Movies SearchOne = new Movies(); if (MoviesID >= 0) { using (db = new DbContextDrowDataBase()) { SearchOne = (db.Movies.FirstOrDefault(m => m.MoviesID == MoviesID)); } } return(SearchOne); }
public void RemoveMovie(int id) { using (db = new DbContextDrowDataBase()) { Movies movies = db.Movies.FirstOrDefault(m => m.MoviesID == id); if (movies != null) { db.Movies.Remove(movies); db.SaveChanges(); } } }
public void UpDate(Movies UpDataMo) { using (db = new DbContextDrowDataBase()) { Movies movies = db.Movies.FirstOrDefault(m => m.MoviesID == UpDataMo.MoviesID); movies.NameMovies = UpDataMo.NameMovies; movies.Inventory = UpDataMo.Inventory; movies.Description = UpDataMo.Description; movies.MovieDirector = UpDataMo.MovieDirector; movies.CategoryID = UpDataMo.CategoryID; if (UpDataMo.ImageUrlOfMovies != null) { movies.ImageUrlOfMovies = UpDataMo.ImageUrlOfMovies; } db.Entry(movies).State = EntityState.Modified; db.SaveChanges(); } }