public List <Movie> SearchMovie(string search)
{
using (var ctx = new MyMediaEntities())
{
var movies = ctx.Movies1.Where(x => x.DirectorName.Contains(search)).ToList();
return(movies);
}
}
public void AddMoviesToRegister()
{
using (var ctx = new MyMediaEntities())
{
var movie = new Movie();
movie.DirectorName = Console.ReadLine();
movie.MovieName = Console.ReadLine();
ctx.Movies1.Add(movie);
}
}
public List <Movie> FindAMovie(string search)
{
var convert = int.Parse(search);
using (var ctx = new MyMediaEntities())
{
var movies = ctx.Movies1.Where(x => x.genreID == convert).ToList();
return(movies);
}
}
public string UpdateMovieAgain(Movie movie)
{
string message = string.Empty;
using (var ctx = new MyMediaEntities())
{
ctx.Entry(movie).State = EntityState.Modified;
ctx.SaveChanges();
message = "Author was updated.";
}
return(message);
}
public void RemoveCustomer()
{
using (var ctx = new MyMediaEntities())
{
Console.Write("Choose ID for Customer to remove:");
var removeCustomer = new Customer {
CustomerID = int.Parse(Console.ReadLine())
};
ctx.Customers.Attach(removeCustomer);
ctx.Customers.Remove(removeCustomer);
ctx.SaveChanges();
}
}
public void RemoveMovie()
{
using (var ctx = new MyMediaEntities())
{
Console.Write("Choose ID for Movie to remove:");
var removeMovie = new Movie {
MovieId = int.Parse(Console.ReadLine())
};
ctx.Movies1.Attach(removeMovie);
ctx.Movies1.Remove(removeMovie);
ctx.SaveChanges();
}
}
public void AddRent()
{
using (var ctx = new MyMediaEntities())
{
RentedMovie newRent = new RentedMovie();
Console.Write("Enter Customer ID: ");
newRent.CustomerID = int.Parse(Console.ReadLine());
Console.Write("Enter Movie ID: ");
newRent.MovieID = int.Parse(Console.ReadLine());
newRent.RentExpires = DateTime.Now.AddDays(7);
ctx.RentedMovies1.Add(newRent);
ctx.SaveChanges();
}
}
public void AddCustomer()
{
using (var ctx = new MyMediaEntities())
{
Customer newCustomer = new Customer();
Console.Write("Enter full Customer name: ");
newCustomer.CustomerName = Console.ReadLine();
Console.Write("Enter adress: ");
newCustomer.CustomerAdress = Console.ReadLine();
Console.Write("Enter e-mail: ");
newCustomer.CustomerPhone = Console.ReadLine();
ctx.Customers.Add(newCustomer);
ctx.SaveChanges();
}
}
public void PrintCustomers()
{
using (var ctx = new MyMediaEntities())
{
var query = from it in ctx.Customers
orderby it.CustomerID, it.CustomerName, it.CustomerAdress, it.CustomerPhone
select it;
foreach (Customer customer in query)
{
Console.WriteLine("{0} | {1} | {2} | {3} |", customer.CustomerID, customer.CustomerName, customer.CustomerAdress, customer.CustomerPhone);
}
Console.WriteLine();
Console.WriteLine("Action completed. Press any key to Continue...");
Console.ReadKey();
}
}
public void AddMovie()
{
using (var ctx = new MyMediaEntities())
{
Movie newMovie = new Movie();
Console.Write("Enter Title: ");
newMovie.MovieName = Console.ReadLine();
Console.Write("Enter Directors Name: ");
newMovie.DirectorName = Console.ReadLine();
Console.Write("Enter Release Date (YYYY/MM/DD): ");
newMovie.ReleaseDate = DateTime.Parse(Console.ReadLine());
Console.Write("Enter GenreID: ");
newMovie.genreID = int.Parse(Console.ReadLine());
ctx.Movies1.Add(newMovie);
ctx.SaveChanges();
}
}
public void PrintMovies()
{
using (var ctx = new MyMediaEntities())
{
var query = from it in ctx.Movies1
orderby it.MovieId, it.MovieName, it.DirectorName, it.ReleaseDate
select it;
foreach (Movie movie in query)
{
Console.WriteLine("{0} | {1} | {2} | {3}", movie.MovieId, movie.MovieName, movie.DirectorName, movie.ReleaseDate);
}
Console.WriteLine();
Console.WriteLine("Action completed. Press any key to Continue...");
Console.ReadKey();
}
}
