private static void CreateMovie() // Create a new record.
{
Console.WriteLine("");
Console.WriteLine("Type the following data to create the movie file:");
Console.WriteLine("");
Console.ForegroundColor = ConsoleColor.Yellow;
using (var context = new RDBContext())
{
var newMovie = new Tmovie();
Console.Write("Title: ");
newMovie.Title = Thread.CurrentThread.CurrentCulture.TextInfo.ToTitleCase(Console.ReadLine().Trim());
Console.Write("Year: ");
newMovie.Year = int.Parse(Console.ReadLine().Trim());
var existingMovie = context.Tmovie.Where(x => x.Title.ToLower() == newMovie.Title.ToLower()).FirstOrDefault();
Console.WriteLine("");
if (existingMovie == null)
{
context.Tmovie.Add(newMovie);
var result = context.SaveChanges();
if (result == 1)
{
Console.ForegroundColor = ConsoleColor.Green;
Console.WriteLine("The movie was created succesfully.");
Console.ForegroundColor = ConsoleColor.Gray;
}
else
{
Console.ForegroundColor = ConsoleColor.Red;
Console.WriteLine("Error, the movie wasn't created.");
Console.ForegroundColor = ConsoleColor.Gray;
}
}
else
{
Console.ForegroundColor = ConsoleColor.Red;
Console.WriteLine("Error, already existed a movie with the same name.");
Console.ForegroundColor = ConsoleColor.Gray;
}
}
Console.WriteLine("");
Console.Write("Type any key to continue...");
Console.ReadKey();
Console.Clear();
ShowMenu();
}
private static void PickMovie()
{
using (var context = new RDBContext())
{
var random = new Random();
int totalMovie = context.Tmovie.Where(x => x.Pick == false).ToList().Count();
int randomNumber = random.Next(0, totalMovie);
Console.WriteLine("");
Console.WriteLine("");
Console.Write("The movie picked was: ");
var moviePicked = context.Tmovie.Where(x => x.Pick == false).Skip(randomNumber - 1).Take(1).FirstOrDefault();
Console.ForegroundColor = ConsoleColor.Yellow;
Console.WriteLine("ID: " + moviePicked.Idmovie + ". Title: " + moviePicked.Title + ". Year: " + moviePicked.Year + ".");
Console.ForegroundColor = ConsoleColor.Gray;
Console.WriteLine("");
moviePicked.Pick = true;
moviePicked.PickDate = DateTime.Now;
context.Tmovie.Update(moviePicked);
var result = context.SaveChanges();
if (result == 1)
{
Console.ForegroundColor = ConsoleColor.Green;
Console.WriteLine("The movie was updated succesfully.");
Console.ForegroundColor = ConsoleColor.Gray;
}
else
{
Console.ForegroundColor = ConsoleColor.Red;
Console.WriteLine("Error, the movie wasn't updated.");
Console.ForegroundColor = ConsoleColor.Gray;
}
Console.WriteLine("");
Console.Write("Type any key to continue...");
Console.ReadKey();
Console.Clear();
ShowMenu();
}
}
private static void DeleteMovie()
{
Console.WriteLine("");
Console.Write("Type a id movie that you want to delete: ");
int idMovie = int.Parse(Console.ReadLine());
Console.WriteLine("");
using (var context = new RDBContext())
{
var deleteMovie = context.Tmovie.Where(x => x.Idmovie == idMovie).FirstOrDefault();
if (deleteMovie != null)
{
Console.Write("Do you want to delete ");
Console.ForegroundColor = ConsoleColor.Yellow;
Console.Write(deleteMovie.Title);
Console.ForegroundColor = ConsoleColor.Gray;
Console.WriteLine("?");
Console.WriteLine("");
char deleteOption = '\0';
bool optionToggle = true;
do
{
Console.Write("Type an option (S/N): ");
deleteOption = Console.ReadKey().KeyChar;
if (deleteOption == 's' || deleteOption == 'S' || deleteOption == 'n' || deleteOption == 'N')
{
optionToggle = false;
}
} while (optionToggle);
if (deleteOption == 's' || deleteOption == 'S')
{
Console.WriteLine("");
context.Tmovie.Remove(deleteMovie);
var result = context.SaveChanges();
if (result == 1)
{
Console.ForegroundColor = ConsoleColor.Green;
Console.WriteLine("The movie was deleted succesfully.");
Console.ForegroundColor = ConsoleColor.Gray;
}
else
{
Console.ForegroundColor = ConsoleColor.Red;
Console.WriteLine("Error, the movie wasn't deleted.");
Console.ForegroundColor = ConsoleColor.Gray;
}
}
}
else
{
Console.ForegroundColor = ConsoleColor.Red;
Console.WriteLine("It doesn't exist any movie with the id typed.");
Console.ForegroundColor = ConsoleColor.Gray;
}
Console.WriteLine("");
Console.Write("Type any key to continue...");
Console.ReadKey();
Console.Clear();
ShowMenu();
}
}
private static void UpdateMenu() // Update a existing record.
{
Console.WriteLine("");
Console.Write("Type a id movie that you want to update: ");
int idMovie = int.Parse(Console.ReadLine());
Console.WriteLine("");
using (var context = new RDBContext())
{
var updateMovie = context.Tmovie.Where(x => x.Idmovie == idMovie).FirstOrDefault();
if (updateMovie != null)
{
Console.ForegroundColor = ConsoleColor.Yellow;
Console.WriteLine("1.Title: " + updateMovie.Title);
Console.WriteLine("2.Year: " + updateMovie.Year);
Console.ForegroundColor = ConsoleColor.Gray;
Console.WriteLine("");
Console.Write("What data do you want to update? ");
int dataOption = int.Parse(Console.ReadLine());
Console.WriteLine("");
switch (dataOption)
{
case 1:
do
{
Console.Write("Type a new Title: ");
updateMovie.Title = Thread.CurrentThread.CurrentCulture.TextInfo.ToTitleCase(Console.ReadLine()).Trim();
} while (updateMovie.Title == "");
break;
case 2:
do
{
Console.Write("Type a new Year: ");
updateMovie.Title = Thread.CurrentThread.CurrentCulture.TextInfo.ToTitleCase(Console.ReadLine()).Trim();
} while (updateMovie.Title == "");
break;
default:
break;
}
var existingMovie = context.Tmovie.Where(x => x.Title.ToLower() == updateMovie.Title.ToLower()).FirstOrDefault();
Console.WriteLine("");
if (existingMovie == null)
{
context.Tmovie.Update(updateMovie);
var result = context.SaveChanges();
if (result == 1)
{
Console.ForegroundColor = ConsoleColor.Green;
Console.WriteLine("The movie was updated succesfully.");
Console.ForegroundColor = ConsoleColor.Gray;
}
else
{
Console.ForegroundColor = ConsoleColor.Red;
Console.WriteLine("Error, the movie wasn't updated.");
Console.ForegroundColor = ConsoleColor.Gray;
}
}
else
{
Console.ForegroundColor = ConsoleColor.Red;
Console.WriteLine("Error, already existed a movie with the same name.");
Console.ForegroundColor = ConsoleColor.Gray;
}
}
else
{
Console.ForegroundColor = ConsoleColor.Red;
Console.WriteLine("It doesn't exist any movie with the id typed.");
Console.ForegroundColor = ConsoleColor.Gray;
}
}
Console.WriteLine("");
Console.Write("Type any key to continue...");
Console.ReadKey();
Console.Clear();
ShowMenu();
}
private static void ReadMovie() // List all records registered or picked.
{
Console.WriteLine("");
Console.WriteLine("1. All.");
Console.WriteLine("2. Picked.");
Console.WriteLine("3. Exit.");
Console.WriteLine("");
int optionMenu = -1;
bool validateMenu = true;
while (validateMenu)
{
Console.Write("Type an option: ");
while (!int.TryParse(Console.ReadLine(), out optionMenu))
{
Console.Write("This is not valid input. Please enter an integer value: ");
}
if (optionMenu >= 1 && optionMenu <= 3)
{
validateMenu = false;
}
else
{
Console.Write("Please enter an integer value between 1-3: ");
validateMenu = true;
}
}
Console.WriteLine("");
switch (optionMenu)
{
case 1:
using (var context = new RDBContext())
{
var listMovie = context.Tmovie.ToList();
if (listMovie != null)
{
Console.ForegroundColor = ConsoleColor.Yellow;
foreach (var movie in listMovie)
{
Console.WriteLine("ID: " + movie.Idmovie + ". Title: " + movie.Title + ". Year: " + movie.Year + ".");
}
Console.ForegroundColor = ConsoleColor.Gray;
}
else
{
Console.WriteLine("");
Console.WriteLine("It doesn't exists movies to read.");
}
}
break;
case 2:
using (var context = new RDBContext())
{
var listMovie = context.Tmovie.Where(x => x.Pick == true).OrderBy(x => x.PickDate).ToList();
int totalPicked = context.Tmovie.Where(x => x.Pick == true).Count();
if (listMovie != null)
{
Console.ForegroundColor = ConsoleColor.Yellow;
foreach (var movie in listMovie)
{
Console.WriteLine("ID: " + movie.Idmovie + ". Title: " + movie.Title + ". Year: " + movie.Year + ".");
}
Console.ForegroundColor = ConsoleColor.Gray;
Console.WriteLine("");
Console.WriteLine("Total movie picked: " + totalPicked + ".");
}
else
{
Console.WriteLine("");
Console.WriteLine("It doesn't exists movies to read.");
}
}
break;
case 3:
ShowMenu();
break;
default:
break;
}
Console.WriteLine("");
Console.Write("Type any key to continue...");
Console.ReadKey();
Console.Clear();
ShowMenu();
}
public HomeController(RDBContext context, ILogger <HomeController> logger)
{
_context = context;
_logger = logger;
}
