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();
}
}